Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.uri_test AS uri_test_3,
  t0.db_name_test AS db_name_test_4,
  t0.db_user_test AS db_user_test_5,
  t0.db_password_test AS db_password_test_6,
  t0.uri_prod AS uri_prod_7,
  t0.db_name_prod AS db_name_prod_8,
  t0.db_user_prod AS db_user_prod_9,
  t0.db_password_prod AS db_password_prod_10,
  t0.css_path_test AS css_path_test_11,
  t0.css_path_prod AS css_path_prod_12,
  t0.deepl_api_key AS deepl_api_key_13,
  t0.jwt_passcode AS jwt_passcode_14,
  t0.ico AS ico_15
FROM
  project t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.uri_test AS uri_test_3, t0.db_name_test AS db_name_test_4, t0.db_user_test AS db_user_test_5, t0.db_password_test AS db_password_test_6, t0.uri_prod AS uri_prod_7, t0.db_name_prod AS db_name_prod_8, t0.db_user_prod AS db_user_prod_9, t0.db_password_prod AS db_password_prod_10, t0.css_path_test AS css_path_test_11, t0.css_path_prod AS css_path_prod_12, t0.deepl_api_key AS deepl_api_key_13, t0.jwt_passcode AS jwt_passcode_14, t0.ico AS ico_15 FROM project t0 WHERE t0.id = 25;

SELECT
  l0_.id AS id_0,
  l0_.name AS name_1,
  l0_.locale AS locale_2,
  l0_.is_right_to_left AS is_right_to_left_3,
  l0_.short AS short_4,
  l1_.is_default AS is_default_5,
  l0_.id AS id_6
FROM
  language l0_
  INNER JOIN language_project l1_ ON l0_.id = l1_.language_id
WHERE
  l1_.project_id = ?

SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.locale AS locale_2, l0_.is_right_to_left AS is_right_to_left_3, l0_.short AS short_4, l1_.is_default AS is_default_5, l0_.id AS id_6 FROM language l0_ INNER JOIN language_project l1_ ON l0_.id = l1_.language_id WHERE l1_.project_id = 25;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.password AS password_3,
  t0.name AS name_4,
  t0.phone AS phone_5,
  t0.is_greendot AS is_greendot_6
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.name AS name_4, t0.phone AS phone_5, t0.is_greendot AS is_greendot_6 FROM user t0 WHERE t0.id = 11;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.uri_test AS uri_test_3,
  t0.db_name_test AS db_name_test_4,
  t0.db_user_test AS db_user_test_5,
  t0.db_password_test AS db_password_test_6,
  t0.uri_prod AS uri_prod_7,
  t0.db_name_prod AS db_name_prod_8,
  t0.db_user_prod AS db_user_prod_9,
  t0.db_password_prod AS db_password_prod_10,
  t0.css_path_test AS css_path_test_11,
  t0.css_path_prod AS css_path_prod_12,
  t0.deepl_api_key AS deepl_api_key_13,
  t0.jwt_passcode AS jwt_passcode_14,
  t0.ico AS ico_15
FROM
  project t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.uri_test AS uri_test_3, t0.db_name_test AS db_name_test_4, t0.db_user_test AS db_user_test_5, t0.db_password_test AS db_password_test_6, t0.uri_prod AS uri_prod_7, t0.db_name_prod AS db_name_prod_8, t0.db_user_prod AS db_user_prod_9, t0.db_password_prod AS db_password_prod_10, t0.css_path_test AS css_path_test_11, t0.css_path_prod AS css_path_prod_12, t0.deepl_api_key AS deepl_api_key_13, t0.jwt_passcode AS jwt_passcode_14, t0.ico AS ico_15 FROM project t0;

SELECT
  CASE WHEN c0_.sequence IS NULL THEN
    0
  ELSE
    1
  END AS sclr_0,
  p1_.id AS id_1,
  p1_.name AS name_2,
  p1_.menu_name AS menu_name_3,
  p1_.description AS description_4,
  p1_.html AS html_5,
  p1_.title AS title_6,
  p1_.is_active AS is_active_7,
  p1_.slug AS slug_8,
  p1_.javascript AS javascript_9,
  p1_.sequence AS sequence_10,
  p1_.is_menu AS is_menu_11,
  p1_.latitude AS latitude_12,
  p1_.longitude AS longitude_13,
  p1_.state AS state_14,
  p1_.has_comments AS has_comments_15,
  p1_.is_indexable AS is_indexable_16,
  p1_.created_at AS created_at_17,
  p1_.published_at AS published_at_18,
  c0_.id AS id_19,
  c0_.sequence AS sequence_20,
  p2_.id AS id_21,
  p2_.name AS name_22,
  l3_.id AS id_23,
  l3_.name AS name_24,
  l3_.color AS color_25,
  c4_.id AS id_26,
  c4_.name AS name_27,
  c4_.template AS template_28,
  c4_.slug_prefix AS slug_prefix_29,
  u5_.id AS id_30,
  u5_.name AS name_31,
  u5_.extension AS extension_32,
  u5_.mime AS mime_33,
  u5_.title AS title_34,
  u5_.short_description AS short_description_35,
  u5_.description AS description_36,
  u5_.created AS created_37,
  u5_.path AS path_38,
  u5_.original_name AS original_name_39,
  u5_.width AS width_40,
  u5_.height AS height_41,
  u5_.sequence AS sequence_42,
  m6_.id AS id_43,
  m6_.name AS name_44,
  m6_.template AS template_45,
  m6_.controller_name AS controller_name_46,
  s7_.id AS id_47,
  s7_.name AS name_48,
  s7_.template AS template_49,
  s7_.controller_name AS controller_name_50,
  p1_.category_type_id AS category_type_id_51,
  p1_.upload_id AS upload_id_52,
  c0_.category_id AS category_id_53,
  c0_.menu_type_id AS menu_type_id_54,
  p2_.label_type_id AS label_type_id_55,
  u5_.upload_group_id AS upload_group_id_56,
  u5_.upload_type_id AS upload_type_id_57
FROM
  p_category p1_
  LEFT JOIN p_category_category p8_ ON p1_.id = p8_.category_sub_id
  LEFT JOIN category_menu_type c0_ ON p1_.id = c0_.category_id
  LEFT JOIN category_label c9_ ON p1_.id = c9_.category_id
  LEFT JOIN p_label p2_ ON p2_.id = c9_.label_id
  LEFT JOIN label_type l3_ ON p2_.label_type_id = l3_.id
  LEFT JOIN category_type c4_ ON p1_.category_type_id = c4_.id
  LEFT JOIN upload u5_ ON p1_.upload_id = u5_.id
  LEFT JOIN menu_type m6_ ON c0_.menu_type_id = m6_.id
  LEFT JOIN category_sub_menu_type c10_ ON p1_.id = c10_.category_id
  LEFT JOIN sub_menu_type s7_ ON s7_.id = c10_.sub_menu_type_id
WHERE
  p1_.id IN (
    SELECT
      p11_.id
    FROM
      p_category p11_
      LEFT JOIN p_category_category p12_ ON p11_.id = p12_.category_sub_id
      LEFT JOIN category_menu_type c13_ ON p11_.id = c13_.category_id
    WHERE
      p8_.id IS NULL
      AND c13_.menu_type_id = ?
      AND p11_.id > ?
  )
ORDER BY
  p8_.sequence ASC,
  sclr_0 DESC,
  c0_.sequence ASC

SELECT CASE WHEN c0_.sequence IS NULL THEN 0 ELSE 1 END AS sclr_0, p1_.id AS id_1, p1_.name AS name_2, p1_.menu_name AS menu_name_3, p1_.description AS description_4, p1_.html AS html_5, p1_.title AS title_6, p1_.is_active AS is_active_7, p1_.slug AS slug_8, p1_.javascript AS javascript_9, p1_.sequence AS sequence_10, p1_.is_menu AS is_menu_11, p1_.latitude AS latitude_12, p1_.longitude AS longitude_13, p1_.state AS state_14, p1_.has_comments AS has_comments_15, p1_.is_indexable AS is_indexable_16, p1_.created_at AS created_at_17, p1_.published_at AS published_at_18, c0_.id AS id_19, c0_.sequence AS sequence_20, p2_.id AS id_21, p2_.name AS name_22, l3_.id AS id_23, l3_.name AS name_24, l3_.color AS color_25, c4_.id AS id_26, c4_.name AS name_27, c4_.template AS template_28, c4_.slug_prefix AS slug_prefix_29, u5_.id AS id_30, u5_.name AS name_31, u5_.extension AS extension_32, u5_.mime AS mime_33, u5_.title AS title_34, u5_.short_description AS short_description_35, u5_.description AS description_36, u5_.created AS created_37, u5_.path AS path_38, u5_.original_name AS original_name_39, u5_.width AS width_40, u5_.height AS height_41, u5_.sequence AS sequence_42, m6_.id AS id_43, m6_.name AS name_44, m6_.template AS template_45, m6_.controller_name AS controller_name_46, s7_.id AS id_47, s7_.name AS name_48, s7_.template AS template_49, s7_.controller_name AS controller_name_50, p1_.category_type_id AS category_type_id_51, p1_.upload_id AS upload_id_52, c0_.category_id AS category_id_53, c0_.menu_type_id AS menu_type_id_54, p2_.label_type_id AS label_type_id_55, u5_.upload_group_id AS upload_group_id_56, u5_.upload_type_id AS upload_type_id_57 FROM p_category p1_ LEFT JOIN p_category_category p8_ ON p1_.id = p8_.category_sub_id LEFT JOIN category_menu_type c0_ ON p1_.id = c0_.category_id LEFT JOIN category_label c9_ ON p1_.id = c9_.category_id LEFT JOIN p_label p2_ ON p2_.id = c9_.label_id LEFT JOIN label_type l3_ ON p2_.label_type_id = l3_.id LEFT JOIN category_type c4_ ON p1_.category_type_id = c4_.id LEFT JOIN upload u5_ ON p1_.upload_id = u5_.id LEFT JOIN menu_type m6_ ON c0_.menu_type_id = m6_.id LEFT JOIN category_sub_menu_type c10_ ON p1_.id = c10_.category_id LEFT JOIN sub_menu_type s7_ ON s7_.id = c10_.sub_menu_type_id WHERE p1_.id IN (SELECT p11_.id FROM p_category p11_ LEFT JOIN p_category_category p12_ ON p11_.id = p12_.category_sub_id LEFT JOIN category_menu_type c13_ ON p11_.id = c13_.category_id WHERE p8_.id IS NULL AND c13_.menu_type_id = '1' AND p11_.id > 10) ORDER BY p8_.sequence ASC, sclr_0 DESC, c0_.sequence ASC;

SELECT
  t0.id AS id_1,
  t0.sequence AS sequence_2,
  t0.is_menu_item AS is_menu_item_3,
  t0.category_super_id AS category_super_id_4,
  t0.category_sub_id AS category_sub_id_5
FROM
  p_category_category t0
WHERE
  t0.category_super_id = ?
ORDER BY
  t0.sequence ASC

SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.is_menu_item AS is_menu_item_3, t0.category_super_id AS category_super_id_4, t0.category_sub_id AS category_sub_id_5 FROM p_category_category t0 WHERE t0.category_super_id = 13 ORDER BY t0.sequence ASC;

SELECT
  t0.id AS id_1,
  t0.sequence AS sequence_2,
  t0.is_menu_item AS is_menu_item_3,
  t0.category_super_id AS category_super_id_4,
  t0.category_sub_id AS category_sub_id_5
FROM
  p_category_category t0
WHERE
  t0.category_sub_id = ?
ORDER BY
  t0.sequence ASC

SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.is_menu_item AS is_menu_item_3, t0.category_super_id AS category_super_id_4, t0.category_sub_id AS category_sub_id_5 FROM p_category_category t0 WHERE t0.category_sub_id = 13 ORDER BY t0.sequence ASC;

SELECT
  t0.id AS id_1,
  t0.sequence AS sequence_2,
  t0.is_menu_item AS is_menu_item_3,
  t0.category_super_id AS category_super_id_4,
  t0.category_sub_id AS category_sub_id_5
FROM
  p_category_category t0
WHERE
  t0.category_super_id = ?
ORDER BY
  t0.sequence ASC

SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.is_menu_item AS is_menu_item_3, t0.category_super_id AS category_super_id_4, t0.category_sub_id AS category_sub_id_5 FROM p_category_category t0 WHERE t0.category_super_id = 100 ORDER BY t0.sequence ASC;

SELECT
  t0.id AS id_1,
  t0.sequence AS sequence_2,
  t0.is_menu_item AS is_menu_item_3,
  t0.category_super_id AS category_super_id_4,
  t0.category_sub_id AS category_sub_id_5
FROM
  p_category_category t0
WHERE
  t0.category_sub_id = ?
ORDER BY
  t0.sequence ASC

SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.is_menu_item AS is_menu_item_3, t0.category_super_id AS category_super_id_4, t0.category_sub_id AS category_sub_id_5 FROM p_category_category t0 WHERE t0.category_sub_id = 100 ORDER BY t0.sequence ASC;

SELECT
  t0.id AS id_1,
  t0.sequence AS sequence_2,
  t0.is_menu_item AS is_menu_item_3,
  t0.category_super_id AS category_super_id_4,
  t0.category_sub_id AS category_sub_id_5
FROM
  p_category_category t0
WHERE
  t0.category_super_id = ?
ORDER BY
  t0.sequence ASC

SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.is_menu_item AS is_menu_item_3, t0.category_super_id AS category_super_id_4, t0.category_sub_id AS category_sub_id_5 FROM p_category_category t0 WHERE t0.category_super_id = 15 ORDER BY t0.sequence ASC;

SELECT
  t0.id AS id_1,
  t0.sequence AS sequence_2,
  t0.is_menu_item AS is_menu_item_3,
  t0.category_super_id AS category_super_id_4,
  t0.category_sub_id AS category_sub_id_5
FROM
  p_category_category t0
WHERE
  t0.category_sub_id = ?
ORDER BY
  t0.sequence ASC

SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.is_menu_item AS is_menu_item_3, t0.category_super_id AS category_super_id_4, t0.category_sub_id AS category_sub_id_5 FROM p_category_category t0 WHERE t0.category_sub_id = 15 ORDER BY t0.sequence ASC;

SELECT
  t0.id AS id_1,
  t0.sequence AS sequence_2,
  t0.is_menu_item AS is_menu_item_3,
  t0.category_super_id AS category_super_id_4,
  t0.category_sub_id AS category_sub_id_5
FROM
  p_category_category t0
WHERE
  t0.category_super_id = ?
ORDER BY
  t0.sequence ASC

SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.is_menu_item AS is_menu_item_3, t0.category_super_id AS category_super_id_4, t0.category_sub_id AS category_sub_id_5 FROM p_category_category t0 WHERE t0.category_super_id = 11 ORDER BY t0.sequence ASC;

SELECT
  t0.id AS id_1,
  t0.sequence AS sequence_2,
  t0.is_menu_item AS is_menu_item_3,
  t0.category_super_id AS category_super_id_4,
  t0.category_sub_id AS category_sub_id_5
FROM
  p_category_category t0
WHERE
  t0.category_sub_id = ?
ORDER BY
  t0.sequence ASC

SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.is_menu_item AS is_menu_item_3, t0.category_super_id AS category_super_id_4, t0.category_sub_id AS category_sub_id_5 FROM p_category_category t0 WHERE t0.category_sub_id = 11 ORDER BY t0.sequence ASC;