Query Metrics
45
Database Queries
9
Different statements
4.33 ms
Query time
1
Invalid entities
91
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.20 ms |
SELECT t0.id AS id_1, t0.num_article_erp AS num_article_erp_2, t0.reference AS reference_3, t0.titre_web AS titre_web_4, t0.description_web AS description_web_5, t0.meta_titre AS meta_titre_6, t0.meta_mots_cles AS meta_mots_cles_7, t0.meta_description AS meta_description_8, t0.reference_oem AS reference_oem_9, t0.ref_marked AS ref_marked_10, t0.prix_vente AS prix_vente_11, t0.prix_achat AS prix_achat_12, t0.unite AS unite_13, t0.notes AS notes_14, t0.stock AS stock_15, t0.nombre_dans_lot AS nombre_dans_lot_16, t0.publie AS publie_17, t0.date_creation AS date_creation_18, t0.date_synchronisation AS date_synchronisation_19, t0.en_stock AS en_stock_20, t0.slug AS slug_21, t0.marque_id AS marque_id_22 FROM article t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"20260302113911625994-pignon-conique-z30-lp-1518-konpigz3001"
]
|
| 2 | 0.18 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:
[] |
| 3 | 0.13 ms |
SELECT t0.id AS id_1, t0.id_erp AS id_erp_2, t0.nom_fichier AS nom_fichier_3, t0.photo_par_defaut AS photo_par_defaut_4, t0.nom_fichier_card AS nom_fichier_card_5, t0.article_id AS article_id_6 FROM article_photo t0 WHERE t0.article_id = ? ORDER BY t0.photo_par_defaut DESC
Parameters:
[
8163
]
|
| 4 | 0.09 ms |
SELECT t0.id AS id_1, t0.id_marque_erp AS id_marque_erp_2, t0.nom AS nom_3, t0.code AS code_4 FROM marque t0 WHERE t0.id = ?
Parameters:
[
109
]
|
| 5 | 0.11 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:
[
8163
]
|
| 6 | 0.10 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:
[
32
]
|
| 7 | 0.16 ms |
SELECT t0.id AS id_1, t0.id_application_erp AS id_application_erp_2, t0.article_id AS article_id_3, t0.modele_id AS modele_id_4 FROM article_application t0 WHERE t0.article_id = ?
Parameters:
[
8163
]
|
| 8 | 0.10 ms |
SELECT t0.id AS id_1, t0.num_modele_erp AS num_modele_erp_2, t0.nom AS nom_3, t0.date_ajout AS date_ajout_4, t0.marque_vehicule_id AS marque_vehicule_id_5, t0.machine_categorie_id AS machine_categorie_id_6 FROM modele t0 WHERE t0.id = ?
Parameters:
[
3836
]
|
| 9 | 0.09 ms |
SELECT t0.id AS id_1, t0.num_marque_vehicule_erp AS num_marque_vehicule_erp_2, t0.nom AS nom_3, t0.debut_num_serie AS debut_num_serie_4 FROM marque_vehicule t0 WHERE t0.id = ?
Parameters:
[
6
]
|
| 10 | 0.09 ms |
SELECT t0.id AS id_1, t0.num_modele_erp AS num_modele_erp_2, t0.nom AS nom_3, t0.date_ajout AS date_ajout_4, t0.marque_vehicule_id AS marque_vehicule_id_5, t0.machine_categorie_id AS machine_categorie_id_6 FROM modele t0 WHERE t0.id = ?
Parameters:
[
4973
]
|
| 11 | 0.09 ms |
SELECT t0.id AS id_1, t0.num_modele_erp AS num_modele_erp_2, t0.nom AS nom_3, t0.date_ajout AS date_ajout_4, t0.marque_vehicule_id AS marque_vehicule_id_5, t0.machine_categorie_id AS machine_categorie_id_6 FROM modele t0 WHERE t0.id = ?
Parameters:
[
2537
]
|
| 12 | 0.10 ms |
SELECT t0.id AS id_1, t0.num_modele_erp AS num_modele_erp_2, t0.nom AS nom_3, t0.date_ajout AS date_ajout_4, t0.marque_vehicule_id AS marque_vehicule_id_5, t0.machine_categorie_id AS machine_categorie_id_6 FROM modele t0 WHERE t0.id = ?
Parameters:
[
5455
]
|
| 13 | 0.11 ms |
SELECT t0.id AS id_1, t0.num_modele_erp AS num_modele_erp_2, t0.nom AS nom_3, t0.date_ajout AS date_ajout_4, t0.marque_vehicule_id AS marque_vehicule_id_5, t0.machine_categorie_id AS machine_categorie_id_6 FROM modele t0 WHERE t0.id = ?
Parameters:
[
2928
]
|
| 14 | 0.11 ms |
SELECT t0.id AS id_1, t0.num_modele_erp AS num_modele_erp_2, t0.nom AS nom_3, t0.date_ajout AS date_ajout_4, t0.marque_vehicule_id AS marque_vehicule_id_5, t0.machine_categorie_id AS machine_categorie_id_6 FROM modele t0 WHERE t0.id = ?
Parameters:
[
399
]
|
| 15 | 0.09 ms |
SELECT t0.id AS id_1, t0.num_modele_erp AS num_modele_erp_2, t0.nom AS nom_3, t0.date_ajout AS date_ajout_4, t0.marque_vehicule_id AS marque_vehicule_id_5, t0.machine_categorie_id AS machine_categorie_id_6 FROM modele t0 WHERE t0.id = ?
Parameters:
[
963
]
|
| 16 | 0.08 ms |
SELECT t0.id AS id_1, t0.num_modele_erp AS num_modele_erp_2, t0.nom AS nom_3, t0.date_ajout AS date_ajout_4, t0.marque_vehicule_id AS marque_vehicule_id_5, t0.machine_categorie_id AS machine_categorie_id_6 FROM modele t0 WHERE t0.id = ?
Parameters:
[
608
]
|
| 17 | 0.07 ms |
SELECT t0.id AS id_1, t0.num_modele_erp AS num_modele_erp_2, t0.nom AS nom_3, t0.date_ajout AS date_ajout_4, t0.marque_vehicule_id AS marque_vehicule_id_5, t0.machine_categorie_id AS machine_categorie_id_6 FROM modele t0 WHERE t0.id = ?
Parameters:
[
1163
]
|
| 18 | 0.09 ms |
SELECT t0.id AS id_1, t0.num_modele_erp AS num_modele_erp_2, t0.nom AS nom_3, t0.date_ajout AS date_ajout_4, t0.marque_vehicule_id AS marque_vehicule_id_5, t0.machine_categorie_id AS machine_categorie_id_6 FROM modele t0 WHERE t0.id = ?
Parameters:
[
350
]
|
| 19 | 0.08 ms |
SELECT t0.id AS id_1, t0.num_modele_erp AS num_modele_erp_2, t0.nom AS nom_3, t0.date_ajout AS date_ajout_4, t0.marque_vehicule_id AS marque_vehicule_id_5, t0.machine_categorie_id AS machine_categorie_id_6 FROM modele t0 WHERE t0.id = ?
Parameters:
[
4606
]
|
| 20 | 0.08 ms |
SELECT t0.id AS id_1, t0.num_modele_erp AS num_modele_erp_2, t0.nom AS nom_3, t0.date_ajout AS date_ajout_4, t0.marque_vehicule_id AS marque_vehicule_id_5, t0.machine_categorie_id AS machine_categorie_id_6 FROM modele t0 WHERE t0.id = ?
Parameters:
[
800
]
|
| 21 | 0.08 ms |
SELECT t0.id AS id_1, t0.num_modele_erp AS num_modele_erp_2, t0.nom AS nom_3, t0.date_ajout AS date_ajout_4, t0.marque_vehicule_id AS marque_vehicule_id_5, t0.machine_categorie_id AS machine_categorie_id_6 FROM modele t0 WHERE t0.id = ?
Parameters:
[
1385
]
|
| 22 | 0.08 ms |
SELECT t0.id AS id_1, t0.num_modele_erp AS num_modele_erp_2, t0.nom AS nom_3, t0.date_ajout AS date_ajout_4, t0.marque_vehicule_id AS marque_vehicule_id_5, t0.machine_categorie_id AS machine_categorie_id_6 FROM modele t0 WHERE t0.id = ?
Parameters:
[
2923
]
|
| 23 | 0.07 ms |
SELECT t0.id AS id_1, t0.num_marque_vehicule_erp AS num_marque_vehicule_erp_2, t0.nom AS nom_3, t0.debut_num_serie AS debut_num_serie_4 FROM marque_vehicule t0 WHERE t0.id = ?
Parameters:
[
26
]
|
| 24 | 0.11 ms |
SELECT t0.id AS id_1, t0.num_modele_erp AS num_modele_erp_2, t0.nom AS nom_3, t0.date_ajout AS date_ajout_4, t0.marque_vehicule_id AS marque_vehicule_id_5, t0.machine_categorie_id AS machine_categorie_id_6 FROM modele t0 WHERE t0.id = ?
Parameters:
[
5182
]
|
| 25 | 0.08 ms |
SELECT t0.id AS id_1, t0.num_modele_erp AS num_modele_erp_2, t0.nom AS nom_3, t0.date_ajout AS date_ajout_4, t0.marque_vehicule_id AS marque_vehicule_id_5, t0.machine_categorie_id AS machine_categorie_id_6 FROM modele t0 WHERE t0.id = ?
Parameters:
[
5184
]
|
| 26 | 0.08 ms |
SELECT t0.id AS id_1, t0.num_modele_erp AS num_modele_erp_2, t0.nom AS nom_3, t0.date_ajout AS date_ajout_4, t0.marque_vehicule_id AS marque_vehicule_id_5, t0.machine_categorie_id AS machine_categorie_id_6 FROM modele t0 WHERE t0.id = ?
Parameters:
[
3347
]
|
| 27 | 0.08 ms |
SELECT t0.id AS id_1, t0.num_modele_erp AS num_modele_erp_2, t0.nom AS nom_3, t0.date_ajout AS date_ajout_4, t0.marque_vehicule_id AS marque_vehicule_id_5, t0.machine_categorie_id AS machine_categorie_id_6 FROM modele t0 WHERE t0.id = ?
Parameters:
[
3664
]
|
| 28 | 0.09 ms |
SELECT t0.id AS id_1, t0.num_modele_erp AS num_modele_erp_2, t0.nom AS nom_3, t0.date_ajout AS date_ajout_4, t0.marque_vehicule_id AS marque_vehicule_id_5, t0.machine_categorie_id AS machine_categorie_id_6 FROM modele t0 WHERE t0.id = ?
Parameters:
[
4890
]
|
| 29 | 0.08 ms |
SELECT t0.id AS id_1, t0.num_modele_erp AS num_modele_erp_2, t0.nom AS nom_3, t0.date_ajout AS date_ajout_4, t0.marque_vehicule_id AS marque_vehicule_id_5, t0.machine_categorie_id AS machine_categorie_id_6 FROM modele t0 WHERE t0.id = ?
Parameters:
[
413
]
|
| 30 | 0.08 ms |
SELECT t0.id AS id_1, t0.num_modele_erp AS num_modele_erp_2, t0.nom AS nom_3, t0.date_ajout AS date_ajout_4, t0.marque_vehicule_id AS marque_vehicule_id_5, t0.machine_categorie_id AS machine_categorie_id_6 FROM modele t0 WHERE t0.id = ?
Parameters:
[
5183
]
|
| 31 | 0.08 ms |
SELECT t0.id AS id_1, t0.num_modele_erp AS num_modele_erp_2, t0.nom AS nom_3, t0.date_ajout AS date_ajout_4, t0.marque_vehicule_id AS marque_vehicule_id_5, t0.machine_categorie_id AS machine_categorie_id_6 FROM modele t0 WHERE t0.id = ?
Parameters:
[
609
]
|
| 32 | 0.09 ms |
SELECT t0.id AS id_1, t0.num_modele_erp AS num_modele_erp_2, t0.nom AS nom_3, t0.date_ajout AS date_ajout_4, t0.marque_vehicule_id AS marque_vehicule_id_5, t0.machine_categorie_id AS machine_categorie_id_6 FROM modele t0 WHERE t0.id = ?
Parameters:
[
5024
]
|
| 33 | 0.08 ms |
SELECT t0.id AS id_1, t0.num_modele_erp AS num_modele_erp_2, t0.nom AS nom_3, t0.date_ajout AS date_ajout_4, t0.marque_vehicule_id AS marque_vehicule_id_5, t0.machine_categorie_id AS machine_categorie_id_6 FROM modele t0 WHERE t0.id = ?
Parameters:
[
799
]
|
| 34 | 0.08 ms |
SELECT t0.id AS id_1, t0.num_modele_erp AS num_modele_erp_2, t0.nom AS nom_3, t0.date_ajout AS date_ajout_4, t0.marque_vehicule_id AS marque_vehicule_id_5, t0.machine_categorie_id AS machine_categorie_id_6 FROM modele t0 WHERE t0.id = ?
Parameters:
[
798
]
|
| 35 | 0.12 ms |
SELECT t0.id AS id_1, t0.num_modele_erp AS num_modele_erp_2, t0.nom AS nom_3, t0.date_ajout AS date_ajout_4, t0.marque_vehicule_id AS marque_vehicule_id_5, t0.machine_categorie_id AS machine_categorie_id_6 FROM modele t0 WHERE t0.id = ?
Parameters:
[
4971
]
|
| 36 | 0.09 ms |
SELECT t0.id AS id_1, t0.num_modele_erp AS num_modele_erp_2, t0.nom AS nom_3, t0.date_ajout AS date_ajout_4, t0.marque_vehicule_id AS marque_vehicule_id_5, t0.machine_categorie_id AS machine_categorie_id_6 FROM modele t0 WHERE t0.id = ?
Parameters:
[
3737
]
|
| 37 | 0.11 ms |
SELECT t0.id AS id_1, t0.num_modele_erp AS num_modele_erp_2, t0.nom AS nom_3, t0.date_ajout AS date_ajout_4, t0.marque_vehicule_id AS marque_vehicule_id_5, t0.machine_categorie_id AS machine_categorie_id_6 FROM modele t0 WHERE t0.id = ?
Parameters:
[
570
]
|
| 38 | 0.08 ms |
SELECT t0.id AS id_1, t0.num_modele_erp AS num_modele_erp_2, t0.nom AS nom_3, t0.date_ajout AS date_ajout_4, t0.marque_vehicule_id AS marque_vehicule_id_5, t0.machine_categorie_id AS machine_categorie_id_6 FROM modele t0 WHERE t0.id = ?
Parameters:
[
465
]
|
| 39 | 0.08 ms |
SELECT t0.id AS id_1, t0.num_modele_erp AS num_modele_erp_2, t0.nom AS nom_3, t0.date_ajout AS date_ajout_4, t0.marque_vehicule_id AS marque_vehicule_id_5, t0.machine_categorie_id AS machine_categorie_id_6 FROM modele t0 WHERE t0.id = ?
Parameters:
[
796
]
|
| 40 | 0.08 ms |
SELECT t0.id AS id_1, t0.num_modele_erp AS num_modele_erp_2, t0.nom AS nom_3, t0.date_ajout AS date_ajout_4, t0.marque_vehicule_id AS marque_vehicule_id_5, t0.machine_categorie_id AS machine_categorie_id_6 FROM modele t0 WHERE t0.id = ?
Parameters:
[
237
]
|
| 41 | 0.07 ms |
SELECT t0.id AS id_1, t0.num_modele_erp AS num_modele_erp_2, t0.nom AS nom_3, t0.date_ajout AS date_ajout_4, t0.marque_vehicule_id AS marque_vehicule_id_5, t0.machine_categorie_id AS machine_categorie_id_6 FROM modele t0 WHERE t0.id = ?
Parameters:
[
5198
]
|
| 42 | 0.07 ms |
SELECT t0.id AS id_1, t0.num_modele_erp AS num_modele_erp_2, t0.nom AS nom_3, t0.date_ajout AS date_ajout_4, t0.marque_vehicule_id AS marque_vehicule_id_5, t0.machine_categorie_id AS machine_categorie_id_6 FROM modele t0 WHERE t0.id = ?
Parameters:
[
1448
]
|
| 43 | 0.11 ms |
SELECT t0.id AS id_1, t0.num_modele_erp AS num_modele_erp_2, t0.nom AS nom_3, t0.date_ajout AS date_ajout_4, t0.marque_vehicule_id AS marque_vehicule_id_5, t0.machine_categorie_id AS machine_categorie_id_6 FROM modele t0 WHERE t0.id = ?
Parameters:
[
1455
]
|
| 44 | 0.08 ms |
SELECT t0.id AS id_1, t0.num_modele_erp AS num_modele_erp_2, t0.nom AS nom_3, t0.date_ajout AS date_ajout_4, t0.marque_vehicule_id AS marque_vehicule_id_5, t0.machine_categorie_id AS machine_categorie_id_6 FROM modele t0 WHERE t0.id = ?
Parameters:
[
732
]
|
| 45 | 0.08 ms |
SELECT t0.id AS id_1, t0.num_modele_erp AS num_modele_erp_2, t0.nom AS nom_3, t0.date_ajout AS date_ajout_4, t0.marque_vehicule_id AS marque_vehicule_id_5, t0.machine_categorie_id AS machine_categorie_id_6 FROM modele t0 WHERE t0.id = ?
Parameters:
[
4773
]
|
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\ArticleApplication | 36 |
| App\Entity\Modele | 36 |
| App\Entity\MachineCategorie | 13 |
| App\Entity\MarqueVehicule | 2 |
| App\Entity\Article | 1 |
| App\Entity\Marque | 1 |
| App\Entity\GroupeFamilleArticleArticle | 1 |
| App\Entity\GroupeFamilleArticle | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Article |
|
| App\Entity\Marque | No errors. |
| App\Entity\ArticlePhoto | No errors. |
| App\Entity\GroupeFamilleArticleArticle | No errors. |
| App\Entity\ArticleApplication | No errors. |
| App\Entity\MachineCategorie | No errors. |
| App\Entity\GroupeFamilleArticle | No errors. |
| App\Entity\Modele | No errors. |
| App\Entity\MarqueVehicule | No errors. |