Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.publish AS publish_2,
  t0.name AS name_3,
  t0.owner_id AS owner_id_4,
  t0.owner_type AS owner_type_5,
  t0.tags AS tags_6,
  t0.published AS published_7
FROM
  admin_wishlist t0
WHERE
  t0.owner_type = ?
ORDER BY
  t0.published DESC
LIMIT
  5

SELECT t0.id AS id_1, t0.publish AS publish_2, t0.name AS name_3, t0.owner_id AS owner_id_4, t0.owner_type AS owner_type_5, t0.tags AS tags_6, t0.published AS published_7 FROM admin_wishlist t0 WHERE t0.owner_type = 'zeitgeist' ORDER BY t0.published DESC LIMIT 5;

SELECT
  a0_.id AS id_0,
  a0_.updated AS updated_1,
  a0_.admin_wishlist_id AS admin_wishlist_id_2,
  a0_.item_id AS item_id_3
FROM
  admin_wishlist_item a0_
  LEFT JOIN e_commerce_item e1_ ON a0_.item_id = e1_.id
  LEFT JOIN admin_wishlist a2_ ON a0_.admin_wishlist_id = a2_.id
  LEFT JOIN bind_film_scene_item_character b3_ ON (b3_.e_commerce_item_id = e1_.id)
  LEFT JOIN bind_film_character_signature_item b4_ ON (b4_.e_commerce_item_id = e1_.id)
  LEFT JOIN bind_film_set_item b5_ ON (b5_.e_commerce_item_id = e1_.id)
  LEFT JOIN bind_film_merch b6_ ON (b6_.e_commerce_item_id = e1_.id)
  LEFT JOIN bind_film_post_item_character b7_ ON (b7_.e_commerce_item_id = e1_.id)
  LEFT JOIN film_scene f8_ ON b3_.film_scene_id = f8_.id
  AND (f8_.publish = 1)
  LEFT JOIN film_character_signature f9_ ON b4_.film_character_signature_id = f9_.id
  LEFT JOIN film_character f10_ ON f9_.character_id = f10_.id
  LEFT JOIN film_set f11_ ON b5_.film_set_id = f11_.id
  AND (f11_.publish = 1)
  LEFT JOIN film_set_category f12_ ON f11_.film_set_category_id = f12_.id
  AND (f12_.publish = 1)
  LEFT JOIN film_merch f13_ ON b6_.film_merch_id = f13_.id
  AND (f13_.publish = 1)
  LEFT JOIN film_posts f14_ ON b7_.film_post_id = f14_.id
  AND (f14_.publish = 1)
  LEFT JOIN film f15_ ON (
    f15_.id = f8_.film_id
    OR f15_.id = f10_.film_id
    OR f15_.id = f12_.film_id
    OR f15_.id = f13_.film_id
    OR f15_.id = f14_.film_id
  )
  LEFT JOIN bind_tv_show_scene_item_character b16_ ON (b16_.e_commerce_item_id = e1_.id)
  LEFT JOIN bind_tv_show_character_signature_item b17_ ON (b17_.e_commerce_item_id = e1_.id)
  LEFT JOIN bind_tv_show_set_item b18_ ON (b18_.e_commerce_item_id = e1_.id)
  LEFT JOIN bind_tv_show_merch b19_ ON (b19_.e_commerce_item_id = e1_.id)
  LEFT JOIN bind_tv_show_post_item_character b20_ ON (b20_.e_commerce_item_id = e1_.id)
  LEFT JOIN tv_show_scene t21_ ON b16_.tv_show_scene_id = t21_.id
  AND (t21_.publish = 1)
  LEFT JOIN tv_show_episode t22_ ON t21_.tv_show_episode_id = t22_.id
  AND (t22_.publish = 1)
  LEFT JOIN tv_show_season t23_ ON t22_.tv_show_season_id = t23_.id
  AND (t23_.publish = 1)
  LEFT JOIN tv_show_character_signature t24_ ON b17_.tv_show_character_signature_id = t24_.id
  AND (t24_.publish = 1)
  LEFT JOIN tv_show_character t25_ ON t24_.character_id = t25_.id
  LEFT JOIN tv_show_set t26_ ON b18_.tv_show_set_id = t26_.id
  AND (t26_.publish = 1)
  LEFT JOIN tv_show_set_category t27_ ON t26_.tv_show_set_category_id = t27_.id
  AND (t27_.publish = 1)
  LEFT JOIN tv_show_merch t28_ ON b19_.tv_show_merch_id = t28_.id
  AND (t28_.publish = 1)
  LEFT JOIN tv_show_posts t29_ ON b20_.tv_show_post_id = t29_.id
  AND (t29_.publish = 1)
  LEFT JOIN tv_show t30_ ON (
    t30_.id = t23_.tv_show_id
    OR t30_.id = t25_.tv_show_id
    OR t30_.id = t27_.tv_show_id
    OR t30_.id = t28_.tv_show_id
    OR t30_.id = t29_.tv_show_id
  )
  LEFT JOIN bind_music_video_scene_item_character b31_ ON (b31_.e_commerce_item_id = e1_.id)
  LEFT JOIN bind_music_video_character_signature_item b32_ ON (b32_.e_commerce_item_id = e1_.id)
  LEFT JOIN bind_music_video_set_item b33_ ON (b33_.e_commerce_item_id = e1_.id)
  LEFT JOIN music_scene m34_ ON b31_.music_scene_id = m34_.id
  AND (m34_.publish = 1)
  LEFT JOIN music_video_character_signature m35_ ON b32_.music_video_character_signature_id = m35_.id
  LEFT JOIN music_video_character m36_ ON m35_.character_id = m36_.id
  LEFT JOIN music_video_set m37_ ON b33_.music_video_set_id = m37_.id
  AND (m37_.publish = 1)
  LEFT JOIN music_video_set_category m38_ ON m37_.music_video_set_category_id = m38_.id
  AND (m38_.publish = 1)
  LEFT JOIN music_video m39_ ON (
    m39_.id = m34_.music_video_id
    OR m39_.id = m36_.music_video_id
    OR m39_.id = m38_.music_video_id
  )
  LEFT JOIN music_artist_to_music_video m41_ ON m39_.id = m41_.music_video_id
  LEFT JOIN music_artist m40_ ON m40_.id = m41_.music_artist_id
  LEFT JOIN bind_music_artist_merch b42_ ON (b42_.e_commerce_item_id = e1_.id)
  LEFT JOIN music_artist_merch m43_ ON b42_.music_artist_merch_id = m43_.id
  AND (m43_.publish = 1)
  LEFT JOIN bind_music_artist_post_item_character b44_ ON (b44_.e_commerce_item_id = e1_.id)
  LEFT JOIN music_artist_posts m45_ ON b44_.music_artist_post_id = m45_.id
  AND (m45_.publish = 1)
  LEFT JOIN bind_music_artist_post_item_guest_character b46_ ON (b46_.e_commerce_item_id = e1_.id)
  LEFT JOIN music_artist_posts m47_ ON b46_.music_artist_post_id = m47_.id
  AND (m47_.publish = 1)
  LEFT JOIN music_artist m48_ ON (
    m48_.id = m43_.music_artist_id
    OR m48_.id = m45_.music_artist_id
    OR m48_.id = m47_.music_artist_id
  )
  INNER JOIN e_commerce_item_settings_discovery e49_ ON e1_.id = e49_.item_id
  AND (
    e49_.discovery = 1
    AND e49_.quantity_update <> 0
  )
WHERE
  (
    f15_.publish = 1
    OR t30_.publish = 1
    OR (
      m39_.publish = 1
      AND m40_.publish = 1
    )
    OR m48_.publish = 1
  )
  AND e1_.removed = 0
  AND a0_.admin_wishlist_id = ?
GROUP BY
  e1_.name,
  e1_.sku,
  e1_.price_on_mirinly,
  e1_.msrp,
  e1_.sale_price,
  e1_.available_from_samples,
  e1_.available_from_mirinly,
  e1_.available,
  e1_.affiliate_url,
  e1_.thumbnail,
  e1_.additional_image_1,
  e1_.additional_image_2,
  e1_.additional_image_3,
  e1_.additional_image_4,
  e1_.sizeGuide,
  e1_.description,
  e1_.position,
  e1_.id,
  e1_.featured,
  e1_.sponsored_global,
  e1_.sponsored_category,
  e1_.sponsored_sub_category,
  e1_.based_in,
  e1_.other_sizes_colors,
  e1_.measurement_type,
  e1_.insurance_type,
  e1_.insurance,
  e1_.reasonable_wear_and_tear,
  e1_.low_volume_production,
  e1_.shipping_policy,
  e1_.return_policy,
  e1_.care,
  e1_.created,
  e1_.enable_shopify_sync,
  e1_.enable_squarecpase_sync,
  e1_.imported,
  e1_.removed,
  e1_.once_assigned,
  e1_.default_cities,
  e1_.default_search_tags,
  e1_.external_id,
  e1_.finalized_date,
  e1_.e_commerce_subcategory_id,
  e1_.e_commerce_item_type_id,
  e1_.e_commerce_item_template_id,
  e1_.brand_id,
  e1_.main_image_id

SELECT a0_.id AS id_0, a0_.updated AS updated_1, a0_.admin_wishlist_id AS admin_wishlist_id_2, a0_.item_id AS item_id_3 FROM admin_wishlist_item a0_ LEFT JOIN e_commerce_item e1_ ON a0_.item_id = e1_.id LEFT JOIN admin_wishlist a2_ ON a0_.admin_wishlist_id = a2_.id LEFT JOIN bind_film_scene_item_character b3_ ON (b3_.e_commerce_item_id = e1_.id) LEFT JOIN bind_film_character_signature_item b4_ ON (b4_.e_commerce_item_id = e1_.id) LEFT JOIN bind_film_set_item b5_ ON (b5_.e_commerce_item_id = e1_.id) LEFT JOIN bind_film_merch b6_ ON (b6_.e_commerce_item_id = e1_.id) LEFT JOIN bind_film_post_item_character b7_ ON (b7_.e_commerce_item_id = e1_.id) LEFT JOIN film_scene f8_ ON b3_.film_scene_id = f8_.id AND (f8_.publish = 1) LEFT JOIN film_character_signature f9_ ON b4_.film_character_signature_id = f9_.id LEFT JOIN film_character f10_ ON f9_.character_id = f10_.id LEFT JOIN film_set f11_ ON b5_.film_set_id = f11_.id AND (f11_.publish = 1) LEFT JOIN film_set_category f12_ ON f11_.film_set_category_id = f12_.id AND (f12_.publish = 1) LEFT JOIN film_merch f13_ ON b6_.film_merch_id = f13_.id AND (f13_.publish = 1) LEFT JOIN film_posts f14_ ON b7_.film_post_id = f14_.id AND (f14_.publish = 1) LEFT JOIN film f15_ ON (f15_.id = f8_.film_id OR f15_.id = f10_.film_id OR f15_.id = f12_.film_id OR f15_.id = f13_.film_id OR f15_.id = f14_.film_id) LEFT JOIN bind_tv_show_scene_item_character b16_ ON (b16_.e_commerce_item_id = e1_.id) LEFT JOIN bind_tv_show_character_signature_item b17_ ON (b17_.e_commerce_item_id = e1_.id) LEFT JOIN bind_tv_show_set_item b18_ ON (b18_.e_commerce_item_id = e1_.id) LEFT JOIN bind_tv_show_merch b19_ ON (b19_.e_commerce_item_id = e1_.id) LEFT JOIN bind_tv_show_post_item_character b20_ ON (b20_.e_commerce_item_id = e1_.id) LEFT JOIN tv_show_scene t21_ ON b16_.tv_show_scene_id = t21_.id AND (t21_.publish = 1) LEFT JOIN tv_show_episode t22_ ON t21_.tv_show_episode_id = t22_.id AND (t22_.publish = 1) LEFT JOIN tv_show_season t23_ ON t22_.tv_show_season_id = t23_.id AND (t23_.publish = 1) LEFT JOIN tv_show_character_signature t24_ ON b17_.tv_show_character_signature_id = t24_.id AND (t24_.publish = 1) LEFT JOIN tv_show_character t25_ ON t24_.character_id = t25_.id LEFT JOIN tv_show_set t26_ ON b18_.tv_show_set_id = t26_.id AND (t26_.publish = 1) LEFT JOIN tv_show_set_category t27_ ON t26_.tv_show_set_category_id = t27_.id AND (t27_.publish = 1) LEFT JOIN tv_show_merch t28_ ON b19_.tv_show_merch_id = t28_.id AND (t28_.publish = 1) LEFT JOIN tv_show_posts t29_ ON b20_.tv_show_post_id = t29_.id AND (t29_.publish = 1) LEFT JOIN tv_show t30_ ON (t30_.id = t23_.tv_show_id OR t30_.id = t25_.tv_show_id OR t30_.id = t27_.tv_show_id OR t30_.id = t28_.tv_show_id OR t30_.id = t29_.tv_show_id) LEFT JOIN bind_music_video_scene_item_character b31_ ON (b31_.e_commerce_item_id = e1_.id) LEFT JOIN bind_music_video_character_signature_item b32_ ON (b32_.e_commerce_item_id = e1_.id) LEFT JOIN bind_music_video_set_item b33_ ON (b33_.e_commerce_item_id = e1_.id) LEFT JOIN music_scene m34_ ON b31_.music_scene_id = m34_.id AND (m34_.publish = 1) LEFT JOIN music_video_character_signature m35_ ON b32_.music_video_character_signature_id = m35_.id LEFT JOIN music_video_character m36_ ON m35_.character_id = m36_.id LEFT JOIN music_video_set m37_ ON b33_.music_video_set_id = m37_.id AND (m37_.publish = 1) LEFT JOIN music_video_set_category m38_ ON m37_.music_video_set_category_id = m38_.id AND (m38_.publish = 1) LEFT JOIN music_video m39_ ON (m39_.id = m34_.music_video_id OR m39_.id = m36_.music_video_id OR m39_.id = m38_.music_video_id) LEFT JOIN music_artist_to_music_video m41_ ON m39_.id = m41_.music_video_id LEFT JOIN music_artist m40_ ON m40_.id = m41_.music_artist_id LEFT JOIN bind_music_artist_merch b42_ ON (b42_.e_commerce_item_id = e1_.id) LEFT JOIN music_artist_merch m43_ ON b42_.music_artist_merch_id = m43_.id AND (m43_.publish = 1) LEFT JOIN bind_music_artist_post_item_character b44_ ON (b44_.e_commerce_item_id = e1_.id) LEFT JOIN music_artist_posts m45_ ON b44_.music_artist_post_id = m45_.id AND (m45_.publish = 1) LEFT JOIN bind_music_artist_post_item_guest_character b46_ ON (b46_.e_commerce_item_id = e1_.id) LEFT JOIN music_artist_posts m47_ ON b46_.music_artist_post_id = m47_.id AND (m47_.publish = 1) LEFT JOIN music_artist m48_ ON (m48_.id = m43_.music_artist_id OR m48_.id = m45_.music_artist_id OR m48_.id = m47_.music_artist_id) INNER JOIN e_commerce_item_settings_discovery e49_ ON e1_.id = e49_.item_id AND (e49_.discovery = 1 AND e49_.quantity_update <> 0) WHERE (f15_.publish = 1 OR t30_.publish = 1 OR (m39_.publish = 1 AND m40_.publish = 1) OR m48_.publish = 1) AND e1_.removed = 0 AND a0_.admin_wishlist_id = 400 GROUP BY e1_.name, e1_.sku, e1_.price_on_mirinly, e1_.msrp, e1_.sale_price, e1_.available_from_samples, e1_.available_from_mirinly, e1_.available, e1_.affiliate_url, e1_.thumbnail, e1_.additional_image_1, e1_.additional_image_2, e1_.additional_image_3, e1_.additional_image_4, e1_.sizeGuide, e1_.description, e1_.position, e1_.id, e1_.featured, e1_.sponsored_global, e1_.sponsored_category, e1_.sponsored_sub_category, e1_.based_in, e1_.other_sizes_colors, e1_.measurement_type, e1_.insurance_type, e1_.insurance, e1_.reasonable_wear_and_tear, e1_.low_volume_production, e1_.shipping_policy, e1_.return_policy, e1_.care, e1_.created, e1_.enable_shopify_sync, e1_.enable_squarecpase_sync, e1_.imported, e1_.removed, e1_.once_assigned, e1_.default_cities, e1_.default_search_tags, e1_.external_id, e1_.finalized_date, e1_.e_commerce_subcategory_id, e1_.e_commerce_item_type_id, e1_.e_commerce_item_template_id, e1_.brand_id, e1_.main_image_id;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO admin_wishlist_trend (points, updated, target_id)
VALUES
  (?, ?, ?)

INSERT INTO admin_wishlist_trend (points, updated, target_id) VALUES (1, '2026-02-19 00:31:37', 400);

"COMMIT"

"COMMIT";

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
  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 = '3dsb2hcn1d3asnkqcfcdk9mbql' GROUP BY c0_.session_id, c0_.quantity, c0_.id, c0_.item_id, c0_.size_id, c0_.color_id ORDER BY c0_.id DESC;

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

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;

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
ORDER BY
  t0.name ASC

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 ORDER BY t0.name ASC;

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;