Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.site_slug AS site_slug_2,
  t0.route_name AS route_name_3,
  t0.site_content AS site_content_4,
  t0.site_date AS site_date_5,
  t0.site_excerpt AS site_excerpt_6,
  t0.site_status AS site_status_7,
  t0.comment_status AS comment_status_8,
  t0.site_type AS site_type_9,
  t0.site_img AS site_img_10,
  t0.site_user AS site_user_11,
  t0.site_password AS site_password_12,
  t0.excerpt_limit AS excerpt_limit_13,
  t0.extra_css AS extra_css_14,
  t0.position AS position_15,
  t0.header AS header_16,
  t0.footer AS footer_17,
  t0.builder_active AS builder_active_18,
  t0.custom AS custom_19,
  t0.form_builder AS form_builder_20,
  t0.siteSeo AS siteSeo_21,
  t0.site_category_id AS site_category_id_22
FROM
  app_sites t0
WHERE
  t0.site_slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.site_slug AS site_slug_2, t0.route_name AS route_name_3, t0.site_content AS site_content_4, t0.site_date AS site_date_5, t0.site_excerpt AS site_excerpt_6, t0.site_status AS site_status_7, t0.comment_status AS comment_status_8, t0.site_type AS site_type_9, t0.site_img AS site_img_10, t0.site_user AS site_user_11, t0.site_password AS site_password_12, t0.excerpt_limit AS excerpt_limit_13, t0.extra_css AS extra_css_14, t0.position AS position_15, t0.header AS header_16, t0.footer AS footer_17, t0.builder_active AS builder_active_18, t0.custom AS custom_19, t0.form_builder AS form_builder_20, t0.siteSeo AS siteSeo_21, t0.site_category_id AS site_category_id_22 FROM app_sites t0 WHERE t0.site_slug = 'test' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.url AS url_4,
  t0.type AS type_5,
  t0.css_class AS css_class_6,
  t0.attr AS attr_7,
  t0.new_tab AS new_tab_8,
  t0.xfn AS xfn_9,
  t0.active AS active_10,
  t0.show_login AS show_login_11,
  t0.show_not_login AS show_not_login_12,
  t0.position AS position_13,
  t0.lft AS lft_14,
  t0.lvl AS lvl_15,
  t0.rgt AS rgt_16,
  t0.original_title AS original_title_17,
  t0.site AS site_18,
  t0.category AS category_19,
  t0.tree_root AS tree_root_20,
  t0.parent_id AS parent_id_21,
  t0.menu_category_id AS menu_category_id_22
FROM
  menu t0
WHERE
  t0.menu_category_id = ?
  AND t0.lvl = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.url AS url_4, t0.type AS type_5, t0.css_class AS css_class_6, t0.attr AS attr_7, t0.new_tab AS new_tab_8, t0.xfn AS xfn_9, t0.active AS active_10, t0.show_login AS show_login_11, t0.show_not_login AS show_not_login_12, t0.position AS position_13, t0.lft AS lft_14, t0.lvl AS lvl_15, t0.rgt AS rgt_16, t0.original_title AS original_title_17, t0.site AS site_18, t0.category AS category_19, t0.tree_root AS tree_root_20, t0.parent_id AS parent_id_21, t0.menu_category_id AS menu_category_id_22 FROM menu t0 WHERE t0.menu_category_id = 1 AND t0.lvl = 0 LIMIT 1;

SELECT
  m0_.id AS id_0,
  m0_.title AS title_1,
  m0_.description AS description_2,
  m0_.url AS url_3,
  m0_.type AS type_4,
  m0_.css_class AS css_class_5,
  m0_.attr AS attr_6,
  m0_.new_tab AS new_tab_7,
  m0_.xfn AS xfn_8,
  m0_.active AS active_9,
  m0_.show_login AS show_login_10,
  m0_.show_not_login AS show_not_login_11,
  m0_.position AS position_12,
  m0_.lft AS lft_13,
  m0_.lvl AS lvl_14,
  m0_.rgt AS rgt_15,
  m0_.original_title AS original_title_16,
  m0_.site AS site_17,
  m0_.category AS category_18
FROM
  menu m0_
WHERE
  m0_.rgt < 6
  AND m0_.lft > 1
  AND m0_.tree_root = ?
ORDER BY
  m0_.tree_root ASC,
  m0_.lft ASC

SELECT m0_.id AS id_0, m0_.title AS title_1, m0_.description AS description_2, m0_.url AS url_3, m0_.type AS type_4, m0_.css_class AS css_class_5, m0_.attr AS attr_6, m0_.new_tab AS new_tab_7, m0_.xfn AS xfn_8, m0_.active AS active_9, m0_.show_login AS show_login_10, m0_.show_not_login AS show_not_login_11, m0_.position AS position_12, m0_.lft AS lft_13, m0_.lvl AS lvl_14, m0_.rgt AS rgt_15, m0_.original_title AS original_title_16, m0_.site AS site_17, m0_.category AS category_18 FROM menu m0_ WHERE m0_.rgt < 6 AND m0_.lft > 1 AND m0_.tree_root = 1 ORDER BY m0_.tree_root ASC, m0_.lft ASC;

SELECT
  u0_.id AS id_0,
  u0_.uuid AS uuid_1,
  u0_.email AS email_2,
  u0_.roles AS roles_3,
  u0_.password AS password_4,
  u0_.is_verified AS is_verified_5,
  u0_.totp_secret AS totp_secret_6
FROM
  user u0_
WHERE
  JSON_CONTAINS(u0_.roles, ?) = 1

SELECT u0_.id AS id_0, u0_.uuid AS uuid_1, u0_.email AS email_2, u0_.roles AS roles_3, u0_.password AS password_4, u0_.is_verified AS is_verified_5, u0_.totp_secret AS totp_secret_6 FROM user u0_ WHERE JSON_CONTAINS(u0_.roles, '\"ROLE_SUPER_ADMIN\"') = 1;

SELECT
  t0.id AS id_1,
  t0.seo_title AS seo_title_2,
  t0.seo_content AS seo_content_3,
  t0.no_index AS no_index_4,
  t0.no_follow AS no_follow_5,
  t0.fb_active AS fb_active_6,
  t0.og_type AS og_type_7,
  t0.og_title AS og_title_8,
  t0.og_content AS og_content_9,
  t0.og_image AS og_image_10,
  t0.x_active AS x_active_11,
  t0.x_type AS x_type_12,
  t0.x_site AS x_site_13,
  t0.x_creator AS x_creator_14,
  t0.fb_app_id AS fb_app_id_15,
  t0.fb_admins AS fb_admins_16,
  t0.title_prefix AS title_prefix_17,
  t0.title_suffix AS title_suffix_18,
  t0.title_separator AS title_separator_19,
  t0.reading_time AS reading_time_20,
  t0.created_at AS created_at_21,
  t0.last_update AS last_update_22,
  t23.id AS id_24,
  t23.site_slug AS site_slug_25,
  t23.route_name AS route_name_26,
  t23.site_content AS site_content_27,
  t23.site_date AS site_date_28,
  t23.site_excerpt AS site_excerpt_29,
  t23.site_status AS site_status_30,
  t23.comment_status AS comment_status_31,
  t23.site_type AS site_type_32,
  t23.site_img AS site_img_33,
  t23.site_user AS site_user_34,
  t23.site_password AS site_password_35,
  t23.excerpt_limit AS excerpt_limit_36,
  t23.extra_css AS extra_css_37,
  t23.position AS position_38,
  t23.header AS header_39,
  t23.footer AS footer_40,
  t23.builder_active AS builder_active_41,
  t23.custom AS custom_42,
  t23.form_builder AS form_builder_43,
  t23.siteSeo AS siteSeo_44,
  t23.site_category_id AS site_category_id_45,
  t46.id AS id_47,
  t46.post_content AS post_content_48,
  t46.post_date AS post_date_49,
  t46.post_excerpt AS post_excerpt_50,
  t46.comment_status AS comment_status_51,
  t46.site_type AS site_type_52,
  t46.site_img AS site_img_53,
  t46.excerpt_limit AS excerpt_limit_54,
  t46.extra_css AS extra_css_55,
  t46.position AS position_56,
  t46.post_status AS post_status_57,
  t46.builder AS builder_58,
  t46.post_slug AS post_slug_59,
  t46.header AS header_60,
  t46.footer AS footer_61,
  t46.post_gallery AS post_gallery_62,
  t46.siteSeo AS siteSeo_63,
  t46.post_category_id AS post_category_id_64
FROM
  site_seo t0
  LEFT JOIN app_sites t23 ON t23.siteSeo = t0.id
  LEFT JOIN post_sites t46 ON t46.siteSeo = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.seo_title AS seo_title_2, t0.seo_content AS seo_content_3, t0.no_index AS no_index_4, t0.no_follow AS no_follow_5, t0.fb_active AS fb_active_6, t0.og_type AS og_type_7, t0.og_title AS og_title_8, t0.og_content AS og_content_9, t0.og_image AS og_image_10, t0.x_active AS x_active_11, t0.x_type AS x_type_12, t0.x_site AS x_site_13, t0.x_creator AS x_creator_14, t0.fb_app_id AS fb_app_id_15, t0.fb_admins AS fb_admins_16, t0.title_prefix AS title_prefix_17, t0.title_suffix AS title_suffix_18, t0.title_separator AS title_separator_19, t0.reading_time AS reading_time_20, t0.created_at AS created_at_21, t0.last_update AS last_update_22, t23.id AS id_24, t23.site_slug AS site_slug_25, t23.route_name AS route_name_26, t23.site_content AS site_content_27, t23.site_date AS site_date_28, t23.site_excerpt AS site_excerpt_29, t23.site_status AS site_status_30, t23.comment_status AS comment_status_31, t23.site_type AS site_type_32, t23.site_img AS site_img_33, t23.site_user AS site_user_34, t23.site_password AS site_password_35, t23.excerpt_limit AS excerpt_limit_36, t23.extra_css AS extra_css_37, t23.position AS position_38, t23.header AS header_39, t23.footer AS footer_40, t23.builder_active AS builder_active_41, t23.custom AS custom_42, t23.form_builder AS form_builder_43, t23.siteSeo AS siteSeo_44, t23.site_category_id AS site_category_id_45, t46.id AS id_47, t46.post_content AS post_content_48, t46.post_date AS post_date_49, t46.post_excerpt AS post_excerpt_50, t46.comment_status AS comment_status_51, t46.site_type AS site_type_52, t46.site_img AS site_img_53, t46.excerpt_limit AS excerpt_limit_54, t46.extra_css AS extra_css_55, t46.position AS position_56, t46.post_status AS post_status_57, t46.builder AS builder_58, t46.post_slug AS post_slug_59, t46.header AS header_60, t46.footer AS footer_61, t46.post_gallery AS post_gallery_62, t46.siteSeo AS siteSeo_63, t46.post_category_id AS post_category_id_64 FROM site_seo t0 LEFT JOIN app_sites t23 ON t23.siteSeo = t0.id LEFT JOIN post_sites t46 ON t46.siteSeo = t0.id WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.version AS version_2,
  t0.designation AS designation_3,
  t0.app AS app_4,
  t0.email AS email_5,
  t0.log AS log_6,
  t0.oauth AS oauth_7,
  t0.register AS register_8,
  t0.design AS design_9
FROM
  system_settings t0
WHERE
  t0.designation = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.version AS version_2, t0.designation AS designation_3, t0.app AS app_4, t0.email AS email_5, t0.log AS log_6, t0.oauth AS oauth_7, t0.register AS register_8, t0.design AS design_9 FROM system_settings t0 WHERE t0.designation = 'system' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.title AS title_3,
  t0.description AS description_4,
  t0.position AS position_5,
  t0.active AS active_6,
  t0.type AS type_7,
  t0.menu_settings AS menu_settings_8
FROM
  menu_category t0
WHERE
  t0.type = ?
  AND t0.active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.title AS title_3, t0.description AS description_4, t0.position AS position_5, t0.active AS active_6, t0.type AS type_7, t0.menu_settings AS menu_settings_8 FROM menu_category t0 WHERE t0.type = 'main' AND t0.active = 1 LIMIT 1;

SELECT
  app
FROM
  system_settings
WHERE
  designation = ?

SELECT app FROM system_settings WHERE designation = 'system';

SELECT
  DATABASE()

SELECT DATABASE();