Symfony Profiler

Query Metrics

12 Database Queries

11 Different statements

24.02 ms Query time

24 Invalid entities

403 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

12.49 ms
(51.98%)

SELECT c0_.session_id AS session_id_0, c0_.quantity AS quantity_1, c0_.id AS id_2, c0_.item_id AS item_id_3, c0_.size_id AS size_id_4, c0_.color_id AS color_id_5 FROM customers_cart c0_ INNER JOIN e_commerce_item e1_ ON (c0_.item_id = e1_.id) LEFT JOIN bind_film_scene_item_character b2_ ON (b2_.e_commerce_item_id = e1_.id) LEFT JOIN bind_film_character_signature_item b3_ ON (b3_.e_commerce_item_id = e1_.id) LEFT JOIN bind_film_set_item b4_ ON (b4_.e_commerce_item_id = e1_.id) LEFT JOIN bind_film_merch b5_ ON (b5_.e_commerce_item_id = e1_.id) LEFT JOIN bind_film_post_item_character b6_ ON (b6_.e_commerce_item_id = e1_.id) LEFT JOIN film_scene f7_ ON b2_.film_scene_id = f7_.id AND (f7_.publish = 1) LEFT JOIN film_character_signature f8_ ON b3_.film_character_signature_id = f8_.id LEFT JOIN film_character f9_ ON f8_.character_id = f9_.id LEFT JOIN film_set f10_ ON b4_.film_set_id = f10_.id AND (f10_.publish = 1) LEFT JOIN film_set_category f11_ ON f10_.film_set_category_id = f11_.id AND (f11_.publish = 1) LEFT JOIN film_merch f12_ ON b5_.film_merch_id = f12_.id LEFT JOIN film_posts f13_ ON b6_.film_post_id = f13_.id LEFT JOIN film f14_ ON (f14_.id = f7_.film_id OR f14_.id = f9_.film_id OR f14_.id = f11_.film_id OR f14_.id = f12_.film_id OR f14_.id = f13_.film_id) LEFT JOIN bind_tv_show_scene_item_character b15_ ON (b15_.e_commerce_item_id = e1_.id) LEFT JOIN bind_tv_show_character_signature_item b16_ ON (b16_.e_commerce_item_id = e1_.id) LEFT JOIN bind_tv_show_set_item b17_ ON (b17_.e_commerce_item_id = e1_.id) LEFT JOIN bind_tv_show_merch b18_ ON (b18_.e_commerce_item_id = e1_.id) LEFT JOIN bind_tv_show_post_item_character b19_ ON (b19_.e_commerce_item_id = e1_.id) LEFT JOIN tv_show_scene t20_ ON b15_.tv_show_scene_id = t20_.id AND (t20_.publish = 1) LEFT JOIN tv_show_episode t21_ ON t20_.tv_show_episode_id = t21_.id AND (t21_.publish = 1) LEFT JOIN tv_show_season t22_ ON t21_.tv_show_season_id = t22_.id AND (t22_.publish = 1) LEFT JOIN tv_show_character_signature t23_ ON b16_.tv_show_character_signature_id = t23_.id AND (t23_.publish = 1) LEFT JOIN tv_show_character t24_ ON t23_.character_id = t24_.id LEFT JOIN tv_show_set t25_ ON b17_.tv_show_set_id = t25_.id AND (t25_.publish = 1) LEFT JOIN tv_show_set_category t26_ ON t25_.tv_show_set_category_id = t26_.id AND (t26_.publish = 1) LEFT JOIN tv_show_merch t27_ ON b18_.tv_show_merch_id = t27_.id AND (t27_.publish = 1) LEFT JOIN tv_show_posts t28_ ON b19_.tv_show_post_id = t28_.id AND (t28_.publish = 1) LEFT JOIN tv_show t29_ ON (t29_.id = t22_.tv_show_id OR t29_.id = t24_.tv_show_id OR t29_.id = t26_.tv_show_id OR t29_.id = t27_.tv_show_id OR t29_.id = t28_.tv_show_id) LEFT JOIN bind_music_video_scene_item_character b30_ ON (b30_.e_commerce_item_id = e1_.id) LEFT JOIN bind_music_video_character_signature_item b31_ ON (b31_.e_commerce_item_id = e1_.id) LEFT JOIN bind_music_video_set_item b32_ ON (b32_.e_commerce_item_id = e1_.id) LEFT JOIN music_scene m33_ ON b30_.music_scene_id = m33_.id AND (m33_.publish = 1) LEFT JOIN music_video_character_signature m34_ ON b31_.music_video_character_signature_id = m34_.id LEFT JOIN music_video_character m35_ ON m34_.character_id = m35_.id LEFT JOIN music_video_set m36_ ON b32_.music_video_set_id = m36_.id AND (m36_.publish = 1) LEFT JOIN music_video_set_category m37_ ON m36_.music_video_set_category_id = m37_.id AND (m37_.publish = 1) LEFT JOIN music_video m38_ ON (m38_.id = m33_.music_video_id OR m38_.id = m35_.music_video_id OR m38_.id = m37_.music_video_id) LEFT JOIN music_artist_to_music_video m40_ ON m38_.id = m40_.music_video_id LEFT JOIN music_artist m39_ ON m39_.id = m40_.music_artist_id LEFT JOIN bind_music_artist_merch b41_ ON (b41_.e_commerce_item_id = e1_.id) LEFT JOIN music_artist_merch m42_ ON b41_.music_artist_merch_id = m42_.id AND (m42_.publish = 1) LEFT JOIN bind_music_artist_post_item_character b43_ ON (b43_.e_commerce_item_id = e1_.id) LEFT JOIN music_artist_posts m44_ ON b43_.music_artist_post_id = m44_.id AND (m44_.publish = 1) LEFT JOIN bind_music_artist_post_item_guest_character b45_ ON (b45_.e_commerce_item_id = e1_.id) LEFT JOIN music_artist_posts m46_ ON b45_.music_artist_post_id = m46_.id AND (m46_.publish = 1) LEFT JOIN music_artist m47_ ON (m47_.id = m42_.music_artist_id OR m47_.id = m44_.music_artist_id OR m47_.id = m46_.music_artist_id) WHERE (f14_.publish = 1 OR t29_.publish = 1 OR (m38_.publish = 1 AND m39_.publish = 1) OR m47_.publish = 1) AND c0_.session_id = ? GROUP BY c0_.session_id, c0_.quantity, c0_.id, c0_.item_id, c0_.size_id, c0_.color_id ORDER BY c0_.id DESC

Parameters:

[
  "ff40sqkdpujm4orol2nfmdvdan"
]

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 = 'ff40sqkdpujm4orol2nfmdvdan' 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_474dfe10498a035a09d55974b3c7d50d->doDisplay (line 54)
18	Twig\Template->yield (line 402)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 373)
21	Twig\TemplateWrapper->render (line 51)
22	Twig\Environment->render (line 333)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
26	Mirinly\FrontBundle\Controller\GenieController->showAdminWishlistAction (line 915)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 185)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 29)
32	require_once (line 5)

3.84 ms
(15.98%)

SELECT a0_.id AS id_0, a0_.updated AS updated_1, a0_.admin_wishlist_id AS admin_wishlist_id_2, a0_.item_id AS item_id_3 FROM admin_wishlist_item a0_ LEFT JOIN e_commerce_item e1_ ON a0_.item_id = e1_.id LEFT JOIN admin_wishlist a2_ ON a0_.admin_wishlist_id = a2_.id LEFT JOIN bind_film_scene_item_character b3_ ON (b3_.e_commerce_item_id = e1_.id) LEFT JOIN bind_film_character_signature_item b4_ ON (b4_.e_commerce_item_id = e1_.id) LEFT JOIN bind_film_set_item b5_ ON (b5_.e_commerce_item_id = e1_.id) LEFT JOIN bind_film_merch b6_ ON (b6_.e_commerce_item_id = e1_.id) LEFT JOIN bind_film_post_item_character b7_ ON (b7_.e_commerce_item_id = e1_.id) LEFT JOIN film_scene f8_ ON b3_.film_scene_id = f8_.id AND (f8_.publish = 1) LEFT JOIN film_character_signature f9_ ON b4_.film_character_signature_id = f9_.id LEFT JOIN film_character f10_ ON f9_.character_id = f10_.id LEFT JOIN film_set f11_ ON b5_.film_set_id = f11_.id AND (f11_.publish = 1) LEFT JOIN film_set_category f12_ ON f11_.film_set_category_id = f12_.id AND (f12_.publish = 1) LEFT JOIN film_merch f13_ ON b6_.film_merch_id = f13_.id AND (f13_.publish = 1) LEFT JOIN film_posts f14_ ON b7_.film_post_id = f14_.id AND (f14_.publish = 1) LEFT JOIN film f15_ ON (f15_.id = f8_.film_id OR f15_.id = f10_.film_id OR f15_.id = f12_.film_id OR f15_.id = f13_.film_id OR f15_.id = f14_.film_id) LEFT JOIN bind_tv_show_scene_item_character b16_ ON (b16_.e_commerce_item_id = e1_.id) LEFT JOIN bind_tv_show_character_signature_item b17_ ON (b17_.e_commerce_item_id = e1_.id) LEFT JOIN bind_tv_show_set_item b18_ ON (b18_.e_commerce_item_id = e1_.id) LEFT JOIN bind_tv_show_merch b19_ ON (b19_.e_commerce_item_id = e1_.id) LEFT JOIN bind_tv_show_post_item_character b20_ ON (b20_.e_commerce_item_id = e1_.id) LEFT JOIN tv_show_scene t21_ ON b16_.tv_show_scene_id = t21_.id AND (t21_.publish = 1) LEFT JOIN tv_show_episode t22_ ON t21_.tv_show_episode_id = t22_.id AND (t22_.publish = 1) LEFT JOIN tv_show_season t23_ ON t22_.tv_show_season_id = t23_.id AND (t23_.publish = 1) LEFT JOIN tv_show_character_signature t24_ ON b17_.tv_show_character_signature_id = t24_.id AND (t24_.publish = 1) LEFT JOIN tv_show_character t25_ ON t24_.character_id = t25_.id LEFT JOIN tv_show_set t26_ ON b18_.tv_show_set_id = t26_.id AND (t26_.publish = 1) LEFT JOIN tv_show_set_category t27_ ON t26_.tv_show_set_category_id = t27_.id AND (t27_.publish = 1) LEFT JOIN tv_show_merch t28_ ON b19_.tv_show_merch_id = t28_.id AND (t28_.publish = 1) LEFT JOIN tv_show_posts t29_ ON b20_.tv_show_post_id = t29_.id AND (t29_.publish = 1) LEFT JOIN tv_show t30_ ON (t30_.id = t23_.tv_show_id OR t30_.id = t25_.tv_show_id OR t30_.id = t27_.tv_show_id OR t30_.id = t28_.tv_show_id OR t30_.id = t29_.tv_show_id) LEFT JOIN bind_music_video_scene_item_character b31_ ON (b31_.e_commerce_item_id = e1_.id) LEFT JOIN bind_music_video_character_signature_item b32_ ON (b32_.e_commerce_item_id = e1_.id) LEFT JOIN bind_music_video_set_item b33_ ON (b33_.e_commerce_item_id = e1_.id) LEFT JOIN music_scene m34_ ON b31_.music_scene_id = m34_.id AND (m34_.publish = 1) LEFT JOIN music_video_character_signature m35_ ON b32_.music_video_character_signature_id = m35_.id LEFT JOIN music_video_character m36_ ON m35_.character_id = m36_.id LEFT JOIN music_video_set m37_ ON b33_.music_video_set_id = m37_.id AND (m37_.publish = 1) LEFT JOIN music_video_set_category m38_ ON m37_.music_video_set_category_id = m38_.id AND (m38_.publish = 1) LEFT JOIN music_video m39_ ON (m39_.id = m34_.music_video_id OR m39_.id = m36_.music_video_id OR m39_.id = m38_.music_video_id) LEFT JOIN music_artist_to_music_video m41_ ON m39_.id = m41_.music_video_id LEFT JOIN music_artist m40_ ON m40_.id = m41_.music_artist_id LEFT JOIN bind_music_artist_merch b42_ ON (b42_.e_commerce_item_id = e1_.id) LEFT JOIN music_artist_merch m43_ ON b42_.music_artist_merch_id = m43_.id AND (m43_.publish = 1) LEFT JOIN bind_music_artist_post_item_character b44_ ON (b44_.e_commerce_item_id = e1_.id) LEFT JOIN music_artist_posts m45_ ON b44_.music_artist_post_id = m45_.id AND (m45_.publish = 1) LEFT JOIN bind_music_artist_post_item_guest_character b46_ ON (b46_.e_commerce_item_id = e1_.id) LEFT JOIN music_artist_posts m47_ ON b46_.music_artist_post_id = m47_.id AND (m47_.publish = 1) LEFT JOIN music_artist m48_ ON (m48_.id = m43_.music_artist_id OR m48_.id = m45_.music_artist_id OR m48_.id = m47_.music_artist_id) INNER JOIN e_commerce_item_settings_discovery e49_ ON e1_.id = e49_.item_id AND (e49_.discovery = 1 AND e49_.quantity_update <> 0) WHERE (f15_.publish = 1 OR t30_.publish = 1 OR (m39_.publish = 1 AND m40_.publish = 1) OR m48_.publish = 1) AND e1_.removed = 0 AND a0_.admin_wishlist_id = ? GROUP BY e1_.name, e1_.sku, e1_.price_on_mirinly, e1_.msrp, e1_.sale_price, e1_.available_from_samples, e1_.available_from_mirinly, e1_.available, e1_.affiliate_url, e1_.thumbnail, e1_.additional_image_1, e1_.additional_image_2, e1_.additional_image_3, e1_.additional_image_4, e1_.sizeGuide, e1_.description, e1_.position, e1_.id, e1_.featured, e1_.sponsored_global, e1_.sponsored_category, e1_.sponsored_sub_category, e1_.based_in, e1_.other_sizes_colors, e1_.measurement_type, e1_.insurance_type, e1_.insurance, e1_.reasonable_wear_and_tear, e1_.low_volume_production, e1_.shipping_policy, e1_.return_policy, e1_.care, e1_.created, e1_.enable_shopify_sync, e1_.enable_squarecpase_sync, e1_.imported, e1_.removed, e1_.once_assigned, e1_.default_cities, e1_.default_search_tags, e1_.external_id, e1_.finalized_date, e1_.e_commerce_subcategory_id, e1_.e_commerce_item_type_id, e1_.e_commerce_item_template_id, e1_.brand_id, e1_.main_image_id

Parameters:

[
  401
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.updated AS updated_1,
  a0_.admin_wishlist_id AS admin_wishlist_id_2,
  a0_.item_id AS item_id_3
FROM
  admin_wishlist_item a0_
  LEFT JOIN e_commerce_item e1_ ON a0_.item_id = e1_.id
  LEFT JOIN admin_wishlist a2_ ON a0_.admin_wishlist_id = a2_.id
  LEFT JOIN bind_film_scene_item_character b3_ ON (b3_.e_commerce_item_id = e1_.id)
  LEFT JOIN bind_film_character_signature_item b4_ ON (b4_.e_commerce_item_id = e1_.id)
  LEFT JOIN bind_film_set_item b5_ ON (b5_.e_commerce_item_id = e1_.id)
  LEFT JOIN bind_film_merch b6_ ON (b6_.e_commerce_item_id = e1_.id)
  LEFT JOIN bind_film_post_item_character b7_ ON (b7_.e_commerce_item_id = e1_.id)
  LEFT JOIN film_scene f8_ ON b3_.film_scene_id = f8_.id
  AND (f8_.publish = 1)
  LEFT JOIN film_character_signature f9_ ON b4_.film_character_signature_id = f9_.id
  LEFT JOIN film_character f10_ ON f9_.character_id = f10_.id
  LEFT JOIN film_set f11_ ON b5_.film_set_id = f11_.id
  AND (f11_.publish = 1)
  LEFT JOIN film_set_category f12_ ON f11_.film_set_category_id = f12_.id
  AND (f12_.publish = 1)
  LEFT JOIN film_merch f13_ ON b6_.film_merch_id = f13_.id
  AND (f13_.publish = 1)
  LEFT JOIN film_posts f14_ ON b7_.film_post_id = f14_.id
  AND (f14_.publish = 1)
  LEFT JOIN film f15_ ON (
    f15_.id = f8_.film_id
    OR f15_.id = f10_.film_id
    OR f15_.id = f12_.film_id
    OR f15_.id = f13_.film_id
    OR f15_.id = f14_.film_id
  )
  LEFT JOIN bind_tv_show_scene_item_character b16_ ON (b16_.e_commerce_item_id = e1_.id)
  LEFT JOIN bind_tv_show_character_signature_item b17_ ON (b17_.e_commerce_item_id = e1_.id)
  LEFT JOIN bind_tv_show_set_item b18_ ON (b18_.e_commerce_item_id = e1_.id)
  LEFT JOIN bind_tv_show_merch b19_ ON (b19_.e_commerce_item_id = e1_.id)
  LEFT JOIN bind_tv_show_post_item_character b20_ ON (b20_.e_commerce_item_id = e1_.id)
  LEFT JOIN tv_show_scene t21_ ON b16_.tv_show_scene_id = t21_.id
  AND (t21_.publish = 1)
  LEFT JOIN tv_show_episode t22_ ON t21_.tv_show_episode_id = t22_.id
  AND (t22_.publish = 1)
  LEFT JOIN tv_show_season t23_ ON t22_.tv_show_season_id = t23_.id
  AND (t23_.publish = 1)
  LEFT JOIN tv_show_character_signature t24_ ON b17_.tv_show_character_signature_id = t24_.id
  AND (t24_.publish = 1)
  LEFT JOIN tv_show_character t25_ ON t24_.character_id = t25_.id
  LEFT JOIN tv_show_set t26_ ON b18_.tv_show_set_id = t26_.id
  AND (t26_.publish = 1)
  LEFT JOIN tv_show_set_category t27_ ON t26_.tv_show_set_category_id = t27_.id
  AND (t27_.publish = 1)
  LEFT JOIN tv_show_merch t28_ ON b19_.tv_show_merch_id = t28_.id
  AND (t28_.publish = 1)
  LEFT JOIN tv_show_posts t29_ ON b20_.tv_show_post_id = t29_.id
  AND (t29_.publish = 1)
  LEFT JOIN tv_show t30_ ON (
    t30_.id = t23_.tv_show_id
    OR t30_.id = t25_.tv_show_id
    OR t30_.id = t27_.tv_show_id
    OR t30_.id = t28_.tv_show_id
    OR t30_.id = t29_.tv_show_id
  )
  LEFT JOIN bind_music_video_scene_item_character b31_ ON (b31_.e_commerce_item_id = e1_.id)
  LEFT JOIN bind_music_video_character_signature_item b32_ ON (b32_.e_commerce_item_id = e1_.id)
  LEFT JOIN bind_music_video_set_item b33_ ON (b33_.e_commerce_item_id = e1_.id)
  LEFT JOIN music_scene m34_ ON b31_.music_scene_id = m34_.id
  AND (m34_.publish = 1)
  LEFT JOIN music_video_character_signature m35_ ON b32_.music_video_character_signature_id = m35_.id
  LEFT JOIN music_video_character m36_ ON m35_.character_id = m36_.id
  LEFT JOIN music_video_set m37_ ON b33_.music_video_set_id = m37_.id
  AND (m37_.publish = 1)
  LEFT JOIN music_video_set_category m38_ ON m37_.music_video_set_category_id = m38_.id
  AND (m38_.publish = 1)
  LEFT JOIN music_video m39_ ON (
    m39_.id = m34_.music_video_id
    OR m39_.id = m36_.music_video_id
    OR m39_.id = m38_.music_video_id
  )
  LEFT JOIN music_artist_to_music_video m41_ ON m39_.id = m41_.music_video_id
  LEFT JOIN music_artist m40_ ON m40_.id = m41_.music_artist_id
  LEFT JOIN bind_music_artist_merch b42_ ON (b42_.e_commerce_item_id = e1_.id)
  LEFT JOIN music_artist_merch m43_ ON b42_.music_artist_merch_id = m43_.id
  AND (m43_.publish = 1)
  LEFT JOIN bind_music_artist_post_item_character b44_ ON (b44_.e_commerce_item_id = e1_.id)
  LEFT JOIN music_artist_posts m45_ ON b44_.music_artist_post_id = m45_.id
  AND (m45_.publish = 1)
  LEFT JOIN bind_music_artist_post_item_guest_character b46_ ON (b46_.e_commerce_item_id = e1_.id)
  LEFT JOIN music_artist_posts m47_ ON b46_.music_artist_post_id = m47_.id
  AND (m47_.publish = 1)
  LEFT JOIN music_artist m48_ ON (
    m48_.id = m43_.music_artist_id
    OR m48_.id = m45_.music_artist_id
    OR m48_.id = m47_.music_artist_id
  )
  INNER JOIN e_commerce_item_settings_discovery e49_ ON e1_.id = e49_.item_id
  AND (
    e49_.discovery = 1
    AND e49_.quantity_update <> 0
  )
WHERE
  (
    f15_.publish = 1
    OR t30_.publish = 1
    OR (
      m39_.publish = 1
      AND m40_.publish = 1
    )
    OR m48_.publish = 1
  )
  AND e1_.removed = 0
  AND a0_.admin_wishlist_id = ?
GROUP BY
  e1_.name,
  e1_.sku,
  e1_.price_on_mirinly,
  e1_.msrp,
  e1_.sale_price,
  e1_.available_from_samples,
  e1_.available_from_mirinly,
  e1_.available,
  e1_.affiliate_url,
  e1_.thumbnail,
  e1_.additional_image_1,
  e1_.additional_image_2,
  e1_.additional_image_3,
  e1_.additional_image_4,
  e1_.sizeGuide,
  e1_.description,
  e1_.position,
  e1_.id,
  e1_.featured,
  e1_.sponsored_global,
  e1_.sponsored_category,
  e1_.sponsored_sub_category,
  e1_.based_in,
  e1_.other_sizes_colors,
  e1_.measurement_type,
  e1_.insurance_type,
  e1_.insurance,
  e1_.reasonable_wear_and_tear,
  e1_.low_volume_production,
  e1_.shipping_policy,
  e1_.return_policy,
  e1_.care,
  e1_.created,
  e1_.enable_shopify_sync,
  e1_.enable_squarecpase_sync,
  e1_.imported,
  e1_.removed,
  e1_.once_assigned,
  e1_.default_cities,
  e1_.default_search_tags,
  e1_.external_id,
  e1_.finalized_date,
  e1_.e_commerce_subcategory_id,
  e1_.e_commerce_item_type_id,
  e1_.e_commerce_item_template_id,
  e1_.brand_id,
  e1_.main_image_id

SELECT a0_.id AS id_0, a0_.updated AS updated_1, a0_.admin_wishlist_id AS admin_wishlist_id_2, a0_.item_id AS item_id_3 FROM admin_wishlist_item a0_ LEFT JOIN e_commerce_item e1_ ON a0_.item_id = e1_.id LEFT JOIN admin_wishlist a2_ ON a0_.admin_wishlist_id = a2_.id LEFT JOIN bind_film_scene_item_character b3_ ON (b3_.e_commerce_item_id = e1_.id) LEFT JOIN bind_film_character_signature_item b4_ ON (b4_.e_commerce_item_id = e1_.id) LEFT JOIN bind_film_set_item b5_ ON (b5_.e_commerce_item_id = e1_.id) LEFT JOIN bind_film_merch b6_ ON (b6_.e_commerce_item_id = e1_.id) LEFT JOIN bind_film_post_item_character b7_ ON (b7_.e_commerce_item_id = e1_.id) LEFT JOIN film_scene f8_ ON b3_.film_scene_id = f8_.id AND (f8_.publish = 1) LEFT JOIN film_character_signature f9_ ON b4_.film_character_signature_id = f9_.id LEFT JOIN film_character f10_ ON f9_.character_id = f10_.id LEFT JOIN film_set f11_ ON b5_.film_set_id = f11_.id AND (f11_.publish = 1) LEFT JOIN film_set_category f12_ ON f11_.film_set_category_id = f12_.id AND (f12_.publish = 1) LEFT JOIN film_merch f13_ ON b6_.film_merch_id = f13_.id AND (f13_.publish = 1) LEFT JOIN film_posts f14_ ON b7_.film_post_id = f14_.id AND (f14_.publish = 1) LEFT JOIN film f15_ ON (f15_.id = f8_.film_id OR f15_.id = f10_.film_id OR f15_.id = f12_.film_id OR f15_.id = f13_.film_id OR f15_.id = f14_.film_id) LEFT JOIN bind_tv_show_scene_item_character b16_ ON (b16_.e_commerce_item_id = e1_.id) LEFT JOIN bind_tv_show_character_signature_item b17_ ON (b17_.e_commerce_item_id = e1_.id) LEFT JOIN bind_tv_show_set_item b18_ ON (b18_.e_commerce_item_id = e1_.id) LEFT JOIN bind_tv_show_merch b19_ ON (b19_.e_commerce_item_id = e1_.id) LEFT JOIN bind_tv_show_post_item_character b20_ ON (b20_.e_commerce_item_id = e1_.id) LEFT JOIN tv_show_scene t21_ ON b16_.tv_show_scene_id = t21_.id AND (t21_.publish = 1) LEFT JOIN tv_show_episode t22_ ON t21_.tv_show_episode_id = t22_.id AND (t22_.publish = 1) LEFT JOIN tv_show_season t23_ ON t22_.tv_show_season_id = t23_.id AND (t23_.publish = 1) LEFT JOIN tv_show_character_signature t24_ ON b17_.tv_show_character_signature_id = t24_.id AND (t24_.publish = 1) LEFT JOIN tv_show_character t25_ ON t24_.character_id = t25_.id LEFT JOIN tv_show_set t26_ ON b18_.tv_show_set_id = t26_.id AND (t26_.publish = 1) LEFT JOIN tv_show_set_category t27_ ON t26_.tv_show_set_category_id = t27_.id AND (t27_.publish = 1) LEFT JOIN tv_show_merch t28_ ON b19_.tv_show_merch_id = t28_.id AND (t28_.publish = 1) LEFT JOIN tv_show_posts t29_ ON b20_.tv_show_post_id = t29_.id AND (t29_.publish = 1) LEFT JOIN tv_show t30_ ON (t30_.id = t23_.tv_show_id OR t30_.id = t25_.tv_show_id OR t30_.id = t27_.tv_show_id OR t30_.id = t28_.tv_show_id OR t30_.id = t29_.tv_show_id) LEFT JOIN bind_music_video_scene_item_character b31_ ON (b31_.e_commerce_item_id = e1_.id) LEFT JOIN bind_music_video_character_signature_item b32_ ON (b32_.e_commerce_item_id = e1_.id) LEFT JOIN bind_music_video_set_item b33_ ON (b33_.e_commerce_item_id = e1_.id) LEFT JOIN music_scene m34_ ON b31_.music_scene_id = m34_.id AND (m34_.publish = 1) LEFT JOIN music_video_character_signature m35_ ON b32_.music_video_character_signature_id = m35_.id LEFT JOIN music_video_character m36_ ON m35_.character_id = m36_.id LEFT JOIN music_video_set m37_ ON b33_.music_video_set_id = m37_.id AND (m37_.publish = 1) LEFT JOIN music_video_set_category m38_ ON m37_.music_video_set_category_id = m38_.id AND (m38_.publish = 1) LEFT JOIN music_video m39_ ON (m39_.id = m34_.music_video_id OR m39_.id = m36_.music_video_id OR m39_.id = m38_.music_video_id) LEFT JOIN music_artist_to_music_video m41_ ON m39_.id = m41_.music_video_id LEFT JOIN music_artist m40_ ON m40_.id = m41_.music_artist_id LEFT JOIN bind_music_artist_merch b42_ ON (b42_.e_commerce_item_id = e1_.id) LEFT JOIN music_artist_merch m43_ ON b42_.music_artist_merch_id = m43_.id AND (m43_.publish = 1) LEFT JOIN bind_music_artist_post_item_character b44_ ON (b44_.e_commerce_item_id = e1_.id) LEFT JOIN music_artist_posts m45_ ON b44_.music_artist_post_id = m45_.id AND (m45_.publish = 1) LEFT JOIN bind_music_artist_post_item_guest_character b46_ ON (b46_.e_commerce_item_id = e1_.id) LEFT JOIN music_artist_posts m47_ ON b46_.music_artist_post_id = m47_.id AND (m47_.publish = 1) LEFT JOIN music_artist m48_ ON (m48_.id = m43_.music_artist_id OR m48_.id = m45_.music_artist_id OR m48_.id = m47_.music_artist_id) INNER JOIN e_commerce_item_settings_discovery e49_ ON e1_.id = e49_.item_id AND (e49_.discovery = 1 AND e49_.quantity_update <> 0) WHERE (f15_.publish = 1 OR t30_.publish = 1 OR (m39_.publish = 1 AND m40_.publish = 1) OR m48_.publish = 1) AND e1_.removed = 0 AND a0_.admin_wishlist_id = 401 GROUP BY e1_.name, e1_.sku, e1_.price_on_mirinly, e1_.msrp, e1_.sale_price, e1_.available_from_samples, e1_.available_from_mirinly, e1_.available, e1_.affiliate_url, e1_.thumbnail, e1_.additional_image_1, e1_.additional_image_2, e1_.additional_image_3, e1_.additional_image_4, e1_.sizeGuide, e1_.description, e1_.position, e1_.id, e1_.featured, e1_.sponsored_global, e1_.sponsored_category, e1_.sponsored_sub_category, e1_.based_in, e1_.other_sizes_colors, e1_.measurement_type, e1_.insurance_type, e1_.insurance, e1_.reasonable_wear_and_tear, e1_.low_volume_production, e1_.shipping_policy, e1_.return_policy, e1_.care, e1_.created, e1_.enable_shopify_sync, e1_.enable_squarecpase_sync, e1_.imported, e1_.removed, e1_.once_assigned, e1_.default_cities, e1_.default_search_tags, e1_.external_id, e1_.finalized_date, e1_.e_commerce_subcategory_id, e1_.e_commerce_item_type_id, e1_.e_commerce_item_template_id, e1_.brand_id, e1_.main_image_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->getResult (line 688)
6	Mirinly\AdminBundle\Entity\AdminWishlistItemRepository->getAdminWishlistItemsByWishlist (line 80)
7	Mirinly\FrontBundle\Controller\GenieController->showAdminWishlistAction (line 850)
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)

2.39 ms
(9.96%)

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_474dfe10498a035a09d55974b3c7d50d->doDisplay (line 54)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
22	Mirinly\FrontBundle\Controller\GenieController->showAdminWishlistAction (line 915)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 185)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

1.92 ms
(8.00%)

"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\GenieController->showAdminWishlistAction (line 900)
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.83 ms
(3.47%)

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_474dfe10498a035a09d55974b3c7d50d->doDisplay (line 54)
15	Twig\Template->yield (line 402)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 373)
18	Twig\TemplateWrapper->render (line 51)
19	Twig\Environment->render (line 333)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
23	Mirinly\FrontBundle\Controller\GenieController->showAdminWishlistAction (line 915)
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.74 ms
(3.07%)

SELECT t0.id AS id_1, t0.publish AS publish_2, t0.name AS name_3, t0.owner_id AS owner_id_4, t0.owner_type AS owner_type_5, t0.tags AS tags_6, t0.published AS published_7 FROM admin_wishlist t0 WHERE t0.owner_type = ? ORDER BY t0.published DESC LIMIT 5

Parameters:

[
  "zeitgeist"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.publish AS publish_2,
  t0.name AS name_3,
  t0.owner_id AS owner_id_4,
  t0.owner_type AS owner_type_5,
  t0.tags AS tags_6,
  t0.published AS published_7
FROM
  admin_wishlist t0
WHERE
  t0.owner_type = ?
ORDER BY
  t0.published DESC
LIMIT
  5

SELECT t0.id AS id_1, t0.publish AS publish_2, t0.name AS name_3, t0.owner_id AS owner_id_4, t0.owner_type AS owner_type_5, t0.tags AS tags_6, t0.published AS published_7 FROM admin_wishlist t0 WHERE t0.owner_type = 'zeitgeist' ORDER BY t0.published DESC LIMIT 5;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Mirinly\FrontBundle\Controller\GenieController->showAdminWishlistAction (line 827)
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.49 ms
(2.02%)

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_474dfe10498a035a09d55974b3c7d50d->doDisplay (line 54)
15	Twig\Template->yield (line 402)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 373)
18	Twig\TemplateWrapper->render (line 51)
19	Twig\Environment->render (line 333)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
23	Mirinly\FrontBundle\Controller\GenieController->showAdminWishlistAction (line 915)
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.39 ms
(1.62%)

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 WHERE t0.currency_code = ? LIMIT 1

Parameters:

[
  "USD"
]

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
WHERE
  t0.currency_code = ?
LIMIT
  1

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 WHERE t0.currency_code = 'USD' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Mirinly\FrontBundle\Controller\GenieController->showAdminWishlistAction (line 909)
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.34 ms
(1.42%)

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

Parameters:

[
  1
  "2026-02-19 00:31:37"
  401
]

View formatted query View runnable query Explain query View query backtrace

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

INSERT INTO admin_wishlist_trend (points, updated, target_id) VALUES (1, '2026-02-19 00:31:37', 401);

#	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\GenieController->showAdminWishlistAction (line 900)
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.33 ms
(1.39%)

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_474dfe10498a035a09d55974b3c7d50d->doDisplay (line 54)
18	Twig\Template->yield (line 402)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 373)
21	Twig\TemplateWrapper->render (line 51)
22	Twig\Environment->render (line 333)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
26	Mirinly\FrontBundle\Controller\GenieController->showAdminWishlistAction (line 915)
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.26 ms
(1.07%)

"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\GenieController->showAdminWishlistAction (line 900)
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\AdminWishlist	5
Mirinly\AdminBundle\Entity\Parameters	2
Mirinly\AdminBundle\Entity\AdminWishlistItem	1
Mirinly\AdminBundle\Entity\ECommerceItem	1
Mirinly\AdminBundle\Entity\AdminWishlistTrend	1

Entities Mapping

Class	Mapping errors
Mirinly\AdminBundle\Entity\AdminWishlist	No errors.
Mirinly\AdminBundle\Entity\AdminWishlistItem	No errors.
Mirinly\AdminBundle\Entity\AdminWishlistTrend	No errors.
Mirinly\AdminBundle\Entity\WishlistFollow	No errors.
Mirinly\AdminBundle\Entity\AbstractEntity	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\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\BindMusicVideoSceneItemCharacter	No errors.
Mirinly\AdminBundle\Entity\BindMusicVideoCharacterSignatureItem	No errors.
Mirinly\AdminBundle\Entity\BindMusicVideoSetItem	No errors.
Mirinly\AdminBundle\Entity\MusicScene	No errors.
Mirinly\AdminBundle\Entity\MusicVideoCharacterSignature	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\MusicVideoSet	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\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\BindMusicArtistMerch	No errors.
Mirinly\AdminBundle\Entity\MusicArtistMerch	No errors.
Mirinly\AdminBundle\Entity\BindMusicArtistPostItemCharacter	No errors.
Mirinly\AdminBundle\Entity\MusicArtistPosts	No errors.
Mirinly\AdminBundle\Entity\BindMusicArtistPostItemGuestCharacter	No errors.
Mirinly\AdminBundle\Entity\ECommerceItemSettingsDiscovery	No errors.
Mirinly\AdminBundle\Entity\Currency	No errors.
Mirinly\AdminBundle\Entity\Country	No errors.
Mirinly\AdminBundle\Entity\CustomersCart	No errors.
Mirinly\AdminBundle\Entity\Size	No errors.
Mirinly\AdminBundle\Entity\ItemColor	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\Wishlist	No errors.
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\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\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\Season	No errors.
Mirinly\AdminBundle\Entity\ImageToBrand	The field Mirinly\AdminBundle\Entity\ImageToBrand#itemToBrandImage is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\ItemToBrandImage#imageToBrand does not contain the required 'inversedBy: "itemToBrandImage"' attribute. The field Mirinly\AdminBundle\Entity\ImageToBrand#eCommerceItemsMainImage is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\ECommerceItem#mainImage does not contain the required 'inversedBy: "eCommerceItemsMainImage"' attribute.
Mirinly\AdminBundle\Entity\ApproveProductionTvShow	No errors.
Mirinly\AdminBundle\Entity\ApproveProductionFilm	No errors.
Mirinly\AdminBundle\Entity\ApproveProductionMusicVideo	No errors.
Mirinly\AdminBundle\Entity\ApproveProductionMusicArtist	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\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\ApproveProductionEditorial	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\ECommerceItemTrend	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\ImageToFilm	No errors.
Mirinly\AdminBundle\Entity\FilmCharacterTrend	No errors.
Mirinly\AdminBundle\Entity\Artist	No errors.
Mirinly\AdminBundle\Entity\FilmSetTrend	No errors.
Mirinly\AdminBundle\Entity\UserToFilm	No errors.
Mirinly\AdminBundle\Entity\Director	No errors.
Mirinly\AdminBundle\Entity\Producer	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\EpkAttachmentToProduction	No errors.
Mirinly\AdminBundle\Entity\EpkAttachmentLinkToProduction	No errors.
Mirinly\AdminBundle\Entity\LookBookAttachmentToProduction	No errors.
Mirinly\AdminBundle\Entity\LookBookAttachmentLinkToProduction	No errors.
Mirinly\AdminBundle\Entity\FilmWallet	No errors.
Mirinly\AdminBundle\Entity\ImageToTvShow	No errors.
Mirinly\AdminBundle\Entity\TvShowEpisodeTrend	No errors.
Mirinly\AdminBundle\Entity\TvShowCharacterTrend	No errors.
Mirinly\AdminBundle\Entity\TvShowSetTrend	No errors.
Mirinly\AdminBundle\Entity\UserToTvShow	No errors.
Mirinly\AdminBundle\Entity\TvShowLookBook	No errors.
Mirinly\AdminBundle\Entity\TvShowLookBookFolder	No errors.
Mirinly\AdminBundle\Entity\TvShowTrend	No errors.
Mirinly\AdminBundle\Entity\BrandApproveSeasonToTvShow	No errors.
Mirinly\AdminBundle\Entity\TvShowWallet	No errors.
Mirinly\AdminBundle\Entity\ImageToMusicVideo	No errors.
Mirinly\AdminBundle\Entity\UserToMusicVideo	No errors.
Mirinly\AdminBundle\Entity\MusicVideoLookBook	No errors.
Mirinly\AdminBundle\Entity\MusicVideoLookBookFolder	No errors.
Mirinly\AdminBundle\Entity\MusicVideoTrend	No errors.
Mirinly\AdminBundle\Entity\BrandApproveSeasonToMusicVideo	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\MusicArtistCharacter	No errors.
Mirinly\AdminBundle\Entity\MusicArtistGuestCharacter	No errors.
Mirinly\AdminBundle\Entity\BrandApproveSeasonToMusicArtist	No errors.
Mirinly\AdminBundle\Entity\MusicArtistWallet	No errors.
Mirinly\AdminBundle\Entity\ImageToMusicArtist	No errors.
Mirinly\AdminBundle\Entity\VariationSetParam	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