Query Metrics
4
Database Queries
4
Different statements
4.24 ms
Query time
14
Invalid entities
11
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
1.55 ms (36.58%) |
1 |
SELECT t0.name AS name_1, t0.title AS title_2, t0.has_affiliate_url AS has_affiliate_url_3, t0.location AS location_4, t0.logo AS logo_5, t0.sizeGuide AS sizeGuide_6, t0.commission AS commission_7, t0.website AS website_8, t0.phone AS phone_9, t0.fax AS fax_10, t0.contact_first_name AS contact_first_name_11, t0.contact_last_name AS contact_last_name_12, t0.email AS email_13, t0.position AS position_14, t0.id AS id_15, t0.shipping_policy AS shipping_policy_16, t0.return_policy AS return_policy_17, t0.auto_mainstreet AS auto_mainstreet_18, t0.created AS created_19, t0.po_box AS po_box_20, t0.reasonable_wear_and_tear AS reasonable_wear_and_tear_21, t0.low_volume_production AS low_volume_production_22, t0.based_in AS based_in_23, t0.shopify_shop_domain AS shopify_shop_domain_24, t0.shopify_api_key AS shopify_api_key_25, t0.shopify_password AS shopify_password_26, t0.shopify_private AS shopify_private_27, t0.shopify_custom_access_token AS shopify_custom_access_token_28, t0.shopify_custom_api_key AS shopify_custom_api_key_29, t0.shopify_custom_api_secret_key AS shopify_custom_api_secret_key_30, t0.shopify_access_token AS shopify_access_token_31, t0.shopify_installation_link AS shopify_installation_link_32, t0.shopify_client_id AS shopify_client_id_33, t0.shopify_client_secret AS shopify_client_secret_34, t0.update_shopify AS update_shopify_35, t0.quantity_update AS quantity_update_36, t0.default_measurement_type AS default_measurement_type_37, t0.shopifyWay AS shopifyWay_38, t0.shopifySource AS shopifySource_39, t0.shopifyCollection AS shopifyCollection_40, t0.squarespaceSource AS squarespaceSource_41, t0.squarespaceStorePage AS squarespaceStorePage_42, t0.shopify_on AS shopify_on_43, t0.integration AS integration_44, t0.squarespace_url AS squarespace_url_45, t0.default_shopify_other_sizes_colors AS default_shopify_other_sizes_colors_46, t0.instagram_username AS instagram_username_47, t0.instagram_link AS instagram_link_48, t0.twitter_username AS twitter_username_49, t0.twitter_link AS twitter_link_50, t0.tiktok_username AS tiktok_username_51, t0.tiktok_link AS tiktok_link_52, t0.facebook_username AS facebook_username_53, t0.facebook_link AS facebook_link_54, t0.description AS description_55, t0.care AS care_56, t0.plan AS plan_57, t0.joined_first_time AS joined_first_time_58, t0.joined AS joined_59, t0.renewed_on AS renewed_on_60, t0.plan_auto_renewal_date AS plan_auto_renewal_date_61, t0.plan_expiration_date AS plan_expiration_date_62, t0.plan_billing_cycle AS plan_billing_cycle_63, t0.new_plan_billing_cycle AS new_plan_billing_cycle_64, t0.new_plan AS new_plan_65, t0.hold AS hold_66, t0.stripe_subscription AS stripe_subscription_67, t0.stripe_subscription_schedule AS stripe_subscription_schedule_68, t0.insurance AS insurance_69, t0.hide_add_project AS hide_add_project_70, t0.payout_method AS payout_method_71, t0.payout_account_number AS payout_account_number_72, t0.payout_paypal_email AS payout_paypal_email_73, t0.service_fee_percent AS service_fee_percent_74, t0.service_fee_min AS service_fee_min_75, t0.is_canadian AS is_canadian_76, t0.disable_shopify_sync_remove AS disable_shopify_sync_remove_77, t0.squarespace_auth_code AS squarespace_auth_code_78, t0.squarespace_access_token AS squarespace_access_token_79, t0.squarespace_refresh_token AS squarespace_refresh_token_80, t0.squarespace_access_token_expiration AS squarespace_access_token_expiration_81, t0.last_squarespace_update AS last_squarespace_update_82, t0.disable_squarespace_sync_remove AS disable_squarespace_sync_remove_83, t0.approve_future_productions AS approve_future_productions_84, t0.wallet_id AS wallet_id_85, t0.stripe_customer AS stripe_customer_86, t0.url_name AS url_name_87, t0.currency_id AS currency_id_88, t0.main_image_id AS main_image_id_89, t0.default_shopify_product_type_id AS default_shopify_product_type_id_90, t0.default_shopify_sub_category_id AS default_shopify_sub_category_id_91, t0.default_shopify_season_id AS default_shopify_season_id_92, t93.id AS id_94, t93.loan AS loan_95, t93.loan_show AS loan_show_96, t93.loan_film AS loan_film_97, t93.loan_music_video AS loan_music_video_98, t93.loan_music_artist AS loan_music_artist_99, t93.loan_talent AS loan_talent_100, t93.loan_editorial AS loan_editorial_101, t93.loan_advertisement AS loan_advertisement_102, t93.loan_photoshoot AS loan_photoshoot_103, t93.loan_red_carpet AS loan_red_carpet_104, t93.loan_other AS loan_other_105, t93.loan_buyout AS loan_buyout_106, t93.loan_buyout_show AS loan_buyout_show_107, t93.loan_buyout_film AS loan_buyout_film_108, t93.loan_buyout_music_video AS loan_buyout_music_video_109, t93.loan_buyout_music_artist AS loan_buyout_music_artist_110, t93.loan_buyout_talent AS loan_buyout_talent_111, t93.loan_buyout_editorial AS loan_buyout_editorial_112, t93.loan_buyout_advertisement AS loan_buyout_advertisement_113, t93.loan_buyout_photoshoot AS loan_buyout_photoshoot_114, t93.loan_buyout_red_carpet AS loan_buyout_red_carpet_115, t93.loan_buyout_other AS loan_buyout_other_116, t93.loan_buyout_price_percent AS loan_buyout_price_percent_117, t93.return_insurance AS return_insurance_118, t93.policy_insurance AS policy_insurance_119, t93.reasonable_wear_and_tear AS reasonable_wear_and_tear_120, t93.late_fee_type AS late_fee_type_121, t93.late_fee_amount AS late_fee_amount_122, t93.late_fee_percent AS late_fee_percent_123, t93.late_fee_period AS late_fee_period_124, t93.security_hold AS security_hold_125, t93.security_hold_percent AS security_hold_percent_126, t93.quantity_update AS quantity_update_127, t93.brand_id AS brand_id_128, t129.id AS id_130, t129.rental AS rental_131, t129.rental_fee_type AS rental_fee_type_132, t129.rental_fee_amount AS rental_fee_amount_133, t129.rental_price_percent AS rental_price_percent_134, t129.rental_period AS rental_period_135, t129.rental_show AS rental_show_136, t129.rental_film AS rental_film_137, t129.rental_music_video AS rental_music_video_138, t129.rental_music_artist AS rental_music_artist_139, t129.rental_talent AS rental_talent_140, t129.rental_editorial AS rental_editorial_141, t129.rental_advertisement AS rental_advertisement_142, t129.rental_photoshoot AS rental_photoshoot_143, t129.rental_red_carpet AS rental_red_carpet_144, t129.rental_other AS rental_other_145, t129.rental_buyout AS rental_buyout_146, t129.rental_buyout_show AS rental_buyout_show_147, t129.rental_buyout_film AS rental_buyout_film_148, t129.rental_buyout_music_video AS rental_buyout_music_video_149, t129.rental_buyout_music_artist AS rental_buyout_music_artist_150, t129.rental_buyout_talent AS rental_buyout_talent_151, t129.rental_buyout_editorial AS rental_buyout_editorial_152, t129.rental_buyout_advertisement AS rental_buyout_advertisement_153, t129.rental_buyout_photoshoot AS rental_buyout_photoshoot_154, t129.rental_buyout_red_carpet AS rental_buyout_red_carpet_155, t129.rental_buyout_other AS rental_buyout_other_156, t129.rental_buyout_price_percent AS rental_buyout_price_percent_157, t129.return_insurance AS return_insurance_158, t129.policy_insurance AS policy_insurance_159, t129.reasonable_wear_and_tear AS reasonable_wear_and_tear_160, t129.late_fee_type AS late_fee_type_161, t129.late_fee_amount AS late_fee_amount_162, t129.late_fee_percent AS late_fee_percent_163, t129.late_fee_period AS late_fee_period_164, t129.security_hold AS security_hold_165, t129.security_hold_percent AS security_hold_percent_166, t129.quantity_update AS quantity_update_167, t129.brand_id AS brand_id_168, t169.id AS id_170, t169.purchase AS purchase_171, t169.purchase_price_percent AS purchase_price_percent_172, t169.purchase_show AS purchase_show_173, t169.purchase_film AS purchase_film_174, t169.purchase_music_video AS purchase_music_video_175, t169.purchase_music_artist AS purchase_music_artist_176, t169.purchase_talent AS purchase_talent_177, t169.purchase_editorial AS purchase_editorial_178, t169.purchase_advertisement AS purchase_advertisement_179, t169.purchase_photoshoot AS purchase_photoshoot_180, t169.purchase_red_carpet AS purchase_red_carpet_181, t169.purchase_other AS purchase_other_182, t169.reserve_purchase AS reserve_purchase_183, t169.reserve_purchase_price_percent AS reserve_purchase_price_percent_184, t169.reserve_purchase_show AS reserve_purchase_show_185, t169.reserve_purchase_film AS reserve_purchase_film_186, t169.reserve_purchase_music_video AS reserve_purchase_music_video_187, t169.reserve_purchase_music_artist AS reserve_purchase_music_artist_188, t169.reserve_purchase_talent AS reserve_purchase_talent_189, t169.reserve_purchase_editorial AS reserve_purchase_editorial_190, t169.reserve_purchase_advertisement AS reserve_purchase_advertisement_191, t169.reserve_purchase_photoshoot AS reserve_purchase_photoshoot_192, t169.reserve_purchase_red_carpet AS reserve_purchase_red_carpet_193, t169.reserve_purchase_other AS reserve_purchase_other_194, t169.return_policy AS return_policy_195, t169.care AS care_196, t169.quantity_update AS quantity_update_197, t169.brand_id AS brand_id_198, t199.id AS id_200, t199.custom_commission AS custom_commission_201, t199.custom_commission_show AS custom_commission_show_202, t199.custom_commission_film AS custom_commission_film_203, t199.custom_commission_music_video AS custom_commission_music_video_204, t199.custom_commission_music_artist AS custom_commission_music_artist_205, t199.custom_commission_talent AS custom_commission_talent_206, t199.custom_commission_editorial AS custom_commission_editorial_207, t199.custom_commission_advertisement AS custom_commission_advertisement_208, t199.brand_id AS brand_id_209, t210.id AS id_211, t210.in_person AS in_person_212, t210.industry_discount AS industry_discount_213, t210.industry_discount_price_percent AS industry_discount_price_percent_214, t210.return_policy AS return_policy_215, t210.care AS care_216, t210.online_shopping AS online_shopping_217, t210.shipping_policy AS shipping_policy_218, t210.quantity_update AS quantity_update_219, t210.brand_id AS brand_id_220, t221.id AS id_222, t221.discovery AS discovery_223, t221.discovery_show AS discovery_show_224, t221.discovery_film AS discovery_film_225, t221.discovery_music_video AS discovery_music_video_226, t221.discovery_music_artist AS discovery_music_artist_227, t221.discovery_talent AS discovery_talent_228, t221.discovery_editorial AS discovery_editorial_229, t221.discovery_advertisement AS discovery_advertisement_230, t221.shipping_policy AS shipping_policy_231, t221.return_policy AS return_policy_232, t221.care AS care_233, t221.quantity_update AS quantity_update_234, t221.brand_id AS brand_id_235, t0.service_fee_currency AS service_fee_currency_236, t0.province_id AS province_id_237, t238.has_network_dashboard AS has_network_dashboard_239, t238.has_network_email AS has_network_email_240, t238.has_show_dashboard AS has_show_dashboard_241, t238.has_show_email AS has_show_email_242, t238.has_studio_dashboard AS has_studio_dashboard_243, t238.has_studio_email AS has_studio_email_244, t238.has_film_dashboard AS has_film_dashboard_245, t238.has_film_email AS has_film_email_246, t238.has_record_label_dashboard AS has_record_label_dashboard_247, t238.has_record_label_email AS has_record_label_email_248, t238.has_music_video_dashboard AS has_music_video_dashboard_249, t238.has_music_video_email AS has_music_video_email_250, t238.has_talent_dashboard AS has_talent_dashboard_251, t238.has_talent_email AS has_talent_email_252, t238.has_editorial_dashboard AS has_editorial_dashboard_253, t238.has_editorial_email AS has_editorial_email_254, t238.id AS id_255, t238.brand_id AS brand_id_256 FROM brand t0 LEFT JOIN brand_settings_loan t93 ON t93.brand_id = t0.id LEFT JOIN brand_settings_rental t129 ON t129.brand_id = t0.id LEFT JOIN brand_settings_purchase t169 ON t169.brand_id = t0.id LEFT JOIN brand_settings_custom_commission t199 ON t199.brand_id = t0.id LEFT JOIN brand_settings_in_person t210 ON t210.brand_id = t0.id LEFT JOIN brand_settings_discovery t221 ON t221.brand_id = t0.id LEFT JOIN brand_notify_new_added_productions t238 ON t238.brand_id = t0.id WHERE t0.id = ?
Parameters:
[
379
]
|
||||||||||||||||||||||||||
|
1.28 ms (30.30%) |
1 |
"COMMIT"
Parameters:
[] |
||||||||||||||||||||||||||
|
1.24 ms (29.19%) |
1 |
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/7435107172435\";s:9:\"body_html\";s:108:\"Mid-rise 13.25 oz Japanese denim with an easy, straight fit through the hip, tapered at the leg. Button fly.\";s:10:\"created_at\";s:25:\"2024-09-03T10:20:14-07:00\";s:6:\"handle\";s:38:\"b007-japanese-denim-ford-standard-jean\";s:2:\"id\";i:7435107172435;s:12:\"product_type\";s:5:\"Jeans\";s:12:\"published_at\";s:25:\"2024-09-03T10:00:30-07:00\";s:15:\"template_suffix\";N;s:5:\"title\";s:38:\"B007 Japanese Denim Ford Standard Jean\";s:10:\"updated_at\";s:25:\"2026-02-18T17:19:57-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:245:\"callout--complimentaryhem, callout--japanesedenim, callout--newarrival, category--jeans, color--b007, color-group--blacks, filter-gender:men, gender--m, product-line--japanese-denim-ford-standard-jean, product-type--bottoms, style--ford-standard\";s:8:\"variants\";a:12:{i:0;a:21:{s:20:\"admin_graphql_api_id\";s:43:\"gid://shopify/ProductVariant/42146603728979\";s:7:\"barcode\";N;s:16:\"compare_at_price\";N;s:10:\"created_at\";s:25:\"2024-09-03T10:20:14-07:00\";s:2:\"id\";i:42146603728979;s:16:\"inventory_policy\";s:4:\"deny\";s:8:\"position\";i:1;s:5:\"price\";s:6:\"198.00\";s:10:\"product_id\";i:7435107172435;s:3:\"sku\";s:18:\"BM12125.1011B00728\";s:7:\"taxable\";b:1;s:5:\"title\";s:2:\"28\";s:10:\"updated_at\";s:25:\"2026-02-18T11:13:39-08:00\";s:7:\"option1\";s:2:\"28\";s:7:\"option2\";N;s:7:\"option3\";N;s:8:\"image_id\";N;s:17:\"inventory_item_id\";i:44244107034707;s:18:\"inventory_quantity\";i:18;s:22:\"old_inventory_quantity\";i:18;s:8:\"tax_code\";s:8:\"PC040100\";}i:1;a:21:{s:20:\"admin_graphql_api_id\";s:43:\"gid://shopify/ProductVariant/42146603761747\";s:7:\"barcode\";N;s:16:\"compare_at_price\";N;s:10:\"created_at\";s:25:\"2024-09-03T10:20:14-07:00\";s:2:\"id\";i:42146603761747;s:16:\"inventory_policy\";s:4:\"deny\";s:8:\"position\";i:2;s:5:\"price\";s:6:\"198.00\";s:10:\"product_id\";i:7435107172435;s:3:\"sku\";s:18:\"BM12125.1011B00729\";s:7:\"taxable\";b:1;s:5:\"title\";s:2:\"29\";s:10:\"updated_at\";s:25:\"2026-02-18T12:06:09-08:00\";s:7:\"option1\";s:2:\"29\";s:7:\"option2\";N;s:7:\"option3\";N;s:8:\"image_id\";N;s:17:\"inventory_item_id\";i:44244107067475;s:18:\"inventory_quantity\";i:30;s:22:\"old_inventory_quantity\";i:30;s:8:\"tax_code\";s:8:\"PC040100\";}i:2;a:21:{s:20:\"admin_graphql_api_id\";s:43:\"gid://shopify/ProductVariant/42146603794515\";s:7:\"barcode\";N;s:16:\"compare_at_price\";N;s:10:\"created_at\";s:25:\"2024-09-03T10:20:14-07:00\";s:2:\"id\";i:42146603794515;s:16:\"inventory_policy\";s:4:\"deny\";s:8:\"position\";i:3;s:5:\"price\";s:6:\"198.00\";s:10:\"product_id\";i:7435107172435;s:3:\"sku\";s:18:\"BM12125.1011B00730\";s:7:\"taxable\";b:1;s:5:\"title\";s:2:\"30\";s:10:\"updated_at\";s:25:\"2026-02-17T10:06:46-08:00\";s:7:\"option1\";s:2:\"30\";s:7:\"option2\";N;s:7:\"option3\";N;s:8:\"image_id\";N;s:17:\"inventory_item_id\";i:44244107100243;s:18:\"inventory_quantity\";i:5;s:22:\"old_inventory_quantity\";i:5;s:8:\"tax_code\";s:8:\"PC040100\";}i:3;a:21:{s:20:\"admin_graphql_api_id\";s:43:\"gid://shopify/ProductVariant/42146603827283\";s:7:\"barcode\";N;s:16:\"compare_at_price\";N;s:10:\"created_at\";s:25:\"2024-09-03T10:20:14-07:00\";s:2:\"id\";i:42146603827283;s:16:\"inventory_policy\";s:4:\"deny\";s:8:\"position\";i:4;s:5:\"price\";s:6:\"198.00\";s:10:\"product_id\";i:7435107172435;s:3:\"sku\";s:18:\"BM12125.1011B00731\";s:7:\"taxable\";b:1;s:5:\"title\";s:2:\"31\";s:10:\"updated_at\";s:25:\"2026-02-18T13:26:57-08:00\";s:7:\"option1\";s:2:\"31\";s:7:\"option2\";N;s:7:\"option3\";N;s:8:\"image_id\";N;s:17:\"inventory_item_id\";i:44244107133011;s:18:\"inventory_quantity\";i:74;s:22:\"old_inventory_quantity\";i:74;s:8:\"tax_code\";s:8:\"PC040100\";}i:4;a:21:{s:20:\"admin_graphql_api_id\";s:43:\"gid://shopify/ProductVariant/42146603860051\";s:7:\"barcode\";N;s:16:\"compare_at_price\";N;s:10:\"created_at\";s:25:\"2024-09-03T10:20:14-07:00\";s:2:\"id\";i:42146603860051;s:16:\"inventory_policy\";s:4:\"deny\";s:8:\"position\";i:5;s:5:\"price\";s:6:\"198.00\";s:10:\"product_id\";i:7435107172435;s:3:\"sku\";s:18:\"BM12125.1011B00732\";s:7:\"taxable\";b:1;s:5:\"title\";s:2:\"32\";s:10:\"updated_at\";s:25:\"2026-02-18T16:16:38-08:00\";s:7:\"option1\";s:2:\"32\";s:7:\"option2\";N;s:7:\"option3\";N;s:8:\"image_id\";N;s:17:\"inventory_item_id\";i:44244107165779;s:18:\"inventory_quantity\";i:175;s:22:\"old_inventory_quantity\";i:175;s:8:\"tax_code\";s:8:\"PC040100\";}i:5;a:21:{s:20:\"admin_graphql_api_id\";s:43:\"gid://shopify/ProductVariant/42146603892819\";s:7:\"barcode\";N;s:16:\"compare_at_price\";N;s:10:\"created_at\";s:25:\"2024-09-03T10:20:14-07:00\";s:2:\"id\";i:42146603892819;s:16:\"inventory_policy\";s:4:\"deny\";s:8:\"position\";i:6;s:5:\"price\";s:6:\"198.00\";s:10:\"product_id\";i:7435107172435;s:3:\"sku\";s:18:\"BM12125.1011B00733\";s:7:\"taxable\";b:1;s:5:\"title\";s:2:\"33\";s:10:\"updated_at\";s:25:\"2026-02-18T17:19:58-08:00\";s:7:\"option1\";s:2:\"33\";s:7:\"option2\";N;s:7:\"option3\";N;s:8:\"image_id\";N;s:17:\"inventory_item_id\";i:44244107198547;s:18:\"inventory_quantity\";i:150;s:22:\"old_inventory_quantity\";i:150;s:8:\"tax_code\";s:8:\"PC040100\";}i:6;a:21:{s:20:\"admin_graphql_api_id\";s:43:\"gid://shopify/ProductVariant/42146603925587\";s:7:\"barcode\";N;s:16:\"compare_at_price\";N;s:10:\"created_at\";s:25:\"2024-09-03T10:20:14-07:00\";s:2:\"id\";i:42146603925587;s:16:\"inventory_policy\";s:4:\"deny\";s:8:\"position\";i:7;s:5:\"price\";s:6:\"198.00\";s:10:\"product_id\";i:7435107172435;s:3:\"sku\";s:18:\"BM12125.1011B00734\";s:7:\"taxable\";b:1;s:5:\"title\";s:2:\"34\";s:10:\"updated_at\";s:25:\"2026-02-18T15:04:22-08:00\";s:7:\"option1\";s:2:\"34\";s:7:\"option2\";N;s:7:\"option3\";N;s:8:\"image_id\";N;s:17:\"inventory_item_id\";i:44244107231315;s:18:\"inventory_quantity\";i:94;s:22:\"old_inventory_quantity\";i:94;s:8:\"tax_code\";s:8:\"PC040100\";}i:7;a:21:{s:20:\"admin_graphql_api_id\";s:43:\"gid://shopify/ProductVariant/42599350206547\";s:7:\"barcode\";N;s:16:\"compare_at_price\";N;s:10:\"created_at\";s:25:\"2025-03-31T10:02:09-07:00\";s:2:\"id\";i:42599350206547;s:16:\"inventory_policy\";s:4:\"deny\";s:8:\"position\";i:8;s:5:\"price\";s:6:\"198.00\";s:10:\"product_id\";i:7435107172435;s:3:\"sku\";s:18:\"BM12125.1011B00735\";s:7:\"taxable\";b:1;s:5:\"title\";s:2:\"35\";s:10:\"updated_at\";s:25:\"2026-02-17T10:06:58-08:00\";s:7:\"option1\";s:2:\"35\";s:7:\"option2\";N;s:7:\"option3\";N;s:8:\"image_id\";N;s:17:\"inventory_item_id\";i:44697131548755;s:18:\"inventory_quantity\";i:0;s:22:\"old_inventory_quantity\";i:0;s:8:\"tax_code\";s:8:\"PC040100\";}i:8;a:21:{s:20:\"admin_graphql_api_id\";s:43:\"gid://shopify/ProductVariant/42146603958355\";s:7:\"barcode\";N;s:16:\"compare_at_price\";N;s:10:\"created_at\";s:25:\"2024-09-03T10:20:14-07:00\";s:2:\"id\";i:42146603958355;s:16:\"inventory_policy\";s:4:\"deny\";s:8:\"position\";i:9;s:5:\"price\";s:6:\"198.00\";s:10:\"product_id\";i:7435107172435;s:3:\"sku\";s:18:\"BM12125.1011B00736\";s:7:\"taxable\";b:1;s:5:\"title\";s:2:\"36\";s:10:\"updated_at\";s:25:\"2026-02-18T15:04:22-08:00\";s:7:\"option1\";s:2:\"36\";s:7:\"option2\";N;s:7:\"option3\";N;s:8:\"image_id\";N;s:17:\"inventory_item_id\";i:44244107264083;s:18:\"inventory_quantity\";i:118;s:22:\"old_inventory_quantity\";i:118;s:8:\"tax_code\";s:8:\"PC040100\";}i:9;a:21:{s:20:\"admin_graphql_api_id\";s:43:\"gid://shopify/ProductVariant/42599350239315\";s:7:\"barcode\";N;s:16:\"compare_at_price\";N;s:10:\"created_at\";s:25:\"2025-03-31T10:02:09-07:00\";s:2:\"id\";i:42599350239315;s:16:\"inventory_policy\";s:4:\"deny\";s:8:\"position\";i:10;s:5:\"price\";s:6:\"198.00\";s:10:\"product_id\";i:7435107172435;s:3:\"sku\";s:18:\"BM12125.1011B00737\";s:7:\"taxable\";b:1;s:5:\"title\";s:2:\"37\";s:10:\"updated_at\";s:25:\"2026-02-17T10:07:02-08:00\";s:7:\"option1\";s:2:\"37\";s:7:\"option2\";N;s:7:\"option3\";N;s:8:\"image_id\";N;s:17:\"inventory_item_id\";i:44697131581523;s:18:\"inventory_quantity\";i:0;s:22:\"old_inventory_quantity\";i:0;s:8:\"tax_code\";s:8:\"PC040100\";}i:10;a:21:{s:20:\"admin_graphql_api_id\";s:43:\"gid://shopify/ProductVariant/42146603991123\";s:7:\"barcode\";N;s:16:\"compare_at_price\";N;s:10:\"created_at\";s:25:\"2024-09-03T10:20:14-07:00\";s:2:\"id\";i:42146603991123;s:16:\"inventory_policy\";s:4:\"deny\";s:8:\"position\";i:11;s:5:\"price\";s:6:\"198.00\";s:10:\"product_id\";i:7435107172435;s:3:\"sku\";s:18:\"BM12125.1011B00738\";s:7:\"taxable\";b:1;s:5:\"title\";s:2:\"38\";s:10:\"updated_at\";s:25:\"2026-02-17T12:17:26-08:00\";s:7:\"option1\";s:2:\"38\";s:7:\"option2\";N;s:7:\"option3\";N;s:8:\"image_id\";N;s:17:\"inventory_item_id\";i:44244107296851;s:18:\"inventory_quantity\";i:28;s:22:\"old_inventory_quantity\";i:28;s:8:\"tax_code\";s:8:\"PC040100\";}i:11;a:21:{s:20:\"admin_graphql_api_id\";s:43:\"gid://shopify/ProductVariant/42571151704147\";s:7:\"barcode\";N;s:16:\"compare_at_price\";N;s:10:\"created_at\";s:25:\"2025-03-14T11:12:49-07:00\";s:2:\"id\";i:42571151704147;s:16:\"inventory_policy\";s:4:\"deny\";s:8:\"position\";i:12;s:5:\"price\";s:6:\"198.00\";s:10:\"product_id\";i:7435107172435;s:3:\"sku\";s:18:\"BM12125.1011B00740\";s:7:\"taxable\";b:1;s:5:\"title\";s:2:\"40\";s:10:\"updated_at\";s:25:\"2026-02-17T10:07:07-08:00\";s:7:\"option1\";s:2:\"40\";s:7:\"option2\";N;s:7:\"option3\";N;s:8:\"image_id\";N;s:17:\"inventory_item_id\";i:44668888907859;s:18:\"inventory_quantity\";i:0;s:22:\"old_inventory_quantity\";i:0;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:9536547225683;s:10:\"product_id\";i:7435107172435;s:8:\"position\";i:1;s:6:\"values\";a:12:{i:0;s:2:\"28\";i:1;s:2:\"29\";i:2;s:2:\"30\";i:3;s:2:\"31\";i:4;s:2:\"32\";i:5;s:2:\"33\";i:6;s:2:\"34\";i:7;s:2:\"35\";i:8;s:2:\"36\";i:9;s:2:\"37\";i:10;s:2:\"38\";i:11;s:2:\"40\";}}}s:6:\"images\";a:6:{i:0;a:11:{s:2:\"id\";i:35700377354323;s:10:\"product_id\";i:7435107172435;s:8:\"position\";i:1;s:10:\"created_at\";s:25:\"2024-09-03T10:22:45-07:00\";s:10:\"updated_at\";s:25:\"2024-09-03T10:22:56-07:00\";s:3:\"alt\";s:12:\"Product Flat\";s:5:\"width\";i:1800;s:6:\"height\";i:2400;s:3:\"src\";s:112:\"https://cdn.shopify.com/s/files/1/0123/5065/2473/files/BM12125.1011B007_Ford-Standard-Jean_B007.jpg?v=1725384167\";s:11:\"variant_ids\";a:0:{}s:20:\"admin_graphql_api_id\";s:41:\"gid://shopify/ProductImage/35700377354323\";}i:1;a:11:{s:2:\"id\";i:39561432072275;s:10:\"product_id\";i:7435107172435;s:8:\"position\";i:2;s:10:\"created_at\";s:25:\"2025-09-09T18:35:20-07:00\";s:10:\"updated_at\";s:25:\"2025-09-09T18:36:16-07:00\";s:3:\"alt\";s:59:\"Man wearing a black sweater and pants on a beige background\";s:5:\"width\";i:1800;s:6:\"height\";i:2400;s:3:\"src\";s:128:\"https://cdn.shopify.com/s/files/1/0123/5065/2473/files/BM12125.1011_JAPANESE-DENIM-FORD-STANDARD-JEAN_B007_1675.jpg?v=1757468122\";s:11:\"variant_ids\";a:0:{}s:20:\"admin_graphql_api_id\";s:41:\"gid://shopify/ProductImage/39561432072275\";}i:2;a:11:{s:2:\"id\";i:39561432105043;s:10:\"product_id\";i:7435107172435;s:8:\"position\";i:3;s:10:\"created_at\";s:25:\"2025-09-09T18:35:20-07:00\";s:10:\"updated_at\";s:25:\"2025-09-09T18:36:16-07:00\";s:3:\"alt\";s:58:\"Person wearing black pants and shoes on a beige background\";s:5:\"width\";i:1800;s:6:\"height\";i:2400;s:3:\"src\";s:131:\"https://cdn.shopify.com/s/files/1/0123/5065/2473/files/BM12125.1011_JAPANESE-DENIM-FORD-STANDARD-JEAN_B007_1687_R2.jpg?v=1757468122\";s:11:\"variant_ids\";a:0:{}s:20:\"admin_graphql_api_id\";s:41:\"gid://shopify/ProductImage/39561432105043\";}i:3;a:11:{s:2:\"id\";i:39561432137811;s:10:\"product_id\";i:7435107172435;s:8:\"position\";i:4;s:10:\"created_at\";s:25:\"2025-09-09T18:35:20-07:00\";s:10:\"updated_at\";s:25:\"2025-09-09T18:36:16-07:00\";s:3:\"alt\";s:68:\"Person wearing a black sweater and black pants on a beige background\";s:5:\"width\";i:1800;s:6:\"height\";i:2400;s:3:\"src\";s:131:\"https://cdn.shopify.com/s/files/1/0123/5065/2473/files/BM12125.1011_JAPANESE-DENIM-FORD-STANDARD-JEAN_B007_1699_R2.jpg?v=1757468122\";s:11:\"variant_ids\";a:0:{}s:20:\"admin_graphql_api_id\";s:41:\"gid://shopify/ProductImage/39561432137811\";}i:4;a:11:{s:2:\"id\";i:39561432203347;s:10:\"product_id\";i:7435107172435;s:8:\"position\";i:5;s:10:\"created_at\";s:25:\"2025-09-09T18:35:20-07:00\";s:10:\"updated_at\";s:25:\"2025-09-09T18:36:16-07:00\";s:3:\"alt\";s:48:\"Person wearing black pants on a plain background\";s:5:\"width\";i:1800;s:6:\"height\";i:2400;s:3:\"src\";s:131:\"https://cdn.shopify.com/s/files/1/0123/5065/2473/files/BM12125.1011_JAPANESE-DENIM-FORD-STANDARD-JEAN_B007_1715_R2.jpg?v=1757468176\";s:11:\"variant_ids\";a:0:{}s:20:\"admin_graphql_api_id\";s:41:\"gid://shopify/ProductImage/39561432203347\";}i:5;a:11:{s:2:\"id\";i:39561432170579;s:10:\"product_id\";i:7435107172435;s:8:\"position\";i:6;s:10:\"created_at\";s:25:\"2025-09-09T18:35:20-07:00\";s:10:\"updated_at\";s:25:\"2025-09-09T18:36:16-07:00\";s:3:\"alt\";N;s:5:\"width\";i:1800;s:6:\"height\";i:2400;s:3:\"src\";s:131:\"https://cdn.shopify.com/s/files/1/0123/5065/2473/files/BM12125.1011_JAPANESE-DENIM-FORD-STANDARD-JEAN_B007_1711_R2.jpg?v=1757468176\";s:11:\"variant_ids\";a:0:{}s:20:\"admin_graphql_api_id\";s:41:\"gid://shopify/ProductImage/39561432170579\";}}s:5:\"image\";a:11:{s:2:\"id\";i:35700377354323;s:10:\"product_id\";i:7435107172435;s:8:\"position\";i:1;s:10:\"created_at\";s:25:\"2024-09-03T10:22:45-07:00\";s:10:\"updated_at\";s:25:\"2024-09-03T10:22:56-07:00\";s:3:\"alt\";s:12:\"Product Flat\";s:5:\"width\";i:1800;s:6:\"height\";i:2400;s:3:\"src\";s:112:\"https://cdn.shopify.com/s/files/1/0123/5065/2473/files/BM12125.1011B007_Ford-Standard-Jean_B007.jpg?v=1725384167\";s:11:\"variant_ids\";a:0:{}s:20:\"admin_graphql_api_id\";s:41:\"gid://shopify/ProductImage/35700377354323\";}s:5:\"media\";a:6:{i:0;a:11:{s:2:\"id\";i:28089969180755;s:10:\"product_id\";i:7435107172435;s:8:\"position\";i:1;s:10:\"created_at\";s:25:\"2024-09-03T10:22:45-07:00\";s:10:\"updated_at\";s:25:\"2024-09-03T10:22:56-07: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:112:\"https://cdn.shopify.com/s/files/1/0123/5065/2473/files/BM12125.1011B007_Ford-Standard-Jean_B007.jpg?v=1725384167\";s:6:\"status\";s:5:\"READY\";}s:11:\"variant_ids\";a:0:{}s:20:\"admin_graphql_api_id\";s:39:\"gid://shopify/MediaImage/28089969180755\";}i:1;a:11:{s:2:\"id\";i:30956621660243;s:10:\"product_id\";i:7435107172435;s:8:\"position\";i:2;s:10:\"created_at\";s:25:\"2025-09-09T18:35:20-07:00\";s:10:\"updated_at\";s:25:\"2025-09-09T18:36:16-07:00\";s:3:\"alt\";s:59:\"Man wearing a black sweater and pants on a beige background\";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:128:\"https://cdn.shopify.com/s/files/1/0123/5065/2473/files/BM12125.1011_JAPANESE-DENIM-FORD-STANDARD-JEAN_B007_1675.jpg?v=1757468122\";s:6:\"status\";s:5:\"READY\";}s:11:\"variant_ids\";a:0:{}s:20:\"admin_graphql_api_id\";s:39:\"gid://shopify/MediaImage/30956621660243\";}i:2;a:11:{s:2:\"id\";i:30956621693011;s:10:\"product_id\";i:7435107172435;s:8:\"position\";i:3;s:10:\"created_at\";s:25:\"2025-09-09T18:35:20-07:00\";s:10:\"updated_at\";s:25:\"2025-09-09T18:36:16-07:00\";s:3:\"alt\";s:58:\"Person wearing black pants and shoes on a beige background\";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:131:\"https://cdn.shopify.com/s/files/1/0123/5065/2473/files/BM12125.1011_JAPANESE-DENIM-FORD-STANDARD-JEAN_B007_1687_R2.jpg?v=1757468122\";s:6:\"status\";s:5:\"READY\";}s:11:\"variant_ids\";a:0:{}s:20:\"admin_graphql_api_id\";s:39:\"gid://shopify/MediaImage/30956621693011\";}i:3;a:11:{s:2:\"id\";i:30956621725779;s:10:\"product_id\";i:7435107172435;s:8:\"position\";i:4;s:10:\"created_at\";s:25:\"2025-09-09T18:35:20-07:00\";s:10:\"updated_at\";s:25:\"2025-09-09T18:36:16-07:00\";s:3:\"alt\";s:68:\"Person wearing a black sweater and black pants on a beige background\";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:131:\"https://cdn.shopify.com/s/files/1/0123/5065/2473/files/BM12125.1011_JAPANESE-DENIM-FORD-STANDARD-JEAN_B007_1699_R2.jpg?v=1757468122\";s:6:\"status\";s:5:\"READY\";}s:11:\"variant_ids\";a:0:{}s:20:\"admin_graphql_api_id\";s:39:\"gid://shopify/MediaImage/30956621725779\";}i:4;a:11:{s:2:\"id\";i:30956621791315;s:10:\"product_id\";i:7435107172435;s:8:\"position\";i:5;s:10:\"created_at\";s:25:\"2025-09-09T18:35:20-07:00\";s:10:\"updated_at\";s:25:\"2025-09-09T18:36:16-07:00\";s:3:\"alt\";s:48:\"Person wearing black pants on a plain background\";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:131:\"https://cdn.shopify.com/s/files/1/0123/5065/2473/files/BM12125.1011_JAPANESE-DENIM-FORD-STANDARD-JEAN_B007_1715_R2.jpg?v=1757468176\";s:6:\"status\";s:5:\"READY\";}s:11:\"variant_ids\";a:0:{}s:20:\"admin_graphql_api_id\";s:39:\"gid://shopify/MediaImage/30956621791315\";}i:5;a:11:{s:2:\"id\";i:30956621758547;s:10:\"product_id\";i:7435107172435;s:8:\"position\";i:6;s:10:\"created_at\";s:25:\"2025-09-09T18:35:20-07:00\";s:10:\"updated_at\";s:25:\"2025-09-09T18:36:16-07:00\";s:3:\"alt\";N;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:131:\"https://cdn.shopify.com/s/files/1/0123/5065/2473/files/BM12125.1011_JAPANESE-DENIM-FORD-STANDARD-JEAN_B007_1711_R2.jpg?v=1757468176\";s:6:\"status\";s:5:\"READY\";}s:11:\"variant_ids\";a:0:{}s:20:\"admin_graphql_api_id\";s:39:\"gid://shopify/MediaImage/30956621758547\";}}s:12:\"variant_gids\";a:12:{i:0;a:2:{s:20:\"admin_graphql_api_id\";s:43:\"gid://shopify/ProductVariant/42146603892819\";s:10:\"updated_at\";s:24:\"2026-02-19T01:19:58.000Z\";}i:1;a:2:{s:20:\"admin_graphql_api_id\";s:43:\"gid://shopify/ProductVariant/42146603860051\";s:10:\"updated_at\";s:24:\"2026-02-19T00:16:38.000Z\";}i:2;a:2:{s:20:\"admin_graphql_api_id\";s:43:\"gid://shopify/ProductVariant/42146603925587\";s:10:\"updated_at\";s:24:\"2026-02-18T23:04:22.000Z\";}i:3;a:2:{s:20:\"admin_graphql_api_id\";s:43:\"gid://shopify/ProductVariant/42146603958355\";s:10:\"updated_at\";s:24:\"2026-02-18T23:04:22.000Z\";}i:4;a:2:{s:20:\"admin_graphql_api_id\";s:43:\"gid://shopify/ProductVariant/42146603827283\";s:10:\"updated_at\";s:24:\"2026-02-18T21:26:57.000Z\";}i:5;a:2:{s:20:\"admin_graphql_api_id\";s:43:\"gid://shopify/ProductVariant/42146603761747\";s:10:\"updated_at\";s:24:\"2026-02-18T20:06:09.000Z\";}i:6;a:2:{s:20:\"admin_graphql_api_id\";s:43:\"gid://shopify/ProductVariant/42146603728979\";s:10:\"updated_at\";s:24:\"2026-02-18T19:13:39.000Z\";}i:7;a:2:{s:20:\"admin_graphql_api_id\";s:43:\"gid://shopify/ProductVariant/42146603991123\";s:10:\"updated_at\";s:24:\"2026-02-17T20:17:26.000Z\";}i:8;a:2:{s:20:\"admin_graphql_api_id\";s:43:\"gid://shopify/ProductVariant/42571151704147\";s:10:\"updated_at\";s:24:\"2026-02-17T18:07:07.000Z\";}i:9;a:2:{s:20:\"admin_graphql_api_id\";s:43:\"gid://shopify/ProductVariant/42599350239315\";s:10:\"updated_at\";s:24:\"2026-02-17T18:07:02.000Z\";}i:10;a:2:{s:20:\"admin_graphql_api_id\";s:43:\"gid://shopify/ProductVariant/42599350206547\";s:10:\"updated_at\";s:24:\"2026-02-17T18:06:58.000Z\";}i:11;a:2:{s:20:\"admin_graphql_api_id\";s:43:\"gid://shopify/ProductVariant/42146603794515\";s:10:\"updated_at\";s:24:\"2026-02-17T18:06:46.000Z\";}}s:37:\"has_variants_that_requires_components\";b:0;s:8:\"category\";a:3:{s:20:\"admin_graphql_api_id\";s:33:\"gid://shopify/TaxonomyCategory/na\";s:4:\"name\";s:13:\"Uncategorized\";s:9:\"full_name\";s:13:\"Uncategorized\";}}}}}" "[]" "default" "2026-02-19 01:20:00" "2026-02-19 01:20:00" ] |
||||||||||||||||||||||||||
|
0.17 ms (3.94%) |
1 |
"START TRANSACTION"
Parameters:
[] |
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 |
|
| Mirinly\AdminBundle\Entity\Currency | No errors. |
| Mirinly\AdminBundle\Entity\ImageToBrand |
|
| Mirinly\AdminBundle\Entity\ECommerceItemType |
|
| Mirinly\AdminBundle\Entity\ECommerceSubcategory |
|
| 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 |
|
| Mirinly\AdminBundle\Entity\BrandTrend | No errors. |
| Mirinly\AdminBundle\Entity\Country | No errors. |
| Mirinly\AdminBundle\Entity\ECommerceItem |
|
| Mirinly\AdminBundle\Entity\VariationSet | No errors. |
| Mirinly\AdminBundle\Entity\Film |
|
| Mirinly\AdminBundle\Entity\TvShow |
|
| Mirinly\AdminBundle\Entity\MusicVideo |
|
| Mirinly\AdminBundle\Entity\MusicArtist |
|
| Mirinly\AdminBundle\Entity\Network |
|
| Mirinly\AdminBundle\Entity\Studio |
|
| Mirinly\AdminBundle\Entity\RecordLabel |
|
| Mirinly\AdminBundle\Entity\Editorial |
|
| 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. |