Symfony Profiler

SELECT
  e0_.points AS points_0,
  e0_.id AS id_1,
  e0_.updated AS updated_2,
  sum(e0_.points) AS sclr_3,
  sum(e1_.points) AS sclr_4,
  sum(e2_.points) / (
    DATEDIFF(
      ?,
      min(e2_.updated)
    )
  ) AS sclr_5,
  e0_.target_id AS target_id_6
FROM
  e_commerce_item_trend e0_
  LEFT JOIN e_commerce_item_trend e2_ ON (
    e2_.id = e0_.id
    AND e2_.updated < ?
  )
  LEFT JOIN e_commerce_item_trend e1_ ON (
    e1_.id = e0_.id
    AND e1_.updated >= ?
  )
  INNER JOIN e_commerce_item e3_ ON e0_.target_id = e3_.id
  INNER JOIN e_commerce_item_settings_discovery e4_ ON e3_.id = e4_.item_id
  AND (
    e4_.discovery = 1
    AND e4_.quantity_update <> 0
  )
  LEFT JOIN bind_film_scene_item_character b5_ ON (b5_.e_commerce_item_id = e3_.id)
  LEFT JOIN bind_film_character_signature_item b6_ ON (b6_.e_commerce_item_id = e3_.id)
  LEFT JOIN bind_film_set_item b7_ ON (b7_.e_commerce_item_id = e3_.id)
  LEFT JOIN bind_film_merch b8_ ON (b8_.e_commerce_item_id = e3_.id)
  LEFT JOIN bind_film_post_item_character b9_ ON (b9_.e_commerce_item_id = e3_.id)
  LEFT JOIN film_scene f10_ ON b5_.film_scene_id = f10_.id
  AND (f10_.publish = 1)
  LEFT JOIN film_character_signature f11_ ON b6_.film_character_signature_id = f11_.id
  LEFT JOIN film_character f12_ ON f11_.character_id = f12_.id
  LEFT JOIN film_set f13_ ON b7_.film_set_id = f13_.id
  AND (f13_.publish = 1)
  LEFT JOIN film_set_category f14_ ON f13_.film_set_category_id = f14_.id
  AND (f14_.publish = 1)
  LEFT JOIN film_merch f15_ ON b8_.film_merch_id = f15_.id
  AND (f15_.publish = 1)
  LEFT JOIN film_posts f16_ ON b9_.film_post_id = f16_.id
  AND (f16_.publish = 1)
  LEFT JOIN film f17_ ON (
    f17_.id = f10_.film_id
    OR f17_.id = f12_.film_id
    OR f17_.id = f14_.film_id
    OR f17_.id = f15_.film_id
    OR f17_.id = f16_.film_id
  )
  LEFT JOIN bind_tv_show_scene_item_character b18_ ON (b18_.e_commerce_item_id = e3_.id)
  LEFT JOIN bind_tv_show_character_signature_item b19_ ON (b19_.e_commerce_item_id = e3_.id)
  LEFT JOIN bind_tv_show_set_item b20_ ON (b20_.e_commerce_item_id = e3_.id)
  LEFT JOIN bind_tv_show_merch b21_ ON (b21_.e_commerce_item_id = e3_.id)
  LEFT JOIN bind_tv_show_post_item_character b22_ ON (b22_.e_commerce_item_id = e3_.id)
  LEFT JOIN tv_show_scene t23_ ON b18_.tv_show_scene_id = t23_.id
  AND (t23_.publish = 1)
  LEFT JOIN tv_show_episode t24_ ON t23_.tv_show_episode_id = t24_.id
  AND (t24_.publish = 1)
  LEFT JOIN tv_show_season t25_ ON t24_.tv_show_season_id = t25_.id
  AND (t25_.publish = 1)
  LEFT JOIN tv_show_character_signature t26_ ON b19_.tv_show_character_signature_id = t26_.id
  AND (t26_.publish = 1)
  LEFT JOIN tv_show_character t27_ ON t26_.character_id = t27_.id
  LEFT JOIN tv_show_set t28_ ON b20_.tv_show_set_id = t28_.id
  AND (t28_.publish = 1)
  LEFT JOIN tv_show_set_category t29_ ON t28_.tv_show_set_category_id = t29_.id
  AND (t29_.publish = 1)
  LEFT JOIN tv_show_merch t30_ ON b21_.tv_show_merch_id = t30_.id
  AND (t30_.publish = 1)
  LEFT JOIN tv_show_posts t31_ ON b22_.tv_show_post_id = t31_.id
  AND (t31_.publish = 1)
  LEFT JOIN tv_show t32_ ON (
    t32_.id = t25_.tv_show_id
    OR t32_.id = t27_.tv_show_id
    OR t32_.id = t29_.tv_show_id
    OR t32_.id = t30_.tv_show_id
    OR t32_.id = t31_.tv_show_id
  )
  LEFT JOIN bind_music_video_scene_item_character b33_ ON (b33_.e_commerce_item_id = e3_.id)
  LEFT JOIN bind_music_video_character_signature_item b34_ ON (b34_.e_commerce_item_id = e3_.id)
  LEFT JOIN bind_music_video_set_item b35_ ON (b35_.e_commerce_item_id = e3_.id)
  LEFT JOIN music_scene m36_ ON b33_.music_scene_id = m36_.id
  AND (m36_.publish = 1)
  LEFT JOIN music_video_character_signature m37_ ON b34_.music_video_character_signature_id = m37_.id
  LEFT JOIN music_video_character m38_ ON m37_.character_id = m38_.id
  LEFT JOIN music_video_set m39_ ON b35_.music_video_set_id = m39_.id
  AND (m39_.publish = 1)
  LEFT JOIN music_video_set_category m40_ ON m39_.music_video_set_category_id = m40_.id
  AND (m40_.publish = 1)
  LEFT JOIN music_video m41_ ON (
    m41_.id = m36_.music_video_id
    OR m41_.id = m38_.music_video_id
    OR m41_.id = m40_.music_video_id
  )
  LEFT JOIN music_artist_to_music_video m43_ ON m41_.id = m43_.music_video_id
  LEFT JOIN music_artist m42_ ON m42_.id = m43_.music_artist_id
  LEFT JOIN bind_music_artist_merch b44_ ON (b44_.e_commerce_item_id = e3_.id)
  LEFT JOIN music_artist_merch m45_ ON b44_.music_artist_merch_id = m45_.id
  AND (m45_.publish = 1)
  LEFT JOIN bind_music_artist_post_item_character b46_ ON (b46_.e_commerce_item_id = e3_.id)
  LEFT JOIN music_artist_posts m47_ ON b46_.music_artist_post_id = m47_.id
  AND (m47_.publish = 1)
  LEFT JOIN bind_music_artist_post_item_guest_character b48_ ON (b48_.e_commerce_item_id = e3_.id)
  LEFT JOIN music_artist_posts m49_ ON b48_.music_artist_post_id = m49_.id
  AND (m49_.publish = 1)
  LEFT JOIN music_artist m50_ ON (
    m50_.id = m45_.music_artist_id
    OR m50_.id = m47_.music_artist_id
    OR m50_.id = m49_.music_artist_id
  )
WHERE
  (
    f17_.publish = 1
    OR t32_.publish = 1
    OR (
      m41_.publish = 1
      AND m42_.publish = 1
    )
    OR m50_.publish = 1
  )
  AND e3_.removed = 0
GROUP BY
  e0_.target_id
ORDER BY
  sclr_3 DESC
LIMIT
  1000

SELECT e0_.points AS points_0, e0_.id AS id_1, e0_.updated AS updated_2, sum(e0_.points) AS sclr_3, sum(e1_.points) AS sclr_4, sum(e2_.points) / (DATEDIFF('2026-02-19 00:00:00', min(e2_.updated))) AS sclr_5, e0_.target_id AS target_id_6 FROM e_commerce_item_trend e0_ LEFT JOIN e_commerce_item_trend e2_ ON (e2_.id = e0_.id AND e2_.updated < '2026-02-19 00:00:00') LEFT JOIN e_commerce_item_trend e1_ ON (e1_.id = e0_.id AND e1_.updated >= '2026-02-19 00:00:00') INNER JOIN e_commerce_item e3_ ON e0_.target_id = e3_.id INNER JOIN e_commerce_item_settings_discovery e4_ ON e3_.id = e4_.item_id AND (e4_.discovery = 1 AND e4_.quantity_update <> 0) LEFT JOIN bind_film_scene_item_character b5_ ON (b5_.e_commerce_item_id = e3_.id) LEFT JOIN bind_film_character_signature_item b6_ ON (b6_.e_commerce_item_id = e3_.id) LEFT JOIN bind_film_set_item b7_ ON (b7_.e_commerce_item_id = e3_.id) LEFT JOIN bind_film_merch b8_ ON (b8_.e_commerce_item_id = e3_.id) LEFT JOIN bind_film_post_item_character b9_ ON (b9_.e_commerce_item_id = e3_.id) LEFT JOIN film_scene f10_ ON b5_.film_scene_id = f10_.id AND (f10_.publish = 1) LEFT JOIN film_character_signature f11_ ON b6_.film_character_signature_id = f11_.id LEFT JOIN film_character f12_ ON f11_.character_id = f12_.id LEFT JOIN film_set f13_ ON b7_.film_set_id = f13_.id AND (f13_.publish = 1) LEFT JOIN film_set_category f14_ ON f13_.film_set_category_id = f14_.id AND (f14_.publish = 1) LEFT JOIN film_merch f15_ ON b8_.film_merch_id = f15_.id AND (f15_.publish = 1) LEFT JOIN film_posts f16_ ON b9_.film_post_id = f16_.id AND (f16_.publish = 1) LEFT JOIN film f17_ ON (f17_.id = f10_.film_id OR f17_.id = f12_.film_id OR f17_.id = f14_.film_id OR f17_.id = f15_.film_id OR f17_.id = f16_.film_id) LEFT JOIN bind_tv_show_scene_item_character b18_ ON (b18_.e_commerce_item_id = e3_.id) LEFT JOIN bind_tv_show_character_signature_item b19_ ON (b19_.e_commerce_item_id = e3_.id) LEFT JOIN bind_tv_show_set_item b20_ ON (b20_.e_commerce_item_id = e3_.id) LEFT JOIN bind_tv_show_merch b21_ ON (b21_.e_commerce_item_id = e3_.id) LEFT JOIN bind_tv_show_post_item_character b22_ ON (b22_.e_commerce_item_id = e3_.id) LEFT JOIN tv_show_scene t23_ ON b18_.tv_show_scene_id = t23_.id AND (t23_.publish = 1) LEFT JOIN tv_show_episode t24_ ON t23_.tv_show_episode_id = t24_.id AND (t24_.publish = 1) LEFT JOIN tv_show_season t25_ ON t24_.tv_show_season_id = t25_.id AND (t25_.publish = 1) LEFT JOIN tv_show_character_signature t26_ ON b19_.tv_show_character_signature_id = t26_.id AND (t26_.publish = 1) LEFT JOIN tv_show_character t27_ ON t26_.character_id = t27_.id LEFT JOIN tv_show_set t28_ ON b20_.tv_show_set_id = t28_.id AND (t28_.publish = 1) LEFT JOIN tv_show_set_category t29_ ON t28_.tv_show_set_category_id = t29_.id AND (t29_.publish = 1) LEFT JOIN tv_show_merch t30_ ON b21_.tv_show_merch_id = t30_.id AND (t30_.publish = 1) LEFT JOIN tv_show_posts t31_ ON b22_.tv_show_post_id = t31_.id AND (t31_.publish = 1) LEFT JOIN tv_show t32_ ON (t32_.id = t25_.tv_show_id OR t32_.id = t27_.tv_show_id OR t32_.id = t29_.tv_show_id OR t32_.id = t30_.tv_show_id OR t32_.id = t31_.tv_show_id) LEFT JOIN bind_music_video_scene_item_character b33_ ON (b33_.e_commerce_item_id = e3_.id) LEFT JOIN bind_music_video_character_signature_item b34_ ON (b34_.e_commerce_item_id = e3_.id) LEFT JOIN bind_music_video_set_item b35_ ON (b35_.e_commerce_item_id = e3_.id) LEFT JOIN music_scene m36_ ON b33_.music_scene_id = m36_.id AND (m36_.publish = 1) LEFT JOIN music_video_character_signature m37_ ON b34_.music_video_character_signature_id = m37_.id LEFT JOIN music_video_character m38_ ON m37_.character_id = m38_.id LEFT JOIN music_video_set m39_ ON b35_.music_video_set_id = m39_.id AND (m39_.publish = 1) LEFT JOIN music_video_set_category m40_ ON m39_.music_video_set_category_id = m40_.id AND (m40_.publish = 1) LEFT JOIN music_video m41_ ON (m41_.id = m36_.music_video_id OR m41_.id = m38_.music_video_id OR m41_.id = m40_.music_video_id) LEFT JOIN music_artist_to_music_video m43_ ON m41_.id = m43_.music_video_id LEFT JOIN music_artist m42_ ON m42_.id = m43_.music_artist_id LEFT JOIN bind_music_artist_merch b44_ ON (b44_.e_commerce_item_id = e3_.id) LEFT JOIN music_artist_merch m45_ ON b44_.music_artist_merch_id = m45_.id AND (m45_.publish = 1) LEFT JOIN bind_music_artist_post_item_character b46_ ON (b46_.e_commerce_item_id = e3_.id) LEFT JOIN music_artist_posts m47_ ON b46_.music_artist_post_id = m47_.id AND (m47_.publish = 1) LEFT JOIN bind_music_artist_post_item_guest_character b48_ ON (b48_.e_commerce_item_id = e3_.id) LEFT JOIN music_artist_posts m49_ ON b48_.music_artist_post_id = m49_.id AND (m49_.publish = 1) LEFT JOIN music_artist m50_ ON (m50_.id = m45_.music_artist_id OR m50_.id = m47_.music_artist_id OR m50_.id = m49_.music_artist_id) WHERE (f17_.publish = 1 OR t32_.publish = 1 OR (m41_.publish = 1 AND m42_.publish = 1) OR m50_.publish = 1) AND e3_.removed = 0 GROUP BY e0_.target_id ORDER BY sclr_3 DESC LIMIT 1000;

SELECT
  t0.name AS name_1,
  t0.sku AS sku_2,
  t0.price_on_mirinly AS price_on_mirinly_3,
  t0.msrp AS msrp_4,
  t0.sale_price AS sale_price_5,
  t0.available_from_samples AS available_from_samples_6,
  t0.available_from_mirinly AS available_from_mirinly_7,
  t0.available AS available_8,
  t0.affiliate_url AS affiliate_url_9,
  t0.thumbnail AS thumbnail_10,
  t0.additional_image_1 AS additional_image_1_11,
  t0.additional_image_2 AS additional_image_2_12,
  t0.additional_image_3 AS additional_image_3_13,
  t0.additional_image_4 AS additional_image_4_14,
  t0.sizeGuide AS sizeGuide_15,
  t0.description AS description_16,
  t0.position AS position_17,
  t0.id AS id_18,
  t0.featured AS featured_19,
  t0.sponsored_global AS sponsored_global_20,
  t0.sponsored_category AS sponsored_category_21,
  t0.sponsored_sub_category AS sponsored_sub_category_22,
  t0.based_in AS based_in_23,
  t0.other_sizes_colors AS other_sizes_colors_24,
  t0.measurement_type AS measurement_type_25,
  t0.insurance_type AS insurance_type_26,
  t0.insurance AS insurance_27,
  t0.reasonable_wear_and_tear AS reasonable_wear_and_tear_28,
  t0.low_volume_production AS low_volume_production_29,
  t0.shipping_policy AS shipping_policy_30,
  t0.return_policy AS return_policy_31,
  t0.care AS care_32,
  t0.created AS created_33,
  t0.enable_shopify_sync AS enable_shopify_sync_34,
  t0.enable_squarecpase_sync AS enable_squarecpase_sync_35,
  t0.imported AS imported_36,
  t0.removed AS removed_37,
  t0.once_assigned AS once_assigned_38,
  t0.default_cities AS default_cities_39,
  t0.default_search_tags AS default_search_tags_40,
  t0.external_id AS external_id_41,
  t0.finalized_date AS finalized_date_42,
  t0.e_commerce_subcategory_id AS e_commerce_subcategory_id_43,
  t0.e_commerce_item_type_id AS e_commerce_item_type_id_44,
  t0.e_commerce_item_template_id AS e_commerce_item_template_id_45,
  t0.brand_id AS brand_id_46,
  t0.main_image_id AS main_image_id_47,
  t48.id AS id_49,
  t48.loan AS loan_50,
  t48.loan_show AS loan_show_51,
  t48.loan_film AS loan_film_52,
  t48.loan_music_video AS loan_music_video_53,
  t48.loan_music_artist AS loan_music_artist_54,
  t48.loan_talent AS loan_talent_55,
  t48.loan_editorial AS loan_editorial_56,
  t48.loan_advertisement AS loan_advertisement_57,
  t48.loan_photoshoot AS loan_photoshoot_58,
  t48.loan_red_carpet AS loan_red_carpet_59,
  t48.loan_other AS loan_other_60,
  t48.loan_buyout_show AS loan_buyout_show_61,
  t48.loan_buyout_film AS loan_buyout_film_62,
  t48.loan_buyout_music_video AS loan_buyout_music_video_63,
  t48.loan_buyout_music_artist AS loan_buyout_music_artist_64,
  t48.loan_buyout_talent AS loan_buyout_talent_65,
  t48.loan_buyout_editorial AS loan_buyout_editorial_66,
  t48.loan_buyout_advertisement AS loan_buyout_advertisement_67,
  t48.loan_buyout_photoshoot AS loan_buyout_photoshoot_68,
  t48.loan_buyout_red_carpet AS loan_buyout_red_carpet_69,
  t48.loan_buyout_other AS loan_buyout_other_70,
  t48.quantity_general AS quantity_general_71,
  t48.quantity AS quantity_72,
  t48.return_insurance_general AS return_insurance_general_73,
  t48.return_insurance AS return_insurance_74,
  t48.policy_insurance_general AS policy_insurance_general_75,
  t48.policy_insurance AS policy_insurance_76,
  t48.default_reasonable_wear_and_tear AS default_reasonable_wear_and_tear_77,
  t48.reasonable_wear_and_tear AS reasonable_wear_and_tear_78,
  t48.default_late_fee AS default_late_fee_79,
  t48.late_fee_type AS late_fee_type_80,
  t48.late_fee_amount AS late_fee_amount_81,
  t48.late_fee_percent AS late_fee_percent_82,
  t48.late_fee_period AS late_fee_period_83,
  t48.loan_buyout AS loan_buyout_84,
  t48.loan_buyout_price_type AS loan_buyout_price_type_85,
  t48.loan_buyout_price_value AS loan_buyout_price_value_86,
  t48.security_hold AS security_hold_87,
  t48.security_hold_percent AS security_hold_percent_88,
  t48.shopify_sync AS shopify_sync_89,
  t48.shopify_sync_add AS shopify_sync_add_90,
  t48.squarespace_sync AS squarespace_sync_91,
  t48.squarespace_sync_add AS squarespace_sync_add_92,
  t48.default_quantity_update AS default_quantity_update_93,
  t48.quantity_update AS quantity_update_94,
  t48.item_id AS item_id_95,
  t96.id AS id_97,
  t96.rental AS rental_98,
  t96.rental_show AS rental_show_99,
  t96.rental_film AS rental_film_100,
  t96.rental_music_video AS rental_music_video_101,
  t96.rental_music_artist AS rental_music_artist_102,
  t96.rental_talent AS rental_talent_103,
  t96.rental_editorial AS rental_editorial_104,
  t96.rental_advertisement AS rental_advertisement_105,
  t96.rental_photoshoot AS rental_photoshoot_106,
  t96.rental_red_carpet AS rental_red_carpet_107,
  t96.rental_other AS rental_other_108,
  t96.rental_buyout_show AS rental_buyout_show_109,
  t96.rental_buyout_film AS rental_buyout_film_110,
  t96.rental_buyout_music_video AS rental_buyout_music_video_111,
  t96.rental_buyout_music_artist AS rental_buyout_music_artist_112,
  t96.rental_buyout_talent AS rental_buyout_talent_113,
  t96.rental_buyout_editorial AS rental_buyout_editorial_114,
  t96.rental_buyout_advertisement AS rental_buyout_advertisement_115,
  t96.rental_buyout_photoshoot AS rental_buyout_photoshoot_116,
  t96.rental_buyout_red_carpet AS rental_buyout_red_carpet_117,
  t96.rental_buyout_other AS rental_buyout_other_118,
  t96.quantity_general AS quantity_general_119,
  t96.quantity AS quantity_120,
  t96.rental_price_type_general AS rental_price_type_general_121,
  t96.rental_price_value AS rental_price_value_122,
  t96.rental_period_general AS rental_period_general_123,
  t96.return_insurance_general AS return_insurance_general_124,
  t96.return_insurance AS return_insurance_125,
  t96.policy_insurance_general AS policy_insurance_general_126,
  t96.policy_insurance AS policy_insurance_127,
  t96.default_reasonable_wear_and_tear AS default_reasonable_wear_and_tear_128,
  t96.reasonable_wear_and_tear AS reasonable_wear_and_tear_129,
  t96.default_late_fee AS default_late_fee_130,
  t96.late_fee_type AS late_fee_type_131,
  t96.late_fee_amount AS late_fee_amount_132,
  t96.late_fee_percent AS late_fee_percent_133,
  t96.late_fee_period AS late_fee_period_134,
  t96.rental_buyout AS rental_buyout_135,
  t96.rental_buyout_price_type AS rental_buyout_price_type_136,
  t96.rental_buyout_price_value AS rental_buyout_price_value_137,
  t96.security_hold AS security_hold_138,
  t96.security_hold_percent AS security_hold_percent_139,
  t96.shopify_sync AS shopify_sync_140,
  t96.shopify_sync_add AS shopify_sync_add_141,
  t96.squarespace_sync AS squarespace_sync_142,
  t96.squarespace_sync_add AS squarespace_sync_add_143,
  t96.default_quantity_update AS default_quantity_update_144,
  t96.quantity_update AS quantity_update_145,
  t96.item_id AS item_id_146,
  t147.id AS id_148,
  t147.purchase AS purchase_149,
  t147.purchase_show AS purchase_show_150,
  t147.purchase_film AS purchase_film_151,
  t147.purchase_music_video AS purchase_music_video_152,
  t147.purchase_music_artist AS purchase_music_artist_153,
  t147.purchase_talent AS purchase_talent_154,
  t147.purchase_editorial AS purchase_editorial_155,
  t147.purchase_advertisement AS purchase_advertisement_156,
  t147.purchase_photoshoot AS purchase_photoshoot_157,
  t147.purchase_red_carpet AS purchase_red_carpet_158,
  t147.purchase_other AS purchase_other_159,
  t147.reserve_purchase_show AS reserve_purchase_show_160,
  t147.reserve_purchase_film AS reserve_purchase_film_161,
  t147.reserve_purchase_music_video AS reserve_purchase_music_video_162,
  t147.reserve_purchase_music_artist AS reserve_purchase_music_artist_163,
  t147.reserve_purchase_talent AS reserve_purchase_talent_164,
  t147.reserve_purchase_editorial AS reserve_purchase_editorial_165,
  t147.reserve_purchase_advertisement AS reserve_purchase_advertisement_166,
  t147.reserve_purchase_photoshoot AS reserve_purchase_photoshoot_167,
  t147.reserve_purchase_red_carpet AS reserve_purchase_red_carpet_168,
  t147.reserve_purchase_other AS reserve_purchase_other_169,
  t147.quantity_general AS quantity_general_170,
  t147.quantity AS quantity_171,
  t147.purchase_price_type_general AS purchase_price_type_general_172,
  t147.purchase_price_value AS purchase_price_value_173,
  t147.reserve_purchase AS reserve_purchase_174,
  t147.reserve_purchase_price_type AS reserve_purchase_price_type_175,
  t147.reserve_purchase_price_value AS reserve_purchase_price_value_176,
  t147.made_to_order_type AS made_to_order_type_177,
  t147.pre_order_type AS pre_order_type_178,
  t147.default_return_policy AS default_return_policy_179,
  t147.return_policy AS return_policy_180,
  t147.default_care AS default_care_181,
  t147.care AS care_182,
  t147.shopify_sync AS shopify_sync_183,
  t147.shopify_sync_add AS shopify_sync_add_184,
  t147.squarespace_sync AS squarespace_sync_185,
  t147.squarespace_sync_add AS squarespace_sync_add_186,
  t147.default_quantity_update AS default_quantity_update_187,
  t147.quantity_update AS quantity_update_188,
  t147.item_id AS item_id_189,
  t190.id AS id_191,
  t190.in_person AS in_person_192,
  t190.quantity_general AS quantity_general_193,
  t190.quantity AS quantity_194,
  t190.industry_discount_type_general AS industry_discount_type_general_195,
  t190.industry_discount_value AS industry_discount_value_196,
  t190.made_to_order_type AS made_to_order_type_197,
  t190.pre_order_type AS pre_order_type_198,
  t190.shopify_sync AS shopify_sync_199,
  t190.shopify_sync_add AS shopify_sync_add_200,
  t190.squarespace_sync AS squarespace_sync_201,
  t190.squarespace_sync_add AS squarespace_sync_add_202,
  t190.default_quantity_update AS default_quantity_update_203,
  t190.quantity_update AS quantity_update_204,
  t190.item_id AS item_id_205,
  t206.id AS id_207,
  t206.discovery AS discovery_208,
  t206.discovery_show AS discovery_show_209,
  t206.discovery_film AS discovery_film_210,
  t206.discovery_music_video AS discovery_music_video_211,
  t206.discovery_music_artist AS discovery_music_artist_212,
  t206.discovery_talent AS discovery_talent_213,
  t206.discovery_editorial AS discovery_editorial_214,
  t206.discovery_advertisement AS discovery_advertisement_215,
  t206.quantity_general AS quantity_general_216,
  t206.quantity AS quantity_217,
  t206.made_to_order_type AS made_to_order_type_218,
  t206.pre_order_type AS pre_order_type_219,
  t206.default_shipping_policy AS default_shipping_policy_220,
  t206.shipping_policy AS shipping_policy_221,
  t206.default_return_policy AS default_return_policy_222,
  t206.return_policy AS return_policy_223,
  t206.default_care AS default_care_224,
  t206.care AS care_225,
  t206.shopify_sync AS shopify_sync_226,
  t206.shopify_sync_add AS shopify_sync_add_227,
  t206.squarespace_sync AS squarespace_sync_228,
  t206.squarespace_sync_add AS squarespace_sync_add_229,
  t206.default_quantity_update AS default_quantity_update_230,
  t206.quantity_update AS quantity_update_231,
  t206.item_id AS item_id_232
FROM
  e_commerce_item t0
  LEFT JOIN e_commerce_item_settings_loan t48 ON t48.item_id = t0.id
  LEFT JOIN e_commerce_item_settings_rental t96 ON t96.item_id = t0.id
  LEFT JOIN e_commerce_item_settings_purchase t147 ON t147.item_id = t0.id
  LEFT JOIN e_commerce_item_settings_in_person t190 ON t190.item_id = t0.id
  LEFT JOIN e_commerce_item_settings_discovery t206 ON t206.item_id = t0.id
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.sku AS sku_2, t0.price_on_mirinly AS price_on_mirinly_3, t0.msrp AS msrp_4, t0.sale_price AS sale_price_5, t0.available_from_samples AS available_from_samples_6, t0.available_from_mirinly AS available_from_mirinly_7, t0.available AS available_8, t0.affiliate_url AS affiliate_url_9, t0.thumbnail AS thumbnail_10, t0.additional_image_1 AS additional_image_1_11, t0.additional_image_2 AS additional_image_2_12, t0.additional_image_3 AS additional_image_3_13, t0.additional_image_4 AS additional_image_4_14, t0.sizeGuide AS sizeGuide_15, t0.description AS description_16, t0.position AS position_17, t0.id AS id_18, t0.featured AS featured_19, t0.sponsored_global AS sponsored_global_20, t0.sponsored_category AS sponsored_category_21, t0.sponsored_sub_category AS sponsored_sub_category_22, t0.based_in AS based_in_23, t0.other_sizes_colors AS other_sizes_colors_24, t0.measurement_type AS measurement_type_25, t0.insurance_type AS insurance_type_26, t0.insurance AS insurance_27, t0.reasonable_wear_and_tear AS reasonable_wear_and_tear_28, t0.low_volume_production AS low_volume_production_29, t0.shipping_policy AS shipping_policy_30, t0.return_policy AS return_policy_31, t0.care AS care_32, t0.created AS created_33, t0.enable_shopify_sync AS enable_shopify_sync_34, t0.enable_squarecpase_sync AS enable_squarecpase_sync_35, t0.imported AS imported_36, t0.removed AS removed_37, t0.once_assigned AS once_assigned_38, t0.default_cities AS default_cities_39, t0.default_search_tags AS default_search_tags_40, t0.external_id AS external_id_41, t0.finalized_date AS finalized_date_42, t0.e_commerce_subcategory_id AS e_commerce_subcategory_id_43, t0.e_commerce_item_type_id AS e_commerce_item_type_id_44, t0.e_commerce_item_template_id AS e_commerce_item_template_id_45, t0.brand_id AS brand_id_46, t0.main_image_id AS main_image_id_47, t48.id AS id_49, t48.loan AS loan_50, t48.loan_show AS loan_show_51, t48.loan_film AS loan_film_52, t48.loan_music_video AS loan_music_video_53, t48.loan_music_artist AS loan_music_artist_54, t48.loan_talent AS loan_talent_55, t48.loan_editorial AS loan_editorial_56, t48.loan_advertisement AS loan_advertisement_57, t48.loan_photoshoot AS loan_photoshoot_58, t48.loan_red_carpet AS loan_red_carpet_59, t48.loan_other AS loan_other_60, t48.loan_buyout_show AS loan_buyout_show_61, t48.loan_buyout_film AS loan_buyout_film_62, t48.loan_buyout_music_video AS loan_buyout_music_video_63, t48.loan_buyout_music_artist AS loan_buyout_music_artist_64, t48.loan_buyout_talent AS loan_buyout_talent_65, t48.loan_buyout_editorial AS loan_buyout_editorial_66, t48.loan_buyout_advertisement AS loan_buyout_advertisement_67, t48.loan_buyout_photoshoot AS loan_buyout_photoshoot_68, t48.loan_buyout_red_carpet AS loan_buyout_red_carpet_69, t48.loan_buyout_other AS loan_buyout_other_70, t48.quantity_general AS quantity_general_71, t48.quantity AS quantity_72, t48.return_insurance_general AS return_insurance_general_73, t48.return_insurance AS return_insurance_74, t48.policy_insurance_general AS policy_insurance_general_75, t48.policy_insurance AS policy_insurance_76, t48.default_reasonable_wear_and_tear AS default_reasonable_wear_and_tear_77, t48.reasonable_wear_and_tear AS reasonable_wear_and_tear_78, t48.default_late_fee AS default_late_fee_79, t48.late_fee_type AS late_fee_type_80, t48.late_fee_amount AS late_fee_amount_81, t48.late_fee_percent AS late_fee_percent_82, t48.late_fee_period AS late_fee_period_83, t48.loan_buyout AS loan_buyout_84, t48.loan_buyout_price_type AS loan_buyout_price_type_85, t48.loan_buyout_price_value AS loan_buyout_price_value_86, t48.security_hold AS security_hold_87, t48.security_hold_percent AS security_hold_percent_88, t48.shopify_sync AS shopify_sync_89, t48.shopify_sync_add AS shopify_sync_add_90, t48.squarespace_sync AS squarespace_sync_91, t48.squarespace_sync_add AS squarespace_sync_add_92, t48.default_quantity_update AS default_quantity_update_93, t48.quantity_update AS quantity_update_94, t48.item_id AS item_id_95, t96.id AS id_97, t96.rental AS rental_98, t96.rental_show AS rental_show_99, t96.rental_film AS rental_film_100, t96.rental_music_video AS rental_music_video_101, t96.rental_music_artist AS rental_music_artist_102, t96.rental_talent AS rental_talent_103, t96.rental_editorial AS rental_editorial_104, t96.rental_advertisement AS rental_advertisement_105, t96.rental_photoshoot AS rental_photoshoot_106, t96.rental_red_carpet AS rental_red_carpet_107, t96.rental_other AS rental_other_108, t96.rental_buyout_show AS rental_buyout_show_109, t96.rental_buyout_film AS rental_buyout_film_110, t96.rental_buyout_music_video AS rental_buyout_music_video_111, t96.rental_buyout_music_artist AS rental_buyout_music_artist_112, t96.rental_buyout_talent AS rental_buyout_talent_113, t96.rental_buyout_editorial AS rental_buyout_editorial_114, t96.rental_buyout_advertisement AS rental_buyout_advertisement_115, t96.rental_buyout_photoshoot AS rental_buyout_photoshoot_116, t96.rental_buyout_red_carpet AS rental_buyout_red_carpet_117, t96.rental_buyout_other AS rental_buyout_other_118, t96.quantity_general AS quantity_general_119, t96.quantity AS quantity_120, t96.rental_price_type_general AS rental_price_type_general_121, t96.rental_price_value AS rental_price_value_122, t96.rental_period_general AS rental_period_general_123, t96.return_insurance_general AS return_insurance_general_124, t96.return_insurance AS return_insurance_125, t96.policy_insurance_general AS policy_insurance_general_126, t96.policy_insurance AS policy_insurance_127, t96.default_reasonable_wear_and_tear AS default_reasonable_wear_and_tear_128, t96.reasonable_wear_and_tear AS reasonable_wear_and_tear_129, t96.default_late_fee AS default_late_fee_130, t96.late_fee_type AS late_fee_type_131, t96.late_fee_amount AS late_fee_amount_132, t96.late_fee_percent AS late_fee_percent_133, t96.late_fee_period AS late_fee_period_134, t96.rental_buyout AS rental_buyout_135, t96.rental_buyout_price_type AS rental_buyout_price_type_136, t96.rental_buyout_price_value AS rental_buyout_price_value_137, t96.security_hold AS security_hold_138, t96.security_hold_percent AS security_hold_percent_139, t96.shopify_sync AS shopify_sync_140, t96.shopify_sync_add AS shopify_sync_add_141, t96.squarespace_sync AS squarespace_sync_142, t96.squarespace_sync_add AS squarespace_sync_add_143, t96.default_quantity_update AS default_quantity_update_144, t96.quantity_update AS quantity_update_145, t96.item_id AS item_id_146, t147.id AS id_148, t147.purchase AS purchase_149, t147.purchase_show AS purchase_show_150, t147.purchase_film AS purchase_film_151, t147.purchase_music_video AS purchase_music_video_152, t147.purchase_music_artist AS purchase_music_artist_153, t147.purchase_talent AS purchase_talent_154, t147.purchase_editorial AS purchase_editorial_155, t147.purchase_advertisement AS purchase_advertisement_156, t147.purchase_photoshoot AS purchase_photoshoot_157, t147.purchase_red_carpet AS purchase_red_carpet_158, t147.purchase_other AS purchase_other_159, t147.reserve_purchase_show AS reserve_purchase_show_160, t147.reserve_purchase_film AS reserve_purchase_film_161, t147.reserve_purchase_music_video AS reserve_purchase_music_video_162, t147.reserve_purchase_music_artist AS reserve_purchase_music_artist_163, t147.reserve_purchase_talent AS reserve_purchase_talent_164, t147.reserve_purchase_editorial AS reserve_purchase_editorial_165, t147.reserve_purchase_advertisement AS reserve_purchase_advertisement_166, t147.reserve_purchase_photoshoot AS reserve_purchase_photoshoot_167, t147.reserve_purchase_red_carpet AS reserve_purchase_red_carpet_168, t147.reserve_purchase_other AS reserve_purchase_other_169, t147.quantity_general AS quantity_general_170, t147.quantity AS quantity_171, t147.purchase_price_type_general AS purchase_price_type_general_172, t147.purchase_price_value AS purchase_price_value_173, t147.reserve_purchase AS reserve_purchase_174, t147.reserve_purchase_price_type AS reserve_purchase_price_type_175, t147.reserve_purchase_price_value AS reserve_purchase_price_value_176, t147.made_to_order_type AS made_to_order_type_177, t147.pre_order_type AS pre_order_type_178, t147.default_return_policy AS default_return_policy_179, t147.return_policy AS return_policy_180, t147.default_care AS default_care_181, t147.care AS care_182, t147.shopify_sync AS shopify_sync_183, t147.shopify_sync_add AS shopify_sync_add_184, t147.squarespace_sync AS squarespace_sync_185, t147.squarespace_sync_add AS squarespace_sync_add_186, t147.default_quantity_update AS default_quantity_update_187, t147.quantity_update AS quantity_update_188, t147.item_id AS item_id_189, t190.id AS id_191, t190.in_person AS in_person_192, t190.quantity_general AS quantity_general_193, t190.quantity AS quantity_194, t190.industry_discount_type_general AS industry_discount_type_general_195, t190.industry_discount_value AS industry_discount_value_196, t190.made_to_order_type AS made_to_order_type_197, t190.pre_order_type AS pre_order_type_198, t190.shopify_sync AS shopify_sync_199, t190.shopify_sync_add AS shopify_sync_add_200, t190.squarespace_sync AS squarespace_sync_201, t190.squarespace_sync_add AS squarespace_sync_add_202, t190.default_quantity_update AS default_quantity_update_203, t190.quantity_update AS quantity_update_204, t190.item_id AS item_id_205, t206.id AS id_207, t206.discovery AS discovery_208, t206.discovery_show AS discovery_show_209, t206.discovery_film AS discovery_film_210, t206.discovery_music_video AS discovery_music_video_211, t206.discovery_music_artist AS discovery_music_artist_212, t206.discovery_talent AS discovery_talent_213, t206.discovery_editorial AS discovery_editorial_214, t206.discovery_advertisement AS discovery_advertisement_215, t206.quantity_general AS quantity_general_216, t206.quantity AS quantity_217, t206.made_to_order_type AS made_to_order_type_218, t206.pre_order_type AS pre_order_type_219, t206.default_shipping_policy AS default_shipping_policy_220, t206.shipping_policy AS shipping_policy_221, t206.default_return_policy AS default_return_policy_222, t206.return_policy AS return_policy_223, t206.default_care AS default_care_224, t206.care AS care_225, t206.shopify_sync AS shopify_sync_226, t206.shopify_sync_add AS shopify_sync_add_227, t206.squarespace_sync AS squarespace_sync_228, t206.squarespace_sync_add AS squarespace_sync_add_229, t206.default_quantity_update AS default_quantity_update_230, t206.quantity_update AS quantity_update_231, t206.item_id AS item_id_232 FROM e_commerce_item t0 LEFT JOIN e_commerce_item_settings_loan t48 ON t48.item_id = t0.id LEFT JOIN e_commerce_item_settings_rental t96 ON t96.item_id = t0.id LEFT JOIN e_commerce_item_settings_purchase t147 ON t147.item_id = t0.id LEFT JOIN e_commerce_item_settings_in_person t190 ON t190.item_id = t0.id LEFT JOIN e_commerce_item_settings_discovery t206 ON t206.item_id = t0.id WHERE t0.id = 41947;

SELECT
  t0.name AS name_1,
  t0.position AS position_2,
  t0.id AS id_3,
  t0.e_commerce_category_id AS e_commerce_category_id_4
FROM
  e_commerce_subcategory t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.position AS position_2, t0.id AS id_3, t0.e_commerce_category_id AS e_commerce_category_id_4 FROM e_commerce_subcategory t0 WHERE t0.id = 58;

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 = 11;