Symfony Profiler

Query Metrics

20 Database Queries

17 Different statements

27.77 ms Query time

27 Invalid entities

433 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

11.96 ms
(43.08%)

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:

[
  "kuc045hc9rvamerhku5lugsfpu"
]

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 = 'kuc045hc9rvamerhku5lugsfpu' 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)

4.19 ms
(15.10%)

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:

[
  397
]

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 = 397 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)

1.84 ms
(6.62%)

SELECT t0.name AS name_1, t0.sku AS sku_2, t0.price_on_mirinly AS price_on_mirinly_3, t0.msrp AS msrp_4, t0.sale_price AS sale_price_5, t0.available_from_samples AS available_from_samples_6, t0.available_from_mirinly AS available_from_mirinly_7, t0.available AS available_8, t0.affiliate_url AS affiliate_url_9, t0.thumbnail AS thumbnail_10, t0.additional_image_1 AS additional_image_1_11, t0.additional_image_2 AS additional_image_2_12, t0.additional_image_3 AS additional_image_3_13, t0.additional_image_4 AS additional_image_4_14, t0.sizeGuide AS sizeGuide_15, t0.description AS description_16, t0.position AS position_17, t0.id AS id_18, t0.featured AS featured_19, t0.sponsored_global AS sponsored_global_20, t0.sponsored_category AS sponsored_category_21, t0.sponsored_sub_category AS sponsored_sub_category_22, t0.based_in AS based_in_23, t0.other_sizes_colors AS other_sizes_colors_24, t0.measurement_type AS measurement_type_25, t0.insurance_type AS insurance_type_26, t0.insurance AS insurance_27, t0.reasonable_wear_and_tear AS reasonable_wear_and_tear_28, t0.low_volume_production AS low_volume_production_29, t0.shipping_policy AS shipping_policy_30, t0.return_policy AS return_policy_31, t0.care AS care_32, t0.created AS created_33, t0.enable_shopify_sync AS enable_shopify_sync_34, t0.enable_squarecpase_sync AS enable_squarecpase_sync_35, t0.imported AS imported_36, t0.removed AS removed_37, t0.once_assigned AS once_assigned_38, t0.default_cities AS default_cities_39, t0.default_search_tags AS default_search_tags_40, t0.external_id AS external_id_41, t0.finalized_date AS finalized_date_42, t0.e_commerce_subcategory_id AS e_commerce_subcategory_id_43, t0.e_commerce_item_type_id AS e_commerce_item_type_id_44, t0.e_commerce_item_template_id AS e_commerce_item_template_id_45, t0.brand_id AS brand_id_46, t0.main_image_id AS main_image_id_47, t48.id AS id_49, t48.loan AS loan_50, t48.loan_show AS loan_show_51, t48.loan_film AS loan_film_52, t48.loan_music_video AS loan_music_video_53, t48.loan_music_artist AS loan_music_artist_54, t48.loan_talent AS loan_talent_55, t48.loan_editorial AS loan_editorial_56, t48.loan_advertisement AS loan_advertisement_57, t48.loan_photoshoot AS loan_photoshoot_58, t48.loan_red_carpet AS loan_red_carpet_59, t48.loan_other AS loan_other_60, t48.loan_buyout_show AS loan_buyout_show_61, t48.loan_buyout_film AS loan_buyout_film_62, t48.loan_buyout_music_video AS loan_buyout_music_video_63, t48.loan_buyout_music_artist AS loan_buyout_music_artist_64, t48.loan_buyout_talent AS loan_buyout_talent_65, t48.loan_buyout_editorial AS loan_buyout_editorial_66, t48.loan_buyout_advertisement AS loan_buyout_advertisement_67, t48.loan_buyout_photoshoot AS loan_buyout_photoshoot_68, t48.loan_buyout_red_carpet AS loan_buyout_red_carpet_69, t48.loan_buyout_other AS loan_buyout_other_70, t48.quantity_general AS quantity_general_71, t48.quantity AS quantity_72, t48.return_insurance_general AS return_insurance_general_73, t48.return_insurance AS return_insurance_74, t48.policy_insurance_general AS policy_insurance_general_75, t48.policy_insurance AS policy_insurance_76, t48.default_reasonable_wear_and_tear AS default_reasonable_wear_and_tear_77, t48.reasonable_wear_and_tear AS reasonable_wear_and_tear_78, t48.default_late_fee AS default_late_fee_79, t48.late_fee_type AS late_fee_type_80, t48.late_fee_amount AS late_fee_amount_81, t48.late_fee_percent AS late_fee_percent_82, t48.late_fee_period AS late_fee_period_83, t48.loan_buyout AS loan_buyout_84, t48.loan_buyout_price_type AS loan_buyout_price_type_85, t48.loan_buyout_price_value AS loan_buyout_price_value_86, t48.security_hold AS security_hold_87, t48.security_hold_percent AS security_hold_percent_88, t48.shopify_sync AS shopify_sync_89, t48.shopify_sync_add AS shopify_sync_add_90, t48.squarespace_sync AS squarespace_sync_91, t48.squarespace_sync_add AS squarespace_sync_add_92, t48.default_quantity_update AS default_quantity_update_93, t48.quantity_update AS quantity_update_94, t48.item_id AS item_id_95, t96.id AS id_97, t96.rental AS rental_98, t96.rental_show AS rental_show_99, t96.rental_film AS rental_film_100, t96.rental_music_video AS rental_music_video_101, t96.rental_music_artist AS rental_music_artist_102, t96.rental_talent AS rental_talent_103, t96.rental_editorial AS rental_editorial_104, t96.rental_advertisement AS rental_advertisement_105, t96.rental_photoshoot AS rental_photoshoot_106, t96.rental_red_carpet AS rental_red_carpet_107, t96.rental_other AS rental_other_108, t96.rental_buyout_show AS rental_buyout_show_109, t96.rental_buyout_film AS rental_buyout_film_110, t96.rental_buyout_music_video AS rental_buyout_music_video_111, t96.rental_buyout_music_artist AS rental_buyout_music_artist_112, t96.rental_buyout_talent AS rental_buyout_talent_113, t96.rental_buyout_editorial AS rental_buyout_editorial_114, t96.rental_buyout_advertisement AS rental_buyout_advertisement_115, t96.rental_buyout_photoshoot AS rental_buyout_photoshoot_116, t96.rental_buyout_red_carpet AS rental_buyout_red_carpet_117, t96.rental_buyout_other AS rental_buyout_other_118, t96.quantity_general AS quantity_general_119, t96.quantity AS quantity_120, t96.rental_price_type_general AS rental_price_type_general_121, t96.rental_price_value AS rental_price_value_122, t96.rental_period_general AS rental_period_general_123, t96.return_insurance_general AS return_insurance_general_124, t96.return_insurance AS return_insurance_125, t96.policy_insurance_general AS policy_insurance_general_126, t96.policy_insurance AS policy_insurance_127, t96.default_reasonable_wear_and_tear AS default_reasonable_wear_and_tear_128, t96.reasonable_wear_and_tear AS reasonable_wear_and_tear_129, t96.default_late_fee AS default_late_fee_130, t96.late_fee_type AS late_fee_type_131, t96.late_fee_amount AS late_fee_amount_132, t96.late_fee_percent AS late_fee_percent_133, t96.late_fee_period AS late_fee_period_134, t96.rental_buyout AS rental_buyout_135, t96.rental_buyout_price_type AS rental_buyout_price_type_136, t96.rental_buyout_price_value AS rental_buyout_price_value_137, t96.security_hold AS security_hold_138, t96.security_hold_percent AS security_hold_percent_139, t96.shopify_sync AS shopify_sync_140, t96.shopify_sync_add AS shopify_sync_add_141, t96.squarespace_sync AS squarespace_sync_142, t96.squarespace_sync_add AS squarespace_sync_add_143, t96.default_quantity_update AS default_quantity_update_144, t96.quantity_update AS quantity_update_145, t96.item_id AS item_id_146, t147.id AS id_148, t147.purchase AS purchase_149, t147.purchase_show AS purchase_show_150, t147.purchase_film AS purchase_film_151, t147.purchase_music_video AS purchase_music_video_152, t147.purchase_music_artist AS purchase_music_artist_153, t147.purchase_talent AS purchase_talent_154, t147.purchase_editorial AS purchase_editorial_155, t147.purchase_advertisement AS purchase_advertisement_156, t147.purchase_photoshoot AS purchase_photoshoot_157, t147.purchase_red_carpet AS purchase_red_carpet_158, t147.purchase_other AS purchase_other_159, t147.reserve_purchase_show AS reserve_purchase_show_160, t147.reserve_purchase_film AS reserve_purchase_film_161, t147.reserve_purchase_music_video AS reserve_purchase_music_video_162, t147.reserve_purchase_music_artist AS reserve_purchase_music_artist_163, t147.reserve_purchase_talent AS reserve_purchase_talent_164, t147.reserve_purchase_editorial AS reserve_purchase_editorial_165, t147.reserve_purchase_advertisement AS reserve_purchase_advertisement_166, t147.reserve_purchase_photoshoot AS reserve_purchase_photoshoot_167, t147.reserve_purchase_red_carpet AS reserve_purchase_red_carpet_168, t147.reserve_purchase_other AS reserve_purchase_other_169, t147.quantity_general AS quantity_general_170, t147.quantity AS quantity_171, t147.purchase_price_type_general AS purchase_price_type_general_172, t147.purchase_price_value AS purchase_price_value_173, t147.reserve_purchase AS reserve_purchase_174, t147.reserve_purchase_price_type AS reserve_purchase_price_type_175, t147.reserve_purchase_price_value AS reserve_purchase_price_value_176, t147.made_to_order_type AS made_to_order_type_177, t147.pre_order_type AS pre_order_type_178, t147.default_return_policy AS default_return_policy_179, t147.return_policy AS return_policy_180, t147.default_care AS default_care_181, t147.care AS care_182, t147.shopify_sync AS shopify_sync_183, t147.shopify_sync_add AS shopify_sync_add_184, t147.squarespace_sync AS squarespace_sync_185, t147.squarespace_sync_add AS squarespace_sync_add_186, t147.default_quantity_update AS default_quantity_update_187, t147.quantity_update AS quantity_update_188, t147.item_id AS item_id_189, t190.id AS id_191, t190.in_person AS in_person_192, t190.quantity_general AS quantity_general_193, t190.quantity AS quantity_194, t190.industry_discount_type_general AS industry_discount_type_general_195, t190.industry_discount_value AS industry_discount_value_196, t190.made_to_order_type AS made_to_order_type_197, t190.pre_order_type AS pre_order_type_198, t190.shopify_sync AS shopify_sync_199, t190.shopify_sync_add AS shopify_sync_add_200, t190.squarespace_sync AS squarespace_sync_201, t190.squarespace_sync_add AS squarespace_sync_add_202, t190.default_quantity_update AS default_quantity_update_203, t190.quantity_update AS quantity_update_204, t190.item_id AS item_id_205, t206.id AS id_207, t206.discovery AS discovery_208, t206.discovery_show AS discovery_show_209, t206.discovery_film AS discovery_film_210, t206.discovery_music_video AS discovery_music_video_211, t206.discovery_music_artist AS discovery_music_artist_212, t206.discovery_talent AS discovery_talent_213, t206.discovery_editorial AS discovery_editorial_214, t206.discovery_advertisement AS discovery_advertisement_215, t206.quantity_general AS quantity_general_216, t206.quantity AS quantity_217, t206.made_to_order_type AS made_to_order_type_218, t206.pre_order_type AS pre_order_type_219, t206.default_shipping_policy AS default_shipping_policy_220, t206.shipping_policy AS shipping_policy_221, t206.default_return_policy AS default_return_policy_222, t206.return_policy AS return_policy_223, t206.default_care AS default_care_224, t206.care AS care_225, t206.shopify_sync AS shopify_sync_226, t206.shopify_sync_add AS shopify_sync_add_227, t206.squarespace_sync AS squarespace_sync_228, t206.squarespace_sync_add AS squarespace_sync_add_229, t206.default_quantity_update AS default_quantity_update_230, t206.quantity_update AS quantity_update_231, t206.item_id AS item_id_232 FROM e_commerce_item t0 LEFT JOIN e_commerce_item_settings_loan t48 ON t48.item_id = t0.id LEFT JOIN e_commerce_item_settings_rental t96 ON t96.item_id = t0.id LEFT JOIN e_commerce_item_settings_purchase t147 ON t147.item_id = t0.id LEFT JOIN e_commerce_item_settings_in_person t190 ON t190.item_id = t0.id LEFT JOIN e_commerce_item_settings_discovery t206 ON t206.item_id = t0.id WHERE t0.id = ?

Parameters:

[
  41947
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.sku AS sku_2,
  t0.price_on_mirinly AS price_on_mirinly_3,
  t0.msrp AS msrp_4,
  t0.sale_price AS sale_price_5,
  t0.available_from_samples AS available_from_samples_6,
  t0.available_from_mirinly AS available_from_mirinly_7,
  t0.available AS available_8,
  t0.affiliate_url AS affiliate_url_9,
  t0.thumbnail AS thumbnail_10,
  t0.additional_image_1 AS additional_image_1_11,
  t0.additional_image_2 AS additional_image_2_12,
  t0.additional_image_3 AS additional_image_3_13,
  t0.additional_image_4 AS additional_image_4_14,
  t0.sizeGuide AS sizeGuide_15,
  t0.description AS description_16,
  t0.position AS position_17,
  t0.id AS id_18,
  t0.featured AS featured_19,
  t0.sponsored_global AS sponsored_global_20,
  t0.sponsored_category AS sponsored_category_21,
  t0.sponsored_sub_category AS sponsored_sub_category_22,
  t0.based_in AS based_in_23,
  t0.other_sizes_colors AS other_sizes_colors_24,
  t0.measurement_type AS measurement_type_25,
  t0.insurance_type AS insurance_type_26,
  t0.insurance AS insurance_27,
  t0.reasonable_wear_and_tear AS reasonable_wear_and_tear_28,
  t0.low_volume_production AS low_volume_production_29,
  t0.shipping_policy AS shipping_policy_30,
  t0.return_policy AS return_policy_31,
  t0.care AS care_32,
  t0.created AS created_33,
  t0.enable_shopify_sync AS enable_shopify_sync_34,
  t0.enable_squarecpase_sync AS enable_squarecpase_sync_35,
  t0.imported AS imported_36,
  t0.removed AS removed_37,
  t0.once_assigned AS once_assigned_38,
  t0.default_cities AS default_cities_39,
  t0.default_search_tags AS default_search_tags_40,
  t0.external_id AS external_id_41,
  t0.finalized_date AS finalized_date_42,
  t0.e_commerce_subcategory_id AS e_commerce_subcategory_id_43,
  t0.e_commerce_item_type_id AS e_commerce_item_type_id_44,
  t0.e_commerce_item_template_id AS e_commerce_item_template_id_45,
  t0.brand_id AS brand_id_46,
  t0.main_image_id AS main_image_id_47,
  t48.id AS id_49,
  t48.loan AS loan_50,
  t48.loan_show AS loan_show_51,
  t48.loan_film AS loan_film_52,
  t48.loan_music_video AS loan_music_video_53,
  t48.loan_music_artist AS loan_music_artist_54,
  t48.loan_talent AS loan_talent_55,
  t48.loan_editorial AS loan_editorial_56,
  t48.loan_advertisement AS loan_advertisement_57,
  t48.loan_photoshoot AS loan_photoshoot_58,
  t48.loan_red_carpet AS loan_red_carpet_59,
  t48.loan_other AS loan_other_60,
  t48.loan_buyout_show AS loan_buyout_show_61,
  t48.loan_buyout_film AS loan_buyout_film_62,
  t48.loan_buyout_music_video AS loan_buyout_music_video_63,
  t48.loan_buyout_music_artist AS loan_buyout_music_artist_64,
  t48.loan_buyout_talent AS loan_buyout_talent_65,
  t48.loan_buyout_editorial AS loan_buyout_editorial_66,
  t48.loan_buyout_advertisement AS loan_buyout_advertisement_67,
  t48.loan_buyout_photoshoot AS loan_buyout_photoshoot_68,
  t48.loan_buyout_red_carpet AS loan_buyout_red_carpet_69,
  t48.loan_buyout_other AS loan_buyout_other_70,
  t48.quantity_general AS quantity_general_71,
  t48.quantity AS quantity_72,
  t48.return_insurance_general AS return_insurance_general_73,
  t48.return_insurance AS return_insurance_74,
  t48.policy_insurance_general AS policy_insurance_general_75,
  t48.policy_insurance AS policy_insurance_76,
  t48.default_reasonable_wear_and_tear AS default_reasonable_wear_and_tear_77,
  t48.reasonable_wear_and_tear AS reasonable_wear_and_tear_78,
  t48.default_late_fee AS default_late_fee_79,
  t48.late_fee_type AS late_fee_type_80,
  t48.late_fee_amount AS late_fee_amount_81,
  t48.late_fee_percent AS late_fee_percent_82,
  t48.late_fee_period AS late_fee_period_83,
  t48.loan_buyout AS loan_buyout_84,
  t48.loan_buyout_price_type AS loan_buyout_price_type_85,
  t48.loan_buyout_price_value AS loan_buyout_price_value_86,
  t48.security_hold AS security_hold_87,
  t48.security_hold_percent AS security_hold_percent_88,
  t48.shopify_sync AS shopify_sync_89,
  t48.shopify_sync_add AS shopify_sync_add_90,
  t48.squarespace_sync AS squarespace_sync_91,
  t48.squarespace_sync_add AS squarespace_sync_add_92,
  t48.default_quantity_update AS default_quantity_update_93,
  t48.quantity_update AS quantity_update_94,
  t48.item_id AS item_id_95,
  t96.id AS id_97,
  t96.rental AS rental_98,
  t96.rental_show AS rental_show_99,
  t96.rental_film AS rental_film_100,
  t96.rental_music_video AS rental_music_video_101,
  t96.rental_music_artist AS rental_music_artist_102,
  t96.rental_talent AS rental_talent_103,
  t96.rental_editorial AS rental_editorial_104,
  t96.rental_advertisement AS rental_advertisement_105,
  t96.rental_photoshoot AS rental_photoshoot_106,
  t96.rental_red_carpet AS rental_red_carpet_107,
  t96.rental_other AS rental_other_108,
  t96.rental_buyout_show AS rental_buyout_show_109,
  t96.rental_buyout_film AS rental_buyout_film_110,
  t96.rental_buyout_music_video AS rental_buyout_music_video_111,
  t96.rental_buyout_music_artist AS rental_buyout_music_artist_112,
  t96.rental_buyout_talent AS rental_buyout_talent_113,
  t96.rental_buyout_editorial AS rental_buyout_editorial_114,
  t96.rental_buyout_advertisement AS rental_buyout_advertisement_115,
  t96.rental_buyout_photoshoot AS rental_buyout_photoshoot_116,
  t96.rental_buyout_red_carpet AS rental_buyout_red_carpet_117,
  t96.rental_buyout_other AS rental_buyout_other_118,
  t96.quantity_general AS quantity_general_119,
  t96.quantity AS quantity_120,
  t96.rental_price_type_general AS rental_price_type_general_121,
  t96.rental_price_value AS rental_price_value_122,
  t96.rental_period_general AS rental_period_general_123,
  t96.return_insurance_general AS return_insurance_general_124,
  t96.return_insurance AS return_insurance_125,
  t96.policy_insurance_general AS policy_insurance_general_126,
  t96.policy_insurance AS policy_insurance_127,
  t96.default_reasonable_wear_and_tear AS default_reasonable_wear_and_tear_128,
  t96.reasonable_wear_and_tear AS reasonable_wear_and_tear_129,
  t96.default_late_fee AS default_late_fee_130,
  t96.late_fee_type AS late_fee_type_131,
  t96.late_fee_amount AS late_fee_amount_132,
  t96.late_fee_percent AS late_fee_percent_133,
  t96.late_fee_period AS late_fee_period_134,
  t96.rental_buyout AS rental_buyout_135,
  t96.rental_buyout_price_type AS rental_buyout_price_type_136,
  t96.rental_buyout_price_value AS rental_buyout_price_value_137,
  t96.security_hold AS security_hold_138,
  t96.security_hold_percent AS security_hold_percent_139,
  t96.shopify_sync AS shopify_sync_140,
  t96.shopify_sync_add AS shopify_sync_add_141,
  t96.squarespace_sync AS squarespace_sync_142,
  t96.squarespace_sync_add AS squarespace_sync_add_143,
  t96.default_quantity_update AS default_quantity_update_144,
  t96.quantity_update AS quantity_update_145,
  t96.item_id AS item_id_146,
  t147.id AS id_148,
  t147.purchase AS purchase_149,
  t147.purchase_show AS purchase_show_150,
  t147.purchase_film AS purchase_film_151,
  t147.purchase_music_video AS purchase_music_video_152,
  t147.purchase_music_artist AS purchase_music_artist_153,
  t147.purchase_talent AS purchase_talent_154,
  t147.purchase_editorial AS purchase_editorial_155,
  t147.purchase_advertisement AS purchase_advertisement_156,
  t147.purchase_photoshoot AS purchase_photoshoot_157,
  t147.purchase_red_carpet AS purchase_red_carpet_158,
  t147.purchase_other AS purchase_other_159,
  t147.reserve_purchase_show AS reserve_purchase_show_160,
  t147.reserve_purchase_film AS reserve_purchase_film_161,
  t147.reserve_purchase_music_video AS reserve_purchase_music_video_162,
  t147.reserve_purchase_music_artist AS reserve_purchase_music_artist_163,
  t147.reserve_purchase_talent AS reserve_purchase_talent_164,
  t147.reserve_purchase_editorial AS reserve_purchase_editorial_165,
  t147.reserve_purchase_advertisement AS reserve_purchase_advertisement_166,
  t147.reserve_purchase_photoshoot AS reserve_purchase_photoshoot_167,
  t147.reserve_purchase_red_carpet AS reserve_purchase_red_carpet_168,
  t147.reserve_purchase_other AS reserve_purchase_other_169,
  t147.quantity_general AS quantity_general_170,
  t147.quantity AS quantity_171,
  t147.purchase_price_type_general AS purchase_price_type_general_172,
  t147.purchase_price_value AS purchase_price_value_173,
  t147.reserve_purchase AS reserve_purchase_174,
  t147.reserve_purchase_price_type AS reserve_purchase_price_type_175,
  t147.reserve_purchase_price_value AS reserve_purchase_price_value_176,
  t147.made_to_order_type AS made_to_order_type_177,
  t147.pre_order_type AS pre_order_type_178,
  t147.default_return_policy AS default_return_policy_179,
  t147.return_policy AS return_policy_180,
  t147.default_care AS default_care_181,
  t147.care AS care_182,
  t147.shopify_sync AS shopify_sync_183,
  t147.shopify_sync_add AS shopify_sync_add_184,
  t147.squarespace_sync AS squarespace_sync_185,
  t147.squarespace_sync_add AS squarespace_sync_add_186,
  t147.default_quantity_update AS default_quantity_update_187,
  t147.quantity_update AS quantity_update_188,
  t147.item_id AS item_id_189,
  t190.id AS id_191,
  t190.in_person AS in_person_192,
  t190.quantity_general AS quantity_general_193,
  t190.quantity AS quantity_194,
  t190.industry_discount_type_general AS industry_discount_type_general_195,
  t190.industry_discount_value AS industry_discount_value_196,
  t190.made_to_order_type AS made_to_order_type_197,
  t190.pre_order_type AS pre_order_type_198,
  t190.shopify_sync AS shopify_sync_199,
  t190.shopify_sync_add AS shopify_sync_add_200,
  t190.squarespace_sync AS squarespace_sync_201,
  t190.squarespace_sync_add AS squarespace_sync_add_202,
  t190.default_quantity_update AS default_quantity_update_203,
  t190.quantity_update AS quantity_update_204,
  t190.item_id AS item_id_205,
  t206.id AS id_207,
  t206.discovery AS discovery_208,
  t206.discovery_show AS discovery_show_209,
  t206.discovery_film AS discovery_film_210,
  t206.discovery_music_video AS discovery_music_video_211,
  t206.discovery_music_artist AS discovery_music_artist_212,
  t206.discovery_talent AS discovery_talent_213,
  t206.discovery_editorial AS discovery_editorial_214,
  t206.discovery_advertisement AS discovery_advertisement_215,
  t206.quantity_general AS quantity_general_216,
  t206.quantity AS quantity_217,
  t206.made_to_order_type AS made_to_order_type_218,
  t206.pre_order_type AS pre_order_type_219,
  t206.default_shipping_policy AS default_shipping_policy_220,
  t206.shipping_policy AS shipping_policy_221,
  t206.default_return_policy AS default_return_policy_222,
  t206.return_policy AS return_policy_223,
  t206.default_care AS default_care_224,
  t206.care AS care_225,
  t206.shopify_sync AS shopify_sync_226,
  t206.shopify_sync_add AS shopify_sync_add_227,
  t206.squarespace_sync AS squarespace_sync_228,
  t206.squarespace_sync_add AS squarespace_sync_add_229,
  t206.default_quantity_update AS default_quantity_update_230,
  t206.quantity_update AS quantity_update_231,
  t206.item_id AS item_id_232
FROM
  e_commerce_item t0
  LEFT JOIN e_commerce_item_settings_loan t48 ON t48.item_id = t0.id
  LEFT JOIN e_commerce_item_settings_rental t96 ON t96.item_id = t0.id
  LEFT JOIN e_commerce_item_settings_purchase t147 ON t147.item_id = t0.id
  LEFT JOIN e_commerce_item_settings_in_person t190 ON t190.item_id = t0.id
  LEFT JOIN e_commerce_item_settings_discovery t206 ON t206.item_id = t0.id
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.sku AS sku_2, t0.price_on_mirinly AS price_on_mirinly_3, t0.msrp AS msrp_4, t0.sale_price AS sale_price_5, t0.available_from_samples AS available_from_samples_6, t0.available_from_mirinly AS available_from_mirinly_7, t0.available AS available_8, t0.affiliate_url AS affiliate_url_9, t0.thumbnail AS thumbnail_10, t0.additional_image_1 AS additional_image_1_11, t0.additional_image_2 AS additional_image_2_12, t0.additional_image_3 AS additional_image_3_13, t0.additional_image_4 AS additional_image_4_14, t0.sizeGuide AS sizeGuide_15, t0.description AS description_16, t0.position AS position_17, t0.id AS id_18, t0.featured AS featured_19, t0.sponsored_global AS sponsored_global_20, t0.sponsored_category AS sponsored_category_21, t0.sponsored_sub_category AS sponsored_sub_category_22, t0.based_in AS based_in_23, t0.other_sizes_colors AS other_sizes_colors_24, t0.measurement_type AS measurement_type_25, t0.insurance_type AS insurance_type_26, t0.insurance AS insurance_27, t0.reasonable_wear_and_tear AS reasonable_wear_and_tear_28, t0.low_volume_production AS low_volume_production_29, t0.shipping_policy AS shipping_policy_30, t0.return_policy AS return_policy_31, t0.care AS care_32, t0.created AS created_33, t0.enable_shopify_sync AS enable_shopify_sync_34, t0.enable_squarecpase_sync AS enable_squarecpase_sync_35, t0.imported AS imported_36, t0.removed AS removed_37, t0.once_assigned AS once_assigned_38, t0.default_cities AS default_cities_39, t0.default_search_tags AS default_search_tags_40, t0.external_id AS external_id_41, t0.finalized_date AS finalized_date_42, t0.e_commerce_subcategory_id AS e_commerce_subcategory_id_43, t0.e_commerce_item_type_id AS e_commerce_item_type_id_44, t0.e_commerce_item_template_id AS e_commerce_item_template_id_45, t0.brand_id AS brand_id_46, t0.main_image_id AS main_image_id_47, t48.id AS id_49, t48.loan AS loan_50, t48.loan_show AS loan_show_51, t48.loan_film AS loan_film_52, t48.loan_music_video AS loan_music_video_53, t48.loan_music_artist AS loan_music_artist_54, t48.loan_talent AS loan_talent_55, t48.loan_editorial AS loan_editorial_56, t48.loan_advertisement AS loan_advertisement_57, t48.loan_photoshoot AS loan_photoshoot_58, t48.loan_red_carpet AS loan_red_carpet_59, t48.loan_other AS loan_other_60, t48.loan_buyout_show AS loan_buyout_show_61, t48.loan_buyout_film AS loan_buyout_film_62, t48.loan_buyout_music_video AS loan_buyout_music_video_63, t48.loan_buyout_music_artist AS loan_buyout_music_artist_64, t48.loan_buyout_talent AS loan_buyout_talent_65, t48.loan_buyout_editorial AS loan_buyout_editorial_66, t48.loan_buyout_advertisement AS loan_buyout_advertisement_67, t48.loan_buyout_photoshoot AS loan_buyout_photoshoot_68, t48.loan_buyout_red_carpet AS loan_buyout_red_carpet_69, t48.loan_buyout_other AS loan_buyout_other_70, t48.quantity_general AS quantity_general_71, t48.quantity AS quantity_72, t48.return_insurance_general AS return_insurance_general_73, t48.return_insurance AS return_insurance_74, t48.policy_insurance_general AS policy_insurance_general_75, t48.policy_insurance AS policy_insurance_76, t48.default_reasonable_wear_and_tear AS default_reasonable_wear_and_tear_77, t48.reasonable_wear_and_tear AS reasonable_wear_and_tear_78, t48.default_late_fee AS default_late_fee_79, t48.late_fee_type AS late_fee_type_80, t48.late_fee_amount AS late_fee_amount_81, t48.late_fee_percent AS late_fee_percent_82, t48.late_fee_period AS late_fee_period_83, t48.loan_buyout AS loan_buyout_84, t48.loan_buyout_price_type AS loan_buyout_price_type_85, t48.loan_buyout_price_value AS loan_buyout_price_value_86, t48.security_hold AS security_hold_87, t48.security_hold_percent AS security_hold_percent_88, t48.shopify_sync AS shopify_sync_89, t48.shopify_sync_add AS shopify_sync_add_90, t48.squarespace_sync AS squarespace_sync_91, t48.squarespace_sync_add AS squarespace_sync_add_92, t48.default_quantity_update AS default_quantity_update_93, t48.quantity_update AS quantity_update_94, t48.item_id AS item_id_95, t96.id AS id_97, t96.rental AS rental_98, t96.rental_show AS rental_show_99, t96.rental_film AS rental_film_100, t96.rental_music_video AS rental_music_video_101, t96.rental_music_artist AS rental_music_artist_102, t96.rental_talent AS rental_talent_103, t96.rental_editorial AS rental_editorial_104, t96.rental_advertisement AS rental_advertisement_105, t96.rental_photoshoot AS rental_photoshoot_106, t96.rental_red_carpet AS rental_red_carpet_107, t96.rental_other AS rental_other_108, t96.rental_buyout_show AS rental_buyout_show_109, t96.rental_buyout_film AS rental_buyout_film_110, t96.rental_buyout_music_video AS rental_buyout_music_video_111, t96.rental_buyout_music_artist AS rental_buyout_music_artist_112, t96.rental_buyout_talent AS rental_buyout_talent_113, t96.rental_buyout_editorial AS rental_buyout_editorial_114, t96.rental_buyout_advertisement AS rental_buyout_advertisement_115, t96.rental_buyout_photoshoot AS rental_buyout_photoshoot_116, t96.rental_buyout_red_carpet AS rental_buyout_red_carpet_117, t96.rental_buyout_other AS rental_buyout_other_118, t96.quantity_general AS quantity_general_119, t96.quantity AS quantity_120, t96.rental_price_type_general AS rental_price_type_general_121, t96.rental_price_value AS rental_price_value_122, t96.rental_period_general AS rental_period_general_123, t96.return_insurance_general AS return_insurance_general_124, t96.return_insurance AS return_insurance_125, t96.policy_insurance_general AS policy_insurance_general_126, t96.policy_insurance AS policy_insurance_127, t96.default_reasonable_wear_and_tear AS default_reasonable_wear_and_tear_128, t96.reasonable_wear_and_tear AS reasonable_wear_and_tear_129, t96.default_late_fee AS default_late_fee_130, t96.late_fee_type AS late_fee_type_131, t96.late_fee_amount AS late_fee_amount_132, t96.late_fee_percent AS late_fee_percent_133, t96.late_fee_period AS late_fee_period_134, t96.rental_buyout AS rental_buyout_135, t96.rental_buyout_price_type AS rental_buyout_price_type_136, t96.rental_buyout_price_value AS rental_buyout_price_value_137, t96.security_hold AS security_hold_138, t96.security_hold_percent AS security_hold_percent_139, t96.shopify_sync AS shopify_sync_140, t96.shopify_sync_add AS shopify_sync_add_141, t96.squarespace_sync AS squarespace_sync_142, t96.squarespace_sync_add AS squarespace_sync_add_143, t96.default_quantity_update AS default_quantity_update_144, t96.quantity_update AS quantity_update_145, t96.item_id AS item_id_146, t147.id AS id_148, t147.purchase AS purchase_149, t147.purchase_show AS purchase_show_150, t147.purchase_film AS purchase_film_151, t147.purchase_music_video AS purchase_music_video_152, t147.purchase_music_artist AS purchase_music_artist_153, t147.purchase_talent AS purchase_talent_154, t147.purchase_editorial AS purchase_editorial_155, t147.purchase_advertisement AS purchase_advertisement_156, t147.purchase_photoshoot AS purchase_photoshoot_157, t147.purchase_red_carpet AS purchase_red_carpet_158, t147.purchase_other AS purchase_other_159, t147.reserve_purchase_show AS reserve_purchase_show_160, t147.reserve_purchase_film AS reserve_purchase_film_161, t147.reserve_purchase_music_video AS reserve_purchase_music_video_162, t147.reserve_purchase_music_artist AS reserve_purchase_music_artist_163, t147.reserve_purchase_talent AS reserve_purchase_talent_164, t147.reserve_purchase_editorial AS reserve_purchase_editorial_165, t147.reserve_purchase_advertisement AS reserve_purchase_advertisement_166, t147.reserve_purchase_photoshoot AS reserve_purchase_photoshoot_167, t147.reserve_purchase_red_carpet AS reserve_purchase_red_carpet_168, t147.reserve_purchase_other AS reserve_purchase_other_169, t147.quantity_general AS quantity_general_170, t147.quantity AS quantity_171, t147.purchase_price_type_general AS purchase_price_type_general_172, t147.purchase_price_value AS purchase_price_value_173, t147.reserve_purchase AS reserve_purchase_174, t147.reserve_purchase_price_type AS reserve_purchase_price_type_175, t147.reserve_purchase_price_value AS reserve_purchase_price_value_176, t147.made_to_order_type AS made_to_order_type_177, t147.pre_order_type AS pre_order_type_178, t147.default_return_policy AS default_return_policy_179, t147.return_policy AS return_policy_180, t147.default_care AS default_care_181, t147.care AS care_182, t147.shopify_sync AS shopify_sync_183, t147.shopify_sync_add AS shopify_sync_add_184, t147.squarespace_sync AS squarespace_sync_185, t147.squarespace_sync_add AS squarespace_sync_add_186, t147.default_quantity_update AS default_quantity_update_187, t147.quantity_update AS quantity_update_188, t147.item_id AS item_id_189, t190.id AS id_191, t190.in_person AS in_person_192, t190.quantity_general AS quantity_general_193, t190.quantity AS quantity_194, t190.industry_discount_type_general AS industry_discount_type_general_195, t190.industry_discount_value AS industry_discount_value_196, t190.made_to_order_type AS made_to_order_type_197, t190.pre_order_type AS pre_order_type_198, t190.shopify_sync AS shopify_sync_199, t190.shopify_sync_add AS shopify_sync_add_200, t190.squarespace_sync AS squarespace_sync_201, t190.squarespace_sync_add AS squarespace_sync_add_202, t190.default_quantity_update AS default_quantity_update_203, t190.quantity_update AS quantity_update_204, t190.item_id AS item_id_205, t206.id AS id_207, t206.discovery AS discovery_208, t206.discovery_show AS discovery_show_209, t206.discovery_film AS discovery_film_210, t206.discovery_music_video AS discovery_music_video_211, t206.discovery_music_artist AS discovery_music_artist_212, t206.discovery_talent AS discovery_talent_213, t206.discovery_editorial AS discovery_editorial_214, t206.discovery_advertisement AS discovery_advertisement_215, t206.quantity_general AS quantity_general_216, t206.quantity AS quantity_217, t206.made_to_order_type AS made_to_order_type_218, t206.pre_order_type AS pre_order_type_219, t206.default_shipping_policy AS default_shipping_policy_220, t206.shipping_policy AS shipping_policy_221, t206.default_return_policy AS default_return_policy_222, t206.return_policy AS return_policy_223, t206.default_care AS default_care_224, t206.care AS care_225, t206.shopify_sync AS shopify_sync_226, t206.shopify_sync_add AS shopify_sync_add_227, t206.squarespace_sync AS squarespace_sync_228, t206.squarespace_sync_add AS squarespace_sync_add_229, t206.default_quantity_update AS default_quantity_update_230, t206.quantity_update AS quantity_update_231, t206.item_id AS item_id_232 FROM e_commerce_item t0 LEFT JOIN e_commerce_item_settings_loan t48 ON t48.item_id = t0.id LEFT JOIN e_commerce_item_settings_rental t96 ON t96.item_id = t0.id LEFT JOIN e_commerce_item_settings_purchase t147 ON t147.item_id = t0.id LEFT JOIN e_commerce_item_settings_in_person t190 ON t190.item_id = t0.id LEFT JOIN e_commerce_item_settings_discovery t206 ON t206.item_id = t0.id WHERE t0.id = 41947;

#	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\ECommerceItem::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 61)
6	Proxies\__CG__\Mirinly\AdminBundle\Entity\ECommerceItem->__get (line 120)
7	Mirinly\AdminBundle\Entity\ECommerceItem->getRemoved (line 2620)
8	Twig\Extension\CoreExtension->getAttribute (line 1911)
9	__TwigTemplate_474dfe10498a035a09d55974b3c7d50d::block_content (line 224)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_3a8022cedc3a177a8d05e322c8e823dd->doDisplay (line 231)
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.81 ms
(6.52%)

SELECT t0.name AS name_1, t0.title AS title_2, t0.has_affiliate_url AS has_affiliate_url_3, t0.location AS location_4, t0.logo AS logo_5, t0.sizeGuide AS sizeGuide_6, t0.commission AS commission_7, t0.website AS website_8, t0.phone AS phone_9, t0.fax AS fax_10, t0.contact_first_name AS contact_first_name_11, t0.contact_last_name AS contact_last_name_12, t0.email AS email_13, t0.position AS position_14, t0.id AS id_15, t0.shipping_policy AS shipping_policy_16, t0.return_policy AS return_policy_17, t0.auto_mainstreet AS auto_mainstreet_18, t0.created AS created_19, t0.po_box AS po_box_20, t0.reasonable_wear_and_tear AS reasonable_wear_and_tear_21, t0.low_volume_production AS low_volume_production_22, t0.based_in AS based_in_23, t0.shopify_shop_domain AS shopify_shop_domain_24, t0.shopify_api_key AS shopify_api_key_25, t0.shopify_password AS shopify_password_26, t0.shopify_private AS shopify_private_27, t0.shopify_custom_access_token AS shopify_custom_access_token_28, t0.shopify_custom_api_key AS shopify_custom_api_key_29, t0.shopify_custom_api_secret_key AS shopify_custom_api_secret_key_30, t0.shopify_access_token AS shopify_access_token_31, t0.shopify_installation_link AS shopify_installation_link_32, t0.shopify_client_id AS shopify_client_id_33, t0.shopify_client_secret AS shopify_client_secret_34, t0.update_shopify AS update_shopify_35, t0.quantity_update AS quantity_update_36, t0.default_measurement_type AS default_measurement_type_37, t0.shopifyWay AS shopifyWay_38, t0.shopifySource AS shopifySource_39, t0.shopifyCollection AS shopifyCollection_40, t0.squarespaceSource AS squarespaceSource_41, t0.squarespaceStorePage AS squarespaceStorePage_42, t0.shopify_on AS shopify_on_43, t0.integration AS integration_44, t0.squarespace_url AS squarespace_url_45, t0.default_shopify_other_sizes_colors AS default_shopify_other_sizes_colors_46, t0.instagram_username AS instagram_username_47, t0.instagram_link AS instagram_link_48, t0.twitter_username AS twitter_username_49, t0.twitter_link AS twitter_link_50, t0.tiktok_username AS tiktok_username_51, t0.tiktok_link AS tiktok_link_52, t0.facebook_username AS facebook_username_53, t0.facebook_link AS facebook_link_54, t0.description AS description_55, t0.care AS care_56, t0.plan AS plan_57, t0.joined_first_time AS joined_first_time_58, t0.joined AS joined_59, t0.renewed_on AS renewed_on_60, t0.plan_auto_renewal_date AS plan_auto_renewal_date_61, t0.plan_expiration_date AS plan_expiration_date_62, t0.plan_billing_cycle AS plan_billing_cycle_63, t0.new_plan_billing_cycle AS new_plan_billing_cycle_64, t0.new_plan AS new_plan_65, t0.hold AS hold_66, t0.stripe_subscription AS stripe_subscription_67, t0.stripe_subscription_schedule AS stripe_subscription_schedule_68, t0.insurance AS insurance_69, t0.hide_add_project AS hide_add_project_70, t0.payout_method AS payout_method_71, t0.payout_account_number AS payout_account_number_72, t0.payout_paypal_email AS payout_paypal_email_73, t0.service_fee_percent AS service_fee_percent_74, t0.service_fee_min AS service_fee_min_75, t0.is_canadian AS is_canadian_76, t0.disable_shopify_sync_remove AS disable_shopify_sync_remove_77, t0.squarespace_auth_code AS squarespace_auth_code_78, t0.squarespace_access_token AS squarespace_access_token_79, t0.squarespace_refresh_token AS squarespace_refresh_token_80, t0.squarespace_access_token_expiration AS squarespace_access_token_expiration_81, t0.last_squarespace_update AS last_squarespace_update_82, t0.disable_squarespace_sync_remove AS disable_squarespace_sync_remove_83, t0.approve_future_productions AS approve_future_productions_84, t0.wallet_id AS wallet_id_85, t0.stripe_customer AS stripe_customer_86, t0.url_name AS url_name_87, t0.currency_id AS currency_id_88, t0.main_image_id AS main_image_id_89, t0.default_shopify_product_type_id AS default_shopify_product_type_id_90, t0.default_shopify_sub_category_id AS default_shopify_sub_category_id_91, t0.default_shopify_season_id AS default_shopify_season_id_92, t93.id AS id_94, t93.loan AS loan_95, t93.loan_show AS loan_show_96, t93.loan_film AS loan_film_97, t93.loan_music_video AS loan_music_video_98, t93.loan_music_artist AS loan_music_artist_99, t93.loan_talent AS loan_talent_100, t93.loan_editorial AS loan_editorial_101, t93.loan_advertisement AS loan_advertisement_102, t93.loan_photoshoot AS loan_photoshoot_103, t93.loan_red_carpet AS loan_red_carpet_104, t93.loan_other AS loan_other_105, t93.loan_buyout AS loan_buyout_106, t93.loan_buyout_show AS loan_buyout_show_107, t93.loan_buyout_film AS loan_buyout_film_108, t93.loan_buyout_music_video AS loan_buyout_music_video_109, t93.loan_buyout_music_artist AS loan_buyout_music_artist_110, t93.loan_buyout_talent AS loan_buyout_talent_111, t93.loan_buyout_editorial AS loan_buyout_editorial_112, t93.loan_buyout_advertisement AS loan_buyout_advertisement_113, t93.loan_buyout_photoshoot AS loan_buyout_photoshoot_114, t93.loan_buyout_red_carpet AS loan_buyout_red_carpet_115, t93.loan_buyout_other AS loan_buyout_other_116, t93.loan_buyout_price_percent AS loan_buyout_price_percent_117, t93.return_insurance AS return_insurance_118, t93.policy_insurance AS policy_insurance_119, t93.reasonable_wear_and_tear AS reasonable_wear_and_tear_120, t93.late_fee_type AS late_fee_type_121, t93.late_fee_amount AS late_fee_amount_122, t93.late_fee_percent AS late_fee_percent_123, t93.late_fee_period AS late_fee_period_124, t93.security_hold AS security_hold_125, t93.security_hold_percent AS security_hold_percent_126, t93.quantity_update AS quantity_update_127, t93.brand_id AS brand_id_128, t129.id AS id_130, t129.rental AS rental_131, t129.rental_fee_type AS rental_fee_type_132, t129.rental_fee_amount AS rental_fee_amount_133, t129.rental_price_percent AS rental_price_percent_134, t129.rental_period AS rental_period_135, t129.rental_show AS rental_show_136, t129.rental_film AS rental_film_137, t129.rental_music_video AS rental_music_video_138, t129.rental_music_artist AS rental_music_artist_139, t129.rental_talent AS rental_talent_140, t129.rental_editorial AS rental_editorial_141, t129.rental_advertisement AS rental_advertisement_142, t129.rental_photoshoot AS rental_photoshoot_143, t129.rental_red_carpet AS rental_red_carpet_144, t129.rental_other AS rental_other_145, t129.rental_buyout AS rental_buyout_146, t129.rental_buyout_show AS rental_buyout_show_147, t129.rental_buyout_film AS rental_buyout_film_148, t129.rental_buyout_music_video AS rental_buyout_music_video_149, t129.rental_buyout_music_artist AS rental_buyout_music_artist_150, t129.rental_buyout_talent AS rental_buyout_talent_151, t129.rental_buyout_editorial AS rental_buyout_editorial_152, t129.rental_buyout_advertisement AS rental_buyout_advertisement_153, t129.rental_buyout_photoshoot AS rental_buyout_photoshoot_154, t129.rental_buyout_red_carpet AS rental_buyout_red_carpet_155, t129.rental_buyout_other AS rental_buyout_other_156, t129.rental_buyout_price_percent AS rental_buyout_price_percent_157, t129.return_insurance AS return_insurance_158, t129.policy_insurance AS policy_insurance_159, t129.reasonable_wear_and_tear AS reasonable_wear_and_tear_160, t129.late_fee_type AS late_fee_type_161, t129.late_fee_amount AS late_fee_amount_162, t129.late_fee_percent AS late_fee_percent_163, t129.late_fee_period AS late_fee_period_164, t129.security_hold AS security_hold_165, t129.security_hold_percent AS security_hold_percent_166, t129.quantity_update AS quantity_update_167, t129.brand_id AS brand_id_168, t169.id AS id_170, t169.purchase AS purchase_171, t169.purchase_price_percent AS purchase_price_percent_172, t169.purchase_show AS purchase_show_173, t169.purchase_film AS purchase_film_174, t169.purchase_music_video AS purchase_music_video_175, t169.purchase_music_artist AS purchase_music_artist_176, t169.purchase_talent AS purchase_talent_177, t169.purchase_editorial AS purchase_editorial_178, t169.purchase_advertisement AS purchase_advertisement_179, t169.purchase_photoshoot AS purchase_photoshoot_180, t169.purchase_red_carpet AS purchase_red_carpet_181, t169.purchase_other AS purchase_other_182, t169.reserve_purchase AS reserve_purchase_183, t169.reserve_purchase_price_percent AS reserve_purchase_price_percent_184, t169.reserve_purchase_show AS reserve_purchase_show_185, t169.reserve_purchase_film AS reserve_purchase_film_186, t169.reserve_purchase_music_video AS reserve_purchase_music_video_187, t169.reserve_purchase_music_artist AS reserve_purchase_music_artist_188, t169.reserve_purchase_talent AS reserve_purchase_talent_189, t169.reserve_purchase_editorial AS reserve_purchase_editorial_190, t169.reserve_purchase_advertisement AS reserve_purchase_advertisement_191, t169.reserve_purchase_photoshoot AS reserve_purchase_photoshoot_192, t169.reserve_purchase_red_carpet AS reserve_purchase_red_carpet_193, t169.reserve_purchase_other AS reserve_purchase_other_194, t169.return_policy AS return_policy_195, t169.care AS care_196, t169.quantity_update AS quantity_update_197, t169.brand_id AS brand_id_198, t199.id AS id_200, t199.custom_commission AS custom_commission_201, t199.custom_commission_show AS custom_commission_show_202, t199.custom_commission_film AS custom_commission_film_203, t199.custom_commission_music_video AS custom_commission_music_video_204, t199.custom_commission_music_artist AS custom_commission_music_artist_205, t199.custom_commission_talent AS custom_commission_talent_206, t199.custom_commission_editorial AS custom_commission_editorial_207, t199.custom_commission_advertisement AS custom_commission_advertisement_208, t199.brand_id AS brand_id_209, t210.id AS id_211, t210.in_person AS in_person_212, t210.industry_discount AS industry_discount_213, t210.industry_discount_price_percent AS industry_discount_price_percent_214, t210.return_policy AS return_policy_215, t210.care AS care_216, t210.online_shopping AS online_shopping_217, t210.shipping_policy AS shipping_policy_218, t210.quantity_update AS quantity_update_219, t210.brand_id AS brand_id_220, t221.id AS id_222, t221.discovery AS discovery_223, t221.discovery_show AS discovery_show_224, t221.discovery_film AS discovery_film_225, t221.discovery_music_video AS discovery_music_video_226, t221.discovery_music_artist AS discovery_music_artist_227, t221.discovery_talent AS discovery_talent_228, t221.discovery_editorial AS discovery_editorial_229, t221.discovery_advertisement AS discovery_advertisement_230, t221.shipping_policy AS shipping_policy_231, t221.return_policy AS return_policy_232, t221.care AS care_233, t221.quantity_update AS quantity_update_234, t221.brand_id AS brand_id_235, t0.service_fee_currency AS service_fee_currency_236, t0.province_id AS province_id_237, t238.has_network_dashboard AS has_network_dashboard_239, t238.has_network_email AS has_network_email_240, t238.has_show_dashboard AS has_show_dashboard_241, t238.has_show_email AS has_show_email_242, t238.has_studio_dashboard AS has_studio_dashboard_243, t238.has_studio_email AS has_studio_email_244, t238.has_film_dashboard AS has_film_dashboard_245, t238.has_film_email AS has_film_email_246, t238.has_record_label_dashboard AS has_record_label_dashboard_247, t238.has_record_label_email AS has_record_label_email_248, t238.has_music_video_dashboard AS has_music_video_dashboard_249, t238.has_music_video_email AS has_music_video_email_250, t238.has_talent_dashboard AS has_talent_dashboard_251, t238.has_talent_email AS has_talent_email_252, t238.has_editorial_dashboard AS has_editorial_dashboard_253, t238.has_editorial_email AS has_editorial_email_254, t238.id AS id_255, t238.brand_id AS brand_id_256 FROM brand t0 LEFT JOIN brand_settings_loan t93 ON t93.brand_id = t0.id LEFT JOIN brand_settings_rental t129 ON t129.brand_id = t0.id LEFT JOIN brand_settings_purchase t169 ON t169.brand_id = t0.id LEFT JOIN brand_settings_custom_commission t199 ON t199.brand_id = t0.id LEFT JOIN brand_settings_in_person t210 ON t210.brand_id = t0.id LEFT JOIN brand_settings_discovery t221 ON t221.brand_id = t0.id LEFT JOIN brand_notify_new_added_productions t238 ON t238.brand_id = t0.id WHERE t0.id = ?

Parameters:

[
  44
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.title AS title_2,
  t0.has_affiliate_url AS has_affiliate_url_3,
  t0.location AS location_4,
  t0.logo AS logo_5,
  t0.sizeGuide AS sizeGuide_6,
  t0.commission AS commission_7,
  t0.website AS website_8,
  t0.phone AS phone_9,
  t0.fax AS fax_10,
  t0.contact_first_name AS contact_first_name_11,
  t0.contact_last_name AS contact_last_name_12,
  t0.email AS email_13,
  t0.position AS position_14,
  t0.id AS id_15,
  t0.shipping_policy AS shipping_policy_16,
  t0.return_policy AS return_policy_17,
  t0.auto_mainstreet AS auto_mainstreet_18,
  t0.created AS created_19,
  t0.po_box AS po_box_20,
  t0.reasonable_wear_and_tear AS reasonable_wear_and_tear_21,
  t0.low_volume_production AS low_volume_production_22,
  t0.based_in AS based_in_23,
  t0.shopify_shop_domain AS shopify_shop_domain_24,
  t0.shopify_api_key AS shopify_api_key_25,
  t0.shopify_password AS shopify_password_26,
  t0.shopify_private AS shopify_private_27,
  t0.shopify_custom_access_token AS shopify_custom_access_token_28,
  t0.shopify_custom_api_key AS shopify_custom_api_key_29,
  t0.shopify_custom_api_secret_key AS shopify_custom_api_secret_key_30,
  t0.shopify_access_token AS shopify_access_token_31,
  t0.shopify_installation_link AS shopify_installation_link_32,
  t0.shopify_client_id AS shopify_client_id_33,
  t0.shopify_client_secret AS shopify_client_secret_34,
  t0.update_shopify AS update_shopify_35,
  t0.quantity_update AS quantity_update_36,
  t0.default_measurement_type AS default_measurement_type_37,
  t0.shopifyWay AS shopifyWay_38,
  t0.shopifySource AS shopifySource_39,
  t0.shopifyCollection AS shopifyCollection_40,
  t0.squarespaceSource AS squarespaceSource_41,
  t0.squarespaceStorePage AS squarespaceStorePage_42,
  t0.shopify_on AS shopify_on_43,
  t0.integration AS integration_44,
  t0.squarespace_url AS squarespace_url_45,
  t0.default_shopify_other_sizes_colors AS default_shopify_other_sizes_colors_46,
  t0.instagram_username AS instagram_username_47,
  t0.instagram_link AS instagram_link_48,
  t0.twitter_username AS twitter_username_49,
  t0.twitter_link AS twitter_link_50,
  t0.tiktok_username AS tiktok_username_51,
  t0.tiktok_link AS tiktok_link_52,
  t0.facebook_username AS facebook_username_53,
  t0.facebook_link AS facebook_link_54,
  t0.description AS description_55,
  t0.care AS care_56,
  t0.plan AS plan_57,
  t0.joined_first_time AS joined_first_time_58,
  t0.joined AS joined_59,
  t0.renewed_on AS renewed_on_60,
  t0.plan_auto_renewal_date AS plan_auto_renewal_date_61,
  t0.plan_expiration_date AS plan_expiration_date_62,
  t0.plan_billing_cycle AS plan_billing_cycle_63,
  t0.new_plan_billing_cycle AS new_plan_billing_cycle_64,
  t0.new_plan AS new_plan_65,
  t0.hold AS hold_66,
  t0.stripe_subscription AS stripe_subscription_67,
  t0.stripe_subscription_schedule AS stripe_subscription_schedule_68,
  t0.insurance AS insurance_69,
  t0.hide_add_project AS hide_add_project_70,
  t0.payout_method AS payout_method_71,
  t0.payout_account_number AS payout_account_number_72,
  t0.payout_paypal_email AS payout_paypal_email_73,
  t0.service_fee_percent AS service_fee_percent_74,
  t0.service_fee_min AS service_fee_min_75,
  t0.is_canadian AS is_canadian_76,
  t0.disable_shopify_sync_remove AS disable_shopify_sync_remove_77,
  t0.squarespace_auth_code AS squarespace_auth_code_78,
  t0.squarespace_access_token AS squarespace_access_token_79,
  t0.squarespace_refresh_token AS squarespace_refresh_token_80,
  t0.squarespace_access_token_expiration AS squarespace_access_token_expiration_81,
  t0.last_squarespace_update AS last_squarespace_update_82,
  t0.disable_squarespace_sync_remove AS disable_squarespace_sync_remove_83,
  t0.approve_future_productions AS approve_future_productions_84,
  t0.wallet_id AS wallet_id_85,
  t0.stripe_customer AS stripe_customer_86,
  t0.url_name AS url_name_87,
  t0.currency_id AS currency_id_88,
  t0.main_image_id AS main_image_id_89,
  t0.default_shopify_product_type_id AS default_shopify_product_type_id_90,
  t0.default_shopify_sub_category_id AS default_shopify_sub_category_id_91,
  t0.default_shopify_season_id AS default_shopify_season_id_92,
  t93.id AS id_94,
  t93.loan AS loan_95,
  t93.loan_show AS loan_show_96,
  t93.loan_film AS loan_film_97,
  t93.loan_music_video AS loan_music_video_98,
  t93.loan_music_artist AS loan_music_artist_99,
  t93.loan_talent AS loan_talent_100,
  t93.loan_editorial AS loan_editorial_101,
  t93.loan_advertisement AS loan_advertisement_102,
  t93.loan_photoshoot AS loan_photoshoot_103,
  t93.loan_red_carpet AS loan_red_carpet_104,
  t93.loan_other AS loan_other_105,
  t93.loan_buyout AS loan_buyout_106,
  t93.loan_buyout_show AS loan_buyout_show_107,
  t93.loan_buyout_film AS loan_buyout_film_108,
  t93.loan_buyout_music_video AS loan_buyout_music_video_109,
  t93.loan_buyout_music_artist AS loan_buyout_music_artist_110,
  t93.loan_buyout_talent AS loan_buyout_talent_111,
  t93.loan_buyout_editorial AS loan_buyout_editorial_112,
  t93.loan_buyout_advertisement AS loan_buyout_advertisement_113,
  t93.loan_buyout_photoshoot AS loan_buyout_photoshoot_114,
  t93.loan_buyout_red_carpet AS loan_buyout_red_carpet_115,
  t93.loan_buyout_other AS loan_buyout_other_116,
  t93.loan_buyout_price_percent AS loan_buyout_price_percent_117,
  t93.return_insurance AS return_insurance_118,
  t93.policy_insurance AS policy_insurance_119,
  t93.reasonable_wear_and_tear AS reasonable_wear_and_tear_120,
  t93.late_fee_type AS late_fee_type_121,
  t93.late_fee_amount AS late_fee_amount_122,
  t93.late_fee_percent AS late_fee_percent_123,
  t93.late_fee_period AS late_fee_period_124,
  t93.security_hold AS security_hold_125,
  t93.security_hold_percent AS security_hold_percent_126,
  t93.quantity_update AS quantity_update_127,
  t93.brand_id AS brand_id_128,
  t129.id AS id_130,
  t129.rental AS rental_131,
  t129.rental_fee_type AS rental_fee_type_132,
  t129.rental_fee_amount AS rental_fee_amount_133,
  t129.rental_price_percent AS rental_price_percent_134,
  t129.rental_period AS rental_period_135,
  t129.rental_show AS rental_show_136,
  t129.rental_film AS rental_film_137,
  t129.rental_music_video AS rental_music_video_138,
  t129.rental_music_artist AS rental_music_artist_139,
  t129.rental_talent AS rental_talent_140,
  t129.rental_editorial AS rental_editorial_141,
  t129.rental_advertisement AS rental_advertisement_142,
  t129.rental_photoshoot AS rental_photoshoot_143,
  t129.rental_red_carpet AS rental_red_carpet_144,
  t129.rental_other AS rental_other_145,
  t129.rental_buyout AS rental_buyout_146,
  t129.rental_buyout_show AS rental_buyout_show_147,
  t129.rental_buyout_film AS rental_buyout_film_148,
  t129.rental_buyout_music_video AS rental_buyout_music_video_149,
  t129.rental_buyout_music_artist AS rental_buyout_music_artist_150,
  t129.rental_buyout_talent AS rental_buyout_talent_151,
  t129.rental_buyout_editorial AS rental_buyout_editorial_152,
  t129.rental_buyout_advertisement AS rental_buyout_advertisement_153,
  t129.rental_buyout_photoshoot AS rental_buyout_photoshoot_154,
  t129.rental_buyout_red_carpet AS rental_buyout_red_carpet_155,
  t129.rental_buyout_other AS rental_buyout_other_156,
  t129.rental_buyout_price_percent AS rental_buyout_price_percent_157,
  t129.return_insurance AS return_insurance_158,
  t129.policy_insurance AS policy_insurance_159,
  t129.reasonable_wear_and_tear AS reasonable_wear_and_tear_160,
  t129.late_fee_type AS late_fee_type_161,
  t129.late_fee_amount AS late_fee_amount_162,
  t129.late_fee_percent AS late_fee_percent_163,
  t129.late_fee_period AS late_fee_period_164,
  t129.security_hold AS security_hold_165,
  t129.security_hold_percent AS security_hold_percent_166,
  t129.quantity_update AS quantity_update_167,
  t129.brand_id AS brand_id_168,
  t169.id AS id_170,
  t169.purchase AS purchase_171,
  t169.purchase_price_percent AS purchase_price_percent_172,
  t169.purchase_show AS purchase_show_173,
  t169.purchase_film AS purchase_film_174,
  t169.purchase_music_video AS purchase_music_video_175,
  t169.purchase_music_artist AS purchase_music_artist_176,
  t169.purchase_talent AS purchase_talent_177,
  t169.purchase_editorial AS purchase_editorial_178,
  t169.purchase_advertisement AS purchase_advertisement_179,
  t169.purchase_photoshoot AS purchase_photoshoot_180,
  t169.purchase_red_carpet AS purchase_red_carpet_181,
  t169.purchase_other AS purchase_other_182,
  t169.reserve_purchase AS reserve_purchase_183,
  t169.reserve_purchase_price_percent AS reserve_purchase_price_percent_184,
  t169.reserve_purchase_show AS reserve_purchase_show_185,
  t169.reserve_purchase_film AS reserve_purchase_film_186,
  t169.reserve_purchase_music_video AS reserve_purchase_music_video_187,
  t169.reserve_purchase_music_artist AS reserve_purchase_music_artist_188,
  t169.reserve_purchase_talent AS reserve_purchase_talent_189,
  t169.reserve_purchase_editorial AS reserve_purchase_editorial_190,
  t169.reserve_purchase_advertisement AS reserve_purchase_advertisement_191,
  t169.reserve_purchase_photoshoot AS reserve_purchase_photoshoot_192,
  t169.reserve_purchase_red_carpet AS reserve_purchase_red_carpet_193,
  t169.reserve_purchase_other AS reserve_purchase_other_194,
  t169.return_policy AS return_policy_195,
  t169.care AS care_196,
  t169.quantity_update AS quantity_update_197,
  t169.brand_id AS brand_id_198,
  t199.id AS id_200,
  t199.custom_commission AS custom_commission_201,
  t199.custom_commission_show AS custom_commission_show_202,
  t199.custom_commission_film AS custom_commission_film_203,
  t199.custom_commission_music_video AS custom_commission_music_video_204,
  t199.custom_commission_music_artist AS custom_commission_music_artist_205,
  t199.custom_commission_talent AS custom_commission_talent_206,
  t199.custom_commission_editorial AS custom_commission_editorial_207,
  t199.custom_commission_advertisement AS custom_commission_advertisement_208,
  t199.brand_id AS brand_id_209,
  t210.id AS id_211,
  t210.in_person AS in_person_212,
  t210.industry_discount AS industry_discount_213,
  t210.industry_discount_price_percent AS industry_discount_price_percent_214,
  t210.return_policy AS return_policy_215,
  t210.care AS care_216,
  t210.online_shopping AS online_shopping_217,
  t210.shipping_policy AS shipping_policy_218,
  t210.quantity_update AS quantity_update_219,
  t210.brand_id AS brand_id_220,
  t221.id AS id_222,
  t221.discovery AS discovery_223,
  t221.discovery_show AS discovery_show_224,
  t221.discovery_film AS discovery_film_225,
  t221.discovery_music_video AS discovery_music_video_226,
  t221.discovery_music_artist AS discovery_music_artist_227,
  t221.discovery_talent AS discovery_talent_228,
  t221.discovery_editorial AS discovery_editorial_229,
  t221.discovery_advertisement AS discovery_advertisement_230,
  t221.shipping_policy AS shipping_policy_231,
  t221.return_policy AS return_policy_232,
  t221.care AS care_233,
  t221.quantity_update AS quantity_update_234,
  t221.brand_id AS brand_id_235,
  t0.service_fee_currency AS service_fee_currency_236,
  t0.province_id AS province_id_237,
  t238.has_network_dashboard AS has_network_dashboard_239,
  t238.has_network_email AS has_network_email_240,
  t238.has_show_dashboard AS has_show_dashboard_241,
  t238.has_show_email AS has_show_email_242,
  t238.has_studio_dashboard AS has_studio_dashboard_243,
  t238.has_studio_email AS has_studio_email_244,
  t238.has_film_dashboard AS has_film_dashboard_245,
  t238.has_film_email AS has_film_email_246,
  t238.has_record_label_dashboard AS has_record_label_dashboard_247,
  t238.has_record_label_email AS has_record_label_email_248,
  t238.has_music_video_dashboard AS has_music_video_dashboard_249,
  t238.has_music_video_email AS has_music_video_email_250,
  t238.has_talent_dashboard AS has_talent_dashboard_251,
  t238.has_talent_email AS has_talent_email_252,
  t238.has_editorial_dashboard AS has_editorial_dashboard_253,
  t238.has_editorial_email AS has_editorial_email_254,
  t238.id AS id_255,
  t238.brand_id AS brand_id_256
FROM
  brand t0
  LEFT JOIN brand_settings_loan t93 ON t93.brand_id = t0.id
  LEFT JOIN brand_settings_rental t129 ON t129.brand_id = t0.id
  LEFT JOIN brand_settings_purchase t169 ON t169.brand_id = t0.id
  LEFT JOIN brand_settings_custom_commission t199 ON t199.brand_id = t0.id
  LEFT JOIN brand_settings_in_person t210 ON t210.brand_id = t0.id
  LEFT JOIN brand_settings_discovery t221 ON t221.brand_id = t0.id
  LEFT JOIN brand_notify_new_added_productions t238 ON t238.brand_id = t0.id
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.title AS title_2, t0.has_affiliate_url AS has_affiliate_url_3, t0.location AS location_4, t0.logo AS logo_5, t0.sizeGuide AS sizeGuide_6, t0.commission AS commission_7, t0.website AS website_8, t0.phone AS phone_9, t0.fax AS fax_10, t0.contact_first_name AS contact_first_name_11, t0.contact_last_name AS contact_last_name_12, t0.email AS email_13, t0.position AS position_14, t0.id AS id_15, t0.shipping_policy AS shipping_policy_16, t0.return_policy AS return_policy_17, t0.auto_mainstreet AS auto_mainstreet_18, t0.created AS created_19, t0.po_box AS po_box_20, t0.reasonable_wear_and_tear AS reasonable_wear_and_tear_21, t0.low_volume_production AS low_volume_production_22, t0.based_in AS based_in_23, t0.shopify_shop_domain AS shopify_shop_domain_24, t0.shopify_api_key AS shopify_api_key_25, t0.shopify_password AS shopify_password_26, t0.shopify_private AS shopify_private_27, t0.shopify_custom_access_token AS shopify_custom_access_token_28, t0.shopify_custom_api_key AS shopify_custom_api_key_29, t0.shopify_custom_api_secret_key AS shopify_custom_api_secret_key_30, t0.shopify_access_token AS shopify_access_token_31, t0.shopify_installation_link AS shopify_installation_link_32, t0.shopify_client_id AS shopify_client_id_33, t0.shopify_client_secret AS shopify_client_secret_34, t0.update_shopify AS update_shopify_35, t0.quantity_update AS quantity_update_36, t0.default_measurement_type AS default_measurement_type_37, t0.shopifyWay AS shopifyWay_38, t0.shopifySource AS shopifySource_39, t0.shopifyCollection AS shopifyCollection_40, t0.squarespaceSource AS squarespaceSource_41, t0.squarespaceStorePage AS squarespaceStorePage_42, t0.shopify_on AS shopify_on_43, t0.integration AS integration_44, t0.squarespace_url AS squarespace_url_45, t0.default_shopify_other_sizes_colors AS default_shopify_other_sizes_colors_46, t0.instagram_username AS instagram_username_47, t0.instagram_link AS instagram_link_48, t0.twitter_username AS twitter_username_49, t0.twitter_link AS twitter_link_50, t0.tiktok_username AS tiktok_username_51, t0.tiktok_link AS tiktok_link_52, t0.facebook_username AS facebook_username_53, t0.facebook_link AS facebook_link_54, t0.description AS description_55, t0.care AS care_56, t0.plan AS plan_57, t0.joined_first_time AS joined_first_time_58, t0.joined AS joined_59, t0.renewed_on AS renewed_on_60, t0.plan_auto_renewal_date AS plan_auto_renewal_date_61, t0.plan_expiration_date AS plan_expiration_date_62, t0.plan_billing_cycle AS plan_billing_cycle_63, t0.new_plan_billing_cycle AS new_plan_billing_cycle_64, t0.new_plan AS new_plan_65, t0.hold AS hold_66, t0.stripe_subscription AS stripe_subscription_67, t0.stripe_subscription_schedule AS stripe_subscription_schedule_68, t0.insurance AS insurance_69, t0.hide_add_project AS hide_add_project_70, t0.payout_method AS payout_method_71, t0.payout_account_number AS payout_account_number_72, t0.payout_paypal_email AS payout_paypal_email_73, t0.service_fee_percent AS service_fee_percent_74, t0.service_fee_min AS service_fee_min_75, t0.is_canadian AS is_canadian_76, t0.disable_shopify_sync_remove AS disable_shopify_sync_remove_77, t0.squarespace_auth_code AS squarespace_auth_code_78, t0.squarespace_access_token AS squarespace_access_token_79, t0.squarespace_refresh_token AS squarespace_refresh_token_80, t0.squarespace_access_token_expiration AS squarespace_access_token_expiration_81, t0.last_squarespace_update AS last_squarespace_update_82, t0.disable_squarespace_sync_remove AS disable_squarespace_sync_remove_83, t0.approve_future_productions AS approve_future_productions_84, t0.wallet_id AS wallet_id_85, t0.stripe_customer AS stripe_customer_86, t0.url_name AS url_name_87, t0.currency_id AS currency_id_88, t0.main_image_id AS main_image_id_89, t0.default_shopify_product_type_id AS default_shopify_product_type_id_90, t0.default_shopify_sub_category_id AS default_shopify_sub_category_id_91, t0.default_shopify_season_id AS default_shopify_season_id_92, t93.id AS id_94, t93.loan AS loan_95, t93.loan_show AS loan_show_96, t93.loan_film AS loan_film_97, t93.loan_music_video AS loan_music_video_98, t93.loan_music_artist AS loan_music_artist_99, t93.loan_talent AS loan_talent_100, t93.loan_editorial AS loan_editorial_101, t93.loan_advertisement AS loan_advertisement_102, t93.loan_photoshoot AS loan_photoshoot_103, t93.loan_red_carpet AS loan_red_carpet_104, t93.loan_other AS loan_other_105, t93.loan_buyout AS loan_buyout_106, t93.loan_buyout_show AS loan_buyout_show_107, t93.loan_buyout_film AS loan_buyout_film_108, t93.loan_buyout_music_video AS loan_buyout_music_video_109, t93.loan_buyout_music_artist AS loan_buyout_music_artist_110, t93.loan_buyout_talent AS loan_buyout_talent_111, t93.loan_buyout_editorial AS loan_buyout_editorial_112, t93.loan_buyout_advertisement AS loan_buyout_advertisement_113, t93.loan_buyout_photoshoot AS loan_buyout_photoshoot_114, t93.loan_buyout_red_carpet AS loan_buyout_red_carpet_115, t93.loan_buyout_other AS loan_buyout_other_116, t93.loan_buyout_price_percent AS loan_buyout_price_percent_117, t93.return_insurance AS return_insurance_118, t93.policy_insurance AS policy_insurance_119, t93.reasonable_wear_and_tear AS reasonable_wear_and_tear_120, t93.late_fee_type AS late_fee_type_121, t93.late_fee_amount AS late_fee_amount_122, t93.late_fee_percent AS late_fee_percent_123, t93.late_fee_period AS late_fee_period_124, t93.security_hold AS security_hold_125, t93.security_hold_percent AS security_hold_percent_126, t93.quantity_update AS quantity_update_127, t93.brand_id AS brand_id_128, t129.id AS id_130, t129.rental AS rental_131, t129.rental_fee_type AS rental_fee_type_132, t129.rental_fee_amount AS rental_fee_amount_133, t129.rental_price_percent AS rental_price_percent_134, t129.rental_period AS rental_period_135, t129.rental_show AS rental_show_136, t129.rental_film AS rental_film_137, t129.rental_music_video AS rental_music_video_138, t129.rental_music_artist AS rental_music_artist_139, t129.rental_talent AS rental_talent_140, t129.rental_editorial AS rental_editorial_141, t129.rental_advertisement AS rental_advertisement_142, t129.rental_photoshoot AS rental_photoshoot_143, t129.rental_red_carpet AS rental_red_carpet_144, t129.rental_other AS rental_other_145, t129.rental_buyout AS rental_buyout_146, t129.rental_buyout_show AS rental_buyout_show_147, t129.rental_buyout_film AS rental_buyout_film_148, t129.rental_buyout_music_video AS rental_buyout_music_video_149, t129.rental_buyout_music_artist AS rental_buyout_music_artist_150, t129.rental_buyout_talent AS rental_buyout_talent_151, t129.rental_buyout_editorial AS rental_buyout_editorial_152, t129.rental_buyout_advertisement AS rental_buyout_advertisement_153, t129.rental_buyout_photoshoot AS rental_buyout_photoshoot_154, t129.rental_buyout_red_carpet AS rental_buyout_red_carpet_155, t129.rental_buyout_other AS rental_buyout_other_156, t129.rental_buyout_price_percent AS rental_buyout_price_percent_157, t129.return_insurance AS return_insurance_158, t129.policy_insurance AS policy_insurance_159, t129.reasonable_wear_and_tear AS reasonable_wear_and_tear_160, t129.late_fee_type AS late_fee_type_161, t129.late_fee_amount AS late_fee_amount_162, t129.late_fee_percent AS late_fee_percent_163, t129.late_fee_period AS late_fee_period_164, t129.security_hold AS security_hold_165, t129.security_hold_percent AS security_hold_percent_166, t129.quantity_update AS quantity_update_167, t129.brand_id AS brand_id_168, t169.id AS id_170, t169.purchase AS purchase_171, t169.purchase_price_percent AS purchase_price_percent_172, t169.purchase_show AS purchase_show_173, t169.purchase_film AS purchase_film_174, t169.purchase_music_video AS purchase_music_video_175, t169.purchase_music_artist AS purchase_music_artist_176, t169.purchase_talent AS purchase_talent_177, t169.purchase_editorial AS purchase_editorial_178, t169.purchase_advertisement AS purchase_advertisement_179, t169.purchase_photoshoot AS purchase_photoshoot_180, t169.purchase_red_carpet AS purchase_red_carpet_181, t169.purchase_other AS purchase_other_182, t169.reserve_purchase AS reserve_purchase_183, t169.reserve_purchase_price_percent AS reserve_purchase_price_percent_184, t169.reserve_purchase_show AS reserve_purchase_show_185, t169.reserve_purchase_film AS reserve_purchase_film_186, t169.reserve_purchase_music_video AS reserve_purchase_music_video_187, t169.reserve_purchase_music_artist AS reserve_purchase_music_artist_188, t169.reserve_purchase_talent AS reserve_purchase_talent_189, t169.reserve_purchase_editorial AS reserve_purchase_editorial_190, t169.reserve_purchase_advertisement AS reserve_purchase_advertisement_191, t169.reserve_purchase_photoshoot AS reserve_purchase_photoshoot_192, t169.reserve_purchase_red_carpet AS reserve_purchase_red_carpet_193, t169.reserve_purchase_other AS reserve_purchase_other_194, t169.return_policy AS return_policy_195, t169.care AS care_196, t169.quantity_update AS quantity_update_197, t169.brand_id AS brand_id_198, t199.id AS id_200, t199.custom_commission AS custom_commission_201, t199.custom_commission_show AS custom_commission_show_202, t199.custom_commission_film AS custom_commission_film_203, t199.custom_commission_music_video AS custom_commission_music_video_204, t199.custom_commission_music_artist AS custom_commission_music_artist_205, t199.custom_commission_talent AS custom_commission_talent_206, t199.custom_commission_editorial AS custom_commission_editorial_207, t199.custom_commission_advertisement AS custom_commission_advertisement_208, t199.brand_id AS brand_id_209, t210.id AS id_211, t210.in_person AS in_person_212, t210.industry_discount AS industry_discount_213, t210.industry_discount_price_percent AS industry_discount_price_percent_214, t210.return_policy AS return_policy_215, t210.care AS care_216, t210.online_shopping AS online_shopping_217, t210.shipping_policy AS shipping_policy_218, t210.quantity_update AS quantity_update_219, t210.brand_id AS brand_id_220, t221.id AS id_222, t221.discovery AS discovery_223, t221.discovery_show AS discovery_show_224, t221.discovery_film AS discovery_film_225, t221.discovery_music_video AS discovery_music_video_226, t221.discovery_music_artist AS discovery_music_artist_227, t221.discovery_talent AS discovery_talent_228, t221.discovery_editorial AS discovery_editorial_229, t221.discovery_advertisement AS discovery_advertisement_230, t221.shipping_policy AS shipping_policy_231, t221.return_policy AS return_policy_232, t221.care AS care_233, t221.quantity_update AS quantity_update_234, t221.brand_id AS brand_id_235, t0.service_fee_currency AS service_fee_currency_236, t0.province_id AS province_id_237, t238.has_network_dashboard AS has_network_dashboard_239, t238.has_network_email AS has_network_email_240, t238.has_show_dashboard AS has_show_dashboard_241, t238.has_show_email AS has_show_email_242, t238.has_studio_dashboard AS has_studio_dashboard_243, t238.has_studio_email AS has_studio_email_244, t238.has_film_dashboard AS has_film_dashboard_245, t238.has_film_email AS has_film_email_246, t238.has_record_label_dashboard AS has_record_label_dashboard_247, t238.has_record_label_email AS has_record_label_email_248, t238.has_music_video_dashboard AS has_music_video_dashboard_249, t238.has_music_video_email AS has_music_video_email_250, t238.has_talent_dashboard AS has_talent_dashboard_251, t238.has_talent_email AS has_talent_email_252, t238.has_editorial_dashboard AS has_editorial_dashboard_253, t238.has_editorial_email AS has_editorial_email_254, t238.id AS id_255, t238.brand_id AS brand_id_256 FROM brand t0 LEFT JOIN brand_settings_loan t93 ON t93.brand_id = t0.id LEFT JOIN brand_settings_rental t129 ON t129.brand_id = t0.id LEFT JOIN brand_settings_purchase t169 ON t169.brand_id = t0.id LEFT JOIN brand_settings_custom_commission t199 ON t199.brand_id = t0.id LEFT JOIN brand_settings_in_person t210 ON t210.brand_id = t0.id LEFT JOIN brand_settings_discovery t221 ON t221.brand_id = t0.id LEFT JOIN brand_notify_new_added_productions t238 ON t238.brand_id = t0.id WHERE t0.id = 44;

#	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\Brand::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 61)
6	Proxies\__CG__\Mirinly\AdminBundle\Entity\Brand->__get (line 120)
7	Mirinly\AdminBundle\Entity\Brand->getCurrency (line 1160)
8	Mirinly\AdminBundle\Entity\ECommerceItem->getConvertedPriceOnMirinly (line 840)
9	Twig\Extension\CoreExtension->getAttribute (line 1911)
10	__TwigTemplate_474dfe10498a035a09d55974b3c7d50d::block_content (line 253)
11	Twig\Template->yieldBlock (line 446)
12	__TwigTemplate_3a8022cedc3a177a8d05e322c8e823dd->doDisplay (line 231)
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)

1.70 ms
(6.12%)

"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)

1.17 ms
(4.21%)

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

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Mirinly\FrontBundle\Controller\PageController->listLinksAction (line 51)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
7	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 78)
8	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
9	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 47)
10	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 44)
11	__TwigTemplate_3a8022cedc3a177a8d05e322c8e823dd->doDisplay (line 238)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_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)

0.90 ms
(3.23%)

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.79 ms
(2.83%)

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.55 ms
(1.98%)

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.49 ms
(1.78%)

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.46 ms
(1.65%)

SELECT t0.quantity AS quantity_1, t0.retail_price AS retail_price_2, t0.sale AS sale_3, t0.made_to_order AS made_to_order_4, t0.quantity_max AS quantity_max_5, t0.preorder AS preorder_6, t0.preorder_quantity AS preorder_quantity_7, t0.preorder_from AS preorder_from_8, t0.preorder_to AS preorder_to_9, t0.external_id AS external_id_10, t0.id AS id_11, t0.sku AS sku_12, t0.enable_shopify_sync AS enable_shopify_sync_13, t0.enable_squarespace_sync AS enable_squarespace_sync_14, t0.item_id AS item_id_15, t0.color_id AS color_id_16, t0.size_id AS size_id_17 FROM item_inventory_discovery t0 WHERE t0.item_id = ?

Parameters:

[
  41947
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.quantity AS quantity_1,
  t0.retail_price AS retail_price_2,
  t0.sale AS sale_3,
  t0.made_to_order AS made_to_order_4,
  t0.quantity_max AS quantity_max_5,
  t0.preorder AS preorder_6,
  t0.preorder_quantity AS preorder_quantity_7,
  t0.preorder_from AS preorder_from_8,
  t0.preorder_to AS preorder_to_9,
  t0.external_id AS external_id_10,
  t0.id AS id_11,
  t0.sku AS sku_12,
  t0.enable_shopify_sync AS enable_shopify_sync_13,
  t0.enable_squarespace_sync AS enable_squarespace_sync_14,
  t0.item_id AS item_id_15,
  t0.color_id AS color_id_16,
  t0.size_id AS size_id_17
FROM
  item_inventory_discovery t0
WHERE
  t0.item_id = ?

SELECT t0.quantity AS quantity_1, t0.retail_price AS retail_price_2, t0.sale AS sale_3, t0.made_to_order AS made_to_order_4, t0.quantity_max AS quantity_max_5, t0.preorder AS preorder_6, t0.preorder_quantity AS preorder_quantity_7, t0.preorder_from AS preorder_from_8, t0.preorder_to AS preorder_to_9, t0.external_id AS external_id_10, t0.id AS id_11, t0.sku AS sku_12, t0.enable_shopify_sync AS enable_shopify_sync_13, t0.enable_squarespace_sync AS enable_squarespace_sync_14, t0.item_id AS item_id_15, t0.color_id AS color_id_16, t0.size_id AS size_id_17 FROM item_inventory_discovery t0 WHERE t0.item_id = 41947;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 39)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	count (line 842)
9	Mirinly\AdminBundle\Entity\ECommerceItem::getConvertedPriceOnMirinly (line 842)
10	Twig\Extension\CoreExtension->getAttribute (line 1911)
11	__TwigTemplate_474dfe10498a035a09d55974b3c7d50d::block_content (line 253)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_3a8022cedc3a177a8d05e322c8e823dd->doDisplay (line 231)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_474dfe10498a035a09d55974b3c7d50d->doDisplay (line 54)
16	Twig\Template->yield (line 402)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 373)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
24	Mirinly\FrontBundle\Controller\GenieController->showAdminWishlistAction (line 915)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 185)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 29)
30	require_once (line 5)

0.44 ms
(1.57%)

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)

0.41 ms
(1.47%)

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_brand t0 WHERE t0.id = ?

Parameters:

[
  160129
]

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_brand 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_brand t0 WHERE t0.id = 160129;

#	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\ImageToBrand::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 61)
6	Proxies\__CG__\Mirinly\AdminBundle\Entity\ImageToBrand->__get (line 120)
7	Mirinly\AdminBundle\Entity\ImageToBrand->getImage (line 41)
8	Twig\Extension\CoreExtension->getAttribute (line 1911)
9	__TwigTemplate_474dfe10498a035a09d55974b3c7d50d::block_content (line 233)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_3a8022cedc3a177a8d05e322c8e823dd->doDisplay (line 231)
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)

0.33 ms
(1.17%)

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:

[
  160337
]

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 = 160337;

#	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	Twig\Extension\CoreExtension->getAttribute (line 1911)
9	__TwigTemplate_474dfe10498a035a09d55974b3c7d50d::block_content (line 233)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_3a8022cedc3a177a8d05e322c8e823dd->doDisplay (line 231)
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)

0.28 ms
(1.00%)

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.26 ms
(0.94%)

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

Parameters:

[
  1
  "2026-02-19 00:31:38"
  397
]

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:38', 397);

#	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.20 ms
(0.73%)

"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\Page	9
Mirinly\AdminBundle\Entity\Continent	7
Mirinly\AdminBundle\Entity\AdminWishlist	5
Mirinly\AdminBundle\Entity\Parameters	2
Mirinly\AdminBundle\Entity\ECommerceSubcategory	2
Mirinly\AdminBundle\Entity\ImageToBrand	2
Mirinly\AdminBundle\Entity\AdminWishlistItem	1
Mirinly\AdminBundle\Entity\ECommerceItem	1
Mirinly\AdminBundle\Entity\AdminWishlistTrend	1
Mirinly\AdminBundle\Entity\ECommerceItemType	1
Mirinly\AdminBundle\Entity\Brand	1
Mirinly\AdminBundle\Entity\ECommerceItemSettingsLoan	1
Mirinly\AdminBundle\Entity\ECommerceItemSettingsRental	1
Mirinly\AdminBundle\Entity\ECommerceItemSettingsPurchase	1
Mirinly\AdminBundle\Entity\ECommerceItemSettingsInPerson	1
Mirinly\AdminBundle\Entity\ECommerceItemSettingsDiscovery	1
Mirinly\AdminBundle\Entity\Image	1
Mirinly\AdminBundle\Entity\Season	1
Mirinly\AdminBundle\Entity\BrandSettingsLoan	1
Mirinly\AdminBundle\Entity\BrandSettingsRental	1
Mirinly\AdminBundle\Entity\BrandSettingsPurchase	1
Mirinly\AdminBundle\Entity\BrandSettingsCustomCommission	1
Mirinly\AdminBundle\Entity\BrandSettingsInPerson	1
Mirinly\AdminBundle\Entity\BrandSettingsDiscovery	1
Mirinly\AdminBundle\Entity\BrandNotifyNewAddedProductions	1
Mirinly\AdminBundle\Entity\ItemInventoryDiscovery	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.
Mirinly\AdminBundle\Entity\CustomerShippingAddress	No errors.
Mirinly\AdminBundle\Entity\ProjectRegistrationRequest	No errors.
Mirinly\AdminBundle\Entity\CartOrderProject	No errors.
Mirinly\AdminBundle\Entity\ProductionLookBook	No errors.
Mirinly\AdminBundle\Entity\ProductionLookBookFolder	No errors.
Mirinly\AdminBundle\Entity\ProductionWallet	No errors.
Mirinly\AdminBundle\Entity\WishlistItem	No errors.
Mirinly\AdminBundle\Entity\WishlistTrend	No errors.
Mirinly\AdminBundle\Entity\ECommerceCategory	No errors.
Mirinly\AdminBundle\Entity\SizeParamSet	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\ItemSizeParamGrid	No errors.
Mirinly\AdminBundle\Entity\ItemToBrandImage	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\NetworkMerch	No errors.
Mirinly\AdminBundle\Entity\NetworkPosts	No errors.
Mirinly\AdminBundle\Entity\NetworkLookBook	No errors.
Mirinly\AdminBundle\Entity\NetworkLookBookFolder	No errors.
Mirinly\AdminBundle\Entity\BrandApproveSeasonToNetwork	No errors.
Mirinly\AdminBundle\Entity\StudioMerch	No errors.
Mirinly\AdminBundle\Entity\StudioPosts	No errors.
Mirinly\AdminBundle\Entity\StudioLookBook	No errors.
Mirinly\AdminBundle\Entity\StudioLookBookFolder	No errors.
Mirinly\AdminBundle\Entity\BrandApproveSeasonToStudio	No errors.
Mirinly\AdminBundle\Entity\RecordLabelMerch	No errors.
Mirinly\AdminBundle\Entity\RecordLabelPosts	No errors.
Mirinly\AdminBundle\Entity\BrandApproveSeasonToRecordLabel	No errors.
Mirinly\AdminBundle\Entity\BrandApproveSeasonToEditorial	No errors.
Mirinly\AdminBundle\Entity\EditorialLookBook	No errors.
Mirinly\AdminBundle\Entity\EditorialLookBookFolder	No errors.
Mirinly\AdminBundle\Entity\EditorialWallet	No errors.
Mirinly\AdminBundle\Entity\Collection	The mappings Mirinly\AdminBundle\Entity\Collection#collectionItems and Mirinly\AdminBundle\Entity\CollectionItem#collection are inconsistent with each other.
Mirinly\AdminBundle\Entity\FilmLookBookItem	No errors.
Mirinly\AdminBundle\Entity\FilmLookBookFolderItem	No errors.
Mirinly\AdminBundle\Entity\FilmLookBookAttachment	No errors.
Mirinly\AdminBundle\Entity\FilmLookBookFolderAttachment	No errors.
Mirinly\AdminBundle\Entity\TvShowLookBookItem	No errors.
Mirinly\AdminBundle\Entity\TvShowLookBookFolderItem	No errors.
Mirinly\AdminBundle\Entity\TvShowLookBookAttachment	No errors.
Mirinly\AdminBundle\Entity\TvShowLookBookFolderAttachment	No errors.
Mirinly\AdminBundle\Entity\MusicVideoLookBookItem	No errors.
Mirinly\AdminBundle\Entity\MusicVideoLookBookFolderItem	No errors.
Mirinly\AdminBundle\Entity\MusicVideoLookBookAttachment	No errors.
Mirinly\AdminBundle\Entity\MusicVideoLookBookFolderAttachment	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\MusicPerformer	No errors.
Mirinly\AdminBundle\Entity\MusicArtistCharacterTrend	No errors.
Mirinly\AdminBundle\Entity\ItemInventory	The association Mirinly\AdminBundle\Entity\ItemInventory#item refers to the inverse side field Mirinly\AdminBundle\Entity\ECommerceItem#itemInventories which does not exist.
Mirinly\AdminBundle\Entity\ImageToNetwork	No errors.
Mirinly\AdminBundle\Entity\ImageToRecordLabel	No errors.
Mirinly\AdminBundle\Entity\ImageToStudio	No errors.
Mirinly\AdminBundle\Entity\Complaint	No errors.
Mirinly\AdminBundle\Entity\Page	No errors.
Mirinly\AdminBundle\Entity\PhotoAttachmentToProjectRequest	No errors.
Mirinly\AdminBundle\Entity\PhotoAttachmentLinkToProjectRequest	No errors.
Mirinly\AdminBundle\Entity\EpkAttachmentToProjectRequest	No errors.
Mirinly\AdminBundle\Entity\EpkAttachmentLinkToProjectRequest	No errors.
Mirinly\AdminBundle\Entity\LookBookAttachmentToProjectRequest	No errors.
Mirinly\AdminBundle\Entity\LookBookAttachmentLinkToProjectRequest	No errors.
Mirinly\AdminBundle\Entity\AudioAttachmentToProjectRequest	No errors.
Mirinly\AdminBundle\Entity\AudioAttachmentLinkToProjectRequest	No errors.
Mirinly\AdminBundle\Entity\EpkAttachmentToCartOrderProject	No errors.
Mirinly\AdminBundle\Entity\EpkAttachmentLinkToCartOrderProject	No errors.
Mirinly\AdminBundle\Entity\LookBookAttachmentToCartOrderProject	No errors.
Mirinly\AdminBundle\Entity\LookBookAttachmentLinkToCartOrderProject	No errors.
Mirinly\AdminBundle\Entity\AudioAttachmentToCartOrderProject	No errors.
Mirinly\AdminBundle\Entity\AudioAttachmentLinkToCartOrderProject	No errors.
Mirinly\AdminBundle\Entity\ProductionLookBookItem	No errors.
Mirinly\AdminBundle\Entity\ProductionLookBookFolderItem	No errors.
Mirinly\AdminBundle\Entity\ProductionLookBookAttachment	No errors.
Mirinly\AdminBundle\Entity\ProductionLookBookFolderAttachment	No errors.
Mirinly\AdminBundle\Entity\SizeParam	No errors.
Mirinly\AdminBundle\Entity\AddressAttachmentToBrand	No errors.
Mirinly\AdminBundle\Entity\NetworkLookBookItem	No errors.
Mirinly\AdminBundle\Entity\NetworkLookBookFolderItem	No errors.
Mirinly\AdminBundle\Entity\NetworkLookBookAttachment	No errors.
Mirinly\AdminBundle\Entity\NetworkLookBookFolderAttachment	No errors.
Mirinly\AdminBundle\Entity\StudioLookBookItem	No errors.
Mirinly\AdminBundle\Entity\StudioLookBookFolderItem	No errors.
Mirinly\AdminBundle\Entity\StudioLookBookAttachment	No errors.
Mirinly\AdminBundle\Entity\StudioLookBookFolderAttachment	No errors.
Mirinly\AdminBundle\Entity\EditorialLookBookItem	No errors.
Mirinly\AdminBundle\Entity\EditorialLookBookFolderItem	No errors.
Mirinly\AdminBundle\Entity\EditorialLookBookAttachment	No errors.
Mirinly\AdminBundle\Entity\EditorialLookBookFolderAttachment	No errors.
Mirinly\AdminBundle\Entity\Cart	No errors.
Mirinly\AdminBundle\Entity\AddressAttachment	No errors.
Mirinly\AdminBundle\Entity\CartOrder	No errors.
Mirinly\AdminBundle\Entity\CartSubOrder	No errors.
Mirinly\AdminBundle\Entity\IssueProductionOrderItem	No errors.
Mirinly\AdminBundle\Entity\IssueBrandOrderItem	No errors.
Mirinly\AdminBundle\Entity\CartItemProductionEdits	No errors.
Mirinly\AdminBundle\Entity\CartItemBrandEdits	No errors.

Symfony Profiler

GET https://mirinly.com/genie/production/wishlist/397/show

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping