Query Metrics
24
Database Queries
6
Different statements
33.13 ms
Query time
1
Invalid entities
88
Managed entities
Queries
| #▲ | 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 |
|
| 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. |