Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

3.17 ms Query time

18 Invalid entities

3 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.61 ms
(82.26%)

SELECT e0_.name AS name_0, e0_.sku AS sku_1, e0_.price_on_mirinly AS price_on_mirinly_2, e0_.msrp AS msrp_3, e0_.sale_price AS sale_price_4, e0_.available_from_samples AS available_from_samples_5, e0_.available_from_mirinly AS available_from_mirinly_6, e0_.available AS available_7, e0_.affiliate_url AS affiliate_url_8, e0_.thumbnail AS thumbnail_9, e0_.additional_image_1 AS additional_image_1_10, e0_.additional_image_2 AS additional_image_2_11, e0_.additional_image_3 AS additional_image_3_12, e0_.additional_image_4 AS additional_image_4_13, e0_.sizeGuide AS sizeGuide_14, e0_.description AS description_15, e0_.position AS position_16, e0_.id AS id_17, e0_.featured AS featured_18, e0_.sponsored_global AS sponsored_global_19, e0_.sponsored_category AS sponsored_category_20, e0_.sponsored_sub_category AS sponsored_sub_category_21, e0_.based_in AS based_in_22, e0_.other_sizes_colors AS other_sizes_colors_23, e0_.measurement_type AS measurement_type_24, e0_.insurance_type AS insurance_type_25, e0_.insurance AS insurance_26, e0_.reasonable_wear_and_tear AS reasonable_wear_and_tear_27, e0_.low_volume_production AS low_volume_production_28, e0_.shipping_policy AS shipping_policy_29, e0_.return_policy AS return_policy_30, e0_.care AS care_31, e0_.created AS created_32, e0_.enable_shopify_sync AS enable_shopify_sync_33, e0_.enable_squarecpase_sync AS enable_squarecpase_sync_34, e0_.imported AS imported_35, e0_.removed AS removed_36, e0_.once_assigned AS once_assigned_37, e0_.default_cities AS default_cities_38, e0_.default_search_tags AS default_search_tags_39, e0_.external_id AS external_id_40, e0_.finalized_date AS finalized_date_41, e0_.e_commerce_subcategory_id AS e_commerce_subcategory_id_42, e0_.e_commerce_item_type_id AS e_commerce_item_type_id_43, e0_.e_commerce_item_template_id AS e_commerce_item_template_id_44, e0_.brand_id AS brand_id_45, e0_.main_image_id AS main_image_id_46 FROM e_commerce_item e0_ LEFT JOIN bind_film_scene_item_character b1_ ON (b1_.e_commerce_item_id = e0_.id) LEFT JOIN bind_film_character_signature_item b2_ ON (b2_.e_commerce_item_id = e0_.id) LEFT JOIN bind_film_set_item b3_ ON (b3_.e_commerce_item_id = e0_.id) LEFT JOIN bind_film_merch b4_ ON (b4_.e_commerce_item_id = e0_.id) LEFT JOIN bind_film_post_item_character b5_ ON (b5_.e_commerce_item_id = e0_.id) LEFT JOIN film_scene f6_ ON b1_.film_scene_id = f6_.id AND (f6_.publish = 1) LEFT JOIN film_character_signature f7_ ON b2_.film_character_signature_id = f7_.id LEFT JOIN film_character f8_ ON f7_.character_id = f8_.id LEFT JOIN film_set f9_ ON b3_.film_set_id = f9_.id AND (f9_.publish = 1) LEFT JOIN film_set_category f10_ ON f9_.film_set_category_id = f10_.id AND (f10_.publish = 1) LEFT JOIN film_merch f11_ ON b4_.film_merch_id = f11_.id AND (f11_.publish = 1) LEFT JOIN film_posts f12_ ON b5_.film_post_id = f12_.id AND (f12_.publish = 1) LEFT JOIN film f13_ ON (f13_.publish = 1 AND f13_.id = f6_.film_id OR f13_.id = f8_.film_id OR f13_.id = f10_.film_id OR f13_.id = f11_.film_id OR f13_.id = f12_.film_id) LEFT JOIN bind_tv_show_scene_item_character b14_ ON (b14_.e_commerce_item_id = e0_.id) LEFT JOIN bind_tv_show_character_signature_item b15_ ON (b15_.e_commerce_item_id = e0_.id) LEFT JOIN bind_tv_show_set_item b16_ ON (b16_.e_commerce_item_id = e0_.id) LEFT JOIN bind_tv_show_merch b17_ ON (b17_.e_commerce_item_id = e0_.id) LEFT JOIN bind_tv_show_post_item_character b18_ ON (b18_.e_commerce_item_id = e0_.id) LEFT JOIN tv_show_scene t19_ ON b14_.tv_show_scene_id = t19_.id AND (t19_.publish = 1) LEFT JOIN tv_show_episode t20_ ON t19_.tv_show_episode_id = t20_.id AND (t20_.publish = 1) LEFT JOIN tv_show_season t21_ ON t20_.tv_show_season_id = t21_.id AND (t21_.publish = 1) LEFT JOIN tv_show_character_signature t22_ ON b15_.tv_show_character_signature_id = t22_.id AND (t22_.publish = 1) LEFT JOIN tv_show_character t23_ ON t22_.character_id = t23_.id LEFT JOIN tv_show_set t24_ ON b16_.tv_show_set_id = t24_.id AND (t24_.publish = 1) LEFT JOIN tv_show_set_category t25_ ON t24_.tv_show_set_category_id = t25_.id AND (t25_.publish = 1) LEFT JOIN tv_show_merch t26_ ON b17_.tv_show_merch_id = t26_.id AND (t26_.publish = 1) LEFT JOIN tv_show_posts t27_ ON b18_.tv_show_post_id = t27_.id AND (t27_.publish = 1) LEFT JOIN tv_show t28_ ON (t28_.publish = 1 AND t28_.id = t21_.tv_show_id OR t28_.id = t23_.tv_show_id OR t28_.id = t25_.tv_show_id OR t28_.id = t26_.tv_show_id OR t28_.id = t27_.tv_show_id) LEFT JOIN bind_music_video_scene_item_character b29_ ON (b29_.e_commerce_item_id = e0_.id) LEFT JOIN bind_music_video_character_signature_item b30_ ON (b30_.e_commerce_item_id = e0_.id) LEFT JOIN bind_music_video_set_item b31_ ON (b31_.e_commerce_item_id = e0_.id) LEFT JOIN music_scene m32_ ON b29_.music_scene_id = m32_.id AND (m32_.publish = 1) LEFT JOIN music_video_character_signature m33_ ON b30_.music_video_character_signature_id = m33_.id LEFT JOIN music_video_character m34_ ON m33_.character_id = m34_.id LEFT JOIN music_video_set m35_ ON b31_.music_video_set_id = m35_.id AND (m35_.publish = 1) LEFT JOIN music_video_set_category m36_ ON m35_.music_video_set_category_id = m36_.id AND (m36_.publish = 1) LEFT JOIN music_video m37_ ON (m37_.publish = 1 AND m37_.id = m32_.music_video_id OR m37_.id = m34_.music_video_id OR m37_.id = m36_.music_video_id) LEFT JOIN music_artist_to_music_video m39_ ON m37_.id = m39_.music_video_id LEFT JOIN music_artist m38_ ON m38_.id = m39_.music_artist_id LEFT JOIN bind_music_artist_merch b40_ ON (b40_.e_commerce_item_id = e0_.id) LEFT JOIN music_artist_merch m41_ ON b40_.music_artist_merch_id = m41_.id AND (m41_.publish = 1) LEFT JOIN bind_music_artist_post_item_character b42_ ON (b42_.e_commerce_item_id = e0_.id) LEFT JOIN music_artist_posts m43_ ON b42_.music_artist_post_id = m43_.id AND (m43_.publish = 1) LEFT JOIN bind_music_artist_post_item_guest_character b44_ ON (b44_.e_commerce_item_id = e0_.id) LEFT JOIN music_artist_posts m45_ ON b44_.music_artist_post_id = m45_.id AND (m45_.publish = 1) LEFT JOIN music_artist m46_ ON (m46_.publish = 1 AND m46_.id = m41_.music_artist_id OR m46_.id = m43_.music_artist_id OR m46_.id = m45_.music_artist_id) WHERE (f13_.publish = 1 OR t28_.publish = 1 OR (m37_.publish = 1 AND m38_.publish = 1) OR m46_.publish = 1) AND e0_.removed = 0 AND e0_.id = ? GROUP BY e0_.name, e0_.sku, e0_.price_on_mirinly, e0_.msrp, e0_.sale_price, e0_.available_from_samples, e0_.available_from_mirinly, e0_.available, e0_.affiliate_url, e0_.thumbnail, e0_.additional_image_1, e0_.additional_image_2, e0_.additional_image_3, e0_.additional_image_4, e0_.sizeGuide, e0_.description, e0_.position, e0_.id, e0_.featured, e0_.sponsored_global, e0_.sponsored_category, e0_.sponsored_sub_category, e0_.based_in, e0_.other_sizes_colors, e0_.measurement_type, e0_.insurance_type, e0_.insurance, e0_.reasonable_wear_and_tear, e0_.low_volume_production, e0_.shipping_policy, e0_.return_policy, e0_.care, e0_.created, e0_.enable_shopify_sync, e0_.enable_squarecpase_sync, e0_.imported, e0_.removed, e0_.once_assigned, e0_.default_cities, e0_.default_search_tags, e0_.external_id, e0_.finalized_date, e0_.e_commerce_subcategory_id, e0_.e_commerce_item_type_id, e0_.e_commerce_item_template_id, e0_.brand_id, e0_.main_image_id

Parameters:

[
  0
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.name AS name_0,
  e0_.sku AS sku_1,
  e0_.price_on_mirinly AS price_on_mirinly_2,
  e0_.msrp AS msrp_3,
  e0_.sale_price AS sale_price_4,
  e0_.available_from_samples AS available_from_samples_5,
  e0_.available_from_mirinly AS available_from_mirinly_6,
  e0_.available AS available_7,
  e0_.affiliate_url AS affiliate_url_8,
  e0_.thumbnail AS thumbnail_9,
  e0_.additional_image_1 AS additional_image_1_10,
  e0_.additional_image_2 AS additional_image_2_11,
  e0_.additional_image_3 AS additional_image_3_12,
  e0_.additional_image_4 AS additional_image_4_13,
  e0_.sizeGuide AS sizeGuide_14,
  e0_.description AS description_15,
  e0_.position AS position_16,
  e0_.id AS id_17,
  e0_.featured AS featured_18,
  e0_.sponsored_global AS sponsored_global_19,
  e0_.sponsored_category AS sponsored_category_20,
  e0_.sponsored_sub_category AS sponsored_sub_category_21,
  e0_.based_in AS based_in_22,
  e0_.other_sizes_colors AS other_sizes_colors_23,
  e0_.measurement_type AS measurement_type_24,
  e0_.insurance_type AS insurance_type_25,
  e0_.insurance AS insurance_26,
  e0_.reasonable_wear_and_tear AS reasonable_wear_and_tear_27,
  e0_.low_volume_production AS low_volume_production_28,
  e0_.shipping_policy AS shipping_policy_29,
  e0_.return_policy AS return_policy_30,
  e0_.care AS care_31,
  e0_.created AS created_32,
  e0_.enable_shopify_sync AS enable_shopify_sync_33,
  e0_.enable_squarecpase_sync AS enable_squarecpase_sync_34,
  e0_.imported AS imported_35,
  e0_.removed AS removed_36,
  e0_.once_assigned AS once_assigned_37,
  e0_.default_cities AS default_cities_38,
  e0_.default_search_tags AS default_search_tags_39,
  e0_.external_id AS external_id_40,
  e0_.finalized_date AS finalized_date_41,
  e0_.e_commerce_subcategory_id AS e_commerce_subcategory_id_42,
  e0_.e_commerce_item_type_id AS e_commerce_item_type_id_43,
  e0_.e_commerce_item_template_id AS e_commerce_item_template_id_44,
  e0_.brand_id AS brand_id_45,
  e0_.main_image_id AS main_image_id_46
FROM
  e_commerce_item e0_
  LEFT JOIN bind_film_scene_item_character b1_ ON (b1_.e_commerce_item_id = e0_.id)
  LEFT JOIN bind_film_character_signature_item b2_ ON (b2_.e_commerce_item_id = e0_.id)
  LEFT JOIN bind_film_set_item b3_ ON (b3_.e_commerce_item_id = e0_.id)
  LEFT JOIN bind_film_merch b4_ ON (b4_.e_commerce_item_id = e0_.id)
  LEFT JOIN bind_film_post_item_character b5_ ON (b5_.e_commerce_item_id = e0_.id)
  LEFT JOIN film_scene f6_ ON b1_.film_scene_id = f6_.id
  AND (f6_.publish = 1)
  LEFT JOIN film_character_signature f7_ ON b2_.film_character_signature_id = f7_.id
  LEFT JOIN film_character f8_ ON f7_.character_id = f8_.id
  LEFT JOIN film_set f9_ ON b3_.film_set_id = f9_.id
  AND (f9_.publish = 1)
  LEFT JOIN film_set_category f10_ ON f9_.film_set_category_id = f10_.id
  AND (f10_.publish = 1)
  LEFT JOIN film_merch f11_ ON b4_.film_merch_id = f11_.id
  AND (f11_.publish = 1)
  LEFT JOIN film_posts f12_ ON b5_.film_post_id = f12_.id
  AND (f12_.publish = 1)
  LEFT JOIN film f13_ ON (
    f13_.publish = 1
    AND f13_.id = f6_.film_id
    OR f13_.id = f8_.film_id
    OR f13_.id = f10_.film_id
    OR f13_.id = f11_.film_id
    OR f13_.id = f12_.film_id
  )
  LEFT JOIN bind_tv_show_scene_item_character b14_ ON (b14_.e_commerce_item_id = e0_.id)
  LEFT JOIN bind_tv_show_character_signature_item b15_ ON (b15_.e_commerce_item_id = e0_.id)
  LEFT JOIN bind_tv_show_set_item b16_ ON (b16_.e_commerce_item_id = e0_.id)
  LEFT JOIN bind_tv_show_merch b17_ ON (b17_.e_commerce_item_id = e0_.id)
  LEFT JOIN bind_tv_show_post_item_character b18_ ON (b18_.e_commerce_item_id = e0_.id)
  LEFT JOIN tv_show_scene t19_ ON b14_.tv_show_scene_id = t19_.id
  AND (t19_.publish = 1)
  LEFT JOIN tv_show_episode t20_ ON t19_.tv_show_episode_id = t20_.id
  AND (t20_.publish = 1)
  LEFT JOIN tv_show_season t21_ ON t20_.tv_show_season_id = t21_.id
  AND (t21_.publish = 1)
  LEFT JOIN tv_show_character_signature t22_ ON b15_.tv_show_character_signature_id = t22_.id
  AND (t22_.publish = 1)
  LEFT JOIN tv_show_character t23_ ON t22_.character_id = t23_.id
  LEFT JOIN tv_show_set t24_ ON b16_.tv_show_set_id = t24_.id
  AND (t24_.publish = 1)
  LEFT JOIN tv_show_set_category t25_ ON t24_.tv_show_set_category_id = t25_.id
  AND (t25_.publish = 1)
  LEFT JOIN tv_show_merch t26_ ON b17_.tv_show_merch_id = t26_.id
  AND (t26_.publish = 1)
  LEFT JOIN tv_show_posts t27_ ON b18_.tv_show_post_id = t27_.id
  AND (t27_.publish = 1)
  LEFT JOIN tv_show t28_ ON (
    t28_.publish = 1
    AND t28_.id = t21_.tv_show_id
    OR t28_.id = t23_.tv_show_id
    OR t28_.id = t25_.tv_show_id
    OR t28_.id = t26_.tv_show_id
    OR t28_.id = t27_.tv_show_id
  )
  LEFT JOIN bind_music_video_scene_item_character b29_ ON (b29_.e_commerce_item_id = e0_.id)
  LEFT JOIN bind_music_video_character_signature_item b30_ ON (b30_.e_commerce_item_id = e0_.id)
  LEFT JOIN bind_music_video_set_item b31_ ON (b31_.e_commerce_item_id = e0_.id)
  LEFT JOIN music_scene m32_ ON b29_.music_scene_id = m32_.id
  AND (m32_.publish = 1)
  LEFT JOIN music_video_character_signature m33_ ON b30_.music_video_character_signature_id = m33_.id
  LEFT JOIN music_video_character m34_ ON m33_.character_id = m34_.id
  LEFT JOIN music_video_set m35_ ON b31_.music_video_set_id = m35_.id
  AND (m35_.publish = 1)
  LEFT JOIN music_video_set_category m36_ ON m35_.music_video_set_category_id = m36_.id
  AND (m36_.publish = 1)
  LEFT JOIN music_video m37_ ON (
    m37_.publish = 1
    AND m37_.id = m32_.music_video_id
    OR m37_.id = m34_.music_video_id
    OR m37_.id = m36_.music_video_id
  )
  LEFT JOIN music_artist_to_music_video m39_ ON m37_.id = m39_.music_video_id
  LEFT JOIN music_artist m38_ ON m38_.id = m39_.music_artist_id
  LEFT JOIN bind_music_artist_merch b40_ ON (b40_.e_commerce_item_id = e0_.id)
  LEFT JOIN music_artist_merch m41_ ON b40_.music_artist_merch_id = m41_.id
  AND (m41_.publish = 1)
  LEFT JOIN bind_music_artist_post_item_character b42_ ON (b42_.e_commerce_item_id = e0_.id)
  LEFT JOIN music_artist_posts m43_ ON b42_.music_artist_post_id = m43_.id
  AND (m43_.publish = 1)
  LEFT JOIN bind_music_artist_post_item_guest_character b44_ ON (b44_.e_commerce_item_id = e0_.id)
  LEFT JOIN music_artist_posts m45_ ON b44_.music_artist_post_id = m45_.id
  AND (m45_.publish = 1)
  LEFT JOIN music_artist m46_ ON (
    m46_.publish = 1
    AND m46_.id = m41_.music_artist_id
    OR m46_.id = m43_.music_artist_id
    OR m46_.id = m45_.music_artist_id
  )
WHERE
  (
    f13_.publish = 1
    OR t28_.publish = 1
    OR (
      m37_.publish = 1
      AND m38_.publish = 1
    )
    OR m46_.publish = 1
  )
  AND e0_.removed = 0
  AND e0_.id = ?
GROUP BY
  e0_.name,
  e0_.sku,
  e0_.price_on_mirinly,
  e0_.msrp,
  e0_.sale_price,
  e0_.available_from_samples,
  e0_.available_from_mirinly,
  e0_.available,
  e0_.affiliate_url,
  e0_.thumbnail,
  e0_.additional_image_1,
  e0_.additional_image_2,
  e0_.additional_image_3,
  e0_.additional_image_4,
  e0_.sizeGuide,
  e0_.description,
  e0_.position,
  e0_.id,
  e0_.featured,
  e0_.sponsored_global,
  e0_.sponsored_category,
  e0_.sponsored_sub_category,
  e0_.based_in,
  e0_.other_sizes_colors,
  e0_.measurement_type,
  e0_.insurance_type,
  e0_.insurance,
  e0_.reasonable_wear_and_tear,
  e0_.low_volume_production,
  e0_.shipping_policy,
  e0_.return_policy,
  e0_.care,
  e0_.created,
  e0_.enable_shopify_sync,
  e0_.enable_squarecpase_sync,
  e0_.imported,
  e0_.removed,
  e0_.once_assigned,
  e0_.default_cities,
  e0_.default_search_tags,
  e0_.external_id,
  e0_.finalized_date,
  e0_.e_commerce_subcategory_id,
  e0_.e_commerce_item_type_id,
  e0_.e_commerce_item_template_id,
  e0_.brand_id,
  e0_.main_image_id

SELECT e0_.name AS name_0, e0_.sku AS sku_1, e0_.price_on_mirinly AS price_on_mirinly_2, e0_.msrp AS msrp_3, e0_.sale_price AS sale_price_4, e0_.available_from_samples AS available_from_samples_5, e0_.available_from_mirinly AS available_from_mirinly_6, e0_.available AS available_7, e0_.affiliate_url AS affiliate_url_8, e0_.thumbnail AS thumbnail_9, e0_.additional_image_1 AS additional_image_1_10, e0_.additional_image_2 AS additional_image_2_11, e0_.additional_image_3 AS additional_image_3_12, e0_.additional_image_4 AS additional_image_4_13, e0_.sizeGuide AS sizeGuide_14, e0_.description AS description_15, e0_.position AS position_16, e0_.id AS id_17, e0_.featured AS featured_18, e0_.sponsored_global AS sponsored_global_19, e0_.sponsored_category AS sponsored_category_20, e0_.sponsored_sub_category AS sponsored_sub_category_21, e0_.based_in AS based_in_22, e0_.other_sizes_colors AS other_sizes_colors_23, e0_.measurement_type AS measurement_type_24, e0_.insurance_type AS insurance_type_25, e0_.insurance AS insurance_26, e0_.reasonable_wear_and_tear AS reasonable_wear_and_tear_27, e0_.low_volume_production AS low_volume_production_28, e0_.shipping_policy AS shipping_policy_29, e0_.return_policy AS return_policy_30, e0_.care AS care_31, e0_.created AS created_32, e0_.enable_shopify_sync AS enable_shopify_sync_33, e0_.enable_squarecpase_sync AS enable_squarecpase_sync_34, e0_.imported AS imported_35, e0_.removed AS removed_36, e0_.once_assigned AS once_assigned_37, e0_.default_cities AS default_cities_38, e0_.default_search_tags AS default_search_tags_39, e0_.external_id AS external_id_40, e0_.finalized_date AS finalized_date_41, e0_.e_commerce_subcategory_id AS e_commerce_subcategory_id_42, e0_.e_commerce_item_type_id AS e_commerce_item_type_id_43, e0_.e_commerce_item_template_id AS e_commerce_item_template_id_44, e0_.brand_id AS brand_id_45, e0_.main_image_id AS main_image_id_46 FROM e_commerce_item e0_ LEFT JOIN bind_film_scene_item_character b1_ ON (b1_.e_commerce_item_id = e0_.id) LEFT JOIN bind_film_character_signature_item b2_ ON (b2_.e_commerce_item_id = e0_.id) LEFT JOIN bind_film_set_item b3_ ON (b3_.e_commerce_item_id = e0_.id) LEFT JOIN bind_film_merch b4_ ON (b4_.e_commerce_item_id = e0_.id) LEFT JOIN bind_film_post_item_character b5_ ON (b5_.e_commerce_item_id = e0_.id) LEFT JOIN film_scene f6_ ON b1_.film_scene_id = f6_.id AND (f6_.publish = 1) LEFT JOIN film_character_signature f7_ ON b2_.film_character_signature_id = f7_.id LEFT JOIN film_character f8_ ON f7_.character_id = f8_.id LEFT JOIN film_set f9_ ON b3_.film_set_id = f9_.id AND (f9_.publish = 1) LEFT JOIN film_set_category f10_ ON f9_.film_set_category_id = f10_.id AND (f10_.publish = 1) LEFT JOIN film_merch f11_ ON b4_.film_merch_id = f11_.id AND (f11_.publish = 1) LEFT JOIN film_posts f12_ ON b5_.film_post_id = f12_.id AND (f12_.publish = 1) LEFT JOIN film f13_ ON (f13_.publish = 1 AND f13_.id = f6_.film_id OR f13_.id = f8_.film_id OR f13_.id = f10_.film_id OR f13_.id = f11_.film_id OR f13_.id = f12_.film_id) LEFT JOIN bind_tv_show_scene_item_character b14_ ON (b14_.e_commerce_item_id = e0_.id) LEFT JOIN bind_tv_show_character_signature_item b15_ ON (b15_.e_commerce_item_id = e0_.id) LEFT JOIN bind_tv_show_set_item b16_ ON (b16_.e_commerce_item_id = e0_.id) LEFT JOIN bind_tv_show_merch b17_ ON (b17_.e_commerce_item_id = e0_.id) LEFT JOIN bind_tv_show_post_item_character b18_ ON (b18_.e_commerce_item_id = e0_.id) LEFT JOIN tv_show_scene t19_ ON b14_.tv_show_scene_id = t19_.id AND (t19_.publish = 1) LEFT JOIN tv_show_episode t20_ ON t19_.tv_show_episode_id = t20_.id AND (t20_.publish = 1) LEFT JOIN tv_show_season t21_ ON t20_.tv_show_season_id = t21_.id AND (t21_.publish = 1) LEFT JOIN tv_show_character_signature t22_ ON b15_.tv_show_character_signature_id = t22_.id AND (t22_.publish = 1) LEFT JOIN tv_show_character t23_ ON t22_.character_id = t23_.id LEFT JOIN tv_show_set t24_ ON b16_.tv_show_set_id = t24_.id AND (t24_.publish = 1) LEFT JOIN tv_show_set_category t25_ ON t24_.tv_show_set_category_id = t25_.id AND (t25_.publish = 1) LEFT JOIN tv_show_merch t26_ ON b17_.tv_show_merch_id = t26_.id AND (t26_.publish = 1) LEFT JOIN tv_show_posts t27_ ON b18_.tv_show_post_id = t27_.id AND (t27_.publish = 1) LEFT JOIN tv_show t28_ ON (t28_.publish = 1 AND t28_.id = t21_.tv_show_id OR t28_.id = t23_.tv_show_id OR t28_.id = t25_.tv_show_id OR t28_.id = t26_.tv_show_id OR t28_.id = t27_.tv_show_id) LEFT JOIN bind_music_video_scene_item_character b29_ ON (b29_.e_commerce_item_id = e0_.id) LEFT JOIN bind_music_video_character_signature_item b30_ ON (b30_.e_commerce_item_id = e0_.id) LEFT JOIN bind_music_video_set_item b31_ ON (b31_.e_commerce_item_id = e0_.id) LEFT JOIN music_scene m32_ ON b29_.music_scene_id = m32_.id AND (m32_.publish = 1) LEFT JOIN music_video_character_signature m33_ ON b30_.music_video_character_signature_id = m33_.id LEFT JOIN music_video_character m34_ ON m33_.character_id = m34_.id LEFT JOIN music_video_set m35_ ON b31_.music_video_set_id = m35_.id AND (m35_.publish = 1) LEFT JOIN music_video_set_category m36_ ON m35_.music_video_set_category_id = m36_.id AND (m36_.publish = 1) LEFT JOIN music_video m37_ ON (m37_.publish = 1 AND m37_.id = m32_.music_video_id OR m37_.id = m34_.music_video_id OR m37_.id = m36_.music_video_id) LEFT JOIN music_artist_to_music_video m39_ ON m37_.id = m39_.music_video_id LEFT JOIN music_artist m38_ ON m38_.id = m39_.music_artist_id LEFT JOIN bind_music_artist_merch b40_ ON (b40_.e_commerce_item_id = e0_.id) LEFT JOIN music_artist_merch m41_ ON b40_.music_artist_merch_id = m41_.id AND (m41_.publish = 1) LEFT JOIN bind_music_artist_post_item_character b42_ ON (b42_.e_commerce_item_id = e0_.id) LEFT JOIN music_artist_posts m43_ ON b42_.music_artist_post_id = m43_.id AND (m43_.publish = 1) LEFT JOIN bind_music_artist_post_item_guest_character b44_ ON (b44_.e_commerce_item_id = e0_.id) LEFT JOIN music_artist_posts m45_ ON b44_.music_artist_post_id = m45_.id AND (m45_.publish = 1) LEFT JOIN music_artist m46_ ON (m46_.publish = 1 AND m46_.id = m41_.music_artist_id OR m46_.id = m43_.music_artist_id OR m46_.id = m45_.music_artist_id) WHERE (f13_.publish = 1 OR t28_.publish = 1 OR (m37_.publish = 1 AND m38_.publish = 1) OR m46_.publish = 1) AND e0_.removed = 0 AND e0_.id = 0 GROUP BY e0_.name, e0_.sku, e0_.price_on_mirinly, e0_.msrp, e0_.sale_price, e0_.available_from_samples, e0_.available_from_mirinly, e0_.available, e0_.affiliate_url, e0_.thumbnail, e0_.additional_image_1, e0_.additional_image_2, e0_.additional_image_3, e0_.additional_image_4, e0_.sizeGuide, e0_.description, e0_.position, e0_.id, e0_.featured, e0_.sponsored_global, e0_.sponsored_category, e0_.sponsored_sub_category, e0_.based_in, e0_.other_sizes_colors, e0_.measurement_type, e0_.insurance_type, e0_.insurance, e0_.reasonable_wear_and_tear, e0_.low_volume_production, e0_.shipping_policy, e0_.return_policy, e0_.care, e0_.created, e0_.enable_shopify_sync, e0_.enable_squarecpase_sync, e0_.imported, e0_.removed, e0_.once_assigned, e0_.default_cities, e0_.default_search_tags, e0_.external_id, e0_.finalized_date, e0_.e_commerce_subcategory_id, e0_.e_commerce_item_type_id, e0_.e_commerce_item_template_id, e0_.brand_id, e0_.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->getOneOrNullResult (line 737)
6	Mirinly\AdminBundle\Entity\ECommerceItemRepository->getPublishItemById (line 3298)
7	Mirinly\FrontBundle\Controller\ProductController->indexAction (line 61)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 185)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

0.56 ms
(17.74%)

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\ProductController->indexAction (line 54)
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	1
Mirinly\AdminBundle\Entity\Currency	1
Mirinly\AdminBundle\Entity\Continent	1

Entities Mapping

Class	Mapping errors
Mirinly\AdminBundle\Entity\AbstractEntity	No errors.
Mirinly\AdminBundle\Entity\Country	No errors.
Mirinly\AdminBundle\Entity\Currency	No errors.
Mirinly\AdminBundle\Entity\Continent	No errors.
Mirinly\AdminBundle\Entity\State	No errors.
Mirinly\AdminBundle\Entity\City	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\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\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.

Symfony Profiler

GET https://mirinly.com/product/quickview/1108

Configuration Settings

Theme

Page Width