Query Metrics
24
Database Queries
6
Different statements
33.13 ms
Query time
1
Invalid entities
88
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
29.94 ms (90.36%) |
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.45 ms (4.36%) |
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
]
|
|
1.01 ms (3.06%) |
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.39 ms (1.17%) |
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.20 ms (0.60%) |
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.14 ms (0.44%) |
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 |
|
| 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. |