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

Response
200 OK
IP
216.73.216.217
Profiled on
Token
9ac004

Query Metrics

43 Database Queries
37 Different statements
7048.63 ms Query time
27 Invalid entities
4274 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
3831.49 ms
(54.36%) 		1 
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, sum(e1_.points) AS sclr_42, sum(e2_.points) AS sclr_43, sum(e3_.points) / (DATEDIFF(?, min(e3_.updated))) AS sclr_44, e0_.e_commerce_subcategory_id AS e_commerce_subcategory_id_45, e0_.e_commerce_item_type_id AS e_commerce_item_type_id_46, e0_.e_commerce_item_template_id AS e_commerce_item_template_id_47, e0_.brand_id AS brand_id_48, e0_.main_image_id AS main_image_id_49 FROM e_commerce_item e0_ LEFT JOIN e_commerce_item_trend e1_ ON (e1_.target_id = e0_.id) LEFT JOIN e_commerce_item_trend e3_ ON (e3_.id = e1_.id AND e3_.updated < ?) LEFT JOIN e_commerce_item_trend e2_ ON (e2_.id = e1_.id AND e2_.updated >= ?) LEFT JOIN bind_film_scene_item_character b4_ ON (b4_.e_commerce_item_id = e0_.id) LEFT JOIN bind_film_character_signature_item b5_ ON (b5_.e_commerce_item_id = e0_.id) LEFT JOIN bind_film_set_item b6_ ON (b6_.e_commerce_item_id = e0_.id) LEFT JOIN bind_film_merch b7_ ON (b7_.e_commerce_item_id = e0_.id) LEFT JOIN bind_film_post_item_character b8_ ON (b8_.e_commerce_item_id = e0_.id) LEFT JOIN film_scene f9_ ON b4_.film_scene_id = f9_.id AND (f9_.publish = 1) LEFT JOIN film_character_signature f10_ ON b5_.film_character_signature_id = f10_.id LEFT JOIN film_character f11_ ON f10_.character_id = f11_.id LEFT JOIN film_set f12_ ON b6_.film_set_id = f12_.id AND (f12_.publish = 1) LEFT JOIN film_set_category f13_ ON f12_.film_set_category_id = f13_.id AND (f13_.publish = 1) LEFT JOIN film_merch f14_ ON b7_.film_merch_id = f14_.id AND (f14_.publish = 1) LEFT JOIN film_posts f15_ ON b8_.film_post_id = f15_.id AND (f15_.publish = 1) LEFT JOIN film f16_ ON (f16_.publish = 1 AND f16_.id = f9_.film_id OR f16_.id = f11_.film_id OR f16_.id = f13_.film_id OR f16_.id = f14_.film_id OR f16_.id = f15_.film_id) LEFT JOIN bind_tv_show_scene_item_character b17_ ON (b17_.e_commerce_item_id = e0_.id) LEFT JOIN bind_tv_show_character_signature_item b18_ ON (b18_.e_commerce_item_id = e0_.id) LEFT JOIN bind_tv_show_set_item b19_ ON (b19_.e_commerce_item_id = e0_.id) LEFT JOIN bind_tv_show_merch b20_ ON (b20_.e_commerce_item_id = e0_.id) LEFT JOIN bind_tv_show_post_item_character b21_ ON (b21_.e_commerce_item_id = e0_.id) LEFT JOIN tv_show_scene t22_ ON b17_.tv_show_scene_id = t22_.id AND (t22_.publish = 1) LEFT JOIN tv_show_episode t23_ ON t22_.tv_show_episode_id = t23_.id AND (t23_.publish = 1) LEFT JOIN tv_show_season t24_ ON t23_.tv_show_season_id = t24_.id AND (t24_.publish = 1) LEFT JOIN tv_show_character_signature t25_ ON b18_.tv_show_character_signature_id = t25_.id AND (t25_.publish = 1) LEFT JOIN tv_show_character t26_ ON t25_.character_id = t26_.id LEFT JOIN tv_show_set t27_ ON b19_.tv_show_set_id = t27_.id AND (t27_.publish = 1) LEFT JOIN tv_show_set_category t28_ ON t27_.tv_show_set_category_id = t28_.id AND (t28_.publish = 1) LEFT JOIN tv_show_merch t29_ ON b20_.tv_show_merch_id = t29_.id AND (t29_.publish = 1) LEFT JOIN tv_show_posts t30_ ON b21_.tv_show_post_id = t30_.id AND (t30_.publish = 1) LEFT JOIN tv_show t31_ ON (t31_.publish = 1 AND t31_.id = t24_.tv_show_id OR t31_.id = t26_.tv_show_id OR t31_.id = t28_.tv_show_id OR t31_.id = t29_.tv_show_id OR t31_.id = t30_.tv_show_id) LEFT JOIN bind_music_video_scene_item_character b32_ ON (b32_.e_commerce_item_id = e0_.id) LEFT JOIN bind_music_video_character_signature_item b33_ ON (b33_.e_commerce_item_id = e0_.id) LEFT JOIN bind_music_video_set_item b34_ ON (b34_.e_commerce_item_id = e0_.id) LEFT JOIN music_scene m35_ ON b32_.music_scene_id = m35_.id AND (m35_.publish = 1) LEFT JOIN music_video_character_signature m36_ ON b33_.music_video_character_signature_id = m36_.id LEFT JOIN music_video_character m37_ ON m36_.character_id = m37_.id LEFT JOIN music_video_set m38_ ON b34_.music_video_set_id = m38_.id AND (m38_.publish = 1) LEFT JOIN music_video_set_category m39_ ON m38_.music_video_set_category_id = m39_.id AND (m39_.publish = 1) LEFT JOIN music_video m40_ ON (m40_.publish = 1 AND m40_.id = m35_.music_video_id OR m40_.id = m37_.music_video_id OR m40_.id = m39_.music_video_id) LEFT JOIN music_artist_to_music_video m42_ ON m40_.id = m42_.music_video_id LEFT JOIN music_artist m41_ ON m41_.id = m42_.music_artist_id LEFT JOIN bind_music_artist_merch b43_ ON (b43_.e_commerce_item_id = e0_.id) LEFT JOIN music_artist_merch m44_ ON b43_.music_artist_merch_id = m44_.id AND (m44_.publish = 1) LEFT JOIN bind_music_artist_post_item_character b45_ ON (b45_.e_commerce_item_id = e0_.id) LEFT JOIN music_artist_posts m46_ ON b45_.music_artist_post_id = m46_.id AND (m46_.publish = 1) LEFT JOIN bind_music_artist_post_item_guest_character b47_ ON (b47_.e_commerce_item_id = e0_.id) LEFT JOIN music_artist_posts m48_ ON b47_.music_artist_post_id = m48_.id AND (m48_.publish = 1) LEFT JOIN music_artist m49_ ON (m49_.publish = 1 AND m49_.id = m44_.music_artist_id OR m49_.id = m46_.music_artist_id OR m49_.id = m48_.music_artist_id) INNER JOIN e_commerce_item_settings_discovery e50_ ON e0_.id = e50_.item_id AND (e50_.discovery = 1 AND e50_.quantity_update <> 0) LEFT JOIN e_commerce_item e51_ ON (e51_.id = ?) LEFT JOIN bind_film_character_signature_item b52_ ON (b52_.e_commerce_item_id = e51_.id) LEFT JOIN bind_film_set_item b53_ ON (b53_.e_commerce_item_id = e51_.id) LEFT JOIN bind_tv_show_character_signature_item b54_ ON (b54_.e_commerce_item_id = e51_.id) LEFT JOIN bind_tv_show_set_item b55_ ON (b55_.e_commerce_item_id = e51_.id) LEFT JOIN bind_music_video_character_signature_item b56_ ON (b56_.e_commerce_item_id = e51_.id) LEFT JOIN bind_music_video_set_item b57_ ON (b57_.e_commerce_item_id = e51_.id) WHERE (f16_.publish = 1 OR t31_.publish = 1 OR (m40_.publish = 1 AND m41_.publish = 1) OR m49_.publish = 1) AND e0_.removed = 0 AND (b5_.film_character_signature_id = b52_.film_character_signature_id OR b6_.film_set_id = b53_.film_set_id OR b18_.tv_show_character_signature_id = b54_.tv_show_character_signature_id OR b19_.tv_show_set_id = b55_.tv_show_set_id OR b33_.music_video_character_signature_id = b56_.music_video_character_signature_id OR b34_.music_video_set_id = b57_.music_video_set_id) AND e0_.id <> e51_.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: 
[
  "2026-02-19 00:00:00"
  "2026-02-19 00:00:00"
  "2026-02-19 00:00:00"
  41947
]
View formatted query    View runnable query    Explain query    View query backtrace
3023.00 ms
(42.89%) 		1 
SELECT e0_.name AS name_0, e0_.position AS position_1, e0_.id AS id_2, e0_.e_commerce_category_id AS e_commerce_category_id_3 FROM e_commerce_subcategory e0_ INNER JOIN e_commerce_category e1_ ON e0_.e_commerce_category_id = e1_.id INNER JOIN e_commerce_item e2_ ON (e0_.id = e2_.e_commerce_subcategory_id) INNER JOIN e_commerce_item_settings_discovery e3_ ON e2_.id = e3_.item_id AND (e3_.discovery = 1 AND e3_.quantity_update <> 0) LEFT JOIN bind_film_scene_item_character b4_ ON (b4_.e_commerce_item_id = e2_.id) LEFT JOIN bind_film_character_signature_item b5_ ON (b5_.e_commerce_item_id = e2_.id) LEFT JOIN bind_film_set_item b6_ ON (b6_.e_commerce_item_id = e2_.id) LEFT JOIN bind_film_merch b7_ ON (b7_.e_commerce_item_id = e2_.id) LEFT JOIN bind_film_post_item_character b8_ ON (b8_.e_commerce_item_id = e2_.id) LEFT JOIN film_scene f9_ ON b4_.film_scene_id = f9_.id AND (f9_.publish = 1) LEFT JOIN film_character_signature f10_ ON b5_.film_character_signature_id = f10_.id LEFT JOIN film_character f11_ ON f10_.character_id = f11_.id LEFT JOIN film_set f12_ ON b6_.film_set_id = f12_.id AND (f12_.publish = 1) LEFT JOIN film_set_category f13_ ON f12_.film_set_category_id = f13_.id AND (f13_.publish = 1) LEFT JOIN film_merch f14_ ON b7_.film_merch_id = f14_.id AND (f14_.publish = 1) LEFT JOIN film_posts f15_ ON b8_.film_post_id = f15_.id AND (f15_.publish = 1) LEFT JOIN film f16_ ON (f16_.id = f9_.film_id OR f16_.id = f11_.film_id OR f16_.id = f13_.film_id OR f16_.id = f14_.film_id OR f16_.id = f15_.film_id) LEFT JOIN bind_tv_show_scene_item_character b17_ ON (b17_.e_commerce_item_id = e2_.id) LEFT JOIN bind_tv_show_character_signature_item b18_ ON (b18_.e_commerce_item_id = e2_.id) LEFT JOIN bind_tv_show_set_item b19_ ON (b19_.e_commerce_item_id = e2_.id) LEFT JOIN bind_tv_show_merch b20_ ON (b20_.e_commerce_item_id = e2_.id) LEFT JOIN bind_tv_show_post_item_character b21_ ON (b21_.e_commerce_item_id = e2_.id) LEFT JOIN tv_show_scene t22_ ON b17_.tv_show_scene_id = t22_.id AND (t22_.publish = 1) LEFT JOIN tv_show_episode t23_ ON t22_.tv_show_episode_id = t23_.id AND (t23_.publish = 1) LEFT JOIN tv_show_season t24_ ON t23_.tv_show_season_id = t24_.id AND (t24_.publish = 1) LEFT JOIN tv_show_character_signature t25_ ON b18_.tv_show_character_signature_id = t25_.id AND (t25_.publish = 1) LEFT JOIN tv_show_character t26_ ON t25_.character_id = t26_.id LEFT JOIN tv_show_set t27_ ON b19_.tv_show_set_id = t27_.id AND (t27_.publish = 1) LEFT JOIN tv_show_set_category t28_ ON t27_.tv_show_set_category_id = t28_.id AND (t28_.publish = 1) LEFT JOIN tv_show_merch t29_ ON b20_.tv_show_merch_id = t29_.id AND (t29_.publish = 1) LEFT JOIN tv_show_posts t30_ ON b21_.tv_show_post_id = t30_.id AND (t30_.publish = 1) LEFT JOIN tv_show t31_ ON (t31_.id = t24_.tv_show_id OR t31_.id = t26_.tv_show_id OR t31_.id = t28_.tv_show_id OR t31_.id = t29_.tv_show_id OR t31_.id = t30_.tv_show_id) LEFT JOIN bind_music_video_scene_item_character b32_ ON (b32_.e_commerce_item_id = e2_.id) LEFT JOIN bind_music_video_character_signature_item b33_ ON (b33_.e_commerce_item_id = e2_.id) LEFT JOIN bind_music_video_set_item b34_ ON (b34_.e_commerce_item_id = e2_.id) LEFT JOIN music_scene m35_ ON b32_.music_scene_id = m35_.id AND (m35_.publish = 1) LEFT JOIN music_video_character_signature m36_ ON b33_.music_video_character_signature_id = m36_.id LEFT JOIN music_video_character m37_ ON m36_.character_id = m37_.id LEFT JOIN music_video_set m38_ ON b34_.music_video_set_id = m38_.id AND (m38_.publish = 1) LEFT JOIN music_video_set_category m39_ ON m38_.music_video_set_category_id = m39_.id AND (m39_.publish = 1) LEFT JOIN music_video m40_ ON (m40_.id = m35_.music_video_id OR m40_.id = m37_.music_video_id OR m40_.id = m39_.music_video_id) LEFT JOIN music_artist_to_music_video m42_ ON m40_.id = m42_.music_video_id LEFT JOIN music_artist m41_ ON m41_.id = m42_.music_artist_id LEFT JOIN bind_music_artist_merch b43_ ON (b43_.e_commerce_item_id = e2_.id) LEFT JOIN music_artist_merch m44_ ON b43_.music_artist_merch_id = m44_.id AND (m44_.publish = 1) LEFT JOIN bind_music_artist_post_item_character b45_ ON (b45_.e_commerce_item_id = e2_.id) LEFT JOIN music_artist_posts m46_ ON b45_.music_artist_post_id = m46_.id AND (m46_.publish = 1) LEFT JOIN bind_music_artist_post_item_guest_character b47_ ON (b47_.e_commerce_item_id = e2_.id) LEFT JOIN music_artist_posts m48_ ON b47_.music_artist_post_id = m48_.id AND (m48_.publish = 1) LEFT JOIN music_artist m49_ ON (m49_.id = m44_.music_artist_id OR m49_.id = m46_.music_artist_id OR m49_.id = m48_.music_artist_id) WHERE (f16_.publish = 1 OR t31_.publish = 1 OR (m40_.publish = 1 AND m41_.publish = 1) OR m49_.publish = 1) AND e2_.e_commerce_item_type_id = ? ORDER BY e1_.position ASC, e0_.position ASC
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
128.08 ms
(1.82%) 		1 
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, CASE WHEN (f1_.id IS NOT NULL AND f2_.id IS NULL AND f3_.id IS NULL AND f4_.id IS NULL AND f5_.id IS NOT NULL) THEN 'film_merch' WHEN (f1_.id IS NOT NULL AND f2_.id IS NULL AND f3_.id IS NULL AND f4_.id IS NULL AND f6_.id IS NOT NULL) THEN 'film_posts' WHEN f1_.id IS NOT NULL THEN 'film' WHEN (t7_.id IS NOT NULL AND t8_.id IS NULL AND t9_.id IS NULL AND t10_.id IS NULL AND t11_.id IS NOT NULL) THEN 'show_merch' WHEN (t7_.id IS NOT NULL AND t8_.id IS NULL AND t9_.id IS NULL AND t10_.id IS NULL AND t12_.id IS NOT NULL) THEN 'show_posts' WHEN t7_.id IS NOT NULL THEN 'show' WHEN m13_.id IS NOT NULL THEN 'music-video' WHEN m14_.id IS NOT NULL THEN 'music-artist-merch' WHEN m15_.id IS NOT NULL THEN 'music-artist-post' WHEN m16_.id IS NOT NULL THEN 'music-artist-post' ELSE '' END AS sclr_42, CASE WHEN (f1_.id IS NOT NULL AND f2_.id IS NULL AND f3_.id IS NULL AND f4_.id IS NULL AND f5_.id IS NOT NULL) THEN CONCAT(f1_.name, ' - Merch') WHEN (f1_.id IS NOT NULL AND f2_.id IS NULL AND f3_.id IS NULL AND f4_.id IS NULL AND f6_.id IS NOT NULL) THEN CONCAT(f1_.name, ' - Posts') WHEN f1_.id IS NOT NULL THEN f1_.name WHEN (t7_.id IS NOT NULL AND t8_.id IS NULL AND t9_.id IS NULL AND t10_.id IS NULL AND t11_.id IS NOT NULL) THEN CONCAT(t7_.name, ' - Merch') WHEN (t7_.id IS NOT NULL AND t8_.id IS NULL AND t9_.id IS NULL AND t10_.id IS NULL AND t12_.id IS NOT NULL) THEN CONCAT(t7_.name, ' - Posts') WHEN t7_.id IS NOT NULL THEN t7_.name WHEN m13_.id IS NOT NULL THEN m13_.name WHEN m14_.id IS NOT NULL THEN CONCAT(m17_.name, ' - Merch') WHEN m15_.id IS NOT NULL THEN CONCAT(m17_.name, ' - Posts') WHEN m16_.id IS NOT NULL THEN CONCAT(m17_.name, ' - Posts') ELSE '' END AS sclr_43, CASE WHEN f1_.id IS NOT NULL THEN f1_.id WHEN t7_.id IS NOT NULL THEN t7_.id WHEN m13_.id IS NOT NULL THEN m13_.id WHEN m14_.id IS NOT NULL THEN m17_.id WHEN m15_.id IS NOT NULL THEN m17_.id WHEN m16_.id IS NOT NULL THEN m17_.id ELSE '' END AS sclr_44, sum(e18_.points) AS sclr_45, sum(e19_.points) AS sclr_46, sum(e20_.points) / (DATEDIFF(?, min(e20_.updated))) AS sclr_47, e0_.e_commerce_subcategory_id AS e_commerce_subcategory_id_48, e0_.e_commerce_item_type_id AS e_commerce_item_type_id_49, e0_.e_commerce_item_template_id AS e_commerce_item_template_id_50, e0_.brand_id AS brand_id_51, e0_.main_image_id AS main_image_id_52 FROM e_commerce_item e0_ LEFT JOIN e_commerce_item_trend e18_ ON (e18_.target_id = e0_.id) LEFT JOIN e_commerce_item_trend e20_ ON (e20_.id = e18_.id AND e20_.updated < ?) LEFT JOIN e_commerce_item_trend e19_ ON (e19_.id = e18_.id AND e19_.updated >= ?) LEFT JOIN bind_film_scene_item_character b21_ ON (b21_.e_commerce_item_id = e0_.id) LEFT JOIN bind_film_character_signature_item b22_ ON (b22_.e_commerce_item_id = e0_.id) LEFT JOIN bind_film_set_item b23_ ON (b23_.e_commerce_item_id = e0_.id) LEFT JOIN bind_film_merch b24_ ON (b24_.e_commerce_item_id = e0_.id) LEFT JOIN bind_film_post_item_character b25_ ON (b25_.e_commerce_item_id = e0_.id) LEFT JOIN film_scene f2_ ON b21_.film_scene_id = f2_.id AND (f2_.publish = 1) LEFT JOIN film_character_signature f26_ ON b22_.film_character_signature_id = f26_.id LEFT JOIN film_character f3_ ON f26_.character_id = f3_.id LEFT JOIN film_set f27_ ON b23_.film_set_id = f27_.id AND (f27_.publish = 1) LEFT JOIN film_set_category f4_ ON f27_.film_set_category_id = f4_.id AND (f4_.publish = 1) LEFT JOIN film_merch f5_ ON b24_.film_merch_id = f5_.id AND (f5_.publish = 1) LEFT JOIN film_posts f6_ ON b25_.film_post_id = f6_.id AND (f6_.publish = 1) LEFT JOIN film f1_ ON (f1_.publish = 1 AND f1_.id = f2_.film_id OR f1_.id = f3_.film_id OR f1_.id = f4_.film_id OR f1_.id = f5_.film_id OR f1_.id = f6_.film_id) LEFT JOIN bind_tv_show_scene_item_character b28_ ON (b28_.e_commerce_item_id = e0_.id) LEFT JOIN bind_tv_show_character_signature_item b29_ ON (b29_.e_commerce_item_id = e0_.id) LEFT JOIN bind_tv_show_set_item b30_ ON (b30_.e_commerce_item_id = e0_.id) LEFT JOIN bind_tv_show_merch b31_ ON (b31_.e_commerce_item_id = e0_.id) LEFT JOIN bind_tv_show_post_item_character b32_ ON (b32_.e_commerce_item_id = e0_.id) LEFT JOIN tv_show_scene t33_ ON b28_.tv_show_scene_id = t33_.id AND (t33_.publish = 1) LEFT JOIN tv_show_episode t34_ ON t33_.tv_show_episode_id = t34_.id AND (t34_.publish = 1) LEFT JOIN tv_show_season t8_ ON t34_.tv_show_season_id = t8_.id AND (t8_.publish = 1) LEFT JOIN tv_show_character_signature t35_ ON b29_.tv_show_character_signature_id = t35_.id AND (t35_.publish = 1) LEFT JOIN tv_show_character t9_ ON t35_.character_id = t9_.id LEFT JOIN tv_show_set t36_ ON b30_.tv_show_set_id = t36_.id AND (t36_.publish = 1) LEFT JOIN tv_show_set_category t10_ ON t36_.tv_show_set_category_id = t10_.id AND (t10_.publish = 1) LEFT JOIN tv_show_merch t11_ ON b31_.tv_show_merch_id = t11_.id AND (t11_.publish = 1) LEFT JOIN tv_show_posts t12_ ON b32_.tv_show_post_id = t12_.id AND (t12_.publish = 1) LEFT JOIN tv_show t7_ ON (t7_.publish = 1 AND t7_.id = t8_.tv_show_id OR t7_.id = t9_.tv_show_id OR t7_.id = t10_.tv_show_id OR t7_.id = t11_.tv_show_id OR t7_.id = t12_.tv_show_id) LEFT JOIN bind_music_video_scene_item_character b37_ ON (b37_.e_commerce_item_id = e0_.id) LEFT JOIN bind_music_video_character_signature_item b38_ ON (b38_.e_commerce_item_id = e0_.id) LEFT JOIN bind_music_video_set_item b39_ ON (b39_.e_commerce_item_id = e0_.id) LEFT JOIN music_scene m40_ ON b37_.music_scene_id = m40_.id AND (m40_.publish = 1) LEFT JOIN music_video_character_signature m41_ ON b38_.music_video_character_signature_id = m41_.id LEFT JOIN music_video_character m42_ ON m41_.character_id = m42_.id LEFT JOIN music_video_set m43_ ON b39_.music_video_set_id = m43_.id AND (m43_.publish = 1) LEFT JOIN music_video_set_category m44_ ON m43_.music_video_set_category_id = m44_.id AND (m44_.publish = 1) LEFT JOIN music_video m13_ ON (m13_.publish = 1 AND m13_.id = m40_.music_video_id OR m13_.id = m42_.music_video_id OR m13_.id = m44_.music_video_id) LEFT JOIN music_artist_to_music_video m46_ ON m13_.id = m46_.music_video_id LEFT JOIN music_artist m45_ ON m45_.id = m46_.music_artist_id LEFT JOIN bind_music_artist_merch b47_ ON (b47_.e_commerce_item_id = e0_.id) LEFT JOIN music_artist_merch m14_ ON b47_.music_artist_merch_id = m14_.id AND (m14_.publish = 1) LEFT JOIN bind_music_artist_post_item_character b48_ ON (b48_.e_commerce_item_id = e0_.id) LEFT JOIN music_artist_posts m15_ ON b48_.music_artist_post_id = m15_.id AND (m15_.publish = 1) LEFT JOIN bind_music_artist_post_item_guest_character b49_ ON (b49_.e_commerce_item_id = e0_.id) LEFT JOIN music_artist_posts m16_ ON b49_.music_artist_post_id = m16_.id AND (m16_.publish = 1) LEFT JOIN music_artist m17_ ON (m17_.publish = 1 AND m17_.id = m14_.music_artist_id OR m17_.id = m15_.music_artist_id OR m17_.id = m16_.music_artist_id) WHERE (f1_.publish = 1 OR t7_.publish = 1 OR (m13_.publish = 1 AND m45_.publish = 1) OR m17_.publish = 1) AND e0_.removed = 0 AND (e0_.brand_id = ? 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: 
[
  "2026-02-19 00:00:00"
  "2026-02-19 00:00:00"
  "2026-02-19 00:00:00"
  44
  41947
]
View formatted query    View runnable query    Explain query    View query backtrace
25.76 ms
(0.37%) 		1 
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 ORDER BY t0.name ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
10.70 ms
(0.15%) 		2 
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: 
[
  "fb38ki3g7pvaf4tfv50at573ed"
]
View formatted query    View runnable query    Explain query    View query backtrace
6.09 ms
(0.09%) 		1 
SELECT e0_.points AS points_0, e0_.id AS id_1, e0_.updated AS updated_2, sum(e0_.points) AS sclr_3, sum(e1_.points) AS sclr_4, sum(e2_.points) / (DATEDIFF(?, min(e2_.updated))) AS sclr_5, e0_.target_id AS target_id_6 FROM e_commerce_item_trend e0_ LEFT JOIN e_commerce_item_trend e2_ ON (e2_.id = e0_.id AND e2_.updated < ?) LEFT JOIN e_commerce_item_trend e1_ ON (e1_.id = e0_.id AND e1_.updated >= ?) WHERE e0_.target_id = ? LIMIT 1
Parameters: 
[
  "2026-02-19 00:00:00"
  "2026-02-19 00:00:00"
  "2026-02-19 00:00:00"
  41947
]
View formatted query    View runnable query    Explain query    View query backtrace
3.28 ms
(0.05%) 		1 
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, CASE WHEN (f1_.id IS NOT NULL AND f2_.id IS NULL AND f3_.id IS NULL AND f4_.id IS NULL AND f5_.id IS NOT NULL) THEN 'film_merch' WHEN (f1_.id IS NOT NULL AND f2_.id IS NULL AND f3_.id IS NULL AND f4_.id IS NULL AND f6_.id IS NOT NULL) THEN 'film_posts' WHEN f1_.id IS NOT NULL THEN 'film' WHEN (t7_.id IS NOT NULL AND t8_.id IS NULL AND t9_.id IS NULL AND t10_.id IS NULL AND t11_.id IS NOT NULL) THEN 'show_merch' WHEN (t7_.id IS NOT NULL AND t8_.id IS NULL AND t9_.id IS NULL AND t10_.id IS NULL AND t12_.id IS NOT NULL) THEN 'show_posts' WHEN t7_.id IS NOT NULL THEN 'show' WHEN m13_.id IS NOT NULL THEN 'music-video' WHEN m14_.id IS NOT NULL THEN 'music-artist-merch' WHEN m15_.id IS NOT NULL THEN 'music-artist-post' WHEN m16_.id IS NOT NULL THEN 'music-artist-post' ELSE '' END AS sclr_42, CASE WHEN (f1_.id IS NOT NULL AND f2_.id IS NULL AND f3_.id IS NULL AND f4_.id IS NULL AND f5_.id IS NOT NULL) THEN CONCAT(f1_.name, ' - Merch') WHEN (f1_.id IS NOT NULL AND f2_.id IS NULL AND f3_.id IS NULL AND f4_.id IS NULL AND f6_.id IS NOT NULL) THEN CONCAT(f1_.name, ' - Posts') WHEN f1_.id IS NOT NULL THEN f1_.name WHEN (t7_.id IS NOT NULL AND t8_.id IS NULL AND t9_.id IS NULL AND t10_.id IS NULL AND t11_.id IS NOT NULL) THEN CONCAT(t7_.name, ' - Merch') WHEN (t7_.id IS NOT NULL AND t8_.id IS NULL AND t9_.id IS NULL AND t10_.id IS NULL AND t12_.id IS NOT NULL) THEN CONCAT(t7_.name, ' - Posts') WHEN t7_.id IS NOT NULL THEN t7_.name WHEN m13_.id IS NOT NULL THEN m13_.name WHEN m14_.id IS NOT NULL THEN CONCAT(m17_.name, ' - Merch') WHEN m15_.id IS NOT NULL THEN CONCAT(m17_.name, ' - Posts') WHEN m16_.id IS NOT NULL THEN CONCAT(m17_.name, ' - Posts') ELSE '' END AS sclr_43, CASE WHEN f1_.id IS NOT NULL THEN f1_.id WHEN t7_.id IS NOT NULL THEN t7_.id WHEN m13_.id IS NOT NULL THEN m13_.id WHEN m14_.id IS NOT NULL THEN m17_.id WHEN m15_.id IS NOT NULL THEN m17_.id WHEN m16_.id IS NOT NULL THEN m17_.id ELSE '' END AS sclr_44, e0_.e_commerce_subcategory_id AS e_commerce_subcategory_id_45, e0_.e_commerce_item_type_id AS e_commerce_item_type_id_46, e0_.e_commerce_item_template_id AS e_commerce_item_template_id_47, e0_.brand_id AS brand_id_48, e0_.main_image_id AS main_image_id_49 FROM e_commerce_item e0_ LEFT JOIN bind_film_scene_item_character b18_ ON (b18_.e_commerce_item_id = e0_.id) LEFT JOIN bind_film_character_signature_item b19_ ON (b19_.e_commerce_item_id = e0_.id) LEFT JOIN bind_film_set_item b20_ ON (b20_.e_commerce_item_id = e0_.id) LEFT JOIN bind_film_merch b21_ ON (b21_.e_commerce_item_id = e0_.id) LEFT JOIN bind_film_post_item_character b22_ ON (b22_.e_commerce_item_id = e0_.id) LEFT JOIN film_scene f2_ ON b18_.film_scene_id = f2_.id AND (f2_.publish = 1) LEFT JOIN film_character_signature f23_ ON b19_.film_character_signature_id = f23_.id LEFT JOIN film_character f3_ ON f23_.character_id = f3_.id LEFT JOIN film_set f24_ ON b20_.film_set_id = f24_.id AND (f24_.publish = 1) LEFT JOIN film_set_category f4_ ON f24_.film_set_category_id = f4_.id AND (f4_.publish = 1) LEFT JOIN film_merch f5_ ON b21_.film_merch_id = f5_.id AND (f5_.publish = 1) LEFT JOIN film_posts f6_ ON b22_.film_post_id = f6_.id AND (f6_.publish = 1) LEFT JOIN film f1_ ON (f1_.publish = 1 AND f1_.id = f2_.film_id OR f1_.id = f3_.film_id OR f1_.id = f4_.film_id OR f1_.id = f5_.film_id OR f1_.id = f6_.film_id) LEFT JOIN bind_tv_show_scene_item_character b25_ ON (b25_.e_commerce_item_id = e0_.id) LEFT JOIN bind_tv_show_character_signature_item b26_ ON (b26_.e_commerce_item_id = e0_.id) LEFT JOIN bind_tv_show_set_item b27_ ON (b27_.e_commerce_item_id = e0_.id) LEFT JOIN bind_tv_show_merch b28_ ON (b28_.e_commerce_item_id = e0_.id) LEFT JOIN bind_tv_show_post_item_character b29_ ON (b29_.e_commerce_item_id = e0_.id) LEFT JOIN tv_show_scene t30_ ON b25_.tv_show_scene_id = t30_.id AND (t30_.publish = 1) LEFT JOIN tv_show_episode t31_ ON t30_.tv_show_episode_id = t31_.id AND (t31_.publish = 1) LEFT JOIN tv_show_season t8_ ON t31_.tv_show_season_id = t8_.id AND (t8_.publish = 1) LEFT JOIN tv_show_character_signature t32_ ON b26_.tv_show_character_signature_id = t32_.id AND (t32_.publish = 1) LEFT JOIN tv_show_character t9_ ON t32_.character_id = t9_.id LEFT JOIN tv_show_set t33_ ON b27_.tv_show_set_id = t33_.id AND (t33_.publish = 1) LEFT JOIN tv_show_set_category t10_ ON t33_.tv_show_set_category_id = t10_.id AND (t10_.publish = 1) LEFT JOIN tv_show_merch t11_ ON b28_.tv_show_merch_id = t11_.id AND (t11_.publish = 1) LEFT JOIN tv_show_posts t12_ ON b29_.tv_show_post_id = t12_.id AND (t12_.publish = 1) LEFT JOIN tv_show t7_ ON (t7_.publish = 1 AND t7_.id = t8_.tv_show_id OR t7_.id = t9_.tv_show_id OR t7_.id = t10_.tv_show_id OR t7_.id = t11_.tv_show_id OR t7_.id = t12_.tv_show_id) LEFT JOIN bind_music_video_scene_item_character b34_ ON (b34_.e_commerce_item_id = e0_.id) LEFT JOIN bind_music_video_character_signature_item b35_ ON (b35_.e_commerce_item_id = e0_.id) LEFT JOIN bind_music_video_set_item b36_ ON (b36_.e_commerce_item_id = e0_.id) LEFT JOIN music_scene m37_ ON b34_.music_scene_id = m37_.id AND (m37_.publish = 1) LEFT JOIN music_video_character_signature m38_ ON b35_.music_video_character_signature_id = m38_.id LEFT JOIN music_video_character m39_ ON m38_.character_id = m39_.id LEFT JOIN music_video_set m40_ ON b36_.music_video_set_id = m40_.id AND (m40_.publish = 1) LEFT JOIN music_video_set_category m41_ ON m40_.music_video_set_category_id = m41_.id AND (m41_.publish = 1) LEFT JOIN music_video m13_ ON (m13_.publish = 1 AND m13_.id = m37_.music_video_id OR m13_.id = m39_.music_video_id OR m13_.id = m41_.music_video_id) LEFT JOIN music_artist_to_music_video m43_ ON m13_.id = m43_.music_video_id LEFT JOIN music_artist m42_ ON m42_.id = m43_.music_artist_id LEFT JOIN bind_music_artist_merch b44_ ON (b44_.e_commerce_item_id = e0_.id) LEFT JOIN music_artist_merch m14_ ON b44_.music_artist_merch_id = m14_.id AND (m14_.publish = 1) LEFT JOIN bind_music_artist_post_item_character b45_ ON (b45_.e_commerce_item_id = e0_.id) LEFT JOIN music_artist_posts m15_ ON b45_.music_artist_post_id = m15_.id AND (m15_.publish = 1) LEFT JOIN bind_music_artist_post_item_guest_character b46_ ON (b46_.e_commerce_item_id = e0_.id) LEFT JOIN music_artist_posts m16_ ON b46_.music_artist_post_id = m16_.id AND (m16_.publish = 1) LEFT JOIN music_artist m17_ ON (m17_.publish = 1 AND m17_.id = m14_.music_artist_id OR m17_.id = m15_.music_artist_id OR m17_.id = m16_.music_artist_id) WHERE (f1_.publish = 1 OR t7_.publish = 1 OR (m13_.publish = 1 AND m42_.publish = 1) OR m17_.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: 
[
  41947
]
View formatted query    View runnable query    Explain query    View query backtrace
3.15 ms
(0.04%) 		1 
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: 
[
  41947
]
View formatted query    View runnable query    Explain query    View query backtrace
1.94 ms
(0.03%) 		1 
SELECT e0_.id AS sclr_0, e0_.name AS sclr_1 FROM e_commerce_item e1_ INNER JOIN e_commerce_item_settings_discovery e2_ ON e1_.id = e2_.item_id AND (e2_.discovery = 1 AND e2_.quantity_update <> 0) INNER JOIN item_color i3_ ON e1_.id = i3_.item_id INNER JOIN item_color_to_base_color i5_ ON i3_.id = i5_.item_color_id INNER JOIN base_color b4_ ON b4_.id = i5_.base_color_id INNER JOIN e_commerce_item_to_production e6_ ON e1_.id = e6_.e_commerce_item_id AND (e6_.published = 1) INNER JOIN e_commerce_item_type e0_ ON e1_.e_commerce_item_type_id = e0_.id WHERE e1_.imported = 0 AND e1_.removed = 0 AND e1_.name IS NOT NULL AND e1_.e_commerce_item_type_id IS NOT NULL AND e1_.description IS NOT NULL AND e1_.e_commerce_subcategory_id IS NOT NULL GROUP BY e0_.id
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.16 ms
(0.02%) 		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 INNER JOIN country_to_brand ON t0.id = country_to_brand.country_id WHERE country_to_brand.brand_id = ?
Parameters: 
[
  44
]
View formatted query    View runnable query    Explain query    View query backtrace
1.05 ms
(0.01%) 		3 
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
0.94 ms
(0.01%) 		1 
SELECT a0_.id AS id_0, a0_.publish AS publish_1, a0_.name AS name_2, a0_.owner_id AS owner_id_3, a0_.owner_type AS owner_type_4, a0_.tags AS tags_5, a0_.published AS published_6 FROM admin_wishlist a0_ INNER JOIN admin_wishlist_item a1_ ON a0_.id = a1_.admin_wishlist_id INNER JOIN e_commerce_item e2_ ON a1_.item_id = e2_.id AND (e2_.id = ?) WHERE a0_.publish = ? AND e2_.removed = 0
Parameters: 
[
  41947
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
0.88 ms
(0.01%) 		2 
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
0.85 ms
(0.01%) 		1 
SELECT t0.name AS name_1, t0.publish AS publish_2, t0.complete AS complete_3, t0.updated AS updated_4, t0.position AS position_5, t0.id AS id_6, t0.auto_mainstreet AS auto_mainstreet_7, t0.commission AS commission_8, t0.spotify_username AS spotify_username_9, t0.spotify_link AS spotify_link_10, t0.sound_cloud_username AS sound_cloud_username_11, t0.sound_cloud_link AS sound_cloud_link_12, t0.tik_tok_username AS tik_tok_username_13, t0.tik_tok_link AS tik_tok_link_14, t0.imdb_link AS imdb_link_15, t0.wikipedia_link AS wikipedia_link_16, t0.approve_status AS approve_status_17, t0.old_parents AS old_parents_18, t0.thumbnail AS thumbnail_19, t0.description AS description_20, t0.short_description AS short_description_21, t0.actual_publish_date AS actual_publish_date_22, t0.youtube_username AS youtube_username_23, t0.youtube_link AS youtube_link_24, t0.instagram_username AS instagram_username_25, t0.instagram_link AS instagram_link_26, t0.twitter_username AS twitter_username_27, t0.twitter_link AS twitter_link_28, t0.facebook_username AS facebook_username_29, t0.facebook_link AS facebook_link_30, t0.website_link AS website_link_31, t0.stripe_customer AS stripe_customer_32 FROM music_artist t0 ORDER BY t0.name ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.82 ms
(0.01%) 		1 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.81 ms
(0.01%) 		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 ORDER BY t0.name ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.68 ms
(0.01%) 		1 
SELECT t0.id AS id_1, t0.loan AS loan_2, t0.loan_show AS loan_show_3, t0.loan_film AS loan_film_4, t0.loan_music_video AS loan_music_video_5, t0.loan_music_artist AS loan_music_artist_6, t0.loan_talent AS loan_talent_7, t0.loan_editorial AS loan_editorial_8, t0.loan_advertisement AS loan_advertisement_9, t0.loan_photoshoot AS loan_photoshoot_10, t0.loan_red_carpet AS loan_red_carpet_11, t0.loan_other AS loan_other_12, t0.loan_buyout_show AS loan_buyout_show_13, t0.loan_buyout_film AS loan_buyout_film_14, t0.loan_buyout_music_video AS loan_buyout_music_video_15, t0.loan_buyout_music_artist AS loan_buyout_music_artist_16, t0.loan_buyout_talent AS loan_buyout_talent_17, t0.loan_buyout_editorial AS loan_buyout_editorial_18, t0.loan_buyout_advertisement AS loan_buyout_advertisement_19, t0.loan_buyout_photoshoot AS loan_buyout_photoshoot_20, t0.loan_buyout_red_carpet AS loan_buyout_red_carpet_21, t0.loan_buyout_other AS loan_buyout_other_22, t0.quantity_general AS quantity_general_23, t0.quantity AS quantity_24, t0.return_insurance_general AS return_insurance_general_25, t0.return_insurance AS return_insurance_26, t0.policy_insurance_general AS policy_insurance_general_27, t0.policy_insurance AS policy_insurance_28, t0.default_reasonable_wear_and_tear AS default_reasonable_wear_and_tear_29, t0.reasonable_wear_and_tear AS reasonable_wear_and_tear_30, t0.default_late_fee AS default_late_fee_31, t0.late_fee_type AS late_fee_type_32, t0.late_fee_amount AS late_fee_amount_33, t0.late_fee_percent AS late_fee_percent_34, t0.late_fee_period AS late_fee_period_35, t0.loan_buyout AS loan_buyout_36, t0.loan_buyout_price_type AS loan_buyout_price_type_37, t0.loan_buyout_price_value AS loan_buyout_price_value_38, t0.security_hold AS security_hold_39, t0.security_hold_percent AS security_hold_percent_40, t0.shopify_sync AS shopify_sync_41, t0.shopify_sync_add AS shopify_sync_add_42, t0.squarespace_sync AS squarespace_sync_43, t0.squarespace_sync_add AS squarespace_sync_add_44, t0.default_quantity_update AS default_quantity_update_45, t0.quantity_update AS quantity_update_46, t0.item_id AS item_id_47 FROM e_commerce_item_settings_loan t0 WHERE t0.item_id = ?
Parameters: 
[
  41947
]
View formatted query    View runnable query    Explain query    View query backtrace
0.62 ms
(0.01%) 		1 
SELECT i0_.updated AS updated_0, i0_.position AS position_1, i0_.id AS id_2, i0_.user_id AS user_id_3, i0_.item_id AS item_id_4, i0_.image_to_brand_id AS image_to_brand_id_5 FROM item_to_brand_image i0_ INNER JOIN image_to_brand i1_ ON (i0_.image_to_brand_id = i1_.id) INNER JOIN image i2_ ON (i1_.image_id = i2_.id) WHERE i0_.item_id = ? ORDER BY i0_.position ASC
Parameters: 
[
  41947
]
View formatted query    View runnable query    Explain query    View query backtrace
0.59 ms
(0.01%) 		2 
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
0.53 ms
(0.01%) 		2 
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
0.53 ms
(0.01%) 		1 
SELECT t0.name AS name_1, t0.thumbnail AS thumbnail_2, t0.short_description AS short_description_3, t0.description AS description_4, t0.release_date AS release_date_5, t0.publish AS publish_6, t0.complete AS complete_7, t0.updated AS updated_8, t0.position AS position_9, t0.id AS id_10, t0.auto_mainstreet AS auto_mainstreet_11, t0.commission AS commission_12, t0.contact_name AS contact_name_13, t0.email AS email_14, t0.video_link AS video_link_15, t0.spotify_username AS spotify_username_16, t0.spotify_link AS spotify_link_17, t0.sound_cloud_username AS sound_cloud_username_18, t0.sound_cloud_link AS sound_cloud_link_19, t0.tik_tok_username AS tik_tok_username_20, t0.tik_tok_link AS tik_tok_link_21, t0.approve_status AS approve_status_22, t0.old_parents AS old_parents_23, t0.publish_date AS publish_date_24, t0.actual_publish_date AS actual_publish_date_25, t0.youtube_username AS youtube_username_26, t0.youtube_link AS youtube_link_27, t0.instagram_username AS instagram_username_28, t0.instagram_link AS instagram_link_29, t0.twitter_username AS twitter_username_30, t0.twitter_link AS twitter_link_31, t0.facebook_username AS facebook_username_32, t0.facebook_link AS facebook_link_33, t0.website_link AS website_link_34, t0.stripe_customer AS stripe_customer_35, t0.season_id AS season_id_36 FROM music_video t0 ORDER BY t0.name ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.48 ms
(0.01%) 		1 
SELECT t0.name AS name_1, t0.position AS position_2, t0.id AS id_3, t0.variation_set_id AS variation_set_id_4 FROM variation_set_param t0 INNER JOIN item_inventory_discovery_to_variation_set_param ON t0.id = item_inventory_discovery_to_variation_set_param.variation_set_param_id WHERE item_inventory_discovery_to_variation_set_param.item_inventory_discovery_id = ?
Parameters: 
[
  153550
]
View formatted query    View runnable query    Explain query    View query backtrace
0.47 ms
(0.01%) 		1 
SELECT t0.publish AS publish_1, t0.complete AS complete_2, t0.release_date AS release_date_3, t0.commission AS commission_4, t0.auto_mainstreet AS auto_mainstreet_5, t0.contact_name AS contact_name_6, t0.email AS email_7, t0.imdb_link AS imdb_link_8, t0.approve_status AS approve_status_9, t0.old_parents AS old_parents_10, t0.name AS name_11, t0.position AS position_12, t0.id AS id_13, t0.description AS description_14, t0.thumbnail AS thumbnail_15, t0.updated AS updated_16, t0.publish_date AS publish_date_17, t0.actual_publish_date AS actual_publish_date_18, t0.youtube_username AS youtube_username_19, t0.youtube_link AS youtube_link_20, t0.instagram_username AS instagram_username_21, t0.instagram_link AS instagram_link_22, t0.twitter_username AS twitter_username_23, t0.twitter_link AS twitter_link_24, t0.facebook_username AS facebook_username_25, t0.facebook_link AS facebook_link_26, t0.website_link AS website_link_27, t0.stripe_customer AS stripe_customer_28, t0.tv_show_season_id AS tv_show_season_id_29, t0.season_id AS season_id_30 FROM tv_show t0 ORDER BY t0.name ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.47 ms
(0.01%) 		1 
SELECT t0.id AS id_1, t0.rental AS rental_2, t0.rental_show AS rental_show_3, t0.rental_film AS rental_film_4, t0.rental_music_video AS rental_music_video_5, t0.rental_music_artist AS rental_music_artist_6, t0.rental_talent AS rental_talent_7, t0.rental_editorial AS rental_editorial_8, t0.rental_advertisement AS rental_advertisement_9, t0.rental_photoshoot AS rental_photoshoot_10, t0.rental_red_carpet AS rental_red_carpet_11, t0.rental_other AS rental_other_12, t0.rental_buyout_show AS rental_buyout_show_13, t0.rental_buyout_film AS rental_buyout_film_14, t0.rental_buyout_music_video AS rental_buyout_music_video_15, t0.rental_buyout_music_artist AS rental_buyout_music_artist_16, t0.rental_buyout_talent AS rental_buyout_talent_17, t0.rental_buyout_editorial AS rental_buyout_editorial_18, t0.rental_buyout_advertisement AS rental_buyout_advertisement_19, t0.rental_buyout_photoshoot AS rental_buyout_photoshoot_20, t0.rental_buyout_red_carpet AS rental_buyout_red_carpet_21, t0.rental_buyout_other AS rental_buyout_other_22, t0.quantity_general AS quantity_general_23, t0.quantity AS quantity_24, t0.rental_price_type_general AS rental_price_type_general_25, t0.rental_price_value AS rental_price_value_26, t0.rental_period_general AS rental_period_general_27, t0.return_insurance_general AS return_insurance_general_28, t0.return_insurance AS return_insurance_29, t0.policy_insurance_general AS policy_insurance_general_30, t0.policy_insurance AS policy_insurance_31, t0.default_reasonable_wear_and_tear AS default_reasonable_wear_and_tear_32, t0.reasonable_wear_and_tear AS reasonable_wear_and_tear_33, t0.default_late_fee AS default_late_fee_34, t0.late_fee_type AS late_fee_type_35, t0.late_fee_amount AS late_fee_amount_36, t0.late_fee_percent AS late_fee_percent_37, t0.late_fee_period AS late_fee_period_38, t0.rental_buyout AS rental_buyout_39, t0.rental_buyout_price_type AS rental_buyout_price_type_40, t0.rental_buyout_price_value AS rental_buyout_price_value_41, t0.security_hold AS security_hold_42, t0.security_hold_percent AS security_hold_percent_43, t0.shopify_sync AS shopify_sync_44, t0.shopify_sync_add AS shopify_sync_add_45, t0.squarespace_sync AS squarespace_sync_46, t0.squarespace_sync_add AS squarespace_sync_add_47, t0.default_quantity_update AS default_quantity_update_48, t0.quantity_update AS quantity_update_49, t0.item_id AS item_id_50 FROM e_commerce_item_settings_rental t0 WHERE t0.item_id = ?
Parameters: 
[
  41947
]
View formatted query    View runnable query    Explain query    View query backtrace
0.46 ms
(0.01%) 		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
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.42 ms
(0.01%) 		1 
SELECT t0.name AS name_1, t0.thumbnail AS thumbnail_2, t0.short_description AS short_description_3, t0.description AS description_4, t0.publish AS publish_5, t0.complete AS complete_6, t0.release_date AS release_date_7, t0.position AS position_8, t0.updated AS updated_9, t0.id AS id_10, t0.commission AS commission_11, t0.auto_mainstreet AS auto_mainstreet_12, t0.contact_name AS contact_name_13, t0.email AS email_14, t0.imdb_link AS imdb_link_15, t0.approve_status AS approve_status_16, t0.old_parents AS old_parents_17, t0.publish_date AS publish_date_18, t0.actual_publish_date AS actual_publish_date_19, t0.youtube_username AS youtube_username_20, t0.youtube_link AS youtube_link_21, t0.instagram_username AS instagram_username_22, t0.instagram_link AS instagram_link_23, t0.twitter_username AS twitter_username_24, t0.twitter_link AS twitter_link_25, t0.facebook_username AS facebook_username_26, t0.facebook_link AS facebook_link_27, t0.website_link AS website_link_28, t0.stripe_customer AS stripe_customer_29, t0.season_id AS season_id_30 FROM film t0 ORDER BY t0.name ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.40 ms
(0.01%) 		1 
SELECT t0.id AS id_1, t0.purchase AS purchase_2, t0.purchase_show AS purchase_show_3, t0.purchase_film AS purchase_film_4, t0.purchase_music_video AS purchase_music_video_5, t0.purchase_music_artist AS purchase_music_artist_6, t0.purchase_talent AS purchase_talent_7, t0.purchase_editorial AS purchase_editorial_8, t0.purchase_advertisement AS purchase_advertisement_9, t0.purchase_photoshoot AS purchase_photoshoot_10, t0.purchase_red_carpet AS purchase_red_carpet_11, t0.purchase_other AS purchase_other_12, t0.reserve_purchase_show AS reserve_purchase_show_13, t0.reserve_purchase_film AS reserve_purchase_film_14, t0.reserve_purchase_music_video AS reserve_purchase_music_video_15, t0.reserve_purchase_music_artist AS reserve_purchase_music_artist_16, t0.reserve_purchase_talent AS reserve_purchase_talent_17, t0.reserve_purchase_editorial AS reserve_purchase_editorial_18, t0.reserve_purchase_advertisement AS reserve_purchase_advertisement_19, t0.reserve_purchase_photoshoot AS reserve_purchase_photoshoot_20, t0.reserve_purchase_red_carpet AS reserve_purchase_red_carpet_21, t0.reserve_purchase_other AS reserve_purchase_other_22, t0.quantity_general AS quantity_general_23, t0.quantity AS quantity_24, t0.purchase_price_type_general AS purchase_price_type_general_25, t0.purchase_price_value AS purchase_price_value_26, t0.reserve_purchase AS reserve_purchase_27, t0.reserve_purchase_price_type AS reserve_purchase_price_type_28, t0.reserve_purchase_price_value AS reserve_purchase_price_value_29, t0.made_to_order_type AS made_to_order_type_30, t0.pre_order_type AS pre_order_type_31, t0.default_return_policy AS default_return_policy_32, t0.return_policy AS return_policy_33, t0.default_care AS default_care_34, t0.care AS care_35, t0.shopify_sync AS shopify_sync_36, t0.shopify_sync_add AS shopify_sync_add_37, t0.squarespace_sync AS squarespace_sync_38, t0.squarespace_sync_add AS squarespace_sync_add_39, t0.default_quantity_update AS default_quantity_update_40, t0.quantity_update AS quantity_update_41, t0.item_id AS item_id_42 FROM e_commerce_item_settings_purchase t0 WHERE t0.item_id = ?
Parameters: 
[
  41947
]
View formatted query    View runnable query    Explain query    View query backtrace
0.39 ms
(0.01%) 		1 
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
0.38 ms
(0.01%) 		1 
SELECT t0.name AS name_1, t0.position AS position_2, t0.id AS id_3 FROM e_commerce_category t0 WHERE t0.id = ?
Parameters: 
[
  11
]
View formatted query    View runnable query    Explain query    View query backtrace
0.33 ms
(0.00%) 		1 
SELECT t0.id AS id_1, t0.discovery AS discovery_2, t0.discovery_show AS discovery_show_3, t0.discovery_film AS discovery_film_4, t0.discovery_music_video AS discovery_music_video_5, t0.discovery_music_artist AS discovery_music_artist_6, t0.discovery_talent AS discovery_talent_7, t0.discovery_editorial AS discovery_editorial_8, t0.discovery_advertisement AS discovery_advertisement_9, t0.quantity_general AS quantity_general_10, t0.quantity AS quantity_11, t0.made_to_order_type AS made_to_order_type_12, t0.pre_order_type AS pre_order_type_13, t0.default_shipping_policy AS default_shipping_policy_14, t0.shipping_policy AS shipping_policy_15, t0.default_return_policy AS default_return_policy_16, t0.return_policy AS return_policy_17, t0.default_care AS default_care_18, t0.care AS care_19, t0.shopify_sync AS shopify_sync_20, t0.shopify_sync_add AS shopify_sync_add_21, t0.squarespace_sync AS squarespace_sync_22, t0.squarespace_sync_add AS squarespace_sync_add_23, t0.default_quantity_update AS default_quantity_update_24, t0.quantity_update AS quantity_update_25, t0.item_id AS item_id_26 FROM e_commerce_item_settings_discovery t0 WHERE t0.item_id = ?
Parameters: 
[
  41947
]
View formatted query    View runnable query    Explain query    View query backtrace
0.32 ms
(0.00%) 		1 
SELECT t0.id AS id_1, t0.item_id AS item_id_2, t0.size_id AS size_id_3 FROM item_size_grid t0 WHERE t0.item_id = ?
Parameters: 
[
  41947
]
View formatted query    View runnable query    Explain query    View query backtrace
0.30 ms
(0.00%) 		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 = ? LIMIT 1
Parameters: 
[
  "USD"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.29 ms
(0.00%) 		1 
SELECT t0.id AS id_1, t0.in_person AS in_person_2, t0.quantity_general AS quantity_general_3, t0.quantity AS quantity_4, t0.industry_discount_type_general AS industry_discount_type_general_5, t0.industry_discount_value AS industry_discount_value_6, t0.made_to_order_type AS made_to_order_type_7, t0.pre_order_type AS pre_order_type_8, t0.shopify_sync AS shopify_sync_9, t0.shopify_sync_add AS shopify_sync_add_10, t0.squarespace_sync AS squarespace_sync_11, t0.squarespace_sync_add AS squarespace_sync_add_12, t0.default_quantity_update AS default_quantity_update_13, t0.quantity_update AS quantity_update_14, t0.item_id AS item_id_15 FROM e_commerce_item_settings_in_person t0 WHERE t0.item_id = ?
Parameters: 
[
  41947
]
View formatted query    View runnable query    Explain query    View query backtrace
0.29 ms
(0.00%) 		1 
INSERT INTO e_commerce_item_trend (points, updated, target_id) VALUES (?, ?, ?)
Parameters: 
[
  1
  "2026-02-19 00:33:55"
  41947
]
View formatted query    View runnable query    Explain query    View query backtrace
0.26 ms
(0.00%) 		1 
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
0.24 ms
(0.00%) 		1 
SELECT t0.name AS name_1, t0.position AS position_2, t0.id AS id_3, t0.e_commerce_category_id AS e_commerce_category_id_4 FROM e_commerce_subcategory t0 WHERE t0.id = ?
Parameters: 
[
  58
]
View formatted query    View runnable query    Explain query    View query backtrace
0.18 ms
(0.00%) 		1 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace

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\Brand 434
Mirinly\AdminBundle\Entity\BrandSettingsLoan 434
Mirinly\AdminBundle\Entity\BrandSettingsRental 434
Mirinly\AdminBundle\Entity\BrandSettingsPurchase 434
Mirinly\AdminBundle\Entity\BrandSettingsCustomCommission 434
Mirinly\AdminBundle\Entity\BrandSettingsInPerson 434
Mirinly\AdminBundle\Entity\BrandSettingsDiscovery 434
Mirinly\AdminBundle\Entity\BrandNotifyNewAddedProductions 431
Mirinly\AdminBundle\Entity\Country 233
Mirinly\AdminBundle\Entity\Currency 153
Mirinly\AdminBundle\Entity\ImageToBrand 114
Mirinly\AdminBundle\Entity\MusicArtist 80
Mirinly\AdminBundle\Entity\AdminWishlist 66
Mirinly\AdminBundle\Entity\ECommerceSubcategory 60
Mirinly\AdminBundle\Entity\Season 22
Mirinly\AdminBundle\Entity\TvShow 20
Mirinly\AdminBundle\Entity\Page 9
Mirinly\AdminBundle\Entity\MusicVideo 8
Mirinly\AdminBundle\Entity\Continent 7
Mirinly\AdminBundle\Entity\TvShowSeason 5
Mirinly\AdminBundle\Entity\ECommerceItemType 4
Mirinly\AdminBundle\Entity\Film 4
Mirinly\AdminBundle\Entity\State 4
Mirinly\AdminBundle\Entity\ECommerceItemTrend 2
Mirinly\AdminBundle\Entity\Image 2
Mirinly\AdminBundle\Entity\Parameters 2
Mirinly\AdminBundle\Entity\ECommerceItem 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\ECommerceCategory 1
Mirinly\AdminBundle\Entity\ItemToBrandImage 1
Mirinly\AdminBundle\Entity\User 1
Mirinly\AdminBundle\Entity\ItemInventoryDiscovery 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.
Mirinly\AdminBundle\Entity\ItemSizeGrid No errors.
Mirinly\AdminBundle\Entity\ItemColor 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\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\ECommerceItemSettingsDiscovery 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\BaseColor No errors.
Mirinly\AdminBundle\Entity\ECommerceCategory No errors.
Mirinly\AdminBundle\Entity\Size 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\ItemToBrandImage 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\AdminWishlist No errors.
Mirinly\AdminBundle\Entity\Wishlist No errors.
Mirinly\AdminBundle\Entity\AdminWishlistItem No errors.
Mirinly\AdminBundle\Entity\AdminWishlistTrend No errors.
Mirinly\AdminBundle\Entity\UserToTvShow No errors.
Mirinly\AdminBundle\Entity\Director No errors.
Mirinly\AdminBundle\Entity\Producer No errors.
Mirinly\AdminBundle\Entity\TvShowLookBook No errors.
Mirinly\AdminBundle\Entity\TvShowLookBookFolder No errors.
Mirinly\AdminBundle\Entity\TvShowTrend No errors.
Mirinly\AdminBundle\Entity\Artist No errors.
Mirinly\AdminBundle\Entity\BrandApproveSeasonToTvShow 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\TvShowWallet No errors.
Mirinly\AdminBundle\Entity\UserToFilm No errors.
Mirinly\AdminBundle\Entity\FilmLookBook No errors.
Mirinly\AdminBundle\Entity\FilmLookBookFolder No errors.
Mirinly\AdminBundle\Entity\FilmTrend No errors.
Mirinly\AdminBundle\Entity\BrandApproveSeasonToFilm No errors.
Mirinly\AdminBundle\Entity\FilmWallet No errors.
Mirinly\AdminBundle\Entity\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\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\BrandNotifyNewAddedProductions 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\Store No errors.
Mirinly\AdminBundle\Entity\BrandWallet No errors.
Mirinly\AdminBundle\Entity\ColorFilterDictionary No errors.
Mirinly\AdminBundle\Entity\ImageToFilm No errors.
Mirinly\AdminBundle\Entity\ImageToTvShow No errors.
Mirinly\AdminBundle\Entity\ImageToMusicArtist No errors.
Mirinly\AdminBundle\Entity\ImageToMusicVideo No errors.
Mirinly\AdminBundle\Entity\ImageToNetwork No errors.
Mirinly\AdminBundle\Entity\ImageToRecordLabel No errors.
Mirinly\AdminBundle\Entity\ImageToStudio No errors.
Mirinly\AdminBundle\Entity\Complaint No errors.
Mirinly\AdminBundle\Entity\VariationSetParam No errors.
Mirinly\AdminBundle\Entity\CustomersCart No errors.
Mirinly\AdminBundle\Entity\FilmCharacterTrend No errors.
Mirinly\AdminBundle\Entity\FilmSetTrend No errors.
Mirinly\AdminBundle\Entity\TvShowEpisodeTrend No errors.
Mirinly\AdminBundle\Entity\TvShowCharacterTrend No errors.
Mirinly\AdminBundle\Entity\TvShowSetTrend No errors.
Mirinly\AdminBundle\Entity\SizeParamSet No errors.
Mirinly\AdminBundle\Entity\SizeSet No errors.
Mirinly\AdminBundle\Entity\ItemSizeParamGrid No errors.
Mirinly\AdminBundle\Entity\NetworkMerch No errors.
Mirinly\AdminBundle\Entity\NetworkPosts No errors.
Mirinly\AdminBundle\Entity\NetworkLookBook No errors.
Mirinly\AdminBundle\Entity\NetworkLookBookFolder No errors.
Mirinly\AdminBundle\Entity\BrandApproveSeasonToNetwork No errors.
Mirinly\AdminBundle\Entity\StudioMerch No errors.
Mirinly\AdminBundle\Entity\StudioPosts No errors.
Mirinly\AdminBundle\Entity\StudioLookBook No errors.
Mirinly\AdminBundle\Entity\StudioLookBookFolder No errors.
Mirinly\AdminBundle\Entity\BrandApproveSeasonToStudio No errors.
Mirinly\AdminBundle\Entity\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\BaseSize No errors.
Mirinly\AdminBundle\Entity\CustomerShippingAddress No errors.
Mirinly\AdminBundle\Entity\WishlistFollow No errors.
Mirinly\AdminBundle\Entity\ProjectRegistrationRequest No errors.
Mirinly\AdminBundle\Entity\CartOrderProject No errors.
Mirinly\AdminBundle\Entity\ProductionLookBook No errors.
Mirinly\AdminBundle\Entity\ProductionLookBookFolder No errors.
Mirinly\AdminBundle\Entity\ProductionWallet No errors.
Mirinly\AdminBundle\Entity\WishlistItem No errors.
Mirinly\AdminBundle\Entity\WishlistTrend 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\FilmLookBookItem No errors.
Mirinly\AdminBundle\Entity\FilmLookBookFolderItem No errors.
Mirinly\AdminBundle\Entity\FilmLookBookAttachment No errors.
Mirinly\AdminBundle\Entity\FilmLookBookFolderAttachment 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\AddressAttachmentToBrand No errors.
Mirinly\AdminBundle\Entity\Cart 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\Parameters No errors.
Mirinly\AdminBundle\Entity\SizeParam 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\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\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.
Mirinly\AdminBundle\Entity\Page No errors.
Mirinly\AdminBundle\Entity\CartOrderReturnAddress No errors.
Mirinly\AdminBundle\Entity\CartOrderShippingAddress No errors.
Mirinly\AdminBundle\Entity\CartOrderProductionEdits No errors.
Mirinly\AdminBundle\Entity\CartOrderBrandEdits No errors.
Mirinly\AdminBundle\Entity\IssueAttachmentProductionOrderItem No errors.
Mirinly\AdminBundle\Entity\IssueAttachmentBrandOrderItem No errors.