GET https://www.v3.agriland.shop/

Query Metrics

24 Database Queries
6 Different statements
33.13 ms Query time
1 Invalid entities
88 Managed entities

Queries

Group similar statements

# Time Info
1 0.20 ms
SELECT s0_.id AS id_0, s0_.titre AS titre_1, s0_.sous_titre AS sous_titre_2, s0_.texte_bouton AS texte_bouton_3, s0_.lien_bouton AS lien_bouton_4, s0_.image AS image_5, s0_.couleur_fond AS couleur_fond_6, s0_.ordre AS ordre_7, s0_.actif AS actif_8 FROM slider_banniere s0_ WHERE s0_.actif = 1 ORDER BY s0_.ordre ASC
Parameters:
[]
2 29.94 ms
SELECT a0_.id AS id_0, a0_.num_article_erp AS num_article_erp_1, a0_.reference AS reference_2, a0_.titre_web AS titre_web_3, a0_.description_web AS description_web_4, a0_.meta_titre AS meta_titre_5, a0_.meta_mots_cles AS meta_mots_cles_6, a0_.meta_description AS meta_description_7, a0_.reference_oem AS reference_oem_8, a0_.ref_marked AS ref_marked_9, a0_.prix_vente AS prix_vente_10, a0_.prix_achat AS prix_achat_11, a0_.unite AS unite_12, a0_.notes AS notes_13, a0_.stock AS stock_14, a0_.nombre_dans_lot AS nombre_dans_lot_15, a0_.publie AS publie_16, a0_.date_creation AS date_creation_17, a0_.date_synchronisation AS date_synchronisation_18, a0_.en_stock AS en_stock_19, a0_.slug AS slug_20, a1_.id AS id_21, a1_.id_erp AS id_erp_22, a1_.nom_fichier AS nom_fichier_23, a1_.photo_par_defaut AS photo_par_defaut_24, a1_.nom_fichier_card AS nom_fichier_card_25, m2_.id AS id_26, m2_.id_marque_erp AS id_marque_erp_27, m2_.nom AS nom_28, m2_.code AS code_29, a0_.marque_id AS marque_id_30, a1_.article_id AS article_id_31 FROM article a0_ LEFT JOIN article_photo a1_ ON a0_.id = a1_.article_id LEFT JOIN marque m2_ ON a0_.marque_id = m2_.id WHERE a0_.publie = 1 ORDER BY a0_.date_synchronisation DESC, a1_.photo_par_defaut DESC LIMIT 8
Parameters:
[]
3 0.20 ms
SELECT t0.id AS id_1, t0.id_machine_categorie_erp AS id_machine_categorie_erp_2, t0.nom AS nom_3, t0.slug AS slug_4, t0.parent_id AS parent_id_5 FROM machine_categorie t0 WHERE t0.parent_id IS NULL ORDER BY t0.nom ASC
Parameters:
[]
4 0.19 ms
SELECT t0.id AS id_1, t0.id_machine_categorie_erp AS id_machine_categorie_erp_2, t0.nom AS nom_3, t0.slug AS slug_4, t0.parent_id AS parent_id_5 FROM machine_categorie t0 WHERE t0.parent_id IS NULL ORDER BY t0.nom ASC
Parameters:
[]
5 0.12 ms
SELECT t0.id AS id_1, t0.id_machine_categorie_erp AS id_machine_categorie_erp_2, t0.nom AS nom_3, t0.slug AS slug_4, t0.parent_id AS parent_id_5 FROM machine_categorie t0 WHERE t0.parent_id = ?
Parameters:
[
  47
]
6 0.13 ms
SELECT t0.id AS id_1, t0.id_machine_categorie_erp AS id_machine_categorie_erp_2, t0.nom AS nom_3, t0.slug AS slug_4, t0.parent_id AS parent_id_5 FROM machine_categorie t0 WHERE t0.parent_id = ?
Parameters:
[
  5
]
7 0.15 ms
SELECT t0.id AS id_1, t0.id_machine_categorie_erp AS id_machine_categorie_erp_2, t0.nom AS nom_3, t0.slug AS slug_4, t0.parent_id AS parent_id_5 FROM machine_categorie t0 WHERE t0.parent_id = ?
Parameters:
[
  1
]
8 0.13 ms
SELECT t0.id AS id_1, t0.id_machine_categorie_erp AS id_machine_categorie_erp_2, t0.nom AS nom_3, t0.slug AS slug_4, t0.parent_id AS parent_id_5 FROM machine_categorie t0 WHERE t0.parent_id = ?
Parameters:
[
  3
]
9 0.11 ms
SELECT t0.id AS id_1, t0.id_machine_categorie_erp AS id_machine_categorie_erp_2, t0.nom AS nom_3, t0.slug AS slug_4, t0.parent_id AS parent_id_5 FROM machine_categorie t0 WHERE t0.parent_id = ?
Parameters:
[
  51
]
10 0.11 ms
SELECT t0.id AS id_1, t0.id_machine_categorie_erp AS id_machine_categorie_erp_2, t0.nom AS nom_3, t0.slug AS slug_4, t0.parent_id AS parent_id_5 FROM machine_categorie t0 WHERE t0.parent_id = ?
Parameters:
[
  49
]
11 0.15 ms
SELECT t0.id AS id_1, t0.id_machine_categorie_erp AS id_machine_categorie_erp_2, t0.nom AS nom_3, t0.slug AS slug_4, t0.parent_id AS parent_id_5 FROM machine_categorie t0 WHERE t0.parent_id = ?
Parameters:
[
  48
]
12 0.12 ms
SELECT t0.id AS id_1, t0.id_machine_categorie_erp AS id_machine_categorie_erp_2, t0.nom AS nom_3, t0.slug AS slug_4, t0.parent_id AS parent_id_5 FROM machine_categorie t0 WHERE t0.parent_id = ?
Parameters:
[
  4
]
13 0.15 ms
SELECT t0.id AS id_1, t0.id_machine_categorie_erp AS id_machine_categorie_erp_2, t0.nom AS nom_3, t0.slug AS slug_4, t0.parent_id AS parent_id_5 FROM machine_categorie t0 WHERE t0.parent_id = ?
Parameters:
[
  2
]
14 0.13 ms
SELECT t0.id AS id_1, t0.id_machine_categorie_erp AS id_machine_categorie_erp_2, t0.nom AS nom_3, t0.slug AS slug_4, t0.parent_id AS parent_id_5 FROM machine_categorie t0 WHERE t0.parent_id = ?
Parameters:
[
  50
]
15 0.15 ms
SELECT t0.id AS id_1, t0.id_machine_categorie_erp AS id_machine_categorie_erp_2, t0.nom AS nom_3, t0.slug AS slug_4, t0.parent_id AS parent_id_5 FROM machine_categorie t0 WHERE t0.parent_id = ?
Parameters:
[
  46
]
16 0.12 ms
SELECT t0.id AS id_1, t0.famille_article_defaut AS famille_article_defaut_2, t0.article_id AS article_id_3, t0.groupe_famille_id AS groupe_famille_id_4, t0.machine_categorie_id AS machine_categorie_id_5 FROM groupe_famille_article_article t0 WHERE t0.article_id = ?
Parameters:
[
  8230
]
17 0.14 ms
SELECT t0.id AS id_1, t0.id_machine_categorie_erp AS id_machine_categorie_erp_2, t0.nom AS nom_3, t0.slug AS slug_4, t0.parent_id AS parent_id_5 FROM machine_categorie t0 WHERE t0.id = ?
Parameters:
[
  25
]
18 0.16 ms
SELECT t0.id AS id_1, t0.famille_article_defaut AS famille_article_defaut_2, t0.article_id AS article_id_3, t0.groupe_famille_id AS groupe_famille_id_4, t0.machine_categorie_id AS machine_categorie_id_5 FROM groupe_famille_article_article t0 WHERE t0.article_id = ?
Parameters:
[
  8229
]
19 0.12 ms
SELECT t0.id AS id_1, t0.famille_article_defaut AS famille_article_defaut_2, t0.article_id AS article_id_3, t0.groupe_famille_id AS groupe_famille_id_4, t0.machine_categorie_id AS machine_categorie_id_5 FROM groupe_famille_article_article t0 WHERE t0.article_id = ?
Parameters:
[
  8228
]
20 0.12 ms
SELECT t0.id AS id_1, t0.famille_article_defaut AS famille_article_defaut_2, t0.article_id AS article_id_3, t0.groupe_famille_id AS groupe_famille_id_4, t0.machine_categorie_id AS machine_categorie_id_5 FROM groupe_famille_article_article t0 WHERE t0.article_id = ?
Parameters:
[
  8227
]
21 0.12 ms
SELECT t0.id AS id_1, t0.famille_article_defaut AS famille_article_defaut_2, t0.article_id AS article_id_3, t0.groupe_famille_id AS groupe_famille_id_4, t0.machine_categorie_id AS machine_categorie_id_5 FROM groupe_famille_article_article t0 WHERE t0.article_id = ?
Parameters:
[
  8223
]
22 0.12 ms
SELECT t0.id AS id_1, t0.famille_article_defaut AS famille_article_defaut_2, t0.article_id AS article_id_3, t0.groupe_famille_id AS groupe_famille_id_4, t0.machine_categorie_id AS machine_categorie_id_5 FROM groupe_famille_article_article t0 WHERE t0.article_id = ?
Parameters:
[
  8224
]
23 0.14 ms
SELECT t0.id AS id_1, t0.famille_article_defaut AS famille_article_defaut_2, t0.article_id AS article_id_3, t0.groupe_famille_id AS groupe_famille_id_4, t0.machine_categorie_id AS machine_categorie_id_5 FROM groupe_famille_article_article t0 WHERE t0.article_id = ?
Parameters:
[
  8225
]
24 0.12 ms
SELECT t0.id AS id_1, t0.famille_article_defaut AS famille_article_defaut_2, t0.article_id AS article_id_3, t0.groupe_famille_id AS groupe_famille_id_4, t0.machine_categorie_id AS machine_categorie_id_5 FROM groupe_famille_article_article t0 WHERE t0.article_id = ?
Parameters:
[
  8226
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\MachineCategorie 67
App\Entity\Article 8
App\Entity\GroupeFamilleArticleArticle 8
App\Entity\GroupeFamilleArticle 3
App\Entity\Marque 2

Entities Mapping

Class Mapping errors
App\Entity\SliderBanniere No errors.
App\Entity\Article
  • The field App\Entity\Article#groupeFamilleArticleArticles is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\GroupeFamilleArticleArticle#article does not contain the required 'inversedBy="groupeFamilleArticleArticles"' attribute.
  • The field App\Entity\Article#articleApplications is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ArticleApplication#article does not contain the required 'inversedBy="articleApplications"' attribute.
App\Entity\ArticlePhoto No errors.
App\Entity\Marque No errors.
App\Entity\GroupeFamilleArticleArticle No errors.
App\Entity\ArticleApplication No errors.
App\Entity\MachineCategorie No errors.
App\Entity\GroupeFamilleArticle No errors.