Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.name AS name_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.category_id AS category_id_6
FROM
  category_translations t0
WHERE
  t0.category_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.category_id AS category_id_6 FROM category_translations t0 WHERE t0.category_id = 'f9f34881-b949-5c03-9d76-8b7078b3f214';

SELECT
  COUNT(*)
FROM
  categories t0
WHERE
  t0.parent_id = ?

SELECT COUNT(*) FROM categories t0 WHERE t0.parent_id = 'f9f34881-b949-5c03-9d76-8b7078b3f214';

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      name_6
    FROM
      (
        SELECT
          c0_.id AS id_0,
          c0_.category_usage AS category_usage_1,
          c0_.created_at AS created_at_2,
          c0_.updated_at AS updated_at_3,
          c1_.id AS id_4,
          c1_.locale AS locale_5,
          c1_.name AS name_6,
          c1_.created_at AS created_at_7,
          c1_.updated_at AS updated_at_8,
          c2_.id AS id_9,
          c2_.locale AS locale_10,
          c2_.name AS name_11,
          c2_.created_at AS created_at_12,
          c2_.updated_at AS updated_at_13
        FROM
          categories c0_
          LEFT JOIN categories c3_ ON c0_.parent_id = c3_.id
          LEFT JOIN category_translations c1_ ON c0_.id = c1_.category_id
          AND (c1_.locale = ?)
          LEFT JOIN category_translations c2_ ON c3_.id = c2_.category_id
          AND (c2_.locale = ?)
        WHERE
          c0_.category_usage IN (?, ?)
      ) dctrn_result_inner
    ORDER BY
      name_6 ASC
  ) dctrn_result
LIMIT
  500

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, name_6 FROM (SELECT c0_.id AS id_0, c0_.category_usage AS category_usage_1, c0_.created_at AS created_at_2, c0_.updated_at AS updated_at_3, c1_.id AS id_4, c1_.locale AS locale_5, c1_.name AS name_6, c1_.created_at AS created_at_7, c1_.updated_at AS updated_at_8, c2_.id AS id_9, c2_.locale AS locale_10, c2_.name AS name_11, c2_.created_at AS created_at_12, c2_.updated_at AS updated_at_13 FROM categories c0_ LEFT JOIN categories c3_ ON c0_.parent_id = c3_.id LEFT JOIN category_translations c1_ ON c0_.id = c1_.category_id AND (c1_.locale = 'es') LEFT JOIN category_translations c2_ ON c3_.id = c2_.category_id AND (c2_.locale = 'es') WHERE c0_.category_usage IN ('product_type', 'all')) dctrn_result_inner ORDER BY name_6 ASC) dctrn_result LIMIT 500;

SELECT
  c0_.id AS id_0,
  c0_.category_usage AS category_usage_1,
  c0_.created_at AS created_at_2,
  c0_.updated_at AS updated_at_3,
  c0_.parent_id AS parent_id_4
FROM
  categories c0_
  LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id
  LEFT JOIN category_translations c2_ ON c0_.id = c2_.category_id
  AND (c2_.locale = ?)
  LEFT JOIN category_translations c3_ ON c1_.id = c3_.category_id
  AND (c3_.locale = ?)
WHERE
  c0_.category_usage IN (?, ?)
  AND c0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  c2_.name ASC

SELECT c0_.id AS id_0, c0_.category_usage AS category_usage_1, c0_.created_at AS created_at_2, c0_.updated_at AS updated_at_3, c0_.parent_id AS parent_id_4 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id LEFT JOIN category_translations c2_ ON c0_.id = c2_.category_id AND (c2_.locale = 'es') LEFT JOIN category_translations c3_ ON c1_.id = c3_.category_id AND (c3_.locale = 'es') WHERE c0_.category_usage IN ('product_type', 'all') AND c0_.id IN ('f9f34881-b949-5c03-9d76-8b7078b3f214', 'b970a2de-7cd3-58a8-a897-1c3b3a6f9f59', 'd42a5c9b-1538-5290-ac49-459bb79102bf', '8c1dc532-1154-520d-b713-ca2b72949a69', '614164e5-8cd0-534a-aa17-4db6519eb4f5', '39e443eb-e19d-50e5-b9c9-cd153a4e58c8', '562648b9-aa06-5ad2-8f61-1210e5285014', 'df414572-2beb-5475-903c-3b3ade758894', 'aee2d0c3-2e56-55b6-b3b8-73707d8a5cca', '42bee7d5-0fcc-5cfa-a288-7a60c5db8a81', 'c315df80-a3d9-5239-8c36-f22ca8f69644', 'e84b69c1-c9ed-5e94-a48c-890de7afe59c', '4e40ccd4-6ac0-52ca-80d9-c614f031f218', '3e9a5060-3032-5641-9600-5b4bc83b1611', '5b3d71de-12d7-54d4-af75-0d4dbf54b513', '0dbac79e-2239-5975-936c-e21c565d09e8', 'c49bba7d-4efd-5803-ae7b-21c0e916c89b', 'a1ecb2f5-b8ab-5c31-a651-395b5fff6e00', 'd448c524-90a2-5faf-b188-dd264d0bc784', '01551d58-0b44-5aba-a8f8-6de4382a9a14', '485b60e4-7121-5166-a9f5-8e3c37d20abb', 'd1cdf323-2646-5f70-8ee5-b321ab182f18', '7467a87a-e714-5433-afc7-a4b626cacdbb', '78c62415-264a-503c-883e-6806b276059a', 'bcfae31e-072d-53d1-acaf-b22bdb874910', '7cf38abb-1f76-5075-87c5-ecabc16301d1', '1e26042e-8592-5d73-bdda-4d56f8799f17', 'f78b9477-8db8-5e64-a639-c1536e5cdf5c', 'ab8598b9-4188-59ce-929f-90b81ac6c147', 'e6c3bb99-9e84-5d4f-b2bb-92c47b662485', '0af60ea6-3c19-5c3f-b52a-c21fbe8a30d4', '97b223ed-0f29-57cb-a3ab-db08453fbde0', '0f4826ac-a8fe-54ac-83d6-15923ddb89f4', '6edbe7d1-1071-522f-b5a8-9f2decfedcc1', '389ad2ba-cfc5-5fda-a901-16939d83ce57', '24751500-969c-54c4-ab3f-a2522f58da03', '1021ed47-5680-52cb-9685-f4a597cc8ffd', '88211d52-7dd5-563e-b074-4a689979d252', '001a3bd9-316d-5ee8-a56d-c52336fba048', '7dc391c6-ba2e-50bc-83a6-aef414c8cca6', 'aca8ebde-837b-5163-a521-8174af28fbad', '138cbe7c-dd6a-5545-bed5-55e3fcdc4f26', 'a4d4e1c1-a57e-55a9-8ac9-124a041704b9', 'e4a4782d-3cec-5bb9-a1ec-626628991464', '531e59f3-3c67-5126-bd69-875bcea801d8', 'aebe69d3-26a9-567c-a06b-712804ffc01c', '22fc30a3-71db-5f92-adac-786cccc67bb9', 'ae9bf236-f40f-50f1-8093-8e64902613c9', 'a2eb3826-eb43-5875-b23f-2261bc11d5e1', '88c1ab3c-6ad6-5f80-ae08-6f1dc2df30f7', 'af7d73df-2040-5ce5-b0a4-d39032f1687f', '305ebeab-a020-565e-9cc1-4132a0bde607', '05675a16-5bab-55ca-8598-7cea11dd12ca', '41cdec7b-8649-5682-8381-00b593131735', 'f7116c55-4f53-514e-8a95-070bbd31f04d', 'f8dc37ba-aa8c-53c5-9b76-31929cd68f05', '4b766873-84af-5996-93cc-19473bfec4e5', 'ae2fac76-6911-530f-9c22-4a09b675070d', '7f1663ad-5c94-5d24-aff8-fb6fd195cc37', '0a6b9d46-15aa-52a6-9536-3f3ba2dd6f52', 'a124d611-9c4e-5dbe-b8e8-3f5560a1f34a', 'f7f8446a-ed24-55af-87f2-f00a96e0c06a', 'f4723bce-09e4-5d50-b3fc-acba7e79d00e', '76ddb6a7-493b-54fe-adaf-4356910561bf', '92b20996-4a46-5649-a2a5-2fe1bb0e1167', '84d93fcc-faa6-5bd0-a99f-4f8a1851959c', 'ae7c0220-06e4-5ee2-8f29-0aa5be259a91', '5b0fd778-1ea3-5a0a-934f-56b7ee0cb58b', '865410b6-b775-5325-b852-c34b416746a7', '85f7b5a0-fe95-5190-81f8-4897eac43fd1', 'e00d1c00-925a-5d48-aaa1-b4c532f0c947', 'd5937a3b-ca11-5b8e-b412-2818ef63d04a', '7b76d8e5-fb41-51b6-8798-6eb27ec2d557', '1fa7f743-9cca-5543-906c-fff5099aaa92', '717c9fad-d613-5e25-a4be-d4834ccb2c69', '83f6d15e-ed7b-585a-981d-ed7938e2804a', '5959f89f-d09f-5f0b-baf6-e8116673cf0e', 'd3ca2530-0f9c-5c58-95cc-afe3ae91885a', 'f4b47972-d335-53aa-a0e6-507910081e17', '27e849e2-82ff-55a7-a31e-4570f6541f76', 'fc97d608-6fa2-51b1-8ad4-9298d7880770', 'dc9fea78-86ba-5b97-a044-b60f69e61f9b', '89cd0741-fc62-59f1-90fe-90aa837ca5bd', '214b00be-a890-51fa-8363-0f1448d1d85e', '6bb66adc-c89a-5272-b7dd-08d5c8911bda', '0e6635e9-1916-5fa2-9b2c-8fd90fe6a704', 'd5ac59c3-84b7-5c15-b06d-0f74cf7519e8', '1f90253f-bda3-55d8-b45a-5c743cc00d04', '51d1760a-f354-521e-9211-28e15c61f904') ORDER BY c2_.name ASC;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.email AS email_3,
  t0.name AS name_4,
  t0.surname AS surname_5,
  t0.roles AS roles_6,
  t0.mobile_phone AS mobile_phone_7,
  t0.address AS address_8,
  t0.city AS city_9,
  t0.zip_code AS zip_code_10,
  t0.state AS state_11,
  t0.country AS country_12,
  t0.price_modifier AS price_modifier_13,
  t0.password AS password_14,
  t0.reset_password_token AS reset_password_token_15,
  t0.locale AS locale_16,
  t0.double_factor_method AS double_factor_method_17,
  t0.auth_code AS auth_code_18,
  t0.google_authenticator_secret AS google_authenticator_secret_19,
  t0.disabled_at AS disabled_at_20,
  t0.last_login_at AS last_login_at_21,
  t0.last_login_ip AS last_login_ip_22,
  t0.previous_login_at AS previous_login_at_23,
  t0.previous_login_ip AS previous_login_ip_24,
  t0.created_at AS created_at_25,
  t0.updated_at AS updated_at_26
FROM
  users t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.name AS name_4, t0.surname AS surname_5, t0.roles AS roles_6, t0.mobile_phone AS mobile_phone_7, t0.address AS address_8, t0.city AS city_9, t0.zip_code AS zip_code_10, t0.state AS state_11, t0.country AS country_12, t0.price_modifier AS price_modifier_13, t0.password AS password_14, t0.reset_password_token AS reset_password_token_15, t0.locale AS locale_16, t0.double_factor_method AS double_factor_method_17, t0.auth_code AS auth_code_18, t0.google_authenticator_secret AS google_authenticator_secret_19, t0.disabled_at AS disabled_at_20, t0.last_login_at AS last_login_at_21, t0.last_login_ip AS last_login_ip_22, t0.previous_login_at AS previous_login_at_23, t0.previous_login_ip AS previous_login_ip_24, t0.created_at AS created_at_25, t0.updated_at AS updated_at_26 FROM users t0 WHERE t0.id = 'e1d213a7-a827-410f-8a36-623e68f7991b';

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          c0_.id AS id_0,
          c0_.category_usage AS category_usage_1,
          c0_.created_at AS created_at_2,
          c0_.updated_at AS updated_at_3
        FROM
          categories c0_
          LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id
          LEFT JOIN category_translations c2_ ON c0_.id = c2_.category_id
          AND (c2_.locale = ?)
          LEFT JOIN category_translations c3_ ON c1_.id = c3_.category_id
          AND (c3_.locale = ?)
        WHERE
          c0_.category_usage IN (?, ?)
        ORDER BY
          c2_.name ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT c0_.id AS id_0, c0_.category_usage AS category_usage_1, c0_.created_at AS created_at_2, c0_.updated_at AS updated_at_3 FROM categories c0_ LEFT JOIN categories c1_ ON c0_.parent_id = c1_.id LEFT JOIN category_translations c2_ ON c0_.id = c2_.category_id AND (c2_.locale = 'es') LEFT JOIN category_translations c3_ ON c1_.id = c3_.category_id AND (c3_.locale = 'es') WHERE c0_.category_usage IN ('product_type', 'all') ORDER BY c2_.name ASC) dctrn_result) dctrn_table;