Symfony Profiler

SELECT
  t0.name AS name_1,
  t0.publish AS publish_2,
  t0.complete AS complete_3,
  t0.updated AS updated_4,
  t0.position AS position_5,
  t0.id AS id_6,
  t0.auto_mainstreet AS auto_mainstreet_7,
  t0.commission AS commission_8,
  t0.spotify_username AS spotify_username_9,
  t0.spotify_link AS spotify_link_10,
  t0.sound_cloud_username AS sound_cloud_username_11,
  t0.sound_cloud_link AS sound_cloud_link_12,
  t0.tik_tok_username AS tik_tok_username_13,
  t0.tik_tok_link AS tik_tok_link_14,
  t0.imdb_link AS imdb_link_15,
  t0.wikipedia_link AS wikipedia_link_16,
  t0.approve_status AS approve_status_17,
  t0.old_parents AS old_parents_18,
  t0.thumbnail AS thumbnail_19,
  t0.description AS description_20,
  t0.short_description AS short_description_21,
  t0.actual_publish_date AS actual_publish_date_22,
  t0.youtube_username AS youtube_username_23,
  t0.youtube_link AS youtube_link_24,
  t0.instagram_username AS instagram_username_25,
  t0.instagram_link AS instagram_link_26,
  t0.twitter_username AS twitter_username_27,
  t0.twitter_link AS twitter_link_28,
  t0.facebook_username AS facebook_username_29,
  t0.facebook_link AS facebook_link_30,
  t0.website_link AS website_link_31,
  t0.stripe_customer AS stripe_customer_32
FROM
  music_artist t0
WHERE
  t0.id = ?
  AND t0.publish = ?
LIMIT
  1

SELECT t0.name AS name_1, t0.publish AS publish_2, t0.complete AS complete_3, t0.updated AS updated_4, t0.position AS position_5, t0.id AS id_6, t0.auto_mainstreet AS auto_mainstreet_7, t0.commission AS commission_8, t0.spotify_username AS spotify_username_9, t0.spotify_link AS spotify_link_10, t0.sound_cloud_username AS sound_cloud_username_11, t0.sound_cloud_link AS sound_cloud_link_12, t0.tik_tok_username AS tik_tok_username_13, t0.tik_tok_link AS tik_tok_link_14, t0.imdb_link AS imdb_link_15, t0.wikipedia_link AS wikipedia_link_16, t0.approve_status AS approve_status_17, t0.old_parents AS old_parents_18, t0.thumbnail AS thumbnail_19, t0.description AS description_20, t0.short_description AS short_description_21, t0.actual_publish_date AS actual_publish_date_22, t0.youtube_username AS youtube_username_23, t0.youtube_link AS youtube_link_24, t0.instagram_username AS instagram_username_25, t0.instagram_link AS instagram_link_26, t0.twitter_username AS twitter_username_27, t0.twitter_link AS twitter_link_28, t0.facebook_username AS facebook_username_29, t0.facebook_link AS facebook_link_30, t0.website_link AS website_link_31, t0.stripe_customer AS stripe_customer_32 FROM music_artist t0 WHERE t0.id = 6 AND t0.publish = 1 LIMIT 1;

SELECT
  m0_.name AS name_0,
  m0_.thumbnail AS thumbnail_1,
  m0_.short_description AS short_description_2,
  m0_.description AS description_3,
  m0_.release_date AS release_date_4,
  m0_.publish AS publish_5,
  m0_.complete AS complete_6,
  m0_.updated AS updated_7,
  m0_.position AS position_8,
  m0_.id AS id_9,
  m0_.auto_mainstreet AS auto_mainstreet_10,
  m0_.commission AS commission_11,
  m0_.contact_name AS contact_name_12,
  m0_.email AS email_13,
  m0_.video_link AS video_link_14,
  m0_.spotify_username AS spotify_username_15,
  m0_.spotify_link AS spotify_link_16,
  m0_.sound_cloud_username AS sound_cloud_username_17,
  m0_.sound_cloud_link AS sound_cloud_link_18,
  m0_.tik_tok_username AS tik_tok_username_19,
  m0_.tik_tok_link AS tik_tok_link_20,
  m0_.approve_status AS approve_status_21,
  m0_.old_parents AS old_parents_22,
  m0_.publish_date AS publish_date_23,
  m0_.actual_publish_date AS actual_publish_date_24,
  m0_.youtube_username AS youtube_username_25,
  m0_.youtube_link AS youtube_link_26,
  m0_.instagram_username AS instagram_username_27,
  m0_.instagram_link AS instagram_link_28,
  m0_.twitter_username AS twitter_username_29,
  m0_.twitter_link AS twitter_link_30,
  m0_.facebook_username AS facebook_username_31,
  m0_.facebook_link AS facebook_link_32,
  m0_.website_link AS website_link_33,
  m0_.stripe_customer AS stripe_customer_34,
  m0_.season_id AS season_id_35
FROM
  music_video m0_
  INNER JOIN music_artist_to_music_video m2_ ON m0_.id = m2_.music_video_id
  INNER JOIN music_artist m1_ ON m1_.id = m2_.music_artist_id
WHERE
  m0_.publish = 1
  AND m1_.id = ?
GROUP BY
  m0_.name,
  m0_.thumbnail,
  m0_.short_description,
  m0_.description,
  m0_.release_date,
  m0_.publish,
  m0_.complete,
  m0_.updated,
  m0_.position,
  m0_.id,
  m0_.auto_mainstreet,
  m0_.commission,
  m0_.contact_name,
  m0_.email,
  m0_.video_link,
  m0_.spotify_username,
  m0_.spotify_link,
  m0_.sound_cloud_username,
  m0_.sound_cloud_link,
  m0_.tik_tok_username,
  m0_.tik_tok_link,
  m0_.approve_status,
  m0_.old_parents,
  m0_.publish_date,
  m0_.actual_publish_date,
  m0_.youtube_username,
  m0_.youtube_link,
  m0_.instagram_username,
  m0_.instagram_link,
  m0_.twitter_username,
  m0_.twitter_link,
  m0_.facebook_username,
  m0_.facebook_link,
  m0_.website_link,
  m0_.stripe_customer,
  m0_.season_id
LIMIT
  1

SELECT m0_.name AS name_0, m0_.thumbnail AS thumbnail_1, m0_.short_description AS short_description_2, m0_.description AS description_3, m0_.release_date AS release_date_4, m0_.publish AS publish_5, m0_.complete AS complete_6, m0_.updated AS updated_7, m0_.position AS position_8, m0_.id AS id_9, m0_.auto_mainstreet AS auto_mainstreet_10, m0_.commission AS commission_11, m0_.contact_name AS contact_name_12, m0_.email AS email_13, m0_.video_link AS video_link_14, m0_.spotify_username AS spotify_username_15, m0_.spotify_link AS spotify_link_16, m0_.sound_cloud_username AS sound_cloud_username_17, m0_.sound_cloud_link AS sound_cloud_link_18, m0_.tik_tok_username AS tik_tok_username_19, m0_.tik_tok_link AS tik_tok_link_20, m0_.approve_status AS approve_status_21, m0_.old_parents AS old_parents_22, m0_.publish_date AS publish_date_23, m0_.actual_publish_date AS actual_publish_date_24, m0_.youtube_username AS youtube_username_25, m0_.youtube_link AS youtube_link_26, m0_.instagram_username AS instagram_username_27, m0_.instagram_link AS instagram_link_28, m0_.twitter_username AS twitter_username_29, m0_.twitter_link AS twitter_link_30, m0_.facebook_username AS facebook_username_31, m0_.facebook_link AS facebook_link_32, m0_.website_link AS website_link_33, m0_.stripe_customer AS stripe_customer_34, m0_.season_id AS season_id_35 FROM music_video m0_ INNER JOIN music_artist_to_music_video m2_ ON m0_.id = m2_.music_video_id INNER JOIN music_artist m1_ ON m1_.id = m2_.music_artist_id WHERE m0_.publish = 1 AND m1_.id = 6 GROUP BY m0_.name, m0_.thumbnail, m0_.short_description, m0_.description, m0_.release_date, m0_.publish, m0_.complete, m0_.updated, m0_.position, m0_.id, m0_.auto_mainstreet, m0_.commission, m0_.contact_name, m0_.email, m0_.video_link, m0_.spotify_username, m0_.spotify_link, m0_.sound_cloud_username, m0_.sound_cloud_link, m0_.tik_tok_username, m0_.tik_tok_link, m0_.approve_status, m0_.old_parents, m0_.publish_date, m0_.actual_publish_date, m0_.youtube_username, m0_.youtube_link, m0_.instagram_username, m0_.instagram_link, m0_.twitter_username, m0_.twitter_link, m0_.facebook_username, m0_.facebook_link, m0_.website_link, m0_.stripe_customer, m0_.season_id LIMIT 1;

SELECT
  m0_.name AS name_0,
  m0_.updated AS updated_1,
  m0_.id AS id_2,
  m0_.position AS position_3,
  m0_.soc_link AS soc_link_4,
  m0_.soc_type AS soc_type_5,
  m0_.publish AS publish_6,
  m0_.publish_date AS publish_date_7,
  m0_.actual_publish_date AS actual_publish_date_8,
  m0_.music_artist_id AS music_artist_id_9,
  m0_.image_to_music_artist_id AS image_to_music_artist_id_10
FROM
  music_artist_posts m0_
  LEFT JOIN bind_music_artist_post_item_character b1_ ON (
    b1_.music_artist_post_id = m0_.id
  )
  LEFT JOIN bind_music_artist_post_item_guest_character b2_ ON (
    b2_.music_artist_post_id = m0_.id
  )
WHERE
  m0_.publish = 1
  AND m0_.music_artist_id = ?
  AND (
    b1_.id IS NOT NULL
    OR b2_.id IS NOT NULL
  )
GROUP BY
  m0_.name,
  m0_.updated,
  m0_.id,
  m0_.position,
  m0_.soc_link,
  m0_.soc_type,
  m0_.publish,
  m0_.publish_date,
  m0_.actual_publish_date,
  m0_.music_artist_id,
  m0_.image_to_music_artist_id
ORDER BY
  m0_.actual_publish_date DESC,
  m0_.position ASC

SELECT m0_.name AS name_0, m0_.updated AS updated_1, m0_.id AS id_2, m0_.position AS position_3, m0_.soc_link AS soc_link_4, m0_.soc_type AS soc_type_5, m0_.publish AS publish_6, m0_.publish_date AS publish_date_7, m0_.actual_publish_date AS actual_publish_date_8, m0_.music_artist_id AS music_artist_id_9, m0_.image_to_music_artist_id AS image_to_music_artist_id_10 FROM music_artist_posts m0_ LEFT JOIN bind_music_artist_post_item_character b1_ ON (b1_.music_artist_post_id = m0_.id) LEFT JOIN bind_music_artist_post_item_guest_character b2_ ON (b2_.music_artist_post_id = m0_.id) WHERE m0_.publish = 1 AND m0_.music_artist_id = 6 AND (b1_.id IS NOT NULL OR b2_.id IS NOT NULL) GROUP BY m0_.name, m0_.updated, m0_.id, m0_.position, m0_.soc_link, m0_.soc_type, m0_.publish, m0_.publish_date, m0_.actual_publish_date, m0_.music_artist_id, m0_.image_to_music_artist_id ORDER BY m0_.actual_publish_date DESC, m0_.position ASC;

SELECT
  m0_.name AS name_0,
  m0_.updated AS updated_1,
  m0_.position AS position_2,
  m0_.id AS id_3,
  m0_.publish AS publish_4,
  m0_.publish_date AS publish_date_5,
  m0_.actual_publish_date AS actual_publish_date_6,
  m0_.music_artist_id AS music_artist_id_7,
  m0_.image_to_music_artist_id AS image_to_music_artist_id_8
FROM
  music_artist_merch m0_
  INNER JOIN bind_music_artist_merch b1_ ON (
    b1_.music_artist_merch_id = m0_.id
  )
WHERE
  m0_.publish = 1
  AND m0_.music_artist_id = ?
GROUP BY
  m0_.name,
  m0_.updated,
  m0_.position,
  m0_.id,
  m0_.publish,
  m0_.publish_date,
  m0_.actual_publish_date,
  m0_.music_artist_id,
  m0_.image_to_music_artist_id
ORDER BY
  m0_.actual_publish_date DESC,
  m0_.position ASC

SELECT m0_.name AS name_0, m0_.updated AS updated_1, m0_.position AS position_2, m0_.id AS id_3, m0_.publish AS publish_4, m0_.publish_date AS publish_date_5, m0_.actual_publish_date AS actual_publish_date_6, m0_.music_artist_id AS music_artist_id_7, m0_.image_to_music_artist_id AS image_to_music_artist_id_8 FROM music_artist_merch m0_ INNER JOIN bind_music_artist_merch b1_ ON (b1_.music_artist_merch_id = m0_.id) WHERE m0_.publish = 1 AND m0_.music_artist_id = 6 GROUP BY m0_.name, m0_.updated, m0_.position, m0_.id, m0_.publish, m0_.publish_date, m0_.actual_publish_date, m0_.music_artist_id, m0_.image_to_music_artist_id ORDER BY m0_.actual_publish_date DESC, m0_.position ASC;

SELECT
  m0_.thumbnail AS thumbnail_0,
  m0_.position AS position_1,
  m0_.updated AS updated_2,
  m0_.name AS name_3,
  m0_.description AS description_4,
  m0_.id AS id_5,
  m0_.actual_publish_date AS actual_publish_date_6,
  m0_.music_artist_id AS music_artist_id_7,
  m0_.music_performer_id AS music_performer_id_8,
  m0_.artist_id AS artist_id_9,
  m0_.image_to_music_artist_id AS image_to_music_artist_id_10
FROM
  music_artist_character m0_
  INNER JOIN music_artist_posts m1_ ON (
    m1_.music_artist_id = ?
    AND m1_.publish = 1
  )
  INNER JOIN bind_music_artist_post_item_character b2_ ON (
    b2_.music_artist_character_id = m0_.id
    AND b2_.music_artist_post_id = m1_.id
  )
WHERE
  m0_.music_artist_id = ?
ORDER BY
  m0_.actual_publish_date DESC,
  m0_.position ASC

SELECT m0_.thumbnail AS thumbnail_0, m0_.position AS position_1, m0_.updated AS updated_2, m0_.name AS name_3, m0_.description AS description_4, m0_.id AS id_5, m0_.actual_publish_date AS actual_publish_date_6, m0_.music_artist_id AS music_artist_id_7, m0_.music_performer_id AS music_performer_id_8, m0_.artist_id AS artist_id_9, m0_.image_to_music_artist_id AS image_to_music_artist_id_10 FROM music_artist_character m0_ INNER JOIN music_artist_posts m1_ ON (m1_.music_artist_id = 6 AND m1_.publish = 1) INNER JOIN bind_music_artist_post_item_character b2_ ON (b2_.music_artist_character_id = m0_.id AND b2_.music_artist_post_id = m1_.id) WHERE m0_.music_artist_id = 6 ORDER BY m0_.actual_publish_date DESC, m0_.position ASC;

SELECT
  m0_.thumbnail AS thumbnail_0,
  m0_.position AS position_1,
  m0_.updated AS updated_2,
  m0_.name AS name_3,
  m0_.description AS description_4,
  m0_.id AS id_5,
  m0_.actual_publish_date AS actual_publish_date_6,
  m0_.music_artist_id AS music_artist_id_7,
  m0_.music_performer_id AS music_performer_id_8,
  m0_.artist_id AS artist_id_9,
  m0_.image_to_music_artist_id AS image_to_music_artist_id_10
FROM
  music_artist_guest_character m0_
  INNER JOIN music_artist_posts m1_ ON (
    m1_.music_artist_id = ?
    AND m1_.publish = 1
  )
  INNER JOIN bind_music_artist_post_item_guest_character b2_ ON (
    b2_.music_artist_guest_character_id = m0_.id
    AND b2_.music_artist_post_id = m1_.id
  )
WHERE
  m0_.music_artist_id = ?
ORDER BY
  m0_.actual_publish_date DESC,
  m0_.position ASC

SELECT m0_.thumbnail AS thumbnail_0, m0_.position AS position_1, m0_.updated AS updated_2, m0_.name AS name_3, m0_.description AS description_4, m0_.id AS id_5, m0_.actual_publish_date AS actual_publish_date_6, m0_.music_artist_id AS music_artist_id_7, m0_.music_performer_id AS music_performer_id_8, m0_.artist_id AS artist_id_9, m0_.image_to_music_artist_id AS image_to_music_artist_id_10 FROM music_artist_guest_character m0_ INNER JOIN music_artist_posts m1_ ON (m1_.music_artist_id = 6 AND m1_.publish = 1) INNER JOIN bind_music_artist_post_item_guest_character b2_ ON (b2_.music_artist_guest_character_id = m0_.id AND b2_.music_artist_post_id = m1_.id) WHERE m0_.music_artist_id = 6 ORDER BY m0_.actual_publish_date DESC, m0_.position ASC;