Query Metrics
20
Database Queries
19
Different statements
60.99 ms
Query time
1
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.70 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_actif AS is_actif_4, t0.is_default AS is_default_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8 FROM languages t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"fr"
]
|
2 | 0.74 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_actif AS is_actif_4, t0.is_default AS is_default_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8 FROM languages t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"fr"
]
|
3 | 0.83 ms |
SELECT p0_.slug AS slug_0, p0_.page_category_id AS sclr_1 FROM page_category_lang p0_ WHERE p0_.language_id = ? AND p0_.page_category_id IN (?)
Parameters:
[ 1 "1" ] |
4 | 0.87 ms |
SELECT p0_.slug AS slug_0, p0_.page_id AS sclr_1 FROM page_lang p0_ WHERE p0_.language_id = ? AND p0_.page_id IN (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 "4" "5" "8" "10" "9" "21" "32" "43" ] |
5 | 0.60 ms |
SELECT p0_.slug AS slug_0, p0_.page_id AS sclr_1 FROM page_lang p0_ WHERE p0_.language_id = ? AND p0_.page_id IN (?, ?)
Parameters:
[ 1 "21" "22" ] |
6 | 0.72 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.language_id AS language_id_5, t0.page_id AS page_id_6 FROM page_lang t0 WHERE t0.language_id = ? AND t0.slug = ? LIMIT 1
Parameters:
[ 1 "mentions-legales" ] |
7 | 2.22 ms |
SELECT m0_.id AS id_0, m0_.origin AS origin_1, m0_.id_origin AS id_origin_2, m0_.file AS file_3, m0_.extension AS extension_4, m0_.taille AS taille_5, m0_.path AS path_6, m0_.title AS title_7, m0_.position AS position_8, m0_.created_at AS created_at_9, m0_.updated_at AS updated_at_10, m0_.deleted_at AS deleted_at_11, m0_.type AS type_12, m0_.language_id AS language_id_13 FROM media m0_ WHERE m0_.origin = ? AND m0_.id_origin = ? AND m0_.deleted_at IS NULL AND m0_.language_id = ? ORDER BY m0_.position ASC
Parameters:
[ "App\Entity\Pages\Page" 21 1 ] |
8 | 7.73 ms |
SELECT b0_.id AS id_0, b0_.position AS position_1, b0_.is_fix_title AS is_fix_title_2, b0_.type AS type_3, b0_.classe AS classe_4, b0_.id_origin AS id_origin_5, b0_.id_type AS id_type_6, b0_.origin AS origin_7, b0_.first_position AS first_position_8, b0_.second_position AS second_position_9, b0_.is_show_title AS is_show_title_10, b0_.position_image AS position_image_11, b0_.position_video AS position_video_12, b0_.col_txt AS col_txt_13, b0_.col_image AS col_image_14, b0_.col_card AS col_card_15, b0_.alignement_texte AS alignement_texte_16, b0_.istitre_principale_bloc AS istitre_principale_bloc_17, b0_.is_btn AS is_btn_18, b0_.titre_principale_bloc AS titre_principale_bloc_19, b0_.classe_titre_principale_bloc AS classe_titre_principale_bloc_20, b1_.title AS title_21, b1_.description AS description_22, m2_.id AS id_23, m2_.file AS file_24, m2_.path AS path_25, m2_.extension AS extension_26, m2_.title AS title_27, m2_.type AS type_28, c3_.id AS id_29, c3_.is_enable AS is_enable_30, c4_.title_top AS title_top_31, c4_.title AS title_32, c4_.description AS description_33, c3_.link AS link_34, c3_.classe AS classe_35, m5_.id AS id_36, m5_.origin AS origin_37, m5_.file AS file_38, m5_.path AS path_39, m5_.extension AS extension_40, c6_.id AS id_41, c7_.title_top AS title_top_42, c6_.is_enable AS is_enable_43, c7_.title AS title_44, c7_.description AS description_45, c6_.link AS link_46, c6_.classe AS classe_47, m8_.id AS id_48, m8_.origin AS origin_49, m8_.file AS file_50, m8_.path AS path_51, m8_.extension AS extension_52 FROM bloc b0_ LEFT JOIN bloc_lang b1_ ON b0_.id = b1_.bloc_id AND (b1_.language_id = ?) LEFT JOIN media m2_ ON (m2_.id_origin = b0_.id AND m2_.origin = ? AND m2_.language_id = ?) LEFT JOIN client_bloc c6_ ON b0_.client_right_id = c6_.id LEFT JOIN client_bloc_lang c7_ ON c6_.id = c7_.client_bloc_lang_id AND (c7_.language_id = ?) LEFT JOIN media m8_ ON (m8_.origin = ? AND m8_.id_origin = c6_.id AND m8_.language_id = ?) LEFT JOIN client_bloc c3_ ON b0_.client_left_id = c3_.id LEFT JOIN client_bloc_lang c4_ ON c3_.id = c4_.client_bloc_lang_id AND (c4_.language_id = ?) LEFT JOIN media m5_ ON (m5_.origin = ? AND m5_.id_origin = c3_.id AND m5_.language_id = ?) WHERE b0_.origin = ? AND b0_.id_origin = ? AND m2_.deleted_at IS NULL AND m8_.deleted_at IS NULL AND m5_.deleted_at IS NULL ORDER BY b0_.position ASC
Parameters:
[ 1 "App\Entity\Blocs\Bloc" 1 1 "App\Entity\ClientBlocs\ClientBloc" 1 1 "App\Entity\ClientBlocs\ClientBloc" 1 "App\Entity\Pages\Page" 21 ] |
9 | 21.95 ms |
SELECT l0_.id AS id_0, l0_.created_at AS created_at_1, l0_.is_enable AS is_enable_2, l0_.classe AS classe_3, l1_.name AS name_4, l1_.description AS description_5, l2_.id AS id_6, l2_.link AS link_7, l3_.second_title AS second_title_8, l3_.name AS name_9, l2_.is_show_title_labels AS is_show_title_labels_10, l3_.description AS description_11, l2_.classe AS classe_12, l2_.col_bloc_label_slide AS col_bloc_label_slide_13, m4_.id AS id_14, m4_.file AS file_15, m4_.path AS path_16, m4_.title AS title_17 FROM label_bloc l0_ LEFT JOIN label_bloc_lang l1_ ON l0_.id = l1_.label_bloc_id AND (l1_.language_id = ?) LEFT JOIN label_slider l2_ ON l0_.id = l2_.label_bloc_id LEFT JOIN label_slider_lang l3_ ON l2_.id = l3_.label_slider_id AND (l3_.language_id = ?) LEFT JOIN media m4_ ON (m4_.id_origin = l2_.id AND m4_.origin = ? AND m4_.language_id = ?) WHERE l0_.deleted_at IS NULL AND l0_.is_enable = ? AND (l2_.deleted_at IS NULL AND l2_.is_enable = 1) AND m4_.deleted_at IS NULL ORDER BY l0_.id DESC
Parameters:
[ 1 1 "App\Entity\Labels\LabelSlider" 1 1 ] |
10 | 6.25 ms |
SELECT c0_.id AS id_0, c0_.created_at AS created_at_1, c0_.is_enable AS is_enable_2, c1_.name AS name_3, c0_.class AS class_4, c2_.id AS id_5, c3_.name AS name_6, c3_.description AS description_7, c3_.title_mobile AS title_mobile_8, c2_.is_enable AS is_enable_9, c2_.background_color AS background_color_10, m4_.id AS id_11, m4_.file AS file_12, m4_.path AS path_13, m4_.extension AS extension_14 FROM carrousel c0_ LEFT JOIN carrousel_lang c1_ ON c0_.id = c1_.carrousel_id AND (c1_.language_id = ?) LEFT JOIN carrousel_items c2_ ON c0_.id = c2_.carrousel_id LEFT JOIN carrousel_items_lang c3_ ON c2_.id = c3_.carousel_items_id AND (c3_.language_id = ?) LEFT JOIN media m4_ ON (m4_.id_origin = c2_.id AND m4_.origin = ? AND m4_.language_id = ?) WHERE c0_.deleted_at IS NULL AND (c2_.deleted_at IS NULL AND c2_.is_enable = 1) AND m4_.deleted_at IS NULL ORDER BY c0_.id DESC, c2_.id ASC
Parameters:
[ 1 1 "App\Entity\Carrousel\carrouselItems" 1 ] |
11 | 11.17 ms |
SELECT b0_.id AS id_0, b0_.created_at AS created_at_1, b0_.is_enable AS is_enable_2, b1_.name AS name_3, b1_.description AS description_4, b2_.id AS id_5, b2_.classe AS classe_6, b3_.name AS name_7, b3_.description AS description_8, b2_.col_benefice_items AS col_benefice_items_9, b2_.cards_links AS cards_links_10, b3_.link AS link_11, m4_.id AS id_12, m4_.file AS file_13, m4_.path AS path_14, m4_.title AS title_15 FROM benefice b0_ LEFT JOIN benefice_lang b1_ ON b0_.id = b1_.benefice_bloc_id AND (b1_.language_id = ?) LEFT JOIN benefice_items b2_ ON b0_.id = b2_.benefice_id LEFT JOIN benefice_items_lang b3_ ON b2_.id = b3_.benefice_items_id AND (b3_.language_id = ?) LEFT JOIN media m4_ ON (m4_.id_origin = b2_.id AND m4_.origin = ? AND m4_.language_id = ?) WHERE b0_.deleted_at IS NULL AND b0_.is_enable = ? AND (b2_.deleted_at IS NULL AND b2_.is_enable = 1) AND m4_.deleted_at IS NULL ORDER BY b0_.id DESC
Parameters:
[ 1 1 "App\Entity\Benefice\BeneficeItems" 1 1 ] |
12 | 0.85 ms |
SELECT t0.id AS id_1, t0.origin AS origin_2, t0.id_origin AS id_origin_3, t0.value AS value_4 FROM palette_color t0 WHERE t0.origin = ? AND t0.id_origin = ?
Parameters:
[ "App\Entity\Pages\Page" 21 ] |
13 | 0.69 ms |
SELECT t0.id AS id_1, t0.is_enable AS is_enable_2, t0.is_contact AS is_contact_3, t0.is_demo AS is_demo_4, t0.classe_titre_contact AS classe_titre_contact_5, t0.link_visiter_site AS link_visiter_site_6, t0.classe_body_page AS classe_body_page_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10, t0.page_sous_category_id AS page_sous_category_id_11, t0.parent_id AS parent_id_12 FROM page t0 WHERE t0.id = ?
Parameters:
[
21
]
|
14 | 0.90 ms |
SELECT p0_.id AS id_0, p0_.created_at AS created_at_1, p0_.is_enable AS is_enable_2, p0_.is_contact AS is_contact_3, p1_.name AS name_4, p1_.slug AS slug_5, p1_.description AS description_6, p0_.classe_titre_contact AS classe_titre_contact_7, p0_.link_visiter_site AS link_visiter_site_8, p0_.classe_body_page AS classe_body_page_9, p0_.is_demo AS is_demo_10 FROM page p0_ LEFT JOIN page_lang p1_ ON p0_.id = p1_.page_id AND (p1_.language_id = ?) WHERE (p0_.deleted_at IS NULL AND p0_.is_enable = 1) AND p0_.id = ? ORDER BY p0_.id ASC
Parameters:
[ 1 21 ] |
15 | 0.80 ms |
SELECT t0.id AS id_1, t0.route AS route_2, t0.parameter AS parameter_3 FROM seo t0 WHERE t0.route = ? AND t0.parameter = ? LIMIT 1
Parameters:
[ "front_page_show" "mentions-legales" ] |
16 | 0.85 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.language_id AS language_id_5, t0.seo_id AS seo_id_6 FROM seo_lang t0 WHERE t0.seo_id = ? AND t0.language_id = ? LIMIT 1
Parameters:
[ 12 1 ] |
17 | 1.21 ms |
SELECT p0_.id AS id_0, p0_.created_at AS created_at_1, p0_.is_enable AS is_enable_2, p0_.is_contact AS is_contact_3, p1_.name AS name_4, p1_.slug AS slug_5, p1_.description AS description_6, p0_.classe_titre_contact AS classe_titre_contact_7, p0_.link_visiter_site AS link_visiter_site_8, p0_.classe_body_page AS classe_body_page_9, p0_.is_demo AS is_demo_10 FROM page p0_ LEFT JOIN page_lang p1_ ON p0_.id = p1_.page_id AND (p1_.language_id = ?) WHERE (p0_.deleted_at IS NULL AND p0_.is_enable = 1) AND p0_.id IN (?, ?, ?, ?) ORDER BY p0_.id ASC
Parameters:
[ 1 "10" "8" "5" "4" ] |
18 | 0.76 ms |
SELECT p0_.slug AS slug_0, p1_.id AS id_1, p0_.name AS name_2 FROM page_lang p0_ INNER JOIN page p1_ ON p0_.page_id = p1_.id WHERE p0_.language_id = ? AND p1_.parent_id = ?
Parameters:
[ 1 "10" ] |
19 | 0.51 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_actif AS is_actif_4, t0.is_default AS is_default_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8 FROM languages t0 WHERE t0.deleted_at IS NULL AND t0.is_actif = ?
Parameters:
[
1
]
|
20 | 0.65 ms |
SELECT t0.id AS id_1, t0.the_key AS the_key_2, t0.the_value AS the_value_3, t0.updated_at AS updated_at_4 FROM configs t0 WHERE t0.the_key = ? LIMIT 1
Parameters:
[
"show_consentement"
]
|
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\Languages | No errors. |
App\Entity\ClientBlocs\ClientBlocLang | No errors. |
App\Entity\Labels\LabelBlocLang | No errors. |
App\Entity\Labels\LabelSliderLang | No errors. |
App\Entity\ItemsSolution\ItemsSolutionLang | No errors. |
App\Entity\Benefice\BeneficeLang | No errors. |
App\Entity\Benefice\BeneficeItemsLang | No errors. |
App\Entity\Pages\PageSousCategoryLang | No errors. |
App\Entity\User\UserStatusLang | No errors. |
App\Entity\Pages\PageCategoryLang | No errors. |
App\Entity\Pages\PageCategory | No errors. |
App\Entity\Pages\PageLang | No errors. |
App\Entity\Pages\Page | No errors. |
App\Entity\Medias\Media | No errors. |
App\Entity\Blocs\Bloc |
|
App\Entity\Blocs\BlocLang | No errors. |
App\Entity\ClientBlocs\ClientBloc | No errors. |
App\Entity\Labels\LabelBloc | No errors. |
App\Entity\Labels\LabelSlider | No errors. |
App\Entity\Carrousel\carrousel | No errors. |
App\Entity\Carrousel\carrouselLang | No errors. |
App\Entity\Carrousel\carrouselItems | No errors. |
App\Entity\Carrousel\carrouselItemsLang | No errors. |
App\Entity\Benefice\Benefice | No errors. |
App\Entity\Benefice\BeneficeItems | No errors. |
App\Entity\Pages\PaletteColor | No errors. |
App\Entity\Pages\PageSousCategory | No errors. |
App\Entity\Seo\Seo | No errors. |
App\Entity\Seo\SeoLang | No errors. |
App\Entity\Config\Configs | No errors. |