Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 20
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine 3
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Mercure
• Configuration

Query Metrics

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_.id = ?

[
  1
]

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_.id = ?

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_.id = 1;