Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

3.38 ms Query time

14 Invalid entities

11 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.35 ms
(40.05%)

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

Parameters:

[
  379
]

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Mirinly\FrontBundle\Controller\WebhookController->saveWebhookAsAsyncMessage (line 487)
6	Mirinly\FrontBundle\Controller\WebhookController->shopifyAction (line 471)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 185)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

0.96 ms
(28.38%)

INSERT INTO messenger_messages (body, headers, queue_name, created_at, available_at) VALUES(?, ?, ?, ?, ?)

Parameters:

[
  "O:36:\"Symfony\\Component\\Messenger\\Envelope\":2:{s:44:\"\0Symfony\\Component\\Messenger\\Envelope\0stamps\";a:1:{s:46:\"Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\";a:1:{i:0;O:46:\"Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\":1:{s:55:\"\0Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\0busName\";s:21:\"messenger.bus.default\";}}}s:45:\"\0Symfony\\Component\\Messenger\\Envelope\0message\";O:26:\"App\\Message\\WebhookMessage\":1:{s:35:\"\0App\\Message\\WebhookMessage\0payload\";a:3:{s:2:\"id\";s:3:\"379\";s:5:\"topic\";s:15:\"products/update\";s:4:\"data\";a:22:{s:20:\"admin_graphql_api_id\";s:35:\"gid://shopify/Product/7130670497875\";s:9:\"body_html\";s:117:\"A classic fit crewneck tee in premium, long-staple USA-grown Supima cotton. Made at BM Knitting Mills in Mohnton, PA.\";s:10:\"created_at\";s:25:\"2024-01-10T12:31:15-08:00\";s:6:\"handle\";s:28:\"heather-oat-pima-classic-tee\";s:2:\"id\";i:7130670497875;s:12:\"product_type\";s:4:\"Tees\";s:12:\"published_at\";s:25:\"2024-01-10T12:31:11-08:00\";s:15:\"template_suffix\";N;s:5:\"title\";s:28:\"Heather Oat Pima Classic Tee\";s:10:\"updated_at\";s:25:\"2026-02-18T15:38:27-08:00\";s:6:\"vendor\";s:10:\"Buck Mason\";s:6:\"status\";s:6:\"active\";s:15:\"published_scope\";s:6:\"global\";s:4:\"tags\";s:202:\"callout--madeinusa--m, callout--mensmadeinpa, category--tees, color--heather-oat, color-group--neutrals, filter-gender:men, gender--m, product-line--pima-classic-tee, product-type--tops, style--knit-s-s\";s:8:\"variants\";a:6:{i:0;a:21:{s:20:\"admin_graphql_api_id\";s:43:\"gid://shopify/ProductVariant/41277580705875\";s:7:\"barcode\";N;s:16:\"compare_at_price\";N;s:10:\"created_at\";s:25:\"2024-01-10T12:31:15-08:00\";s:2:\"id\";i:41277580705875;s:16:\"inventory_policy\";s:4:\"deny\";s:8:\"position\";i:1;s:5:\"price\";s:5:\"48.00\";s:10:\"product_id\";i:7130670497875;s:3:\"sku\";s:16:\"BM11030.578HOAXS\";s:7:\"taxable\";b:1;s:5:\"title\";s:2:\"XS\";s:10:\"updated_at\";s:25:\"2026-02-18T15:29:28-08:00\";s:7:\"option1\";s:2:\"XS\";s:7:\"option2\";N;s:7:\"option3\";N;s:8:\"image_id\";N;s:17:\"inventory_item_id\";i:43373067272275;s:18:\"inventory_quantity\";i:127;s:22:\"old_inventory_quantity\";i:127;s:8:\"tax_code\";s:8:\"PC040100\";}i:1;a:21:{s:20:\"admin_graphql_api_id\";s:43:\"gid://shopify/ProductVariant/41277580738643\";s:7:\"barcode\";N;s:16:\"compare_at_price\";N;s:10:\"created_at\";s:25:\"2024-01-10T12:31:16-08:00\";s:2:\"id\";i:41277580738643;s:16:\"inventory_policy\";s:4:\"deny\";s:8:\"position\";i:2;s:5:\"price\";s:5:\"48.00\";s:10:\"product_id\";i:7130670497875;s:3:\"sku\";s:15:\"BM11030.578HOAS\";s:7:\"taxable\";b:1;s:5:\"title\";s:1:\"S\";s:10:\"updated_at\";s:25:\"2026-02-18T10:09:59-08:00\";s:7:\"option1\";s:1:\"S\";s:7:\"option2\";N;s:7:\"option3\";N;s:8:\"image_id\";N;s:17:\"inventory_item_id\";i:43373067305043;s:18:\"inventory_quantity\";i:372;s:22:\"old_inventory_quantity\";i:372;s:8:\"tax_code\";s:8:\"PC040100\";}i:2;a:21:{s:20:\"admin_graphql_api_id\";s:43:\"gid://shopify/ProductVariant/41277580771411\";s:7:\"barcode\";N;s:16:\"compare_at_price\";N;s:10:\"created_at\";s:25:\"2024-01-10T12:31:16-08:00\";s:2:\"id\";i:41277580771411;s:16:\"inventory_policy\";s:4:\"deny\";s:8:\"position\";i:3;s:5:\"price\";s:5:\"48.00\";s:10:\"product_id\";i:7130670497875;s:3:\"sku\";s:15:\"BM11030.578HOAM\";s:7:\"taxable\";b:1;s:5:\"title\";s:1:\"M\";s:10:\"updated_at\";s:25:\"2026-02-18T15:22:00-08:00\";s:7:\"option1\";s:1:\"M\";s:7:\"option2\";N;s:7:\"option3\";N;s:8:\"image_id\";N;s:17:\"inventory_item_id\";i:43373067337811;s:18:\"inventory_quantity\";i:955;s:22:\"old_inventory_quantity\";i:955;s:8:\"tax_code\";s:8:\"PC040100\";}i:3;a:21:{s:20:\"admin_graphql_api_id\";s:43:\"gid://shopify/ProductVariant/41277580804179\";s:7:\"barcode\";N;s:16:\"compare_at_price\";N;s:10:\"created_at\";s:25:\"2024-01-10T12:31:16-08:00\";s:2:\"id\";i:41277580804179;s:16:\"inventory_policy\";s:4:\"deny\";s:8:\"position\";i:4;s:5:\"price\";s:5:\"48.00\";s:10:\"product_id\";i:7130670497875;s:3:\"sku\";s:15:\"BM11030.578HOAL\";s:7:\"taxable\";b:1;s:5:\"title\";s:1:\"L\";s:10:\"updated_at\";s:25:\"2026-02-18T15:37:28-08:00\";s:7:\"option1\";s:1:\"L\";s:7:\"option2\";N;s:7:\"option3\";N;s:8:\"image_id\";N;s:17:\"inventory_item_id\";i:43373067370579;s:18:\"inventory_quantity\";i:706;s:22:\"old_inventory_quantity\";i:706;s:8:\"tax_code\";s:8:\"PC040100\";}i:4;a:21:{s:20:\"admin_graphql_api_id\";s:43:\"gid://shopify/ProductVariant/41277580836947\";s:7:\"barcode\";N;s:16:\"compare_at_price\";N;s:10:\"created_at\";s:25:\"2024-01-10T12:31:16-08:00\";s:2:\"id\";i:41277580836947;s:16:\"inventory_policy\";s:4:\"deny\";s:8:\"position\";i:5;s:5:\"price\";s:5:\"48.00\";s:10:\"product_id\";i:7130670497875;s:3:\"sku\";s:16:\"BM11030.578HOAXL\";s:7:\"taxable\";b:1;s:5:\"title\";s:2:\"XL\";s:10:\"updated_at\";s:25:\"2026-02-18T13:09:25-08:00\";s:7:\"option1\";s:2:\"XL\";s:7:\"option2\";N;s:7:\"option3\";N;s:8:\"image_id\";N;s:17:\"inventory_item_id\";i:43373067403347;s:18:\"inventory_quantity\";i:361;s:22:\"old_inventory_quantity\";i:361;s:8:\"tax_code\";s:8:\"PC040100\";}i:5;a:21:{s:20:\"admin_graphql_api_id\";s:43:\"gid://shopify/ProductVariant/41277580869715\";s:7:\"barcode\";N;s:16:\"compare_at_price\";N;s:10:\"created_at\";s:25:\"2024-01-10T12:31:16-08:00\";s:2:\"id\";i:41277580869715;s:16:\"inventory_policy\";s:4:\"deny\";s:8:\"position\";i:6;s:5:\"price\";s:5:\"48.00\";s:10:\"product_id\";i:7130670497875;s:3:\"sku\";s:17:\"BM11030.578HOAXXL\";s:7:\"taxable\";b:1;s:5:\"title\";s:3:\"XXL\";s:10:\"updated_at\";s:25:\"2026-02-18T05:14:09-08:00\";s:7:\"option1\";s:3:\"XXL\";s:7:\"option2\";N;s:7:\"option3\";N;s:8:\"image_id\";N;s:17:\"inventory_item_id\";i:43373067436115;s:18:\"inventory_quantity\";i:79;s:22:\"old_inventory_quantity\";i:79;s:8:\"tax_code\";s:8:\"PC040100\";}}s:7:\"options\";a:1:{i:0;a:5:{s:4:\"name\";s:5:\"Title\";s:2:\"id\";i:9172827340883;s:10:\"product_id\";i:7130670497875;s:8:\"position\";i:1;s:6:\"values\";a:6:{i:0;s:2:\"XS\";i:1;s:1:\"S\";i:2;s:1:\"M\";i:3;s:1:\"L\";i:4;s:2:\"XL\";i:5;s:3:\"XXL\";}}}s:6:\"images\";a:4:{i:0;a:11:{s:2:\"id\";i:34131031785555;s:10:\"product_id\";i:7130670497875;s:8:\"position\";i:1;s:10:\"created_at\";s:25:\"2024-02-28T21:13:11-08:00\";s:10:\"updated_at\";s:25:\"2024-02-28T21:13:33-08:00\";s:3:\"alt\";s:12:\"Product Flat\";s:5:\"width\";i:1800;s:6:\"height\";i:2400;s:3:\"src\";s:100:\"https://cdn.shopify.com/s/files/1/0123/5065/2473/files/PIMA_CLASSIC_TEE_HEATHER_OAT.jpg?v=1709183604\";s:11:\"variant_ids\";a:0:{}s:20:\"admin_graphql_api_id\";s:41:\"gid://shopify/ProductImage/34131031785555\";}i:1;a:11:{s:2:\"id\";i:36761784647763;s:10:\"product_id\";i:7130670497875;s:8:\"position\";i:2;s:10:\"created_at\";s:25:\"2025-01-23T10:30:35-08:00\";s:10:\"updated_at\";s:25:\"2025-01-23T10:30:50-08:00\";s:3:\"alt\";s:46:\"Model wearing Heather Oat Pima Classic Tee - 1\";s:5:\"width\";i:1800;s:6:\"height\";i:2400;s:3:\"src\";s:120:\"https://cdn.shopify.com/s/files/1/0123/5065/2473/files/BM11030.578HOA_HEATHER-OAT-PIMA-CLASSIC-TEE_1572.jpg?v=1737657041\";s:11:\"variant_ids\";a:0:{}s:20:\"admin_graphql_api_id\";s:41:\"gid://shopify/ProductImage/36761784647763\";}i:2;a:11:{s:2:\"id\";i:36761784614995;s:10:\"product_id\";i:7130670497875;s:8:\"position\";i:3;s:10:\"created_at\";s:25:\"2025-01-23T10:30:35-08:00\";s:10:\"updated_at\";s:25:\"2025-01-23T10:30:55-08:00\";s:3:\"alt\";s:46:\"Model wearing Heather Oat Pima Classic Tee - 2\";s:5:\"width\";i:1800;s:6:\"height\";i:2400;s:3:\"src\";s:120:\"https://cdn.shopify.com/s/files/1/0123/5065/2473/files/BM11030.578HOA_HEATHER-OAT-PIMA-CLASSIC-TEE_1568.jpg?v=1737657038\";s:11:\"variant_ids\";a:0:{}s:20:\"admin_graphql_api_id\";s:41:\"gid://shopify/ProductImage/36761784614995\";}i:3;a:11:{s:2:\"id\";i:36761784582227;s:10:\"product_id\";i:7130670497875;s:8:\"position\";i:4;s:10:\"created_at\";s:25:\"2025-01-23T10:30:35-08:00\";s:10:\"updated_at\";s:25:\"2025-01-23T10:30:59-08:00\";s:3:\"alt\";s:46:\"Model wearing Heather Oat Pima Classic Tee - 3\";s:5:\"width\";i:1800;s:6:\"height\";i:2400;s:3:\"src\";s:120:\"https://cdn.shopify.com/s/files/1/0123/5065/2473/files/BM11030.578HOA_HEATHER-OAT-PIMA-CLASSIC-TEE_1576.jpg?v=1737657037\";s:11:\"variant_ids\";a:0:{}s:20:\"admin_graphql_api_id\";s:41:\"gid://shopify/ProductImage/36761784582227\";}}s:5:\"image\";a:11:{s:2:\"id\";i:34131031785555;s:10:\"product_id\";i:7130670497875;s:8:\"position\";i:1;s:10:\"created_at\";s:25:\"2024-02-28T21:13:11-08:00\";s:10:\"updated_at\";s:25:\"2024-02-28T21:13:33-08:00\";s:3:\"alt\";s:12:\"Product Flat\";s:5:\"width\";i:1800;s:6:\"height\";i:2400;s:3:\"src\";s:100:\"https://cdn.shopify.com/s/files/1/0123/5065/2473/files/PIMA_CLASSIC_TEE_HEATHER_OAT.jpg?v=1709183604\";s:11:\"variant_ids\";a:0:{}s:20:\"admin_graphql_api_id\";s:41:\"gid://shopify/ProductImage/34131031785555\";}s:5:\"media\";a:4:{i:0;a:11:{s:2:\"id\";i:26562888269907;s:10:\"product_id\";i:7130670497875;s:8:\"position\";i:1;s:10:\"created_at\";s:25:\"2024-02-28T21:13:11-08:00\";s:10:\"updated_at\";s:25:\"2024-02-28T21:13:33-08:00\";s:3:\"alt\";s:12:\"Product Flat\";s:6:\"status\";s:5:\"READY\";s:18:\"media_content_type\";s:5:\"IMAGE\";s:13:\"preview_image\";a:4:{s:5:\"width\";i:1800;s:6:\"height\";i:2400;s:3:\"src\";s:100:\"https://cdn.shopify.com/s/files/1/0123/5065/2473/files/PIMA_CLASSIC_TEE_HEATHER_OAT.jpg?v=1709183604\";s:6:\"status\";s:5:\"READY\";}s:11:\"variant_ids\";a:0:{}s:20:\"admin_graphql_api_id\";s:39:\"gid://shopify/MediaImage/26562888269907\";}i:1;a:11:{s:2:\"id\";i:28915385270355;s:10:\"product_id\";i:7130670497875;s:8:\"position\";i:2;s:10:\"created_at\";s:25:\"2025-01-23T10:30:35-08:00\";s:10:\"updated_at\";s:25:\"2025-01-23T10:30:50-08:00\";s:3:\"alt\";s:46:\"Model wearing Heather Oat Pima Classic Tee - 1\";s:6:\"status\";s:5:\"READY\";s:18:\"media_content_type\";s:5:\"IMAGE\";s:13:\"preview_image\";a:4:{s:5:\"width\";i:1800;s:6:\"height\";i:2400;s:3:\"src\";s:120:\"https://cdn.shopify.com/s/files/1/0123/5065/2473/files/BM11030.578HOA_HEATHER-OAT-PIMA-CLASSIC-TEE_1572.jpg?v=1737657041\";s:6:\"status\";s:5:\"READY\";}s:11:\"variant_ids\";a:0:{}s:20:\"admin_graphql_api_id\";s:39:\"gid://shopify/MediaImage/28915385270355\";}i:2;a:11:{s:2:\"id\";i:28915385237587;s:10:\"product_id\";i:7130670497875;s:8:\"position\";i:3;s:10:\"created_at\";s:25:\"2025-01-23T10:30:35-08:00\";s:10:\"updated_at\";s:25:\"2025-01-23T10:30:55-08:00\";s:3:\"alt\";s:46:\"Model wearing Heather Oat Pima Classic Tee - 2\";s:6:\"status\";s:5:\"READY\";s:18:\"media_content_type\";s:5:\"IMAGE\";s:13:\"preview_image\";a:4:{s:5:\"width\";i:1800;s:6:\"height\";i:2400;s:3:\"src\";s:120:\"https://cdn.shopify.com/s/files/1/0123/5065/2473/files/BM11030.578HOA_HEATHER-OAT-PIMA-CLASSIC-TEE_1568.jpg?v=1737657038\";s:6:\"status\";s:5:\"READY\";}s:11:\"variant_ids\";a:0:{}s:20:\"admin_graphql_api_id\";s:39:\"gid://shopify/MediaImage/28915385237587\";}i:3;a:11:{s:2:\"id\";i:28915385303123;s:10:\"product_id\";i:7130670497875;s:8:\"position\";i:4;s:10:\"created_at\";s:25:\"2025-01-23T10:30:35-08:00\";s:10:\"updated_at\";s:25:\"2025-01-23T10:30:59-08:00\";s:3:\"alt\";s:46:\"Model wearing Heather Oat Pima Classic Tee - 3\";s:6:\"status\";s:5:\"READY\";s:18:\"media_content_type\";s:5:\"IMAGE\";s:13:\"preview_image\";a:4:{s:5:\"width\";i:1800;s:6:\"height\";i:2400;s:3:\"src\";s:120:\"https://cdn.shopify.com/s/files/1/0123/5065/2473/files/BM11030.578HOA_HEATHER-OAT-PIMA-CLASSIC-TEE_1576.jpg?v=1737657037\";s:6:\"status\";s:5:\"READY\";}s:11:\"variant_ids\";a:0:{}s:20:\"admin_graphql_api_id\";s:39:\"gid://shopify/MediaImage/28915385303123\";}}s:12:\"variant_gids\";a:6:{i:0;a:2:{s:20:\"admin_graphql_api_id\";s:43:\"gid://shopify/ProductVariant/41277580804179\";s:10:\"updated_at\";s:24:\"2026-02-18T23:37:28.000Z\";}i:1;a:2:{s:20:\"admin_graphql_api_id\";s:43:\"gid://shopify/ProductVariant/41277580705875\";s:10:\"updated_at\";s:24:\"2026-02-18T23:29:28.000Z\";}i:2;a:2:{s:20:\"admin_graphql_api_id\";s:43:\"gid://shopify/ProductVariant/41277580771411\";s:10:\"updated_at\";s:24:\"2026-02-18T23:22:00.000Z\";}i:3;a:2:{s:20:\"admin_graphql_api_id\";s:43:\"gid://shopify/ProductVariant/41277580836947\";s:10:\"updated_at\";s:24:\"2026-02-18T21:09:25.000Z\";}i:4;a:2:{s:20:\"admin_graphql_api_id\";s:43:\"gid://shopify/ProductVariant/41277580738643\";s:10:\"updated_at\";s:24:\"2026-02-18T18:09:59.000Z\";}i:5;a:2:{s:20:\"admin_graphql_api_id\";s:43:\"gid://shopify/ProductVariant/41277580869715\";s:10:\"updated_at\";s:24:\"2026-02-18T13:14:09.000Z\";}}s:37:\"has_variants_that_requires_components\";b:0;s:8:\"category\";N;}}}}"
  "[]"
  "default"
  "2026-02-18 23:38:30"
  "2026-02-18 23:38:30"
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO messenger_messages (
  body, headers, queue_name, created_at,
  available_at
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO messenger_messages (body, headers, queue_name, created_at, available_at) VALUES('O:36:\\\"Symfony\\\\Component\\\\Messenger\\\\Envelope\\\":2:{s:44:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Envelope\\0stamps\\\";a:1:{s:46:\\\"Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\\";a:1:{i:0;O:46:\\\"Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\\":1:{s:55:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\0busName\\\";s:21:\\\"messenger.bus.default\\\";}}}s:45:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Envelope\\0message\\\";O:26:\\\"App\\\\Message\\\\WebhookMessage\\\":1:{s:35:\\\"\\0App\\\\Message\\\\WebhookMessage\\0payload\\\";a:3:{s:2:\\\"id\\\";s:3:\\\"379\\\";s:5:\\\"topic\\\";s:15:\\\"products/update\\\";s:4:\\\"data\\\";a:22:{s:20:\\\"admin_graphql_api_id\\\";s:35:\\\"gid://shopify/Product/7130670497875\\\";s:9:\\\"body_html\\\";s:117:\\\"A classic fit crewneck tee in premium, long-staple USA-grown Supima cotton. Made at BM Knitting Mills in Mohnton, PA.\\\";s:10:\\\"created_at\\\";s:25:\\\"2024-01-10T12:31:15-08:00\\\";s:6:\\\"handle\\\";s:28:\\\"heather-oat-pima-classic-tee\\\";s:2:\\\"id\\\";i:7130670497875;s:12:\\\"product_type\\\";s:4:\\\"Tees\\\";s:12:\\\"published_at\\\";s:25:\\\"2024-01-10T12:31:11-08:00\\\";s:15:\\\"template_suffix\\\";N;s:5:\\\"title\\\";s:28:\\\"Heather Oat Pima Classic Tee\\\";s:10:\\\"updated_at\\\";s:25:\\\"2026-02-18T15:38:27-08:00\\\";s:6:\\\"vendor\\\";s:10:\\\"Buck Mason\\\";s:6:\\\"status\\\";s:6:\\\"active\\\";s:15:\\\"published_scope\\\";s:6:\\\"global\\\";s:4:\\\"tags\\\";s:202:\\\"callout--madeinusa--m, callout--mensmadeinpa, category--tees, color--heather-oat, color-group--neutrals, filter-gender:men, gender--m, product-line--pima-classic-tee, product-type--tops, style--knit-s-s\\\";s:8:\\\"variants\\\";a:6:{i:0;a:21:{s:20:\\\"admin_graphql_api_id\\\";s:43:\\\"gid://shopify/ProductVariant/41277580705875\\\";s:7:\\\"barcode\\\";N;s:16:\\\"compare_at_price\\\";N;s:10:\\\"created_at\\\";s:25:\\\"2024-01-10T12:31:15-08:00\\\";s:2:\\\"id\\\";i:41277580705875;s:16:\\\"inventory_policy\\\";s:4:\\\"deny\\\";s:8:\\\"position\\\";i:1;s:5:\\\"price\\\";s:5:\\\"48.00\\\";s:10:\\\"product_id\\\";i:7130670497875;s:3:\\\"sku\\\";s:16:\\\"BM11030.578HOAXS\\\";s:7:\\\"taxable\\\";b:1;s:5:\\\"title\\\";s:2:\\\"XS\\\";s:10:\\\"updated_at\\\";s:25:\\\"2026-02-18T15:29:28-08:00\\\";s:7:\\\"option1\\\";s:2:\\\"XS\\\";s:7:\\\"option2\\\";N;s:7:\\\"option3\\\";N;s:8:\\\"image_id\\\";N;s:17:\\\"inventory_item_id\\\";i:43373067272275;s:18:\\\"inventory_quantity\\\";i:127;s:22:\\\"old_inventory_quantity\\\";i:127;s:8:\\\"tax_code\\\";s:8:\\\"PC040100\\\";}i:1;a:21:{s:20:\\\"admin_graphql_api_id\\\";s:43:\\\"gid://shopify/ProductVariant/41277580738643\\\";s:7:\\\"barcode\\\";N;s:16:\\\"compare_at_price\\\";N;s:10:\\\"created_at\\\";s:25:\\\"2024-01-10T12:31:16-08:00\\\";s:2:\\\"id\\\";i:41277580738643;s:16:\\\"inventory_policy\\\";s:4:\\\"deny\\\";s:8:\\\"position\\\";i:2;s:5:\\\"price\\\";s:5:\\\"48.00\\\";s:10:\\\"product_id\\\";i:7130670497875;s:3:\\\"sku\\\";s:15:\\\"BM11030.578HOAS\\\";s:7:\\\"taxable\\\";b:1;s:5:\\\"title\\\";s:1:\\\"S\\\";s:10:\\\"updated_at\\\";s:25:\\\"2026-02-18T10:09:59-08:00\\\";s:7:\\\"option1\\\";s:1:\\\"S\\\";s:7:\\\"option2\\\";N;s:7:\\\"option3\\\";N;s:8:\\\"image_id\\\";N;s:17:\\\"inventory_item_id\\\";i:43373067305043;s:18:\\\"inventory_quantity\\\";i:372;s:22:\\\"old_inventory_quantity\\\";i:372;s:8:\\\"tax_code\\\";s:8:\\\"PC040100\\\";}i:2;a:21:{s:20:\\\"admin_graphql_api_id\\\";s:43:\\\"gid://shopify/ProductVariant/41277580771411\\\";s:7:\\\"barcode\\\";N;s:16:\\\"compare_at_price\\\";N;s:10:\\\"created_at\\\";s:25:\\\"2024-01-10T12:31:16-08:00\\\";s:2:\\\"id\\\";i:41277580771411;s:16:\\\"inventory_policy\\\";s:4:\\\"deny\\\";s:8:\\\"position\\\";i:3;s:5:\\\"price\\\";s:5:\\\"48.00\\\";s:10:\\\"product_id\\\";i:7130670497875;s:3:\\\"sku\\\";s:15:\\\"BM11030.578HOAM\\\";s:7:\\\"taxable\\\";b:1;s:5:\\\"title\\\";s:1:\\\"M\\\";s:10:\\\"updated_at\\\";s:25:\\\"2026-02-18T15:22:00-08:00\\\";s:7:\\\"option1\\\";s:1:\\\"M\\\";s:7:\\\"option2\\\";N;s:7:\\\"option3\\\";N;s:8:\\\"image_id\\\";N;s:17:\\\"inventory_item_id\\\";i:43373067337811;s:18:\\\"inventory_quantity\\\";i:955;s:22:\\\"old_inventory_quantity\\\";i:955;s:8:\\\"tax_code\\\";s:8:\\\"PC040100\\\";}i:3;a:21:{s:20:\\\"admin_graphql_api_id\\\";s:43:\\\"gid://shopify/ProductVariant/41277580804179\\\";s:7:\\\"barcode\\\";N;s:16:\\\"compare_at_price\\\";N;s:10:\\\"created_at\\\";s:25:\\\"2024-01-10T12:31:16-08:00\\\";s:2:\\\"id\\\";i:41277580804179;s:16:\\\"inventory_policy\\\";s:4:\\\"deny\\\";s:8:\\\"position\\\";i:4;s:5:\\\"price\\\";s:5:\\\"48.00\\\";s:10:\\\"product_id\\\";i:7130670497875;s:3:\\\"sku\\\";s:15:\\\"BM11030.578HOAL\\\";s:7:\\\"taxable\\\";b:1;s:5:\\\"title\\\";s:1:\\\"L\\\";s:10:\\\"updated_at\\\";s:25:\\\"2026-02-18T15:37:28-08:00\\\";s:7:\\\"option1\\\";s:1:\\\"L\\\";s:7:\\\"option2\\\";N;s:7:\\\"option3\\\";N;s:8:\\\"image_id\\\";N;s:17:\\\"inventory_item_id\\\";i:43373067370579;s:18:\\\"inventory_quantity\\\";i:706;s:22:\\\"old_inventory_quantity\\\";i:706;s:8:\\\"tax_code\\\";s:8:\\\"PC040100\\\";}i:4;a:21:{s:20:\\\"admin_graphql_api_id\\\";s:43:\\\"gid://shopify/ProductVariant/41277580836947\\\";s:7:\\\"barcode\\\";N;s:16:\\\"compare_at_price\\\";N;s:10:\\\"created_at\\\";s:25:\\\"2024-01-10T12:31:16-08:00\\\";s:2:\\\"id\\\";i:41277580836947;s:16:\\\"inventory_policy\\\";s:4:\\\"deny\\\";s:8:\\\"position\\\";i:5;s:5:\\\"price\\\";s:5:\\\"48.00\\\";s:10:\\\"product_id\\\";i:7130670497875;s:3:\\\"sku\\\";s:16:\\\"BM11030.578HOAXL\\\";s:7:\\\"taxable\\\";b:1;s:5:\\\"title\\\";s:2:\\\"XL\\\";s:10:\\\"updated_at\\\";s:25:\\\"2026-02-18T13:09:25-08:00\\\";s:7:\\\"option1\\\";s:2:\\\"XL\\\";s:7:\\\"option2\\\";N;s:7:\\\"option3\\\";N;s:8:\\\"image_id\\\";N;s:17:\\\"inventory_item_id\\\";i:43373067403347;s:18:\\\"inventory_quantity\\\";i:361;s:22:\\\"old_inventory_quantity\\\";i:361;s:8:\\\"tax_code\\\";s:8:\\\"PC040100\\\";}i:5;a:21:{s:20:\\\"admin_graphql_api_id\\\";s:43:\\\"gid://shopify/ProductVariant/41277580869715\\\";s:7:\\\"barcode\\\";N;s:16:\\\"compare_at_price\\\";N;s:10:\\\"created_at\\\";s:25:\\\"2024-01-10T12:31:16-08:00\\\";s:2:\\\"id\\\";i:41277580869715;s:16:\\\"inventory_policy\\\";s:4:\\\"deny\\\";s:8:\\\"position\\\";i:6;s:5:\\\"price\\\";s:5:\\\"48.00\\\";s:10:\\\"product_id\\\";i:7130670497875;s:3:\\\"sku\\\";s:17:\\\"BM11030.578HOAXXL\\\";s:7:\\\"taxable\\\";b:1;s:5:\\\"title\\\";s:3:\\\"XXL\\\";s:10:\\\"updated_at\\\";s:25:\\\"2026-02-18T05:14:09-08:00\\\";s:7:\\\"option1\\\";s:3:\\\"XXL\\\";s:7:\\\"option2\\\";N;s:7:\\\"option3\\\";N;s:8:\\\"image_id\\\";N;s:17:\\\"inventory_item_id\\\";i:43373067436115;s:18:\\\"inventory_quantity\\\";i:79;s:22:\\\"old_inventory_quantity\\\";i:79;s:8:\\\"tax_code\\\";s:8:\\\"PC040100\\\";}}s:7:\\\"options\\\";a:1:{i:0;a:5:{s:4:\\\"name\\\";s:5:\\\"Title\\\";s:2:\\\"id\\\";i:9172827340883;s:10:\\\"product_id\\\";i:7130670497875;s:8:\\\"position\\\";i:1;s:6:\\\"values\\\";a:6:{i:0;s:2:\\\"XS\\\";i:1;s:1:\\\"S\\\";i:2;s:1:\\\"M\\\";i:3;s:1:\\\"L\\\";i:4;s:2:\\\"XL\\\";i:5;s:3:\\\"XXL\\\";}}}s:6:\\\"images\\\";a:4:{i:0;a:11:{s:2:\\\"id\\\";i:34131031785555;s:10:\\\"product_id\\\";i:7130670497875;s:8:\\\"position\\\";i:1;s:10:\\\"created_at\\\";s:25:\\\"2024-02-28T21:13:11-08:00\\\";s:10:\\\"updated_at\\\";s:25:\\\"2024-02-28T21:13:33-08:00\\\";s:3:\\\"alt\\\";s:12:\\\"Product Flat\\\";s:5:\\\"width\\\";i:1800;s:6:\\\"height\\\";i:2400;s:3:\\\"src\\\";s:100:\\\"https://cdn.shopify.com/s/files/1/0123/5065/2473/files/PIMA_CLASSIC_TEE_HEATHER_OAT.jpg?v=1709183604\\\";s:11:\\\"variant_ids\\\";a:0:{}s:20:\\\"admin_graphql_api_id\\\";s:41:\\\"gid://shopify/ProductImage/34131031785555\\\";}i:1;a:11:{s:2:\\\"id\\\";i:36761784647763;s:10:\\\"product_id\\\";i:7130670497875;s:8:\\\"position\\\";i:2;s:10:\\\"created_at\\\";s:25:\\\"2025-01-23T10:30:35-08:00\\\";s:10:\\\"updated_at\\\";s:25:\\\"2025-01-23T10:30:50-08:00\\\";s:3:\\\"alt\\\";s:46:\\\"Model wearing Heather Oat Pima Classic Tee - 1\\\";s:5:\\\"width\\\";i:1800;s:6:\\\"height\\\";i:2400;s:3:\\\"src\\\";s:120:\\\"https://cdn.shopify.com/s/files/1/0123/5065/2473/files/BM11030.578HOA_HEATHER-OAT-PIMA-CLASSIC-TEE_1572.jpg?v=1737657041\\\";s:11:\\\"variant_ids\\\";a:0:{}s:20:\\\"admin_graphql_api_id\\\";s:41:\\\"gid://shopify/ProductImage/36761784647763\\\";}i:2;a:11:{s:2:\\\"id\\\";i:36761784614995;s:10:\\\"product_id\\\";i:7130670497875;s:8:\\\"position\\\";i:3;s:10:\\\"created_at\\\";s:25:\\\"2025-01-23T10:30:35-08:00\\\";s:10:\\\"updated_at\\\";s:25:\\\"2025-01-23T10:30:55-08:00\\\";s:3:\\\"alt\\\";s:46:\\\"Model wearing Heather Oat Pima Classic Tee - 2\\\";s:5:\\\"width\\\";i:1800;s:6:\\\"height\\\";i:2400;s:3:\\\"src\\\";s:120:\\\"https://cdn.shopify.com/s/files/1/0123/5065/2473/files/BM11030.578HOA_HEATHER-OAT-PIMA-CLASSIC-TEE_1568.jpg?v=1737657038\\\";s:11:\\\"variant_ids\\\";a:0:{}s:20:\\\"admin_graphql_api_id\\\";s:41:\\\"gid://shopify/ProductImage/36761784614995\\\";}i:3;a:11:{s:2:\\\"id\\\";i:36761784582227;s:10:\\\"product_id\\\";i:7130670497875;s:8:\\\"position\\\";i:4;s:10:\\\"created_at\\\";s:25:\\\"2025-01-23T10:30:35-08:00\\\";s:10:\\\"updated_at\\\";s:25:\\\"2025-01-23T10:30:59-08:00\\\";s:3:\\\"alt\\\";s:46:\\\"Model wearing Heather Oat Pima Classic Tee - 3\\\";s:5:\\\"width\\\";i:1800;s:6:\\\"height\\\";i:2400;s:3:\\\"src\\\";s:120:\\\"https://cdn.shopify.com/s/files/1/0123/5065/2473/files/BM11030.578HOA_HEATHER-OAT-PIMA-CLASSIC-TEE_1576.jpg?v=1737657037\\\";s:11:\\\"variant_ids\\\";a:0:{}s:20:\\\"admin_graphql_api_id\\\";s:41:\\\"gid://shopify/ProductImage/36761784582227\\\";}}s:5:\\\"image\\\";a:11:{s:2:\\\"id\\\";i:34131031785555;s:10:\\\"product_id\\\";i:7130670497875;s:8:\\\"position\\\";i:1;s:10:\\\"created_at\\\";s:25:\\\"2024-02-28T21:13:11-08:00\\\";s:10:\\\"updated_at\\\";s:25:\\\"2024-02-28T21:13:33-08:00\\\";s:3:\\\"alt\\\";s:12:\\\"Product Flat\\\";s:5:\\\"width\\\";i:1800;s:6:\\\"height\\\";i:2400;s:3:\\\"src\\\";s:100:\\\"https://cdn.shopify.com/s/files/1/0123/5065/2473/files/PIMA_CLASSIC_TEE_HEATHER_OAT.jpg?v=1709183604\\\";s:11:\\\"variant_ids\\\";a:0:{}s:20:\\\"admin_graphql_api_id\\\";s:41:\\\"gid://shopify/ProductImage/34131031785555\\\";}s:5:\\\"media\\\";a:4:{i:0;a:11:{s:2:\\\"id\\\";i:26562888269907;s:10:\\\"product_id\\\";i:7130670497875;s:8:\\\"position\\\";i:1;s:10:\\\"created_at\\\";s:25:\\\"2024-02-28T21:13:11-08:00\\\";s:10:\\\"updated_at\\\";s:25:\\\"2024-02-28T21:13:33-08:00\\\";s:3:\\\"alt\\\";s:12:\\\"Product Flat\\\";s:6:\\\"status\\\";s:5:\\\"READY\\\";s:18:\\\"media_content_type\\\";s:5:\\\"IMAGE\\\";s:13:\\\"preview_image\\\";a:4:{s:5:\\\"width\\\";i:1800;s:6:\\\"height\\\";i:2400;s:3:\\\"src\\\";s:100:\\\"https://cdn.shopify.com/s/files/1/0123/5065/2473/files/PIMA_CLASSIC_TEE_HEATHER_OAT.jpg?v=1709183604\\\";s:6:\\\"status\\\";s:5:\\\"READY\\\";}s:11:\\\"variant_ids\\\";a:0:{}s:20:\\\"admin_graphql_api_id\\\";s:39:\\\"gid://shopify/MediaImage/26562888269907\\\";}i:1;a:11:{s:2:\\\"id\\\";i:28915385270355;s:10:\\\"product_id\\\";i:7130670497875;s:8:\\\"position\\\";i:2;s:10:\\\"created_at\\\";s:25:\\\"2025-01-23T10:30:35-08:00\\\";s:10:\\\"updated_at\\\";s:25:\\\"2025-01-23T10:30:50-08:00\\\";s:3:\\\"alt\\\";s:46:\\\"Model wearing Heather Oat Pima Classic Tee - 1\\\";s:6:\\\"status\\\";s:5:\\\"READY\\\";s:18:\\\"media_content_type\\\";s:5:\\\"IMAGE\\\";s:13:\\\"preview_image\\\";a:4:{s:5:\\\"width\\\";i:1800;s:6:\\\"height\\\";i:2400;s:3:\\\"src\\\";s:120:\\\"https://cdn.shopify.com/s/files/1/0123/5065/2473/files/BM11030.578HOA_HEATHER-OAT-PIMA-CLASSIC-TEE_1572.jpg?v=1737657041\\\";s:6:\\\"status\\\";s:5:\\\"READY\\\";}s:11:\\\"variant_ids\\\";a:0:{}s:20:\\\"admin_graphql_api_id\\\";s:39:\\\"gid://shopify/MediaImage/28915385270355\\\";}i:2;a:11:{s:2:\\\"id\\\";i:28915385237587;s:10:\\\"product_id\\\";i:7130670497875;s:8:\\\"position\\\";i:3;s:10:\\\"created_at\\\";s:25:\\\"2025-01-23T10:30:35-08:00\\\";s:10:\\\"updated_at\\\";s:25:\\\"2025-01-23T10:30:55-08:00\\\";s:3:\\\"alt\\\";s:46:\\\"Model wearing Heather Oat Pima Classic Tee - 2\\\";s:6:\\\"status\\\";s:5:\\\"READY\\\";s:18:\\\"media_content_type\\\";s:5:\\\"IMAGE\\\";s:13:\\\"preview_image\\\";a:4:{s:5:\\\"width\\\";i:1800;s:6:\\\"height\\\";i:2400;s:3:\\\"src\\\";s:120:\\\"https://cdn.shopify.com/s/files/1/0123/5065/2473/files/BM11030.578HOA_HEATHER-OAT-PIMA-CLASSIC-TEE_1568.jpg?v=1737657038\\\";s:6:\\\"status\\\";s:5:\\\"READY\\\";}s:11:\\\"variant_ids\\\";a:0:{}s:20:\\\"admin_graphql_api_id\\\";s:39:\\\"gid://shopify/MediaImage/28915385237587\\\";}i:3;a:11:{s:2:\\\"id\\\";i:28915385303123;s:10:\\\"product_id\\\";i:7130670497875;s:8:\\\"position\\\";i:4;s:10:\\\"created_at\\\";s:25:\\\"2025-01-23T10:30:35-08:00\\\";s:10:\\\"updated_at\\\";s:25:\\\"2025-01-23T10:30:59-08:00\\\";s:3:\\\"alt\\\";s:46:\\\"Model wearing Heather Oat Pima Classic Tee - 3\\\";s:6:\\\"status\\\";s:5:\\\"READY\\\";s:18:\\\"media_content_type\\\";s:5:\\\"IMAGE\\\";s:13:\\\"preview_image\\\";a:4:{s:5:\\\"width\\\";i:1800;s:6:\\\"height\\\";i:2400;s:3:\\\"src\\\";s:120:\\\"https://cdn.shopify.com/s/files/1/0123/5065/2473/files/BM11030.578HOA_HEATHER-OAT-PIMA-CLASSIC-TEE_1576.jpg?v=1737657037\\\";s:6:\\\"status\\\";s:5:\\\"READY\\\";}s:11:\\\"variant_ids\\\";a:0:{}s:20:\\\"admin_graphql_api_id\\\";s:39:\\\"gid://shopify/MediaImage/28915385303123\\\";}}s:12:\\\"variant_gids\\\";a:6:{i:0;a:2:{s:20:\\\"admin_graphql_api_id\\\";s:43:\\\"gid://shopify/ProductVariant/41277580804179\\\";s:10:\\\"updated_at\\\";s:24:\\\"2026-02-18T23:37:28.000Z\\\";}i:1;a:2:{s:20:\\\"admin_graphql_api_id\\\";s:43:\\\"gid://shopify/ProductVariant/41277580705875\\\";s:10:\\\"updated_at\\\";s:24:\\\"2026-02-18T23:29:28.000Z\\\";}i:2;a:2:{s:20:\\\"admin_graphql_api_id\\\";s:43:\\\"gid://shopify/ProductVariant/41277580771411\\\";s:10:\\\"updated_at\\\";s:24:\\\"2026-02-18T23:22:00.000Z\\\";}i:3;a:2:{s:20:\\\"admin_graphql_api_id\\\";s:43:\\\"gid://shopify/ProductVariant/41277580836947\\\";s:10:\\\"updated_at\\\";s:24:\\\"2026-02-18T21:09:25.000Z\\\";}i:4;a:2:{s:20:\\\"admin_graphql_api_id\\\";s:43:\\\"gid://shopify/ProductVariant/41277580738643\\\";s:10:\\\"updated_at\\\";s:24:\\\"2026-02-18T18:09:59.000Z\\\";}i:5;a:2:{s:20:\\\"admin_graphql_api_id\\\";s:43:\\\"gid://shopify/ProductVariant/41277580869715\\\";s:10:\\\"updated_at\\\";s:24:\\\"2026-02-18T13:14:09.000Z\\\";}}s:37:\\\"has_variants_that_requires_components\\\";b:0;s:8:\\\"category\\\";N;}}}}', '[]', 'default', '2026-02-18 23:38:30', '2026-02-18 23:38:30');

#	File/Call
1	Symfony\Component\Messenger\Bridge\Doctrine\Transport\Connection->executeInsert (line 458)
2	Symfony\Component\Messenger\Bridge\Doctrine\Transport\Connection->send (line 137)
3	Symfony\Component\Messenger\Bridge\Doctrine\Transport\DoctrineSender->send (line 46)
4	Symfony\Component\Messenger\Bridge\Doctrine\Transport\DoctrineTransport->send (line 72)
5	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 62)
6	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 34)
7	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 68)
8	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 41)
9	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 37)
10	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 40)
11	Symfony\Component\Messenger\MessageBus->dispatch (line 70)
12	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 38)
13	Mirinly\FrontBundle\Controller\WebhookController->saveWebhookAsAsyncMessage (line 519)
14	Mirinly\FrontBundle\Controller\WebhookController->shopifyAction (line 471)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
17	Symfony\Component\HttpKernel\Kernel->handle (line 185)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
19	require_once (line 29)
20	require_once (line 5)

0.91 ms
(26.87%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Symfony\Component\Messenger\Bridge\Doctrine\Transport\Connection->executeInsert (line 465)
2	Symfony\Component\Messenger\Bridge\Doctrine\Transport\Connection->send (line 137)
3	Symfony\Component\Messenger\Bridge\Doctrine\Transport\DoctrineSender->send (line 46)
4	Symfony\Component\Messenger\Bridge\Doctrine\Transport\DoctrineTransport->send (line 72)
5	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 62)
6	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 34)
7	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 68)
8	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 41)
9	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 37)
10	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 40)
11	Symfony\Component\Messenger\MessageBus->dispatch (line 70)
12	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 38)
13	Mirinly\FrontBundle\Controller\WebhookController->saveWebhookAsAsyncMessage (line 519)
14	Mirinly\FrontBundle\Controller\WebhookController->shopifyAction (line 471)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
17	Symfony\Component\HttpKernel\Kernel->handle (line 185)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
19	require_once (line 29)
20	require_once (line 5)

0.16 ms
(4.70%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Symfony\Component\Messenger\Bridge\Doctrine\Transport\Connection->executeInsert (line 446)
2	Symfony\Component\Messenger\Bridge\Doctrine\Transport\Connection->send (line 137)
3	Symfony\Component\Messenger\Bridge\Doctrine\Transport\DoctrineSender->send (line 46)
4	Symfony\Component\Messenger\Bridge\Doctrine\Transport\DoctrineTransport->send (line 72)
5	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 62)
6	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 34)
7	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 68)
8	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 41)
9	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 37)
10	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 40)
11	Symfony\Component\Messenger\MessageBus->dispatch (line 70)
12	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 38)
13	Mirinly\FrontBundle\Controller\WebhookController->saveWebhookAsAsyncMessage (line 519)
14	Mirinly\FrontBundle\Controller\WebhookController->shopifyAction (line 471)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
17	Symfony\Component\HttpKernel\Kernel->handle (line 185)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
19	require_once (line 29)
20	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
Mirinly\AdminBundle\Entity\Brand	1
Mirinly\AdminBundle\Entity\Currency	1
Mirinly\AdminBundle\Entity\ECommerceItemType	1
Mirinly\AdminBundle\Entity\Season	1
Mirinly\AdminBundle\Entity\BrandSettingsLoan	1
Mirinly\AdminBundle\Entity\BrandSettingsRental	1
Mirinly\AdminBundle\Entity\BrandSettingsPurchase	1
Mirinly\AdminBundle\Entity\BrandSettingsCustomCommission	1
Mirinly\AdminBundle\Entity\BrandSettingsInPerson	1
Mirinly\AdminBundle\Entity\BrandSettingsDiscovery	1
Mirinly\AdminBundle\Entity\BrandNotifyNewAddedProductions	1

Entities Mapping

Class	Mapping errors
Mirinly\AdminBundle\Entity\AbstractEntity	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\Currency	No errors.
Mirinly\AdminBundle\Entity\ImageToBrand	The field Mirinly\AdminBundle\Entity\ImageToBrand#itemToBrandImage is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\ItemToBrandImage#imageToBrand does not contain the required 'inversedBy: "itemToBrandImage"' attribute. The field Mirinly\AdminBundle\Entity\ImageToBrand#eCommerceItemsMainImage is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Mirinly\AdminBundle\Entity\ECommerceItem#mainImage does not contain the required 'inversedBy: "eCommerceItemsMainImage"' attribute.
Mirinly\AdminBundle\Entity\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\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\Season	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\State	No errors.
Mirinly\AdminBundle\Entity\BrandNotifyNewAddedProductions	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\BrandTrend	No errors.
Mirinly\AdminBundle\Entity\Country	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\VariationSet	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\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\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\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\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\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\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\SearchBrandTag	No errors.
Mirinly\AdminBundle\Entity\SearchECommerceItemTag	No errors.
Mirinly\AdminBundle\Entity\BrandReturnAddress	No errors.
Mirinly\AdminBundle\Entity\Store	No errors.
Mirinly\AdminBundle\Entity\City	No errors.
Mirinly\AdminBundle\Entity\BrandWallet	No errors.
Mirinly\AdminBundle\Entity\ColorFilterDictionary	No errors.

Symfony Profiler

POST https://mirinly.com/webhook/shopify/379

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping