Symfony Profiler

SELECT
  e0_.id AS sclr_0,
  e0_.name AS sclr_1,
  i1_.retail_price AS sclr_2,
  i1_.sale AS sclr_3,
  i2_.name AS sclr_4,
  b3_.name AS sclr_5,
  e0_.removed AS sclr_6,
  e0_.msrp AS sclr_7,
  c4_.name AS sclr_8,
  c4_.currency_code AS sclr_9,
  c4_.ex_rate AS sclr_10,
  e0_.available_from_samples AS sclr_11,
  'sponsoredCategory,sponsoredSubCategory,sponsoredGlobal,brand_id,production_id,production_type,post,merch,points,today_points,avg_points' AS sclr_12,
  e0_.sponsored_category AS sclr_13,
  e0_.sponsored_sub_category AS sclr_14,
  e0_.sponsored_global AS sclr_15,
  b3_.id AS sclr_16,
  e5_.production_id AS sclr_17,
  e5_.production_type AS sclr_18,
  e5_.post AS sclr_19,
  e5_.merch AS sclr_20,
  sum(e6_.points) AS sclr_21,
  sum(e7_.points) AS sclr_22,
  sum(e8_.points) / (
    DATEDIFF(
      ?,
      min(e8_.updated)
    )
  ) AS sclr_23
FROM
  e_commerce_item e0_
  INNER JOIN e_commerce_item_to_production e5_ ON e0_.id = e5_.e_commerce_item_id
  AND (e5_.published = 1)
  LEFT JOIN e_commerce_item_trend e6_ ON (e6_.target_id = e0_.id)
  LEFT JOIN e_commerce_item_trend e8_ ON (
    e8_.id = e6_.id
    AND e8_.updated < ?
  )
  LEFT JOIN e_commerce_item_trend e7_ ON (
    e7_.id = e6_.id
    AND e7_.updated >= ?
  )
  LEFT JOIN image_to_brand i9_ ON e0_.main_image_id = i9_.id
  LEFT JOIN image i2_ ON i9_.image_id = i2_.id
  LEFT JOIN brand b3_ ON e0_.brand_id = b3_.id
  LEFT JOIN currency c4_ ON b3_.currency_id = c4_.id
  LEFT JOIN item_inventory_discovery i1_ ON e0_.id = i1_.item_id
WHERE
  e0_.id IN (?)
GROUP BY
  e0_.id,
  i1_.retail_price,
  i1_.sale
ORDER BY
  i1_.retail_price - CASE WHEN i1_.sale IS NOT NULL
  AND i1_.sale <> 0 THEN
    i1_.retail_price * i1_.sale / 100
  ELSE
    0
  END ASC

SELECT e0_.id AS sclr_0, e0_.name AS sclr_1, i1_.retail_price AS sclr_2, i1_.sale AS sclr_3, i2_.name AS sclr_4, b3_.name AS sclr_5, e0_.removed AS sclr_6, e0_.msrp AS sclr_7, c4_.name AS sclr_8, c4_.currency_code AS sclr_9, c4_.ex_rate AS sclr_10, e0_.available_from_samples AS sclr_11, 'sponsoredCategory,sponsoredSubCategory,sponsoredGlobal,brand_id,production_id,production_type,post,merch,points,today_points,avg_points' AS sclr_12, e0_.sponsored_category AS sclr_13, e0_.sponsored_sub_category AS sclr_14, e0_.sponsored_global AS sclr_15, b3_.id AS sclr_16, e5_.production_id AS sclr_17, e5_.production_type AS sclr_18, e5_.post AS sclr_19, e5_.merch AS sclr_20, sum(e6_.points) AS sclr_21, sum(e7_.points) AS sclr_22, sum(e8_.points) / (DATEDIFF('2026-02-19 00:00:00', min(e8_.updated))) AS sclr_23 FROM e_commerce_item e0_ INNER JOIN e_commerce_item_to_production e5_ ON e0_.id = e5_.e_commerce_item_id AND (e5_.published = 1) LEFT JOIN e_commerce_item_trend e6_ ON (e6_.target_id = e0_.id) LEFT JOIN e_commerce_item_trend e8_ ON (e8_.id = e6_.id AND e8_.updated < '2026-02-19 00:00:00') LEFT JOIN e_commerce_item_trend e7_ ON (e7_.id = e6_.id AND e7_.updated >= '2026-02-19 00:00:00') LEFT JOIN image_to_brand i9_ ON e0_.main_image_id = i9_.id LEFT JOIN image i2_ ON i9_.image_id = i2_.id LEFT JOIN brand b3_ ON e0_.brand_id = b3_.id LEFT JOIN currency c4_ ON b3_.currency_id = c4_.id LEFT JOIN item_inventory_discovery i1_ ON e0_.id = i1_.item_id WHERE e0_.id IN (2130) GROUP BY e0_.id, i1_.retail_price, i1_.sale ORDER BY i1_.retail_price - CASE WHEN i1_.sale IS NOT NULL AND i1_.sale <> 0 THEN i1_.retail_price * i1_.sale / 100 ELSE 0 END ASC;

SELECT
  c0_.session_id AS session_id_0,
  c0_.quantity AS quantity_1,
  c0_.id AS id_2,
  c0_.item_id AS item_id_3,
  c0_.size_id AS size_id_4,
  c0_.color_id AS color_id_5
FROM
  customers_cart c0_
  INNER JOIN e_commerce_item e1_ ON (c0_.item_id = e1_.id)
  LEFT JOIN bind_film_scene_item_character b2_ ON (b2_.e_commerce_item_id = e1_.id)
  LEFT JOIN bind_film_character_signature_item b3_ ON (b3_.e_commerce_item_id = e1_.id)
  LEFT JOIN bind_film_set_item b4_ ON (b4_.e_commerce_item_id = e1_.id)
  LEFT JOIN bind_film_merch b5_ ON (b5_.e_commerce_item_id = e1_.id)
  LEFT JOIN bind_film_post_item_character b6_ ON (b6_.e_commerce_item_id = e1_.id)
  LEFT JOIN film_scene f7_ ON b2_.film_scene_id = f7_.id
  AND (f7_.publish = 1)
  LEFT JOIN film_character_signature f8_ ON b3_.film_character_signature_id = f8_.id
  LEFT JOIN film_character f9_ ON f8_.character_id = f9_.id
  LEFT JOIN film_set f10_ ON b4_.film_set_id = f10_.id
  AND (f10_.publish = 1)
  LEFT JOIN film_set_category f11_ ON f10_.film_set_category_id = f11_.id
  AND (f11_.publish = 1)
  LEFT JOIN film_merch f12_ ON b5_.film_merch_id = f12_.id
  LEFT JOIN film_posts f13_ ON b6_.film_post_id = f13_.id
  LEFT JOIN film f14_ ON (
    f14_.id = f7_.film_id
    OR f14_.id = f9_.film_id
    OR f14_.id = f11_.film_id
    OR f14_.id = f12_.film_id
    OR f14_.id = f13_.film_id
  )
  LEFT JOIN bind_tv_show_scene_item_character b15_ ON (b15_.e_commerce_item_id = e1_.id)
  LEFT JOIN bind_tv_show_character_signature_item b16_ ON (b16_.e_commerce_item_id = e1_.id)
  LEFT JOIN bind_tv_show_set_item b17_ ON (b17_.e_commerce_item_id = e1_.id)
  LEFT JOIN bind_tv_show_merch b18_ ON (b18_.e_commerce_item_id = e1_.id)
  LEFT JOIN bind_tv_show_post_item_character b19_ ON (b19_.e_commerce_item_id = e1_.id)
  LEFT JOIN tv_show_scene t20_ ON b15_.tv_show_scene_id = t20_.id
  AND (t20_.publish = 1)
  LEFT JOIN tv_show_episode t21_ ON t20_.tv_show_episode_id = t21_.id
  AND (t21_.publish = 1)
  LEFT JOIN tv_show_season t22_ ON t21_.tv_show_season_id = t22_.id
  AND (t22_.publish = 1)
  LEFT JOIN tv_show_character_signature t23_ ON b16_.tv_show_character_signature_id = t23_.id
  AND (t23_.publish = 1)
  LEFT JOIN tv_show_character t24_ ON t23_.character_id = t24_.id
  LEFT JOIN tv_show_set t25_ ON b17_.tv_show_set_id = t25_.id
  AND (t25_.publish = 1)
  LEFT JOIN tv_show_set_category t26_ ON t25_.tv_show_set_category_id = t26_.id
  AND (t26_.publish = 1)
  LEFT JOIN tv_show_merch t27_ ON b18_.tv_show_merch_id = t27_.id
  AND (t27_.publish = 1)
  LEFT JOIN tv_show_posts t28_ ON b19_.tv_show_post_id = t28_.id
  AND (t28_.publish = 1)
  LEFT JOIN tv_show t29_ ON (
    t29_.id = t22_.tv_show_id
    OR t29_.id = t24_.tv_show_id
    OR t29_.id = t26_.tv_show_id
    OR t29_.id = t27_.tv_show_id
    OR t29_.id = t28_.tv_show_id
  )
  LEFT JOIN bind_music_video_scene_item_character b30_ ON (b30_.e_commerce_item_id = e1_.id)
  LEFT JOIN bind_music_video_character_signature_item b31_ ON (b31_.e_commerce_item_id = e1_.id)
  LEFT JOIN bind_music_video_set_item b32_ ON (b32_.e_commerce_item_id = e1_.id)
  LEFT JOIN music_scene m33_ ON b30_.music_scene_id = m33_.id
  AND (m33_.publish = 1)
  LEFT JOIN music_video_character_signature m34_ ON b31_.music_video_character_signature_id = m34_.id
  LEFT JOIN music_video_character m35_ ON m34_.character_id = m35_.id
  LEFT JOIN music_video_set m36_ ON b32_.music_video_set_id = m36_.id
  AND (m36_.publish = 1)
  LEFT JOIN music_video_set_category m37_ ON m36_.music_video_set_category_id = m37_.id
  AND (m37_.publish = 1)
  LEFT JOIN music_video m38_ ON (
    m38_.id = m33_.music_video_id
    OR m38_.id = m35_.music_video_id
    OR m38_.id = m37_.music_video_id
  )
  LEFT JOIN music_artist_to_music_video m40_ ON m38_.id = m40_.music_video_id
  LEFT JOIN music_artist m39_ ON m39_.id = m40_.music_artist_id
  LEFT JOIN bind_music_artist_merch b41_ ON (b41_.e_commerce_item_id = e1_.id)
  LEFT JOIN music_artist_merch m42_ ON b41_.music_artist_merch_id = m42_.id
  AND (m42_.publish = 1)
  LEFT JOIN bind_music_artist_post_item_character b43_ ON (b43_.e_commerce_item_id = e1_.id)
  LEFT JOIN music_artist_posts m44_ ON b43_.music_artist_post_id = m44_.id
  AND (m44_.publish = 1)
  LEFT JOIN bind_music_artist_post_item_guest_character b45_ ON (b45_.e_commerce_item_id = e1_.id)
  LEFT JOIN music_artist_posts m46_ ON b45_.music_artist_post_id = m46_.id
  AND (m46_.publish = 1)
  LEFT JOIN music_artist m47_ ON (
    m47_.id = m42_.music_artist_id
    OR m47_.id = m44_.music_artist_id
    OR m47_.id = m46_.music_artist_id
  )
WHERE
  (
    f14_.publish = 1
    OR t29_.publish = 1
    OR (
      m38_.publish = 1
      AND m39_.publish = 1
    )
    OR m47_.publish = 1
  )
  AND c0_.session_id = ?
GROUP BY
  c0_.session_id,
  c0_.quantity,
  c0_.id,
  c0_.item_id,
  c0_.size_id,
  c0_.color_id
ORDER BY
  c0_.id DESC

SELECT c0_.session_id AS session_id_0, c0_.quantity AS quantity_1, c0_.id AS id_2, c0_.item_id AS item_id_3, c0_.size_id AS size_id_4, c0_.color_id AS color_id_5 FROM customers_cart c0_ INNER JOIN e_commerce_item e1_ ON (c0_.item_id = e1_.id) LEFT JOIN bind_film_scene_item_character b2_ ON (b2_.e_commerce_item_id = e1_.id) LEFT JOIN bind_film_character_signature_item b3_ ON (b3_.e_commerce_item_id = e1_.id) LEFT JOIN bind_film_set_item b4_ ON (b4_.e_commerce_item_id = e1_.id) LEFT JOIN bind_film_merch b5_ ON (b5_.e_commerce_item_id = e1_.id) LEFT JOIN bind_film_post_item_character b6_ ON (b6_.e_commerce_item_id = e1_.id) LEFT JOIN film_scene f7_ ON b2_.film_scene_id = f7_.id AND (f7_.publish = 1) LEFT JOIN film_character_signature f8_ ON b3_.film_character_signature_id = f8_.id LEFT JOIN film_character f9_ ON f8_.character_id = f9_.id LEFT JOIN film_set f10_ ON b4_.film_set_id = f10_.id AND (f10_.publish = 1) LEFT JOIN film_set_category f11_ ON f10_.film_set_category_id = f11_.id AND (f11_.publish = 1) LEFT JOIN film_merch f12_ ON b5_.film_merch_id = f12_.id LEFT JOIN film_posts f13_ ON b6_.film_post_id = f13_.id LEFT JOIN film f14_ ON (f14_.id = f7_.film_id OR f14_.id = f9_.film_id OR f14_.id = f11_.film_id OR f14_.id = f12_.film_id OR f14_.id = f13_.film_id) LEFT JOIN bind_tv_show_scene_item_character b15_ ON (b15_.e_commerce_item_id = e1_.id) LEFT JOIN bind_tv_show_character_signature_item b16_ ON (b16_.e_commerce_item_id = e1_.id) LEFT JOIN bind_tv_show_set_item b17_ ON (b17_.e_commerce_item_id = e1_.id) LEFT JOIN bind_tv_show_merch b18_ ON (b18_.e_commerce_item_id = e1_.id) LEFT JOIN bind_tv_show_post_item_character b19_ ON (b19_.e_commerce_item_id = e1_.id) LEFT JOIN tv_show_scene t20_ ON b15_.tv_show_scene_id = t20_.id AND (t20_.publish = 1) LEFT JOIN tv_show_episode t21_ ON t20_.tv_show_episode_id = t21_.id AND (t21_.publish = 1) LEFT JOIN tv_show_season t22_ ON t21_.tv_show_season_id = t22_.id AND (t22_.publish = 1) LEFT JOIN tv_show_character_signature t23_ ON b16_.tv_show_character_signature_id = t23_.id AND (t23_.publish = 1) LEFT JOIN tv_show_character t24_ ON t23_.character_id = t24_.id LEFT JOIN tv_show_set t25_ ON b17_.tv_show_set_id = t25_.id AND (t25_.publish = 1) LEFT JOIN tv_show_set_category t26_ ON t25_.tv_show_set_category_id = t26_.id AND (t26_.publish = 1) LEFT JOIN tv_show_merch t27_ ON b18_.tv_show_merch_id = t27_.id AND (t27_.publish = 1) LEFT JOIN tv_show_posts t28_ ON b19_.tv_show_post_id = t28_.id AND (t28_.publish = 1) LEFT JOIN tv_show t29_ ON (t29_.id = t22_.tv_show_id OR t29_.id = t24_.tv_show_id OR t29_.id = t26_.tv_show_id OR t29_.id = t27_.tv_show_id OR t29_.id = t28_.tv_show_id) LEFT JOIN bind_music_video_scene_item_character b30_ ON (b30_.e_commerce_item_id = e1_.id) LEFT JOIN bind_music_video_character_signature_item b31_ ON (b31_.e_commerce_item_id = e1_.id) LEFT JOIN bind_music_video_set_item b32_ ON (b32_.e_commerce_item_id = e1_.id) LEFT JOIN music_scene m33_ ON b30_.music_scene_id = m33_.id AND (m33_.publish = 1) LEFT JOIN music_video_character_signature m34_ ON b31_.music_video_character_signature_id = m34_.id LEFT JOIN music_video_character m35_ ON m34_.character_id = m35_.id LEFT JOIN music_video_set m36_ ON b32_.music_video_set_id = m36_.id AND (m36_.publish = 1) LEFT JOIN music_video_set_category m37_ ON m36_.music_video_set_category_id = m37_.id AND (m37_.publish = 1) LEFT JOIN music_video m38_ ON (m38_.id = m33_.music_video_id OR m38_.id = m35_.music_video_id OR m38_.id = m37_.music_video_id) LEFT JOIN music_artist_to_music_video m40_ ON m38_.id = m40_.music_video_id LEFT JOIN music_artist m39_ ON m39_.id = m40_.music_artist_id LEFT JOIN bind_music_artist_merch b41_ ON (b41_.e_commerce_item_id = e1_.id) LEFT JOIN music_artist_merch m42_ ON b41_.music_artist_merch_id = m42_.id AND (m42_.publish = 1) LEFT JOIN bind_music_artist_post_item_character b43_ ON (b43_.e_commerce_item_id = e1_.id) LEFT JOIN music_artist_posts m44_ ON b43_.music_artist_post_id = m44_.id AND (m44_.publish = 1) LEFT JOIN bind_music_artist_post_item_guest_character b45_ ON (b45_.e_commerce_item_id = e1_.id) LEFT JOIN music_artist_posts m46_ ON b45_.music_artist_post_id = m46_.id AND (m46_.publish = 1) LEFT JOIN music_artist m47_ ON (m47_.id = m42_.music_artist_id OR m47_.id = m44_.music_artist_id OR m47_.id = m46_.music_artist_id) WHERE (f14_.publish = 1 OR t29_.publish = 1 OR (m38_.publish = 1 AND m39_.publish = 1) OR m47_.publish = 1) AND c0_.session_id = 'jlbdnddvvh3353soj1gj8hc9nh' GROUP BY c0_.session_id, c0_.quantity, c0_.id, c0_.item_id, c0_.size_id, c0_.color_id ORDER BY c0_.id DESC;

SELECT
  c0_.id AS sclr_0,
  c0_.name AS sclr_1,
  c0_.country_code AS sclr_2
FROM
  e_commerce_item e1_
  INNER JOIN e_commerce_item_settings_discovery e2_ ON e1_.id = e2_.item_id
  AND (
    e2_.discovery = 1
    AND e2_.quantity_update <> 0
  )
  INNER JOIN item_color i3_ ON e1_.id = i3_.item_id
  INNER JOIN item_color_to_base_color i5_ ON i3_.id = i5_.item_color_id
  INNER JOIN base_color b4_ ON b4_.id = i5_.base_color_id
  INNER JOIN e_commerce_item_to_production e6_ ON e1_.id = e6_.e_commerce_item_id
  AND (e6_.published = 1)
  LEFT JOIN brand b7_ ON e1_.brand_id = b7_.id
  LEFT JOIN country_to_brand c8_ ON b7_.id = c8_.brand_id
  LEFT JOIN country c0_ ON c0_.id = c8_.country_id
WHERE
  (
    e1_.imported = 0
    AND e1_.removed = 0
    AND e1_.name IS NOT NULL
    AND e1_.e_commerce_item_type_id IS NOT NULL
    AND e1_.description IS NOT NULL
    AND e1_.e_commerce_subcategory_id IS NOT NULL
  )
  AND e1_.e_commerce_subcategory_id = ?
GROUP BY
  c0_.id
ORDER BY
  c0_.name ASC

SELECT c0_.id AS sclr_0, c0_.name AS sclr_1, c0_.country_code AS sclr_2 FROM e_commerce_item e1_ INNER JOIN e_commerce_item_settings_discovery e2_ ON e1_.id = e2_.item_id AND (e2_.discovery = 1 AND e2_.quantity_update <> 0) INNER JOIN item_color i3_ ON e1_.id = i3_.item_id INNER JOIN item_color_to_base_color i5_ ON i3_.id = i5_.item_color_id INNER JOIN base_color b4_ ON b4_.id = i5_.base_color_id INNER JOIN e_commerce_item_to_production e6_ ON e1_.id = e6_.e_commerce_item_id AND (e6_.published = 1) LEFT JOIN brand b7_ ON e1_.brand_id = b7_.id LEFT JOIN country_to_brand c8_ ON b7_.id = c8_.brand_id LEFT JOIN country c0_ ON c0_.id = c8_.country_id WHERE (e1_.imported = 0 AND e1_.removed = 0 AND e1_.name IS NOT NULL AND e1_.e_commerce_item_type_id IS NOT NULL AND e1_.description IS NOT NULL AND e1_.e_commerce_subcategory_id IS NOT NULL) AND e1_.e_commerce_subcategory_id = 251 GROUP BY c0_.id ORDER BY c0_.name ASC;

SELECT
  0 AS sclr_0,
  0 AS sclr_1,
  0 AS sclr_2,
  0 AS sclr_3,
  0 AS sclr_4,
  0 AS sclr_5,
  0 AS sclr_6,
  0 AS sclr_7,
  0 AS sclr_8,
  0 AS sclr_9,
  0 AS sclr_10,
  e0_.id AS sclr_11,
  e0_.name AS sclr_12,
  e0_.position AS sclr_13,
  e1_.id AS sclr_14,
  e1_.name AS sclr_15,
  e1_.position AS sclr_16
FROM
  e_commerce_item e2_
  INNER JOIN e_commerce_item_settings_discovery e3_ ON e2_.id = e3_.item_id
  AND (
    e3_.discovery = 1
    AND e3_.quantity_update <> 0
  )
  INNER JOIN item_color i4_ ON e2_.id = i4_.item_id
  INNER JOIN item_color_to_base_color i6_ ON i4_.id = i6_.item_color_id
  INNER JOIN base_color b5_ ON b5_.id = i6_.base_color_id
  INNER JOIN e_commerce_item_to_production e7_ ON e2_.id = e7_.e_commerce_item_id
  AND (e7_.published = 1)
  LEFT JOIN e_commerce_subcategory e0_ ON e2_.e_commerce_subcategory_id = e0_.id
  LEFT JOIN e_commerce_category e1_ ON e0_.e_commerce_category_id = e1_.id
WHERE
  e2_.imported = 0
  AND e2_.removed = 0
  AND e2_.name IS NOT NULL
  AND e2_.e_commerce_item_type_id IS NOT NULL
  AND e2_.description IS NOT NULL
  AND e2_.e_commerce_subcategory_id IS NOT NULL
GROUP BY
  e2_.id,
  e0_.id

SELECT 0 AS sclr_0, 0 AS sclr_1, 0 AS sclr_2, 0 AS sclr_3, 0 AS sclr_4, 0 AS sclr_5, 0 AS sclr_6, 0 AS sclr_7, 0 AS sclr_8, 0 AS sclr_9, 0 AS sclr_10, e0_.id AS sclr_11, e0_.name AS sclr_12, e0_.position AS sclr_13, e1_.id AS sclr_14, e1_.name AS sclr_15, e1_.position AS sclr_16 FROM e_commerce_item e2_ INNER JOIN e_commerce_item_settings_discovery e3_ ON e2_.id = e3_.item_id AND (e3_.discovery = 1 AND e3_.quantity_update <> 0) INNER JOIN item_color i4_ ON e2_.id = i4_.item_id INNER JOIN item_color_to_base_color i6_ ON i4_.id = i6_.item_color_id INNER JOIN base_color b5_ ON b5_.id = i6_.base_color_id INNER JOIN e_commerce_item_to_production e7_ ON e2_.id = e7_.e_commerce_item_id AND (e7_.published = 1) LEFT JOIN e_commerce_subcategory e0_ ON e2_.e_commerce_subcategory_id = e0_.id LEFT JOIN e_commerce_category e1_ ON e0_.e_commerce_category_id = e1_.id WHERE e2_.imported = 0 AND e2_.removed = 0 AND e2_.name IS NOT NULL AND e2_.e_commerce_item_type_id IS NOT NULL AND e2_.description IS NOT NULL AND e2_.e_commerce_subcategory_id IS NOT NULL GROUP BY e2_.id, e0_.id;

SELECT
  e0_.id AS sclr_0,
  e0_.name AS sclr_1
FROM
  e_commerce_item e1_
  INNER JOIN e_commerce_item_settings_discovery e2_ ON e1_.id = e2_.item_id
  AND (
    e2_.discovery = 1
    AND e2_.quantity_update <> 0
  )
  INNER JOIN item_color i3_ ON e1_.id = i3_.item_id
  INNER JOIN item_color_to_base_color i5_ ON i3_.id = i5_.item_color_id
  INNER JOIN base_color b4_ ON b4_.id = i5_.base_color_id
  INNER JOIN e_commerce_item_to_production e6_ ON e1_.id = e6_.e_commerce_item_id
  AND (e6_.published = 1)
  INNER JOIN e_commerce_item_type e0_ ON e1_.e_commerce_item_type_id = e0_.id
WHERE
  e1_.imported = 0
  AND e1_.removed = 0
  AND e1_.name IS NOT NULL
  AND e1_.e_commerce_item_type_id IS NOT NULL
  AND e1_.description IS NOT NULL
  AND e1_.e_commerce_subcategory_id IS NOT NULL
GROUP BY
  e0_.id

SELECT e0_.id AS sclr_0, e0_.name AS sclr_1 FROM e_commerce_item e1_ INNER JOIN e_commerce_item_settings_discovery e2_ ON e1_.id = e2_.item_id AND (e2_.discovery = 1 AND e2_.quantity_update <> 0) INNER JOIN item_color i3_ ON e1_.id = i3_.item_id INNER JOIN item_color_to_base_color i5_ ON i3_.id = i5_.item_color_id INNER JOIN base_color b4_ ON b4_.id = i5_.base_color_id INNER JOIN e_commerce_item_to_production e6_ ON e1_.id = e6_.e_commerce_item_id AND (e6_.published = 1) INNER JOIN e_commerce_item_type e0_ ON e1_.e_commerce_item_type_id = e0_.id WHERE e1_.imported = 0 AND e1_.removed = 0 AND e1_.name IS NOT NULL AND e1_.e_commerce_item_type_id IS NOT NULL AND e1_.description IS NOT NULL AND e1_.e_commerce_subcategory_id IS NOT NULL GROUP BY e0_.id;

SELECT
  e0_.id AS sclr_0,
  e0_.name AS sclr_1
FROM
  e_commerce_item e0_
  INNER JOIN e_commerce_item_settings_discovery e1_ ON e0_.id = e1_.item_id
  AND (
    e1_.discovery = 1
    AND e1_.quantity_update <> 0
  )
  INNER JOIN item_color i2_ ON e0_.id = i2_.item_id
  INNER JOIN item_color_to_base_color i4_ ON i2_.id = i4_.item_color_id
  INNER JOIN base_color b3_ ON b3_.id = i4_.base_color_id
  LEFT JOIN item_inventory_discovery i5_ ON e0_.id = i5_.item_id
  INNER JOIN e_commerce_item_to_production e6_ ON e0_.id = e6_.e_commerce_item_id
  AND (e6_.published = 1)
WHERE
  (
    e0_.imported = 0
    AND e0_.removed = 0
    AND e0_.name IS NOT NULL
    AND e0_.e_commerce_item_type_id IS NOT NULL
    AND e0_.description IS NOT NULL
    AND e0_.e_commerce_subcategory_id IS NOT NULL
  )
  AND e0_.e_commerce_subcategory_id = ?
GROUP BY
  e0_.id
ORDER BY
  e0_.finalized_date DESC,
  e0_.id DESC

SELECT e0_.id AS sclr_0, e0_.name AS sclr_1 FROM e_commerce_item e0_ INNER JOIN e_commerce_item_settings_discovery e1_ ON e0_.id = e1_.item_id AND (e1_.discovery = 1 AND e1_.quantity_update <> 0) INNER JOIN item_color i2_ ON e0_.id = i2_.item_id INNER JOIN item_color_to_base_color i4_ ON i2_.id = i4_.item_color_id INNER JOIN base_color b3_ ON b3_.id = i4_.base_color_id LEFT JOIN item_inventory_discovery i5_ ON e0_.id = i5_.item_id INNER JOIN e_commerce_item_to_production e6_ ON e0_.id = e6_.e_commerce_item_id AND (e6_.published = 1) WHERE (e0_.imported = 0 AND e0_.removed = 0 AND e0_.name IS NOT NULL AND e0_.e_commerce_item_type_id IS NOT NULL AND e0_.description IS NOT NULL AND e0_.e_commerce_subcategory_id IS NOT NULL) AND e0_.e_commerce_subcategory_id = 251 GROUP BY e0_.id ORDER BY e0_.finalized_date DESC, e0_.id DESC;

SELECT
  b0_.id AS sclr_0,
  b0_.name AS sclr_1
FROM
  e_commerce_item e1_
  INNER JOIN e_commerce_item_settings_discovery e2_ ON e1_.id = e2_.item_id
  AND (
    e2_.discovery = 1
    AND e2_.quantity_update <> 0
  )
  INNER JOIN item_color i3_ ON e1_.id = i3_.item_id
  INNER JOIN item_color_to_base_color i5_ ON i3_.id = i5_.item_color_id
  INNER JOIN base_color b4_ ON b4_.id = i5_.base_color_id
  INNER JOIN e_commerce_item_to_production e6_ ON e1_.id = e6_.e_commerce_item_id
  AND (e6_.published = 1)
  LEFT JOIN brand b0_ ON e1_.brand_id = b0_.id
WHERE
  (
    e1_.imported = 0
    AND e1_.removed = 0
    AND e1_.name IS NOT NULL
    AND e1_.e_commerce_item_type_id IS NOT NULL
    AND e1_.description IS NOT NULL
    AND e1_.e_commerce_subcategory_id IS NOT NULL
  )
  AND e1_.e_commerce_subcategory_id = ?
GROUP BY
  b0_.id
ORDER BY
  b0_.name ASC

SELECT b0_.id AS sclr_0, b0_.name AS sclr_1 FROM e_commerce_item e1_ INNER JOIN e_commerce_item_settings_discovery e2_ ON e1_.id = e2_.item_id AND (e2_.discovery = 1 AND e2_.quantity_update <> 0) INNER JOIN item_color i3_ ON e1_.id = i3_.item_id INNER JOIN item_color_to_base_color i5_ ON i3_.id = i5_.item_color_id INNER JOIN base_color b4_ ON b4_.id = i5_.base_color_id INNER JOIN e_commerce_item_to_production e6_ ON e1_.id = e6_.e_commerce_item_id AND (e6_.published = 1) LEFT JOIN brand b0_ ON e1_.brand_id = b0_.id WHERE (e1_.imported = 0 AND e1_.removed = 0 AND e1_.name IS NOT NULL AND e1_.e_commerce_item_type_id IS NOT NULL AND e1_.description IS NOT NULL AND e1_.e_commerce_subcategory_id IS NOT NULL) AND e1_.e_commerce_subcategory_id = 251 GROUP BY b0_.id ORDER BY b0_.name ASC;

SELECT
  b0_.id AS sclr_0,
  b0_.name AS sclr_1
FROM
  e_commerce_item e1_
  INNER JOIN e_commerce_item_settings_discovery e2_ ON e1_.id = e2_.item_id
  AND (
    e2_.discovery = 1
    AND e2_.quantity_update <> 0
  )
  INNER JOIN item_color i3_ ON e1_.id = i3_.item_id
  INNER JOIN item_color_to_base_color i5_ ON i3_.id = i5_.item_color_id
  INNER JOIN base_color b4_ ON b4_.id = i5_.base_color_id
  LEFT JOIN item_inventory_discovery i6_ ON e1_.id = i6_.item_id
  INNER JOIN e_commerce_item_to_production e7_ ON e1_.id = e7_.e_commerce_item_id
  AND (e7_.published = 1)
  LEFT JOIN size s8_ ON i6_.size_id = s8_.id
  LEFT JOIN base_size b0_ ON s8_.base_size_id = b0_.id
WHERE
  (
    e1_.imported = 0
    AND e1_.removed = 0
    AND e1_.name IS NOT NULL
    AND e1_.e_commerce_item_type_id IS NOT NULL
    AND e1_.description IS NOT NULL
    AND e1_.e_commerce_subcategory_id IS NOT NULL
  )
  AND e1_.e_commerce_subcategory_id = ?
GROUP BY
  b0_.id
ORDER BY
  b0_.position ASC,
  b0_.id DESC

SELECT b0_.id AS sclr_0, b0_.name AS sclr_1 FROM e_commerce_item e1_ INNER JOIN e_commerce_item_settings_discovery e2_ ON e1_.id = e2_.item_id AND (e2_.discovery = 1 AND e2_.quantity_update <> 0) INNER JOIN item_color i3_ ON e1_.id = i3_.item_id INNER JOIN item_color_to_base_color i5_ ON i3_.id = i5_.item_color_id INNER JOIN base_color b4_ ON b4_.id = i5_.base_color_id LEFT JOIN item_inventory_discovery i6_ ON e1_.id = i6_.item_id INNER JOIN e_commerce_item_to_production e7_ ON e1_.id = e7_.e_commerce_item_id AND (e7_.published = 1) LEFT JOIN size s8_ ON i6_.size_id = s8_.id LEFT JOIN base_size b0_ ON s8_.base_size_id = b0_.id WHERE (e1_.imported = 0 AND e1_.removed = 0 AND e1_.name IS NOT NULL AND e1_.e_commerce_item_type_id IS NOT NULL AND e1_.description IS NOT NULL AND e1_.e_commerce_subcategory_id IS NOT NULL) AND e1_.e_commerce_subcategory_id = 251 GROUP BY b0_.id ORDER BY b0_.position ASC, b0_.id DESC;