Symfony Profiler

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  app
FROM
  system_settings
WHERE
  designation = ?

SELECT app FROM system_settings WHERE designation = 'system';

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
  DATABASE()

SELECT DATABASE();

SELECT
  app
FROM
  system_settings
WHERE
  designation = ?

SELECT app FROM system_settings WHERE designation = 'system';

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.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 = 'robots.txt' 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 = ?
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 = 'robots.txt' LIMIT 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, ?) = 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.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
  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 < 8
  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 < 8 AND m0_.lft > 1 AND m0_.tree_root = 1 ORDER BY m0_.tree_root ASC, m0_.lft ASC;

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
  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 < 8
  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 < 8 AND m0_.lft > 1 AND m0_.tree_root = 1 ORDER BY m0_.tree_root ASC, m0_.lft ASC;

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;