Symfony Profiler

SELECT
  t0.currency_code AS currency_code_1,
  t0.ex_rate AS ex_rate_2,
  t0.currency_symb AS currency_symb_3,
  t0.name AS name_4,
  t0.id AS id_5
FROM
  currency t0
WHERE
  t0.currency_code = ?
LIMIT
  1

SELECT t0.currency_code AS currency_code_1, t0.ex_rate AS ex_rate_2, t0.currency_symb AS currency_symb_3, t0.name AS name_4, t0.id AS id_5 FROM currency t0 WHERE t0.currency_code = 'USD' LIMIT 1;

SELECT
  t0.country_code AS country_code_1,
  t0.thumbnail AS thumbnail_2,
  t0.name AS name_3,
  t0.id AS id_4,
  t0.currency_id AS currency_id_5,
  t0.continent_id AS continent_id_6
FROM
  country t0
WHERE
  t0.country_code = ?
LIMIT
  1

SELECT t0.country_code AS country_code_1, t0.thumbnail AS thumbnail_2, t0.name AS name_3, t0.id AS id_4, t0.currency_id AS currency_id_5, t0.continent_id AS continent_id_6 FROM country t0 WHERE t0.country_code = 'US' LIMIT 1;

SELECT
  t0.name AS name_1,
  t0.position AS position_2,
  t0.id AS id_3
FROM
  e_commerce_category t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.position AS position_2, t0.id AS id_3 FROM e_commerce_category t0 WHERE t0.id = 3;

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)
  LEFT JOIN e_commerce_subcategory e7_ ON e0_.e_commerce_subcategory_id = e7_.id
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 e7_.e_commerce_category_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) LEFT JOIN e_commerce_subcategory e7_ ON e0_.e_commerce_subcategory_id = e7_.id 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 e7_.e_commerce_category_id = 3 GROUP BY e0_.id ORDER BY e0_.finalized_date DESC, e0_.id DESC;

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
  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 e_commerce_subcategory e7_ ON e1_.e_commerce_subcategory_id = e7_.id
  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 e7_.e_commerce_category_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 e_commerce_subcategory e7_ ON e1_.e_commerce_subcategory_id = e7_.id 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 e7_.e_commerce_category_id = 3 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 e_commerce_subcategory e8_ ON e1_.e_commerce_subcategory_id = e8_.id
  LEFT JOIN size s9_ ON i6_.size_id = s9_.id
  LEFT JOIN base_size b0_ ON s9_.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 e8_.e_commerce_category_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 e_commerce_subcategory e8_ ON e1_.e_commerce_subcategory_id = e8_.id LEFT JOIN size s9_ ON i6_.size_id = s9_.id LEFT JOIN base_size b0_ ON s9_.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 e8_.e_commerce_category_id = 3 GROUP BY b0_.id ORDER BY b0_.position ASC, b0_.id DESC;

SELECT
  b0_.id AS sclr_0,
  b0_.name AS sclr_1,
  b0_.color 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 i4_ ON i3_.id = i4_.item_color_id
  INNER JOIN base_color b0_ ON b0_.id = i4_.base_color_id
  INNER JOIN e_commerce_item_to_production e5_ ON e1_.id = e5_.e_commerce_item_id
  AND (e5_.published = 1)
  LEFT JOIN e_commerce_subcategory e6_ ON e1_.e_commerce_subcategory_id = e6_.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 e6_.e_commerce_category_id = ?
GROUP BY
  b0_.id
ORDER BY
  b0_.name ASC

SELECT b0_.id AS sclr_0, b0_.name AS sclr_1, b0_.color 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 i4_ ON i3_.id = i4_.item_color_id INNER JOIN base_color b0_ ON b0_.id = i4_.base_color_id INNER JOIN e_commerce_item_to_production e5_ ON e1_.id = e5_.e_commerce_item_id AND (e5_.published = 1) LEFT JOIN e_commerce_subcategory e6_ ON e1_.e_commerce_subcategory_id = e6_.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 e6_.e_commerce_category_id = 3 GROUP BY b0_.id ORDER BY b0_.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 e_commerce_subcategory e7_ ON e1_.e_commerce_subcategory_id = e7_.id
  LEFT JOIN brand b8_ ON e1_.brand_id = b8_.id
  LEFT JOIN country_to_brand c9_ ON b8_.id = c9_.brand_id
  LEFT JOIN country c0_ ON c0_.id = c9_.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 e7_.e_commerce_category_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 e_commerce_subcategory e7_ ON e1_.e_commerce_subcategory_id = e7_.id LEFT JOIN brand b8_ ON e1_.brand_id = b8_.id LEFT JOIN country_to_brand c9_ ON b8_.id = c9_.brand_id LEFT JOIN country c0_ ON c0_.id = c9_.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 e7_.e_commerce_category_id = 3 GROUP BY c0_.id ORDER BY c0_.name 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(
      ?,
      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 (2152, 1110, 1108, 18) 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
  i0_.id AS sclr_0,
  i0_.name AS sclr_1,
  i1_.name AS sclr_2,
  b2_.color AS sclr_3,
  e3_.id AS sclr_4
FROM
  e_commerce_item e3_
  INNER JOIN item_inventory_discovery i4_ ON e3_.id = i4_.item_id
  INNER JOIN item_color i0_ ON i4_.color_id = i0_.id
  INNER JOIN item_color_to_base_color i5_ ON i0_.id = i5_.item_color_id
  INNER JOIN base_color b2_ ON b2_.id = i5_.base_color_id
  LEFT JOIN image_to_brand i6_ ON i0_.preview_image_to_brand_id = i6_.id
  LEFT JOIN image i1_ ON i6_.image_id = i1_.id
WHERE
  e3_.id IN (?, ?, ?, ?)
GROUP BY
  e3_.id,
  i0_.id

SELECT i0_.id AS sclr_0, i0_.name AS sclr_1, i1_.name AS sclr_2, b2_.color AS sclr_3, e3_.id AS sclr_4 FROM e_commerce_item e3_ INNER JOIN item_inventory_discovery i4_ ON e3_.id = i4_.item_id INNER JOIN item_color i0_ ON i4_.color_id = i0_.id INNER JOIN item_color_to_base_color i5_ ON i0_.id = i5_.item_color_id INNER JOIN base_color b2_ ON b2_.id = i5_.base_color_id LEFT JOIN image_to_brand i6_ ON i0_.preview_image_to_brand_id = i6_.id LEFT JOIN image i1_ ON i6_.image_id = i1_.id WHERE e3_.id IN (2152, 1110, 1108, 18) GROUP BY e3_.id, i0_.id;

SELECT
  c0_.id AS sclr_0,
  c0_.name AS sclr_1,
  e1_.id AS sclr_2
FROM
  e_commerce_item e1_
  INNER JOIN brand b2_ ON e1_.brand_id = b2_.id
  INNER JOIN country_to_brand c3_ ON b2_.id = c3_.brand_id
  INNER JOIN country c0_ ON c0_.id = c3_.country_id
WHERE
  e1_.id IN (?, ?, ?, ?)
GROUP BY
  e1_.id,
  c0_.id

SELECT c0_.id AS sclr_0, c0_.name AS sclr_1, e1_.id AS sclr_2 FROM e_commerce_item e1_ INNER JOIN brand b2_ ON e1_.brand_id = b2_.id INNER JOIN country_to_brand c3_ ON b2_.id = c3_.brand_id INNER JOIN country c0_ ON c0_.id = c3_.country_id WHERE e1_.id IN (2152, 1110, 1108, 18) GROUP BY e1_.id, c0_.id;

SELECT
  e0_.id AS sclr_0,
  CASE WHEN e0_.default_cities = 1 THEN
    c1_.name
  ELSE
    c2_.name
  END AS sclr_1,
  CASE WHEN e0_.default_cities = 1 THEN
    s3_.name
  ELSE
    s4_.name
  END AS sclr_2,
  CASE WHEN e0_.default_cities = 1 THEN
    c5_.name
  ELSE
    c6_.name
  END AS sclr_3
FROM
  e_commerce_item e0_
  INNER JOIN brand b7_ ON e0_.brand_id = b7_.id
  LEFT JOIN brand_to_city b8_ ON b7_.id = b8_.brand_id
  LEFT JOIN city c1_ ON c1_.id = b8_.city_id
  AND (e0_.default_cities = 1)
  LEFT JOIN e_commerce_item_to_city e9_ ON e0_.id = e9_.e_commerce_item_id
  LEFT JOIN city c2_ ON c2_.id = e9_.city_id
  AND (e0_.default_cities = 0)
  LEFT JOIN state s3_ ON c1_.state_id = s3_.id
  LEFT JOIN state s4_ ON c2_.state_id = s4_.id
  LEFT JOIN country c5_ ON c1_.country_id = c5_.id
  LEFT JOIN country c6_ ON c2_.country_id = c6_.id
WHERE
  e0_.id IN (?, ?, ?, ?)
GROUP BY
  e0_.id,
  c1_.id,
  c2_.id

SELECT e0_.id AS sclr_0, CASE WHEN e0_.default_cities = 1 THEN c1_.name ELSE c2_.name END AS sclr_1, CASE WHEN e0_.default_cities = 1 THEN s3_.name ELSE s4_.name END AS sclr_2, CASE WHEN e0_.default_cities = 1 THEN c5_.name ELSE c6_.name END AS sclr_3 FROM e_commerce_item e0_ INNER JOIN brand b7_ ON e0_.brand_id = b7_.id LEFT JOIN brand_to_city b8_ ON b7_.id = b8_.brand_id LEFT JOIN city c1_ ON c1_.id = b8_.city_id AND (e0_.default_cities = 1) LEFT JOIN e_commerce_item_to_city e9_ ON e0_.id = e9_.e_commerce_item_id LEFT JOIN city c2_ ON c2_.id = e9_.city_id AND (e0_.default_cities = 0) LEFT JOIN state s3_ ON c1_.state_id = s3_.id LEFT JOIN state s4_ ON c2_.state_id = s4_.id LEFT JOIN country c5_ ON c1_.country_id = c5_.id LEFT JOIN country c6_ ON c2_.country_id = c6_.id WHERE e0_.id IN (2152, 1110, 1108, 18) GROUP BY e0_.id, c1_.id, c2_.id;