Query Metrics
467
Database Queries
17
Different statements
342.98 ms
Query time
5
Invalid entities
Grouped Statements
hermes connection
| Time▼ | Count | Info |
|---|---|---|
|
117.36 ms (34.22%) |
1 |
SELECT t0.id AS id_1, t0.published_at AS published_at_2, t0.numero AS numero_3, t0.code_variante AS code_variante_4, t0.description1 AS description1_5, t0.description2 AS description2_6, t0.stock AS stock_7, t0.sales_unit1 AS sales_unit1_8, t0.sales_unit2 AS sales_unit2_9, t0.sales_unit3 AS sales_unit3_10, t0.code_ean AS code_ean_11, t0.quantite_sur_commande_vente AS quantite_sur_commande_vente_12, t0.prochaine_date_reception AS prochaine_date_reception_13, t0.code_barre AS code_barre_14, t0.antivol_requis AS antivol_requis_15, t0.disponible AS disponible_16, t0.flipbook AS flipbook_17, t0.reference AS reference_18, t0.compatible_marque AS compatible_marque_19, t0.modele_imprimante AS modele_imprimante_20, t0.produit AS produit_21, t0.nouveau AS nouveau_22, t0.promo AS promo_23, t0.exclusivite AS exclusivite_24, t0.designation AS designation_25, t0.picto_recyclage AS picto_recyclage_26, t0.description_courte AS description_courte_27, t0.caracteristiques AS caracteristiques_28, t0.correspondance_oem AS correspondance_oem_29, t0.coloris AS coloris_30, t0.capacite AS capacite_31, t0.capacite_oem AS capacite_oem_32, t0.contenu_emballage AS contenu_emballage_33, t0.conditionnement AS conditionnement_34, t0.dimensions_packaging AS dimensions_packaging_35, t0.pcb1 AS pcb1_36, t0.pcb2 AS pcb2_37, t0.garantie AS garantie_38, t0.picto_caracteristique AS picto_caracteristique_39, t0.photo1 AS photo1_40, t0.photo2 AS photo2_41, t0.photo3 AS photo3_42, t0.video AS video_43, t0.produits_similaires AS produits_similaires_44, t0.notice_utilisation AS notice_utilisation_45, t0.evolution_prix AS evolution_prix_46, t0.prix_achat AS prix_achat_47, t0.taxe_corepile AS taxe_corepile_48, t0.taxe_d3e AS taxe_d3e_49, t0.taxe_copie_france AS taxe_copie_france_50, t0.taxe_eco_participation_ht AS taxe_eco_participation_ht_51, t0.ppcg_pack AS ppcg_pack_52, t0.prix_achat_sans_d3e AS prix_achat_sans_d3e_53, t0.prix_achat_htpar10 AS prix_achat_htpar10_54, t0.prix_achat_htpar10taxe_copie_france_eco_taxe AS prix_achat_htpar10taxe_copie_france_eco_taxe_55, t0.prix_achat_htpar20 AS prix_achat_htpar20_56, t0.prix_achat_htpar20taxe_copie_france_eco_taxe AS prix_achat_htpar20taxe_copie_france_eco_taxe_57, t0.prix_achat_magasin_sans_d3e AS prix_achat_magasin_sans_d3e_58, t0.prix_achat_ht AS prix_achat_ht_59, t0.prix_vente_conseille AS prix_vente_conseille_60, t0.created_at AS created_at_61, t0.updated_at AS updated_at_62, t0.deleted_at AS deleted_at_63, t0.ordre AS ordre_64, t0.stock_promo AS stock_promo_65, t0.stock_promo_hermes AS stock_promo_hermes_66, t0.montant_promo_hermes AS montant_promo_hermes_67, t0.sales_unit1groupe_a AS sales_unit1groupe_a_68, t0.sales_unit2groupe_a AS sales_unit2groupe_a_69, t0.sales_unit1groupe_b AS sales_unit1groupe_b_70, t0.sales_unit2groupe_b AS sales_unit2groupe_b_71, t0.sales_unit1groupe_c AS sales_unit1groupe_c_72, t0.sales_unit2groupe_c AS sales_unit2groupe_c_73, t0.is_visible_ariane AS is_visible_ariane_74, t0.is_visible_hermes AS is_visible_hermes_75, t0.is_bon_plan_web_ariane AS is_bon_plan_web_ariane_76, t0.prix_promo_de_base AS prix_promo_de_base_77, t0.remise_promo AS remise_promo_78, t0.description_promo AS description_promo_79, t0.type_encre_id AS type_encre_id_80, t0.fiche_pdf_id AS fiche_pdf_id_81, t0.article_gamme_id AS article_gamme_id_82, t0.article_groupe_id AS article_groupe_id_83, t0.article_famille_id AS article_famille_id_84, t0.image_id AS image_id_85, t0.promo_box_id AS promo_box_id_86, t0.galerie_id AS galerie_id_87, t0.statut_id AS statut_id_88, t0.article_marque_id AS article_marque_id_89, t0.article_parent_id AS article_parent_id_90, t0.article_type_id AS article_type_id_91, t0.categorie_id AS categorie_id_92 FROM article t0
Parameters:
[] |
|
50.32 ms (14.67%) |
105 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.is_visible_ariane AS is_visible_ariane_4 FROM article_gamme t0 WHERE t0.nom = ? LIMIT 1
Parameters:
[
"ACCESSOIRE PLATINE"
]
|
|
47.58 ms (13.87%) |
101 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.is_visible_ariane AS is_visible_ariane_3 FROM article_famille t0 WHERE t0.nom = ? LIMIT 1
Parameters:
[
"AUDIO"
]
|
|
41.79 ms (12.18%) |
86 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5 FROM client_groupe t0 INNER JOIN lien_marque_client_groupe ON t0.id = lien_marque_client_groupe.article_gamme_id WHERE lien_marque_client_groupe.client_groupe_id = ?
Parameters:
[
1
]
|
|
41.44 ms (12.08%) |
86 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.is_visible_ariane AS is_visible_ariane_3, t0.is_visible_hermes AS is_visible_hermes_4, t0.is_prioritaire AS is_prioritaire_5, t0.image_id AS image_id_6 FROM article_marque t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
26.14 ms (7.62%) |
57 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5 FROM client_groupe t0 INNER JOIN lien_gamme_client_groupe ON t0.id = lien_gamme_client_groupe.article_gamme_id WHERE lien_gamme_client_groupe.client_groupe_id = ?
Parameters:
[
27
]
|
|
6.03 ms (1.76%) |
12 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5 FROM client_groupe t0 INNER JOIN lien_famille_client_groupe ON t0.id = lien_famille_client_groupe.article_famille_id WHERE lien_famille_client_groupe.client_groupe_id = ?
Parameters:
[
7
]
|
|
4.85 ms (1.42%) |
1 |
SELECT a0_.id AS id_0, a0_.published_at AS published_at_1, a0_.numero AS numero_2, a0_.code_variante AS code_variante_3, a0_.description1 AS description1_4, a0_.description2 AS description2_5, a0_.stock AS stock_6, a0_.sales_unit1 AS sales_unit1_7, a0_.sales_unit2 AS sales_unit2_8, a0_.sales_unit3 AS sales_unit3_9, a0_.code_ean AS code_ean_10, a0_.quantite_sur_commande_vente AS quantite_sur_commande_vente_11, a0_.prochaine_date_reception AS prochaine_date_reception_12, a0_.code_barre AS code_barre_13, a0_.antivol_requis AS antivol_requis_14, a0_.disponible AS disponible_15, a0_.flipbook AS flipbook_16, a0_.reference AS reference_17, a0_.compatible_marque AS compatible_marque_18, a0_.modele_imprimante AS modele_imprimante_19, a0_.produit AS produit_20, a0_.nouveau AS nouveau_21, a0_.promo AS promo_22, a0_.exclusivite AS exclusivite_23, a0_.designation AS designation_24, a0_.picto_recyclage AS picto_recyclage_25, a0_.description_courte AS description_courte_26, a0_.caracteristiques AS caracteristiques_27, a0_.correspondance_oem AS correspondance_oem_28, a0_.coloris AS coloris_29, a0_.capacite AS capacite_30, a0_.capacite_oem AS capacite_oem_31, a0_.contenu_emballage AS contenu_emballage_32, a0_.conditionnement AS conditionnement_33, a0_.dimensions_packaging AS dimensions_packaging_34, a0_.pcb1 AS pcb1_35, a0_.pcb2 AS pcb2_36, a0_.garantie AS garantie_37, a0_.picto_caracteristique AS picto_caracteristique_38, a0_.photo1 AS photo1_39, a0_.photo2 AS photo2_40, a0_.photo3 AS photo3_41, a0_.video AS video_42, a0_.produits_similaires AS produits_similaires_43, a0_.notice_utilisation AS notice_utilisation_44, a0_.evolution_prix AS evolution_prix_45, a0_.prix_achat AS prix_achat_46, a0_.taxe_corepile AS taxe_corepile_47, a0_.taxe_d3e AS taxe_d3e_48, a0_.taxe_copie_france AS taxe_copie_france_49, a0_.taxe_eco_participation_ht AS taxe_eco_participation_ht_50, a0_.ppcg_pack AS ppcg_pack_51, a0_.prix_achat_sans_d3e AS prix_achat_sans_d3e_52, a0_.prix_achat_htpar10 AS prix_achat_htpar10_53, a0_.prix_achat_htpar10taxe_copie_france_eco_taxe AS prix_achat_htpar10taxe_copie_france_eco_taxe_54, a0_.prix_achat_htpar20 AS prix_achat_htpar20_55, a0_.prix_achat_htpar20taxe_copie_france_eco_taxe AS prix_achat_htpar20taxe_copie_france_eco_taxe_56, a0_.prix_achat_magasin_sans_d3e AS prix_achat_magasin_sans_d3e_57, a0_.prix_achat_ht AS prix_achat_ht_58, a0_.prix_vente_conseille AS prix_vente_conseille_59, a0_.created_at AS created_at_60, a0_.updated_at AS updated_at_61, a0_.deleted_at AS deleted_at_62, a0_.ordre AS ordre_63, a0_.stock_promo AS stock_promo_64, a0_.stock_promo_hermes AS stock_promo_hermes_65, a0_.montant_promo_hermes AS montant_promo_hermes_66, a0_.sales_unit1groupe_a AS sales_unit1groupe_a_67, a0_.sales_unit2groupe_a AS sales_unit2groupe_a_68, a0_.sales_unit1groupe_b AS sales_unit1groupe_b_69, a0_.sales_unit2groupe_b AS sales_unit2groupe_b_70, a0_.sales_unit1groupe_c AS sales_unit1groupe_c_71, a0_.sales_unit2groupe_c AS sales_unit2groupe_c_72, a0_.is_visible_ariane AS is_visible_ariane_73, a0_.is_visible_hermes AS is_visible_hermes_74, a0_.is_bon_plan_web_ariane AS is_bon_plan_web_ariane_75, a0_.prix_promo_de_base AS prix_promo_de_base_76, a0_.remise_promo AS remise_promo_77, a0_.description_promo AS description_promo_78, a0_.type_encre_id AS type_encre_id_79, a0_.fiche_pdf_id AS fiche_pdf_id_80, a0_.article_gamme_id AS article_gamme_id_81, a0_.article_groupe_id AS article_groupe_id_82, a0_.article_famille_id AS article_famille_id_83, a0_.image_id AS image_id_84, a0_.promo_box_id AS promo_box_id_85, a0_.galerie_id AS galerie_id_86, a0_.statut_id AS statut_id_87, a0_.article_marque_id AS article_marque_id_88, a0_.article_parent_id AS article_parent_id_89, a0_.article_type_id AS article_type_id_90, a0_.categorie_id AS categorie_id_91 FROM article a0_ WHERE a0_.is_visible_ariane = 1 AND a0_.statut_id NOT IN (2, 3, 5, 12) AND a0_.statut_id IS NOT NULL AND a0_.article_marque_id IS NOT NULL AND a0_.statut_id = ?
Parameters:
[
4
]
|
|
1.87 ms (0.55%) |
4 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.ordre AS ordre_4, t0.franco_commande AS franco_commande_5 FROM categorie t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
0.76 ms (0.22%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5 FROM client_groupe t0 WHERE t0.nom = ? LIMIT 1
Parameters:
[
"T-DOM"
]
|
client connection
| Time▼ | Count | Info |
|---|---|---|
|
1.15 ms (0.34%) |
6 |
SELECT DATABASE()
Parameters:
[] |
|
1.06 ms (0.31%) |
1 |
SELECT c.COLUMN_NAME AS field, c.COLUMN_TYPE AS type, c.IS_NULLABLE AS `null`, c.COLUMN_KEY AS `key`, c.COLUMN_DEFAULT AS `default`, c.EXTRA, c.COLUMN_COMMENT AS comment, c.CHARACTER_SET_NAME AS characterset, c.COLLATION_NAME AS collation FROM information_schema.COLUMNS c INNER JOIN information_schema.TABLES t ON t.TABLE_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION
Parameters:
[ "arianesrdi_dev" "arianesrdi_dev" "doctrine_migration_versions" ] |
|
0.91 ms (0.27%) |
2 |
SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME
Parameters:
[
"arianesrdi_dev"
]
|
|
0.65 ms (0.19%) |
1 |
SELECT t.TABLE_NAME, t.ENGINE, t.AUTO_INCREMENT, t.TABLE_COMMENT, t.CREATE_OPTIONS, t.TABLE_COLLATION, ccsa.CHARACTER_SET_NAME FROM information_schema.TABLES t INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE'
Parameters:
[ "arianesrdi_dev" "doctrine_migration_versions" ] |
|
0.55 ms (0.16%) |
1 |
SELECT DISTINCT k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME, k.ORDINAL_POSITION /*!50116, c.UPDATE_RULE, c.DELETE_RULE */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME AND c.TABLE_NAME = k.TABLE_NAME */ WHERE k.TABLE_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL /*!50116 AND c.CONSTRAINT_SCHEMA = 'arianesrdi_dev' */ ORDER BY k.ORDINAL_POSITION
Parameters:
[ "arianesrdi_dev" "doctrine_migration_versions" ] |
|
0.29 ms (0.09%) |
1 |
SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? ORDER BY SEQ_IN_INDEX
Parameters:
[ "arianesrdi_dev" "doctrine_migration_versions" ] |
|
0.21 ms (0.06%) |
1 |
SELECT * FROM doctrine_migration_versions
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| client | doctrine.dbal.client_connection |
| hermes | doctrine.dbal.hermes_connection |
Entity Managers
| Name | Service |
|---|---|
| client | doctrine.orm.client_entity_manager |
| hermes | doctrine.orm.hermes_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
client entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\Ariane\Compte | No errors. |
| App\Entity\Ariane\UserClient | No errors. |
| App\Entity\Ariane\ResetPasswordRequest | No errors. |
| App\Entity\Ariane\Wishlist | No errors. |
| App\Entity\Ariane\CommandeClient | No errors. |
| App\Entity\Ariane\PanierClient | No errors. |
| App\Entity\Ariane\Indispensable | No errors. |
| App\Entity\Ariane\Favori | No errors. |
| App\Entity\Ariane\PanierLigneClient | No errors. |
hermes entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\Hermes\ClientRestrictionVente |
|
| App\Entity\Hermes\ClientGroupe | No errors. |
| App\Entity\Hermes\ArticleFamille | No errors. |
| App\Entity\Hermes\Promotion |
|
| App\Entity\Hermes\ArticleGamme | No errors. |
| App\Entity\Hermes\Article | No errors. |
| App\Entity\Hermes\TypeEncre | No errors. |
| App\Entity\Hermes\MediaMedia | No errors. |
| App\Entity\Hermes\ArticleGroupe | No errors. |
| App\Entity\Hermes\PromoBox | No errors. |
| App\Entity\Hermes\MediaGallery | No errors. |
| App\Entity\Hermes\Statut | No errors. |
| App\Entity\Hermes\ArticleMarque | No errors. |
| App\Entity\Hermes\ArticleType | No errors. |
| App\Entity\Hermes\Categorie | No errors. |
| App\Entity\Hermes\Prix |
|
| App\Entity\Hermes\Client |
|
| App\Entity\Hermes\PromotionInterdictionClient |
|
| App\Entity\Hermes\PromotionLigne | No errors. |
| App\Entity\Hermes\ClientStatut | No errors. |