Query Metrics

103 Database Queries
29 Different statements
76.36 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
23.48 ms
(30.75%)
25
SELECT t0.id AS id_1, t0.model_commercial AS model_commercial_2, t0.placement AS placement_3, t0.actif AS actif_4, t0.avantage AS avantage_5, t0.description AS description_6, t0.caracteristique AS caracteristique_7, t0.date AS date_8, t0.largeur_fixe AS largeur_fixe_9, t0.largeur_min AS largeur_min_10, t0.largeur_max AS largeur_max_11, t0.hauteur_fixe AS hauteur_fixe_12, t0.hauteur_min AS hauteur_min_13, t0.hauteur_max AS hauteur_max_14, t0.profondeur_fixe AS profondeur_fixe_15, t0.profondeur_min AS profondeur_min_16, t0.profondeur_max AS profondeur_max_17, t0.seo_url AS seo_url_18, t0.meta_title AS meta_title_19, t0.meta_description AS meta_description_20, t0.preconfig_url_key AS preconfig_url_key_21, t0.partition_produit_id AS partition_produit_id_22, t0.sous_famille_id AS sous_famille_id_23, t0.configurateur_id AS configurateur_id_24 FROM produit t0 INNER JOIN produit_sous_famille ON t0.id = produit_sous_famille.produit_id WHERE produit_sous_famille.sous_famille_id = ? ORDER BY t0.placement ASC
Parameters:
[
  13
]
14.99 ms
(19.63%)
25
SELECT t0.id AS id_1, t0.title AS title_2, t0.seo_url AS seo_url_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.url_image AS url_image_6, t0.url_image_entete AS url_image_entete_7, t0.date AS date_8, t0.placement AS placement_9 FROM sous_famille_type t0 INNER JOIN sous_famille_type_sous_famille ON t0.id = sous_famille_type_sous_famille.sous_famille_type_id WHERE sous_famille_type_sous_famille.sous_famille_id = ?
Parameters:
[
  13
]
10.64 ms
(13.93%)
14
SELECT t0.id AS id_1, t0.actif AS actif_2, t0.titre AS titre_3, t0.placement AS placement_4, t0.descriptif AS descriptif_5, t0.url AS url_6, t0.date AS date_7, t0.seo_url AS seo_url_8, t0.meta_title AS meta_title_9, t0.meta_description AS meta_description_10, t0.image_alt AS image_alt_11 FROM ambiance t0 INNER JOIN ambiance_sous_thematique_ambiance ON t0.id = ambiance_sous_thematique_ambiance.ambiance_id WHERE ambiance_sous_thematique_ambiance.ambiance_sous_thematique_id = ? ORDER BY t0.placement ASC
Parameters:
[
  4
]
3.39 ms
(4.45%)
6
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.designation_collection_filtre AS designation_collection_filtre_3, t0.designation_collection_filtre_bis AS designation_collection_filtre_bis_4, t0.seo_url AS seo_url_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.navbar_text AS navbar_text_8, t0.placement AS placement_9, t0.url_image AS url_image_10, t0.url_image_entete AS url_image_entete_11, t0.date AS date_12, t0.description AS description_13, t0.description_fin AS description_fin_14, t0.configurateur AS configurateur_15, t0.famille_produit_id AS famille_produit_id_16 FROM sous_famille t0 WHERE t0.famille_produit_id = ? ORDER BY t0.placement ASC
Parameters:
[
  2
]
2.98 ms
(3.90%)
4
SELECT DATABASE()
Parameters:
[]
2.86 ms
(3.75%)
2
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
Parameters:
[]
2.71 ms
(3.55%)
3
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.placement AS placement_3, t0.seo_url AS seo_url_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6, t0.navbar_text AS navbar_text_7, t0.url_image AS url_image_8, t0.url_image_entete AS url_image_entete_9, t0.date AS date_10, t0.description AS description_11, t0.description_fin AS description_fin_12, t0.thematique_id AS thematique_id_13 FROM ambiance_sous_thematique t0 WHERE t0.thematique_id = ? ORDER BY t0.placement ASC
Parameters:
[
  2
]
1.53 ms
(2.01%)
2
SELECT t0.id AS id_1, t0.actif AS actif_2, t0.placement AS placement_3, t0.url_image AS url_image_4, t0.url_image_entete AS url_image_entete_5, t0.date AS date_6, t0.designation AS designation_7, t0.configurateur AS configurateur_8, t0.seo_url AS seo_url_9, t0.meta_title AS meta_title_10, t0.meta_description AS meta_description_11, t0.navbar_text AS navbar_text_12, t0.description AS description_13, t0.description_fin AS description_fin_14 FROM famille_produit t0 WHERE t0.actif = ? ORDER BY t0.placement ASC
Parameters:
[
  1
]
1.50 ms
(1.97%)
1
SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'dbppsogalcom' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION ASC
Parameters:
[]
1.39 ms
(1.82%)
1
SELECT k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME /*!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_NAME = 'doctrine_migration_versions' AND k.TABLE_SCHEMA = 'dbppsogalcom' /*!50116 AND c.CONSTRAINT_SCHEMA = 'dbppsogalcom' */ORDER BY k.ORDINAL_POSITION
Parameters:
[]
1.32 ms
(1.74%)
1
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.url AS url_3, t0.date AS date_4, t0.produit_id AS produit_id_5 FROM image t0 WHERE t0.produit_id = ?
Parameters:
[
  172
]
1.01 ms
(1.32%)
1
SELECT 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 TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'doctrine_migration_versions'
Parameters:
[]
0.91 ms
(1.19%)
2
SELECT t0.id AS id_1, t0.placement AS placement_2, t0.nom AS nom_3, t0.code AS code_4 FROM remplissage_decors t0 INNER JOIN remplissage_nuancier_remplissage_decors ON t0.id = remplissage_nuancier_remplissage_decors.remplissage_decors_id WHERE remplissage_nuancier_remplissage_decors.remplissage_nuancier_id = ? ORDER BY t0.placement ASC
Parameters:
[
  987
]
0.79 ms
(1.04%)
1
SELECT t0.id AS id_1, t0.model_commercial AS model_commercial_2, t0.placement AS placement_3, t0.actif AS actif_4, t0.avantage AS avantage_5, t0.description AS description_6, t0.caracteristique AS caracteristique_7, t0.date AS date_8, t0.largeur_fixe AS largeur_fixe_9, t0.largeur_min AS largeur_min_10, t0.largeur_max AS largeur_max_11, t0.hauteur_fixe AS hauteur_fixe_12, t0.hauteur_min AS hauteur_min_13, t0.hauteur_max AS hauteur_max_14, t0.profondeur_fixe AS profondeur_fixe_15, t0.profondeur_min AS profondeur_min_16, t0.profondeur_max AS profondeur_max_17, t0.seo_url AS seo_url_18, t0.meta_title AS meta_title_19, t0.meta_description AS meta_description_20, t0.preconfig_url_key AS preconfig_url_key_21, t0.partition_produit_id AS partition_produit_id_22, t0.sous_famille_id AS sous_famille_id_23, t0.configurateur_id AS configurateur_id_24 FROM produit t0 WHERE t0.seo_url = ? LIMIT 1
Parameters:
[
  "bloc-porte-formose-v8"
]
0.63 ms
(0.82%)
1
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.seo_url AS seo_url_3, t0.sitemap AS sitemap_4, t0.image_en_tete AS image_en_tete_5, t0.date AS date_6, t0.navbar_active AS navbar_active_7, t0.navbar_top_active AS navbar_top_active_8, t0.footer_active AS footer_active_9, t0.navbar_sous_menu AS navbar_sous_menu_10, t0.navbar_position AS navbar_position_11, t0.navbar_titre AS navbar_titre_12, t0.meta_title AS meta_title_13, t0.meta_description AS meta_description_14, t0.is_contact_form AS is_contact_form_15, t0.image_alt AS image_alt_16, t0.instant_expert AS instant_expert_17 FROM page t0 WHERE t0.navbar_active = ? ORDER BY t0.navbar_position ASC
Parameters:
[
  1
]
0.58 ms
(0.76%)
1
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.seo_url AS seo_url_3, t0.sitemap AS sitemap_4, t0.image_en_tete AS image_en_tete_5, t0.date AS date_6, t0.navbar_active AS navbar_active_7, t0.navbar_top_active AS navbar_top_active_8, t0.footer_active AS footer_active_9, t0.navbar_sous_menu AS navbar_sous_menu_10, t0.navbar_position AS navbar_position_11, t0.navbar_titre AS navbar_titre_12, t0.meta_title AS meta_title_13, t0.meta_description AS meta_description_14, t0.is_contact_form AS is_contact_form_15, t0.image_alt AS image_alt_16, t0.instant_expert AS instant_expert_17 FROM page t0 WHERE t0.is_contact_form = ? ORDER BY t0.navbar_position ASC LIMIT 1
Parameters:
[
  1
]
0.55 ms
(0.71%)
1
SELECT t0.id AS id_1, t0.actif AS actif_2, t0.placement AS placement_3, t0.url_image AS url_image_4, t0.url_image_entete AS url_image_entete_5, t0.date AS date_6, t0.designation AS designation_7, t0.configurateur AS configurateur_8, t0.seo_url AS seo_url_9, t0.meta_title AS meta_title_10, t0.meta_description AS meta_description_11, t0.navbar_text AS navbar_text_12, t0.description AS description_13, t0.description_fin AS description_fin_14 FROM famille_produit t0 WHERE t0.seo_url = ? LIMIT 1
Parameters:
[
  "porte-interieure"
]
0.52 ms
(0.68%)
1
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.designation_collection_filtre AS designation_collection_filtre_3, t0.designation_collection_filtre_bis AS designation_collection_filtre_bis_4, t0.seo_url AS seo_url_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.navbar_text AS navbar_text_8, t0.placement AS placement_9, t0.url_image AS url_image_10, t0.url_image_entete AS url_image_entete_11, t0.date AS date_12, t0.description AS description_13, t0.description_fin AS description_fin_14, t0.configurateur AS configurateur_15, t0.famille_produit_id AS famille_produit_id_16 FROM sous_famille t0 WHERE t0.seo_url = ? LIMIT 1
Parameters:
[
  "blocs-portes-interieurs"
]
0.51 ms
(0.67%)
1
SELECT t0.id AS id_1, t0.placement AS placement_2, t0.nom AS nom_3, t0.nom_interne AS nom_interne_4, t0.date AS date_5 FROM remplissage_nuancier t0 INNER JOIN remplissage_nuancier_produit ON t0.id = remplissage_nuancier_produit.remplissage_nuancier_id WHERE remplissage_nuancier_produit.produit_id = ? ORDER BY t0.placement ASC
Parameters:
[
  172
]
0.49 ms
(0.64%)
1
SELECT t0.id AS id_1, t0.placement AS placement_2, t0.nom AS nom_3, t0.nom_interne AS nom_interne_4, t0.code AS code_5 FROM profil_geometrie t0 INNER JOIN profil_geometrie_produit ON t0.id = profil_geometrie_produit.profil_geometrie_id WHERE profil_geometrie_produit.produit_id = ? ORDER BY t0.placement ASC
Parameters:
[
  172
]
0.48 ms
(0.63%)
1
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.seo_url AS seo_url_3, t0.sitemap AS sitemap_4, t0.image_en_tete AS image_en_tete_5, t0.date AS date_6, t0.navbar_active AS navbar_active_7, t0.navbar_top_active AS navbar_top_active_8, t0.footer_active AS footer_active_9, t0.navbar_sous_menu AS navbar_sous_menu_10, t0.navbar_position AS navbar_position_11, t0.navbar_titre AS navbar_titre_12, t0.meta_title AS meta_title_13, t0.meta_description AS meta_description_14, t0.is_contact_form AS is_contact_form_15, t0.image_alt AS image_alt_16, t0.instant_expert AS instant_expert_17 FROM page t0 WHERE t0.navbar_top_active = ? ORDER BY t0.navbar_position ASC
Parameters:
[
  1
]
0.47 ms
(0.62%)
1
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.placement AS placement_3, t0.seo_url AS seo_url_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6, t0.navbar_text AS navbar_text_7, t0.url_image AS url_image_8, t0.url_image_entete AS url_image_entete_9, t0.date AS date_10, t0.description AS description_11, t0.description_fin AS description_fin_12 FROM ambiance_thematique t0 ORDER BY t0.placement ASC
Parameters:
[]
0.45 ms
(0.59%)
1
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.seo_url AS seo_url_3, t0.sitemap AS sitemap_4, t0.image_en_tete AS image_en_tete_5, t0.date AS date_6, t0.navbar_active AS navbar_active_7, t0.navbar_top_active AS navbar_top_active_8, t0.footer_active AS footer_active_9, t0.navbar_sous_menu AS navbar_sous_menu_10, t0.navbar_position AS navbar_position_11, t0.navbar_titre AS navbar_titre_12, t0.meta_title AS meta_title_13, t0.meta_description AS meta_description_14, t0.is_contact_form AS is_contact_form_15, t0.image_alt AS image_alt_16, t0.instant_expert AS instant_expert_17 FROM page t0 WHERE t0.footer_active = ? ORDER BY t0.navbar_position ASC
Parameters:
[
  1
]
0.43 ms
(0.57%)
1
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.url AS url_4, t0.notice_et_video_id AS notice_et_video_id_5 FROM notice t0 INNER JOIN produit_notice ON t0.id = produit_notice.notice_id WHERE produit_notice.produit_id = ?
Parameters:
[
  172
]
0.38 ms
(0.49%)
1
SELECT * FROM doctrine_migration_versions
Parameters:
[]
0.37 ms
(0.48%)
1
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.seo_url AS seo_url_3, t0.sitemap AS sitemap_4, t0.image_en_tete AS image_en_tete_5, t0.date AS date_6, t0.navbar_active AS navbar_active_7, t0.navbar_top_active AS navbar_top_active_8, t0.footer_active AS footer_active_9, t0.navbar_sous_menu AS navbar_sous_menu_10, t0.navbar_position AS navbar_position_11, t0.navbar_titre AS navbar_titre_12, t0.meta_title AS meta_title_13, t0.meta_description AS meta_description_14, t0.is_contact_form AS is_contact_form_15, t0.image_alt AS image_alt_16, t0.instant_expert AS instant_expert_17 FROM page t0 WHERE t0.navbar_sous_menu = ? ORDER BY t0.navbar_position ASC
Parameters:
[
  1
]
0.37 ms
(0.48%)
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_NAME = 'doctrine_migration_versions' AND TABLE_SCHEMA = 'dbppsogalcom' ORDER BY SEQ_IN_INDEX ASC
Parameters:
[]
0.32 ms
(0.42%)
1
SELECT t0.id AS id_1, t0.url AS url_2, t0.titre AS titre_3, t0.description AS description_4, t0.notice_et_video_id AS notice_et_video_id_5 FROM video t0 INNER JOIN produit_video ON t0.id = produit_video.video_id WHERE produit_video.produit_id = ?
Parameters:
[
  172
]
0.31 ms
(0.41%)
1
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.url AS url_4, t0.produit_id AS produit_id_5 FROM pdf t0 WHERE t0.produit_id = ?
Parameters:
[
  172
]

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.

Entities Mapping

Class Mapping errors
App\Entity\Produit\FamilleProduit No errors.
App\Entity\Produit\SousFamille No errors.
App\Entity\Produit\Produit
  • The mappings App\Entity\Produit\Produit#sousFamille and App\Entity\Produit\SousFamille#produits are inconsistent with each other.
  • If association App\Entity\Produit\Produit#sousFamille is many-to-one, then the inversed side App\Entity\Produit\SousFamille#produits has to be one-to-many.
App\Entity\Produit\SousFamilleType No errors.
App\Entity\Produit\PartitionProduit No errors.
App\Entity\Volumiq\Configurateur No errors.
App\Entity\Produit\Pdf No errors.
App\Entity\Produit\Image No errors.
App\Entity\Site\Ambiance No errors.
App\Entity\Produit\FiltrePersonalise No errors.
App\Entity\Produit\FiltrePersonaliseBis No errors.
App\Entity\Produit\Notice No errors.
App\Entity\Produit\Video No errors.
App\Entity\Produit\ProfilGeometrie No errors.
App\Entity\Produit\RemplissageNuancier No errors.
App\Entity\Template\Page No errors.
App\Entity\Site\AmbianceThematique No errors.
App\Entity\Site\AmbianceSousThematique No errors.
App\Entity\Template\Row No errors.
App\Entity\Volumiq\SousCategorie No errors.
App\Entity\Produit\NoticeEtVideo No errors.
App\Entity\Produit\ProfilCouleur No errors.
App\Entity\Produit\RemplissageDecors No errors.
App\Entity\Template\Col No errors.
App\Entity\Site\Dossier No errors.
App\Entity\Site\Article No errors.