Query Metrics
104
Database Queries
24
Different statements
64.94 ms
Query time
1
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
20.54 ms (31.63%) |
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
]
|
|
9.63 ms (14.83%) |
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
]
|
|
8.05 ms (12.40%) |
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
]
|
|
4.00 ms (6.16%) |
8 |
SELECT t0.id AS id_1, t0.largeur AS largeur_2, t0.contenu AS contenu_3, t0.placement AS placement_4, t0.row_id AS row_id_5 FROM col t0 WHERE t0.row_id = ? ORDER BY t0.placement ASC
Parameters:
[
754
]
|
|
3.04 ms (4.68%) |
2 |
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
Parameters:
[] |
|
2.92 ms (4.50%) |
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.16 ms (3.32%) |
4 |
SELECT DATABASE()
Parameters:
[] |
|
2.04 ms (3.15%) |
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.55 ms (2.38%) |
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.51 ms (2.33%) |
1 |
SELECT t0.id AS id_1, t0.placement AS placement_2, t0.titre AS titre_3, t0.resume AS resume_4, t0.date AS date_5, t0.pdf AS pdf_6, t0.image_url AS image_url_7, t0.image_bis_url AS image_bis_url_8, t0.image_ter_url AS image_ter_url_9, t0.updated_at AS updated_at_10, t0.seo_url AS seo_url_11, t0.meta_title AS meta_title_12, t0.meta_description AS meta_description_13, t0.date_fin AS date_fin_14, t0.image_alt AS image_alt_15, t0.tag_id AS tag_id_16 FROM article t0 WHERE t0.seo_url = ? LIMIT 1
Parameters:
[
"meubles-deco-industrielle"
]
|
|
1.44 ms (2.21%) |
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.22 ms (1.88%) |
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.96 ms (1.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.81 ms (1.25%) |
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.80 ms (1.23%) |
1 |
SELECT * FROM doctrine_migration_versions
Parameters:
[] |
|
0.78 ms (1.20%) |
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.58 ms (0.90%) |
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.46 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.navbar_active = ? ORDER BY t0.navbar_position ASC
Parameters:
[
1
]
|
|
0.44 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.footer_active = ? ORDER BY t0.navbar_position ASC
Parameters:
[
1
]
|
|
0.43 ms (0.66%) |
1 |
SELECT t0.id AS id_1, t0.placement AS placement_2, t0.titre AS titre_3 FROM article_tag t0 WHERE t0.id = ?
Parameters:
[
6
]
|
|
0.40 ms (0.62%) |
1 |
SELECT t0.id AS id_1, t0.entete AS entete_2, t0.background_color AS background_color_3, t0.background_image AS background_image_4, t0.date AS date_5, t0.background_cover AS background_cover_6, t0.inverser_colonne AS inverser_colonne_7, t0.container_colonne AS container_colonne_8, t0.placement AS placement_9, t0.page_id AS page_id_10, t0.ambiance_id AS ambiance_id_11, t0.dossier_id AS dossier_id_12, t0.article_id AS article_id_13 FROM row t0 WHERE t0.article_id = ? ORDER BY t0.placement ASC
Parameters:
[
23
]
|
|
0.40 ms (0.61%) |
1 |
SELECT t0.id AS id_1, t0.placement AS placement_2, t0.titre AS titre_3 FROM article_tag_produit t0 INNER JOIN article_article_tag_produit ON t0.id = article_article_tag_produit.article_tag_produit_id WHERE article_article_tag_produit.article_id = ?
Parameters:
[
23
]
|
|
0.39 ms (0.61%) |
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.38 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.navbar_sous_menu = ? ORDER BY t0.navbar_position ASC
Parameters:
[
1
]
|
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\Site\Article | No errors. |
| App\Entity\Site\ArticleTag | No errors. |
| App\Entity\Template\Row | No errors. |
| App\Entity\Site\ArticleTagProduit | No errors. |
| App\Entity\Template\Page | No errors. |
| App\Entity\Produit\FamilleProduit | No errors. |
| App\Entity\Site\AmbianceThematique | No errors. |
| App\Entity\Produit\SousFamille | No errors. |
| App\Entity\Site\AmbianceSousThematique | No errors. |
| App\Entity\Produit\Produit |
|
| App\Entity\Produit\SousFamilleType | No errors. |
| App\Entity\Site\Ambiance | No errors. |
| App\Entity\Volumiq\Configurateur | No errors. |
| App\Entity\Produit\PartitionProduit | No errors. |
| App\Entity\Produit\Pdf | No errors. |
| App\Entity\Produit\Image | 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\Col | No errors. |
| App\Entity\Site\Dossier | 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\Site\DossierParent | No errors. |
| App\Entity\Volumiq\Categorie | No errors. |
| App\Entity\Produit\NoticeSousCategorie | No errors. |