Symfony Profiler

Query Metrics

25 Database Queries

22 Different statements

388.90 ms Query time

25 Invalid entities

416 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

275.01 ms
(70.72%)

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 (m8_.music_video_id = ? OR m12_.music_video_id = ? OR m14_.music_video_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-19 00:00:00"
  "2026-02-19 00:00:00"
  "2026-02-19 00:00:00"
  13
  13
  13
]

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 (
    m8_.music_video_id = ?
    OR m12_.music_video_id = ?
    OR m14_.music_video_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-19 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-19 00:00:00') LEFT JOIN e_commerce_item_trend e1_ ON (e1_.id = e0_.id AND e1_.updated >= '2026-02-19 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 (m8_.music_video_id = 13 OR m12_.music_video_id = 13 OR m14_.music_video_id = 13) 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->getECommerceItemTrendsForMusicVideo (line 318)
7	Mirinly\FrontBundle\Controller\MusicVideosController->musicArtistPostsAction (line 1626)
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)

39.24 ms
(10.09%)

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-19 00:00:00"
  "2026-02-19 00:00:00"
  "2026-02-19 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-19 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-19 00:00:00') LEFT JOIN music_video_trend m1_ ON (m1_.id = m0_.id AND m1_.updated >= '2026-02-19 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->musicArtistPostsAction (line 1618)
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)

24.96 ms
(6.42%)

SELECT m0_.points AS points_0, m0_.id AS id_1, m0_.updated AS updated_2, sum(m0_.points) AS sclr_3, sum(t1_.points) AS sclr_4, sum(t2_.points) / (DATEDIFF(?, min(t2_.updated))) AS sclr_5, m0_.target_id AS target_id_6 FROM music_artist_character_trend m0_ LEFT JOIN tv_show_character_trend t2_ ON (t2_.id = m0_.id AND t2_.updated < ?) LEFT JOIN tv_show_character_trend t1_ ON (t1_.id = m0_.id AND t1_.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) WHERE m5_.music_video_id = ? GROUP BY m0_.target_id ORDER BY sclr_3 DESC LIMIT 5

Parameters:

[
  "2026-02-19 00:00:00"
  "2026-02-19 00:00:00"
  "2026-02-19 00:00:00"
  13
]

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(t1_.points) AS sclr_4,
  sum(t2_.points) / (
    DATEDIFF(
      ?,
      min(t2_.updated)
    )
  ) AS sclr_5,
  m0_.target_id AS target_id_6
FROM
  music_artist_character_trend m0_
  LEFT JOIN tv_show_character_trend t2_ ON (
    t2_.id = m0_.id
    AND t2_.updated < ?
  )
  LEFT JOIN tv_show_character_trend t1_ ON (
    t1_.id = m0_.id
    AND t1_.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)
WHERE
  m5_.music_video_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(t1_.points) AS sclr_4, sum(t2_.points) / (DATEDIFF('2026-02-19 00:00:00', min(t2_.updated))) AS sclr_5, m0_.target_id AS target_id_6 FROM music_artist_character_trend m0_ LEFT JOIN tv_show_character_trend t2_ ON (t2_.id = m0_.id AND t2_.updated < '2026-02-19 00:00:00') LEFT JOIN tv_show_character_trend t1_ ON (t1_.id = m0_.id AND t1_.updated >= '2026-02-19 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) WHERE m5_.music_video_id = 13 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->getMusicArtistCharacterTrendsForMusicVideo (line 63)
7	Mirinly\FrontBundle\Controller\MusicVideosController->musicArtistPostsAction (line 1622)
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)

11.76 ms
(3.02%)

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:

[
  "aicnr3a0ddsep1l47o42bb2c8m"
]

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 = 'aicnr3a0ddsep1l47o42bb2c8m' 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_c3d781c642c38bcb866b487e6841e789->doDisplay (line 58)
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->musicArtistPostsAction (line 1635)
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)

11.50 ms
(2.96%)

SELECT m0_.thumbnail AS thumbnail_0, m0_.position AS position_1, m0_.updated AS updated_2, m0_.name AS name_3, m0_.description AS description_4, m0_.id AS id_5, m0_.actual_publish_date AS actual_publish_date_6, m0_.music_artist_id AS music_artist_id_7, m0_.music_performer_id AS music_performer_id_8, m0_.artist_id AS artist_id_9, m0_.image_to_music_artist_id AS image_to_music_artist_id_10 FROM music_artist_character m0_ INNER JOIN music_video m1_ ON (m1_.id = ? AND m1_.publish = 1) INNER JOIN music_artist_to_music_video m3_ ON m1_.id = m3_.music_video_id INNER JOIN music_artist m2_ ON m2_.id = m3_.music_artist_id AND (m2_.publish = 1) INNER JOIN music_artist_to_music_video m5_ ON m2_.id = m5_.music_artist_id INNER JOIN music_video m4_ ON m4_.id = m5_.music_video_id AND (m4_.publish = 1) INNER JOIN music_video_character m6_ ON m4_.id = m6_.music_video_id AND (m6_.artist_id = m0_.artist_id) LEFT JOIN music_video_character_signature m7_ ON (m7_.character_id = m6_.id AND m7_.publish = 1) LEFT JOIN bind_music_video_character_signature_item b8_ ON (b8_.music_video_character_signature_id = m7_.id) LEFT JOIN music_scene m9_ ON m4_.id = m9_.music_video_id AND (m9_.publish = 1) LEFT JOIN bind_music_video_scene_item_character b10_ ON (b10_.music_scene_id = m9_.id AND b10_.music_video_character_id = m6_.id) LEFT JOIN music_artist_posts m11_ ON (m11_.music_artist_id = m2_.id AND m11_.publish = 1) LEFT JOIN bind_music_artist_post_item_character b12_ ON (b12_.music_artist_character_id = m0_.id AND b12_.music_artist_post_id = m11_.id) LEFT JOIN music_artist_guest_character m13_ ON m2_.id = m13_.music_artist_id LEFT JOIN bind_music_artist_post_item_guest_character b14_ ON (b14_.music_artist_guest_character_id = m13_.id AND b14_.music_artist_post_id = m11_.id) WHERE m0_.music_artist_id = m2_.id AND ((b12_.id IS NOT NULL OR b10_.id IS NOT NULL OR b8_.id IS NOT NULL) OR (b8_.id IS NOT NULL AND b14_.id IS NOT NULL)) ORDER BY m0_.actual_publish_date DESC, m0_.position ASC

Parameters:

[
  13
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.thumbnail AS thumbnail_0,
  m0_.position AS position_1,
  m0_.updated AS updated_2,
  m0_.name AS name_3,
  m0_.description AS description_4,
  m0_.id AS id_5,
  m0_.actual_publish_date AS actual_publish_date_6,
  m0_.music_artist_id AS music_artist_id_7,
  m0_.music_performer_id AS music_performer_id_8,
  m0_.artist_id AS artist_id_9,
  m0_.image_to_music_artist_id AS image_to_music_artist_id_10
FROM
  music_artist_character m0_
  INNER JOIN music_video m1_ ON (
    m1_.id = ?
    AND m1_.publish = 1
  )
  INNER JOIN music_artist_to_music_video m3_ ON m1_.id = m3_.music_video_id
  INNER JOIN music_artist m2_ ON m2_.id = m3_.music_artist_id
  AND (m2_.publish = 1)
  INNER JOIN music_artist_to_music_video m5_ ON m2_.id = m5_.music_artist_id
  INNER JOIN music_video m4_ ON m4_.id = m5_.music_video_id
  AND (m4_.publish = 1)
  INNER JOIN music_video_character m6_ ON m4_.id = m6_.music_video_id
  AND (m6_.artist_id = m0_.artist_id)
  LEFT JOIN music_video_character_signature m7_ ON (
    m7_.character_id = m6_.id
    AND m7_.publish = 1
  )
  LEFT JOIN bind_music_video_character_signature_item b8_ ON (
    b8_.music_video_character_signature_id = m7_.id
  )
  LEFT JOIN music_scene m9_ ON m4_.id = m9_.music_video_id
  AND (m9_.publish = 1)
  LEFT JOIN bind_music_video_scene_item_character b10_ ON (
    b10_.music_scene_id = m9_.id
    AND b10_.music_video_character_id = m6_.id
  )
  LEFT JOIN music_artist_posts m11_ ON (
    m11_.music_artist_id = m2_.id
    AND m11_.publish = 1
  )
  LEFT JOIN bind_music_artist_post_item_character b12_ ON (
    b12_.music_artist_character_id = m0_.id
    AND b12_.music_artist_post_id = m11_.id
  )
  LEFT JOIN music_artist_guest_character m13_ ON m2_.id = m13_.music_artist_id
  LEFT JOIN bind_music_artist_post_item_guest_character b14_ ON (
    b14_.music_artist_guest_character_id = m13_.id
    AND b14_.music_artist_post_id = m11_.id
  )
WHERE
  m0_.music_artist_id = m2_.id
  AND (
    (
      b12_.id IS NOT NULL
      OR b10_.id IS NOT NULL
      OR b8_.id IS NOT NULL
    )
    OR (
      b8_.id IS NOT NULL
      AND b14_.id IS NOT NULL
    )
  )
ORDER BY
  m0_.actual_publish_date DESC,
  m0_.position ASC

SELECT m0_.thumbnail AS thumbnail_0, m0_.position AS position_1, m0_.updated AS updated_2, m0_.name AS name_3, m0_.description AS description_4, m0_.id AS id_5, m0_.actual_publish_date AS actual_publish_date_6, m0_.music_artist_id AS music_artist_id_7, m0_.music_performer_id AS music_performer_id_8, m0_.artist_id AS artist_id_9, m0_.image_to_music_artist_id AS image_to_music_artist_id_10 FROM music_artist_character m0_ INNER JOIN music_video m1_ ON (m1_.id = 13 AND m1_.publish = 1) INNER JOIN music_artist_to_music_video m3_ ON m1_.id = m3_.music_video_id INNER JOIN music_artist m2_ ON m2_.id = m3_.music_artist_id AND (m2_.publish = 1) INNER JOIN music_artist_to_music_video m5_ ON m2_.id = m5_.music_artist_id INNER JOIN music_video m4_ ON m4_.id = m5_.music_video_id AND (m4_.publish = 1) INNER JOIN music_video_character m6_ ON m4_.id = m6_.music_video_id AND (m6_.artist_id = m0_.artist_id) LEFT JOIN music_video_character_signature m7_ ON (m7_.character_id = m6_.id AND m7_.publish = 1) LEFT JOIN bind_music_video_character_signature_item b8_ ON (b8_.music_video_character_signature_id = m7_.id) LEFT JOIN music_scene m9_ ON m4_.id = m9_.music_video_id AND (m9_.publish = 1) LEFT JOIN bind_music_video_scene_item_character b10_ ON (b10_.music_scene_id = m9_.id AND b10_.music_video_character_id = m6_.id) LEFT JOIN music_artist_posts m11_ ON (m11_.music_artist_id = m2_.id AND m11_.publish = 1) LEFT JOIN bind_music_artist_post_item_character b12_ ON (b12_.music_artist_character_id = m0_.id AND b12_.music_artist_post_id = m11_.id) LEFT JOIN music_artist_guest_character m13_ ON m2_.id = m13_.music_artist_id LEFT JOIN bind_music_artist_post_item_guest_character b14_ ON (b14_.music_artist_guest_character_id = m13_.id AND b14_.music_artist_post_id = m11_.id) WHERE m0_.music_artist_id = m2_.id AND ((b12_.id IS NOT NULL OR b10_.id IS NOT NULL OR b8_.id IS NOT NULL) OR (b8_.id IS NOT NULL AND b14_.id IS NOT NULL)) 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\MusicArtistCharacterRepository->findNotEmptyMusicArtistCharactersByMusicVideo (line 141)
7	Mirinly\FrontBundle\Controller\MusicVideosController->isEmptyMusicVideoAssets (line 2536)
8	Mirinly\FrontBundle\Controller\MusicVideosController->musicArtistPostsAction (line 1524)
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)

9.31 ms
(2.39%)

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

Parameters:

[
  "13"
]

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

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 m0_.id = '13' 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;

#	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->getOneOrNullResult (line 737)
6	Mirinly\AdminBundle\Entity\MusicVideoRepository->getPublishedMusicVideoById (line 103)
7	Mirinly\FrontBundle\Controller\MusicVideosController->musicArtistPostsAction (line 1514)
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)

7.26 ms
(1.87%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 433)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	Mirinly\FrontBundle\Controller\MusicVideosController->musicArtistPostsAction (line 1582)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 185)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 29)
9	require_once (line 5)

2.33 ms
(0.60%)

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_ INNER JOIN music_artist_to_music_video m2_ ON m0_.id = m2_.music_artist_id INNER JOIN music_video m1_ ON m1_.id = m2_.music_video_id AND (m1_.id = ?) WHERE 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_.id DESC

Parameters:

[
  13
]

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_
  INNER JOIN music_artist_to_music_video m2_ ON m0_.id = m2_.music_artist_id
  INNER JOIN music_video m1_ ON m1_.id = m2_.music_video_id
  AND (m1_.id = ?)
WHERE
  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_.id DESC

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_ INNER JOIN music_artist_to_music_video m2_ ON m0_.id = m2_.music_artist_id INNER JOIN music_video m1_ ON m1_.id = m2_.music_video_id AND (m1_.id = 13) WHERE 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_.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\MusicArtistRepository->getPublishedMusicArtistsByMusicVideo (line 109)
7	Mirinly\FrontBundle\Controller\MusicVideosController->musicArtistPostsAction (line 1518)
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)

1.23 ms
(0.32%)

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

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

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

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

#	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\MusicArtistPostsRepository->getPostsPublished (line 65)
7	Mirinly\FrontBundle\Controller\MusicVideosController->isEmptyMusicVideoAssets (line 2543)
8	Mirinly\FrontBundle\Controller\MusicVideosController->musicArtistPostsAction (line 1524)
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.97 ms
(0.25%)

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_c3d781c642c38bcb866b487e6841e789->doDisplay (line 58)
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->musicArtistPostsAction (line 1635)
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.66 ms
(0.17%)

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_c3d781c642c38bcb866b487e6841e789->doDisplay (line 58)
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->musicArtistPostsAction (line 1635)
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.64 ms
(0.16%)

SELECT m0_.name AS name_0, m0_.thumbnail AS thumbnail_1, m0_.description AS description_2, m0_.updated AS updated_3, m0_.position AS position_4, m0_.id AS id_5, m0_.publish AS publish_6, m0_.actual_publish_date AS actual_publish_date_7, m0_.music_video_id AS music_video_id_8, m0_.image_to_music_video_id AS image_to_music_video_id_9 FROM music_video_set_category m0_ INNER JOIN music_video_set m1_ ON m0_.id = m1_.music_video_set_category_id AND (m1_.publish = 1) INNER JOIN bind_music_video_set_item b2_ ON (b2_.music_video_set_id = m1_.id) WHERE m0_.publish = 1 AND m0_.music_video_id = ? ORDER BY m0_.actual_publish_date DESC, m0_.position ASC

Parameters:

[
  13
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.name AS name_0,
  m0_.thumbnail AS thumbnail_1,
  m0_.description AS description_2,
  m0_.updated AS updated_3,
  m0_.position AS position_4,
  m0_.id AS id_5,
  m0_.publish AS publish_6,
  m0_.actual_publish_date AS actual_publish_date_7,
  m0_.music_video_id AS music_video_id_8,
  m0_.image_to_music_video_id AS image_to_music_video_id_9
FROM
  music_video_set_category m0_
  INNER JOIN music_video_set m1_ ON m0_.id = m1_.music_video_set_category_id
  AND (m1_.publish = 1)
  INNER JOIN bind_music_video_set_item b2_ ON (b2_.music_video_set_id = m1_.id)
WHERE
  m0_.publish = 1
  AND m0_.music_video_id = ?
ORDER BY
  m0_.actual_publish_date DESC,
  m0_.position ASC

SELECT m0_.name AS name_0, m0_.thumbnail AS thumbnail_1, m0_.description AS description_2, m0_.updated AS updated_3, m0_.position AS position_4, m0_.id AS id_5, m0_.publish AS publish_6, m0_.actual_publish_date AS actual_publish_date_7, m0_.music_video_id AS music_video_id_8, m0_.image_to_music_video_id AS image_to_music_video_id_9 FROM music_video_set_category m0_ INNER JOIN music_video_set m1_ ON m0_.id = m1_.music_video_set_category_id AND (m1_.publish = 1) INNER JOIN bind_music_video_set_item b2_ ON (b2_.music_video_set_id = m1_.id) WHERE m0_.publish = 1 AND m0_.music_video_id = 13 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\MusicVideoSetCategoryRepository->getMusicVideoSetCategoriesByMusicVideoBands (line 40)
7	Mirinly\FrontBundle\Controller\MusicVideosController->isEmptyMusicVideoAssets (line 2534)
8	Mirinly\FrontBundle\Controller\MusicVideosController->musicArtistPostsAction (line 1524)
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.62 ms
(0.16%)

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

Parameters:

[
  13
]

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_
  INNER JOIN music_scene m1_ ON m0_.id = m1_.music_video_id
  AND (m1_.publish = 1)
  INNER JOIN bind_music_video_scene_item_character b2_ ON (b2_.music_scene_id = m1_.id)
WHERE
  m0_.publish = 1
  AND m0_.id = ?

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

#	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->getOneOrNullResult (line 737)
6	Mirinly\AdminBundle\Entity\MusicVideoRepository->getMusicVideoWithScenes (line 117)
7	Mirinly\FrontBundle\Controller\MusicVideosController->isEmptyMusicVideoAssets (line 2533)
8	Mirinly\FrontBundle\Controller\MusicVideosController->musicArtistPostsAction (line 1524)
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.56 ms
(0.14%)

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

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

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

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

#	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\MusicArtistMerchRepository->getMerchsPublished (line 30)
7	Mirinly\FrontBundle\Controller\MusicVideosController->isEmptyMusicVideoAssets (line 2542)
8	Mirinly\FrontBundle\Controller\MusicVideosController->musicArtistPostsAction (line 1524)
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.50 ms
(0.13%)

SELECT t0.updated AS updated_1, t0.position AS position_2, t0.id AS id_3, t0.owner_id AS owner_id_4, t0.image_id AS image_id_5 FROM image_to_music_artist t0 WHERE t0.id = ?

Parameters:

[
  65
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.updated AS updated_1,
  t0.position AS position_2,
  t0.id AS id_3,
  t0.owner_id AS owner_id_4,
  t0.image_id AS image_id_5
FROM
  image_to_music_artist t0
WHERE
  t0.id = ?

SELECT t0.updated AS updated_1, t0.position AS position_2, t0.id AS id_3, t0.owner_id AS owner_id_4, t0.image_id AS image_id_5 FROM image_to_music_artist t0 WHERE t0.id = 65;

#	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\ImageToMusicArtist::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 61)
6	Proxies\__CG__\Mirinly\AdminBundle\Entity\ImageToMusicArtist->__get (line 120)
7	Mirinly\AdminBundle\Entity\ImageToMusicArtist->getImage (line 41)
8	Mirinly\FrontBundle\Controller\MusicVideosController->musicArtistPostsAction (line 1558)
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.49 ms
(0.12%)

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_c3d781c642c38bcb866b487e6841e789->doDisplay (line 58)
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->musicArtistPostsAction (line 1635)
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.44 ms
(0.11%)

INSERT INTO music_artist_trend (points, updated, target_id) VALUES (?, ?, ?)

Parameters:

[
  1
  "2026-02-19 01:59:18"
  2
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO music_artist_trend (points, updated, target_id)
VALUES
  (?, ?, ?)

INSERT INTO music_artist_trend (points, updated, target_id) VALUES (1, '2026-02-19 01:59:18', 2);

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 133)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 253)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1060)
4	Doctrine\ORM\UnitOfWork->commit (line 403)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	Mirinly\FrontBundle\Controller\MusicVideosController->musicArtistPostsAction (line 1582)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 185)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

0.40 ms
(0.10%)

SELECT t0.name AS name_1, t0.updated AS updated_2, t0.id AS id_3, t0.position AS position_4, t0.soc_link AS soc_link_5, t0.soc_type AS soc_type_6, t0.publish AS publish_7, t0.publish_date AS publish_date_8, t0.actual_publish_date AS actual_publish_date_9, t0.music_artist_id AS music_artist_id_10, t0.image_to_music_artist_id AS image_to_music_artist_id_11 FROM music_artist_posts t0 WHERE t0.id = ? AND t0.publish = ? LIMIT 1

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.updated AS updated_2,
  t0.id AS id_3,
  t0.position AS position_4,
  t0.soc_link AS soc_link_5,
  t0.soc_type AS soc_type_6,
  t0.publish AS publish_7,
  t0.publish_date AS publish_date_8,
  t0.actual_publish_date AS actual_publish_date_9,
  t0.music_artist_id AS music_artist_id_10,
  t0.image_to_music_artist_id AS image_to_music_artist_id_11
FROM
  music_artist_posts t0
WHERE
  t0.id = ?
  AND t0.publish = ?
LIMIT
  1

SELECT t0.name AS name_1, t0.updated AS updated_2, t0.id AS id_3, t0.position AS position_4, t0.soc_link AS soc_link_5, t0.soc_type AS soc_type_6, t0.publish AS publish_7, t0.publish_date AS publish_date_8, t0.actual_publish_date AS actual_publish_date_9, t0.music_artist_id AS music_artist_id_10, t0.image_to_music_artist_id AS image_to_music_artist_id_11 FROM music_artist_posts t0 WHERE t0.id = 40 AND t0.publish = 1 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Mirinly\FrontBundle\Controller\MusicVideosController->musicArtistPostsAction (line 1600)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 185)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 29)
9	require_once (line 5)

0.33 ms
(0.08%)

SELECT t0.name AS name_1, t0.upload_name AS upload_name_2, t0.alt AS alt_3, t0.width AS width_4, t0.height AS height_5, t0.updated AS updated_6, t0.position AS position_7, t0.id AS id_8, t0.external_id AS external_id_9, t0.external_updated AS external_updated_10 FROM image t0 WHERE t0.id = ?

Parameters:

[
  371198
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.upload_name AS upload_name_2,
  t0.alt AS alt_3,
  t0.width AS width_4,
  t0.height AS height_5,
  t0.updated AS updated_6,
  t0.position AS position_7,
  t0.id AS id_8,
  t0.external_id AS external_id_9,
  t0.external_updated AS external_updated_10
FROM
  image t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.upload_name AS upload_name_2, t0.alt AS alt_3, t0.width AS width_4, t0.height AS height_5, t0.updated AS updated_6, t0.position AS position_7, t0.id AS id_8, t0.external_id AS external_id_9, t0.external_updated AS external_updated_10 FROM image t0 WHERE t0.id = 371198;

#	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\Image::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 61)
6	Proxies\__CG__\Mirinly\AdminBundle\Entity\Image->__get (line 120)
7	Mirinly\AdminBundle\Entity\Image->getName (line 155)
8	Mirinly\FrontBundle\Controller\MusicVideosController->musicArtistPostsAction (line 1558)
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.31 ms
(0.08%)

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_c3d781c642c38bcb866b487e6841e789->doDisplay (line 58)
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->musicArtistPostsAction (line 1635)
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)

0.23 ms
(0.06%)

INSERT INTO music_video_trend (points, updated, target_id) VALUES (?, ?, ?)

Parameters:

[
  1
  "2026-02-19 01:59:18"
  13
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO music_video_trend (points, updated, target_id)
VALUES
  (?, ?, ?)

INSERT INTO music_video_trend (points, updated, target_id) VALUES (1, '2026-02-19 01:59:18', 13);

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 133)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 253)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1060)
4	Doctrine\ORM\UnitOfWork->commit (line 403)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	Mirinly\FrontBundle\Controller\MusicVideosController->musicArtistPostsAction (line 1582)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 185)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

0.15 ms
(0.04%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 382)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	Mirinly\FrontBundle\Controller\MusicVideosController->musicArtistPostsAction (line 1582)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 185)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 29)
9	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\Continent	7
Mirinly\AdminBundle\Entity\MusicVideoTrend	6
Mirinly\AdminBundle\Entity\MusicVideo	5
Mirinly\AdminBundle\Entity\ImageToMusicArtist	2
Mirinly\AdminBundle\Entity\Parameters	2
Mirinly\AdminBundle\Entity\Season	1
Mirinly\AdminBundle\Entity\MusicArtist	1
Mirinly\AdminBundle\Entity\MusicArtistCharacter	1
Mirinly\AdminBundle\Entity\Artist	1
Mirinly\AdminBundle\Entity\MusicArtistPosts	1
Mirinly\AdminBundle\Entity\Image	1
Mirinly\AdminBundle\Entity\MusicArtistTrend	1
Mirinly\AdminBundle\Entity\MusicArtistCharacterTrend	1

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\UserToMusicArtist	No errors.
Mirinly\AdminBundle\Entity\MusicArtistLookBook	No errors.
Mirinly\AdminBundle\Entity\MusicArtistLookBookFolder	No errors.
Mirinly\AdminBundle\Entity\MusicArtistTrend	No errors.
Mirinly\AdminBundle\Entity\MusicArtistGuestCharacter	No errors.
Mirinly\AdminBundle\Entity\BrandApproveSeasonToMusicArtist	No errors.
Mirinly\AdminBundle\Entity\MusicArtistWallet	No errors.
Mirinly\AdminBundle\Entity\ImageToMusicVideo	No errors.
Mirinly\AdminBundle\Entity\BindMusicArtistPostItemGuestCharacter	No errors.
Mirinly\AdminBundle\Entity\MusicPerformer	No errors.
Mirinly\AdminBundle\Entity\ImageToMusicArtist	No errors.
Mirinly\AdminBundle\Entity\MusicArtistCharacterTrend	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\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\ImageToFilm	No errors.
Mirinly\AdminBundle\Entity\ImageToTvShow	No errors.
Mirinly\AdminBundle\Entity\ImageToNetwork	No errors.
Mirinly\AdminBundle\Entity\ImageToRecordLabel	No errors.
Mirinly\AdminBundle\Entity\ImageToStudio	No errors.
Mirinly\AdminBundle\Entity\Complaint	No errors.
Mirinly\AdminBundle\Entity\TvShowCharacterTrend	No errors.
Mirinly\AdminBundle\Entity\ECommerceItemTrend	No errors.
Mirinly\AdminBundle\Entity\ECommerceItemSettingsDiscovery	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.
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\ApproveProductionMusicArtist	No errors.
Mirinly\AdminBundle\Entity\RecordLabelMerch	No errors.
Mirinly\AdminBundle\Entity\RecordLabelPosts	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\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\ItemToBrandImage	No errors.
Mirinly\AdminBundle\Entity\Cart	No errors.
Mirinly\AdminBundle\Entity\VariationSetParam	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\TvShowEpisodeTrend	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.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping