GET https://v3.agriland.shop/

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
29.82 ms
(91.42%)
1
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:
[]
1.25 ms
(3.84%)
11
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
]
0.92 ms
(2.81%)
8
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
]
0.38 ms
(1.16%)
2
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:
[]
0.14 ms
(0.42%)
1
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:
[]
0.12 ms
(0.36%)
1
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
]

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.