1
0.32 ms
SELECT t0 . id AS id_1 , t0 . email AS email_2 , t0 . username AS username_3 , t0 . password AS password_4 , t0 . roles AS roles_5 , t0 . enabled AS enabled_6 , t0 . locked AS locked_7 , t0 . expired AS expired_8 , t0 . credentials_expired AS credentials_expired_9 , t0 . confirmation_token AS confirmation_token_10 , t0 . password_requested_at AS password_requested_at_11 , t0 . last_login AS last_login_12 , t0 . salt AS salt_13 , t0 . deleted AS deleted_14 , t0 . firstname AS firstname_15 , t0 . lastname AS lastname_16 , t0 . company AS company_17 , t0 . birthdate AS birthdate_18 , t0 . phone AS phone_19 , t0 . fax AS fax_20 , t0 . bad_credit AS bad_credit_21 , t0 . review_reminder AS review_reminder_22 , t0 . city AS city_23 , t0 . zipcode AS zipcode_24 , t0 . address AS address_25 , t0 . address2 AS address2_26 , t0 . house_number AS house_number_27 , t0 . gender AS gender_28 , t0 . marital_status AS marital_status_29 , t0 . image AS image_30 , t0 . account_type AS account_type_31 , t0 . approval_status AS approval_status_32 , t0 . information AS information_33 , t0 . ip AS ip_34 , t0 . fields AS fields_35 , t0 . access_auth AS access_auth_36 , t0 . role_access AS role_access_37 , t0 . access_token AS access_token_38 , t0 . b2b_email_channel_setting AS b2b_email_channel_setting_39 , t0 . b2b_order_confirmation_email AS b2b_order_confirmation_email_40 , t0 . b2b_shipped_notification_email AS b2b_shipped_notification_email_41 , t0 . b2b_invoice_payment_advice_email AS b2b_invoice_payment_advice_email_42 , t0 . message AS message_43 , t0 . invoice_slip_ka AS invoice_slip_ka_44 , t0 . old_customer AS old_customer_45 , t0 . created_at AS created_at_46 , t0 . country_id AS country_id_47 FROM fos_user t0 WHERE t0 . id = ?
SELECT
t0 . id AS id_1 ,
t0 . email AS email_2 ,
t0 . username AS username_3 ,
t0 . password AS password_4 ,
t0 . roles AS roles_5 ,
t0 . enabled AS enabled_6 ,
t0 . locked AS locked_7 ,
t0 . expired AS expired_8 ,
t0 . credentials_expired AS credentials_expired_9 ,
t0 . confirmation_token AS confirmation_token_10 ,
t0 . password_requested_at AS password_requested_at_11 ,
t0 . last_login AS last_login_12 ,
t0 . salt AS salt_13 ,
t0 . deleted AS deleted_14 ,
t0 . firstname AS firstname_15 ,
t0 . lastname AS lastname_16 ,
t0 . company AS company_17 ,
t0 . birthdate AS birthdate_18 ,
t0 . phone AS phone_19 ,
t0 . fax AS fax_20 ,
t0 . bad_credit AS bad_credit_21 ,
t0 . review_reminder AS review_reminder_22 ,
t0 . city AS city_23 ,
t0 . zipcode AS zipcode_24 ,
t0 . address AS address_25 ,
t0 . address2 AS address2_26 ,
t0 . house_number AS house_number_27 ,
t0 . gender AS gender_28 ,
t0 . marital_status AS marital_status_29 ,
t0 . image AS image_30 ,
t0 . account_type AS account_type_31 ,
t0 . approval_status AS approval_status_32 ,
t0 . information AS information_33 ,
t0 . ip AS ip_34 ,
t0 . fields AS fields_35 ,
t0 . access_auth AS access_auth_36 ,
t0 . role_access AS role_access_37 ,
t0 . access_token AS access_token_38 ,
t0 . b2b_email_channel_setting AS b2b_email_channel_setting_39 ,
t0 . b2b_order_confirmation_email AS b2b_order_confirmation_email_40 ,
t0 . b2b_shipped_notification_email AS b2b_shipped_notification_email_41 ,
t0 . b2b_invoice_payment_advice_email AS b2b_invoice_payment_advice_email_42 ,
t0 . message AS message_43 ,
t0 . invoice_slip_ka AS invoice_slip_ka_44 ,
t0 . old_customer AS old_customer_45 ,
t0 . created_at AS created_at_46 ,
t0 . country_id AS country_id_47
FROM
fos_user t0
WHERE
t0 . id = ?
Copy
SELECT t0 . id AS id_1 , t0 . email AS email_2 , t0 . username AS username_3 , t0 . password AS password_4 , t0 . roles AS roles_5 , t0 . enabled AS enabled_6 , t0 . locked AS locked_7 , t0 . expired AS expired_8 , t0 . credentials_expired AS credentials_expired_9 , t0 . confirmation_token AS confirmation_token_10 , t0 . password_requested_at AS password_requested_at_11 , t0 . last_login AS last_login_12 , t0 . salt AS salt_13 , t0 . deleted AS deleted_14 , t0 . firstname AS firstname_15 , t0 . lastname AS lastname_16 , t0 . company AS company_17 , t0 . birthdate AS birthdate_18 , t0 . phone AS phone_19 , t0 . fax AS fax_20 , t0 . bad_credit AS bad_credit_21 , t0 . review_reminder AS review_reminder_22 , t0 . city AS city_23 , t0 . zipcode AS zipcode_24 , t0 . address AS address_25 , t0 . address2 AS address2_26 , t0 . house_number AS house_number_27 , t0 . gender AS gender_28 , t0 . marital_status AS marital_status_29 , t0 . image AS image_30 , t0 . account_type AS account_type_31 , t0 . approval_status AS approval_status_32 , t0 . information AS information_33 , t0 . ip AS ip_34 , t0 . fields AS fields_35 , t0 . access_auth AS access_auth_36 , t0 . role_access AS role_access_37 , t0 . access_token AS access_token_38 , t0 . b2b_email_channel_setting AS b2b_email_channel_setting_39 , t0 . b2b_order_confirmation_email AS b2b_order_confirmation_email_40 , t0 . b2b_shipped_notification_email AS b2b_shipped_notification_email_41 , t0 . b2b_invoice_payment_advice_email AS b2b_invoice_payment_advice_email_42 , t0 . message AS message_43 , t0 . invoice_slip_ka AS invoice_slip_ka_44 , t0 . old_customer AS old_customer_45 , t0 . created_at AS created_at_46 , t0 . country_id AS country_id_47 FROM fos_user t0 WHERE t0 . id = 9452 ;
Copy
2
0.17 ms
SELECT o0_ . time_line AS time_line_0 FROM order_timelines o0_ WHERE o0_ . name = ? LIMIT 1
Parameters :
[
"customer order submit time "
]
SELECT o0_ . time_line AS time_line_0 FROM order_timelines o0_ WHERE o0_ . name = 'customer order submit time' LIMIT 1 ;
Copy
3
0.15 ms
SELECT o0_ . time_line AS time_line_0 FROM order_timelines o0_ WHERE o0_ . name = ? LIMIT 1
Parameters :
[
"SameDay order submit timeline "
]
SELECT o0_ . time_line AS time_line_0 FROM order_timelines o0_ WHERE o0_ . name = 'SameDay order submit timeline' LIMIT 1 ;
Copy
4
0.13 ms
SELECT o0_ . time_line AS time_line_0 FROM order_timelines o0_ WHERE o0_ . name = ? LIMIT 1
Parameters :
[
"supplier order submit time "
]
SELECT o0_ . time_line AS time_line_0 FROM order_timelines o0_ WHERE o0_ . name = 'supplier order submit time' LIMIT 1 ;
Copy
5
0.15 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . alias AS alias_3 , t0 . status AS status_4 , t0 . sort_order AS sort_order_5 , t0 . is_default AS is_default_6 , t0 . is_b2c AS is_b2c_7 , t0 . is_b2b AS is_b2b_8 , t0 . created_at AS created_at_9 , t0 . updated_at AS updated_at_10 , t0 . courier_id AS courier_id_11 FROM shipping_method t0 WHERE t0 . is_default = ? AND t0 . status = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . alias AS alias_3 , t0 . status AS status_4 , t0 . sort_order AS sort_order_5 , t0 . is_default AS is_default_6 , t0 . is_b2c AS is_b2c_7 , t0 . is_b2b AS is_b2b_8 , t0 . created_at AS created_at_9 , t0 . updated_at AS updated_at_10 , t0 . courier_id AS courier_id_11 FROM shipping_method t0 WHERE t0 . is_default = 1 AND t0 . status = 1 LIMIT 1 ;
Copy
6
0.24 ms
SELECT c0_ . id AS id_0 , c0_ . holiday_type AS holiday_type_1 , DATE (c0_ . start_date ) AS sclr_2 , DATE (c0_ . end_date ) AS sclr_3 FROM company_calendar c0_ WHERE DATE (c0_ . start_date ) > = ? AND DATE (c0_ . start_date ) < = ? AND c0_ . start_date IS NOT NULL
Parameters :
[
"2026-10-21 "
"2026-12-20 "
]
SELECT c0_ . id AS id_0 , c0_ . holiday_type AS holiday_type_1 , DATE (c0_ . start_date ) AS sclr_2 , DATE (c0_ . end_date ) AS sclr_3 FROM company_calendar c0_ WHERE DATE (c0_ . start_date ) > = '2026-10-21' AND DATE (c0_ . start_date ) < = '2026-12-20' AND c0_ . start_date IS NOT NULL ;
Copy
7
0.36 ms
SELECT t0 . id AS id_1 , t0 . shipping_key AS shipping_key_2 , t0 . shipping_value AS shipping_value_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . shipping_method_id AS shipping_method_id_6 FROM shipping_method_settings t0
SELECT t0 . id AS id_1 , t0 . shipping_key AS shipping_key_2 , t0 . shipping_value AS shipping_value_3 , t0 . created_at AS created_at_4 , t0 . updated_at AS updated_at_5 , t0 . shipping_method_id AS shipping_method_id_6 FROM shipping_method_settings t0 ;
Copy
8
0.13 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . alias AS alias_3 , t0 . status AS status_4 , t0 . sort_order AS sort_order_5 , t0 . is_default AS is_default_6 , t0 . is_b2c AS is_b2c_7 , t0 . is_b2b AS is_b2b_8 , t0 . created_at AS created_at_9 , t0 . updated_at AS updated_at_10 , t0 . courier_id AS courier_id_11 FROM shipping_method t0 WHERE t0 . is_default = ? AND t0 . status = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . alias AS alias_3 , t0 . status AS status_4 , t0 . sort_order AS sort_order_5 , t0 . is_default AS is_default_6 , t0 . is_b2c AS is_b2c_7 , t0 . is_b2b AS is_b2b_8 , t0 . created_at AS created_at_9 , t0 . updated_at AS updated_at_10 , t0 . courier_id AS courier_id_11 FROM shipping_method t0 WHERE t0 . is_default = 1 AND t0 . status = 1 LIMIT 1 ;
Copy
9
0.16 ms
SELECT c0_ . id AS id_0 , c0_ . holiday_type AS holiday_type_1 , DATE (c0_ . start_date ) AS sclr_2 , DATE (c0_ . end_date ) AS sclr_3 FROM company_calendar c0_ WHERE DATE (c0_ . start_date ) > = ? AND DATE (c0_ . start_date ) < = ? AND c0_ . start_date IS NOT NULL
Parameters :
[
"2026-10-21 "
"2026-12-20 "
]
SELECT c0_ . id AS id_0 , c0_ . holiday_type AS holiday_type_1 , DATE (c0_ . start_date ) AS sclr_2 , DATE (c0_ . end_date ) AS sclr_3 FROM company_calendar c0_ WHERE DATE (c0_ . start_date ) > = '2026-10-21' AND DATE (c0_ . start_date ) < = '2026-12-20' AND c0_ . start_date IS NOT NULL ;
Copy
10
0.10 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . alias AS alias_3 , t0 . status AS status_4 , t0 . sort_order AS sort_order_5 , t0 . is_default AS is_default_6 , t0 . is_b2c AS is_b2c_7 , t0 . is_b2b AS is_b2b_8 , t0 . created_at AS created_at_9 , t0 . updated_at AS updated_at_10 , t0 . courier_id AS courier_id_11 FROM shipping_method t0 WHERE t0 . is_default = ? AND t0 . status = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . alias AS alias_3 , t0 . status AS status_4 , t0 . sort_order AS sort_order_5 , t0 . is_default AS is_default_6 , t0 . is_b2c AS is_b2c_7 , t0 . is_b2b AS is_b2b_8 , t0 . created_at AS created_at_9 , t0 . updated_at AS updated_at_10 , t0 . courier_id AS courier_id_11 FROM shipping_method t0 WHERE t0 . is_default = 1 AND t0 . status = 1 LIMIT 1 ;
Copy
11
0.11 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . alias AS alias_3 , t0 . status AS status_4 , t0 . sort AS sort_5 , t0 . image AS image_6 , t0 . is_default AS is_default_7 , t0 . barcode_username AS barcode_username_8 , t0 . barcode_password AS barcode_password_9 , t0 . barcode_franking_license AS barcode_franking_license_10 , t0 . sd_barcode_username AS sd_barcode_username_11 , t0 . sd_barcode_password AS sd_barcode_password_12 , t0 . sd_barcode_franking_license AS sd_barcode_franking_license_13 , t0 . created_at AS created_at_14 , t0 . updated_at AS updated_at_15 FROM courier t0 WHERE t0 . is_default = ? AND t0 . status = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . alias AS alias_3 , t0 . status AS status_4 , t0 . sort AS sort_5 , t0 . image AS image_6 , t0 . is_default AS is_default_7 , t0 . barcode_username AS barcode_username_8 , t0 . barcode_password AS barcode_password_9 , t0 . barcode_franking_license AS barcode_franking_license_10 , t0 . sd_barcode_username AS sd_barcode_username_11 , t0 . sd_barcode_password AS sd_barcode_password_12 , t0 . sd_barcode_franking_license AS sd_barcode_franking_license_13 , t0 . created_at AS created_at_14 , t0 . updated_at AS updated_at_15 FROM courier t0 WHERE t0 . is_default = 1 AND t0 . status = 1 LIMIT 1 ;
Copy
12
0.10 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . alias AS alias_3 , t0 . status AS status_4 , t0 . sort_order AS sort_order_5 , t0 . is_default AS is_default_6 , t0 . is_b2c AS is_b2c_7 , t0 . is_b2b AS is_b2b_8 , t0 . created_at AS created_at_9 , t0 . updated_at AS updated_at_10 , t0 . courier_id AS courier_id_11 FROM shipping_method t0 WHERE t0 . alias = ? AND t0 . status = ? AND t0 . is_b2c = ? LIMIT 1
Parameters :
[
"nt-sd-ev "
"1 "
"1 "
]
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . alias AS alias_3 , t0 . status AS status_4 , t0 . sort_order AS sort_order_5 , t0 . is_default AS is_default_6 , t0 . is_b2c AS is_b2c_7 , t0 . is_b2b AS is_b2b_8 , t0 . created_at AS created_at_9 , t0 . updated_at AS updated_at_10 , t0 . courier_id AS courier_id_11 FROM shipping_method t0 WHERE t0 . alias = 'nt-sd-ev' AND t0 . status = '1' AND t0 . is_b2c = '1' LIMIT 1 ;
Copy
13
0.09 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . alias AS alias_3 , t0 . status AS status_4 , t0 . sort_order AS sort_order_5 , t0 . is_default AS is_default_6 , t0 . is_b2c AS is_b2c_7 , t0 . is_b2b AS is_b2b_8 , t0 . created_at AS created_at_9 , t0 . updated_at AS updated_at_10 , t0 . courier_id AS courier_id_11 FROM shipping_method t0 WHERE t0 . alias = ? AND t0 . status = ? AND t0 . is_b2b = ? LIMIT 1
Parameters :
[
"nt-sd-ev "
"1 "
"1 "
]
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . alias AS alias_3 , t0 . status AS status_4 , t0 . sort_order AS sort_order_5 , t0 . is_default AS is_default_6 , t0 . is_b2c AS is_b2c_7 , t0 . is_b2b AS is_b2b_8 , t0 . created_at AS created_at_9 , t0 . updated_at AS updated_at_10 , t0 . courier_id AS courier_id_11 FROM shipping_method t0 WHERE t0 . alias = 'nt-sd-ev' AND t0 . status = '1' AND t0 . is_b2b = '1' LIMIT 1 ;
Copy
14
0.11 ms
SELECT t0 . id AS id_1 , t0 . ip AS ip_2 FROM customer_ban_ip t0 WHERE t0 . ip = ?
Parameters :
[
"81.221.205.224 "
]
SELECT t0 . id AS id_1 , t0 . ip AS ip_2 FROM customer_ban_ip t0 WHERE t0 . ip = '81.221.205.224' ;
Copy
15
0.09 ms
SELECT s0_ . current_timezone AS current_timezone_0 FROM settings s0_ LIMIT 1
SELECT s0_ . current_timezone AS current_timezone_0 FROM settings s0_ LIMIT 1 ;
Copy
16
0.11 ms
SELECT t0 . id AS id_1 , t0 . created_at AS created_at_2 , t0 . updated_at AS updated_at_3 , t0 . fos_user_id AS fos_user_id_4 FROM cart t0 WHERE t0 . fos_user_id = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . created_at AS created_at_2 , t0 . updated_at AS updated_at_3 , t0 . fos_user_id AS fos_user_id_4 FROM cart t0 WHERE t0 . fos_user_id = 9452 LIMIT 1 ;
Copy
17
0.15 ms
SELECT t0 . id AS id_1 , t0 . price AS price_2 , t0 . reguler_price AS reguler_price_3 , t0 . quantity AS quantity_4 , t0 . image AS image_5 , t0 . ds_fee AS ds_fee_6 , t0 . supplier_id AS supplier_id_7 , t0 . created_at AS created_at_8 , t0 . updated_at AS updated_at_9 , t0 . cart_id AS cart_id_10 , t0 . product_id AS product_id_11 FROM cart_products t0 WHERE t0 . cart_id = ?
SELECT t0 . id AS id_1 , t0 . price AS price_2 , t0 . reguler_price AS reguler_price_3 , t0 . quantity AS quantity_4 , t0 . image AS image_5 , t0 . ds_fee AS ds_fee_6 , t0 . supplier_id AS supplier_id_7 , t0 . created_at AS created_at_8 , t0 . updated_at AS updated_at_9 , t0 . cart_id AS cart_id_10 , t0 . product_id AS product_id_11 FROM cart_products t0 WHERE t0 . cart_id = 228 ;
Copy
18
0.36 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . ecp AS ecp_3 , t0 . is_bulky AS is_bulky_4 , t0 . new_name AS new_name_5 , t0 . icp_name AS icp_name_6 , t0 . code AS code_7 , t0 . mpn_code AS mpn_code_8 , t0 . ean_code AS ean_code_9 , t0 . iean_code AS iean_code_10 , t0 . sean_code AS sean_code_11 , t0 . is_iean_print AS is_iean_print_12 , t0 . is_cean_print AS is_cean_print_13 , t0 . is_sean_print AS is_sean_print_14 , t0 . sean AS sean_15 , t0 . org_supplier_id AS org_supplier_id_16 , t0 . is_retail_hold AS is_retail_hold_17 , t0 . description AS description_18 , t0 . type AS type_19 , t0 . tags AS tags_20 , t0 . product_custom_label AS product_custom_label_21 , t0 . product_label_active_days AS product_label_active_days_22 , t0 . required_configuration AS required_configuration_23 , t0 . price AS price_24 , t0 . price_gross AS price_gross_25 , t0 . msrp AS msrp_26 , t0 . distri_price AS distri_price_27 , t0 . stock_item_value AS stock_item_value_28 , t0 . stock_place AS stock_place_29 , t0 . product_type AS product_type_30 , t0 . quantity AS quantity_31 , t0 . minimum_stock AS minimum_stock_32 , t0 . minimum_stock_status AS minimum_stock_status_33 , t0 . mins_last_status AS mins_last_status_34 , t0 . is_force_mins AS is_force_mins_35 , t0 . is_ds AS is_ds_36 , t0 . is_force_ds AS is_force_ds_37 , t0 . int_stockyard AS int_stockyard_38 , t0 . vct_stock_quantity AS vct_stock_quantity_39 , t0 . vct_stock_status AS vct_stock_status_40 , t0 . expected_delivery_date AS expected_delivery_date_41 , t0 . seller_item_id AS seller_item_id_42 , t0 . other_seller_item_id AS other_seller_item_id_43 , t0 . other_supplier_id AS other_supplier_id_44 , t0 . manufacturer_suggested_retail_price AS manufacturer_suggested_retail_price_45 , t0 . cost_price AS cost_price_46 , t0 . abroad_base_price AS abroad_base_price_47 , t0 . base_price AS base_price_48 , t0 . item_discount AS item_discount_49 , t0 . purchase_price AS purchase_price_50 , t0 . supplier_tax_category AS supplier_tax_category_51 , t0 . publish_date AS publish_date_52 , t0 . expire_date AS expire_date_53 , t0 . require_shipping AS require_shipping_54 , t0 . returnable AS returnable_55 , t0 . stock_shelf AS stock_shelf_56 , t0 . shelf_place AS shelf_place_57 , t0 . package_width AS package_width_58 , t0 . package_height AS package_height_59 , t0 . package_depth AS package_depth_60 , t0 . package_weight AS package_weight_61 , t0 . related_product AS related_product_62 , t0 . spare_parts AS spare_parts_63 , t0 . components AS components_64 , t0 . up_selling_product AS up_selling_product_65 , t0 . cross_selling_product AS cross_selling_product_66 , t0 . attachment AS attachment_67 , t0 . seo_title AS seo_title_68 , t0 . seo_description AS seo_description_69 , t0 . seo_keyword AS seo_keyword_70 , t0 . seo_url AS seo_url_71 , t0 . old_seo_url AS old_seo_url_72 , t0 . show_extra_fields AS show_extra_fields_73 , t0 . status AS status_74 , t0 . manual_status AS manual_status_75 , t0 . is_manual_status AS is_manual_status_76 , t0 . import AS import_77 , t0 . display_stock_report AS display_stock_report_78 , t0 . display_front_status_change AS display_front_status_change_79 , t0 . deleted AS deleted_80 , t0 . incomplete_product AS incomplete_product_81 , t0 . assign_incomplete_product AS assign_incomplete_product_82 , t0 . incomplete_to_assign_product AS incomplete_to_assign_product_83 , t0 . incomplete_assign_product_id AS incomplete_assign_product_id_84 , t0 . sort_order AS sort_order_85 , t0 . profit AS profit_86 , t0 . margin AS margin_87 , t0 . b2b_profit AS b2b_profit_88 , t0 . b2b_margin AS b2b_margin_89 , t0 . catalogue_status AS catalogue_status_90 , t0 . is_unite AS is_unite_91 , t0 . supplier_cart_id AS supplier_cart_id_92 , t0 . created_at AS created_at_93 , t0 . updated_at AS updated_at_94 , t0 . tax_id AS tax_id_95 , t0 . stock_indicators_id AS stock_indicators_id_96 , t0 . return_rule_id AS return_rule_id_97 , t0 . category_id AS category_id_98 , t0 . supplier_id AS supplier_id_99 , t0 . manufacturer_id AS manufacturer_id_100 , t0 . courier_id AS courier_id_101 , t0 . sub_shipping_method_id AS sub_shipping_method_id_102 , t0 . currency_id AS currency_id_103 , t0 . product_label_id AS product_label_id_104 FROM product t0 WHERE t0 . id = ?
SELECT
t0 . id AS id_1 ,
t0 . name AS name_2 ,
t0 . ecp AS ecp_3 ,
t0 . is_bulky AS is_bulky_4 ,
t0 . new_name AS new_name_5 ,
t0 . icp_name AS icp_name_6 ,
t0 . code AS code_7 ,
t0 . mpn_code AS mpn_code_8 ,
t0 . ean_code AS ean_code_9 ,
t0 . iean_code AS iean_code_10 ,
t0 . sean_code AS sean_code_11 ,
t0 . is_iean_print AS is_iean_print_12 ,
t0 . is_cean_print AS is_cean_print_13 ,
t0 . is_sean_print AS is_sean_print_14 ,
t0 . sean AS sean_15 ,
t0 . org_supplier_id AS org_supplier_id_16 ,
t0 . is_retail_hold AS is_retail_hold_17 ,
t0 . description AS description_18 ,
t0 . type AS type_19 ,
t0 . tags AS tags_20 ,
t0 . product_custom_label AS product_custom_label_21 ,
t0 . product_label_active_days AS product_label_active_days_22 ,
t0 . required_configuration AS required_configuration_23 ,
t0 . price AS price_24 ,
t0 . price_gross AS price_gross_25 ,
t0 . msrp AS msrp_26 ,
t0 . distri_price AS distri_price_27 ,
t0 . stock_item_value AS stock_item_value_28 ,
t0 . stock_place AS stock_place_29 ,
t0 . product_type AS product_type_30 ,
t0 . quantity AS quantity_31 ,
t0 . minimum_stock AS minimum_stock_32 ,
t0 . minimum_stock_status AS minimum_stock_status_33 ,
t0 . mins_last_status AS mins_last_status_34 ,
t0 . is_force_mins AS is_force_mins_35 ,
t0 . is_ds AS is_ds_36 ,
t0 . is_force_ds AS is_force_ds_37 ,
t0 . int_stockyard AS int_stockyard_38 ,
t0 . vct_stock_quantity AS vct_stock_quantity_39 ,
t0 . vct_stock_status AS vct_stock_status_40 ,
t0 . expected_delivery_date AS expected_delivery_date_41 ,
t0 . seller_item_id AS seller_item_id_42 ,
t0 . other_seller_item_id AS other_seller_item_id_43 ,
t0 . other_supplier_id AS other_supplier_id_44 ,
t0 . manufacturer_suggested_retail_price AS manufacturer_suggested_retail_price_45 ,
t0 . cost_price AS cost_price_46 ,
t0 . abroad_base_price AS abroad_base_price_47 ,
t0 . base_price AS base_price_48 ,
t0 . item_discount AS item_discount_49 ,
t0 . purchase_price AS purchase_price_50 ,
t0 . supplier_tax_category AS supplier_tax_category_51 ,
t0 . publish_date AS publish_date_52 ,
t0 . expire_date AS expire_date_53 ,
t0 . require_shipping AS require_shipping_54 ,
t0 . returnable AS returnable_55 ,
t0 . stock_shelf AS stock_shelf_56 ,
t0 . shelf_place AS shelf_place_57 ,
t0 . package_width AS package_width_58 ,
t0 . package_height AS package_height_59 ,
t0 . package_depth AS package_depth_60 ,
t0 . package_weight AS package_weight_61 ,
t0 . related_product AS related_product_62 ,
t0 . spare_parts AS spare_parts_63 ,
t0 . components AS components_64 ,
t0 . up_selling_product AS up_selling_product_65 ,
t0 . cross_selling_product AS cross_selling_product_66 ,
t0 . attachment AS attachment_67 ,
t0 . seo_title AS seo_title_68 ,
t0 . seo_description AS seo_description_69 ,
t0 . seo_keyword AS seo_keyword_70 ,
t0 . seo_url AS seo_url_71 ,
t0 . old_seo_url AS old_seo_url_72 ,
t0 . show_extra_fields AS show_extra_fields_73 ,
t0 . status AS status_74 ,
t0 . manual_status AS manual_status_75 ,
t0 . is_manual_status AS is_manual_status_76 ,
t0 . import AS import_77 ,
t0 . display_stock_report AS display_stock_report_78 ,
t0 . display_front_status_change AS display_front_status_change_79 ,
t0 . deleted AS deleted_80 ,
t0 . incomplete_product AS incomplete_product_81 ,
t0 . assign_incomplete_product AS assign_incomplete_product_82 ,
t0 . incomplete_to_assign_product AS incomplete_to_assign_product_83 ,
t0 . incomplete_assign_product_id AS incomplete_assign_product_id_84 ,
t0 . sort_order AS sort_order_85 ,
t0 . profit AS profit_86 ,
t0 . margin AS margin_87 ,
t0 . b2b_profit AS b2b_profit_88 ,
t0 . b2b_margin AS b2b_margin_89 ,
t0 . catalogue_status AS catalogue_status_90 ,
t0 . is_unite AS is_unite_91 ,
t0 . supplier_cart_id AS supplier_cart_id_92 ,
t0 . created_at AS created_at_93 ,
t0 . updated_at AS updated_at_94 ,
t0 . tax_id AS tax_id_95 ,
t0 . stock_indicators_id AS stock_indicators_id_96 ,
t0 . return_rule_id AS return_rule_id_97 ,
t0 . category_id AS category_id_98 ,
t0 . supplier_id AS supplier_id_99 ,
t0 . manufacturer_id AS manufacturer_id_100 ,
t0 . courier_id AS courier_id_101 ,
t0 . sub_shipping_method_id AS sub_shipping_method_id_102 ,
t0 . currency_id AS currency_id_103 ,
t0 . product_label_id AS product_label_id_104
FROM
product t0
WHERE
t0 . id = ?
Copy
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . ecp AS ecp_3 , t0 . is_bulky AS is_bulky_4 , t0 . new_name AS new_name_5 , t0 . icp_name AS icp_name_6 , t0 . code AS code_7 , t0 . mpn_code AS mpn_code_8 , t0 . ean_code AS ean_code_9 , t0 . iean_code AS iean_code_10 , t0 . sean_code AS sean_code_11 , t0 . is_iean_print AS is_iean_print_12 , t0 . is_cean_print AS is_cean_print_13 , t0 . is_sean_print AS is_sean_print_14 , t0 . sean AS sean_15 , t0 . org_supplier_id AS org_supplier_id_16 , t0 . is_retail_hold AS is_retail_hold_17 , t0 . description AS description_18 , t0 . type AS type_19 , t0 . tags AS tags_20 , t0 . product_custom_label AS product_custom_label_21 , t0 . product_label_active_days AS product_label_active_days_22 , t0 . required_configuration AS required_configuration_23 , t0 . price AS price_24 , t0 . price_gross AS price_gross_25 , t0 . msrp AS msrp_26 , t0 . distri_price AS distri_price_27 , t0 . stock_item_value AS stock_item_value_28 , t0 . stock_place AS stock_place_29 , t0 . product_type AS product_type_30 , t0 . quantity AS quantity_31 , t0 . minimum_stock AS minimum_stock_32 , t0 . minimum_stock_status AS minimum_stock_status_33 , t0 . mins_last_status AS mins_last_status_34 , t0 . is_force_mins AS is_force_mins_35 , t0 . is_ds AS is_ds_36 , t0 . is_force_ds AS is_force_ds_37 , t0 . int_stockyard AS int_stockyard_38 , t0 . vct_stock_quantity AS vct_stock_quantity_39 , t0 . vct_stock_status AS vct_stock_status_40 , t0 . expected_delivery_date AS expected_delivery_date_41 , t0 . seller_item_id AS seller_item_id_42 , t0 . other_seller_item_id AS other_seller_item_id_43 , t0 . other_supplier_id AS other_supplier_id_44 , t0 . manufacturer_suggested_retail_price AS manufacturer_suggested_retail_price_45 , t0 . cost_price AS cost_price_46 , t0 . abroad_base_price AS abroad_base_price_47 , t0 . base_price AS base_price_48 , t0 . item_discount AS item_discount_49 , t0 . purchase_price AS purchase_price_50 , t0 . supplier_tax_category AS supplier_tax_category_51 , t0 . publish_date AS publish_date_52 , t0 . expire_date AS expire_date_53 , t0 . require_shipping AS require_shipping_54 , t0 . returnable AS returnable_55 , t0 . stock_shelf AS stock_shelf_56 , t0 . shelf_place AS shelf_place_57 , t0 . package_width AS package_width_58 , t0 . package_height AS package_height_59 , t0 . package_depth AS package_depth_60 , t0 . package_weight AS package_weight_61 , t0 . related_product AS related_product_62 , t0 . spare_parts AS spare_parts_63 , t0 . components AS components_64 , t0 . up_selling_product AS up_selling_product_65 , t0 . cross_selling_product AS cross_selling_product_66 , t0 . attachment AS attachment_67 , t0 . seo_title AS seo_title_68 , t0 . seo_description AS seo_description_69 , t0 . seo_keyword AS seo_keyword_70 , t0 . seo_url AS seo_url_71 , t0 . old_seo_url AS old_seo_url_72 , t0 . show_extra_fields AS show_extra_fields_73 , t0 . status AS status_74 , t0 . manual_status AS manual_status_75 , t0 . is_manual_status AS is_manual_status_76 , t0 . import AS import_77 , t0 . display_stock_report AS display_stock_report_78 , t0 . display_front_status_change AS display_front_status_change_79 , t0 . deleted AS deleted_80 , t0 . incomplete_product AS incomplete_product_81 , t0 . assign_incomplete_product AS assign_incomplete_product_82 , t0 . incomplete_to_assign_product AS incomplete_to_assign_product_83 , t0 . incomplete_assign_product_id AS incomplete_assign_product_id_84 , t0 . sort_order AS sort_order_85 , t0 . profit AS profit_86 , t0 . margin AS margin_87 , t0 . b2b_profit AS b2b_profit_88 , t0 . b2b_margin AS b2b_margin_89 , t0 . catalogue_status AS catalogue_status_90 , t0 . is_unite AS is_unite_91 , t0 . supplier_cart_id AS supplier_cart_id_92 , t0 . created_at AS created_at_93 , t0 . updated_at AS updated_at_94 , t0 . tax_id AS tax_id_95 , t0 . stock_indicators_id AS stock_indicators_id_96 , t0 . return_rule_id AS return_rule_id_97 , t0 . category_id AS category_id_98 , t0 . supplier_id AS supplier_id_99 , t0 . manufacturer_id AS manufacturer_id_100 , t0 . courier_id AS courier_id_101 , t0 . sub_shipping_method_id AS sub_shipping_method_id_102 , t0 . currency_id AS currency_id_103 , t0 . product_label_id AS product_label_id_104 FROM product t0 WHERE t0 . id = 15899 ;
Copy
19
0.20 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . description AS description_3 , t0 . is_b2b_distri AS is_b2b_distri_4 , t0 . is_b2b_resell AS is_b2b_resell_5 , t0 . is_b2c_retail AS is_b2c_retail_6 , t0 . b2b_distri_disagio AS b2b_distri_disagio_7 , t0 . free_b2c_shipping AS free_b2c_shipping_8 , t0 . subtitle AS subtitle_9 , t0 . banner_image AS banner_image_10 , t0 . seo_title AS seo_title_11 , t0 . seo_description AS seo_description_12 , t0 . seo_keyword AS seo_keyword_13 , t0 . seo_url AS seo_url_14 , t0 . image AS image_15 , t0 . sort_order AS sort_order_16 , t0 . status AS status_17 , t0 . display_front AS display_front_18 , t0 . highlight AS highlight_19 , t0 . deleted AS deleted_20 , t0 . created_at AS created_at_21 , t0 . updated_at AS updated_at_22 FROM manufacturer t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . description AS description_3 , t0 . is_b2b_distri AS is_b2b_distri_4 , t0 . is_b2b_resell AS is_b2b_resell_5 , t0 . is_b2c_retail AS is_b2c_retail_6 , t0 . b2b_distri_disagio AS b2b_distri_disagio_7 , t0 . free_b2c_shipping AS free_b2c_shipping_8 , t0 . subtitle AS subtitle_9 , t0 . banner_image AS banner_image_10 , t0 . seo_title AS seo_title_11 , t0 . seo_description AS seo_description_12 , t0 . seo_keyword AS seo_keyword_13 , t0 . seo_url AS seo_url_14 , t0 . image AS image_15 , t0 . sort_order AS sort_order_16 , t0 . status AS status_17 , t0 . display_front AS display_front_18 , t0 . highlight AS highlight_19 , t0 . deleted AS deleted_20 , t0 . created_at AS created_at_21 , t0 . updated_at AS updated_at_22 FROM manufacturer t0 WHERE t0 . id = 428 ;
Copy
20
0.17 ms
SELECT t0 . id AS id_1 , t0 . product_attributes AS product_attributes_2 , t0 . cart_products_id AS cart_products_id_3 , t0 . product_attribute_id AS product_attribute_id_4 , t0 . child_product_attribute_id AS child_product_attribute_id_5 , t0 . child_product_id AS child_product_id_6 , t0 . category_product_characteristic_value_id AS category_product_characteristic_value_id_7 FROM cart_product_attributes t0 WHERE t0 . cart_products_id = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . product_attributes AS product_attributes_2 , t0 . cart_products_id AS cart_products_id_3 , t0 . product_attribute_id AS product_attribute_id_4 , t0 . child_product_attribute_id AS child_product_attribute_id_5 , t0 . child_product_id AS child_product_id_6 , t0 . category_product_characteristic_value_id AS category_product_characteristic_value_id_7 FROM cart_product_attributes t0 WHERE t0 . cart_products_id = 493 LIMIT 1 ;
Copy
21
0.32 ms
SELECT t0 . id AS id_1 , t0 . type AS type_2 , t0 . characteristic_type AS characteristic_type_3 , t0 . alias AS alias_4 , t0 . code AS code_5 , t0 . mpn_code AS mpn_code_6 , t0 . ean_code AS ean_code_7 , t0 . iean_code AS iean_code_8 , t0 . sean_code AS sean_code_9 , t0 . is_iean_print AS is_iean_print_10 , t0 . is_cean_print AS is_cean_print_11 , t0 . is_sean_print AS is_sean_print_12 , t0 . sean AS sean_13 , t0 . org_supplier_id AS org_supplier_id_14 , t0 . price AS price_15 , t0 . price_gross AS price_gross_16 , t0 . msrp AS msrp_17 , t0 . distri_price AS distri_price_18 , t0 . stock_item_value AS stock_item_value_19 , t0 . prefix AS prefix_20 , t0 . stock_place AS stock_place_21 , t0 . product_type AS product_type_22 , t0 . quantity AS quantity_23 , t0 . minimum_stock AS minimum_stock_24 , t0 . minimum_stock_status AS minimum_stock_status_25 , t0 . mins_last_status AS mins_last_status_26 , t0 . is_force_mins AS is_force_mins_27 , t0 . is_ds AS is_ds_28 , t0 . is_force_ds AS is_force_ds_29 , t0 . int_stockyard AS int_stockyard_30 , t0 . vct_stock_quantity AS vct_stock_quantity_31 , t0 . vct_stock_status AS vct_stock_status_32 , t0 . expected_delivery_date AS expected_delivery_date_33 , t0 . seller_item_id AS seller_item_id_34 , t0 . other_seller_item_id AS other_seller_item_id_35 , t0 . other_supplier_id AS other_supplier_id_36 , t0 . manufacturer_suggested_retail_price AS manufacturer_suggested_retail_price_37 , t0 . cost_price AS cost_price_38 , t0 . abroad_base_price AS abroad_base_price_39 , t0 . base_price AS base_price_40 , t0 . item_discount AS item_discount_41 , t0 . purchase_price AS purchase_price_42 , t0 . returnable AS returnable_43 , t0 . supplier_tax_category AS supplier_tax_category_44 , t0 . stock_shelf AS stock_shelf_45 , t0 . shelf_place AS shelf_place_46 , t0 . extra_charge AS extra_charge_47 , t0 . session_id AS session_id_48 , t0 . ip AS ip_49 , t0 . sort_order AS sort_order_50 , t0 . profit AS profit_51 , t0 . margin AS margin_52 , t0 . b2b_profit AS b2b_profit_53 , t0 . b2b_margin AS b2b_margin_54 , t0 . deleted AS deleted_55 , t0 . status AS status_56 , t0 . manual_status AS manual_status_57 , t0 . is_manual_status AS is_manual_status_58 , t0 . display_stock_report AS display_stock_report_59 , t0 . publish_date AS publish_date_60 , t0 . expire_date AS expire_date_61 , t0 . is_unite AS is_unite_62 , t0 . supplier_cart_id AS supplier_cart_id_63 , t0 . created_at AS created_at_64 , t0 . updated_at AS updated_at_65 , t0 . product_id AS product_id_66 , t0 . child_product_id AS child_product_id_67 , t0 . child_product_attribute_id AS child_product_attribute_id_68 , t0 . stock_indicators_id AS stock_indicators_id_69 , t0 . category_product_characteristic_id AS category_product_characteristic_id_70 , t0 . category_product_characteristic_value_id AS category_product_characteristic_value_id_71 , t0 . supplier_id AS supplier_id_72 , t0 . return_rule_id AS return_rule_id_73 FROM product_attribute t0 WHERE t0 . id = ?
SELECT
t0 . id AS id_1 ,
t0 . type AS type_2 ,
t0 . characteristic_type AS characteristic_type_3 ,
t0 . alias AS alias_4 ,
t0 . code AS code_5 ,
t0 . mpn_code AS mpn_code_6 ,
t0 . ean_code AS ean_code_7 ,
t0 . iean_code AS iean_code_8 ,
t0 . sean_code AS sean_code_9 ,
t0 . is_iean_print AS is_iean_print_10 ,
t0 . is_cean_print AS is_cean_print_11 ,
t0 . is_sean_print AS is_sean_print_12 ,
t0 . sean AS sean_13 ,
t0 . org_supplier_id AS org_supplier_id_14 ,
t0 . price AS price_15 ,
t0 . price_gross AS price_gross_16 ,
t0 . msrp AS msrp_17 ,
t0 . distri_price AS distri_price_18 ,
t0 . stock_item_value AS stock_item_value_19 ,
t0 . prefix AS prefix_20 ,
t0 . stock_place AS stock_place_21 ,
t0 . product_type AS product_type_22 ,
t0 . quantity AS quantity_23 ,
t0 . minimum_stock AS minimum_stock_24 ,
t0 . minimum_stock_status AS minimum_stock_status_25 ,
t0 . mins_last_status AS mins_last_status_26 ,
t0 . is_force_mins AS is_force_mins_27 ,
t0 . is_ds AS is_ds_28 ,
t0 . is_force_ds AS is_force_ds_29 ,
t0 . int_stockyard AS int_stockyard_30 ,
t0 . vct_stock_quantity AS vct_stock_quantity_31 ,
t0 . vct_stock_status AS vct_stock_status_32 ,
t0 . expected_delivery_date AS expected_delivery_date_33 ,
t0 . seller_item_id AS seller_item_id_34 ,
t0 . other_seller_item_id AS other_seller_item_id_35 ,
t0 . other_supplier_id AS other_supplier_id_36 ,
t0 . manufacturer_suggested_retail_price AS manufacturer_suggested_retail_price_37 ,
t0 . cost_price AS cost_price_38 ,
t0 . abroad_base_price AS abroad_base_price_39 ,
t0 . base_price AS base_price_40 ,
t0 . item_discount AS item_discount_41 ,
t0 . purchase_price AS purchase_price_42 ,
t0 . returnable AS returnable_43 ,
t0 . supplier_tax_category AS supplier_tax_category_44 ,
t0 . stock_shelf AS stock_shelf_45 ,
t0 . shelf_place AS shelf_place_46 ,
t0 . extra_charge AS extra_charge_47 ,
t0 . session_id AS session_id_48 ,
t0 . ip AS ip_49 ,
t0 . sort_order AS sort_order_50 ,
t0 . profit AS profit_51 ,
t0 . margin AS margin_52 ,
t0 . b2b_profit AS b2b_profit_53 ,
t0 . b2b_margin AS b2b_margin_54 ,
t0 . deleted AS deleted_55 ,
t0 . status AS status_56 ,
t0 . manual_status AS manual_status_57 ,
t0 . is_manual_status AS is_manual_status_58 ,
t0 . display_stock_report AS display_stock_report_59 ,
t0 . publish_date AS publish_date_60 ,
t0 . expire_date AS expire_date_61 ,
t0 . is_unite AS is_unite_62 ,
t0 . supplier_cart_id AS supplier_cart_id_63 ,
t0 . created_at AS created_at_64 ,
t0 . updated_at AS updated_at_65 ,
t0 . product_id AS product_id_66 ,
t0 . child_product_id AS child_product_id_67 ,
t0 . child_product_attribute_id AS child_product_attribute_id_68 ,
t0 . stock_indicators_id AS stock_indicators_id_69 ,
t0 . category_product_characteristic_id AS category_product_characteristic_id_70 ,
t0 . category_product_characteristic_value_id AS category_product_characteristic_value_id_71 ,
t0 . supplier_id AS supplier_id_72 ,
t0 . return_rule_id AS return_rule_id_73
FROM
product_attribute t0
WHERE
t0 . id = ?
Copy
SELECT t0 . id AS id_1 , t0 . type AS type_2 , t0 . characteristic_type AS characteristic_type_3 , t0 . alias AS alias_4 , t0 . code AS code_5 , t0 . mpn_code AS mpn_code_6 , t0 . ean_code AS ean_code_7 , t0 . iean_code AS iean_code_8 , t0 . sean_code AS sean_code_9 , t0 . is_iean_print AS is_iean_print_10 , t0 . is_cean_print AS is_cean_print_11 , t0 . is_sean_print AS is_sean_print_12 , t0 . sean AS sean_13 , t0 . org_supplier_id AS org_supplier_id_14 , t0 . price AS price_15 , t0 . price_gross AS price_gross_16 , t0 . msrp AS msrp_17 , t0 . distri_price AS distri_price_18 , t0 . stock_item_value AS stock_item_value_19 , t0 . prefix AS prefix_20 , t0 . stock_place AS stock_place_21 , t0 . product_type AS product_type_22 , t0 . quantity AS quantity_23 , t0 . minimum_stock AS minimum_stock_24 , t0 . minimum_stock_status AS minimum_stock_status_25 , t0 . mins_last_status AS mins_last_status_26 , t0 . is_force_mins AS is_force_mins_27 , t0 . is_ds AS is_ds_28 , t0 . is_force_ds AS is_force_ds_29 , t0 . int_stockyard AS int_stockyard_30 , t0 . vct_stock_quantity AS vct_stock_quantity_31 , t0 . vct_stock_status AS vct_stock_status_32 , t0 . expected_delivery_date AS expected_delivery_date_33 , t0 . seller_item_id AS seller_item_id_34 , t0 . other_seller_item_id AS other_seller_item_id_35 , t0 . other_supplier_id AS other_supplier_id_36 , t0 . manufacturer_suggested_retail_price AS manufacturer_suggested_retail_price_37 , t0 . cost_price AS cost_price_38 , t0 . abroad_base_price AS abroad_base_price_39 , t0 . base_price AS base_price_40 , t0 . item_discount AS item_discount_41 , t0 . purchase_price AS purchase_price_42 , t0 . returnable AS returnable_43 , t0 . supplier_tax_category AS supplier_tax_category_44 , t0 . stock_shelf AS stock_shelf_45 , t0 . shelf_place AS shelf_place_46 , t0 . extra_charge AS extra_charge_47 , t0 . session_id AS session_id_48 , t0 . ip AS ip_49 , t0 . sort_order AS sort_order_50 , t0 . profit AS profit_51 , t0 . margin AS margin_52 , t0 . b2b_profit AS b2b_profit_53 , t0 . b2b_margin AS b2b_margin_54 , t0 . deleted AS deleted_55 , t0 . status AS status_56 , t0 . manual_status AS manual_status_57 , t0 . is_manual_status AS is_manual_status_58 , t0 . display_stock_report AS display_stock_report_59 , t0 . publish_date AS publish_date_60 , t0 . expire_date AS expire_date_61 , t0 . is_unite AS is_unite_62 , t0 . supplier_cart_id AS supplier_cart_id_63 , t0 . created_at AS created_at_64 , t0 . updated_at AS updated_at_65 , t0 . product_id AS product_id_66 , t0 . child_product_id AS child_product_id_67 , t0 . child_product_attribute_id AS child_product_attribute_id_68 , t0 . stock_indicators_id AS stock_indicators_id_69 , t0 . category_product_characteristic_id AS category_product_characteristic_id_70 , t0 . category_product_characteristic_value_id AS category_product_characteristic_value_id_71 , t0 . supplier_id AS supplier_id_72 , t0 . return_rule_id AS return_rule_id_73 FROM product_attribute t0 WHERE t0 . id = 1158488 ;
Copy
22
0.18 ms
SELECT p0_ . id AS id_0 FROM product_attribute p0_ WHERE p0_ . product_id = ? AND p0_ . deleted = 0 AND p0_ . status = 1 AND p0_ . characteristic_type = ? ORDER BY p0_ . sort_order ASC
Parameters :
[
15899
"product_option "
]
SELECT p0_ . id AS id_0 FROM product_attribute p0_ WHERE p0_ . product_id = 15899 AND p0_ . deleted = 0 AND p0_ . status = 1 AND p0_ . characteristic_type = 'product_option' ORDER BY p0_ . sort_order ASC ;
Copy
23
0.18 ms
SELECT t0 . id AS id_1 , t0 . product_option AS product_option_2 , t0 . filter_navigation AS filter_navigation_3 , t0 . tech_specification AS tech_specification_4 , t0 . display_front AS display_front_5 , t0 . ecp AS ecp_6 , t0 . product_option_sort_order AS product_option_sort_order_7 , t0 . tech_specification_sort_order AS tech_specification_sort_order_8 , t0 . created_at AS created_at_9 , t0 . updated_at AS updated_at_10 , t0 . product_id AS product_id_11 , t0 . category_product_characteristic_id AS category_product_characteristic_id_12 FROM product_attribute_options t0 WHERE t0 . product_id = ? AND t0 . product_option = ? ORDER BY t0 . product_option_sort_order ASC
SELECT t0 . id AS id_1 , t0 . product_option AS product_option_2 , t0 . filter_navigation AS filter_navigation_3 , t0 . tech_specification AS tech_specification_4 , t0 . display_front AS display_front_5 , t0 . ecp AS ecp_6 , t0 . product_option_sort_order AS product_option_sort_order_7 , t0 . tech_specification_sort_order AS tech_specification_sort_order_8 , t0 . created_at AS created_at_9 , t0 . updated_at AS updated_at_10 , t0 . product_id AS product_id_11 , t0 . category_product_characteristic_id AS category_product_characteristic_id_12 FROM product_attribute_options t0 WHERE t0 . product_id = 15899 AND t0 . product_option = 1 ORDER BY t0 . product_option_sort_order ASC ;
Copy
24
0.20 ms
SELECT c0_ . id AS id_0 , c0_ . product_id AS product_id_1 , c0_ . product_attribute_id AS product_attribute_id_2 , c0_ . category_product_characteristic_id AS category_product_characteristic_id_3 , c0_ . category_product_characteristic_value_id AS category_product_characteristic_value_id_4 FROM child_product_characteristic_value c0_ WHERE c0_ . product_attribute_id IN (1158487 , 1158488 , 1158486 , 1158489 , 1158490 ) AND c0_ . category_product_characteristic_id IN (162 )
SELECT c0_ . id AS id_0 , c0_ . product_id AS product_id_1 , c0_ . product_attribute_id AS product_attribute_id_2 , c0_ . category_product_characteristic_id AS category_product_characteristic_id_3 , c0_ . category_product_characteristic_value_id AS category_product_characteristic_value_id_4 FROM child_product_characteristic_value c0_ WHERE c0_ . product_attribute_id IN (1158487 , 1158488 , 1158486 , 1158489 , 1158490 ) AND c0_ . category_product_characteristic_id IN (162 );
Copy
25
0.16 ms
SELECT t0 . id AS id_1 , t0 . type AS type_2 , t0 . product_option AS product_option_3 , t0 . filter_navigation AS filter_navigation_4 , t0 . tech_specification AS tech_specification_5 , t0 . status AS status_6 , t0 . sort_order AS sort_order_7 , t0 . product_option_sort_order AS product_option_sort_order_8 , t0 . filter_navigation_sort_order AS filter_navigation_sort_order_9 , t0 . tech_specification_sort_order AS tech_specification_sort_order_10 , t0 . product_specific_option AS product_specific_option_11 , t0 . product_specific_tech_spec AS product_specific_tech_spec_12 , t0 . value_sorting_type AS value_sorting_type_13 , t0 . created_at AS created_at_14 , t0 . updated_at AS updated_at_15 , t0 . category_id AS category_id_16 , t0 . product_characteristic_id AS product_characteristic_id_17 , t0 . product_id AS product_id_18 , t0 . configure_product_id AS configure_product_id_19 FROM category_product_characteristic t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . type AS type_2 , t0 . product_option AS product_option_3 , t0 . filter_navigation AS filter_navigation_4 , t0 . tech_specification AS tech_specification_5 , t0 . status AS status_6 , t0 . sort_order AS sort_order_7 , t0 . product_option_sort_order AS product_option_sort_order_8 , t0 . filter_navigation_sort_order AS filter_navigation_sort_order_9 , t0 . tech_specification_sort_order AS tech_specification_sort_order_10 , t0 . product_specific_option AS product_specific_option_11 , t0 . product_specific_tech_spec AS product_specific_tech_spec_12 , t0 . value_sorting_type AS value_sorting_type_13 , t0 . created_at AS created_at_14 , t0 . updated_at AS updated_at_15 , t0 . category_id AS category_id_16 , t0 . product_characteristic_id AS product_characteristic_id_17 , t0 . product_id AS product_id_18 , t0 . configure_product_id AS configure_product_id_19 FROM category_product_characteristic t0 WHERE t0 . id = 162 ;
Copy
26
0.12 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 FROM product_characteristic t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 FROM product_characteristic t0 WHERE t0 . id = 14 ;
Copy
27
0.14 ms
SELECT t0 . id AS id_1 , t0 . product_specific_option_value AS product_specific_option_value_2 , t0 . product_filter_specific_option_value AS product_filter_specific_option_value_3 , t0 . product_tech_specific_option_value AS product_tech_specific_option_value_4 , t0 . sort_order AS sort_order_5 , t0 . created_at AS created_at_6 , t0 . updated_at AS updated_at_7 , t0 . category_product_characteristic_id AS category_product_characteristic_id_8 , t0 . product_characteristic_value_id AS product_characteristic_value_id_9 FROM category_product_characteristic_value t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . product_specific_option_value AS product_specific_option_value_2 , t0 . product_filter_specific_option_value AS product_filter_specific_option_value_3 , t0 . product_tech_specific_option_value AS product_tech_specific_option_value_4 , t0 . sort_order AS sort_order_5 , t0 . created_at AS created_at_6 , t0 . updated_at AS updated_at_7 , t0 . category_product_characteristic_id AS category_product_characteristic_id_8 , t0 . product_characteristic_value_id AS product_characteristic_value_id_9 FROM category_product_characteristic_value t0 WHERE t0 . id = 1275 ;
Copy
28
0.10 ms
SELECT t0 . id AS id_1 , t0 . value AS value_2 , t0 . product_characteristic_id AS product_characteristic_id_3 FROM product_characteristic_value t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . value AS value_2 , t0 . product_characteristic_id AS product_characteristic_id_3 FROM product_characteristic_value t0 WHERE t0 . id = 112 ;
Copy
29
0.09 ms
SELECT t0 . id AS id_1 , t0 . product_specific_option_value AS product_specific_option_value_2 , t0 . product_filter_specific_option_value AS product_filter_specific_option_value_3 , t0 . product_tech_specific_option_value AS product_tech_specific_option_value_4 , t0 . sort_order AS sort_order_5 , t0 . created_at AS created_at_6 , t0 . updated_at AS updated_at_7 , t0 . category_product_characteristic_id AS category_product_characteristic_id_8 , t0 . product_characteristic_value_id AS product_characteristic_value_id_9 FROM category_product_characteristic_value t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . product_specific_option_value AS product_specific_option_value_2 , t0 . product_filter_specific_option_value AS product_filter_specific_option_value_3 , t0 . product_tech_specific_option_value AS product_tech_specific_option_value_4 , t0 . sort_order AS sort_order_5 , t0 . created_at AS created_at_6 , t0 . updated_at AS updated_at_7 , t0 . category_product_characteristic_id AS category_product_characteristic_id_8 , t0 . product_characteristic_value_id AS product_characteristic_value_id_9 FROM category_product_characteristic_value t0 WHERE t0 . id = 7631 ;
Copy
30
0.07 ms
SELECT t0 . id AS id_1 , t0 . value AS value_2 , t0 . product_characteristic_id AS product_characteristic_id_3 FROM product_characteristic_value t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . value AS value_2 , t0 . product_characteristic_id AS product_characteristic_id_3 FROM product_characteristic_value t0 WHERE t0 . id = 110 ;
Copy
31
0.09 ms
SELECT t0 . id AS id_1 , t0 . product_specific_option_value AS product_specific_option_value_2 , t0 . product_filter_specific_option_value AS product_filter_specific_option_value_3 , t0 . product_tech_specific_option_value AS product_tech_specific_option_value_4 , t0 . sort_order AS sort_order_5 , t0 . created_at AS created_at_6 , t0 . updated_at AS updated_at_7 , t0 . category_product_characteristic_id AS category_product_characteristic_id_8 , t0 . product_characteristic_value_id AS product_characteristic_value_id_9 FROM category_product_characteristic_value t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . product_specific_option_value AS product_specific_option_value_2 , t0 . product_filter_specific_option_value AS product_filter_specific_option_value_3 , t0 . product_tech_specific_option_value AS product_tech_specific_option_value_4 , t0 . sort_order AS sort_order_5 , t0 . created_at AS created_at_6 , t0 . updated_at AS updated_at_7 , t0 . category_product_characteristic_id AS category_product_characteristic_id_8 , t0 . product_characteristic_value_id AS product_characteristic_value_id_9 FROM category_product_characteristic_value t0 WHERE t0 . id = 33591 ;
Copy
32
0.09 ms
SELECT t0 . id AS id_1 , t0 . value AS value_2 , t0 . product_characteristic_id AS product_characteristic_id_3 FROM product_characteristic_value t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . value AS value_2 , t0 . product_characteristic_id AS product_characteristic_id_3 FROM product_characteristic_value t0 WHERE t0 . id = 3075 ;
Copy
33
0.08 ms
SELECT t0 . id AS id_1 , t0 . product_specific_option_value AS product_specific_option_value_2 , t0 . product_filter_specific_option_value AS product_filter_specific_option_value_3 , t0 . product_tech_specific_option_value AS product_tech_specific_option_value_4 , t0 . sort_order AS sort_order_5 , t0 . created_at AS created_at_6 , t0 . updated_at AS updated_at_7 , t0 . category_product_characteristic_id AS category_product_characteristic_id_8 , t0 . product_characteristic_value_id AS product_characteristic_value_id_9 FROM category_product_characteristic_value t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . product_specific_option_value AS product_specific_option_value_2 , t0 . product_filter_specific_option_value AS product_filter_specific_option_value_3 , t0 . product_tech_specific_option_value AS product_tech_specific_option_value_4 , t0 . sort_order AS sort_order_5 , t0 . created_at AS created_at_6 , t0 . updated_at AS updated_at_7 , t0 . category_product_characteristic_id AS category_product_characteristic_id_8 , t0 . product_characteristic_value_id AS product_characteristic_value_id_9 FROM category_product_characteristic_value t0 WHERE t0 . id = 33590 ;
Copy
34
0.07 ms
SELECT t0 . id AS id_1 , t0 . value AS value_2 , t0 . product_characteristic_id AS product_characteristic_id_3 FROM product_characteristic_value t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . value AS value_2 , t0 . product_characteristic_id AS product_characteristic_id_3 FROM product_characteristic_value t0 WHERE t0 . id = 5556 ;
Copy
35
0.08 ms
SELECT t0 . id AS id_1 , t0 . product_specific_option_value AS product_specific_option_value_2 , t0 . product_filter_specific_option_value AS product_filter_specific_option_value_3 , t0 . product_tech_specific_option_value AS product_tech_specific_option_value_4 , t0 . sort_order AS sort_order_5 , t0 . created_at AS created_at_6 , t0 . updated_at AS updated_at_7 , t0 . category_product_characteristic_id AS category_product_characteristic_id_8 , t0 . product_characteristic_value_id AS product_characteristic_value_id_9 FROM category_product_characteristic_value t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . product_specific_option_value AS product_specific_option_value_2 , t0 . product_filter_specific_option_value AS product_filter_specific_option_value_3 , t0 . product_tech_specific_option_value AS product_tech_specific_option_value_4 , t0 . sort_order AS sort_order_5 , t0 . created_at AS created_at_6 , t0 . updated_at AS updated_at_7 , t0 . category_product_characteristic_id AS category_product_characteristic_id_8 , t0 . product_characteristic_value_id AS product_characteristic_value_id_9 FROM category_product_characteristic_value t0 WHERE t0 . id = 6840 ;
Copy
36
0.06 ms
SELECT t0 . id AS id_1 , t0 . value AS value_2 , t0 . product_characteristic_id AS product_characteristic_id_3 FROM product_characteristic_value t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . value AS value_2 , t0 . product_characteristic_id AS product_characteristic_id_3 FROM product_characteristic_value t0 WHERE t0 . id = 108 ;
Copy
37
0.13 ms
SELECT t0 . id AS id_1 , t0 . cover AS cover_2 , t0 . badge_color AS badge_color_3 , t0 . product_id AS product_id_4 , t0 . product_media_id AS product_media_id_5 , t0 . category_product_characteristic_value_id AS category_product_characteristic_value_id_6 FROM product_attribute_image t0 WHERE t0 . product_id = ? AND t0 . cover = ?
SELECT t0 . id AS id_1 , t0 . cover AS cover_2 , t0 . badge_color AS badge_color_3 , t0 . product_id AS product_id_4 , t0 . product_media_id AS product_media_id_5 , t0 . category_product_characteristic_value_id AS category_product_characteristic_value_id_6 FROM product_attribute_image t0 WHERE t0 . product_id = 15899 AND t0 . cover = 1 ;
Copy
38
0.13 ms
SELECT t0 . id AS id_1 , t0 . session_id AS session_id_2 , t0 . ip AS ip_3 , t0 . is_save AS is_save_4 , t0 . file AS file_5 , t0 . type AS type_6 , t0 . caption AS caption_7 , t0 . description AS description_8 , t0 . is_main_image AS is_main_image_9 , t0 . cover AS cover_10 , t0 . status AS status_11 , t0 . sort_order AS sort_order_12 , t0 . created_at AS created_at_13 , t0 . updated_at AS updated_at_14 , t0 . product_id AS product_id_15 FROM product_media t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . session_id AS session_id_2 , t0 . ip AS ip_3 , t0 . is_save AS is_save_4 , t0 . file AS file_5 , t0 . type AS type_6 , t0 . caption AS caption_7 , t0 . description AS description_8 , t0 . is_main_image AS is_main_image_9 , t0 . cover AS cover_10 , t0 . status AS status_11 , t0 . sort_order AS sort_order_12 , t0 . created_at AS created_at_13 , t0 . updated_at AS updated_at_14 , t0 . product_id AS product_id_15 FROM product_media t0 WHERE t0 . id = 45587 ;
Copy
39
0.09 ms
SELECT t0 . id AS id_1 , t0 . session_id AS session_id_2 , t0 . ip AS ip_3 , t0 . is_save AS is_save_4 , t0 . file AS file_5 , t0 . type AS type_6 , t0 . caption AS caption_7 , t0 . description AS description_8 , t0 . is_main_image AS is_main_image_9 , t0 . cover AS cover_10 , t0 . status AS status_11 , t0 . sort_order AS sort_order_12 , t0 . created_at AS created_at_13 , t0 . updated_at AS updated_at_14 , t0 . product_id AS product_id_15 FROM product_media t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . session_id AS session_id_2 , t0 . ip AS ip_3 , t0 . is_save AS is_save_4 , t0 . file AS file_5 , t0 . type AS type_6 , t0 . caption AS caption_7 , t0 . description AS description_8 , t0 . is_main_image AS is_main_image_9 , t0 . cover AS cover_10 , t0 . status AS status_11 , t0 . sort_order AS sort_order_12 , t0 . created_at AS created_at_13 , t0 . updated_at AS updated_at_14 , t0 . product_id AS product_id_15 FROM product_media t0 WHERE t0 . id = 45591 ;
Copy
40
0.09 ms
SELECT t0 . id AS id_1 , t0 . session_id AS session_id_2 , t0 . ip AS ip_3 , t0 . is_save AS is_save_4 , t0 . file AS file_5 , t0 . type AS type_6 , t0 . caption AS caption_7 , t0 . description AS description_8 , t0 . is_main_image AS is_main_image_9 , t0 . cover AS cover_10 , t0 . status AS status_11 , t0 . sort_order AS sort_order_12 , t0 . created_at AS created_at_13 , t0 . updated_at AS updated_at_14 , t0 . product_id AS product_id_15 FROM product_media t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . session_id AS session_id_2 , t0 . ip AS ip_3 , t0 . is_save AS is_save_4 , t0 . file AS file_5 , t0 . type AS type_6 , t0 . caption AS caption_7 , t0 . description AS description_8 , t0 . is_main_image AS is_main_image_9 , t0 . cover AS cover_10 , t0 . status AS status_11 , t0 . sort_order AS sort_order_12 , t0 . created_at AS created_at_13 , t0 . updated_at AS updated_at_14 , t0 . product_id AS product_id_15 FROM product_media t0 WHERE t0 . id = 45592 ;
Copy
41
0.09 ms
SELECT t0 . id AS id_1 , t0 . session_id AS session_id_2 , t0 . ip AS ip_3 , t0 . is_save AS is_save_4 , t0 . file AS file_5 , t0 . type AS type_6 , t0 . caption AS caption_7 , t0 . description AS description_8 , t0 . is_main_image AS is_main_image_9 , t0 . cover AS cover_10 , t0 . status AS status_11 , t0 . sort_order AS sort_order_12 , t0 . created_at AS created_at_13 , t0 . updated_at AS updated_at_14 , t0 . product_id AS product_id_15 FROM product_media t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . session_id AS session_id_2 , t0 . ip AS ip_3 , t0 . is_save AS is_save_4 , t0 . file AS file_5 , t0 . type AS type_6 , t0 . caption AS caption_7 , t0 . description AS description_8 , t0 . is_main_image AS is_main_image_9 , t0 . cover AS cover_10 , t0 . status AS status_11 , t0 . sort_order AS sort_order_12 , t0 . created_at AS created_at_13 , t0 . updated_at AS updated_at_14 , t0 . product_id AS product_id_15 FROM product_media t0 WHERE t0 . id = 45590 ;
Copy
42
0.09 ms
SELECT t0 . id AS id_1 , t0 . session_id AS session_id_2 , t0 . ip AS ip_3 , t0 . is_save AS is_save_4 , t0 . file AS file_5 , t0 . type AS type_6 , t0 . caption AS caption_7 , t0 . description AS description_8 , t0 . is_main_image AS is_main_image_9 , t0 . cover AS cover_10 , t0 . status AS status_11 , t0 . sort_order AS sort_order_12 , t0 . created_at AS created_at_13 , t0 . updated_at AS updated_at_14 , t0 . product_id AS product_id_15 FROM product_media t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . session_id AS session_id_2 , t0 . ip AS ip_3 , t0 . is_save AS is_save_4 , t0 . file AS file_5 , t0 . type AS type_6 , t0 . caption AS caption_7 , t0 . description AS description_8 , t0 . is_main_image AS is_main_image_9 , t0 . cover AS cover_10 , t0 . status AS status_11 , t0 . sort_order AS sort_order_12 , t0 . created_at AS created_at_13 , t0 . updated_at AS updated_at_14 , t0 . product_id AS product_id_15 FROM product_media t0 WHERE t0 . id = 45593 ;
Copy
43
0.09 ms
SELECT t0 . id AS id_1 , t0 . session_id AS session_id_2 , t0 . ip AS ip_3 , t0 . is_save AS is_save_4 , t0 . file AS file_5 , t0 . type AS type_6 , t0 . caption AS caption_7 , t0 . description AS description_8 , t0 . is_main_image AS is_main_image_9 , t0 . cover AS cover_10 , t0 . status AS status_11 , t0 . sort_order AS sort_order_12 , t0 . created_at AS created_at_13 , t0 . updated_at AS updated_at_14 , t0 . product_id AS product_id_15 FROM product_media t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . session_id AS session_id_2 , t0 . ip AS ip_3 , t0 . is_save AS is_save_4 , t0 . file AS file_5 , t0 . type AS type_6 , t0 . caption AS caption_7 , t0 . description AS description_8 , t0 . is_main_image AS is_main_image_9 , t0 . cover AS cover_10 , t0 . status AS status_11 , t0 . sort_order AS sort_order_12 , t0 . created_at AS created_at_13 , t0 . updated_at AS updated_at_14 , t0 . product_id AS product_id_15 FROM product_media t0 WHERE t0 . id = 45594 ;
Copy
44
0.14 ms
SELECT t0 . id AS id_1 , t0 . session_id AS session_id_2 , t0 . ip AS ip_3 , t0 . price_mode AS price_mode_4 , t0 . discount_rate AS discount_rate_5 , t0 . price AS price_6 , t0 . net_price AS net_price_7 , t0 . start_date AS start_date_8 , t0 . expire_date AS expire_date_9 , t0 . status AS status_10 , t0 . created_at AS created_at_11 , t0 . updated_at AS updated_at_12 , t0 . product_id AS product_id_13 , t0 . currency_id AS currency_id_14 , t0 . product_attribute_id AS product_attribute_id_15 , t0 . supplier_product_id AS supplier_product_id_16 , t0 . tax_id AS tax_id_17 FROM special_price t0 WHERE t0 . product_id = ? AND t0 . product_attribute_id = ? AND t0 . status = ? ORDER BY t0 . id DESC LIMIT 1
Parameters :
[
15899
1158488
1
]
SELECT t0 . id AS id_1 , t0 . session_id AS session_id_2 , t0 . ip AS ip_3 , t0 . price_mode AS price_mode_4 , t0 . discount_rate AS discount_rate_5 , t0 . price AS price_6 , t0 . net_price AS net_price_7 , t0 . start_date AS start_date_8 , t0 . expire_date AS expire_date_9 , t0 . status AS status_10 , t0 . created_at AS created_at_11 , t0 . updated_at AS updated_at_12 , t0 . product_id AS product_id_13 , t0 . currency_id AS currency_id_14 , t0 . product_attribute_id AS product_attribute_id_15 , t0 . supplier_product_id AS supplier_product_id_16 , t0 . tax_id AS tax_id_17 FROM special_price t0 WHERE t0 . product_id = 15899 AND t0 . product_attribute_id = 1158488 AND t0 . status = 1 ORDER BY t0 . id DESC LIMIT 1 ;
Copy
45
0.25 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . ecp AS ecp_3 , t0 . is_bulky AS is_bulky_4 , t0 . new_name AS new_name_5 , t0 . icp_name AS icp_name_6 , t0 . code AS code_7 , t0 . mpn_code AS mpn_code_8 , t0 . ean_code AS ean_code_9 , t0 . iean_code AS iean_code_10 , t0 . sean_code AS sean_code_11 , t0 . is_iean_print AS is_iean_print_12 , t0 . is_cean_print AS is_cean_print_13 , t0 . is_sean_print AS is_sean_print_14 , t0 . sean AS sean_15 , t0 . org_supplier_id AS org_supplier_id_16 , t0 . is_retail_hold AS is_retail_hold_17 , t0 . description AS description_18 , t0 . type AS type_19 , t0 . tags AS tags_20 , t0 . product_custom_label AS product_custom_label_21 , t0 . product_label_active_days AS product_label_active_days_22 , t0 . required_configuration AS required_configuration_23 , t0 . price AS price_24 , t0 . price_gross AS price_gross_25 , t0 . msrp AS msrp_26 , t0 . distri_price AS distri_price_27 , t0 . stock_item_value AS stock_item_value_28 , t0 . stock_place AS stock_place_29 , t0 . product_type AS product_type_30 , t0 . quantity AS quantity_31 , t0 . minimum_stock AS minimum_stock_32 , t0 . minimum_stock_status AS minimum_stock_status_33 , t0 . mins_last_status AS mins_last_status_34 , t0 . is_force_mins AS is_force_mins_35 , t0 . is_ds AS is_ds_36 , t0 . is_force_ds AS is_force_ds_37 , t0 . int_stockyard AS int_stockyard_38 , t0 . vct_stock_quantity AS vct_stock_quantity_39 , t0 . vct_stock_status AS vct_stock_status_40 , t0 . expected_delivery_date AS expected_delivery_date_41 , t0 . seller_item_id AS seller_item_id_42 , t0 . other_seller_item_id AS other_seller_item_id_43 , t0 . other_supplier_id AS other_supplier_id_44 , t0 . manufacturer_suggested_retail_price AS manufacturer_suggested_retail_price_45 , t0 . cost_price AS cost_price_46 , t0 . abroad_base_price AS abroad_base_price_47 , t0 . base_price AS base_price_48 , t0 . item_discount AS item_discount_49 , t0 . purchase_price AS purchase_price_50 , t0 . supplier_tax_category AS supplier_tax_category_51 , t0 . publish_date AS publish_date_52 , t0 . expire_date AS expire_date_53 , t0 . require_shipping AS require_shipping_54 , t0 . returnable AS returnable_55 , t0 . stock_shelf AS stock_shelf_56 , t0 . shelf_place AS shelf_place_57 , t0 . package_width AS package_width_58 , t0 . package_height AS package_height_59 , t0 . package_depth AS package_depth_60 , t0 . package_weight AS package_weight_61 , t0 . related_product AS related_product_62 , t0 . spare_parts AS spare_parts_63 , t0 . components AS components_64 , t0 . up_selling_product AS up_selling_product_65 , t0 . cross_selling_product AS cross_selling_product_66 , t0 . attachment AS attachment_67 , t0 . seo_title AS seo_title_68 , t0 . seo_description AS seo_description_69 , t0 . seo_keyword AS seo_keyword_70 , t0 . seo_url AS seo_url_71 , t0 . old_seo_url AS old_seo_url_72 , t0 . show_extra_fields AS show_extra_fields_73 , t0 . status AS status_74 , t0 . manual_status AS manual_status_75 , t0 . is_manual_status AS is_manual_status_76 , t0 . import AS import_77 , t0 . display_stock_report AS display_stock_report_78 , t0 . display_front_status_change AS display_front_status_change_79 , t0 . deleted AS deleted_80 , t0 . incomplete_product AS incomplete_product_81 , t0 . assign_incomplete_product AS assign_incomplete_product_82 , t0 . incomplete_to_assign_product AS incomplete_to_assign_product_83 , t0 . incomplete_assign_product_id AS incomplete_assign_product_id_84 , t0 . sort_order AS sort_order_85 , t0 . profit AS profit_86 , t0 . margin AS margin_87 , t0 . b2b_profit AS b2b_profit_88 , t0 . b2b_margin AS b2b_margin_89 , t0 . catalogue_status AS catalogue_status_90 , t0 . is_unite AS is_unite_91 , t0 . supplier_cart_id AS supplier_cart_id_92 , t0 . created_at AS created_at_93 , t0 . updated_at AS updated_at_94 , t0 . tax_id AS tax_id_95 , t0 . stock_indicators_id AS stock_indicators_id_96 , t0 . return_rule_id AS return_rule_id_97 , t0 . category_id AS category_id_98 , t0 . supplier_id AS supplier_id_99 , t0 . manufacturer_id AS manufacturer_id_100 , t0 . courier_id AS courier_id_101 , t0 . sub_shipping_method_id AS sub_shipping_method_id_102 , t0 . currency_id AS currency_id_103 , t0 . product_label_id AS product_label_id_104 FROM product t0 WHERE t0 . id = ?
SELECT
t0 . id AS id_1 ,
t0 . name AS name_2 ,
t0 . ecp AS ecp_3 ,
t0 . is_bulky AS is_bulky_4 ,
t0 . new_name AS new_name_5 ,
t0 . icp_name AS icp_name_6 ,
t0 . code AS code_7 ,
t0 . mpn_code AS mpn_code_8 ,
t0 . ean_code AS ean_code_9 ,
t0 . iean_code AS iean_code_10 ,
t0 . sean_code AS sean_code_11 ,
t0 . is_iean_print AS is_iean_print_12 ,
t0 . is_cean_print AS is_cean_print_13 ,
t0 . is_sean_print AS is_sean_print_14 ,
t0 . sean AS sean_15 ,
t0 . org_supplier_id AS org_supplier_id_16 ,
t0 . is_retail_hold AS is_retail_hold_17 ,
t0 . description AS description_18 ,
t0 . type AS type_19 ,
t0 . tags AS tags_20 ,
t0 . product_custom_label AS product_custom_label_21 ,
t0 . product_label_active_days AS product_label_active_days_22 ,
t0 . required_configuration AS required_configuration_23 ,
t0 . price AS price_24 ,
t0 . price_gross AS price_gross_25 ,
t0 . msrp AS msrp_26 ,
t0 . distri_price AS distri_price_27 ,
t0 . stock_item_value AS stock_item_value_28 ,
t0 . stock_place AS stock_place_29 ,
t0 . product_type AS product_type_30 ,
t0 . quantity AS quantity_31 ,
t0 . minimum_stock AS minimum_stock_32 ,
t0 . minimum_stock_status AS minimum_stock_status_33 ,
t0 . mins_last_status AS mins_last_status_34 ,
t0 . is_force_mins AS is_force_mins_35 ,
t0 . is_ds AS is_ds_36 ,
t0 . is_force_ds AS is_force_ds_37 ,
t0 . int_stockyard AS int_stockyard_38 ,
t0 . vct_stock_quantity AS vct_stock_quantity_39 ,
t0 . vct_stock_status AS vct_stock_status_40 ,
t0 . expected_delivery_date AS expected_delivery_date_41 ,
t0 . seller_item_id AS seller_item_id_42 ,
t0 . other_seller_item_id AS other_seller_item_id_43 ,
t0 . other_supplier_id AS other_supplier_id_44 ,
t0 . manufacturer_suggested_retail_price AS manufacturer_suggested_retail_price_45 ,
t0 . cost_price AS cost_price_46 ,
t0 . abroad_base_price AS abroad_base_price_47 ,
t0 . base_price AS base_price_48 ,
t0 . item_discount AS item_discount_49 ,
t0 . purchase_price AS purchase_price_50 ,
t0 . supplier_tax_category AS supplier_tax_category_51 ,
t0 . publish_date AS publish_date_52 ,
t0 . expire_date AS expire_date_53 ,
t0 . require_shipping AS require_shipping_54 ,
t0 . returnable AS returnable_55 ,
t0 . stock_shelf AS stock_shelf_56 ,
t0 . shelf_place AS shelf_place_57 ,
t0 . package_width AS package_width_58 ,
t0 . package_height AS package_height_59 ,
t0 . package_depth AS package_depth_60 ,
t0 . package_weight AS package_weight_61 ,
t0 . related_product AS related_product_62 ,
t0 . spare_parts AS spare_parts_63 ,
t0 . components AS components_64 ,
t0 . up_selling_product AS up_selling_product_65 ,
t0 . cross_selling_product AS cross_selling_product_66 ,
t0 . attachment AS attachment_67 ,
t0 . seo_title AS seo_title_68 ,
t0 . seo_description AS seo_description_69 ,
t0 . seo_keyword AS seo_keyword_70 ,
t0 . seo_url AS seo_url_71 ,
t0 . old_seo_url AS old_seo_url_72 ,
t0 . show_extra_fields AS show_extra_fields_73 ,
t0 . status AS status_74 ,
t0 . manual_status AS manual_status_75 ,
t0 . is_manual_status AS is_manual_status_76 ,
t0 . import AS import_77 ,
t0 . display_stock_report AS display_stock_report_78 ,
t0 . display_front_status_change AS display_front_status_change_79 ,
t0 . deleted AS deleted_80 ,
t0 . incomplete_product AS incomplete_product_81 ,
t0 . assign_incomplete_product AS assign_incomplete_product_82 ,
t0 . incomplete_to_assign_product AS incomplete_to_assign_product_83 ,
t0 . incomplete_assign_product_id AS incomplete_assign_product_id_84 ,
t0 . sort_order AS sort_order_85 ,
t0 . profit AS profit_86 ,
t0 . margin AS margin_87 ,
t0 . b2b_profit AS b2b_profit_88 ,
t0 . b2b_margin AS b2b_margin_89 ,
t0 . catalogue_status AS catalogue_status_90 ,
t0 . is_unite AS is_unite_91 ,
t0 . supplier_cart_id AS supplier_cart_id_92 ,
t0 . created_at AS created_at_93 ,
t0 . updated_at AS updated_at_94 ,
t0 . tax_id AS tax_id_95 ,
t0 . stock_indicators_id AS stock_indicators_id_96 ,
t0 . return_rule_id AS return_rule_id_97 ,
t0 . category_id AS category_id_98 ,
t0 . supplier_id AS supplier_id_99 ,
t0 . manufacturer_id AS manufacturer_id_100 ,
t0 . courier_id AS courier_id_101 ,
t0 . sub_shipping_method_id AS sub_shipping_method_id_102 ,
t0 . currency_id AS currency_id_103 ,
t0 . product_label_id AS product_label_id_104
FROM
product t0
WHERE
t0 . id = ?
Copy
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . ecp AS ecp_3 , t0 . is_bulky AS is_bulky_4 , t0 . new_name AS new_name_5 , t0 . icp_name AS icp_name_6 , t0 . code AS code_7 , t0 . mpn_code AS mpn_code_8 , t0 . ean_code AS ean_code_9 , t0 . iean_code AS iean_code_10 , t0 . sean_code AS sean_code_11 , t0 . is_iean_print AS is_iean_print_12 , t0 . is_cean_print AS is_cean_print_13 , t0 . is_sean_print AS is_sean_print_14 , t0 . sean AS sean_15 , t0 . org_supplier_id AS org_supplier_id_16 , t0 . is_retail_hold AS is_retail_hold_17 , t0 . description AS description_18 , t0 . type AS type_19 , t0 . tags AS tags_20 , t0 . product_custom_label AS product_custom_label_21 , t0 . product_label_active_days AS product_label_active_days_22 , t0 . required_configuration AS required_configuration_23 , t0 . price AS price_24 , t0 . price_gross AS price_gross_25 , t0 . msrp AS msrp_26 , t0 . distri_price AS distri_price_27 , t0 . stock_item_value AS stock_item_value_28 , t0 . stock_place AS stock_place_29 , t0 . product_type AS product_type_30 , t0 . quantity AS quantity_31 , t0 . minimum_stock AS minimum_stock_32 , t0 . minimum_stock_status AS minimum_stock_status_33 , t0 . mins_last_status AS mins_last_status_34 , t0 . is_force_mins AS is_force_mins_35 , t0 . is_ds AS is_ds_36 , t0 . is_force_ds AS is_force_ds_37 , t0 . int_stockyard AS int_stockyard_38 , t0 . vct_stock_quantity AS vct_stock_quantity_39 , t0 . vct_stock_status AS vct_stock_status_40 , t0 . expected_delivery_date AS expected_delivery_date_41 , t0 . seller_item_id AS seller_item_id_42 , t0 . other_seller_item_id AS other_seller_item_id_43 , t0 . other_supplier_id AS other_supplier_id_44 , t0 . manufacturer_suggested_retail_price AS manufacturer_suggested_retail_price_45 , t0 . cost_price AS cost_price_46 , t0 . abroad_base_price AS abroad_base_price_47 , t0 . base_price AS base_price_48 , t0 . item_discount AS item_discount_49 , t0 . purchase_price AS purchase_price_50 , t0 . supplier_tax_category AS supplier_tax_category_51 , t0 . publish_date AS publish_date_52 , t0 . expire_date AS expire_date_53 , t0 . require_shipping AS require_shipping_54 , t0 . returnable AS returnable_55 , t0 . stock_shelf AS stock_shelf_56 , t0 . shelf_place AS shelf_place_57 , t0 . package_width AS package_width_58 , t0 . package_height AS package_height_59 , t0 . package_depth AS package_depth_60 , t0 . package_weight AS package_weight_61 , t0 . related_product AS related_product_62 , t0 . spare_parts AS spare_parts_63 , t0 . components AS components_64 , t0 . up_selling_product AS up_selling_product_65 , t0 . cross_selling_product AS cross_selling_product_66 , t0 . attachment AS attachment_67 , t0 . seo_title AS seo_title_68 , t0 . seo_description AS seo_description_69 , t0 . seo_keyword AS seo_keyword_70 , t0 . seo_url AS seo_url_71 , t0 . old_seo_url AS old_seo_url_72 , t0 . show_extra_fields AS show_extra_fields_73 , t0 . status AS status_74 , t0 . manual_status AS manual_status_75 , t0 . is_manual_status AS is_manual_status_76 , t0 . import AS import_77 , t0 . display_stock_report AS display_stock_report_78 , t0 . display_front_status_change AS display_front_status_change_79 , t0 . deleted AS deleted_80 , t0 . incomplete_product AS incomplete_product_81 , t0 . assign_incomplete_product AS assign_incomplete_product_82 , t0 . incomplete_to_assign_product AS incomplete_to_assign_product_83 , t0 . incomplete_assign_product_id AS incomplete_assign_product_id_84 , t0 . sort_order AS sort_order_85 , t0 . profit AS profit_86 , t0 . margin AS margin_87 , t0 . b2b_profit AS b2b_profit_88 , t0 . b2b_margin AS b2b_margin_89 , t0 . catalogue_status AS catalogue_status_90 , t0 . is_unite AS is_unite_91 , t0 . supplier_cart_id AS supplier_cart_id_92 , t0 . created_at AS created_at_93 , t0 . updated_at AS updated_at_94 , t0 . tax_id AS tax_id_95 , t0 . stock_indicators_id AS stock_indicators_id_96 , t0 . return_rule_id AS return_rule_id_97 , t0 . category_id AS category_id_98 , t0 . supplier_id AS supplier_id_99 , t0 . manufacturer_id AS manufacturer_id_100 , t0 . courier_id AS courier_id_101 , t0 . sub_shipping_method_id AS sub_shipping_method_id_102 , t0 . currency_id AS currency_id_103 , t0 . product_label_id AS product_label_id_104 FROM product t0 WHERE t0 . id = 15997 ;
Copy
46
0.10 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . description AS description_3 , t0 . is_b2b_distri AS is_b2b_distri_4 , t0 . is_b2b_resell AS is_b2b_resell_5 , t0 . is_b2c_retail AS is_b2c_retail_6 , t0 . b2b_distri_disagio AS b2b_distri_disagio_7 , t0 . free_b2c_shipping AS free_b2c_shipping_8 , t0 . subtitle AS subtitle_9 , t0 . banner_image AS banner_image_10 , t0 . seo_title AS seo_title_11 , t0 . seo_description AS seo_description_12 , t0 . seo_keyword AS seo_keyword_13 , t0 . seo_url AS seo_url_14 , t0 . image AS image_15 , t0 . sort_order AS sort_order_16 , t0 . status AS status_17 , t0 . display_front AS display_front_18 , t0 . highlight AS highlight_19 , t0 . deleted AS deleted_20 , t0 . created_at AS created_at_21 , t0 . updated_at AS updated_at_22 FROM manufacturer t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . description AS description_3 , t0 . is_b2b_distri AS is_b2b_distri_4 , t0 . is_b2b_resell AS is_b2b_resell_5 , t0 . is_b2c_retail AS is_b2c_retail_6 , t0 . b2b_distri_disagio AS b2b_distri_disagio_7 , t0 . free_b2c_shipping AS free_b2c_shipping_8 , t0 . subtitle AS subtitle_9 , t0 . banner_image AS banner_image_10 , t0 . seo_title AS seo_title_11 , t0 . seo_description AS seo_description_12 , t0 . seo_keyword AS seo_keyword_13 , t0 . seo_url AS seo_url_14 , t0 . image AS image_15 , t0 . sort_order AS sort_order_16 , t0 . status AS status_17 , t0 . display_front AS display_front_18 , t0 . highlight AS highlight_19 , t0 . deleted AS deleted_20 , t0 . created_at AS created_at_21 , t0 . updated_at AS updated_at_22 FROM manufacturer t0 WHERE t0 . id = 109 ;
Copy
47
0.10 ms
SELECT t0 . id AS id_1 , t0 . product_attributes AS product_attributes_2 , t0 . cart_products_id AS cart_products_id_3 , t0 . product_attribute_id AS product_attribute_id_4 , t0 . child_product_attribute_id AS child_product_attribute_id_5 , t0 . child_product_id AS child_product_id_6 , t0 . category_product_characteristic_value_id AS category_product_characteristic_value_id_7 FROM cart_product_attributes t0 WHERE t0 . cart_products_id = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . product_attributes AS product_attributes_2 , t0 . cart_products_id AS cart_products_id_3 , t0 . product_attribute_id AS product_attribute_id_4 , t0 . child_product_attribute_id AS child_product_attribute_id_5 , t0 . child_product_id AS child_product_id_6 , t0 . category_product_characteristic_value_id AS category_product_characteristic_value_id_7 FROM cart_product_attributes t0 WHERE t0 . cart_products_id = 494 LIMIT 1 ;
Copy
48
0.18 ms
SELECT t0 . id AS id_1 , t0 . type AS type_2 , t0 . characteristic_type AS characteristic_type_3 , t0 . alias AS alias_4 , t0 . code AS code_5 , t0 . mpn_code AS mpn_code_6 , t0 . ean_code AS ean_code_7 , t0 . iean_code AS iean_code_8 , t0 . sean_code AS sean_code_9 , t0 . is_iean_print AS is_iean_print_10 , t0 . is_cean_print AS is_cean_print_11 , t0 . is_sean_print AS is_sean_print_12 , t0 . sean AS sean_13 , t0 . org_supplier_id AS org_supplier_id_14 , t0 . price AS price_15 , t0 . price_gross AS price_gross_16 , t0 . msrp AS msrp_17 , t0 . distri_price AS distri_price_18 , t0 . stock_item_value AS stock_item_value_19 , t0 . prefix AS prefix_20 , t0 . stock_place AS stock_place_21 , t0 . product_type AS product_type_22 , t0 . quantity AS quantity_23 , t0 . minimum_stock AS minimum_stock_24 , t0 . minimum_stock_status AS minimum_stock_status_25 , t0 . mins_last_status AS mins_last_status_26 , t0 . is_force_mins AS is_force_mins_27 , t0 . is_ds AS is_ds_28 , t0 . is_force_ds AS is_force_ds_29 , t0 . int_stockyard AS int_stockyard_30 , t0 . vct_stock_quantity AS vct_stock_quantity_31 , t0 . vct_stock_status AS vct_stock_status_32 , t0 . expected_delivery_date AS expected_delivery_date_33 , t0 . seller_item_id AS seller_item_id_34 , t0 . other_seller_item_id AS other_seller_item_id_35 , t0 . other_supplier_id AS other_supplier_id_36 , t0 . manufacturer_suggested_retail_price AS manufacturer_suggested_retail_price_37 , t0 . cost_price AS cost_price_38 , t0 . abroad_base_price AS abroad_base_price_39 , t0 . base_price AS base_price_40 , t0 . item_discount AS item_discount_41 , t0 . purchase_price AS purchase_price_42 , t0 . returnable AS returnable_43 , t0 . supplier_tax_category AS supplier_tax_category_44 , t0 . stock_shelf AS stock_shelf_45 , t0 . shelf_place AS shelf_place_46 , t0 . extra_charge AS extra_charge_47 , t0 . session_id AS session_id_48 , t0 . ip AS ip_49 , t0 . sort_order AS sort_order_50 , t0 . profit AS profit_51 , t0 . margin AS margin_52 , t0 . b2b_profit AS b2b_profit_53 , t0 . b2b_margin AS b2b_margin_54 , t0 . deleted AS deleted_55 , t0 . status AS status_56 , t0 . manual_status AS manual_status_57 , t0 . is_manual_status AS is_manual_status_58 , t0 . display_stock_report AS display_stock_report_59 , t0 . publish_date AS publish_date_60 , t0 . expire_date AS expire_date_61 , t0 . is_unite AS is_unite_62 , t0 . supplier_cart_id AS supplier_cart_id_63 , t0 . created_at AS created_at_64 , t0 . updated_at AS updated_at_65 , t0 . product_id AS product_id_66 , t0 . child_product_id AS child_product_id_67 , t0 . child_product_attribute_id AS child_product_attribute_id_68 , t0 . stock_indicators_id AS stock_indicators_id_69 , t0 . category_product_characteristic_id AS category_product_characteristic_id_70 , t0 . category_product_characteristic_value_id AS category_product_characteristic_value_id_71 , t0 . supplier_id AS supplier_id_72 , t0 . return_rule_id AS return_rule_id_73 FROM product_attribute t0 WHERE t0 . id = ?
SELECT
t0 . id AS id_1 ,
t0 . type AS type_2 ,
t0 . characteristic_type AS characteristic_type_3 ,
t0 . alias AS alias_4 ,
t0 . code AS code_5 ,
t0 . mpn_code AS mpn_code_6 ,
t0 . ean_code AS ean_code_7 ,
t0 . iean_code AS iean_code_8 ,
t0 . sean_code AS sean_code_9 ,
t0 . is_iean_print AS is_iean_print_10 ,
t0 . is_cean_print AS is_cean_print_11 ,
t0 . is_sean_print AS is_sean_print_12 ,
t0 . sean AS sean_13 ,
t0 . org_supplier_id AS org_supplier_id_14 ,
t0 . price AS price_15 ,
t0 . price_gross AS price_gross_16 ,
t0 . msrp AS msrp_17 ,
t0 . distri_price AS distri_price_18 ,
t0 . stock_item_value AS stock_item_value_19 ,
t0 . prefix AS prefix_20 ,
t0 . stock_place AS stock_place_21 ,
t0 . product_type AS product_type_22 ,
t0 . quantity AS quantity_23 ,
t0 . minimum_stock AS minimum_stock_24 ,
t0 . minimum_stock_status AS minimum_stock_status_25 ,
t0 . mins_last_status AS mins_last_status_26 ,
t0 . is_force_mins AS is_force_mins_27 ,
t0 . is_ds AS is_ds_28 ,
t0 . is_force_ds AS is_force_ds_29 ,
t0 . int_stockyard AS int_stockyard_30 ,
t0 . vct_stock_quantity AS vct_stock_quantity_31 ,
t0 . vct_stock_status AS vct_stock_status_32 ,
t0 . expected_delivery_date AS expected_delivery_date_33 ,
t0 . seller_item_id AS seller_item_id_34 ,
t0 . other_seller_item_id AS other_seller_item_id_35 ,
t0 . other_supplier_id AS other_supplier_id_36 ,
t0 . manufacturer_suggested_retail_price AS manufacturer_suggested_retail_price_37 ,
t0 . cost_price AS cost_price_38 ,
t0 . abroad_base_price AS abroad_base_price_39 ,
t0 . base_price AS base_price_40 ,
t0 . item_discount AS item_discount_41 ,
t0 . purchase_price AS purchase_price_42 ,
t0 . returnable AS returnable_43 ,
t0 . supplier_tax_category AS supplier_tax_category_44 ,
t0 . stock_shelf AS stock_shelf_45 ,
t0 . shelf_place AS shelf_place_46 ,
t0 . extra_charge AS extra_charge_47 ,
t0 . session_id AS session_id_48 ,
t0 . ip AS ip_49 ,
t0 . sort_order AS sort_order_50 ,
t0 . profit AS profit_51 ,
t0 . margin AS margin_52 ,
t0 . b2b_profit AS b2b_profit_53 ,
t0 . b2b_margin AS b2b_margin_54 ,
t0 . deleted AS deleted_55 ,
t0 . status AS status_56 ,
t0 . manual_status AS manual_status_57 ,
t0 . is_manual_status AS is_manual_status_58 ,
t0 . display_stock_report AS display_stock_report_59 ,
t0 . publish_date AS publish_date_60 ,
t0 . expire_date AS expire_date_61 ,
t0 . is_unite AS is_unite_62 ,
t0 . supplier_cart_id AS supplier_cart_id_63 ,
t0 . created_at AS created_at_64 ,
t0 . updated_at AS updated_at_65 ,
t0 . product_id AS product_id_66 ,
t0 . child_product_id AS child_product_id_67 ,
t0 . child_product_attribute_id AS child_product_attribute_id_68 ,
t0 . stock_indicators_id AS stock_indicators_id_69 ,
t0 . category_product_characteristic_id AS category_product_characteristic_id_70 ,
t0 . category_product_characteristic_value_id AS category_product_characteristic_value_id_71 ,
t0 . supplier_id AS supplier_id_72 ,
t0 . return_rule_id AS return_rule_id_73
FROM
product_attribute t0
WHERE
t0 . id = ?
Copy
SELECT t0 . id AS id_1 , t0 . type AS type_2 , t0 . characteristic_type AS characteristic_type_3 , t0 . alias AS alias_4 , t0 . code AS code_5 , t0 . mpn_code AS mpn_code_6 , t0 . ean_code AS ean_code_7 , t0 . iean_code AS iean_code_8 , t0 . sean_code AS sean_code_9 , t0 . is_iean_print AS is_iean_print_10 , t0 . is_cean_print AS is_cean_print_11 , t0 . is_sean_print AS is_sean_print_12 , t0 . sean AS sean_13 , t0 . org_supplier_id AS org_supplier_id_14 , t0 . price AS price_15 , t0 . price_gross AS price_gross_16 , t0 . msrp AS msrp_17 , t0 . distri_price AS distri_price_18 , t0 . stock_item_value AS stock_item_value_19 , t0 . prefix AS prefix_20 , t0 . stock_place AS stock_place_21 , t0 . product_type AS product_type_22 , t0 . quantity AS quantity_23 , t0 . minimum_stock AS minimum_stock_24 , t0 . minimum_stock_status AS minimum_stock_status_25 , t0 . mins_last_status AS mins_last_status_26 , t0 . is_force_mins AS is_force_mins_27 , t0 . is_ds AS is_ds_28 , t0 . is_force_ds AS is_force_ds_29 , t0 . int_stockyard AS int_stockyard_30 , t0 . vct_stock_quantity AS vct_stock_quantity_31 , t0 . vct_stock_status AS vct_stock_status_32 , t0 . expected_delivery_date AS expected_delivery_date_33 , t0 . seller_item_id AS seller_item_id_34 , t0 . other_seller_item_id AS other_seller_item_id_35 , t0 . other_supplier_id AS other_supplier_id_36 , t0 . manufacturer_suggested_retail_price AS manufacturer_suggested_retail_price_37 , t0 . cost_price AS cost_price_38 , t0 . abroad_base_price AS abroad_base_price_39 , t0 . base_price AS base_price_40 , t0 . item_discount AS item_discount_41 , t0 . purchase_price AS purchase_price_42 , t0 . returnable AS returnable_43 , t0 . supplier_tax_category AS supplier_tax_category_44 , t0 . stock_shelf AS stock_shelf_45 , t0 . shelf_place AS shelf_place_46 , t0 . extra_charge AS extra_charge_47 , t0 . session_id AS session_id_48 , t0 . ip AS ip_49 , t0 . sort_order AS sort_order_50 , t0 . profit AS profit_51 , t0 . margin AS margin_52 , t0 . b2b_profit AS b2b_profit_53 , t0 . b2b_margin AS b2b_margin_54 , t0 . deleted AS deleted_55 , t0 . status AS status_56 , t0 . manual_status AS manual_status_57 , t0 . is_manual_status AS is_manual_status_58 , t0 . display_stock_report AS display_stock_report_59 , t0 . publish_date AS publish_date_60 , t0 . expire_date AS expire_date_61 , t0 . is_unite AS is_unite_62 , t0 . supplier_cart_id AS supplier_cart_id_63 , t0 . created_at AS created_at_64 , t0 . updated_at AS updated_at_65 , t0 . product_id AS product_id_66 , t0 . child_product_id AS child_product_id_67 , t0 . child_product_attribute_id AS child_product_attribute_id_68 , t0 . stock_indicators_id AS stock_indicators_id_69 , t0 . category_product_characteristic_id AS category_product_characteristic_id_70 , t0 . category_product_characteristic_value_id AS category_product_characteristic_value_id_71 , t0 . supplier_id AS supplier_id_72 , t0 . return_rule_id AS return_rule_id_73 FROM product_attribute t0 WHERE t0 . id = 1158418 ;
Copy
49
0.12 ms
SELECT p0_ . id AS id_0 FROM product_attribute p0_ WHERE p0_ . product_id = ? AND p0_ . deleted = 0 AND p0_ . status = 1 AND p0_ . characteristic_type = ? ORDER BY p0_ . sort_order ASC
Parameters :
[
15997
"product_option "
]
SELECT p0_ . id AS id_0 FROM product_attribute p0_ WHERE p0_ . product_id = 15997 AND p0_ . deleted = 0 AND p0_ . status = 1 AND p0_ . characteristic_type = 'product_option' ORDER BY p0_ . sort_order ASC ;
Copy
50
0.13 ms
SELECT t0 . id AS id_1 , t0 . product_option AS product_option_2 , t0 . filter_navigation AS filter_navigation_3 , t0 . tech_specification AS tech_specification_4 , t0 . display_front AS display_front_5 , t0 . ecp AS ecp_6 , t0 . product_option_sort_order AS product_option_sort_order_7 , t0 . tech_specification_sort_order AS tech_specification_sort_order_8 , t0 . created_at AS created_at_9 , t0 . updated_at AS updated_at_10 , t0 . product_id AS product_id_11 , t0 . category_product_characteristic_id AS category_product_characteristic_id_12 FROM product_attribute_options t0 WHERE t0 . product_id = ? AND t0 . product_option = ? ORDER BY t0 . product_option_sort_order ASC
SELECT t0 . id AS id_1 , t0 . product_option AS product_option_2 , t0 . filter_navigation AS filter_navigation_3 , t0 . tech_specification AS tech_specification_4 , t0 . display_front AS display_front_5 , t0 . ecp AS ecp_6 , t0 . product_option_sort_order AS product_option_sort_order_7 , t0 . tech_specification_sort_order AS tech_specification_sort_order_8 , t0 . created_at AS created_at_9 , t0 . updated_at AS updated_at_10 , t0 . product_id AS product_id_11 , t0 . category_product_characteristic_id AS category_product_characteristic_id_12 FROM product_attribute_options t0 WHERE t0 . product_id = 15997 AND t0 . product_option = 1 ORDER BY t0 . product_option_sort_order ASC ;
Copy
51
0.14 ms
SELECT c0_ . id AS id_0 , c0_ . product_id AS product_id_1 , c0_ . product_attribute_id AS product_attribute_id_2 , c0_ . category_product_characteristic_id AS category_product_characteristic_id_3 , c0_ . category_product_characteristic_value_id AS category_product_characteristic_value_id_4 FROM child_product_characteristic_value c0_ WHERE c0_ . product_attribute_id IN (1158418 , 1158419 ) AND c0_ . category_product_characteristic_id IN (495 )
SELECT c0_ . id AS id_0 , c0_ . product_id AS product_id_1 , c0_ . product_attribute_id AS product_attribute_id_2 , c0_ . category_product_characteristic_id AS category_product_characteristic_id_3 , c0_ . category_product_characteristic_value_id AS category_product_characteristic_value_id_4 FROM child_product_characteristic_value c0_ WHERE c0_ . product_attribute_id IN (1158418 , 1158419 ) AND c0_ . category_product_characteristic_id IN (495 );
Copy
52
0.11 ms
SELECT t0 . id AS id_1 , t0 . type AS type_2 , t0 . product_option AS product_option_3 , t0 . filter_navigation AS filter_navigation_4 , t0 . tech_specification AS tech_specification_5 , t0 . status AS status_6 , t0 . sort_order AS sort_order_7 , t0 . product_option_sort_order AS product_option_sort_order_8 , t0 . filter_navigation_sort_order AS filter_navigation_sort_order_9 , t0 . tech_specification_sort_order AS tech_specification_sort_order_10 , t0 . product_specific_option AS product_specific_option_11 , t0 . product_specific_tech_spec AS product_specific_tech_spec_12 , t0 . value_sorting_type AS value_sorting_type_13 , t0 . created_at AS created_at_14 , t0 . updated_at AS updated_at_15 , t0 . category_id AS category_id_16 , t0 . product_characteristic_id AS product_characteristic_id_17 , t0 . product_id AS product_id_18 , t0 . configure_product_id AS configure_product_id_19 FROM category_product_characteristic t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . type AS type_2 , t0 . product_option AS product_option_3 , t0 . filter_navigation AS filter_navigation_4 , t0 . tech_specification AS tech_specification_5 , t0 . status AS status_6 , t0 . sort_order AS sort_order_7 , t0 . product_option_sort_order AS product_option_sort_order_8 , t0 . filter_navigation_sort_order AS filter_navigation_sort_order_9 , t0 . tech_specification_sort_order AS tech_specification_sort_order_10 , t0 . product_specific_option AS product_specific_option_11 , t0 . product_specific_tech_spec AS product_specific_tech_spec_12 , t0 . value_sorting_type AS value_sorting_type_13 , t0 . created_at AS created_at_14 , t0 . updated_at AS updated_at_15 , t0 . category_id AS category_id_16 , t0 . product_characteristic_id AS product_characteristic_id_17 , t0 . product_id AS product_id_18 , t0 . configure_product_id AS configure_product_id_19 FROM category_product_characteristic t0 WHERE t0 . id = 495 ;
Copy
53
0.07 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 FROM product_characteristic t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 FROM product_characteristic t0 WHERE t0 . id = 107 ;
Copy
54
0.09 ms
SELECT t0 . id AS id_1 , t0 . product_specific_option_value AS product_specific_option_value_2 , t0 . product_filter_specific_option_value AS product_filter_specific_option_value_3 , t0 . product_tech_specific_option_value AS product_tech_specific_option_value_4 , t0 . sort_order AS sort_order_5 , t0 . created_at AS created_at_6 , t0 . updated_at AS updated_at_7 , t0 . category_product_characteristic_id AS category_product_characteristic_id_8 , t0 . product_characteristic_value_id AS product_characteristic_value_id_9 FROM category_product_characteristic_value t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . product_specific_option_value AS product_specific_option_value_2 , t0 . product_filter_specific_option_value AS product_filter_specific_option_value_3 , t0 . product_tech_specific_option_value AS product_tech_specific_option_value_4 , t0 . sort_order AS sort_order_5 , t0 . created_at AS created_at_6 , t0 . updated_at AS updated_at_7 , t0 . category_product_characteristic_id AS category_product_characteristic_id_8 , t0 . product_characteristic_value_id AS product_characteristic_value_id_9 FROM category_product_characteristic_value t0 WHERE t0 . id = 2806 ;
Copy
55
0.07 ms
SELECT t0 . id AS id_1 , t0 . value AS value_2 , t0 . product_characteristic_id AS product_characteristic_id_3 FROM product_characteristic_value t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . value AS value_2 , t0 . product_characteristic_id AS product_characteristic_id_3 FROM product_characteristic_value t0 WHERE t0 . id = 2221 ;
Copy
56
0.08 ms
SELECT t0 . id AS id_1 , t0 . product_specific_option_value AS product_specific_option_value_2 , t0 . product_filter_specific_option_value AS product_filter_specific_option_value_3 , t0 . product_tech_specific_option_value AS product_tech_specific_option_value_4 , t0 . sort_order AS sort_order_5 , t0 . created_at AS created_at_6 , t0 . updated_at AS updated_at_7 , t0 . category_product_characteristic_id AS category_product_characteristic_id_8 , t0 . product_characteristic_value_id AS product_characteristic_value_id_9 FROM category_product_characteristic_value t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . product_specific_option_value AS product_specific_option_value_2 , t0 . product_filter_specific_option_value AS product_filter_specific_option_value_3 , t0 . product_tech_specific_option_value AS product_tech_specific_option_value_4 , t0 . sort_order AS sort_order_5 , t0 . created_at AS created_at_6 , t0 . updated_at AS updated_at_7 , t0 . category_product_characteristic_id AS category_product_characteristic_id_8 , t0 . product_characteristic_value_id AS product_characteristic_value_id_9 FROM category_product_characteristic_value t0 WHERE t0 . id = 2807 ;
Copy
57
0.07 ms
SELECT t0 . id AS id_1 , t0 . value AS value_2 , t0 . product_characteristic_id AS product_characteristic_id_3 FROM product_characteristic_value t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . value AS value_2 , t0 . product_characteristic_id AS product_characteristic_id_3 FROM product_characteristic_value t0 WHERE t0 . id = 2222 ;
Copy
58
0.09 ms
SELECT t0 . id AS id_1 , t0 . cover AS cover_2 , t0 . badge_color AS badge_color_3 , t0 . product_id AS product_id_4 , t0 . product_media_id AS product_media_id_5 , t0 . category_product_characteristic_value_id AS category_product_characteristic_value_id_6 FROM product_attribute_image t0 WHERE t0 . product_id = ? AND t0 . cover = ?
SELECT t0 . id AS id_1 , t0 . cover AS cover_2 , t0 . badge_color AS badge_color_3 , t0 . product_id AS product_id_4 , t0 . product_media_id AS product_media_id_5 , t0 . category_product_characteristic_value_id AS category_product_characteristic_value_id_6 FROM product_attribute_image t0 WHERE t0 . product_id = 15997 AND t0 . cover = 1 ;
Copy
59
0.12 ms
SELECT t0 . id AS id_1 , t0 . session_id AS session_id_2 , t0 . ip AS ip_3 , t0 . is_save AS is_save_4 , t0 . file AS file_5 , t0 . type AS type_6 , t0 . caption AS caption_7 , t0 . description AS description_8 , t0 . is_main_image AS is_main_image_9 , t0 . cover AS cover_10 , t0 . status AS status_11 , t0 . sort_order AS sort_order_12 , t0 . created_at AS created_at_13 , t0 . updated_at AS updated_at_14 , t0 . product_id AS product_id_15 FROM product_media t0 WHERE t0 . product_id = ? AND t0 . cover = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . session_id AS session_id_2 , t0 . ip AS ip_3 , t0 . is_save AS is_save_4 , t0 . file AS file_5 , t0 . type AS type_6 , t0 . caption AS caption_7 , t0 . description AS description_8 , t0 . is_main_image AS is_main_image_9 , t0 . cover AS cover_10 , t0 . status AS status_11 , t0 . sort_order AS sort_order_12 , t0 . created_at AS created_at_13 , t0 . updated_at AS updated_at_14 , t0 . product_id AS product_id_15 FROM product_media t0 WHERE t0 . product_id = 15997 AND t0 . cover = 1 LIMIT 1 ;
Copy
60
0.11 ms
SELECT t0 . id AS id_1 , t0 . session_id AS session_id_2 , t0 . ip AS ip_3 , t0 . price_mode AS price_mode_4 , t0 . discount_rate AS discount_rate_5 , t0 . price AS price_6 , t0 . net_price AS net_price_7 , t0 . start_date AS start_date_8 , t0 . expire_date AS expire_date_9 , t0 . status AS status_10 , t0 . created_at AS created_at_11 , t0 . updated_at AS updated_at_12 , t0 . product_id AS product_id_13 , t0 . currency_id AS currency_id_14 , t0 . product_attribute_id AS product_attribute_id_15 , t0 . supplier_product_id AS supplier_product_id_16 , t0 . tax_id AS tax_id_17 FROM special_price t0 WHERE t0 . product_id = ? AND t0 . product_attribute_id = ? AND t0 . status = ? ORDER BY t0 . id DESC LIMIT 1
Parameters :
[
15997
1158418
1
]
SELECT t0 . id AS id_1 , t0 . session_id AS session_id_2 , t0 . ip AS ip_3 , t0 . price_mode AS price_mode_4 , t0 . discount_rate AS discount_rate_5 , t0 . price AS price_6 , t0 . net_price AS net_price_7 , t0 . start_date AS start_date_8 , t0 . expire_date AS expire_date_9 , t0 . status AS status_10 , t0 . created_at AS created_at_11 , t0 . updated_at AS updated_at_12 , t0 . product_id AS product_id_13 , t0 . currency_id AS currency_id_14 , t0 . product_attribute_id AS product_attribute_id_15 , t0 . supplier_product_id AS supplier_product_id_16 , t0 . tax_id AS tax_id_17 FROM special_price t0 WHERE t0 . product_id = 15997 AND t0 . product_attribute_id = 1158418 AND t0 . status = 1 ORDER BY t0 . id DESC LIMIT 1 ;
Copy
61
0.12 ms
SELECT t0 . id AS id_1 , t0 . created_at AS created_at_2 , t0 . updated_at AS updated_at_3 , t0 . fos_user_id AS fos_user_id_4 FROM cart t0 WHERE t0 . fos_user_id = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . created_at AS created_at_2 , t0 . updated_at AS updated_at_3 , t0 . fos_user_id AS fos_user_id_4 FROM cart t0 WHERE t0 . fos_user_id = 9452 LIMIT 1 ;
Copy
62
0.12 ms
SELECT t0 . id AS id_1 , t0 . price AS price_2 , t0 . reguler_price AS reguler_price_3 , t0 . quantity AS quantity_4 , t0 . image AS image_5 , t0 . ds_fee AS ds_fee_6 , t0 . supplier_id AS supplier_id_7 , t0 . created_at AS created_at_8 , t0 . updated_at AS updated_at_9 , t0 . cart_id AS cart_id_10 , t0 . product_id AS product_id_11 FROM cart_products t0 WHERE t0 . cart_id = ?
SELECT t0 . id AS id_1 , t0 . price AS price_2 , t0 . reguler_price AS reguler_price_3 , t0 . quantity AS quantity_4 , t0 . image AS image_5 , t0 . ds_fee AS ds_fee_6 , t0 . supplier_id AS supplier_id_7 , t0 . created_at AS created_at_8 , t0 . updated_at AS updated_at_9 , t0 . cart_id AS cart_id_10 , t0 . product_id AS product_id_11 FROM cart_products t0 WHERE t0 . cart_id = 228 ;
Copy