Query Metrics
105
Database Queries
30
Different statements
82.00 ms
Query time
1
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
27.92 ms (34.05%) |
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
]
|
|
13.10 ms (15.97%) |
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.25 ms (12.50%) |
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
]
|
|
4.26 ms (5.19%) |
4 |
SELECT DATABASE()
Parameters:
[] |
|
3.33 ms (4.07%) |
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.37 ms (2.89%) |
2 |
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
Parameters:
[] |
|
2.17 ms (2.64%) |
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
]
|
|
2.17 ms (2.64%) |
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.37 ms (1.67%) |
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-atelier-duomo"
]
|
|
1.37 ms (1.67%) |
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:
[
104
]
|
|
1.31 ms (1.59%) |
3 |
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:
[
811
]
|
|
1.30 ms (1.58%) |
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:
[] |
|
1.27 ms (1.54%) |
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:
[] |
|
0.86 ms (1.05%) |
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.74 ms (0.90%) |
1 |
SELECT t0.id AS id_1, t0.placement AS placement_2, t0.type AS type_3, t0.nom AS nom_4, t0.code AS code_5 FROM profil_couleur t0 INNER JOIN profil_geometrie_profil_couleur ON t0.id = profil_geometrie_profil_couleur.profil_couleur_id WHERE profil_geometrie_profil_couleur.profil_geometrie_id = ? ORDER BY t0.placement ASC
Parameters:
[
160
]
|
|
0.74 ms (0.90%) |
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.73 ms (0.89%) |
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.67 ms (0.82%) |
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:
[
104
]
|
|
0.66 ms (0.81%) |
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.64 ms (0.79%) |
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.63 ms (0.77%) |
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:
[
104
]
|
|
0.58 ms (0.71%) |
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.56 ms (0.68%) |
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.53 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:
[
104
]
|
|
0.52 ms (0.64%) |
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.63%) |
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:
[] |
|
0.46 ms (0.57%) |
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:
[
104
]
|
|
0.36 ms (0.43%) |
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.33 ms (0.40%) |
1 |
SELECT * FROM doctrine_migration_versions
Parameters:
[] |
|
0.31 ms (0.38%) |
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:
[
104
]
|
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 |
|
| 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. |