Symfony Profiler

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
  e0_.name AS name_0,
  e0_.sku AS sku_1,
  e0_.price_on_mirinly AS price_on_mirinly_2,
  e0_.msrp AS msrp_3,
  e0_.sale_price AS sale_price_4,
  e0_.available_from_samples AS available_from_samples_5,
  e0_.available_from_mirinly AS available_from_mirinly_6,
  e0_.available AS available_7,
  e0_.affiliate_url AS affiliate_url_8,
  e0_.thumbnail AS thumbnail_9,
  e0_.additional_image_1 AS additional_image_1_10,
  e0_.additional_image_2 AS additional_image_2_11,
  e0_.additional_image_3 AS additional_image_3_12,
  e0_.additional_image_4 AS additional_image_4_13,
  e0_.sizeGuide AS sizeGuide_14,
  e0_.description AS description_15,
  e0_.position AS position_16,
  e0_.id AS id_17,
  e0_.featured AS featured_18,
  e0_.sponsored_global AS sponsored_global_19,
  e0_.sponsored_category AS sponsored_category_20,
  e0_.sponsored_sub_category AS sponsored_sub_category_21,
  e0_.based_in AS based_in_22,
  e0_.other_sizes_colors AS other_sizes_colors_23,
  e0_.measurement_type AS measurement_type_24,
  e0_.insurance_type AS insurance_type_25,
  e0_.insurance AS insurance_26,
  e0_.reasonable_wear_and_tear AS reasonable_wear_and_tear_27,
  e0_.low_volume_production AS low_volume_production_28,
  e0_.shipping_policy AS shipping_policy_29,
  e0_.return_policy AS return_policy_30,
  e0_.care AS care_31,
  e0_.created AS created_32,
  e0_.enable_shopify_sync AS enable_shopify_sync_33,
  e0_.enable_squarecpase_sync AS enable_squarecpase_sync_34,
  e0_.imported AS imported_35,
  e0_.removed AS removed_36,
  e0_.once_assigned AS once_assigned_37,
  e0_.default_cities AS default_cities_38,
  e0_.default_search_tags AS default_search_tags_39,
  e0_.external_id AS external_id_40,
  e0_.finalized_date AS finalized_date_41,
  e0_.e_commerce_subcategory_id AS e_commerce_subcategory_id_42,
  e0_.e_commerce_item_type_id AS e_commerce_item_type_id_43,
  e0_.e_commerce_item_template_id AS e_commerce_item_template_id_44,
  e0_.brand_id AS brand_id_45,
  e0_.main_image_id AS main_image_id_46
FROM
  e_commerce_item e0_
  LEFT JOIN bind_film_scene_item_character b1_ ON (b1_.e_commerce_item_id = e0_.id)
  LEFT JOIN bind_film_character_signature_item b2_ ON (b2_.e_commerce_item_id = e0_.id)
  LEFT JOIN bind_film_set_item b3_ ON (b3_.e_commerce_item_id = e0_.id)
  LEFT JOIN bind_film_merch b4_ ON (b4_.e_commerce_item_id = e0_.id)
  LEFT JOIN bind_film_post_item_character b5_ ON (b5_.e_commerce_item_id = e0_.id)
  LEFT JOIN film_scene f6_ ON b1_.film_scene_id = f6_.id
  AND (f6_.publish = 1)
  LEFT JOIN film_character_signature f7_ ON b2_.film_character_signature_id = f7_.id
  LEFT JOIN film_character f8_ ON f7_.character_id = f8_.id
  LEFT JOIN film_set f9_ ON b3_.film_set_id = f9_.id
  AND (f9_.publish = 1)
  LEFT JOIN film_set_category f10_ ON f9_.film_set_category_id = f10_.id
  AND (f10_.publish = 1)
  LEFT JOIN film_merch f11_ ON b4_.film_merch_id = f11_.id
  AND (f11_.publish = 1)
  LEFT JOIN film_posts f12_ ON b5_.film_post_id = f12_.id
  AND (f12_.publish = 1)
  LEFT JOIN film f13_ ON (
    f13_.publish = 1
    AND f13_.id = f6_.film_id
    OR f13_.id = f8_.film_id
    OR f13_.id = f10_.film_id
    OR f13_.id = f11_.film_id
    OR f13_.id = f12_.film_id
  )
  LEFT JOIN bind_tv_show_scene_item_character b14_ ON (b14_.e_commerce_item_id = e0_.id)
  LEFT JOIN bind_tv_show_character_signature_item b15_ ON (b15_.e_commerce_item_id = e0_.id)
  LEFT JOIN bind_tv_show_set_item b16_ ON (b16_.e_commerce_item_id = e0_.id)
  LEFT JOIN bind_tv_show_merch b17_ ON (b17_.e_commerce_item_id = e0_.id)
  LEFT JOIN bind_tv_show_post_item_character b18_ ON (b18_.e_commerce_item_id = e0_.id)
  LEFT JOIN tv_show_scene t19_ ON b14_.tv_show_scene_id = t19_.id
  AND (t19_.publish = 1)
  LEFT JOIN tv_show_episode t20_ ON t19_.tv_show_episode_id = t20_.id
  AND (t20_.publish = 1)
  LEFT JOIN tv_show_season t21_ ON t20_.tv_show_season_id = t21_.id
  AND (t21_.publish = 1)
  LEFT JOIN tv_show_character_signature t22_ ON b15_.tv_show_character_signature_id = t22_.id
  AND (t22_.publish = 1)
  LEFT JOIN tv_show_character t23_ ON t22_.character_id = t23_.id
  LEFT JOIN tv_show_set t24_ ON b16_.tv_show_set_id = t24_.id
  AND (t24_.publish = 1)
  LEFT JOIN tv_show_set_category t25_ ON t24_.tv_show_set_category_id = t25_.id
  AND (t25_.publish = 1)
  LEFT JOIN tv_show_merch t26_ ON b17_.tv_show_merch_id = t26_.id
  AND (t26_.publish = 1)
  LEFT JOIN tv_show_posts t27_ ON b18_.tv_show_post_id = t27_.id
  AND (t27_.publish = 1)
  LEFT JOIN tv_show t28_ ON (
    t28_.publish = 1
    AND t28_.id = t21_.tv_show_id
    OR t28_.id = t23_.tv_show_id
    OR t28_.id = t25_.tv_show_id
    OR t28_.id = t26_.tv_show_id
    OR t28_.id = t27_.tv_show_id
  )
  LEFT JOIN bind_music_video_scene_item_character b29_ ON (b29_.e_commerce_item_id = e0_.id)
  LEFT JOIN bind_music_video_character_signature_item b30_ ON (b30_.e_commerce_item_id = e0_.id)
  LEFT JOIN bind_music_video_set_item b31_ ON (b31_.e_commerce_item_id = e0_.id)
  LEFT JOIN music_scene m32_ ON b29_.music_scene_id = m32_.id
  AND (m32_.publish = 1)
  LEFT JOIN music_video_character_signature m33_ ON b30_.music_video_character_signature_id = m33_.id
  LEFT JOIN music_video_character m34_ ON m33_.character_id = m34_.id
  LEFT JOIN music_video_set m35_ ON b31_.music_video_set_id = m35_.id
  AND (m35_.publish = 1)
  LEFT JOIN music_video_set_category m36_ ON m35_.music_video_set_category_id = m36_.id
  AND (m36_.publish = 1)
  LEFT JOIN music_video m37_ ON (
    m37_.publish = 1
    AND m37_.id = m32_.music_video_id
    OR m37_.id = m34_.music_video_id
    OR m37_.id = m36_.music_video_id
  )
  LEFT JOIN music_artist_to_music_video m39_ ON m37_.id = m39_.music_video_id
  LEFT JOIN music_artist m38_ ON m38_.id = m39_.music_artist_id
  LEFT JOIN bind_music_artist_merch b40_ ON (b40_.e_commerce_item_id = e0_.id)
  LEFT JOIN music_artist_merch m41_ ON b40_.music_artist_merch_id = m41_.id
  AND (m41_.publish = 1)
  LEFT JOIN bind_music_artist_post_item_character b42_ ON (b42_.e_commerce_item_id = e0_.id)
  LEFT JOIN music_artist_posts m43_ ON b42_.music_artist_post_id = m43_.id
  AND (m43_.publish = 1)
  LEFT JOIN bind_music_artist_post_item_guest_character b44_ ON (b44_.e_commerce_item_id = e0_.id)
  LEFT JOIN music_artist_posts m45_ ON b44_.music_artist_post_id = m45_.id
  AND (m45_.publish = 1)
  LEFT JOIN music_artist m46_ ON (
    m46_.publish = 1
    AND m46_.id = m41_.music_artist_id
    OR m46_.id = m43_.music_artist_id
    OR m46_.id = m45_.music_artist_id
  )
WHERE
  (
    f13_.publish = 1
    OR t28_.publish = 1
    OR (
      m37_.publish = 1
      AND m38_.publish = 1
    )
    OR m46_.publish = 1
  )
  AND e0_.removed = 0
  AND e0_.id = ?
GROUP BY
  e0_.name,
  e0_.sku,
  e0_.price_on_mirinly,
  e0_.msrp,
  e0_.sale_price,
  e0_.available_from_samples,
  e0_.available_from_mirinly,
  e0_.available,
  e0_.affiliate_url,
  e0_.thumbnail,
  e0_.additional_image_1,
  e0_.additional_image_2,
  e0_.additional_image_3,
  e0_.additional_image_4,
  e0_.sizeGuide,
  e0_.description,
  e0_.position,
  e0_.id,
  e0_.featured,
  e0_.sponsored_global,
  e0_.sponsored_category,
  e0_.sponsored_sub_category,
  e0_.based_in,
  e0_.other_sizes_colors,
  e0_.measurement_type,
  e0_.insurance_type,
  e0_.insurance,
  e0_.reasonable_wear_and_tear,
  e0_.low_volume_production,
  e0_.shipping_policy,
  e0_.return_policy,
  e0_.care,
  e0_.created,
  e0_.enable_shopify_sync,
  e0_.enable_squarecpase_sync,
  e0_.imported,
  e0_.removed,
  e0_.once_assigned,
  e0_.default_cities,
  e0_.default_search_tags,
  e0_.external_id,
  e0_.finalized_date,
  e0_.e_commerce_subcategory_id,
  e0_.e_commerce_item_type_id,
  e0_.e_commerce_item_template_id,
  e0_.brand_id,
  e0_.main_image_id

SELECT e0_.name AS name_0, e0_.sku AS sku_1, e0_.price_on_mirinly AS price_on_mirinly_2, e0_.msrp AS msrp_3, e0_.sale_price AS sale_price_4, e0_.available_from_samples AS available_from_samples_5, e0_.available_from_mirinly AS available_from_mirinly_6, e0_.available AS available_7, e0_.affiliate_url AS affiliate_url_8, e0_.thumbnail AS thumbnail_9, e0_.additional_image_1 AS additional_image_1_10, e0_.additional_image_2 AS additional_image_2_11, e0_.additional_image_3 AS additional_image_3_12, e0_.additional_image_4 AS additional_image_4_13, e0_.sizeGuide AS sizeGuide_14, e0_.description AS description_15, e0_.position AS position_16, e0_.id AS id_17, e0_.featured AS featured_18, e0_.sponsored_global AS sponsored_global_19, e0_.sponsored_category AS sponsored_category_20, e0_.sponsored_sub_category AS sponsored_sub_category_21, e0_.based_in AS based_in_22, e0_.other_sizes_colors AS other_sizes_colors_23, e0_.measurement_type AS measurement_type_24, e0_.insurance_type AS insurance_type_25, e0_.insurance AS insurance_26, e0_.reasonable_wear_and_tear AS reasonable_wear_and_tear_27, e0_.low_volume_production AS low_volume_production_28, e0_.shipping_policy AS shipping_policy_29, e0_.return_policy AS return_policy_30, e0_.care AS care_31, e0_.created AS created_32, e0_.enable_shopify_sync AS enable_shopify_sync_33, e0_.enable_squarecpase_sync AS enable_squarecpase_sync_34, e0_.imported AS imported_35, e0_.removed AS removed_36, e0_.once_assigned AS once_assigned_37, e0_.default_cities AS default_cities_38, e0_.default_search_tags AS default_search_tags_39, e0_.external_id AS external_id_40, e0_.finalized_date AS finalized_date_41, e0_.e_commerce_subcategory_id AS e_commerce_subcategory_id_42, e0_.e_commerce_item_type_id AS e_commerce_item_type_id_43, e0_.e_commerce_item_template_id AS e_commerce_item_template_id_44, e0_.brand_id AS brand_id_45, e0_.main_image_id AS main_image_id_46 FROM e_commerce_item e0_ LEFT JOIN bind_film_scene_item_character b1_ ON (b1_.e_commerce_item_id = e0_.id) LEFT JOIN bind_film_character_signature_item b2_ ON (b2_.e_commerce_item_id = e0_.id) LEFT JOIN bind_film_set_item b3_ ON (b3_.e_commerce_item_id = e0_.id) LEFT JOIN bind_film_merch b4_ ON (b4_.e_commerce_item_id = e0_.id) LEFT JOIN bind_film_post_item_character b5_ ON (b5_.e_commerce_item_id = e0_.id) LEFT JOIN film_scene f6_ ON b1_.film_scene_id = f6_.id AND (f6_.publish = 1) LEFT JOIN film_character_signature f7_ ON b2_.film_character_signature_id = f7_.id LEFT JOIN film_character f8_ ON f7_.character_id = f8_.id LEFT JOIN film_set f9_ ON b3_.film_set_id = f9_.id AND (f9_.publish = 1) LEFT JOIN film_set_category f10_ ON f9_.film_set_category_id = f10_.id AND (f10_.publish = 1) LEFT JOIN film_merch f11_ ON b4_.film_merch_id = f11_.id AND (f11_.publish = 1) LEFT JOIN film_posts f12_ ON b5_.film_post_id = f12_.id AND (f12_.publish = 1) LEFT JOIN film f13_ ON (f13_.publish = 1 AND f13_.id = f6_.film_id OR f13_.id = f8_.film_id OR f13_.id = f10_.film_id OR f13_.id = f11_.film_id OR f13_.id = f12_.film_id) LEFT JOIN bind_tv_show_scene_item_character b14_ ON (b14_.e_commerce_item_id = e0_.id) LEFT JOIN bind_tv_show_character_signature_item b15_ ON (b15_.e_commerce_item_id = e0_.id) LEFT JOIN bind_tv_show_set_item b16_ ON (b16_.e_commerce_item_id = e0_.id) LEFT JOIN bind_tv_show_merch b17_ ON (b17_.e_commerce_item_id = e0_.id) LEFT JOIN bind_tv_show_post_item_character b18_ ON (b18_.e_commerce_item_id = e0_.id) LEFT JOIN tv_show_scene t19_ ON b14_.tv_show_scene_id = t19_.id AND (t19_.publish = 1) LEFT JOIN tv_show_episode t20_ ON t19_.tv_show_episode_id = t20_.id AND (t20_.publish = 1) LEFT JOIN tv_show_season t21_ ON t20_.tv_show_season_id = t21_.id AND (t21_.publish = 1) LEFT JOIN tv_show_character_signature t22_ ON b15_.tv_show_character_signature_id = t22_.id AND (t22_.publish = 1) LEFT JOIN tv_show_character t23_ ON t22_.character_id = t23_.id LEFT JOIN tv_show_set t24_ ON b16_.tv_show_set_id = t24_.id AND (t24_.publish = 1) LEFT JOIN tv_show_set_category t25_ ON t24_.tv_show_set_category_id = t25_.id AND (t25_.publish = 1) LEFT JOIN tv_show_merch t26_ ON b17_.tv_show_merch_id = t26_.id AND (t26_.publish = 1) LEFT JOIN tv_show_posts t27_ ON b18_.tv_show_post_id = t27_.id AND (t27_.publish = 1) LEFT JOIN tv_show t28_ ON (t28_.publish = 1 AND t28_.id = t21_.tv_show_id OR t28_.id = t23_.tv_show_id OR t28_.id = t25_.tv_show_id OR t28_.id = t26_.tv_show_id OR t28_.id = t27_.tv_show_id) LEFT JOIN bind_music_video_scene_item_character b29_ ON (b29_.e_commerce_item_id = e0_.id) LEFT JOIN bind_music_video_character_signature_item b30_ ON (b30_.e_commerce_item_id = e0_.id) LEFT JOIN bind_music_video_set_item b31_ ON (b31_.e_commerce_item_id = e0_.id) LEFT JOIN music_scene m32_ ON b29_.music_scene_id = m32_.id AND (m32_.publish = 1) LEFT JOIN music_video_character_signature m33_ ON b30_.music_video_character_signature_id = m33_.id LEFT JOIN music_video_character m34_ ON m33_.character_id = m34_.id LEFT JOIN music_video_set m35_ ON b31_.music_video_set_id = m35_.id AND (m35_.publish = 1) LEFT JOIN music_video_set_category m36_ ON m35_.music_video_set_category_id = m36_.id AND (m36_.publish = 1) LEFT JOIN music_video m37_ ON (m37_.publish = 1 AND m37_.id = m32_.music_video_id OR m37_.id = m34_.music_video_id OR m37_.id = m36_.music_video_id) LEFT JOIN music_artist_to_music_video m39_ ON m37_.id = m39_.music_video_id LEFT JOIN music_artist m38_ ON m38_.id = m39_.music_artist_id LEFT JOIN bind_music_artist_merch b40_ ON (b40_.e_commerce_item_id = e0_.id) LEFT JOIN music_artist_merch m41_ ON b40_.music_artist_merch_id = m41_.id AND (m41_.publish = 1) LEFT JOIN bind_music_artist_post_item_character b42_ ON (b42_.e_commerce_item_id = e0_.id) LEFT JOIN music_artist_posts m43_ ON b42_.music_artist_post_id = m43_.id AND (m43_.publish = 1) LEFT JOIN bind_music_artist_post_item_guest_character b44_ ON (b44_.e_commerce_item_id = e0_.id) LEFT JOIN music_artist_posts m45_ ON b44_.music_artist_post_id = m45_.id AND (m45_.publish = 1) LEFT JOIN music_artist m46_ ON (m46_.publish = 1 AND m46_.id = m41_.music_artist_id OR m46_.id = m43_.music_artist_id OR m46_.id = m45_.music_artist_id) WHERE (f13_.publish = 1 OR t28_.publish = 1 OR (m37_.publish = 1 AND m38_.publish = 1) OR m46_.publish = 1) AND e0_.removed = 0 AND e0_.id = 41947 GROUP BY e0_.name, e0_.sku, e0_.price_on_mirinly, e0_.msrp, e0_.sale_price, e0_.available_from_samples, e0_.available_from_mirinly, e0_.available, e0_.affiliate_url, e0_.thumbnail, e0_.additional_image_1, e0_.additional_image_2, e0_.additional_image_3, e0_.additional_image_4, e0_.sizeGuide, e0_.description, e0_.position, e0_.id, e0_.featured, e0_.sponsored_global, e0_.sponsored_category, e0_.sponsored_sub_category, e0_.based_in, e0_.other_sizes_colors, e0_.measurement_type, e0_.insurance_type, e0_.insurance, e0_.reasonable_wear_and_tear, e0_.low_volume_production, e0_.shipping_policy, e0_.return_policy, e0_.care, e0_.created, e0_.enable_shopify_sync, e0_.enable_squarecpase_sync, e0_.imported, e0_.removed, e0_.once_assigned, e0_.default_cities, e0_.default_search_tags, e0_.external_id, e0_.finalized_date, e0_.e_commerce_subcategory_id, e0_.e_commerce_item_type_id, e0_.e_commerce_item_template_id, e0_.brand_id, e0_.main_image_id;

SELECT
  t0.id AS id_1,
  t0.loan AS loan_2,
  t0.loan_show AS loan_show_3,
  t0.loan_film AS loan_film_4,
  t0.loan_music_video AS loan_music_video_5,
  t0.loan_music_artist AS loan_music_artist_6,
  t0.loan_talent AS loan_talent_7,
  t0.loan_editorial AS loan_editorial_8,
  t0.loan_advertisement AS loan_advertisement_9,
  t0.loan_photoshoot AS loan_photoshoot_10,
  t0.loan_red_carpet AS loan_red_carpet_11,
  t0.loan_other AS loan_other_12,
  t0.loan_buyout_show AS loan_buyout_show_13,
  t0.loan_buyout_film AS loan_buyout_film_14,
  t0.loan_buyout_music_video AS loan_buyout_music_video_15,
  t0.loan_buyout_music_artist AS loan_buyout_music_artist_16,
  t0.loan_buyout_talent AS loan_buyout_talent_17,
  t0.loan_buyout_editorial AS loan_buyout_editorial_18,
  t0.loan_buyout_advertisement AS loan_buyout_advertisement_19,
  t0.loan_buyout_photoshoot AS loan_buyout_photoshoot_20,
  t0.loan_buyout_red_carpet AS loan_buyout_red_carpet_21,
  t0.loan_buyout_other AS loan_buyout_other_22,
  t0.quantity_general AS quantity_general_23,
  t0.quantity AS quantity_24,
  t0.return_insurance_general AS return_insurance_general_25,
  t0.return_insurance AS return_insurance_26,
  t0.policy_insurance_general AS policy_insurance_general_27,
  t0.policy_insurance AS policy_insurance_28,
  t0.default_reasonable_wear_and_tear AS default_reasonable_wear_and_tear_29,
  t0.reasonable_wear_and_tear AS reasonable_wear_and_tear_30,
  t0.default_late_fee AS default_late_fee_31,
  t0.late_fee_type AS late_fee_type_32,
  t0.late_fee_amount AS late_fee_amount_33,
  t0.late_fee_percent AS late_fee_percent_34,
  t0.late_fee_period AS late_fee_period_35,
  t0.loan_buyout AS loan_buyout_36,
  t0.loan_buyout_price_type AS loan_buyout_price_type_37,
  t0.loan_buyout_price_value AS loan_buyout_price_value_38,
  t0.security_hold AS security_hold_39,
  t0.security_hold_percent AS security_hold_percent_40,
  t0.shopify_sync AS shopify_sync_41,
  t0.shopify_sync_add AS shopify_sync_add_42,
  t0.squarespace_sync AS squarespace_sync_43,
  t0.squarespace_sync_add AS squarespace_sync_add_44,
  t0.default_quantity_update AS default_quantity_update_45,
  t0.quantity_update AS quantity_update_46,
  t0.item_id AS item_id_47
FROM
  e_commerce_item_settings_loan t0
WHERE
  t0.item_id = ?

SELECT t0.id AS id_1, t0.loan AS loan_2, t0.loan_show AS loan_show_3, t0.loan_film AS loan_film_4, t0.loan_music_video AS loan_music_video_5, t0.loan_music_artist AS loan_music_artist_6, t0.loan_talent AS loan_talent_7, t0.loan_editorial AS loan_editorial_8, t0.loan_advertisement AS loan_advertisement_9, t0.loan_photoshoot AS loan_photoshoot_10, t0.loan_red_carpet AS loan_red_carpet_11, t0.loan_other AS loan_other_12, t0.loan_buyout_show AS loan_buyout_show_13, t0.loan_buyout_film AS loan_buyout_film_14, t0.loan_buyout_music_video AS loan_buyout_music_video_15, t0.loan_buyout_music_artist AS loan_buyout_music_artist_16, t0.loan_buyout_talent AS loan_buyout_talent_17, t0.loan_buyout_editorial AS loan_buyout_editorial_18, t0.loan_buyout_advertisement AS loan_buyout_advertisement_19, t0.loan_buyout_photoshoot AS loan_buyout_photoshoot_20, t0.loan_buyout_red_carpet AS loan_buyout_red_carpet_21, t0.loan_buyout_other AS loan_buyout_other_22, t0.quantity_general AS quantity_general_23, t0.quantity AS quantity_24, t0.return_insurance_general AS return_insurance_general_25, t0.return_insurance AS return_insurance_26, t0.policy_insurance_general AS policy_insurance_general_27, t0.policy_insurance AS policy_insurance_28, t0.default_reasonable_wear_and_tear AS default_reasonable_wear_and_tear_29, t0.reasonable_wear_and_tear AS reasonable_wear_and_tear_30, t0.default_late_fee AS default_late_fee_31, t0.late_fee_type AS late_fee_type_32, t0.late_fee_amount AS late_fee_amount_33, t0.late_fee_percent AS late_fee_percent_34, t0.late_fee_period AS late_fee_period_35, t0.loan_buyout AS loan_buyout_36, t0.loan_buyout_price_type AS loan_buyout_price_type_37, t0.loan_buyout_price_value AS loan_buyout_price_value_38, t0.security_hold AS security_hold_39, t0.security_hold_percent AS security_hold_percent_40, t0.shopify_sync AS shopify_sync_41, t0.shopify_sync_add AS shopify_sync_add_42, t0.squarespace_sync AS squarespace_sync_43, t0.squarespace_sync_add AS squarespace_sync_add_44, t0.default_quantity_update AS default_quantity_update_45, t0.quantity_update AS quantity_update_46, t0.item_id AS item_id_47 FROM e_commerce_item_settings_loan t0 WHERE t0.item_id = 41947;

SELECT
  t0.id AS id_1,
  t0.rental AS rental_2,
  t0.rental_show AS rental_show_3,
  t0.rental_film AS rental_film_4,
  t0.rental_music_video AS rental_music_video_5,
  t0.rental_music_artist AS rental_music_artist_6,
  t0.rental_talent AS rental_talent_7,
  t0.rental_editorial AS rental_editorial_8,
  t0.rental_advertisement AS rental_advertisement_9,
  t0.rental_photoshoot AS rental_photoshoot_10,
  t0.rental_red_carpet AS rental_red_carpet_11,
  t0.rental_other AS rental_other_12,
  t0.rental_buyout_show AS rental_buyout_show_13,
  t0.rental_buyout_film AS rental_buyout_film_14,
  t0.rental_buyout_music_video AS rental_buyout_music_video_15,
  t0.rental_buyout_music_artist AS rental_buyout_music_artist_16,
  t0.rental_buyout_talent AS rental_buyout_talent_17,
  t0.rental_buyout_editorial AS rental_buyout_editorial_18,
  t0.rental_buyout_advertisement AS rental_buyout_advertisement_19,
  t0.rental_buyout_photoshoot AS rental_buyout_photoshoot_20,
  t0.rental_buyout_red_carpet AS rental_buyout_red_carpet_21,
  t0.rental_buyout_other AS rental_buyout_other_22,
  t0.quantity_general AS quantity_general_23,
  t0.quantity AS quantity_24,
  t0.rental_price_type_general AS rental_price_type_general_25,
  t0.rental_price_value AS rental_price_value_26,
  t0.rental_period_general AS rental_period_general_27,
  t0.return_insurance_general AS return_insurance_general_28,
  t0.return_insurance AS return_insurance_29,
  t0.policy_insurance_general AS policy_insurance_general_30,
  t0.policy_insurance AS policy_insurance_31,
  t0.default_reasonable_wear_and_tear AS default_reasonable_wear_and_tear_32,
  t0.reasonable_wear_and_tear AS reasonable_wear_and_tear_33,
  t0.default_late_fee AS default_late_fee_34,
  t0.late_fee_type AS late_fee_type_35,
  t0.late_fee_amount AS late_fee_amount_36,
  t0.late_fee_percent AS late_fee_percent_37,
  t0.late_fee_period AS late_fee_period_38,
  t0.rental_buyout AS rental_buyout_39,
  t0.rental_buyout_price_type AS rental_buyout_price_type_40,
  t0.rental_buyout_price_value AS rental_buyout_price_value_41,
  t0.security_hold AS security_hold_42,
  t0.security_hold_percent AS security_hold_percent_43,
  t0.shopify_sync AS shopify_sync_44,
  t0.shopify_sync_add AS shopify_sync_add_45,
  t0.squarespace_sync AS squarespace_sync_46,
  t0.squarespace_sync_add AS squarespace_sync_add_47,
  t0.default_quantity_update AS default_quantity_update_48,
  t0.quantity_update AS quantity_update_49,
  t0.item_id AS item_id_50
FROM
  e_commerce_item_settings_rental t0
WHERE
  t0.item_id = ?

SELECT t0.id AS id_1, t0.rental AS rental_2, t0.rental_show AS rental_show_3, t0.rental_film AS rental_film_4, t0.rental_music_video AS rental_music_video_5, t0.rental_music_artist AS rental_music_artist_6, t0.rental_talent AS rental_talent_7, t0.rental_editorial AS rental_editorial_8, t0.rental_advertisement AS rental_advertisement_9, t0.rental_photoshoot AS rental_photoshoot_10, t0.rental_red_carpet AS rental_red_carpet_11, t0.rental_other AS rental_other_12, t0.rental_buyout_show AS rental_buyout_show_13, t0.rental_buyout_film AS rental_buyout_film_14, t0.rental_buyout_music_video AS rental_buyout_music_video_15, t0.rental_buyout_music_artist AS rental_buyout_music_artist_16, t0.rental_buyout_talent AS rental_buyout_talent_17, t0.rental_buyout_editorial AS rental_buyout_editorial_18, t0.rental_buyout_advertisement AS rental_buyout_advertisement_19, t0.rental_buyout_photoshoot AS rental_buyout_photoshoot_20, t0.rental_buyout_red_carpet AS rental_buyout_red_carpet_21, t0.rental_buyout_other AS rental_buyout_other_22, t0.quantity_general AS quantity_general_23, t0.quantity AS quantity_24, t0.rental_price_type_general AS rental_price_type_general_25, t0.rental_price_value AS rental_price_value_26, t0.rental_period_general AS rental_period_general_27, t0.return_insurance_general AS return_insurance_general_28, t0.return_insurance AS return_insurance_29, t0.policy_insurance_general AS policy_insurance_general_30, t0.policy_insurance AS policy_insurance_31, t0.default_reasonable_wear_and_tear AS default_reasonable_wear_and_tear_32, t0.reasonable_wear_and_tear AS reasonable_wear_and_tear_33, t0.default_late_fee AS default_late_fee_34, t0.late_fee_type AS late_fee_type_35, t0.late_fee_amount AS late_fee_amount_36, t0.late_fee_percent AS late_fee_percent_37, t0.late_fee_period AS late_fee_period_38, t0.rental_buyout AS rental_buyout_39, t0.rental_buyout_price_type AS rental_buyout_price_type_40, t0.rental_buyout_price_value AS rental_buyout_price_value_41, t0.security_hold AS security_hold_42, t0.security_hold_percent AS security_hold_percent_43, t0.shopify_sync AS shopify_sync_44, t0.shopify_sync_add AS shopify_sync_add_45, t0.squarespace_sync AS squarespace_sync_46, t0.squarespace_sync_add AS squarespace_sync_add_47, t0.default_quantity_update AS default_quantity_update_48, t0.quantity_update AS quantity_update_49, t0.item_id AS item_id_50 FROM e_commerce_item_settings_rental t0 WHERE t0.item_id = 41947;

SELECT
  t0.id AS id_1,
  t0.purchase AS purchase_2,
  t0.purchase_show AS purchase_show_3,
  t0.purchase_film AS purchase_film_4,
  t0.purchase_music_video AS purchase_music_video_5,
  t0.purchase_music_artist AS purchase_music_artist_6,
  t0.purchase_talent AS purchase_talent_7,
  t0.purchase_editorial AS purchase_editorial_8,
  t0.purchase_advertisement AS purchase_advertisement_9,
  t0.purchase_photoshoot AS purchase_photoshoot_10,
  t0.purchase_red_carpet AS purchase_red_carpet_11,
  t0.purchase_other AS purchase_other_12,
  t0.reserve_purchase_show AS reserve_purchase_show_13,
  t0.reserve_purchase_film AS reserve_purchase_film_14,
  t0.reserve_purchase_music_video AS reserve_purchase_music_video_15,
  t0.reserve_purchase_music_artist AS reserve_purchase_music_artist_16,
  t0.reserve_purchase_talent AS reserve_purchase_talent_17,
  t0.reserve_purchase_editorial AS reserve_purchase_editorial_18,
  t0.reserve_purchase_advertisement AS reserve_purchase_advertisement_19,
  t0.reserve_purchase_photoshoot AS reserve_purchase_photoshoot_20,
  t0.reserve_purchase_red_carpet AS reserve_purchase_red_carpet_21,
  t0.reserve_purchase_other AS reserve_purchase_other_22,
  t0.quantity_general AS quantity_general_23,
  t0.quantity AS quantity_24,
  t0.purchase_price_type_general AS purchase_price_type_general_25,
  t0.purchase_price_value AS purchase_price_value_26,
  t0.reserve_purchase AS reserve_purchase_27,
  t0.reserve_purchase_price_type AS reserve_purchase_price_type_28,
  t0.reserve_purchase_price_value AS reserve_purchase_price_value_29,
  t0.made_to_order_type AS made_to_order_type_30,
  t0.pre_order_type AS pre_order_type_31,
  t0.default_return_policy AS default_return_policy_32,
  t0.return_policy AS return_policy_33,
  t0.default_care AS default_care_34,
  t0.care AS care_35,
  t0.shopify_sync AS shopify_sync_36,
  t0.shopify_sync_add AS shopify_sync_add_37,
  t0.squarespace_sync AS squarespace_sync_38,
  t0.squarespace_sync_add AS squarespace_sync_add_39,
  t0.default_quantity_update AS default_quantity_update_40,
  t0.quantity_update AS quantity_update_41,
  t0.item_id AS item_id_42
FROM
  e_commerce_item_settings_purchase t0
WHERE
  t0.item_id = ?

SELECT t0.id AS id_1, t0.purchase AS purchase_2, t0.purchase_show AS purchase_show_3, t0.purchase_film AS purchase_film_4, t0.purchase_music_video AS purchase_music_video_5, t0.purchase_music_artist AS purchase_music_artist_6, t0.purchase_talent AS purchase_talent_7, t0.purchase_editorial AS purchase_editorial_8, t0.purchase_advertisement AS purchase_advertisement_9, t0.purchase_photoshoot AS purchase_photoshoot_10, t0.purchase_red_carpet AS purchase_red_carpet_11, t0.purchase_other AS purchase_other_12, t0.reserve_purchase_show AS reserve_purchase_show_13, t0.reserve_purchase_film AS reserve_purchase_film_14, t0.reserve_purchase_music_video AS reserve_purchase_music_video_15, t0.reserve_purchase_music_artist AS reserve_purchase_music_artist_16, t0.reserve_purchase_talent AS reserve_purchase_talent_17, t0.reserve_purchase_editorial AS reserve_purchase_editorial_18, t0.reserve_purchase_advertisement AS reserve_purchase_advertisement_19, t0.reserve_purchase_photoshoot AS reserve_purchase_photoshoot_20, t0.reserve_purchase_red_carpet AS reserve_purchase_red_carpet_21, t0.reserve_purchase_other AS reserve_purchase_other_22, t0.quantity_general AS quantity_general_23, t0.quantity AS quantity_24, t0.purchase_price_type_general AS purchase_price_type_general_25, t0.purchase_price_value AS purchase_price_value_26, t0.reserve_purchase AS reserve_purchase_27, t0.reserve_purchase_price_type AS reserve_purchase_price_type_28, t0.reserve_purchase_price_value AS reserve_purchase_price_value_29, t0.made_to_order_type AS made_to_order_type_30, t0.pre_order_type AS pre_order_type_31, t0.default_return_policy AS default_return_policy_32, t0.return_policy AS return_policy_33, t0.default_care AS default_care_34, t0.care AS care_35, t0.shopify_sync AS shopify_sync_36, t0.shopify_sync_add AS shopify_sync_add_37, t0.squarespace_sync AS squarespace_sync_38, t0.squarespace_sync_add AS squarespace_sync_add_39, t0.default_quantity_update AS default_quantity_update_40, t0.quantity_update AS quantity_update_41, t0.item_id AS item_id_42 FROM e_commerce_item_settings_purchase t0 WHERE t0.item_id = 41947;

SELECT
  t0.id AS id_1,
  t0.in_person AS in_person_2,
  t0.quantity_general AS quantity_general_3,
  t0.quantity AS quantity_4,
  t0.industry_discount_type_general AS industry_discount_type_general_5,
  t0.industry_discount_value AS industry_discount_value_6,
  t0.made_to_order_type AS made_to_order_type_7,
  t0.pre_order_type AS pre_order_type_8,
  t0.shopify_sync AS shopify_sync_9,
  t0.shopify_sync_add AS shopify_sync_add_10,
  t0.squarespace_sync AS squarespace_sync_11,
  t0.squarespace_sync_add AS squarespace_sync_add_12,
  t0.default_quantity_update AS default_quantity_update_13,
  t0.quantity_update AS quantity_update_14,
  t0.item_id AS item_id_15
FROM
  e_commerce_item_settings_in_person t0
WHERE
  t0.item_id = ?

SELECT t0.id AS id_1, t0.in_person AS in_person_2, t0.quantity_general AS quantity_general_3, t0.quantity AS quantity_4, t0.industry_discount_type_general AS industry_discount_type_general_5, t0.industry_discount_value AS industry_discount_value_6, t0.made_to_order_type AS made_to_order_type_7, t0.pre_order_type AS pre_order_type_8, t0.shopify_sync AS shopify_sync_9, t0.shopify_sync_add AS shopify_sync_add_10, t0.squarespace_sync AS squarespace_sync_11, t0.squarespace_sync_add AS squarespace_sync_add_12, t0.default_quantity_update AS default_quantity_update_13, t0.quantity_update AS quantity_update_14, t0.item_id AS item_id_15 FROM e_commerce_item_settings_in_person t0 WHERE t0.item_id = 41947;