Symfony Profiler

Query Metrics

28 Database Queries

18 Different statements

549.02 ms Query time

27 Invalid entities

450 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

224.47 ms
(40.89%)

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_music_video_scene_item_character b5_ ON (b5_.e_commerce_item_id = e3_.id) LEFT JOIN bind_music_video_character_signature_item b6_ ON (b6_.e_commerce_item_id = e3_.id) LEFT JOIN bind_music_video_set_item b7_ ON (b7_.e_commerce_item_id = e3_.id) LEFT JOIN music_video_character m8_ ON b5_.music_video_character_id = m8_.id LEFT JOIN music_video_character_signature m9_ ON b6_.music_video_character_signature_id = m9_.id LEFT JOIN music_video_set m10_ ON b7_.music_video_set_id = m10_.id LEFT JOIN music_video m11_ ON m8_.music_video_id = m11_.id LEFT JOIN music_video_character m12_ ON m9_.character_id = m12_.id LEFT JOIN music_video m13_ ON m12_.music_video_id = m13_.id LEFT JOIN music_video_set_category m14_ ON m10_.music_video_set_category_id = m14_.id LEFT JOIN music_video m15_ ON m14_.music_video_id = m15_.id LEFT JOIN music_scene m16_ ON b5_.music_scene_id = m16_.id WHERE (b5_.e_commerce_item_id = e3_.id OR b6_.e_commerce_item_id = e3_.id OR b7_.e_commerce_item_id = e3_.id) AND ((m16_.publish = 1 AND m11_.publish = 1) OR m13_.publish = 1 OR (m10_.publish = 1 AND m14_.publish = 1 AND m15_.publish = 1)) AND e3_.removed = 0 GROUP BY e0_.target_id ORDER BY sclr_3 DESC LIMIT 5

Parameters:

[
  "2026-02-18 00:00:00"
  "2026-02-18 00:00:00"
  "2026-02-18 00:00:00"
]

View formatted query View runnable query Explain query View query backtrace

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_music_video_scene_item_character b5_ ON (b5_.e_commerce_item_id = e3_.id)
  LEFT JOIN bind_music_video_character_signature_item b6_ ON (b6_.e_commerce_item_id = e3_.id)
  LEFT JOIN bind_music_video_set_item b7_ ON (b7_.e_commerce_item_id = e3_.id)
  LEFT JOIN music_video_character m8_ ON b5_.music_video_character_id = m8_.id
  LEFT JOIN music_video_character_signature m9_ ON b6_.music_video_character_signature_id = m9_.id
  LEFT JOIN music_video_set m10_ ON b7_.music_video_set_id = m10_.id
  LEFT JOIN music_video m11_ ON m8_.music_video_id = m11_.id
  LEFT JOIN music_video_character m12_ ON m9_.character_id = m12_.id
  LEFT JOIN music_video m13_ ON m12_.music_video_id = m13_.id
  LEFT JOIN music_video_set_category m14_ ON m10_.music_video_set_category_id = m14_.id
  LEFT JOIN music_video m15_ ON m14_.music_video_id = m15_.id
  LEFT JOIN music_scene m16_ ON b5_.music_scene_id = m16_.id
WHERE
  (
    b5_.e_commerce_item_id = e3_.id
    OR b6_.e_commerce_item_id = e3_.id
    OR b7_.e_commerce_item_id = e3_.id
  )
  AND (
    (
      m16_.publish = 1
      AND m11_.publish = 1
    )
    OR m13_.publish = 1
    OR (
      m10_.publish = 1
      AND m14_.publish = 1
      AND m15_.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_music_video_scene_item_character b5_ ON (b5_.e_commerce_item_id = e3_.id) LEFT JOIN bind_music_video_character_signature_item b6_ ON (b6_.e_commerce_item_id = e3_.id) LEFT JOIN bind_music_video_set_item b7_ ON (b7_.e_commerce_item_id = e3_.id) LEFT JOIN music_video_character m8_ ON b5_.music_video_character_id = m8_.id LEFT JOIN music_video_character_signature m9_ ON b6_.music_video_character_signature_id = m9_.id LEFT JOIN music_video_set m10_ ON b7_.music_video_set_id = m10_.id LEFT JOIN music_video m11_ ON m8_.music_video_id = m11_.id LEFT JOIN music_video_character m12_ ON m9_.character_id = m12_.id LEFT JOIN music_video m13_ ON m12_.music_video_id = m13_.id LEFT JOIN music_video_set_category m14_ ON m10_.music_video_set_category_id = m14_.id LEFT JOIN music_video m15_ ON m14_.music_video_id = m15_.id LEFT JOIN music_scene m16_ ON b5_.music_scene_id = m16_.id WHERE (b5_.e_commerce_item_id = e3_.id OR b6_.e_commerce_item_id = e3_.id OR b7_.e_commerce_item_id = e3_.id) AND ((m16_.publish = 1 AND m11_.publish = 1) OR m13_.publish = 1 OR (m10_.publish = 1 AND m14_.publish = 1 AND m15_.publish = 1)) AND e3_.removed = 0 GROUP BY e0_.target_id ORDER BY sclr_3 DESC LIMIT 5;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	Mirinly\AdminBundle\Entity\ECommerceItemTrendRepository->getECommerceItemTrendsForMusicVideos (line 276)
7	Mirinly\FrontBundle\Controller\MusicVideosController->indexAction (line 69)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 185)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

102.86 ms
(18.74%)

SELECT m0_.points AS points_0, m0_.id AS id_1, m0_.updated AS updated_2, sum(m0_.points) AS sclr_3, sum(m1_.points) AS sclr_4, sum(m2_.points) / (DATEDIFF(?, min(m2_.updated))) AS sclr_5, 'music_artist' AS sclr_6, m0_.target_id AS target_id_7 FROM music_artist_character_trend m0_ LEFT JOIN music_artist_character_trend m2_ ON (m2_.id = m0_.id AND m2_.updated < ?) LEFT JOIN music_artist_character_trend m1_ ON (m1_.id = m0_.id AND m1_.updated >= ?) INNER JOIN music_artist_character m3_ ON m0_.target_id = m3_.id INNER JOIN music_artist m4_ ON m3_.music_artist_id = m4_.id AND (m4_.publish = 1) INNER JOIN music_video_character m5_ ON (m5_.artist_id = m3_.artist_id) GROUP BY m0_.target_id ORDER BY sclr_3 DESC LIMIT 5

Parameters:

[
  "2026-02-18 00:00:00"
  "2026-02-18 00:00:00"
  "2026-02-18 00:00:00"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.points AS points_0,
  m0_.id AS id_1,
  m0_.updated AS updated_2,
  sum(m0_.points) AS sclr_3,
  sum(m1_.points) AS sclr_4,
  sum(m2_.points) / (
    DATEDIFF(
      ?,
      min(m2_.updated)
    )
  ) AS sclr_5,
  'music_artist' AS sclr_6,
  m0_.target_id AS target_id_7
FROM
  music_artist_character_trend m0_
  LEFT JOIN music_artist_character_trend m2_ ON (
    m2_.id = m0_.id
    AND m2_.updated < ?
  )
  LEFT JOIN music_artist_character_trend m1_ ON (
    m1_.id = m0_.id
    AND m1_.updated >= ?
  )
  INNER JOIN music_artist_character m3_ ON m0_.target_id = m3_.id
  INNER JOIN music_artist m4_ ON m3_.music_artist_id = m4_.id
  AND (m4_.publish = 1)
  INNER JOIN music_video_character m5_ ON (m5_.artist_id = m3_.artist_id)
GROUP BY
  m0_.target_id
ORDER BY
  sclr_3 DESC
LIMIT
  5

SELECT m0_.points AS points_0, m0_.id AS id_1, m0_.updated AS updated_2, sum(m0_.points) AS sclr_3, sum(m1_.points) AS sclr_4, sum(m2_.points) / (DATEDIFF('2026-02-18 00:00:00', min(m2_.updated))) AS sclr_5, 'music_artist' AS sclr_6, m0_.target_id AS target_id_7 FROM music_artist_character_trend m0_ LEFT JOIN music_artist_character_trend m2_ ON (m2_.id = m0_.id AND m2_.updated < '2026-02-18 00:00:00') LEFT JOIN music_artist_character_trend m1_ ON (m1_.id = m0_.id AND m1_.updated >= '2026-02-18 00:00:00') INNER JOIN music_artist_character m3_ ON m0_.target_id = m3_.id INNER JOIN music_artist m4_ ON m3_.music_artist_id = m4_.id AND (m4_.publish = 1) INNER JOIN music_video_character m5_ ON (m5_.artist_id = m3_.artist_id) GROUP BY m0_.target_id ORDER BY sclr_3 DESC LIMIT 5;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	Mirinly\AdminBundle\Entity\MusicArtistCharacterTrendRepository->getMusicArtistCharacterTrends (line 35)
7	Mirinly\FrontBundle\Controller\MusicVideosController->indexAction (line 65)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 185)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

84.86 ms
(15.46%)

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_ LEFT JOIN music_artist_to_music_video m2_ ON m0_.id = m2_.music_video_id LEFT JOIN music_artist m1_ ON m1_.id = m2_.music_artist_id AND (m1_.publish = 1) LEFT JOIN music_scene m3_ ON m0_.id = m3_.music_video_id AND (m3_.publish = 1) LEFT JOIN bind_music_video_scene_item_character b4_ ON (b4_.music_scene_id = m3_.id) LEFT JOIN music_artist_to_music_video m6_ ON m1_.id = m6_.music_artist_id LEFT JOIN music_video m5_ ON m5_.id = m6_.music_video_id AND (m5_.publish = 1) LEFT JOIN music_video_character m7_ ON m5_.id = m7_.music_video_id LEFT JOIN music_video_character_signature m8_ ON m7_.id = m8_.character_id AND (m8_.publish = 1) LEFT JOIN bind_music_video_character_signature_item b9_ ON (b9_.music_video_character_signature_id = m8_.id) LEFT JOIN music_artist_character m10_ ON m1_.id = m10_.music_artist_id AND (m7_.artist_id = m10_.artist_id) LEFT JOIN music_scene m11_ ON m5_.id = m11_.music_video_id AND (m11_.publish = 1) LEFT JOIN bind_music_video_scene_item_character b12_ ON (b12_.music_scene_id = m11_.id AND b12_.music_video_character_id = m7_.id) LEFT JOIN music_artist_posts m13_ ON m1_.id = m13_.music_artist_id AND (m13_.publish = 1) LEFT JOIN bind_music_artist_post_item_character b14_ ON (b14_.music_artist_character_id = m10_.id AND b14_.music_artist_post_id = m13_.id) LEFT JOIN music_video_set_category m15_ ON m0_.id = m15_.music_video_id AND (m15_.publish = 1) LEFT JOIN music_video_set m16_ ON m15_.id = m16_.music_video_set_category_id AND (m16_.publish = 1) LEFT JOIN bind_music_video_set_item b17_ ON (b17_.music_video_set_id = m16_.id) LEFT JOIN music_artist_posts m18_ ON m1_.id = m18_.music_artist_id AND (m18_.publish = 1) LEFT JOIN bind_music_artist_post_item_character b19_ ON (b19_.music_artist_post_id = m18_.id) LEFT JOIN music_artist_merch m20_ ON m1_.id = m20_.music_artist_id AND (m20_.publish = 1) LEFT JOIN bind_music_artist_merch b21_ ON (b21_.music_artist_merch_id = m20_.id) WHERE (b4_.id IS NOT NULL OR ((b9_.id IS NOT NULL OR b12_.id IS NOT NULL OR b14_.id IS NOT NULL) AND m10_.id IS NOT NULL) OR b17_.id IS NOT NULL OR b19_.id IS NOT NULL OR b21_.id IS NOT NULL) AND m0_.publish = 1 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 ORDER BY m0_.actual_publish_date DESC, m0_.position ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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_
  LEFT JOIN music_artist_to_music_video m2_ ON m0_.id = m2_.music_video_id
  LEFT JOIN music_artist m1_ ON m1_.id = m2_.music_artist_id
  AND (m1_.publish = 1)
  LEFT JOIN music_scene m3_ ON m0_.id = m3_.music_video_id
  AND (m3_.publish = 1)
  LEFT JOIN bind_music_video_scene_item_character b4_ ON (b4_.music_scene_id = m3_.id)
  LEFT JOIN music_artist_to_music_video m6_ ON m1_.id = m6_.music_artist_id
  LEFT JOIN music_video m5_ ON m5_.id = m6_.music_video_id
  AND (m5_.publish = 1)
  LEFT JOIN music_video_character m7_ ON m5_.id = m7_.music_video_id
  LEFT JOIN music_video_character_signature m8_ ON m7_.id = m8_.character_id
  AND (m8_.publish = 1)
  LEFT JOIN bind_music_video_character_signature_item b9_ ON (
    b9_.music_video_character_signature_id = m8_.id
  )
  LEFT JOIN music_artist_character m10_ ON m1_.id = m10_.music_artist_id
  AND (m7_.artist_id = m10_.artist_id)
  LEFT JOIN music_scene m11_ ON m5_.id = m11_.music_video_id
  AND (m11_.publish = 1)
  LEFT JOIN bind_music_video_scene_item_character b12_ ON (
    b12_.music_scene_id = m11_.id
    AND b12_.music_video_character_id = m7_.id
  )
  LEFT JOIN music_artist_posts m13_ ON m1_.id = m13_.music_artist_id
  AND (m13_.publish = 1)
  LEFT JOIN bind_music_artist_post_item_character b14_ ON (
    b14_.music_artist_character_id = m10_.id
    AND b14_.music_artist_post_id = m13_.id
  )
  LEFT JOIN music_video_set_category m15_ ON m0_.id = m15_.music_video_id
  AND (m15_.publish = 1)
  LEFT JOIN music_video_set m16_ ON m15_.id = m16_.music_video_set_category_id
  AND (m16_.publish = 1)
  LEFT JOIN bind_music_video_set_item b17_ ON (
    b17_.music_video_set_id = m16_.id
  )
  LEFT JOIN music_artist_posts m18_ ON m1_.id = m18_.music_artist_id
  AND (m18_.publish = 1)
  LEFT JOIN bind_music_artist_post_item_character b19_ ON (
    b19_.music_artist_post_id = m18_.id
  )
  LEFT JOIN music_artist_merch m20_ ON m1_.id = m20_.music_artist_id
  AND (m20_.publish = 1)
  LEFT JOIN bind_music_artist_merch b21_ ON (
    b21_.music_artist_merch_id = m20_.id
  )
WHERE
  (
    b4_.id IS NOT NULL
    OR (
      (
        b9_.id IS NOT NULL
        OR b12_.id IS NOT NULL
        OR b14_.id IS NOT NULL
      )
      AND m10_.id IS NOT NULL
    )
    OR b17_.id IS NOT NULL
    OR b19_.id IS NOT NULL
    OR b21_.id IS NOT NULL
  )
  AND m0_.publish = 1
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
ORDER BY
  m0_.actual_publish_date DESC,
  m0_.position ASC

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_ LEFT JOIN music_artist_to_music_video m2_ ON m0_.id = m2_.music_video_id LEFT JOIN music_artist m1_ ON m1_.id = m2_.music_artist_id AND (m1_.publish = 1) LEFT JOIN music_scene m3_ ON m0_.id = m3_.music_video_id AND (m3_.publish = 1) LEFT JOIN bind_music_video_scene_item_character b4_ ON (b4_.music_scene_id = m3_.id) LEFT JOIN music_artist_to_music_video m6_ ON m1_.id = m6_.music_artist_id LEFT JOIN music_video m5_ ON m5_.id = m6_.music_video_id AND (m5_.publish = 1) LEFT JOIN music_video_character m7_ ON m5_.id = m7_.music_video_id LEFT JOIN music_video_character_signature m8_ ON m7_.id = m8_.character_id AND (m8_.publish = 1) LEFT JOIN bind_music_video_character_signature_item b9_ ON (b9_.music_video_character_signature_id = m8_.id) LEFT JOIN music_artist_character m10_ ON m1_.id = m10_.music_artist_id AND (m7_.artist_id = m10_.artist_id) LEFT JOIN music_scene m11_ ON m5_.id = m11_.music_video_id AND (m11_.publish = 1) LEFT JOIN bind_music_video_scene_item_character b12_ ON (b12_.music_scene_id = m11_.id AND b12_.music_video_character_id = m7_.id) LEFT JOIN music_artist_posts m13_ ON m1_.id = m13_.music_artist_id AND (m13_.publish = 1) LEFT JOIN bind_music_artist_post_item_character b14_ ON (b14_.music_artist_character_id = m10_.id AND b14_.music_artist_post_id = m13_.id) LEFT JOIN music_video_set_category m15_ ON m0_.id = m15_.music_video_id AND (m15_.publish = 1) LEFT JOIN music_video_set m16_ ON m15_.id = m16_.music_video_set_category_id AND (m16_.publish = 1) LEFT JOIN bind_music_video_set_item b17_ ON (b17_.music_video_set_id = m16_.id) LEFT JOIN music_artist_posts m18_ ON m1_.id = m18_.music_artist_id AND (m18_.publish = 1) LEFT JOIN bind_music_artist_post_item_character b19_ ON (b19_.music_artist_post_id = m18_.id) LEFT JOIN music_artist_merch m20_ ON m1_.id = m20_.music_artist_id AND (m20_.publish = 1) LEFT JOIN bind_music_artist_merch b21_ ON (b21_.music_artist_merch_id = m20_.id) WHERE (b4_.id IS NOT NULL OR ((b9_.id IS NOT NULL OR b12_.id IS NOT NULL OR b14_.id IS NOT NULL) AND m10_.id IS NOT NULL) OR b17_.id IS NOT NULL OR b19_.id IS NOT NULL OR b21_.id IS NOT NULL) AND m0_.publish = 1 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 ORDER BY m0_.actual_publish_date DESC, m0_.position ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	Mirinly\AdminBundle\Entity\MusicVideoRepository->getNewlyAddedAndPublishedMusicVideos (line 78)
7	Mirinly\FrontBundle\Controller\MusicVideosController->indexAction (line 57)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 185)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

77.64 ms
(14.14%)

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_ LEFT JOIN music_artist_to_music_video m2_ ON m0_.id = m2_.music_video_id LEFT JOIN music_artist m1_ ON m1_.id = m2_.music_artist_id AND (m1_.publish = 1) LEFT JOIN music_scene m3_ ON m0_.id = m3_.music_video_id AND (m3_.publish = 1) LEFT JOIN bind_music_video_scene_item_character b4_ ON (b4_.music_scene_id = m3_.id) LEFT JOIN music_artist_to_music_video m6_ ON m1_.id = m6_.music_artist_id LEFT JOIN music_video m5_ ON m5_.id = m6_.music_video_id AND (m5_.publish = 1) LEFT JOIN music_video_character m7_ ON m5_.id = m7_.music_video_id LEFT JOIN music_video_character_signature m8_ ON m7_.id = m8_.character_id AND (m8_.publish = 1) LEFT JOIN bind_music_video_character_signature_item b9_ ON (b9_.music_video_character_signature_id = m8_.id) LEFT JOIN music_artist_character m10_ ON m1_.id = m10_.music_artist_id AND (m7_.artist_id = m10_.artist_id) LEFT JOIN music_scene m11_ ON m5_.id = m11_.music_video_id AND (m11_.publish = 1) LEFT JOIN bind_music_video_scene_item_character b12_ ON (b12_.music_scene_id = m11_.id AND b12_.music_video_character_id = m7_.id) LEFT JOIN music_artist_posts m13_ ON m1_.id = m13_.music_artist_id AND (m13_.publish = 1) LEFT JOIN bind_music_artist_post_item_character b14_ ON (b14_.music_artist_character_id = m10_.id AND b14_.music_artist_post_id = m13_.id) LEFT JOIN music_video_set_category m15_ ON m0_.id = m15_.music_video_id AND (m15_.publish = 1) LEFT JOIN music_video_set m16_ ON m15_.id = m16_.music_video_set_category_id AND (m16_.publish = 1) LEFT JOIN bind_music_video_set_item b17_ ON (b17_.music_video_set_id = m16_.id) LEFT JOIN music_artist_posts m18_ ON m1_.id = m18_.music_artist_id AND (m18_.publish = 1) LEFT JOIN bind_music_artist_post_item_character b19_ ON (b19_.music_artist_post_id = m18_.id) LEFT JOIN music_artist_merch m20_ ON m1_.id = m20_.music_artist_id AND (m20_.publish = 1) LEFT JOIN bind_music_artist_merch b21_ ON (b21_.music_artist_merch_id = m20_.id) WHERE (b4_.id IS NOT NULL OR ((b9_.id IS NOT NULL OR b12_.id IS NOT NULL OR b14_.id IS NOT NULL) AND m10_.id IS NOT NULL) OR b17_.id IS NOT NULL OR b19_.id IS NOT NULL OR b21_.id IS NOT NULL) AND m0_.publish = 1 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 ORDER BY m0_.name ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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_
  LEFT JOIN music_artist_to_music_video m2_ ON m0_.id = m2_.music_video_id
  LEFT JOIN music_artist m1_ ON m1_.id = m2_.music_artist_id
  AND (m1_.publish = 1)
  LEFT JOIN music_scene m3_ ON m0_.id = m3_.music_video_id
  AND (m3_.publish = 1)
  LEFT JOIN bind_music_video_scene_item_character b4_ ON (b4_.music_scene_id = m3_.id)
  LEFT JOIN music_artist_to_music_video m6_ ON m1_.id = m6_.music_artist_id
  LEFT JOIN music_video m5_ ON m5_.id = m6_.music_video_id
  AND (m5_.publish = 1)
  LEFT JOIN music_video_character m7_ ON m5_.id = m7_.music_video_id
  LEFT JOIN music_video_character_signature m8_ ON m7_.id = m8_.character_id
  AND (m8_.publish = 1)
  LEFT JOIN bind_music_video_character_signature_item b9_ ON (
    b9_.music_video_character_signature_id = m8_.id
  )
  LEFT JOIN music_artist_character m10_ ON m1_.id = m10_.music_artist_id
  AND (m7_.artist_id = m10_.artist_id)
  LEFT JOIN music_scene m11_ ON m5_.id = m11_.music_video_id
  AND (m11_.publish = 1)
  LEFT JOIN bind_music_video_scene_item_character b12_ ON (
    b12_.music_scene_id = m11_.id
    AND b12_.music_video_character_id = m7_.id
  )
  LEFT JOIN music_artist_posts m13_ ON m1_.id = m13_.music_artist_id
  AND (m13_.publish = 1)
  LEFT JOIN bind_music_artist_post_item_character b14_ ON (
    b14_.music_artist_character_id = m10_.id
    AND b14_.music_artist_post_id = m13_.id
  )
  LEFT JOIN music_video_set_category m15_ ON m0_.id = m15_.music_video_id
  AND (m15_.publish = 1)
  LEFT JOIN music_video_set m16_ ON m15_.id = m16_.music_video_set_category_id
  AND (m16_.publish = 1)
  LEFT JOIN bind_music_video_set_item b17_ ON (
    b17_.music_video_set_id = m16_.id
  )
  LEFT JOIN music_artist_posts m18_ ON m1_.id = m18_.music_artist_id
  AND (m18_.publish = 1)
  LEFT JOIN bind_music_artist_post_item_character b19_ ON (
    b19_.music_artist_post_id = m18_.id
  )
  LEFT JOIN music_artist_merch m20_ ON m1_.id = m20_.music_artist_id
  AND (m20_.publish = 1)
  LEFT JOIN bind_music_artist_merch b21_ ON (
    b21_.music_artist_merch_id = m20_.id
  )
WHERE
  (
    b4_.id IS NOT NULL
    OR (
      (
        b9_.id IS NOT NULL
        OR b12_.id IS NOT NULL
        OR b14_.id IS NOT NULL
      )
      AND m10_.id IS NOT NULL
    )
    OR b17_.id IS NOT NULL
    OR b19_.id IS NOT NULL
    OR b21_.id IS NOT NULL
  )
  AND m0_.publish = 1
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
ORDER BY
  m0_.name ASC

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_ LEFT JOIN music_artist_to_music_video m2_ ON m0_.id = m2_.music_video_id LEFT JOIN music_artist m1_ ON m1_.id = m2_.music_artist_id AND (m1_.publish = 1) LEFT JOIN music_scene m3_ ON m0_.id = m3_.music_video_id AND (m3_.publish = 1) LEFT JOIN bind_music_video_scene_item_character b4_ ON (b4_.music_scene_id = m3_.id) LEFT JOIN music_artist_to_music_video m6_ ON m1_.id = m6_.music_artist_id LEFT JOIN music_video m5_ ON m5_.id = m6_.music_video_id AND (m5_.publish = 1) LEFT JOIN music_video_character m7_ ON m5_.id = m7_.music_video_id LEFT JOIN music_video_character_signature m8_ ON m7_.id = m8_.character_id AND (m8_.publish = 1) LEFT JOIN bind_music_video_character_signature_item b9_ ON (b9_.music_video_character_signature_id = m8_.id) LEFT JOIN music_artist_character m10_ ON m1_.id = m10_.music_artist_id AND (m7_.artist_id = m10_.artist_id) LEFT JOIN music_scene m11_ ON m5_.id = m11_.music_video_id AND (m11_.publish = 1) LEFT JOIN bind_music_video_scene_item_character b12_ ON (b12_.music_scene_id = m11_.id AND b12_.music_video_character_id = m7_.id) LEFT JOIN music_artist_posts m13_ ON m1_.id = m13_.music_artist_id AND (m13_.publish = 1) LEFT JOIN bind_music_artist_post_item_character b14_ ON (b14_.music_artist_character_id = m10_.id AND b14_.music_artist_post_id = m13_.id) LEFT JOIN music_video_set_category m15_ ON m0_.id = m15_.music_video_id AND (m15_.publish = 1) LEFT JOIN music_video_set m16_ ON m15_.id = m16_.music_video_set_category_id AND (m16_.publish = 1) LEFT JOIN bind_music_video_set_item b17_ ON (b17_.music_video_set_id = m16_.id) LEFT JOIN music_artist_posts m18_ ON m1_.id = m18_.music_artist_id AND (m18_.publish = 1) LEFT JOIN bind_music_artist_post_item_character b19_ ON (b19_.music_artist_post_id = m18_.id) LEFT JOIN music_artist_merch m20_ ON m1_.id = m20_.music_artist_id AND (m20_.publish = 1) LEFT JOIN bind_music_artist_merch b21_ ON (b21_.music_artist_merch_id = m20_.id) WHERE (b4_.id IS NOT NULL OR ((b9_.id IS NOT NULL OR b12_.id IS NOT NULL OR b14_.id IS NOT NULL) AND m10_.id IS NOT NULL) OR b17_.id IS NOT NULL OR b19_.id IS NOT NULL OR b21_.id IS NOT NULL) AND m0_.publish = 1 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 ORDER BY m0_.name ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	Mirinly\AdminBundle\Entity\MusicVideoRepository->getPublishedAndNotEmptyMusicVideosOrderByName (line 63)
7	Mirinly\FrontBundle\Controller\MusicVideosController->getDirectories (line 2394)
8	Mirinly\FrontBundle\Controller\MusicVideosController->indexAction (line 79)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 185)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

33.14 ms
(6.04%)

SELECT m0_.points AS points_0, m0_.id AS id_1, m0_.updated AS updated_2, sum(m0_.points) AS sclr_3, sum(m1_.points) AS sclr_4, sum(m2_.points) / (DATEDIFF(?, min(m2_.updated))) AS sclr_5, m0_.target_id AS target_id_6 FROM music_video_trend m0_ LEFT JOIN music_video_trend m2_ ON (m2_.id = m0_.id AND m2_.updated < ?) LEFT JOIN music_video_trend m1_ ON (m1_.id = m0_.id AND m1_.updated >= ?) INNER JOIN music_video m3_ ON m0_.target_id = m3_.id AND (m3_.publish = 1) GROUP BY m0_.target_id ORDER BY sclr_3 DESC LIMIT 5

Parameters:

[
  "2026-02-18 00:00:00"
  "2026-02-18 00:00:00"
  "2026-02-18 00:00:00"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.points AS points_0,
  m0_.id AS id_1,
  m0_.updated AS updated_2,
  sum(m0_.points) AS sclr_3,
  sum(m1_.points) AS sclr_4,
  sum(m2_.points) / (
    DATEDIFF(
      ?,
      min(m2_.updated)
    )
  ) AS sclr_5,
  m0_.target_id AS target_id_6
FROM
  music_video_trend m0_
  LEFT JOIN music_video_trend m2_ ON (
    m2_.id = m0_.id
    AND m2_.updated < ?
  )
  LEFT JOIN music_video_trend m1_ ON (
    m1_.id = m0_.id
    AND m1_.updated >= ?
  )
  INNER JOIN music_video m3_ ON m0_.target_id = m3_.id
  AND (m3_.publish = 1)
GROUP BY
  m0_.target_id
ORDER BY
  sclr_3 DESC
LIMIT
  5

SELECT m0_.points AS points_0, m0_.id AS id_1, m0_.updated AS updated_2, sum(m0_.points) AS sclr_3, sum(m1_.points) AS sclr_4, sum(m2_.points) / (DATEDIFF('2026-02-18 00:00:00', min(m2_.updated))) AS sclr_5, m0_.target_id AS target_id_6 FROM music_video_trend m0_ LEFT JOIN music_video_trend m2_ ON (m2_.id = m0_.id AND m2_.updated < '2026-02-18 00:00:00') LEFT JOIN music_video_trend m1_ ON (m1_.id = m0_.id AND m1_.updated >= '2026-02-18 00:00:00') INNER JOIN music_video m3_ ON m0_.target_id = m3_.id AND (m3_.publish = 1) GROUP BY m0_.target_id ORDER BY sclr_3 DESC LIMIT 5;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	Mirinly\AdminBundle\Entity\MusicVideoTrendRepository->getMusicVideoTrends (line 32)
7	Mirinly\FrontBundle\Controller\MusicVideosController->indexAction (line 61)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 185)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

10.89 ms
(1.98%)

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

Parameters:

[
  "6rf0osiq2qj0ji6fonhc1adne0"
]

View formatted query View runnable query Explain query View query backtrace

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

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	Mirinly\AdminBundle\Entity\CustomersCartRepository->getCustomersCartPublishItems (line 69)
7	Mirinly\FrontBundle\Controller\HomeController->userWelcomeAction (line 367)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
11	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 78)
12	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
13	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 47)
14	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 44)
15	__TwigTemplate_3a8022cedc3a177a8d05e322c8e823dd->doDisplay (line 192)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_e3b5cf7791afca8dd346b08e0dcda643->doDisplay (line 54)
18	Twig\Template->yield (line 402)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 373)
21	Twig\TemplateWrapper->render (line 51)
22	Twig\Environment->render (line 333)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
26	Mirinly\FrontBundle\Controller\MusicVideosController->indexAction (line 167)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 185)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 29)
32	require_once (line 5)

3.98 ms
(0.72%)

SELECT m0_.name AS name_0, m0_.publish AS publish_1, m0_.complete AS complete_2, m0_.updated AS updated_3, m0_.position AS position_4, m0_.id AS id_5, m0_.auto_mainstreet AS auto_mainstreet_6, m0_.commission AS commission_7, m0_.spotify_username AS spotify_username_8, m0_.spotify_link AS spotify_link_9, m0_.sound_cloud_username AS sound_cloud_username_10, m0_.sound_cloud_link AS sound_cloud_link_11, m0_.tik_tok_username AS tik_tok_username_12, m0_.tik_tok_link AS tik_tok_link_13, m0_.imdb_link AS imdb_link_14, m0_.wikipedia_link AS wikipedia_link_15, m0_.approve_status AS approve_status_16, m0_.old_parents AS old_parents_17, m0_.thumbnail AS thumbnail_18, m0_.description AS description_19, m0_.short_description AS short_description_20, m0_.actual_publish_date AS actual_publish_date_21, m0_.youtube_username AS youtube_username_22, m0_.youtube_link AS youtube_link_23, m0_.instagram_username AS instagram_username_24, m0_.instagram_link AS instagram_link_25, m0_.twitter_username AS twitter_username_26, m0_.twitter_link AS twitter_link_27, m0_.facebook_username AS facebook_username_28, m0_.facebook_link AS facebook_link_29, m0_.website_link AS website_link_30, m0_.stripe_customer AS stripe_customer_31 FROM music_artist m0_ LEFT JOIN music_artist_to_music_video m2_ ON m0_.id = m2_.music_artist_id LEFT JOIN music_video m1_ ON m1_.id = m2_.music_video_id AND (m1_.publish = 1) LEFT JOIN music_scene m3_ ON m1_.id = m3_.music_video_id AND (m3_.publish = 1) LEFT JOIN bind_music_video_scene_item_character b4_ ON (b4_.music_scene_id = m3_.id) LEFT JOIN music_video_set_category m5_ ON m1_.id = m5_.music_video_id AND (m5_.publish = 1) LEFT JOIN music_video_set m6_ ON m5_.id = m6_.music_video_set_category_id AND (m6_.publish = 1) LEFT JOIN bind_music_video_set_item b7_ ON (b7_.music_video_set_id = m6_.id) LEFT JOIN music_artist_character m8_ ON m0_.id = m8_.music_artist_id LEFT JOIN music_video_character m9_ ON m1_.id = m9_.music_video_id AND (m9_.artist_id = m8_.artist_id) LEFT JOIN music_video_character_signature m10_ ON m9_.id = m10_.character_id AND (m10_.publish = 1) LEFT JOIN bind_music_video_character_signature_item b11_ ON (b11_.music_video_character_signature_id = m10_.id) LEFT JOIN music_artist_posts m12_ ON m0_.id = m12_.music_artist_id AND (m12_.publish = 1) LEFT JOIN bind_music_artist_post_item_character b13_ ON (b13_.music_artist_character_id = m8_.id AND b13_.music_artist_post_id = m12_.id) LEFT JOIN music_artist_guest_character m14_ ON m0_.id = m14_.music_artist_id LEFT JOIN bind_music_artist_post_item_guest_character b15_ ON (b15_.music_artist_guest_character_id = m14_.id AND b15_.music_artist_post_id = m12_.id) LEFT JOIN music_artist_merch m16_ ON m0_.id = m16_.music_artist_id AND (m16_.publish = 1) LEFT JOIN bind_music_artist_merch b17_ ON (b17_.music_artist_merch_id = m16_.id) WHERE (b4_.id IS NOT NULL OR b7_.id IS NOT NULL OR b11_.id IS NOT NULL OR b13_.id IS NOT NULL OR b15_.id IS NOT NULL OR b17_.id IS NOT NULL) AND m0_.publish = 1 GROUP BY m0_.name, m0_.publish, m0_.complete, m0_.updated, m0_.position, m0_.id, m0_.auto_mainstreet, m0_.commission, m0_.spotify_username, m0_.spotify_link, m0_.sound_cloud_username, m0_.sound_cloud_link, m0_.tik_tok_username, m0_.tik_tok_link, m0_.imdb_link, m0_.wikipedia_link, m0_.approve_status, m0_.old_parents, m0_.thumbnail, m0_.description, m0_.short_description, 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 ORDER BY m0_.actual_publish_date DESC, m0_.position ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.name AS name_0,
  m0_.publish AS publish_1,
  m0_.complete AS complete_2,
  m0_.updated AS updated_3,
  m0_.position AS position_4,
  m0_.id AS id_5,
  m0_.auto_mainstreet AS auto_mainstreet_6,
  m0_.commission AS commission_7,
  m0_.spotify_username AS spotify_username_8,
  m0_.spotify_link AS spotify_link_9,
  m0_.sound_cloud_username AS sound_cloud_username_10,
  m0_.sound_cloud_link AS sound_cloud_link_11,
  m0_.tik_tok_username AS tik_tok_username_12,
  m0_.tik_tok_link AS tik_tok_link_13,
  m0_.imdb_link AS imdb_link_14,
  m0_.wikipedia_link AS wikipedia_link_15,
  m0_.approve_status AS approve_status_16,
  m0_.old_parents AS old_parents_17,
  m0_.thumbnail AS thumbnail_18,
  m0_.description AS description_19,
  m0_.short_description AS short_description_20,
  m0_.actual_publish_date AS actual_publish_date_21,
  m0_.youtube_username AS youtube_username_22,
  m0_.youtube_link AS youtube_link_23,
  m0_.instagram_username AS instagram_username_24,
  m0_.instagram_link AS instagram_link_25,
  m0_.twitter_username AS twitter_username_26,
  m0_.twitter_link AS twitter_link_27,
  m0_.facebook_username AS facebook_username_28,
  m0_.facebook_link AS facebook_link_29,
  m0_.website_link AS website_link_30,
  m0_.stripe_customer AS stripe_customer_31
FROM
  music_artist m0_
  LEFT JOIN music_artist_to_music_video m2_ ON m0_.id = m2_.music_artist_id
  LEFT JOIN music_video m1_ ON m1_.id = m2_.music_video_id
  AND (m1_.publish = 1)
  LEFT JOIN music_scene m3_ ON m1_.id = m3_.music_video_id
  AND (m3_.publish = 1)
  LEFT JOIN bind_music_video_scene_item_character b4_ ON (b4_.music_scene_id = m3_.id)
  LEFT JOIN music_video_set_category m5_ ON m1_.id = m5_.music_video_id
  AND (m5_.publish = 1)
  LEFT JOIN music_video_set m6_ ON m5_.id = m6_.music_video_set_category_id
  AND (m6_.publish = 1)
  LEFT JOIN bind_music_video_set_item b7_ ON (b7_.music_video_set_id = m6_.id)
  LEFT JOIN music_artist_character m8_ ON m0_.id = m8_.music_artist_id
  LEFT JOIN music_video_character m9_ ON m1_.id = m9_.music_video_id
  AND (m9_.artist_id = m8_.artist_id)
  LEFT JOIN music_video_character_signature m10_ ON m9_.id = m10_.character_id
  AND (m10_.publish = 1)
  LEFT JOIN bind_music_video_character_signature_item b11_ ON (
    b11_.music_video_character_signature_id = m10_.id
  )
  LEFT JOIN music_artist_posts m12_ ON m0_.id = m12_.music_artist_id
  AND (m12_.publish = 1)
  LEFT JOIN bind_music_artist_post_item_character b13_ ON (
    b13_.music_artist_character_id = m8_.id
    AND b13_.music_artist_post_id = m12_.id
  )
  LEFT JOIN music_artist_guest_character m14_ ON m0_.id = m14_.music_artist_id
  LEFT JOIN bind_music_artist_post_item_guest_character b15_ ON (
    b15_.music_artist_guest_character_id = m14_.id
    AND b15_.music_artist_post_id = m12_.id
  )
  LEFT JOIN music_artist_merch m16_ ON m0_.id = m16_.music_artist_id
  AND (m16_.publish = 1)
  LEFT JOIN bind_music_artist_merch b17_ ON (
    b17_.music_artist_merch_id = m16_.id
  )
WHERE
  (
    b4_.id IS NOT NULL
    OR b7_.id IS NOT NULL
    OR b11_.id IS NOT NULL
    OR b13_.id IS NOT NULL
    OR b15_.id IS NOT NULL
    OR b17_.id IS NOT NULL
  )
  AND m0_.publish = 1
GROUP BY
  m0_.name,
  m0_.publish,
  m0_.complete,
  m0_.updated,
  m0_.position,
  m0_.id,
  m0_.auto_mainstreet,
  m0_.commission,
  m0_.spotify_username,
  m0_.spotify_link,
  m0_.sound_cloud_username,
  m0_.sound_cloud_link,
  m0_.tik_tok_username,
  m0_.tik_tok_link,
  m0_.imdb_link,
  m0_.wikipedia_link,
  m0_.approve_status,
  m0_.old_parents,
  m0_.thumbnail,
  m0_.description,
  m0_.short_description,
  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
ORDER BY
  m0_.actual_publish_date DESC,
  m0_.position ASC

SELECT m0_.name AS name_0, m0_.publish AS publish_1, m0_.complete AS complete_2, m0_.updated AS updated_3, m0_.position AS position_4, m0_.id AS id_5, m0_.auto_mainstreet AS auto_mainstreet_6, m0_.commission AS commission_7, m0_.spotify_username AS spotify_username_8, m0_.spotify_link AS spotify_link_9, m0_.sound_cloud_username AS sound_cloud_username_10, m0_.sound_cloud_link AS sound_cloud_link_11, m0_.tik_tok_username AS tik_tok_username_12, m0_.tik_tok_link AS tik_tok_link_13, m0_.imdb_link AS imdb_link_14, m0_.wikipedia_link AS wikipedia_link_15, m0_.approve_status AS approve_status_16, m0_.old_parents AS old_parents_17, m0_.thumbnail AS thumbnail_18, m0_.description AS description_19, m0_.short_description AS short_description_20, m0_.actual_publish_date AS actual_publish_date_21, m0_.youtube_username AS youtube_username_22, m0_.youtube_link AS youtube_link_23, m0_.instagram_username AS instagram_username_24, m0_.instagram_link AS instagram_link_25, m0_.twitter_username AS twitter_username_26, m0_.twitter_link AS twitter_link_27, m0_.facebook_username AS facebook_username_28, m0_.facebook_link AS facebook_link_29, m0_.website_link AS website_link_30, m0_.stripe_customer AS stripe_customer_31 FROM music_artist m0_ LEFT JOIN music_artist_to_music_video m2_ ON m0_.id = m2_.music_artist_id LEFT JOIN music_video m1_ ON m1_.id = m2_.music_video_id AND (m1_.publish = 1) LEFT JOIN music_scene m3_ ON m1_.id = m3_.music_video_id AND (m3_.publish = 1) LEFT JOIN bind_music_video_scene_item_character b4_ ON (b4_.music_scene_id = m3_.id) LEFT JOIN music_video_set_category m5_ ON m1_.id = m5_.music_video_id AND (m5_.publish = 1) LEFT JOIN music_video_set m6_ ON m5_.id = m6_.music_video_set_category_id AND (m6_.publish = 1) LEFT JOIN bind_music_video_set_item b7_ ON (b7_.music_video_set_id = m6_.id) LEFT JOIN music_artist_character m8_ ON m0_.id = m8_.music_artist_id LEFT JOIN music_video_character m9_ ON m1_.id = m9_.music_video_id AND (m9_.artist_id = m8_.artist_id) LEFT JOIN music_video_character_signature m10_ ON m9_.id = m10_.character_id AND (m10_.publish = 1) LEFT JOIN bind_music_video_character_signature_item b11_ ON (b11_.music_video_character_signature_id = m10_.id) LEFT JOIN music_artist_posts m12_ ON m0_.id = m12_.music_artist_id AND (m12_.publish = 1) LEFT JOIN bind_music_artist_post_item_character b13_ ON (b13_.music_artist_character_id = m8_.id AND b13_.music_artist_post_id = m12_.id) LEFT JOIN music_artist_guest_character m14_ ON m0_.id = m14_.music_artist_id LEFT JOIN bind_music_artist_post_item_guest_character b15_ ON (b15_.music_artist_guest_character_id = m14_.id AND b15_.music_artist_post_id = m12_.id) LEFT JOIN music_artist_merch m16_ ON m0_.id = m16_.music_artist_id AND (m16_.publish = 1) LEFT JOIN bind_music_artist_merch b17_ ON (b17_.music_artist_merch_id = m16_.id) WHERE (b4_.id IS NOT NULL OR b7_.id IS NOT NULL OR b11_.id IS NOT NULL OR b13_.id IS NOT NULL OR b15_.id IS NOT NULL OR b17_.id IS NOT NULL) AND m0_.publish = 1 GROUP BY m0_.name, m0_.publish, m0_.complete, m0_.updated, m0_.position, m0_.id, m0_.auto_mainstreet, m0_.commission, m0_.spotify_username, m0_.spotify_link, m0_.sound_cloud_username, m0_.sound_cloud_link, m0_.tik_tok_username, m0_.tik_tok_link, m0_.imdb_link, m0_.wikipedia_link, m0_.approve_status, m0_.old_parents, m0_.thumbnail, m0_.description, m0_.short_description, 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 ORDER BY m0_.actual_publish_date DESC, m0_.position ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	Mirinly\AdminBundle\Entity\MusicArtistRepository->getNewlyAddedAndPublishedMusicArtists (line 76)
7	Mirinly\FrontBundle\Controller\MusicVideosController->indexAction (line 73)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 185)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

3.73 ms
(0.68%)

SELECT m0_.name AS name_0, m0_.publish AS publish_1, m0_.complete AS complete_2, m0_.updated AS updated_3, m0_.position AS position_4, m0_.id AS id_5, m0_.auto_mainstreet AS auto_mainstreet_6, m0_.commission AS commission_7, m0_.spotify_username AS spotify_username_8, m0_.spotify_link AS spotify_link_9, m0_.sound_cloud_username AS sound_cloud_username_10, m0_.sound_cloud_link AS sound_cloud_link_11, m0_.tik_tok_username AS tik_tok_username_12, m0_.tik_tok_link AS tik_tok_link_13, m0_.imdb_link AS imdb_link_14, m0_.wikipedia_link AS wikipedia_link_15, m0_.approve_status AS approve_status_16, m0_.old_parents AS old_parents_17, m0_.thumbnail AS thumbnail_18, m0_.description AS description_19, m0_.short_description AS short_description_20, m0_.actual_publish_date AS actual_publish_date_21, m0_.youtube_username AS youtube_username_22, m0_.youtube_link AS youtube_link_23, m0_.instagram_username AS instagram_username_24, m0_.instagram_link AS instagram_link_25, m0_.twitter_username AS twitter_username_26, m0_.twitter_link AS twitter_link_27, m0_.facebook_username AS facebook_username_28, m0_.facebook_link AS facebook_link_29, m0_.website_link AS website_link_30, m0_.stripe_customer AS stripe_customer_31 FROM music_artist m0_ LEFT JOIN music_artist_to_music_video m2_ ON m0_.id = m2_.music_artist_id LEFT JOIN music_video m1_ ON m1_.id = m2_.music_video_id AND (m1_.publish = 1) LEFT JOIN music_scene m3_ ON m1_.id = m3_.music_video_id AND (m3_.publish = 1) LEFT JOIN bind_music_video_scene_item_character b4_ ON (b4_.music_scene_id = m3_.id) LEFT JOIN music_video_set_category m5_ ON m1_.id = m5_.music_video_id AND (m5_.publish = 1) LEFT JOIN music_video_set m6_ ON m5_.id = m6_.music_video_set_category_id AND (m6_.publish = 1) LEFT JOIN bind_music_video_set_item b7_ ON (b7_.music_video_set_id = m6_.id) LEFT JOIN music_artist_character m8_ ON m0_.id = m8_.music_artist_id LEFT JOIN music_video_character m9_ ON m1_.id = m9_.music_video_id AND (m9_.artist_id = m8_.artist_id) LEFT JOIN music_video_character_signature m10_ ON m9_.id = m10_.character_id AND (m10_.publish = 1) LEFT JOIN bind_music_video_character_signature_item b11_ ON (b11_.music_video_character_signature_id = m10_.id) LEFT JOIN music_artist_posts m12_ ON m0_.id = m12_.music_artist_id AND (m12_.publish = 1) LEFT JOIN bind_music_artist_post_item_character b13_ ON (b13_.music_artist_character_id = m8_.id AND b13_.music_artist_post_id = m12_.id) LEFT JOIN music_artist_guest_character m14_ ON m0_.id = m14_.music_artist_id LEFT JOIN bind_music_artist_post_item_guest_character b15_ ON (b15_.music_artist_guest_character_id = m14_.id AND b15_.music_artist_post_id = m12_.id) LEFT JOIN music_artist_merch m16_ ON m0_.id = m16_.music_artist_id AND (m16_.publish = 1) LEFT JOIN bind_music_artist_merch b17_ ON (b17_.music_artist_merch_id = m16_.id) WHERE (b4_.id IS NOT NULL OR b7_.id IS NOT NULL OR b11_.id IS NOT NULL OR b13_.id IS NOT NULL OR b15_.id IS NOT NULL OR b17_.id IS NOT NULL) AND m0_.publish = 1 GROUP BY m0_.name, m0_.publish, m0_.complete, m0_.updated, m0_.position, m0_.id, m0_.auto_mainstreet, m0_.commission, m0_.spotify_username, m0_.spotify_link, m0_.sound_cloud_username, m0_.sound_cloud_link, m0_.tik_tok_username, m0_.tik_tok_link, m0_.imdb_link, m0_.wikipedia_link, m0_.approve_status, m0_.old_parents, m0_.thumbnail, m0_.description, m0_.short_description, 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 ORDER BY m0_.name ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.name AS name_0,
  m0_.publish AS publish_1,
  m0_.complete AS complete_2,
  m0_.updated AS updated_3,
  m0_.position AS position_4,
  m0_.id AS id_5,
  m0_.auto_mainstreet AS auto_mainstreet_6,
  m0_.commission AS commission_7,
  m0_.spotify_username AS spotify_username_8,
  m0_.spotify_link AS spotify_link_9,
  m0_.sound_cloud_username AS sound_cloud_username_10,
  m0_.sound_cloud_link AS sound_cloud_link_11,
  m0_.tik_tok_username AS tik_tok_username_12,
  m0_.tik_tok_link AS tik_tok_link_13,
  m0_.imdb_link AS imdb_link_14,
  m0_.wikipedia_link AS wikipedia_link_15,
  m0_.approve_status AS approve_status_16,
  m0_.old_parents AS old_parents_17,
  m0_.thumbnail AS thumbnail_18,
  m0_.description AS description_19,
  m0_.short_description AS short_description_20,
  m0_.actual_publish_date AS actual_publish_date_21,
  m0_.youtube_username AS youtube_username_22,
  m0_.youtube_link AS youtube_link_23,
  m0_.instagram_username AS instagram_username_24,
  m0_.instagram_link AS instagram_link_25,
  m0_.twitter_username AS twitter_username_26,
  m0_.twitter_link AS twitter_link_27,
  m0_.facebook_username AS facebook_username_28,
  m0_.facebook_link AS facebook_link_29,
  m0_.website_link AS website_link_30,
  m0_.stripe_customer AS stripe_customer_31
FROM
  music_artist m0_
  LEFT JOIN music_artist_to_music_video m2_ ON m0_.id = m2_.music_artist_id
  LEFT JOIN music_video m1_ ON m1_.id = m2_.music_video_id
  AND (m1_.publish = 1)
  LEFT JOIN music_scene m3_ ON m1_.id = m3_.music_video_id
  AND (m3_.publish = 1)
  LEFT JOIN bind_music_video_scene_item_character b4_ ON (b4_.music_scene_id = m3_.id)
  LEFT JOIN music_video_set_category m5_ ON m1_.id = m5_.music_video_id
  AND (m5_.publish = 1)
  LEFT JOIN music_video_set m6_ ON m5_.id = m6_.music_video_set_category_id
  AND (m6_.publish = 1)
  LEFT JOIN bind_music_video_set_item b7_ ON (b7_.music_video_set_id = m6_.id)
  LEFT JOIN music_artist_character m8_ ON m0_.id = m8_.music_artist_id
  LEFT JOIN music_video_character m9_ ON m1_.id = m9_.music_video_id
  AND (m9_.artist_id = m8_.artist_id)
  LEFT JOIN music_video_character_signature m10_ ON m9_.id = m10_.character_id
  AND (m10_.publish = 1)
  LEFT JOIN bind_music_video_character_signature_item b11_ ON (
    b11_.music_video_character_signature_id = m10_.id
  )
  LEFT JOIN music_artist_posts m12_ ON m0_.id = m12_.music_artist_id
  AND (m12_.publish = 1)
  LEFT JOIN bind_music_artist_post_item_character b13_ ON (
    b13_.music_artist_character_id = m8_.id
    AND b13_.music_artist_post_id = m12_.id
  )
  LEFT JOIN music_artist_guest_character m14_ ON m0_.id = m14_.music_artist_id
  LEFT JOIN bind_music_artist_post_item_guest_character b15_ ON (
    b15_.music_artist_guest_character_id = m14_.id
    AND b15_.music_artist_post_id = m12_.id
  )
  LEFT JOIN music_artist_merch m16_ ON m0_.id = m16_.music_artist_id
  AND (m16_.publish = 1)
  LEFT JOIN bind_music_artist_merch b17_ ON (
    b17_.music_artist_merch_id = m16_.id
  )
WHERE
  (
    b4_.id IS NOT NULL
    OR b7_.id IS NOT NULL
    OR b11_.id IS NOT NULL
    OR b13_.id IS NOT NULL
    OR b15_.id IS NOT NULL
    OR b17_.id IS NOT NULL
  )
  AND m0_.publish = 1
GROUP BY
  m0_.name,
  m0_.publish,
  m0_.complete,
  m0_.updated,
  m0_.position,
  m0_.id,
  m0_.auto_mainstreet,
  m0_.commission,
  m0_.spotify_username,
  m0_.spotify_link,
  m0_.sound_cloud_username,
  m0_.sound_cloud_link,
  m0_.tik_tok_username,
  m0_.tik_tok_link,
  m0_.imdb_link,
  m0_.wikipedia_link,
  m0_.approve_status,
  m0_.old_parents,
  m0_.thumbnail,
  m0_.description,
  m0_.short_description,
  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
ORDER BY
  m0_.name ASC

SELECT m0_.name AS name_0, m0_.publish AS publish_1, m0_.complete AS complete_2, m0_.updated AS updated_3, m0_.position AS position_4, m0_.id AS id_5, m0_.auto_mainstreet AS auto_mainstreet_6, m0_.commission AS commission_7, m0_.spotify_username AS spotify_username_8, m0_.spotify_link AS spotify_link_9, m0_.sound_cloud_username AS sound_cloud_username_10, m0_.sound_cloud_link AS sound_cloud_link_11, m0_.tik_tok_username AS tik_tok_username_12, m0_.tik_tok_link AS tik_tok_link_13, m0_.imdb_link AS imdb_link_14, m0_.wikipedia_link AS wikipedia_link_15, m0_.approve_status AS approve_status_16, m0_.old_parents AS old_parents_17, m0_.thumbnail AS thumbnail_18, m0_.description AS description_19, m0_.short_description AS short_description_20, m0_.actual_publish_date AS actual_publish_date_21, m0_.youtube_username AS youtube_username_22, m0_.youtube_link AS youtube_link_23, m0_.instagram_username AS instagram_username_24, m0_.instagram_link AS instagram_link_25, m0_.twitter_username AS twitter_username_26, m0_.twitter_link AS twitter_link_27, m0_.facebook_username AS facebook_username_28, m0_.facebook_link AS facebook_link_29, m0_.website_link AS website_link_30, m0_.stripe_customer AS stripe_customer_31 FROM music_artist m0_ LEFT JOIN music_artist_to_music_video m2_ ON m0_.id = m2_.music_artist_id LEFT JOIN music_video m1_ ON m1_.id = m2_.music_video_id AND (m1_.publish = 1) LEFT JOIN music_scene m3_ ON m1_.id = m3_.music_video_id AND (m3_.publish = 1) LEFT JOIN bind_music_video_scene_item_character b4_ ON (b4_.music_scene_id = m3_.id) LEFT JOIN music_video_set_category m5_ ON m1_.id = m5_.music_video_id AND (m5_.publish = 1) LEFT JOIN music_video_set m6_ ON m5_.id = m6_.music_video_set_category_id AND (m6_.publish = 1) LEFT JOIN bind_music_video_set_item b7_ ON (b7_.music_video_set_id = m6_.id) LEFT JOIN music_artist_character m8_ ON m0_.id = m8_.music_artist_id LEFT JOIN music_video_character m9_ ON m1_.id = m9_.music_video_id AND (m9_.artist_id = m8_.artist_id) LEFT JOIN music_video_character_signature m10_ ON m9_.id = m10_.character_id AND (m10_.publish = 1) LEFT JOIN bind_music_video_character_signature_item b11_ ON (b11_.music_video_character_signature_id = m10_.id) LEFT JOIN music_artist_posts m12_ ON m0_.id = m12_.music_artist_id AND (m12_.publish = 1) LEFT JOIN bind_music_artist_post_item_character b13_ ON (b13_.music_artist_character_id = m8_.id AND b13_.music_artist_post_id = m12_.id) LEFT JOIN music_artist_guest_character m14_ ON m0_.id = m14_.music_artist_id LEFT JOIN bind_music_artist_post_item_guest_character b15_ ON (b15_.music_artist_guest_character_id = m14_.id AND b15_.music_artist_post_id = m12_.id) LEFT JOIN music_artist_merch m16_ ON m0_.id = m16_.music_artist_id AND (m16_.publish = 1) LEFT JOIN bind_music_artist_merch b17_ ON (b17_.music_artist_merch_id = m16_.id) WHERE (b4_.id IS NOT NULL OR b7_.id IS NOT NULL OR b11_.id IS NOT NULL OR b13_.id IS NOT NULL OR b15_.id IS NOT NULL OR b17_.id IS NOT NULL) AND m0_.publish = 1 GROUP BY m0_.name, m0_.publish, m0_.complete, m0_.updated, m0_.position, m0_.id, m0_.auto_mainstreet, m0_.commission, m0_.spotify_username, m0_.spotify_link, m0_.sound_cloud_username, m0_.sound_cloud_link, m0_.tik_tok_username, m0_.tik_tok_link, m0_.imdb_link, m0_.wikipedia_link, m0_.approve_status, m0_.old_parents, m0_.thumbnail, m0_.description, m0_.short_description, 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 ORDER BY m0_.name ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	Mirinly\AdminBundle\Entity\MusicArtistRepository->getPublishedAndNotEmptyMusicArtistsOrderByName (line 61)
7	Mirinly\FrontBundle\Controller\MusicVideosController->getDirectories (line 2399)
8	Mirinly\FrontBundle\Controller\MusicVideosController->indexAction (line 79)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 185)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

1.12 ms
(0.20%)

SELECT t0.thumbnail AS thumbnail_1, t0.position AS position_2, t0.updated AS updated_3, t0.name AS name_4, t0.description AS description_5, t0.id AS id_6, t0.actual_publish_date AS actual_publish_date_7, t0.music_artist_id AS music_artist_id_8, t0.music_performer_id AS music_performer_id_9, t0.artist_id AS artist_id_10, t0.image_to_music_artist_id AS image_to_music_artist_id_11 FROM music_artist_character t0 WHERE t0.id = ?

Parameters:

[
  5
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.thumbnail AS thumbnail_1,
  t0.position AS position_2,
  t0.updated AS updated_3,
  t0.name AS name_4,
  t0.description AS description_5,
  t0.id AS id_6,
  t0.actual_publish_date AS actual_publish_date_7,
  t0.music_artist_id AS music_artist_id_8,
  t0.music_performer_id AS music_performer_id_9,
  t0.artist_id AS artist_id_10,
  t0.image_to_music_artist_id AS image_to_music_artist_id_11
FROM
  music_artist_character t0
WHERE
  t0.id = ?

SELECT t0.thumbnail AS thumbnail_1, t0.position AS position_2, t0.updated AS updated_3, t0.name AS name_4, t0.description AS description_5, t0.id AS id_6, t0.actual_publish_date AS actual_publish_date_7, t0.music_artist_id AS music_artist_id_8, t0.music_performer_id AS music_performer_id_9, t0.artist_id AS artist_id_10, t0.image_to_music_artist_id AS image_to_music_artist_id_11 FROM music_artist_character t0 WHERE t0.id = 5;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 295)
4	Proxies\__CG__\Mirinly\AdminBundle\Entity\MusicArtistCharacter::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 61)
6	Proxies\__CG__\Mirinly\AdminBundle\Entity\MusicArtistCharacter->__get (line 120)
7	Mirinly\AdminBundle\Entity\MusicArtistCharacter->getName (line 40)
8	Twig\Extension\CoreExtension->getAttribute (line 1911)
9	__TwigTemplate_e3b5cf7791afca8dd346b08e0dcda643::block_content (line 416)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_3a8022cedc3a177a8d05e322c8e823dd->doDisplay (line 231)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_e3b5cf7791afca8dd346b08e0dcda643->doDisplay (line 54)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
22	Mirinly\FrontBundle\Controller\MusicVideosController->indexAction (line 167)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 185)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

1.08 ms
(0.20%)

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 INNER JOIN music_artist_to_music_video ON t0.id = music_artist_to_music_video.music_artist_id WHERE music_artist_to_music_video.music_video_id = ?

Parameters:

[
  13
]

View formatted query View runnable query Explain query View query backtrace

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
  INNER JOIN music_artist_to_music_video ON t0.id = music_artist_to_music_video.music_artist_id
WHERE
  music_artist_to_music_video.music_video_id = ?

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 INNER JOIN music_artist_to_music_video ON t0.id = music_artist_to_music_video.music_artist_id WHERE music_artist_to_music_video.music_video_id = 13;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
7	__TwigTemplate_e3b5cf7791afca8dd346b08e0dcda643->block_content (line 221)
8	Twig\Template->yieldBlock (line 446)
9	__TwigTemplate_3a8022cedc3a177a8d05e322c8e823dd->doDisplay (line 231)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_e3b5cf7791afca8dd346b08e0dcda643->doDisplay (line 54)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
20	Mirinly\FrontBundle\Controller\MusicVideosController->indexAction (line 167)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 185)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	require_once (line 5)

1.07 ms
(0.19%)

SELECT t0.name AS name_1, t0.thumbnail AS thumbnail_2, t0.short_description AS short_description_3, t0.description AS description_4, t0.release_date AS release_date_5, t0.publish AS publish_6, t0.complete AS complete_7, t0.updated AS updated_8, t0.position AS position_9, t0.id AS id_10, t0.auto_mainstreet AS auto_mainstreet_11, t0.commission AS commission_12, t0.contact_name AS contact_name_13, t0.email AS email_14, t0.video_link AS video_link_15, t0.spotify_username AS spotify_username_16, t0.spotify_link AS spotify_link_17, t0.sound_cloud_username AS sound_cloud_username_18, t0.sound_cloud_link AS sound_cloud_link_19, t0.tik_tok_username AS tik_tok_username_20, t0.tik_tok_link AS tik_tok_link_21, t0.approve_status AS approve_status_22, t0.old_parents AS old_parents_23, t0.publish_date AS publish_date_24, t0.actual_publish_date AS actual_publish_date_25, t0.youtube_username AS youtube_username_26, t0.youtube_link AS youtube_link_27, t0.instagram_username AS instagram_username_28, t0.instagram_link AS instagram_link_29, t0.twitter_username AS twitter_username_30, t0.twitter_link AS twitter_link_31, t0.facebook_username AS facebook_username_32, t0.facebook_link AS facebook_link_33, t0.website_link AS website_link_34, t0.stripe_customer AS stripe_customer_35, t0.season_id AS season_id_36 FROM music_video t0 WHERE t0.id = ?

Parameters:

[
  9
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.thumbnail AS thumbnail_2,
  t0.short_description AS short_description_3,
  t0.description AS description_4,
  t0.release_date AS release_date_5,
  t0.publish AS publish_6,
  t0.complete AS complete_7,
  t0.updated AS updated_8,
  t0.position AS position_9,
  t0.id AS id_10,
  t0.auto_mainstreet AS auto_mainstreet_11,
  t0.commission AS commission_12,
  t0.contact_name AS contact_name_13,
  t0.email AS email_14,
  t0.video_link AS video_link_15,
  t0.spotify_username AS spotify_username_16,
  t0.spotify_link AS spotify_link_17,
  t0.sound_cloud_username AS sound_cloud_username_18,
  t0.sound_cloud_link AS sound_cloud_link_19,
  t0.tik_tok_username AS tik_tok_username_20,
  t0.tik_tok_link AS tik_tok_link_21,
  t0.approve_status AS approve_status_22,
  t0.old_parents AS old_parents_23,
  t0.publish_date AS publish_date_24,
  t0.actual_publish_date AS actual_publish_date_25,
  t0.youtube_username AS youtube_username_26,
  t0.youtube_link AS youtube_link_27,
  t0.instagram_username AS instagram_username_28,
  t0.instagram_link AS instagram_link_29,
  t0.twitter_username AS twitter_username_30,
  t0.twitter_link AS twitter_link_31,
  t0.facebook_username AS facebook_username_32,
  t0.facebook_link AS facebook_link_33,
  t0.website_link AS website_link_34,
  t0.stripe_customer AS stripe_customer_35,
  t0.season_id AS season_id_36
FROM
  music_video t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.thumbnail AS thumbnail_2, t0.short_description AS short_description_3, t0.description AS description_4, t0.release_date AS release_date_5, t0.publish AS publish_6, t0.complete AS complete_7, t0.updated AS updated_8, t0.position AS position_9, t0.id AS id_10, t0.auto_mainstreet AS auto_mainstreet_11, t0.commission AS commission_12, t0.contact_name AS contact_name_13, t0.email AS email_14, t0.video_link AS video_link_15, t0.spotify_username AS spotify_username_16, t0.spotify_link AS spotify_link_17, t0.sound_cloud_username AS sound_cloud_username_18, t0.sound_cloud_link AS sound_cloud_link_19, t0.tik_tok_username AS tik_tok_username_20, t0.tik_tok_link AS tik_tok_link_21, t0.approve_status AS approve_status_22, t0.old_parents AS old_parents_23, t0.publish_date AS publish_date_24, t0.actual_publish_date AS actual_publish_date_25, t0.youtube_username AS youtube_username_26, t0.youtube_link AS youtube_link_27, t0.instagram_username AS instagram_username_28, t0.instagram_link AS instagram_link_29, t0.twitter_username AS twitter_username_30, t0.twitter_link AS twitter_link_31, t0.facebook_username AS facebook_username_32, t0.facebook_link AS facebook_link_33, t0.website_link AS website_link_34, t0.stripe_customer AS stripe_customer_35, t0.season_id AS season_id_36 FROM music_video t0 WHERE t0.id = 9;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 295)
4	Proxies\__CG__\Mirinly\AdminBundle\Entity\MusicVideo::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 61)
6	Proxies\__CG__\Mirinly\AdminBundle\Entity\MusicVideo->__get (line 120)
7	Mirinly\AdminBundle\Entity\MusicVideo->getName (line 468)
8	Twig\Extension\CoreExtension->getAttribute (line 1911)
9	__TwigTemplate_e3b5cf7791afca8dd346b08e0dcda643::block_content (line 377)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_3a8022cedc3a177a8d05e322c8e823dd->doDisplay (line 231)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_e3b5cf7791afca8dd346b08e0dcda643->doDisplay (line 54)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
22	Mirinly\FrontBundle\Controller\MusicVideosController->indexAction (line 167)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 185)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

1.00 ms
(0.18%)

SELECT r0_.name AS name_0, r0_.publish AS publish_1, r0_.complete AS complete_2, r0_.position AS position_3, r0_.id AS id_4, r0_.spotify_username AS spotify_username_5, r0_.spotify_link AS spotify_link_6, r0_.sound_cloud_username AS sound_cloud_username_7, r0_.sound_cloud_link AS sound_cloud_link_8, r0_.tik_tok_username AS tik_tok_username_9, r0_.tik_tok_link AS tik_tok_link_10, r0_.wikipedia_link AS wikipedia_link_11, r0_.thumbnail AS thumbnail_12, r0_.actual_publish_date AS actual_publish_date_13, r0_.youtube_username AS youtube_username_14, r0_.youtube_link AS youtube_link_15, r0_.instagram_username AS instagram_username_16, r0_.instagram_link AS instagram_link_17, r0_.twitter_username AS twitter_username_18, r0_.twitter_link AS twitter_link_19, r0_.facebook_username AS facebook_username_20, r0_.facebook_link AS facebook_link_21, r0_.website_link AS website_link_22 FROM record_label r0_ LEFT JOIN record_label_approve_music_artist r2_ ON r0_.id = r2_.record_label_id LEFT JOIN music_artist m1_ ON m1_.id = r2_.music_artist_id AND (m1_.publish = 1) LEFT JOIN record_label_to_music_artist_merch r4_ ON r0_.id = r4_.record_label_id LEFT JOIN music_artist m3_ ON m3_.id = r4_.music_artist_id AND (m3_.publish = 1) LEFT JOIN music_artist_merch m5_ ON m3_.id = m5_.music_artist_id AND (m5_.publish = 1) LEFT JOIN bind_music_artist_merch b6_ ON (b6_.music_artist_merch_id = m5_.id) LEFT JOIN record_label_to_music_artist_post r8_ ON r0_.id = r8_.record_label_id LEFT JOIN music_artist m7_ ON m7_.id = r8_.music_artist_id AND (m7_.publish = 1) LEFT JOIN music_artist_character m9_ ON m7_.id = m9_.music_artist_id LEFT JOIN music_artist_posts m10_ ON m7_.id = m10_.music_artist_id AND (m10_.publish = 1) LEFT JOIN bind_music_artist_post_item_character b11_ ON (b11_.music_artist_character_id = m9_.id AND b11_.music_artist_post_id = m10_.id) LEFT JOIN record_label_merch r12_ ON r0_.id = r12_.record_label_id AND (r12_.publish = 1) LEFT JOIN bind_record_label_merch b13_ ON (b13_.record_label_merch_id = r12_.id) LEFT JOIN record_label_posts r14_ ON r0_.id = r14_.record_label_id AND (r14_.publish = 1) LEFT JOIN bind_record_label_post_item_artist_character b15_ ON (b15_.record_label_post_id = r14_.id) WHERE (m1_.id IS NOT NULL OR b6_.id IS NOT NULL OR b11_.id IS NOT NULL OR b13_.id IS NOT NULL OR b15_.id IS NOT NULL) AND r0_.publish = 1 GROUP BY r0_.name, r0_.publish, r0_.complete, r0_.position, r0_.id, r0_.spotify_username, r0_.spotify_link, r0_.sound_cloud_username, r0_.sound_cloud_link, r0_.tik_tok_username, r0_.tik_tok_link, r0_.wikipedia_link, r0_.thumbnail, r0_.actual_publish_date, r0_.youtube_username, r0_.youtube_link, r0_.instagram_username, r0_.instagram_link, r0_.twitter_username, r0_.twitter_link, r0_.facebook_username, r0_.facebook_link, r0_.website_link ORDER BY r0_.name ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  r0_.name AS name_0,
  r0_.publish AS publish_1,
  r0_.complete AS complete_2,
  r0_.position AS position_3,
  r0_.id AS id_4,
  r0_.spotify_username AS spotify_username_5,
  r0_.spotify_link AS spotify_link_6,
  r0_.sound_cloud_username AS sound_cloud_username_7,
  r0_.sound_cloud_link AS sound_cloud_link_8,
  r0_.tik_tok_username AS tik_tok_username_9,
  r0_.tik_tok_link AS tik_tok_link_10,
  r0_.wikipedia_link AS wikipedia_link_11,
  r0_.thumbnail AS thumbnail_12,
  r0_.actual_publish_date AS actual_publish_date_13,
  r0_.youtube_username AS youtube_username_14,
  r0_.youtube_link AS youtube_link_15,
  r0_.instagram_username AS instagram_username_16,
  r0_.instagram_link AS instagram_link_17,
  r0_.twitter_username AS twitter_username_18,
  r0_.twitter_link AS twitter_link_19,
  r0_.facebook_username AS facebook_username_20,
  r0_.facebook_link AS facebook_link_21,
  r0_.website_link AS website_link_22
FROM
  record_label r0_
  LEFT JOIN record_label_approve_music_artist r2_ ON r0_.id = r2_.record_label_id
  LEFT JOIN music_artist m1_ ON m1_.id = r2_.music_artist_id
  AND (m1_.publish = 1)
  LEFT JOIN record_label_to_music_artist_merch r4_ ON r0_.id = r4_.record_label_id
  LEFT JOIN music_artist m3_ ON m3_.id = r4_.music_artist_id
  AND (m3_.publish = 1)
  LEFT JOIN music_artist_merch m5_ ON m3_.id = m5_.music_artist_id
  AND (m5_.publish = 1)
  LEFT JOIN bind_music_artist_merch b6_ ON (
    b6_.music_artist_merch_id = m5_.id
  )
  LEFT JOIN record_label_to_music_artist_post r8_ ON r0_.id = r8_.record_label_id
  LEFT JOIN music_artist m7_ ON m7_.id = r8_.music_artist_id
  AND (m7_.publish = 1)
  LEFT JOIN music_artist_character m9_ ON m7_.id = m9_.music_artist_id
  LEFT JOIN music_artist_posts m10_ ON m7_.id = m10_.music_artist_id
  AND (m10_.publish = 1)
  LEFT JOIN bind_music_artist_post_item_character b11_ ON (
    b11_.music_artist_character_id = m9_.id
    AND b11_.music_artist_post_id = m10_.id
  )
  LEFT JOIN record_label_merch r12_ ON r0_.id = r12_.record_label_id
  AND (r12_.publish = 1)
  LEFT JOIN bind_record_label_merch b13_ ON (
    b13_.record_label_merch_id = r12_.id
  )
  LEFT JOIN record_label_posts r14_ ON r0_.id = r14_.record_label_id
  AND (r14_.publish = 1)
  LEFT JOIN bind_record_label_post_item_artist_character b15_ ON (
    b15_.record_label_post_id = r14_.id
  )
WHERE
  (
    m1_.id IS NOT NULL
    OR b6_.id IS NOT NULL
    OR b11_.id IS NOT NULL
    OR b13_.id IS NOT NULL
    OR b15_.id IS NOT NULL
  )
  AND r0_.publish = 1
GROUP BY
  r0_.name,
  r0_.publish,
  r0_.complete,
  r0_.position,
  r0_.id,
  r0_.spotify_username,
  r0_.spotify_link,
  r0_.sound_cloud_username,
  r0_.sound_cloud_link,
  r0_.tik_tok_username,
  r0_.tik_tok_link,
  r0_.wikipedia_link,
  r0_.thumbnail,
  r0_.actual_publish_date,
  r0_.youtube_username,
  r0_.youtube_link,
  r0_.instagram_username,
  r0_.instagram_link,
  r0_.twitter_username,
  r0_.twitter_link,
  r0_.facebook_username,
  r0_.facebook_link,
  r0_.website_link
ORDER BY
  r0_.name ASC

SELECT r0_.name AS name_0, r0_.publish AS publish_1, r0_.complete AS complete_2, r0_.position AS position_3, r0_.id AS id_4, r0_.spotify_username AS spotify_username_5, r0_.spotify_link AS spotify_link_6, r0_.sound_cloud_username AS sound_cloud_username_7, r0_.sound_cloud_link AS sound_cloud_link_8, r0_.tik_tok_username AS tik_tok_username_9, r0_.tik_tok_link AS tik_tok_link_10, r0_.wikipedia_link AS wikipedia_link_11, r0_.thumbnail AS thumbnail_12, r0_.actual_publish_date AS actual_publish_date_13, r0_.youtube_username AS youtube_username_14, r0_.youtube_link AS youtube_link_15, r0_.instagram_username AS instagram_username_16, r0_.instagram_link AS instagram_link_17, r0_.twitter_username AS twitter_username_18, r0_.twitter_link AS twitter_link_19, r0_.facebook_username AS facebook_username_20, r0_.facebook_link AS facebook_link_21, r0_.website_link AS website_link_22 FROM record_label r0_ LEFT JOIN record_label_approve_music_artist r2_ ON r0_.id = r2_.record_label_id LEFT JOIN music_artist m1_ ON m1_.id = r2_.music_artist_id AND (m1_.publish = 1) LEFT JOIN record_label_to_music_artist_merch r4_ ON r0_.id = r4_.record_label_id LEFT JOIN music_artist m3_ ON m3_.id = r4_.music_artist_id AND (m3_.publish = 1) LEFT JOIN music_artist_merch m5_ ON m3_.id = m5_.music_artist_id AND (m5_.publish = 1) LEFT JOIN bind_music_artist_merch b6_ ON (b6_.music_artist_merch_id = m5_.id) LEFT JOIN record_label_to_music_artist_post r8_ ON r0_.id = r8_.record_label_id LEFT JOIN music_artist m7_ ON m7_.id = r8_.music_artist_id AND (m7_.publish = 1) LEFT JOIN music_artist_character m9_ ON m7_.id = m9_.music_artist_id LEFT JOIN music_artist_posts m10_ ON m7_.id = m10_.music_artist_id AND (m10_.publish = 1) LEFT JOIN bind_music_artist_post_item_character b11_ ON (b11_.music_artist_character_id = m9_.id AND b11_.music_artist_post_id = m10_.id) LEFT JOIN record_label_merch r12_ ON r0_.id = r12_.record_label_id AND (r12_.publish = 1) LEFT JOIN bind_record_label_merch b13_ ON (b13_.record_label_merch_id = r12_.id) LEFT JOIN record_label_posts r14_ ON r0_.id = r14_.record_label_id AND (r14_.publish = 1) LEFT JOIN bind_record_label_post_item_artist_character b15_ ON (b15_.record_label_post_id = r14_.id) WHERE (m1_.id IS NOT NULL OR b6_.id IS NOT NULL OR b11_.id IS NOT NULL OR b13_.id IS NOT NULL OR b15_.id IS NOT NULL) AND r0_.publish = 1 GROUP BY r0_.name, r0_.publish, r0_.complete, r0_.position, r0_.id, r0_.spotify_username, r0_.spotify_link, r0_.sound_cloud_username, r0_.sound_cloud_link, r0_.tik_tok_username, r0_.tik_tok_link, r0_.wikipedia_link, r0_.thumbnail, r0_.actual_publish_date, r0_.youtube_username, r0_.youtube_link, r0_.instagram_username, r0_.instagram_link, r0_.twitter_username, r0_.twitter_link, r0_.facebook_username, r0_.facebook_link, r0_.website_link ORDER BY r0_.name ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	Mirinly\AdminBundle\Entity\RecordLabelRepository->getPublishedAndNotEmptyRecordLabelsOrderByName (line 56)
7	Mirinly\FrontBundle\Controller\MusicVideosController->getDirectories (line 2404)
8	Mirinly\FrontBundle\Controller\MusicVideosController->indexAction (line 79)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 185)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

0.88 ms
(0.16%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.text AS text_3, t0.section AS section_4, t0.page AS page_5, t0.position AS position_6 FROM page t0 WHERE t0.section = ? ORDER BY t0.position ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.text AS text_3,
  t0.section AS section_4,
  t0.page AS page_5,
  t0.position AS position_6
FROM
  page t0
WHERE
  t0.section = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.text AS text_3, t0.section AS section_4, t0.page AS page_5, t0.position AS position_6 FROM page t0 WHERE t0.section = 1 ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Mirinly\FrontBundle\Controller\PageController->listLinksAction (line 51)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
7	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 78)
8	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
9	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 47)
10	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 44)
11	__TwigTemplate_3a8022cedc3a177a8d05e322c8e823dd->doDisplay (line 238)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_e3b5cf7791afca8dd346b08e0dcda643->doDisplay (line 54)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
22	Mirinly\FrontBundle\Controller\MusicVideosController->indexAction (line 167)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 185)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

0.80 ms
(0.14%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Mirinly\AdminBundle\Entity\CountryRepository->findAll (line 18)
4	Mirinly\FrontBundle\Controller\HomeController->userWelcomeAction (line 396)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
8	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 78)
9	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
10	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 47)
11	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 44)
12	__TwigTemplate_3a8022cedc3a177a8d05e322c8e823dd->doDisplay (line 192)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_e3b5cf7791afca8dd346b08e0dcda643->doDisplay (line 54)
15	Twig\Template->yield (line 402)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 373)
18	Twig\TemplateWrapper->render (line 51)
19	Twig\Environment->render (line 333)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
23	Mirinly\FrontBundle\Controller\MusicVideosController->indexAction (line 167)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 185)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 29)
29	require_once (line 5)

0.51 ms
(0.09%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\ORM\EntityRepository->findAll (line 96)
4	Mirinly\FrontBundle\Controller\HomeController->userWelcomeAction (line 393)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
8	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 78)
9	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
10	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 47)
11	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 44)
12	__TwigTemplate_3a8022cedc3a177a8d05e322c8e823dd->doDisplay (line 192)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_e3b5cf7791afca8dd346b08e0dcda643->doDisplay (line 54)
15	Twig\Template->yield (line 402)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 373)
18	Twig\TemplateWrapper->render (line 51)
19	Twig\Environment->render (line 333)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
23	Mirinly\FrontBundle\Controller\MusicVideosController->indexAction (line 167)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 185)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 29)
29	require_once (line 5)

0.41 ms
(0.07%)

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

Parameters:

[
  "US"
]

View formatted query View runnable query Explain query View query backtrace

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;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Mirinly\FrontBundle\Controller\HomeController->userWelcomeAction (line 397)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
7	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 78)
8	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
9	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 47)
10	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 44)
11	__TwigTemplate_3a8022cedc3a177a8d05e322c8e823dd->doDisplay (line 192)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_e3b5cf7791afca8dd346b08e0dcda643->doDisplay (line 54)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
22	Mirinly\FrontBundle\Controller\MusicVideosController->indexAction (line 167)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 185)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

0.33 ms
(0.06%)

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

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

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 = 3 AND c0_.thumbnail IS NOT NULL ORDER BY c0_.position ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	Mirinly\AdminBundle\Entity\CustomSliderRepository->getSlidesByTypePage (line 17)
7	Mirinly\FrontBundle\Controller\MusicVideosController->indexAction (line 77)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 185)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

0.28 ms
(0.05%)

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 = ?

Parameters:

[
  "disable_menu_item"
  1
]

View formatted query View runnable query Explain query View query backtrace

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;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	Mirinly\AdminBundle\Entity\ParametersRepository->getDisabledMenuItems (line 21)
7	Mirinly\FrontBundle\Controller\HomeController->mainMenuAction (line 2235)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
11	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 78)
12	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
13	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 47)
14	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 44)
15	__TwigTemplate_3a8022cedc3a177a8d05e322c8e823dd->doDisplay (line 212)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_e3b5cf7791afca8dd346b08e0dcda643->doDisplay (line 54)
18	Twig\Template->yield (line 402)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 373)
21	Twig\TemplateWrapper->render (line 51)
22	Twig\Environment->render (line 333)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
26	Mirinly\FrontBundle\Controller\MusicVideosController->indexAction (line 167)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 185)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 29)
32	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
Mirinly\AdminBundle\Entity\Country	233
Mirinly\AdminBundle\Entity\Currency	153
Mirinly\AdminBundle\Entity\Page	9
Mirinly\AdminBundle\Entity\CustomSlider	7
Mirinly\AdminBundle\Entity\Continent	7
Mirinly\AdminBundle\Entity\MusicVideo	5
Mirinly\AdminBundle\Entity\MusicVideoTrend	5
Mirinly\AdminBundle\Entity\MusicArtistCharacterTrend	5
Mirinly\AdminBundle\Entity\MusicArtistCharacter	5
Mirinly\AdminBundle\Entity\MusicArtist	5
Mirinly\AdminBundle\Entity\Artist	5
Mirinly\AdminBundle\Entity\ImageToMusicArtist	5
Mirinly\AdminBundle\Entity\Season	4
Mirinly\AdminBundle\Entity\Parameters	2

Entities Mapping

Class	Mapping errors
Mirinly\AdminBundle\Entity\AbstractEntity	No errors.
Mirinly\AdminBundle\Entity\MusicVideo	The field Mirinly\AdminBundle\Entity\MusicVideo#toUsers is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\UserToMusicVideo#musicVideo does not contain the required 'inversedBy: "toUsers"' attribute. The association Mirinly\AdminBundle\Entity\MusicVideo#availableECommerceItems refers to the owning side field Mirinly\AdminBundle\Entity\ECommerceItem#approvedMusicVideos which does not exist. The field Mirinly\AdminBundle\Entity\MusicVideo#musicScenes is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\MusicScene#musicVideo does not contain the required 'inversedBy: "musicScenes"' attribute. The field Mirinly\AdminBundle\Entity\MusicVideo#musicVideoSetCategories is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\MusicVideoSetCategory#musicVideo does not contain the required 'inversedBy: "musicVideoSetCategories"' attribute. The field Mirinly\AdminBundle\Entity\MusicVideo#musicVideoCharacters is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\MusicVideoCharacter#musicVideo does not contain the required 'inversedBy: "musicVideoCharacters"' attribute. The field Mirinly\AdminBundle\Entity\MusicVideo#artists is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\Artist#musicVideos does not contain the required 'inversedBy: "artists"' attribute. The field Mirinly\AdminBundle\Entity\MusicVideo#brandApproveSeasons is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\BrandApproveSeasonToMusicVideo#musicVideo does not contain the required 'inversedBy: "brandApproveSeasons"' attribute. The field Mirinly\AdminBundle\Entity\MusicVideo#wallets is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\MusicVideoWallet#production does not contain the required 'inversedBy: "wallets"' attribute.
Mirinly\AdminBundle\Entity\MusicArtist	The field Mirinly\AdminBundle\Entity\MusicArtist#toUsers is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\UserToMusicArtist#musicArtist does not contain the required 'inversedBy: "toUsers"' attribute. The association Mirinly\AdminBundle\Entity\MusicArtist#availableECommerceItems refers to the owning side field Mirinly\AdminBundle\Entity\ECommerceItem#approvedMusicArtists which does not exist. The field Mirinly\AdminBundle\Entity\MusicArtist#musicArtistCharacters is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\MusicArtistCharacter#musicArtist does not contain the required 'inversedBy: "musicArtistCharacters"' attribute. The field Mirinly\AdminBundle\Entity\MusicArtist#musicArtistGuestCharacters is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\MusicArtistGuestCharacter#musicArtist does not contain the required 'inversedBy: "musicArtistGuestCharacters"' attribute. The field Mirinly\AdminBundle\Entity\MusicArtist#musicArtistMerches is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\MusicArtistMerch#musicArtist does not contain the required 'inversedBy: "musicArtistMerches"' attribute. The field Mirinly\AdminBundle\Entity\MusicArtist#musicArtistPosts is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\MusicArtistPosts#musicArtist does not contain the required 'inversedBy: "musicArtistPosts"' attribute. The field Mirinly\AdminBundle\Entity\MusicArtist#artists is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\Artist#musicArtists does not contain the required 'inversedBy: "artists"' attribute. The field Mirinly\AdminBundle\Entity\MusicArtist#brandApproveSeasons is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\BrandApproveSeasonToMusicArtist#musicArtist does not contain the required 'inversedBy: "brandApproveSeasons"' attribute. The field Mirinly\AdminBundle\Entity\MusicArtist#wallets is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\MusicArtistWallet#production does not contain the required 'inversedBy: "wallets"' attribute.
Mirinly\AdminBundle\Entity\MusicScene	No errors.
Mirinly\AdminBundle\Entity\BindMusicVideoSceneItemCharacter	No errors.
Mirinly\AdminBundle\Entity\MusicVideoCharacter	The field Mirinly\AdminBundle\Entity\MusicVideoCharacter#musicVideoCharacterSignatures is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\MusicVideoCharacterSignature#character does not contain the required 'inversedBy: "musicVideoCharacterSignatures"' attribute.
Mirinly\AdminBundle\Entity\MusicVideoCharacterSignature	No errors.
Mirinly\AdminBundle\Entity\BindMusicVideoCharacterSignatureItem	No errors.
Mirinly\AdminBundle\Entity\MusicArtistCharacter	No errors.
Mirinly\AdminBundle\Entity\MusicArtistPosts	No errors.
Mirinly\AdminBundle\Entity\BindMusicArtistPostItemCharacter	No errors.
Mirinly\AdminBundle\Entity\MusicVideoSetCategory	The field Mirinly\AdminBundle\Entity\MusicVideoSetCategory#musicVideoSets is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\MusicVideoSet#musicVideoSetCategory does not contain the required 'inversedBy: "musicVideoSets"' attribute.
Mirinly\AdminBundle\Entity\MusicVideoSet	No errors.
Mirinly\AdminBundle\Entity\BindMusicVideoSetItem	No errors.
Mirinly\AdminBundle\Entity\MusicArtistMerch	No errors.
Mirinly\AdminBundle\Entity\BindMusicArtistMerch	No errors.
Mirinly\AdminBundle\Entity\Season	No errors.
Mirinly\AdminBundle\Entity\UserToMusicVideo	No errors.
Mirinly\AdminBundle\Entity\RecordLabel	The field Mirinly\AdminBundle\Entity\RecordLabel#recordLabelMerches is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\RecordLabelMerch#recordLabel does not contain the required 'inversedBy: "recordLabelMerches"' attribute. The field Mirinly\AdminBundle\Entity\RecordLabel#recordLabelPosts is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\RecordLabelPosts#recordLabel does not contain the required 'inversedBy: "recordLabelPosts"' attribute. The association Mirinly\AdminBundle\Entity\RecordLabel#availableECommerceItems refers to the owning side field Mirinly\AdminBundle\Entity\ECommerceItem#approvedRecordLabels which does not exist. The field Mirinly\AdminBundle\Entity\RecordLabel#brandApproveSeasons is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\BrandApproveSeasonToRecordLabel#recordLabel does not contain the required 'inversedBy: "brandApproveSeasons"' attribute.
Mirinly\AdminBundle\Entity\Director	No errors.
Mirinly\AdminBundle\Entity\Producer	No errors.
Mirinly\AdminBundle\Entity\ECommerceItem	The field Mirinly\AdminBundle\Entity\ECommerceItem#productions is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\ECommerceItemToProduction#eCommerceItem does not contain the required 'inversedBy: "productions"' attribute. The mappings Mirinly\AdminBundle\Entity\ECommerceItem#collectionItems and Mirinly\AdminBundle\Entity\CollectionItem#item are inconsistent with each other.
Mirinly\AdminBundle\Entity\MusicVideoLookBook	No errors.
Mirinly\AdminBundle\Entity\MusicVideoLookBookFolder	No errors.
Mirinly\AdminBundle\Entity\MusicVideoTrend	No errors.
Mirinly\AdminBundle\Entity\Artist	No errors.
Mirinly\AdminBundle\Entity\Brand	The association Mirinly\AdminBundle\Entity\Brand#countries refers to the inverse side field Mirinly\AdminBundle\Entity\Country#brands which does not exist. The association Mirinly\AdminBundle\Entity\Brand#disabledStates refers to the inverse side field Mirinly\AdminBundle\Entity\State#brands which does not exist. The field Mirinly\AdminBundle\Entity\Brand#eCommerceItems is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\ECommerceItem#brand does not contain the required 'inversedBy: "eCommerceItems"' attribute. The field Mirinly\AdminBundle\Entity\Brand#returnAddresses is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\BrandReturnAddress#brand does not contain the required 'inversedBy: "returnAddresses"' attribute. The field Mirinly\AdminBundle\Entity\Brand#wallets is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\BrandWallet#brand does not contain the required 'inversedBy: "wallets"' attribute.
Mirinly\AdminBundle\Entity\BrandApproveSeasonToMusicVideo	No errors.
Mirinly\AdminBundle\Entity\EpkAttachmentToProduction	No errors.
Mirinly\AdminBundle\Entity\EpkAttachmentLinkToProduction	No errors.
Mirinly\AdminBundle\Entity\LookBookAttachmentToProduction	No errors.
Mirinly\AdminBundle\Entity\LookBookAttachmentLinkToProduction	No errors.
Mirinly\AdminBundle\Entity\AudioAttachmentToMusicVideo	No errors.
Mirinly\AdminBundle\Entity\AudioAttachmentLinkToMusicVideo	No errors.
Mirinly\AdminBundle\Entity\MusicVideoWallet	No errors.
Mirinly\AdminBundle\Entity\MusicArtistCharacterTrend	No errors.
Mirinly\AdminBundle\Entity\ECommerceItemTrend	No errors.
Mirinly\AdminBundle\Entity\ECommerceItemSettingsDiscovery	No errors.
Mirinly\AdminBundle\Entity\MusicArtistGuestCharacter	No errors.
Mirinly\AdminBundle\Entity\BindMusicArtistPostItemGuestCharacter	No errors.
Mirinly\AdminBundle\Entity\UserToMusicArtist	No errors.
Mirinly\AdminBundle\Entity\MusicArtistLookBook	No errors.
Mirinly\AdminBundle\Entity\MusicArtistLookBookFolder	No errors.
Mirinly\AdminBundle\Entity\MusicArtistTrend	No errors.
Mirinly\AdminBundle\Entity\BrandApproveSeasonToMusicArtist	No errors.
Mirinly\AdminBundle\Entity\MusicArtistWallet	No errors.
Mirinly\AdminBundle\Entity\CustomSlider	No errors.
Mirinly\AdminBundle\Entity\RecordLabelMerch	No errors.
Mirinly\AdminBundle\Entity\BindRecordLabelMerch	No errors.
Mirinly\AdminBundle\Entity\RecordLabelPosts	No errors.
Mirinly\AdminBundle\Entity\BindRecordLabelPostItemArtistCharacter	No errors.
Mirinly\AdminBundle\Entity\CustomersCart	No errors.
Mirinly\AdminBundle\Entity\BindFilmSceneItemCharacter	No errors.
Mirinly\AdminBundle\Entity\BindFilmCharacterSignatureItem	No errors.
Mirinly\AdminBundle\Entity\BindFilmSetItem	No errors.
Mirinly\AdminBundle\Entity\BindFilmMerch	No errors.
Mirinly\AdminBundle\Entity\BindFilmPostItemCharacter	No errors.
Mirinly\AdminBundle\Entity\FilmScene	No errors.
Mirinly\AdminBundle\Entity\FilmCharacterSignature	No errors.
Mirinly\AdminBundle\Entity\FilmCharacter	The field Mirinly\AdminBundle\Entity\FilmCharacter#filmCharacterSignatures is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\FilmCharacterSignature#character does not contain the required 'inversedBy: "filmCharacterSignatures"' attribute.
Mirinly\AdminBundle\Entity\FilmSet	No errors.
Mirinly\AdminBundle\Entity\FilmSetCategory	The field Mirinly\AdminBundle\Entity\FilmSetCategory#filmSets is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\FilmSet#filmSetCategory does not contain the required 'inversedBy: "filmSets"' attribute.
Mirinly\AdminBundle\Entity\FilmMerch	No errors.
Mirinly\AdminBundle\Entity\FilmPosts	No errors.
Mirinly\AdminBundle\Entity\Film	The field Mirinly\AdminBundle\Entity\Film#toUsers is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\UserToFilm#film does not contain the required 'inversedBy: "toUsers"' attribute. The association Mirinly\AdminBundle\Entity\Film#availableECommerceItems refers to the owning side field Mirinly\AdminBundle\Entity\ECommerceItem#approvedFilms which does not exist. The field Mirinly\AdminBundle\Entity\Film#filmMerches is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\FilmMerch#film does not contain the required 'inversedBy: "filmMerches"' attribute. The field Mirinly\AdminBundle\Entity\Film#filmPosts is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\FilmPosts#film does not contain the required 'inversedBy: "filmPosts"' attribute. The field Mirinly\AdminBundle\Entity\Film#filmScenes is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\FilmScene#film does not contain the required 'inversedBy: "filmScenes"' attribute. The field Mirinly\AdminBundle\Entity\Film#filmCharacters is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\FilmCharacter#film does not contain the required 'inversedBy: "filmCharacters"' attribute. The field Mirinly\AdminBundle\Entity\Film#filmSetCategories is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\FilmSetCategory#film does not contain the required 'inversedBy: "filmSetCategories"' attribute. The field Mirinly\AdminBundle\Entity\Film#artists is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\Artist#films does not contain the required 'inversedBy: "artists"' attribute. The field Mirinly\AdminBundle\Entity\Film#brandApproveSeasons is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\BrandApproveSeasonToFilm#film does not contain the required 'inversedBy: "brandApproveSeasons"' attribute. The field Mirinly\AdminBundle\Entity\Film#wallets is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\FilmWallet#production does not contain the required 'inversedBy: "wallets"' attribute.
Mirinly\AdminBundle\Entity\BindTvShowSceneItemCharacter	No errors.
Mirinly\AdminBundle\Entity\BindTvShowCharacterSignatureItem	No errors.
Mirinly\AdminBundle\Entity\BindTvShowSetItem	No errors.
Mirinly\AdminBundle\Entity\BindTvShowMerch	No errors.
Mirinly\AdminBundle\Entity\BindTvShowPostItemCharacter	No errors.
Mirinly\AdminBundle\Entity\TvShowScene	No errors.
Mirinly\AdminBundle\Entity\TvShowEpisode	The field Mirinly\AdminBundle\Entity\TvShowEpisode#tvShowScenes is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\TvShowScene#tvShowEpisode does not contain the required 'inversedBy: "tvShowScenes"' attribute.
Mirinly\AdminBundle\Entity\TvShowSeason	No errors.
Mirinly\AdminBundle\Entity\TvShowCharacterSignature	No errors.
Mirinly\AdminBundle\Entity\TvShowCharacter	The field Mirinly\AdminBundle\Entity\TvShowCharacter#tvShowCharacterSignatures is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\TvShowCharacterSignature#character does not contain the required 'inversedBy: "tvShowCharacterSignatures"' attribute.
Mirinly\AdminBundle\Entity\TvShowSet	No errors.
Mirinly\AdminBundle\Entity\TvShowSetCategory	The field Mirinly\AdminBundle\Entity\TvShowSetCategory#tvShowSets is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\TvShowSet#tvShowSetCategory does not contain the required 'inversedBy: "tvShowSets"' attribute.
Mirinly\AdminBundle\Entity\TvShowMerch	If association Mirinly\AdminBundle\Entity\TvShowMerch#tvShowSeason is many-to-one, then the inversed side Mirinly\AdminBundle\Entity\TvShowSeason#tvShowMerches has to be one-to-many.
Mirinly\AdminBundle\Entity\TvShowPosts	If association Mirinly\AdminBundle\Entity\TvShowPosts#tvShowSeason is many-to-one, then the inversed side Mirinly\AdminBundle\Entity\TvShowSeason#tvShowPosts has to be one-to-many.
Mirinly\AdminBundle\Entity\TvShow	The field Mirinly\AdminBundle\Entity\TvShow#toUsers is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\UserToTvShow#tvShow does not contain the required 'inversedBy: "toUsers"' attribute. The association Mirinly\AdminBundle\Entity\TvShow#availableECommerceItems refers to the owning side field Mirinly\AdminBundle\Entity\ECommerceItem#approvedTvShows which does not exist. The field Mirinly\AdminBundle\Entity\TvShow#tvShowMerches is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\TvShowMerch#tvShow does not contain the required 'inversedBy: "tvShowMerches"' attribute. The field Mirinly\AdminBundle\Entity\TvShow#tvShowPosts is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\TvShowPosts#tvShow does not contain the required 'inversedBy: "tvShowPosts"' attribute. The field Mirinly\AdminBundle\Entity\TvShow#tvShowSeasons is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\TvShowSeason#tvShow does not contain the required 'inversedBy: "tvShowSeasons"' attribute. The field Mirinly\AdminBundle\Entity\TvShow#tvShowCharacters is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\TvShowCharacter#tvShow does not contain the required 'inversedBy: "tvShowCharacters"' attribute. The field Mirinly\AdminBundle\Entity\TvShow#tvShowSetCategories is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\TvShowSetCategory#tvShow does not contain the required 'inversedBy: "tvShowSetCategories"' attribute. The field Mirinly\AdminBundle\Entity\TvShow#artists is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\Artist#tvShows does not contain the required 'inversedBy: "artists"' attribute. The field Mirinly\AdminBundle\Entity\TvShow#brandApproveSeasons is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\BrandApproveSeasonToTvShow#tvShow does not contain the required 'inversedBy: "brandApproveSeasons"' attribute. The field Mirinly\AdminBundle\Entity\TvShow#wallets is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\TvShowWallet#production does not contain the required 'inversedBy: "wallets"' attribute.
Mirinly\AdminBundle\Entity\Size	No errors.
Mirinly\AdminBundle\Entity\ItemColor	No errors.
Mirinly\AdminBundle\Entity\Currency	No errors.
Mirinly\AdminBundle\Entity\Country	No errors.
Mirinly\AdminBundle\Entity\Continent	No errors.
Mirinly\AdminBundle\Entity\State	No errors.
Mirinly\AdminBundle\Entity\City	No errors.
Mirinly\AdminBundle\Entity\ImageToMusicVideo	No errors.
FOS\UserBundle\Model\User	No errors.
Mirinly\AdminBundle\Entity\User	The field Mirinly\AdminBundle\Entity\User#toTvShows is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\UserToTvShow#user does not contain the required 'inversedBy: "toTvShows"' attribute. The field Mirinly\AdminBundle\Entity\User#toFilms is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\UserToFilm#user does not contain the required 'inversedBy: "toFilms"' attribute. The field Mirinly\AdminBundle\Entity\User#toMusicVideos is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\UserToMusicVideo#user does not contain the required 'inversedBy: "toMusicVideos"' attribute. The field Mirinly\AdminBundle\Entity\User#toMusicArtist is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\UserToMusicArtist#user does not contain the required 'inversedBy: "toMusicArtist"' attribute. The field Mirinly\AdminBundle\Entity\User#lookBooks is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\ProductionLookBook#user does not contain the required 'inversedBy: "lookBooks"' attribute. The field Mirinly\AdminBundle\Entity\User#lookBookFolders is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\ProductionLookBookFolder#user does not contain the required 'inversedBy: "lookBookFolders"' attribute. The field Mirinly\AdminBundle\Entity\User#wallets is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\ProductionWallet#user does not contain the required 'inversedBy: "wallets"' attribute.
Mirinly\AdminBundle\Entity\ApproveProductionMusicVideo	No errors.
Mirinly\AdminBundle\Entity\MusicPerformer	No errors.
Mirinly\AdminBundle\Entity\ImageToMusicArtist	No errors.
Mirinly\AdminBundle\Entity\ApproveProductionMusicArtist	No errors.
Mirinly\AdminBundle\Entity\BrandApproveSeasonToRecordLabel	No errors.
Mirinly\AdminBundle\Entity\Editorial	The association Mirinly\AdminBundle\Entity\Editorial#availableECommerceItems refers to the owning side field Mirinly\AdminBundle\Entity\ECommerceItem#approvedEditorials which does not exist. The field Mirinly\AdminBundle\Entity\Editorial#brandApproveSeasons is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\BrandApproveSeasonToEditorial#editorial does not contain the required 'inversedBy: "brandApproveSeasons"' attribute. The field Mirinly\AdminBundle\Entity\Editorial#wallets is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\EditorialWallet#production does not contain the required 'inversedBy: "wallets"' attribute.
Mirinly\AdminBundle\Entity\ECommerceSubcategory	The field Mirinly\AdminBundle\Entity\ECommerceSubcategory#eCommerceItems is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\ECommerceItem#eCommerceSubcategory does not contain the required 'inversedBy: "eCommerceItems"' attribute.
Mirinly\AdminBundle\Entity\ECommerceItemType	The field Mirinly\AdminBundle\Entity\ECommerceItemType#eCommerceItems is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\ECommerceItem#eCommerceItemType does not contain the required 'inversedBy: "eCommerceItems"' attribute.
Mirinly\AdminBundle\Entity\ECommerceItemTemplate	No errors.
Mirinly\AdminBundle\Entity\ItemSizeGrid	No errors.
Mirinly\AdminBundle\Entity\ItemVariant	No errors.
Mirinly\AdminBundle\Entity\ItemInventoryLoan	No errors.
Mirinly\AdminBundle\Entity\ItemInventoryRental	No errors.
Mirinly\AdminBundle\Entity\ItemInventoryPurchase	No errors.
Mirinly\AdminBundle\Entity\ItemInventoryInPerson	No errors.
Mirinly\AdminBundle\Entity\ItemInventoryDiscovery	No errors.
Mirinly\AdminBundle\Entity\ImageToBrand	The field Mirinly\AdminBundle\Entity\ImageToBrand#itemToBrandImage is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\ItemToBrandImage#imageToBrand does not contain the required 'inversedBy: "itemToBrandImage"' attribute. The field Mirinly\AdminBundle\Entity\ImageToBrand#eCommerceItemsMainImage is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\ECommerceItem#mainImage does not contain the required 'inversedBy: "eCommerceItemsMainImage"' attribute.
Mirinly\AdminBundle\Entity\ApproveProductionTvShow	No errors.
Mirinly\AdminBundle\Entity\ApproveProductionFilm	No errors.
Mirinly\AdminBundle\Entity\ApproveProductionNetwork	No errors.
Mirinly\AdminBundle\Entity\Network	The association Mirinly\AdminBundle\Entity\Network#availableECommerceItems refers to the owning side field Mirinly\AdminBundle\Entity\ECommerceItem#approvedNetworks which does not exist. The field Mirinly\AdminBundle\Entity\Network#networkMerches is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\NetworkMerch#network does not contain the required 'inversedBy: "networkMerches"' attribute. The field Mirinly\AdminBundle\Entity\Network#networkPosts is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\NetworkPosts#network does not contain the required 'inversedBy: "networkPosts"' attribute. The field Mirinly\AdminBundle\Entity\Network#brandApproveSeasons is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\BrandApproveSeasonToNetwork#network does not contain the required 'inversedBy: "brandApproveSeasons"' attribute.
Mirinly\AdminBundle\Entity\ApproveProductionStudio	No errors.
Mirinly\AdminBundle\Entity\Studio	The field Mirinly\AdminBundle\Entity\Studio#studioMerches is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\StudioMerch#studio does not contain the required 'inversedBy: "studioMerches"' attribute. The field Mirinly\AdminBundle\Entity\Studio#studioPosts is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\StudioPosts#studio does not contain the required 'inversedBy: "studioPosts"' attribute. The association Mirinly\AdminBundle\Entity\Studio#availableECommerceItems refers to the owning side field Mirinly\AdminBundle\Entity\ECommerceItem#approvedStudios which does not exist. The field Mirinly\AdminBundle\Entity\Studio#brandApproveSeasons is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\BrandApproveSeasonToStudio#studio does not contain the required 'inversedBy: "brandApproveSeasons"' attribute.
Mirinly\AdminBundle\Entity\ApproveProductionRecordLabel	No errors.
Mirinly\AdminBundle\Entity\ApproveProductionEditorial	No errors.
Mirinly\AdminBundle\Entity\ECommerceItemStockNotification	No errors.
Mirinly\AdminBundle\Entity\ECommerceItemToProduction	No errors.
Mirinly\AdminBundle\Entity\ECommerceItemSettingsLoan	No errors.
Mirinly\AdminBundle\Entity\ECommerceItemSettingsRental	No errors.
Mirinly\AdminBundle\Entity\ECommerceItemSettingsPurchase	No errors.
Mirinly\AdminBundle\Entity\ECommerceItemSettingsInPerson	No errors.
Mirinly\AdminBundle\Entity\SearchECommerceItemTag	No errors.
Mirinly\AdminBundle\Entity\CollectionItem	The association Mirinly\AdminBundle\Entity\CollectionItem#item refers to the inverse side field Mirinly\AdminBundle\Entity\ECommerceItem#collectionItem which does not exist. The association Mirinly\AdminBundle\Entity\CollectionItem#collection refers to the inverse side field Mirinly\AdminBundle\Entity\Collection#collectionItem which does not exist.
Mirinly\AdminBundle\Entity\MusicVideoLookBookItem	No errors.
Mirinly\AdminBundle\Entity\MusicVideoLookBookFolderItem	No errors.
Mirinly\AdminBundle\Entity\MusicVideoLookBookAttachment	No errors.
Mirinly\AdminBundle\Entity\MusicVideoLookBookFolderAttachment	No errors.
Mirinly\AdminBundle\Entity\BrandTrend	No errors.
Mirinly\AdminBundle\Entity\VariationSet	No errors.
Mirinly\AdminBundle\Entity\SearchBrandTag	No errors.
Mirinly\AdminBundle\Entity\BrandReturnAddress	No errors.
Mirinly\AdminBundle\Entity\BrandSettingsLoan	No errors.
Mirinly\AdminBundle\Entity\BrandSettingsRental	No errors.
Mirinly\AdminBundle\Entity\BrandSettingsPurchase	No errors.
Mirinly\AdminBundle\Entity\BrandSettingsCustomCommission	No errors.
Mirinly\AdminBundle\Entity\BrandSettingsInPerson	No errors.
Mirinly\AdminBundle\Entity\BrandSettingsDiscovery	No errors.
Mirinly\AdminBundle\Entity\Store	No errors.
Mirinly\AdminBundle\Entity\BrandNotifyNewAddedProductions	No errors.
Mirinly\AdminBundle\Entity\BrandWallet	No errors.
Mirinly\AdminBundle\Entity\ColorFilterDictionary	No errors.
Mirinly\AdminBundle\Entity\MusicArtistLookBookItem	No errors.
Mirinly\AdminBundle\Entity\MusicArtistLookBookFolderItem	No errors.
Mirinly\AdminBundle\Entity\MusicArtistLookBookAttachment	No errors.
Mirinly\AdminBundle\Entity\MusicArtistLookBookFolderAttachment	No errors.
Mirinly\AdminBundle\Entity\ImageToRecordLabel	No errors.
Mirinly\AdminBundle\Entity\VariationSetParam	No errors.
Mirinly\AdminBundle\Entity\ImageToFilm	No errors.
Mirinly\AdminBundle\Entity\FilmCharacterTrend	No errors.
Mirinly\AdminBundle\Entity\FilmSetTrend	No errors.
Mirinly\AdminBundle\Entity\UserToFilm	No errors.
Mirinly\AdminBundle\Entity\FilmLookBook	No errors.
Mirinly\AdminBundle\Entity\FilmLookBookFolder	No errors.
Mirinly\AdminBundle\Entity\FilmTrend	No errors.
Mirinly\AdminBundle\Entity\BrandApproveSeasonToFilm	No errors.
Mirinly\AdminBundle\Entity\FilmWallet	No errors.
Mirinly\AdminBundle\Entity\ImageToTvShow	No errors.
Mirinly\AdminBundle\Entity\TvShowEpisodeTrend	No errors.
Mirinly\AdminBundle\Entity\TvShowCharacterTrend	No errors.
Mirinly\AdminBundle\Entity\TvShowSetTrend	No errors.
Mirinly\AdminBundle\Entity\UserToTvShow	No errors.
Mirinly\AdminBundle\Entity\TvShowLookBook	No errors.
Mirinly\AdminBundle\Entity\TvShowLookBookFolder	No errors.
Mirinly\AdminBundle\Entity\TvShowTrend	No errors.
Mirinly\AdminBundle\Entity\BrandApproveSeasonToTvShow	No errors.
Mirinly\AdminBundle\Entity\TvShowWallet	No errors.
Mirinly\AdminBundle\Entity\SizeSet	No errors.
Mirinly\AdminBundle\Entity\BaseSize	No errors.
Mirinly\AdminBundle\Entity\BaseColor	No errors.
Mirinly\AdminBundle\Entity\Parameters	No errors.
Mirinly\AdminBundle\Entity\Image	The field Mirinly\AdminBundle\Entity\Image#imageToBrand is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\ImageToBrand#image does not contain the required 'inversedBy: "imageToBrand"' attribute. The field Mirinly\AdminBundle\Entity\Image#imageToFilm is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\ImageToFilm#image does not contain the required 'inversedBy: "imageToFilm"' attribute. The field Mirinly\AdminBundle\Entity\Image#imageToTvShow is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\ImageToTvShow#image does not contain the required 'inversedBy: "imageToTvShow"' attribute. The field Mirinly\AdminBundle\Entity\Image#imageToMusicArtist is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\ImageToMusicArtist#image does not contain the required 'inversedBy: "imageToMusicArtist"' attribute. The field Mirinly\AdminBundle\Entity\Image#imageToMusicVideo is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\ImageToMusicVideo#image does not contain the required 'inversedBy: "imageToMusicVideo"' attribute. The field Mirinly\AdminBundle\Entity\Image#imageToNetwork is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\ImageToNetwork#image does not contain the required 'inversedBy: "imageToNetwork"' attribute. The field Mirinly\AdminBundle\Entity\Image#imageToRecordLabel is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\ImageToRecordLabel#image does not contain the required 'inversedBy: "imageToRecordLabel"' attribute. The field Mirinly\AdminBundle\Entity\Image#imageToStudio is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\ImageToStudio#image does not contain the required 'inversedBy: "imageToStudio"' attribute. The field Mirinly\AdminBundle\Entity\Image#complaints is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\Complaint#image does not contain the required 'inversedBy: "complaints"' attribute.
Mirinly\AdminBundle\Entity\CustomerShippingAddress	No errors.
Mirinly\AdminBundle\Entity\WishlistFollow	No errors.
Mirinly\AdminBundle\Entity\ProjectRegistrationRequest	No errors.
Mirinly\AdminBundle\Entity\CartOrderProject	No errors.
Mirinly\AdminBundle\Entity\ProductionLookBook	No errors.
Mirinly\AdminBundle\Entity\ProductionLookBookFolder	No errors.
Mirinly\AdminBundle\Entity\ProductionWallet	No errors.
Mirinly\AdminBundle\Entity\BrandApproveSeasonToEditorial	No errors.
Mirinly\AdminBundle\Entity\EditorialLookBook	No errors.
Mirinly\AdminBundle\Entity\EditorialLookBookFolder	No errors.
Mirinly\AdminBundle\Entity\EditorialWallet	No errors.
Mirinly\AdminBundle\Entity\ECommerceCategory	No errors.
Mirinly\AdminBundle\Entity\SizeParamSet	No errors.
Mirinly\AdminBundle\Entity\ItemSizeParamGrid	No errors.
Mirinly\AdminBundle\Entity\ItemToBrandImage	No errors.
Mirinly\AdminBundle\Entity\NetworkMerch	No errors.
Mirinly\AdminBundle\Entity\NetworkPosts	No errors.
Mirinly\AdminBundle\Entity\NetworkLookBook	No errors.
Mirinly\AdminBundle\Entity\NetworkLookBookFolder	No errors.
Mirinly\AdminBundle\Entity\BrandApproveSeasonToNetwork	No errors.
Mirinly\AdminBundle\Entity\StudioMerch	No errors.
Mirinly\AdminBundle\Entity\StudioPosts	No errors.
Mirinly\AdminBundle\Entity\StudioLookBook	No errors.
Mirinly\AdminBundle\Entity\StudioLookBookFolder	No errors.
Mirinly\AdminBundle\Entity\BrandApproveSeasonToStudio	No errors.
Mirinly\AdminBundle\Entity\Collection	The mappings Mirinly\AdminBundle\Entity\Collection#collectionItems and Mirinly\AdminBundle\Entity\CollectionItem#collection are inconsistent with each other.
Mirinly\AdminBundle\Entity\AddressAttachmentToBrand	No errors.
Mirinly\AdminBundle\Entity\ItemInventory	The association Mirinly\AdminBundle\Entity\ItemInventory#item refers to the inverse side field Mirinly\AdminBundle\Entity\ECommerceItem#itemInventories which does not exist.
Mirinly\AdminBundle\Entity\FilmLookBookItem	No errors.
Mirinly\AdminBundle\Entity\FilmLookBookFolderItem	No errors.
Mirinly\AdminBundle\Entity\FilmLookBookAttachment	No errors.
Mirinly\AdminBundle\Entity\FilmLookBookFolderAttachment	No errors.
Mirinly\AdminBundle\Entity\TvShowLookBookItem	No errors.
Mirinly\AdminBundle\Entity\TvShowLookBookFolderItem	No errors.
Mirinly\AdminBundle\Entity\TvShowLookBookAttachment	No errors.
Mirinly\AdminBundle\Entity\TvShowLookBookFolderAttachment	No errors.
Mirinly\AdminBundle\Entity\Page	No errors.

Symfony Profiler

GET https://mirinly.com/_fragment?_path=_format%3Dhtml%26_locale%3Den%26_controller%3DMirinly%255CFrontBundle%255CController%255CPageController%253A%253AlistLinksAc…

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping