Symfony Profiler

SELECT
  f0_.name AS name_0,
  f0_.thumbnail AS thumbnail_1,
  f0_.short_description AS short_description_2,
  f0_.description AS description_3,
  f0_.publish AS publish_4,
  f0_.complete AS complete_5,
  f0_.release_date AS release_date_6,
  f0_.position AS position_7,
  f0_.updated AS updated_8,
  f0_.id AS id_9,
  f0_.commission AS commission_10,
  f0_.auto_mainstreet AS auto_mainstreet_11,
  f0_.contact_name AS contact_name_12,
  f0_.email AS email_13,
  f0_.imdb_link AS imdb_link_14,
  f0_.approve_status AS approve_status_15,
  f0_.old_parents AS old_parents_16,
  f0_.publish_date AS publish_date_17,
  f0_.actual_publish_date AS actual_publish_date_18,
  f0_.youtube_username AS youtube_username_19,
  f0_.youtube_link AS youtube_link_20,
  f0_.instagram_username AS instagram_username_21,
  f0_.instagram_link AS instagram_link_22,
  f0_.twitter_username AS twitter_username_23,
  f0_.twitter_link AS twitter_link_24,
  f0_.facebook_username AS facebook_username_25,
  f0_.facebook_link AS facebook_link_26,
  f0_.website_link AS website_link_27,
  f0_.stripe_customer AS stripe_customer_28,
  f0_.season_id AS season_id_29
FROM
  film f0_
  LEFT JOIN film_scene f1_ ON f0_.id = f1_.film_id
  AND (f1_.publish = 1)
  LEFT JOIN bind_film_scene_item_character b2_ ON (b2_.film_scene_id = f1_.id)
  LEFT JOIN film_character f3_ ON f0_.id = f3_.film_id
  LEFT JOIN film_character_signature f4_ ON f3_.id = f4_.character_id
  AND (f4_.publish = 1)
  LEFT JOIN bind_film_character_signature_item b5_ ON (
    b5_.film_character_signature_id = f4_.id
  )
  LEFT JOIN film_set_category f6_ ON f0_.id = f6_.film_id
  AND (f6_.publish = 1)
  LEFT JOIN film_set f7_ ON f6_.id = f7_.film_set_category_id
  AND (f7_.publish = 1)
  LEFT JOIN bind_film_set_item b8_ ON (b8_.film_set_id = f7_.id)
  LEFT JOIN film_posts f9_ ON f0_.id = f9_.film_id
  AND (f9_.publish = 1)
  LEFT JOIN bind_film_post_item_character b10_ ON (b10_.film_post_id = f9_.id)
  LEFT JOIN film_merch f11_ ON f0_.id = f11_.film_id
  AND (f11_.publish = 1)
  LEFT JOIN bind_film_merch b12_ ON (b12_.film_merch_id = f11_.id)
WHERE
  (
    b2_.id IS NOT NULL
    OR b5_.id IS NOT NULL
    OR b8_.id IS NOT NULL
    OR b10_.id IS NOT NULL
    OR b12_.id IS NOT NULL
  )
  AND f0_.publish = 1
GROUP BY
  f0_.name,
  f0_.thumbnail,
  f0_.short_description,
  f0_.description,
  f0_.publish,
  f0_.complete,
  f0_.release_date,
  f0_.position,
  f0_.updated,
  f0_.id,
  f0_.commission,
  f0_.auto_mainstreet,
  f0_.contact_name,
  f0_.email,
  f0_.imdb_link,
  f0_.approve_status,
  f0_.old_parents,
  f0_.publish_date,
  f0_.actual_publish_date,
  f0_.youtube_username,
  f0_.youtube_link,
  f0_.instagram_username,
  f0_.instagram_link,
  f0_.twitter_username,
  f0_.twitter_link,
  f0_.facebook_username,
  f0_.facebook_link,
  f0_.website_link,
  f0_.stripe_customer,
  f0_.season_id
ORDER BY
  f0_.actual_publish_date DESC,
  f0_.position ASC
LIMIT
  10

SELECT f0_.name AS name_0, f0_.thumbnail AS thumbnail_1, f0_.short_description AS short_description_2, f0_.description AS description_3, f0_.publish AS publish_4, f0_.complete AS complete_5, f0_.release_date AS release_date_6, f0_.position AS position_7, f0_.updated AS updated_8, f0_.id AS id_9, f0_.commission AS commission_10, f0_.auto_mainstreet AS auto_mainstreet_11, f0_.contact_name AS contact_name_12, f0_.email AS email_13, f0_.imdb_link AS imdb_link_14, f0_.approve_status AS approve_status_15, f0_.old_parents AS old_parents_16, f0_.publish_date AS publish_date_17, f0_.actual_publish_date AS actual_publish_date_18, f0_.youtube_username AS youtube_username_19, f0_.youtube_link AS youtube_link_20, f0_.instagram_username AS instagram_username_21, f0_.instagram_link AS instagram_link_22, f0_.twitter_username AS twitter_username_23, f0_.twitter_link AS twitter_link_24, f0_.facebook_username AS facebook_username_25, f0_.facebook_link AS facebook_link_26, f0_.website_link AS website_link_27, f0_.stripe_customer AS stripe_customer_28, f0_.season_id AS season_id_29 FROM film f0_ LEFT JOIN film_scene f1_ ON f0_.id = f1_.film_id AND (f1_.publish = 1) LEFT JOIN bind_film_scene_item_character b2_ ON (b2_.film_scene_id = f1_.id) LEFT JOIN film_character f3_ ON f0_.id = f3_.film_id LEFT JOIN film_character_signature f4_ ON f3_.id = f4_.character_id AND (f4_.publish = 1) LEFT JOIN bind_film_character_signature_item b5_ ON (b5_.film_character_signature_id = f4_.id) LEFT JOIN film_set_category f6_ ON f0_.id = f6_.film_id AND (f6_.publish = 1) LEFT JOIN film_set f7_ ON f6_.id = f7_.film_set_category_id AND (f7_.publish = 1) LEFT JOIN bind_film_set_item b8_ ON (b8_.film_set_id = f7_.id) LEFT JOIN film_posts f9_ ON f0_.id = f9_.film_id AND (f9_.publish = 1) LEFT JOIN bind_film_post_item_character b10_ ON (b10_.film_post_id = f9_.id) LEFT JOIN film_merch f11_ ON f0_.id = f11_.film_id AND (f11_.publish = 1) LEFT JOIN bind_film_merch b12_ ON (b12_.film_merch_id = f11_.id) WHERE (b2_.id IS NOT NULL OR b5_.id IS NOT NULL OR b8_.id IS NOT NULL OR b10_.id IS NOT NULL OR b12_.id IS NOT NULL) AND f0_.publish = 1 GROUP BY f0_.name, f0_.thumbnail, f0_.short_description, f0_.description, f0_.publish, f0_.complete, f0_.release_date, f0_.position, f0_.updated, f0_.id, f0_.commission, f0_.auto_mainstreet, f0_.contact_name, f0_.email, f0_.imdb_link, f0_.approve_status, f0_.old_parents, f0_.publish_date, f0_.actual_publish_date, f0_.youtube_username, f0_.youtube_link, f0_.instagram_username, f0_.instagram_link, f0_.twitter_username, f0_.twitter_link, f0_.facebook_username, f0_.facebook_link, f0_.website_link, f0_.stripe_customer, f0_.season_id ORDER BY f0_.actual_publish_date DESC, f0_.position ASC LIMIT 10;

SELECT
  f0_.name AS name_0,
  f0_.thumbnail AS thumbnail_1,
  f0_.short_description AS short_description_2,
  f0_.description AS description_3,
  f0_.publish AS publish_4,
  f0_.complete AS complete_5,
  f0_.release_date AS release_date_6,
  f0_.position AS position_7,
  f0_.updated AS updated_8,
  f0_.id AS id_9,
  f0_.commission AS commission_10,
  f0_.auto_mainstreet AS auto_mainstreet_11,
  f0_.contact_name AS contact_name_12,
  f0_.email AS email_13,
  f0_.imdb_link AS imdb_link_14,
  f0_.approve_status AS approve_status_15,
  f0_.old_parents AS old_parents_16,
  f0_.publish_date AS publish_date_17,
  f0_.actual_publish_date AS actual_publish_date_18,
  f0_.youtube_username AS youtube_username_19,
  f0_.youtube_link AS youtube_link_20,
  f0_.instagram_username AS instagram_username_21,
  f0_.instagram_link AS instagram_link_22,
  f0_.twitter_username AS twitter_username_23,
  f0_.twitter_link AS twitter_link_24,
  f0_.facebook_username AS facebook_username_25,
  f0_.facebook_link AS facebook_link_26,
  f0_.website_link AS website_link_27,
  f0_.stripe_customer AS stripe_customer_28,
  f0_.season_id AS season_id_29
FROM
  film f0_
  LEFT JOIN film_scene f1_ ON f0_.id = f1_.film_id
  AND (f1_.publish = 1)
  LEFT JOIN bind_film_scene_item_character b2_ ON (b2_.film_scene_id = f1_.id)
  LEFT JOIN film_character f3_ ON f0_.id = f3_.film_id
  LEFT JOIN film_character_signature f4_ ON f3_.id = f4_.character_id
  AND (f4_.publish = 1)
  LEFT JOIN bind_film_character_signature_item b5_ ON (
    b5_.film_character_signature_id = f4_.id
  )
  LEFT JOIN film_set_category f6_ ON f0_.id = f6_.film_id
  AND (f6_.publish = 1)
  LEFT JOIN film_set f7_ ON f6_.id = f7_.film_set_category_id
  AND (f7_.publish = 1)
  LEFT JOIN bind_film_set_item b8_ ON (b8_.film_set_id = f7_.id)
  LEFT JOIN film_posts f9_ ON f0_.id = f9_.film_id
  AND (f9_.publish = 1)
  LEFT JOIN bind_film_post_item_character b10_ ON (b10_.film_post_id = f9_.id)
  LEFT JOIN film_merch f11_ ON f0_.id = f11_.film_id
  AND (f11_.publish = 1)
  LEFT JOIN bind_film_merch b12_ ON (b12_.film_merch_id = f11_.id)
WHERE
  (
    b2_.id IS NOT NULL
    OR b5_.id IS NOT NULL
    OR b8_.id IS NOT NULL
    OR b10_.id IS NOT NULL
    OR b12_.id IS NOT NULL
  )
  AND f0_.publish = 1
GROUP BY
  f0_.name,
  f0_.thumbnail,
  f0_.short_description,
  f0_.description,
  f0_.publish,
  f0_.complete,
  f0_.release_date,
  f0_.position,
  f0_.updated,
  f0_.id,
  f0_.commission,
  f0_.auto_mainstreet,
  f0_.contact_name,
  f0_.email,
  f0_.imdb_link,
  f0_.approve_status,
  f0_.old_parents,
  f0_.publish_date,
  f0_.actual_publish_date,
  f0_.youtube_username,
  f0_.youtube_link,
  f0_.instagram_username,
  f0_.instagram_link,
  f0_.twitter_username,
  f0_.twitter_link,
  f0_.facebook_username,
  f0_.facebook_link,
  f0_.website_link,
  f0_.stripe_customer,
  f0_.season_id
ORDER BY
  f0_.actual_publish_date DESC,
  f0_.position ASC

SELECT f0_.name AS name_0, f0_.thumbnail AS thumbnail_1, f0_.short_description AS short_description_2, f0_.description AS description_3, f0_.publish AS publish_4, f0_.complete AS complete_5, f0_.release_date AS release_date_6, f0_.position AS position_7, f0_.updated AS updated_8, f0_.id AS id_9, f0_.commission AS commission_10, f0_.auto_mainstreet AS auto_mainstreet_11, f0_.contact_name AS contact_name_12, f0_.email AS email_13, f0_.imdb_link AS imdb_link_14, f0_.approve_status AS approve_status_15, f0_.old_parents AS old_parents_16, f0_.publish_date AS publish_date_17, f0_.actual_publish_date AS actual_publish_date_18, f0_.youtube_username AS youtube_username_19, f0_.youtube_link AS youtube_link_20, f0_.instagram_username AS instagram_username_21, f0_.instagram_link AS instagram_link_22, f0_.twitter_username AS twitter_username_23, f0_.twitter_link AS twitter_link_24, f0_.facebook_username AS facebook_username_25, f0_.facebook_link AS facebook_link_26, f0_.website_link AS website_link_27, f0_.stripe_customer AS stripe_customer_28, f0_.season_id AS season_id_29 FROM film f0_ LEFT JOIN film_scene f1_ ON f0_.id = f1_.film_id AND (f1_.publish = 1) LEFT JOIN bind_film_scene_item_character b2_ ON (b2_.film_scene_id = f1_.id) LEFT JOIN film_character f3_ ON f0_.id = f3_.film_id LEFT JOIN film_character_signature f4_ ON f3_.id = f4_.character_id AND (f4_.publish = 1) LEFT JOIN bind_film_character_signature_item b5_ ON (b5_.film_character_signature_id = f4_.id) LEFT JOIN film_set_category f6_ ON f0_.id = f6_.film_id AND (f6_.publish = 1) LEFT JOIN film_set f7_ ON f6_.id = f7_.film_set_category_id AND (f7_.publish = 1) LEFT JOIN bind_film_set_item b8_ ON (b8_.film_set_id = f7_.id) LEFT JOIN film_posts f9_ ON f0_.id = f9_.film_id AND (f9_.publish = 1) LEFT JOIN bind_film_post_item_character b10_ ON (b10_.film_post_id = f9_.id) LEFT JOIN film_merch f11_ ON f0_.id = f11_.film_id AND (f11_.publish = 1) LEFT JOIN bind_film_merch b12_ ON (b12_.film_merch_id = f11_.id) WHERE (b2_.id IS NOT NULL OR b5_.id IS NOT NULL OR b8_.id IS NOT NULL OR b10_.id IS NOT NULL OR b12_.id IS NOT NULL) AND f0_.publish = 1 GROUP BY f0_.name, f0_.thumbnail, f0_.short_description, f0_.description, f0_.publish, f0_.complete, f0_.release_date, f0_.position, f0_.updated, f0_.id, f0_.commission, f0_.auto_mainstreet, f0_.contact_name, f0_.email, f0_.imdb_link, f0_.approve_status, f0_.old_parents, f0_.publish_date, f0_.actual_publish_date, f0_.youtube_username, f0_.youtube_link, f0_.instagram_username, f0_.instagram_link, f0_.twitter_username, f0_.twitter_link, f0_.facebook_username, f0_.facebook_link, f0_.website_link, f0_.stripe_customer, f0_.season_id ORDER BY f0_.actual_publish_date DESC, f0_.position ASC;

SELECT
  f0_.points AS points_0,
  f0_.id AS id_1,
  f0_.updated AS updated_2,
  sum(f0_.points) AS sclr_3,
  sum(f1_.points) AS sclr_4,
  sum(f2_.points) / (
    DATEDIFF(
      ?,
      min(f2_.updated)
    )
  ) AS sclr_5,
  f0_.target_id AS target_id_6
FROM
  film_trend f0_
  LEFT JOIN film_trend f2_ ON (
    f2_.id = f0_.id
    AND f2_.updated < ?
  )
  LEFT JOIN film_trend f1_ ON (
    f1_.id = f0_.id
    AND f1_.updated >= ?
  )
  INNER JOIN film f3_ ON f0_.target_id = f3_.id
  AND (f3_.publish = 1)
GROUP BY
  f0_.target_id
ORDER BY
  sclr_3 DESC
LIMIT
  5

SELECT f0_.points AS points_0, f0_.id AS id_1, f0_.updated AS updated_2, sum(f0_.points) AS sclr_3, sum(f1_.points) AS sclr_4, sum(f2_.points) / (DATEDIFF('2026-02-18 00:00:00', min(f2_.updated))) AS sclr_5, f0_.target_id AS target_id_6 FROM film_trend f0_ LEFT JOIN film_trend f2_ ON (f2_.id = f0_.id AND f2_.updated < '2026-02-18 00:00:00') LEFT JOIN film_trend f1_ ON (f1_.id = f0_.id AND f1_.updated >= '2026-02-18 00:00:00') INNER JOIN film f3_ ON f0_.target_id = f3_.id AND (f3_.publish = 1) GROUP BY f0_.target_id ORDER BY sclr_3 DESC LIMIT 5;

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
  LEFT JOIN film_posts f16_ ON b9_.film_post_id = f16_.id
  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
  )
WHERE
  f17_.publish = 1
  AND e3_.removed = 0
GROUP BY
  e0_.target_id
ORDER BY
  sclr_3 DESC
LIMIT
  5

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-18 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-18 00:00:00') LEFT JOIN e_commerce_item_trend e1_ ON (e1_.id = e0_.id AND e1_.updated >= '2026-02-18 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 LEFT JOIN film_posts f16_ ON b9_.film_post_id = f16_.id 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) WHERE f17_.publish = 1 AND e3_.removed = 0 GROUP BY e0_.target_id ORDER BY sclr_3 DESC LIMIT 5;

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_set_item b5_ ON (b5_.e_commerce_item_id = e3_.id)
  LEFT JOIN film_set f6_ ON b5_.film_set_id = f6_.id
  LEFT JOIN film_set_category f7_ ON f6_.film_set_category_id = f7_.id
  LEFT JOIN film f8_ ON f7_.film_id = f8_.id
WHERE
  (
    b5_.e_commerce_item_id = e3_.id
    AND e3_.removed = 0
  )
  AND (
    f6_.publish = 1
    AND f7_.publish = 1
    AND f8_.publish = 1
  )
GROUP BY
  e0_.target_id
ORDER BY
  sclr_3 DESC
LIMIT
  5

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-18 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-18 00:00:00') LEFT JOIN e_commerce_item_trend e1_ ON (e1_.id = e0_.id AND e1_.updated >= '2026-02-18 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_set_item b5_ ON (b5_.e_commerce_item_id = e3_.id) LEFT JOIN film_set f6_ ON b5_.film_set_id = f6_.id LEFT JOIN film_set_category f7_ ON f6_.film_set_category_id = f7_.id LEFT JOIN film f8_ ON f7_.film_id = f8_.id WHERE (b5_.e_commerce_item_id = e3_.id AND e3_.removed = 0) AND (f6_.publish = 1 AND f7_.publish = 1 AND f8_.publish = 1) GROUP BY e0_.target_id ORDER BY sclr_3 DESC LIMIT 5;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.thumbnail AS thumbnail_2,
  c0_.link AS link_3,
  c0_.page AS page_4,
  c0_.position AS position_5
FROM
  custom_slider c0_
WHERE
  c0_.page = ?
  AND c0_.thumbnail IS NOT NULL
ORDER BY
  c0_.position ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.thumbnail AS thumbnail_2, c0_.link AS link_3, c0_.page AS page_4, c0_.position AS position_5 FROM custom_slider c0_ WHERE c0_.page = 2 AND c0_.thumbnail IS NOT NULL ORDER BY c0_.position ASC;

SELECT
  f0_.name AS name_0,
  f0_.thumbnail AS thumbnail_1,
  f0_.short_description AS short_description_2,
  f0_.description AS description_3,
  f0_.publish AS publish_4,
  f0_.complete AS complete_5,
  f0_.release_date AS release_date_6,
  f0_.position AS position_7,
  f0_.updated AS updated_8,
  f0_.id AS id_9,
  f0_.commission AS commission_10,
  f0_.auto_mainstreet AS auto_mainstreet_11,
  f0_.contact_name AS contact_name_12,
  f0_.email AS email_13,
  f0_.imdb_link AS imdb_link_14,
  f0_.approve_status AS approve_status_15,
  f0_.old_parents AS old_parents_16,
  f0_.publish_date AS publish_date_17,
  f0_.actual_publish_date AS actual_publish_date_18,
  f0_.youtube_username AS youtube_username_19,
  f0_.youtube_link AS youtube_link_20,
  f0_.instagram_username AS instagram_username_21,
  f0_.instagram_link AS instagram_link_22,
  f0_.twitter_username AS twitter_username_23,
  f0_.twitter_link AS twitter_link_24,
  f0_.facebook_username AS facebook_username_25,
  f0_.facebook_link AS facebook_link_26,
  f0_.website_link AS website_link_27,
  f0_.stripe_customer AS stripe_customer_28,
  f0_.season_id AS season_id_29
FROM
  film f0_
  LEFT JOIN film_scene f1_ ON f0_.id = f1_.film_id
  AND (f1_.publish = 1)
  LEFT JOIN bind_film_scene_item_character b2_ ON (b2_.film_scene_id = f1_.id)
  LEFT JOIN film_character f3_ ON f0_.id = f3_.film_id
  LEFT JOIN film_character_signature f4_ ON f3_.id = f4_.character_id
  AND (f4_.publish = 1)
  LEFT JOIN bind_film_character_signature_item b5_ ON (
    b5_.film_character_signature_id = f4_.id
  )
  LEFT JOIN film_set_category f6_ ON f0_.id = f6_.film_id
  AND (f6_.publish = 1)
  LEFT JOIN film_set f7_ ON f6_.id = f7_.film_set_category_id
  AND (f7_.publish = 1)
  LEFT JOIN bind_film_set_item b8_ ON (b8_.film_set_id = f7_.id)
  LEFT JOIN film_posts f9_ ON f0_.id = f9_.film_id
  AND (f9_.publish = 1)
  LEFT JOIN bind_film_post_item_character b10_ ON (b10_.film_post_id = f9_.id)
  LEFT JOIN film_merch f11_ ON f0_.id = f11_.film_id
  AND (f11_.publish = 1)
  LEFT JOIN bind_film_merch b12_ ON (b12_.film_merch_id = f11_.id)
WHERE
  (
    b2_.id IS NOT NULL
    OR b5_.id IS NOT NULL
    OR b8_.id IS NOT NULL
    OR b10_.id IS NOT NULL
    OR b12_.id IS NOT NULL
  )
  AND f0_.publish = 1
GROUP BY
  f0_.name,
  f0_.thumbnail,
  f0_.short_description,
  f0_.description,
  f0_.publish,
  f0_.complete,
  f0_.release_date,
  f0_.position,
  f0_.updated,
  f0_.id,
  f0_.commission,
  f0_.auto_mainstreet,
  f0_.contact_name,
  f0_.email,
  f0_.imdb_link,
  f0_.approve_status,
  f0_.old_parents,
  f0_.publish_date,
  f0_.actual_publish_date,
  f0_.youtube_username,
  f0_.youtube_link,
  f0_.instagram_username,
  f0_.instagram_link,
  f0_.twitter_username,
  f0_.twitter_link,
  f0_.facebook_username,
  f0_.facebook_link,
  f0_.website_link,
  f0_.stripe_customer,
  f0_.season_id
ORDER BY
  f0_.name ASC

SELECT f0_.name AS name_0, f0_.thumbnail AS thumbnail_1, f0_.short_description AS short_description_2, f0_.description AS description_3, f0_.publish AS publish_4, f0_.complete AS complete_5, f0_.release_date AS release_date_6, f0_.position AS position_7, f0_.updated AS updated_8, f0_.id AS id_9, f0_.commission AS commission_10, f0_.auto_mainstreet AS auto_mainstreet_11, f0_.contact_name AS contact_name_12, f0_.email AS email_13, f0_.imdb_link AS imdb_link_14, f0_.approve_status AS approve_status_15, f0_.old_parents AS old_parents_16, f0_.publish_date AS publish_date_17, f0_.actual_publish_date AS actual_publish_date_18, f0_.youtube_username AS youtube_username_19, f0_.youtube_link AS youtube_link_20, f0_.instagram_username AS instagram_username_21, f0_.instagram_link AS instagram_link_22, f0_.twitter_username AS twitter_username_23, f0_.twitter_link AS twitter_link_24, f0_.facebook_username AS facebook_username_25, f0_.facebook_link AS facebook_link_26, f0_.website_link AS website_link_27, f0_.stripe_customer AS stripe_customer_28, f0_.season_id AS season_id_29 FROM film f0_ LEFT JOIN film_scene f1_ ON f0_.id = f1_.film_id AND (f1_.publish = 1) LEFT JOIN bind_film_scene_item_character b2_ ON (b2_.film_scene_id = f1_.id) LEFT JOIN film_character f3_ ON f0_.id = f3_.film_id LEFT JOIN film_character_signature f4_ ON f3_.id = f4_.character_id AND (f4_.publish = 1) LEFT JOIN bind_film_character_signature_item b5_ ON (b5_.film_character_signature_id = f4_.id) LEFT JOIN film_set_category f6_ ON f0_.id = f6_.film_id AND (f6_.publish = 1) LEFT JOIN film_set f7_ ON f6_.id = f7_.film_set_category_id AND (f7_.publish = 1) LEFT JOIN bind_film_set_item b8_ ON (b8_.film_set_id = f7_.id) LEFT JOIN film_posts f9_ ON f0_.id = f9_.film_id AND (f9_.publish = 1) LEFT JOIN bind_film_post_item_character b10_ ON (b10_.film_post_id = f9_.id) LEFT JOIN film_merch f11_ ON f0_.id = f11_.film_id AND (f11_.publish = 1) LEFT JOIN bind_film_merch b12_ ON (b12_.film_merch_id = f11_.id) WHERE (b2_.id IS NOT NULL OR b5_.id IS NOT NULL OR b8_.id IS NOT NULL OR b10_.id IS NOT NULL OR b12_.id IS NOT NULL) AND f0_.publish = 1 GROUP BY f0_.name, f0_.thumbnail, f0_.short_description, f0_.description, f0_.publish, f0_.complete, f0_.release_date, f0_.position, f0_.updated, f0_.id, f0_.commission, f0_.auto_mainstreet, f0_.contact_name, f0_.email, f0_.imdb_link, f0_.approve_status, f0_.old_parents, f0_.publish_date, f0_.actual_publish_date, f0_.youtube_username, f0_.youtube_link, f0_.instagram_username, f0_.instagram_link, f0_.twitter_username, f0_.twitter_link, f0_.facebook_username, f0_.facebook_link, f0_.website_link, f0_.stripe_customer, f0_.season_id ORDER BY f0_.name ASC;