Query Metrics
24
Database Queries
22
Different statements
97.07 ms
Query time
1
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
22.36 ms (23.03%) |
1 |
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 ] |
17.68 ms (18.21%) |
1 |
SELECT b0_.id AS id_0, b1_.id AS id_1, i2_.id AS id_2, i3_.description AS description_3, i2_.classe AS classe_4, m4_.id AS id_5, m4_.file AS file_6, m4_.path AS path_7, m4_.title AS title_8 FROM bloc_solution b0_ LEFT JOIN bloc b1_ ON b0_.bloc_id = b1_.id LEFT JOIN bloc_lang b5_ ON b1_.id = b5_.bloc_id AND (b5_.language_id = ?) LEFT JOIN items_solution i2_ ON b0_.item_solution_id = i2_.id LEFT JOIN media m4_ ON (m4_.id_origin = i2_.id AND m4_.origin = ? AND m4_.language_id = ?) LEFT JOIN items_solution_lang i3_ ON i2_.id = i3_.item_solution_id AND (i3_.language_id = ?) WHERE i2_.deleted_at IS NULL AND b0_.bloc_id IN (?) ORDER BY b0_.position ASC
Parameters:
[ 1 "App\Entity\ItemsSolution\ItemsSolution" 1 1 100 ] |
12.08 ms (12.45%) |
1 |
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 ] |
9.37 ms (9.65%) |
1 |
SELECT p0_.id AS id_0, p0_.created_at AS created_at_1, p0_.is_enable AS is_enable_2, p1_.name AS name_3, p1_.slug AS slug_4, p1_.description AS description_5, p2_.name AS name_6, p3_.id AS id_7, p2_.slug AS slug_8 FROM page_sous_category p0_ LEFT JOIN page_sous_category_lang p1_ ON p0_.id = p1_.pagesouscategory_id AND (p1_.language_id = ?) LEFT JOIN page_category p3_ ON p0_.category_id = p3_.id LEFT JOIN page_category_lang p2_ ON p3_.id = p2_.page_category_id AND (p2_.language_id = ?) WHERE p0_.deleted_at IS NULL AND p0_.is_enable = ? AND p3_.deleted_at IS NULL AND p3_.is_enable = 1 AND p3_.id = (?) ORDER BY p0_.id ASC
Parameters:
[ 1 1 1 1 ] |
8.19 ms (8.44%) |
1 |
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\PageCategory" 1 ] |
6.18 ms (6.37%) |
1 |
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 ] |
3.66 ms (3.77%) |
1 |
SELECT t0.id AS id_1, t0.type AS type_2, t0.is_enable AS is_enable_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6 FROM page_category t0 WHERE t0.id = ?
Parameters:
[
1
]
|
2.95 ms (3.04%) |
1 |
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, p2_.id AS id_11, p2_.type AS type_12, p3_.is_enable AS is_enable_13, m4_.id AS id_14, m4_.file AS file_15, m4_.path AS path_16, m4_.type AS type_17 FROM page p0_ LEFT JOIN page_lang p1_ ON p0_.id = p1_.page_id AND (p1_.language_id = ?) LEFT JOIN media m4_ ON (m4_.id_origin = p0_.id AND m4_.origin = ? AND m4_.language_id = ?) LEFT JOIN page_sous_category p3_ ON p0_.page_sous_category_id = p3_.id LEFT JOIN page_category p2_ ON p3_.category_id = p2_.id LEFT JOIN page_sous_category_lang p5_ ON p3_.id = p5_.pagesouscategory_id AND (p5_.language_id = ?) LEFT JOIN page_category_lang p6_ ON p2_.id = p6_.page_category_id AND (p6_.language_id = ?) WHERE (p0_.deleted_at IS NULL AND p0_.is_enable = 1) AND p0_.is_enable = ? AND (p3_.deleted_at IS NULL AND p3_.is_enable = 1) ORDER BY p0_.id ASC
Parameters:
[ 1 "App\Entity\Pages\Page" 1 1 1 1 ] |
2.73 ms (2.81%) |
3 |
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.10 ms (2.16%) |
1 |
SELECT t0.id AS id_1, t0.origin AS origin_2, t0.id_origin AS id_origin_3, t0.file AS file_4, t0.extension AS extension_5, t0.taille AS taille_6, t0.path AS path_7, t0.title AS title_8, t0.position AS position_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.deleted_at AS deleted_at_12, t0.type AS type_13, t0.language_id AS language_id_14 FROM media t0 WHERE t0.id_origin = ? AND t0.origin = ? AND t0.deleted_at IS NULL
Parameters:
[ 1 "Proxies\__CG__\App\Entity\Pages\PageCategory" ] |
1.79 ms (1.85%) |
1 |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.description AS description_3, t0.name AS name_4, t0.language_id AS language_id_5, t0.page_category_id AS page_category_id_6 FROM page_category_lang t0 WHERE t0.language_id = ? AND t0.slug = ? LIMIT 1
Parameters:
[ 1 "references" ] |
1.28 ms (1.31%) |
1 |
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" ] |
0.95 ms (0.98%) |
1 |
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" ] |
0.89 ms (0.91%) |
1 |
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" ] |
0.86 ms (0.88%) |
1 |
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_category_show" "references" ] |
0.76 ms (0.78%) |
1 |
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" ] |
0.67 ms (0.69%) |
1 |
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\PageCategory" 1 ] |
0.65 ms (0.67%) |
1 |
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:
[ 6 1 ] |
0.60 ms (0.62%) |
1 |
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" ] |
0.54 ms (0.55%) |
1 |
SELECT p0_.id AS id_0, p0_.created_at AS created_at_1, p0_.is_enable AS is_enable_2, p1_.name AS name_3, p1_.slug AS slug_4, p1_.description AS description_5 FROM page_category p0_ LEFT JOIN page_category_lang p1_ ON p0_.id = p1_.page_category_id AND (p1_.language_id = ?) WHERE p0_.deleted_at IS NULL AND p0_.id = ? ORDER BY p0_.id ASC
Parameters:
[ 1 1 ] |
0.41 ms (0.42%) |
1 |
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"
]
|
0.38 ms (0.40%) |
1 |
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
]
|
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\Pages\PageSousCategory | No errors. |
App\Entity\Pages\PaletteColor | 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\Blocs\BlocSolution | No errors. |
App\Entity\ItemsSolution\ItemsSolution | No errors. |
App\Entity\Seo\Seo | No errors. |
App\Entity\Seo\SeoLang | No errors. |
App\Entity\Config\Configs | No errors. |