Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.session_id AS session_id_1,
  c0_.status AS status_2,
  c0_.last_activity_at AS last_activity_at_3,
  c0_.email AS email_4,
  c0_.firstname AS firstname_5,
  c0_.lastname AS lastname_6,
  c0_.telephone AS telephone_7,
  c0_.company_name AS company_name_8,
  c0_.cin AS cin_9,
  c0_.vat_id AS vat_id_10,
  c0_.pickup_point_id AS pickup_point_id_11,
  c0_.pickup_point_name AS pickup_point_name_12,
  c0_.note AS note_13,
  c0_.payment_method AS payment_method_14,
  c0_.created_at AS created_at_15,
  c0_.updated_at AS updated_at_16,
  c0_.address_street AS address_street_17,
  c0_.address_descriptive_number AS address_descriptive_number_18,
  c0_.address_city AS address_city_19,
  c0_.address_country AS address_country_20,
  c0_.address_zip_code AS address_zip_code_21,
  c0_.invoice_street AS invoice_street_22,
  c0_.invoice_descriptive_number AS invoice_descriptive_number_23,
  c0_.invoice_city AS invoice_city_24,
  c0_.invoice_country AS invoice_country_25,
  c0_.invoice_zip_code AS invoice_zip_code_26,
  c1_.id AS id_27,
  c1_.quantity AS quantity_28,
  c1_.created_at AS created_at_29,
  c1_.updated_at AS updated_at_30,
  p2_.id AS id_31,
  p2_.code AS code_32,
  p2_.is_default AS is_default_33,
  p2_.weight_modification AS weight_modification_34,
  p2_.price_modification_amount AS price_modification_amount_35,
  p2_.price_modification_currency AS price_modification_currency_36,
  p2_.stock_stock AS stock_stock_37,
  p2_.stock_reserved AS stock_reserved_38,
  p3_.id AS id_39,
  p3_.name AS name_40,
  p3_.description AS description_41,
  p3_.short_description AS short_description_42,
  p3_.code AS code_43,
  p3_.ean AS ean_44,
  p3_.unit AS unit_45,
  p3_.active AS active_46,
  p3_.can_be_bought AS can_be_bought_47,
  p3_.in_stock_text AS in_stock_text_48,
  p3_.out_of_stock_text AS out_of_stock_text_49,
  p3_.filter_parameter_value_ids AS filter_parameter_value_ids_50,
  p3_.filter_variant_value_ids AS filter_variant_value_ids_51,
  p3_.seo_title AS seo_title_52,
  p3_.seo_description AS seo_description_53,
  p3_.seo_url AS seo_url_54,
  p3_.stock_stock AS stock_stock_55,
  p3_.stock_reserved AS stock_reserved_56,
  p3_.logistic_weight AS logistic_weight_57,
  p3_.logistic_size_width AS logistic_size_width_58,
  p3_.logistic_size_height AS logistic_size_height_59,
  p3_.logistic_size_length AS logistic_size_length_60,
  p3_.price_amount AS price_amount_61,
  p3_.price_currency AS price_currency_62,
  p3_.purchase_price_amount AS purchase_price_amount_63,
  p3_.purchase_price_currency AS purchase_price_currency_64,
  c0_.customer_id AS customer_id_65,
  c0_.shipping_method_id AS shipping_method_id_66,
  c0_.discount_code_id AS discount_code_id_67,
  c1_.cart_id AS cart_id_68,
  c1_.product_variant_id AS product_variant_id_69,
  p2_.product_id AS product_id_70,
  p3_.vat_id AS vat_id_71,
  p3_.main_category_id AS main_category_id_72
FROM
  cart c0_
  LEFT JOIN cart_item c1_ ON c0_.id = c1_.cart_id
  LEFT JOIN product_variant p2_ ON c1_.product_variant_id = p2_.id
  LEFT JOIN product p3_ ON p2_.product_id = p3_.id
WHERE
  c0_.session_id = ?
  AND c0_.status = ?
ORDER BY
  c1_.id ASC

SELECT c0_.id AS id_0, c0_.session_id AS session_id_1, c0_.status AS status_2, c0_.last_activity_at AS last_activity_at_3, c0_.email AS email_4, c0_.firstname AS firstname_5, c0_.lastname AS lastname_6, c0_.telephone AS telephone_7, c0_.company_name AS company_name_8, c0_.cin AS cin_9, c0_.vat_id AS vat_id_10, c0_.pickup_point_id AS pickup_point_id_11, c0_.pickup_point_name AS pickup_point_name_12, c0_.note AS note_13, c0_.payment_method AS payment_method_14, c0_.created_at AS created_at_15, c0_.updated_at AS updated_at_16, c0_.address_street AS address_street_17, c0_.address_descriptive_number AS address_descriptive_number_18, c0_.address_city AS address_city_19, c0_.address_country AS address_country_20, c0_.address_zip_code AS address_zip_code_21, c0_.invoice_street AS invoice_street_22, c0_.invoice_descriptive_number AS invoice_descriptive_number_23, c0_.invoice_city AS invoice_city_24, c0_.invoice_country AS invoice_country_25, c0_.invoice_zip_code AS invoice_zip_code_26, c1_.id AS id_27, c1_.quantity AS quantity_28, c1_.created_at AS created_at_29, c1_.updated_at AS updated_at_30, p2_.id AS id_31, p2_.code AS code_32, p2_.is_default AS is_default_33, p2_.weight_modification AS weight_modification_34, p2_.price_modification_amount AS price_modification_amount_35, p2_.price_modification_currency AS price_modification_currency_36, p2_.stock_stock AS stock_stock_37, p2_.stock_reserved AS stock_reserved_38, p3_.id AS id_39, p3_.name AS name_40, p3_.description AS description_41, p3_.short_description AS short_description_42, p3_.code AS code_43, p3_.ean AS ean_44, p3_.unit AS unit_45, p3_.active AS active_46, p3_.can_be_bought AS can_be_bought_47, p3_.in_stock_text AS in_stock_text_48, p3_.out_of_stock_text AS out_of_stock_text_49, p3_.filter_parameter_value_ids AS filter_parameter_value_ids_50, p3_.filter_variant_value_ids AS filter_variant_value_ids_51, p3_.seo_title AS seo_title_52, p3_.seo_description AS seo_description_53, p3_.seo_url AS seo_url_54, p3_.stock_stock AS stock_stock_55, p3_.stock_reserved AS stock_reserved_56, p3_.logistic_weight AS logistic_weight_57, p3_.logistic_size_width AS logistic_size_width_58, p3_.logistic_size_height AS logistic_size_height_59, p3_.logistic_size_length AS logistic_size_length_60, p3_.price_amount AS price_amount_61, p3_.price_currency AS price_currency_62, p3_.purchase_price_amount AS purchase_price_amount_63, p3_.purchase_price_currency AS purchase_price_currency_64, c0_.customer_id AS customer_id_65, c0_.shipping_method_id AS shipping_method_id_66, c0_.discount_code_id AS discount_code_id_67, c1_.cart_id AS cart_id_68, c1_.product_variant_id AS product_variant_id_69, p2_.product_id AS product_id_70, p3_.vat_id AS vat_id_71, p3_.main_category_id AS main_category_id_72 FROM cart c0_ LEFT JOIN cart_item c1_ ON c0_.id = c1_.cart_id LEFT JOIN product_variant p2_ ON c1_.product_variant_id = p2_.id LEFT JOIN product p3_ ON p2_.product_id = p3_.id WHERE c0_.session_id = '' AND c0_.status = 'active' ORDER BY c1_.id ASC;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.description AS description_2,
  p0_.short_description AS short_description_3,
  p0_.code AS code_4,
  p0_.ean AS ean_5,
  p0_.unit AS unit_6,
  p0_.active AS active_7,
  p0_.can_be_bought AS can_be_bought_8,
  p0_.in_stock_text AS in_stock_text_9,
  p0_.out_of_stock_text AS out_of_stock_text_10,
  p0_.filter_parameter_value_ids AS filter_parameter_value_ids_11,
  p0_.filter_variant_value_ids AS filter_variant_value_ids_12,
  p0_.seo_title AS seo_title_13,
  p0_.seo_description AS seo_description_14,
  p0_.seo_url AS seo_url_15,
  p0_.stock_stock AS stock_stock_16,
  p0_.stock_reserved AS stock_reserved_17,
  p0_.logistic_weight AS logistic_weight_18,
  p0_.logistic_size_width AS logistic_size_width_19,
  p0_.logistic_size_height AS logistic_size_height_20,
  p0_.logistic_size_length AS logistic_size_length_21,
  p0_.price_amount AS price_amount_22,
  p0_.price_currency AS price_currency_23,
  p0_.purchase_price_amount AS purchase_price_amount_24,
  p0_.purchase_price_currency AS purchase_price_currency_25,
  p1_.id AS id_26,
  p1_.code AS code_27,
  p1_.is_default AS is_default_28,
  p1_.weight_modification AS weight_modification_29,
  p1_.price_modification_amount AS price_modification_amount_30,
  p1_.price_modification_currency AS price_modification_currency_31,
  p1_.stock_stock AS stock_stock_32,
  p1_.stock_reserved AS stock_reserved_33,
  v2_.id AS id_34,
  v2_.name AS name_35,
  v2_.slug AS slug_36,
  v2_.color AS color_37,
  v3_.id AS id_38,
  v3_.name AS name_39,
  v3_.slug AS slug_40,
  v3_.type AS type_41,
  p4_.id AS id_42,
  p4_.custom_value AS custom_value_43,
  p5_.id AS id_44,
  p5_.name AS name_45,
  p5_.slug AS slug_46,
  p6_.id AS id_47,
  p6_.name AS name_48,
  p6_.slug AS slug_49,
  p0_.vat_id AS vat_id_50,
  p0_.main_category_id AS main_category_id_51,
  p1_.product_id AS product_id_52,
  v2_.variant_id AS variant_id_53,
  p4_.product_id AS product_id_54,
  p4_.parameter_id AS parameter_id_55,
  p4_.parameter_value_id AS parameter_value_id_56,
  p6_.parameter_id AS parameter_id_57
FROM
  product p0_
  LEFT JOIN product_variant p1_ ON p0_.id = p1_.product_id
  LEFT JOIN product_variant_variant_value p7_ ON p1_.id = p7_.product_variant_id
  LEFT JOIN variant_value v2_ ON v2_.id = p7_.variant_value_id
  LEFT JOIN variant v3_ ON v2_.variant_id = v3_.id
  LEFT JOIN product_parameter p4_ ON p0_.id = p4_.product_id
  LEFT JOIN parameter p5_ ON p4_.parameter_id = p5_.id
  LEFT JOIN parameter_value p6_ ON p4_.parameter_value_id = p6_.id
  INNER JOIN product_category p9_ ON p0_.id = p9_.product_id
  INNER JOIN category c8_ ON c8_.id = p9_.category_id
WHERE
  c8_.id IN (?)
ORDER BY
  p0_.name ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.short_description AS short_description_3, p0_.code AS code_4, p0_.ean AS ean_5, p0_.unit AS unit_6, p0_.active AS active_7, p0_.can_be_bought AS can_be_bought_8, p0_.in_stock_text AS in_stock_text_9, p0_.out_of_stock_text AS out_of_stock_text_10, p0_.filter_parameter_value_ids AS filter_parameter_value_ids_11, p0_.filter_variant_value_ids AS filter_variant_value_ids_12, p0_.seo_title AS seo_title_13, p0_.seo_description AS seo_description_14, p0_.seo_url AS seo_url_15, p0_.stock_stock AS stock_stock_16, p0_.stock_reserved AS stock_reserved_17, p0_.logistic_weight AS logistic_weight_18, p0_.logistic_size_width AS logistic_size_width_19, p0_.logistic_size_height AS logistic_size_height_20, p0_.logistic_size_length AS logistic_size_length_21, p0_.price_amount AS price_amount_22, p0_.price_currency AS price_currency_23, p0_.purchase_price_amount AS purchase_price_amount_24, p0_.purchase_price_currency AS purchase_price_currency_25, p1_.id AS id_26, p1_.code AS code_27, p1_.is_default AS is_default_28, p1_.weight_modification AS weight_modification_29, p1_.price_modification_amount AS price_modification_amount_30, p1_.price_modification_currency AS price_modification_currency_31, p1_.stock_stock AS stock_stock_32, p1_.stock_reserved AS stock_reserved_33, v2_.id AS id_34, v2_.name AS name_35, v2_.slug AS slug_36, v2_.color AS color_37, v3_.id AS id_38, v3_.name AS name_39, v3_.slug AS slug_40, v3_.type AS type_41, p4_.id AS id_42, p4_.custom_value AS custom_value_43, p5_.id AS id_44, p5_.name AS name_45, p5_.slug AS slug_46, p6_.id AS id_47, p6_.name AS name_48, p6_.slug AS slug_49, p0_.vat_id AS vat_id_50, p0_.main_category_id AS main_category_id_51, p1_.product_id AS product_id_52, v2_.variant_id AS variant_id_53, p4_.product_id AS product_id_54, p4_.parameter_id AS parameter_id_55, p4_.parameter_value_id AS parameter_value_id_56, p6_.parameter_id AS parameter_id_57 FROM product p0_ LEFT JOIN product_variant p1_ ON p0_.id = p1_.product_id LEFT JOIN product_variant_variant_value p7_ ON p1_.id = p7_.product_variant_id LEFT JOIN variant_value v2_ ON v2_.id = p7_.variant_value_id LEFT JOIN variant v3_ ON v2_.variant_id = v3_.id LEFT JOIN product_parameter p4_ ON p0_.id = p4_.product_id LEFT JOIN parameter p5_ ON p4_.parameter_id = p5_.id LEFT JOIN parameter_value p6_ ON p4_.parameter_value_id = p6_.id INNER JOIN product_category p9_ ON p0_.id = p9_.product_id INNER JOIN category c8_ ON c8_.id = p9_.category_id WHERE c8_.id IN ('3e1a9f5c-7b4d-4c8e-9a2f-1d6b8c3e4a5f') ORDER BY p0_.name ASC;

SELECT
  unnested_value :: text as value_id,
  COUNT(*) as count
FROM
  product p,
  LATERAL unnest(p.filter_variant_value_ids) as unnested_value
WHERE
  p.active = true
  AND unnested_value = ANY(?)
  AND EXISTS (
    SELECT
      1
    FROM
      product_category pc
    WHERE
      pc.product_id = p.id
      AND pc.category_id = ANY(?)
  )
GROUP BY
  unnested_value

SELECT
                unnested_value::text as value_id,
                COUNT(*) as count
            FROM product p,
            LATERAL unnest(p.filter_variant_value_ids) as unnested_value
            WHERE p.active = true
            AND unnested_value = ANY('{85af27eb-5e1b-49de-a509-fafe5e3549bf,1def715c-1870-4847-8398-1077d75d1e2f}')
         AND EXISTS (SELECT 1 FROM product_category pc WHERE pc.product_id = p.id AND pc.category_id = ANY('{3e1a9f5c-7b4d-4c8e-9a2f-1d6b8c3e4a5f}')) GROUP BY unnested_value;

SELECT
  unnested_value :: text as value_id,
  COUNT(*) as count
FROM
  product p,
  LATERAL unnest(p.filter_parameter_value_ids) as unnested_value
WHERE
  p.active = true
  AND unnested_value = ANY(?)
  AND EXISTS (
    SELECT
      1
    FROM
      product_category pc
    WHERE
      pc.product_id = p.id
      AND pc.category_id = ANY(?)
  )
GROUP BY
  unnested_value

SELECT
                unnested_value::text as value_id,
                COUNT(*) as count
            FROM product p,
            LATERAL unnest(p.filter_parameter_value_ids) as unnested_value
            WHERE p.active = true
            AND unnested_value = ANY('{7f904120-f8b3-4566-b409-472698f59584,dd1b5415-c000-494b-92f0-ed10c8b7e16d}')
         AND EXISTS (SELECT 1 FROM product_category pc WHERE pc.product_id = p.id AND pc.category_id = ANY('{3e1a9f5c-7b4d-4c8e-9a2f-1d6b8c3e4a5f}')) GROUP BY unnested_value;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c0_.description AS description_3,
  c0_.lft AS lft_4,
  c0_.lvl AS lvl_5,
  c0_.rgt AS rgt_6,
  c0_.position AS position_7,
  f1_.id AS id_8,
  f1_.size AS size_9,
  f1_.mime_type AS mime_type_10,
  c0_.image_id AS image_id_11,
  c0_.tree_root AS tree_root_12,
  c0_.parent_id AS parent_id_13
FROM
  category c0_
  LEFT JOIN file f1_ ON c0_.image_id = f1_.id
WHERE
  c0_.slug = ?

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.description AS description_3, c0_.lft AS lft_4, c0_.lvl AS lvl_5, c0_.rgt AS rgt_6, c0_.position AS position_7, f1_.id AS id_8, f1_.size AS size_9, f1_.mime_type AS mime_type_10, c0_.image_id AS image_id_11, c0_.tree_root AS tree_root_12, c0_.parent_id AS parent_id_13 FROM category c0_ LEFT JOIN file f1_ ON c0_.image_id = f1_.id WHERE c0_.slug = 'womens-shoes';

SELECT
  s0_.id AS id_0,
  s0_.title AS title_1,
  s0_.slug AS slug_2,
  s0_.content AS content_3,
  s0_.show_contact_form AS show_contact_form_4,
  s0_.created_at AS created_at_5,
  s0_.updated_at AS updated_at_6,
  s0_.seo_title AS seo_title_7,
  s0_.seo_description AS seo_description_8,
  s0_.seo_url AS seo_url_9
FROM
  static_page s0_
ORDER BY
  s0_.title ASC

SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.slug AS slug_2, s0_.content AS content_3, s0_.show_contact_form AS show_contact_form_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6, s0_.seo_title AS seo_title_7, s0_.seo_description AS seo_description_8, s0_.seo_url AS seo_url_9 FROM static_page s0_ ORDER BY s0_.title ASC;

SELECT
  f0_.id AS id_0,
  f0_.name AS name_1,
  f0_.type AS type_2,
  f0_.is_enabled AS is_enabled_3,
  p1_.id AS id_4,
  p1_.name AS name_5,
  p1_.slug AS slug_6,
  p2_.id AS id_7,
  p2_.name AS name_8,
  p2_.slug AS slug_9,
  f0_.entity AS entity_10,
  f0_.parameter_id AS parameter_id_11,
  p2_.parameter_id AS parameter_id_12
FROM
  filter_configuration f0_
  LEFT JOIN parameter p1_ ON f0_.parameter_id = p1_.id
  LEFT JOIN parameter_value p2_ ON p1_.id = p2_.parameter_id
WHERE
  (f0_.is_enabled = ?)
  AND f0_.entity IN ('parameter')
ORDER BY
  f0_.name ASC

SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.type AS type_2, f0_.is_enabled AS is_enabled_3, p1_.id AS id_4, p1_.name AS name_5, p1_.slug AS slug_6, p2_.id AS id_7, p2_.name AS name_8, p2_.slug AS slug_9, f0_.entity AS entity_10, f0_.parameter_id AS parameter_id_11, p2_.parameter_id AS parameter_id_12 FROM filter_configuration f0_ LEFT JOIN parameter p1_ ON f0_.parameter_id = p1_.id LEFT JOIN parameter_value p2_ ON p1_.id = p2_.parameter_id WHERE (f0_.is_enabled = 1) AND f0_.entity IN ('parameter') ORDER BY f0_.name ASC;

SELECT
  f0_.id AS id_0,
  f0_.name AS name_1,
  f0_.type AS type_2,
  f0_.is_enabled AS is_enabled_3,
  v1_.id AS id_4,
  v1_.name AS name_5,
  v1_.slug AS slug_6,
  v1_.type AS type_7,
  v2_.id AS id_8,
  v2_.name AS name_9,
  v2_.slug AS slug_10,
  v2_.color AS color_11,
  f0_.entity AS entity_12,
  f0_.variant_id AS variant_id_13,
  v2_.variant_id AS variant_id_14
FROM
  filter_configuration f0_
  LEFT JOIN variant v1_ ON f0_.variant_id = v1_.id
  LEFT JOIN variant_value v2_ ON v1_.id = v2_.variant_id
WHERE
  (f0_.is_enabled = ?)
  AND f0_.entity IN ('variant')
ORDER BY
  f0_.name ASC

SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.type AS type_2, f0_.is_enabled AS is_enabled_3, v1_.id AS id_4, v1_.name AS name_5, v1_.slug AS slug_6, v1_.type AS type_7, v2_.id AS id_8, v2_.name AS name_9, v2_.slug AS slug_10, v2_.color AS color_11, f0_.entity AS entity_12, f0_.variant_id AS variant_id_13, v2_.variant_id AS variant_id_14 FROM filter_configuration f0_ LEFT JOIN variant v1_ ON f0_.variant_id = v1_.id LEFT JOIN variant_value v2_ ON v1_.id = v2_.variant_id WHERE (f0_.is_enabled = 1) AND f0_.entity IN ('variant') ORDER BY f0_.name ASC;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c0_.description AS description_3,
  c0_.lft AS lft_4,
  c0_.lvl AS lvl_5,
  c0_.rgt AS rgt_6,
  c0_.position AS position_7,
  c0_.image_id AS image_id_8,
  c0_.tree_root AS tree_root_9,
  c0_.parent_id AS parent_id_10
FROM
  category c0_
WHERE
  c0_.lft < ?
  AND c0_.rgt > ?
  AND c0_.tree_root = ?
ORDER BY
  c0_.lft ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.description AS description_3, c0_.lft AS lft_4, c0_.lvl AS lvl_5, c0_.rgt AS rgt_6, c0_.position AS position_7, c0_.image_id AS image_id_8, c0_.tree_root AS tree_root_9, c0_.parent_id AS parent_id_10 FROM category c0_ WHERE c0_.lft < 16 AND c0_.rgt > 17 AND c0_.tree_root = '3a1c9b5e-7d4f-4e8a-9c2b-1f6d8e3a4c5b' ORDER BY c0_.lft ASC;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c0_.description AS description_3,
  c0_.lft AS lft_4,
  c0_.lvl AS lvl_5,
  c0_.rgt AS rgt_6,
  c0_.position AS position_7,
  f1_.id AS id_8,
  f1_.size AS size_9,
  f1_.mime_type AS mime_type_10,
  c0_.image_id AS image_id_11,
  c0_.tree_root AS tree_root_12,
  c0_.parent_id AS parent_id_13
FROM
  category c0_
  LEFT JOIN file f1_ ON c0_.image_id = f1_.id
WHERE
  c0_.parent_id IS NULL
ORDER BY
  c0_.position ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.description AS description_3, c0_.lft AS lft_4, c0_.lvl AS lvl_5, c0_.rgt AS rgt_6, c0_.position AS position_7, f1_.id AS id_8, f1_.size AS size_9, f1_.mime_type AS mime_type_10, c0_.image_id AS image_id_11, c0_.tree_root AS tree_root_12, c0_.parent_id AS parent_id_13 FROM category c0_ LEFT JOIN file f1_ ON c0_.image_id = f1_.id WHERE c0_.parent_id IS NULL ORDER BY c0_.position ASC;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c0_.description AS description_3,
  c0_.lft AS lft_4,
  c0_.lvl AS lvl_5,
  c0_.rgt AS rgt_6,
  c0_.position AS position_7,
  f1_.id AS id_8,
  f1_.size AS size_9,
  f1_.mime_type AS mime_type_10,
  c0_.image_id AS image_id_11,
  c0_.tree_root AS tree_root_12,
  c0_.parent_id AS parent_id_13
FROM
  category c0_
  LEFT JOIN file f1_ ON c0_.image_id = f1_.id
WHERE
  c0_.parent_id = ?
ORDER BY
  c0_.lft ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.description AS description_3, c0_.lft AS lft_4, c0_.lvl AS lvl_5, c0_.rgt AS rgt_6, c0_.position AS position_7, f1_.id AS id_8, f1_.size AS size_9, f1_.mime_type AS mime_type_10, c0_.image_id AS image_id_11, c0_.tree_root AS tree_root_12, c0_.parent_id AS parent_id_13 FROM category c0_ LEFT JOIN file f1_ ON c0_.image_id = f1_.id WHERE c0_.parent_id = '3e1a9f5c-7b4d-4c8e-9a2f-1d6b8c3e4a5f' ORDER BY c0_.lft ASC;

SELECT
  c0_.id AS id_0
FROM
  category c0_
WHERE
  c0_.lft > ?
  AND c0_.rgt < ?
  AND c0_.tree_root = ?

SELECT c0_.id AS id_0 FROM category c0_ WHERE c0_.lft > 16 AND c0_.rgt < 17 AND c0_.tree_root = '3a1c9b5e-7d4f-4e8a-9c2b-1f6d8e3a4c5b';