Symfony Profiler

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 = 'g0ps7ehnkr2f6blenal3rc6gu4' 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.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.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
  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
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.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
  p0_.type AS type_0,
  p0_.name AS name_1,
  p0_.val AS val_2,
  p0_.int_val AS int_val_3,
  p0_.id AS id_4
FROM
  parameters p0_
WHERE
  p0_.type = ?
  AND p0_.int_val = ?

SELECT p0_.type AS type_0, p0_.name AS name_1, p0_.val AS val_2, p0_.int_val AS int_val_3, p0_.id AS id_4 FROM parameters p0_ WHERE p0_.type = 'disable_menu_item' AND p0_.int_val = 1;