Термос Li-Ning AQTR024

0.003661s
DELETE FROM oc_cart WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB('2025-07-04 06:58:47', INTERVAL 30 DAY)

0.003164s
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2025-07-04 06:58:47') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-07-04 06:58:47')) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2025-07-04 06:58:47') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-07-04 06:58:47')) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '2564' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-07-04 06:58:47' AND p2s.store_id = '0'

0.001557s
SELECT * FROM oc_product_option_value pov LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id) LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id) WHERE pov.product_id = '2564' AND pov.product_option_id = '1511432' AND ovd.language_id = '1' ORDER BY ov.sort_order

0.001483s
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '2564' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

0.001359s
SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2025-07-04 06:58:48') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-07-04 06:58:48')) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < '2025-07-04 06:58:48') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-07-04 06:58:48')) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '2564' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-07-04 06:58:48' AND p2s.store_id = '0'

0.001055s
SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '2564' AND od.language_id = '1' ORDER BY o.sort_order

0.000897s
UPDATE oc_product SET viewed = (viewed + 1) WHERE product_id = '2564'

0.000880s
SELECT * FROM oc_product_image WHERE product_id = '2564' ORDER BY sort_order ASC

0.000767s
SHOW COLUMNS FROM `oc_socnetauth2_customer2account`

0.000752s
SELECT * FROM oc_product_tab pt LEFT JOIN oc_product_tab_desc ptd ON(pt.product_tab_id = ptd.product_tab_id) WHERE pt.product_id = 2564 AND ptd.language_id = '1' AND pt.status = 1 ORDER BY sort_order ASC

0.000727s
SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '2564' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name

0.000645s
SHOW COLUMNS FROM oc_product_to_category;

0.000638s
SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '2564' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name

0.000567s
SELECT * FROM oc_product_discount WHERE product_id = '2564' AND customer_group_id = '1' AND quantity > 1 AND ((date_start = '0000-00-00' OR date_start < '2025-07-04 06:58:47') AND (date_end = '0000-00-00' OR date_end > '2025-07-04 06:58:47')) ORDER BY quantity ASC, priority ASC, price ASC

0.000561s
SELECT COUNT(DISTINCT p.article_id) AS total FROM oc_article p LEFT JOIN oc_article_description pd ON (p.article_id = pd.article_id) LEFT JOIN oc_article_to_store p2s ON (p.article_id = p2s.article_id) LEFT JOIN oc_article_to_blog_category p2c ON (p.article_id = p2c.article_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.blog_category_id = '0'

0.000512s
SHOW COLUMNS FROM `oc_socnetauth2_customer2account`

0.000461s
SELECT * FROM oc_product_related pr LEFT JOIN oc_product p ON (pr.related_id = p.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pr.product_id = '2564' AND p.status = '1' AND p.date_available <= '2025-07-04 06:58:47' AND p2s.store_id = '0'

0.000447s
SELECT ROVP.* FROM `oc_relatedoptions_variant_product` ROVP LEFT JOIN `oc_relatedoptions_variant` ROV ON (ROVP.relatedoptions_variant_id = ROV.relatedoptions_variant_id) WHERE ROVP.product_id = 2564 AND ROVP.relatedoptions_use = 1 ORDER BY ROV.sort_order, ROV.relatedoptions_variant_name, ROVP.relatedoptions_variant_id, ROVP.relatedoptions_variant_product_id

0.000436s
SHOW COLUMNS FROM `oc_socnetauth2_customer2account`

0.000402s
SELECT COUNT(DISTINCT p.article_id) AS total FROM oc_article p LEFT JOIN oc_article_description pd ON (p.article_id = pd.article_id) LEFT JOIN oc_article_to_store p2s ON (p.article_id = p2s.article_id) LEFT JOIN oc_article_to_blog_category p2c ON (p.article_id = p2c.article_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.blog_category_id = '0'

0.000337s
UPDATE `oc_socnetauth2_customer2account` SET code = '' WHERE DATE_ADD(mdate, INTERVAL 15 MINUTE)<NOW()

0.000333s
UPDATE `oc_socnetauth2_customer2account` SET code = '' WHERE DATE_ADD(mdate, INTERVAL 15 MINUTE)<NOW()

0.000315s
SHOW COLUMNS FROM `oc_socnetauth2_customer2account`

0.000309s
SHOW COLUMNS FROM `oc_socnetauth2_customer2account`

0.000309s
SHOW COLUMNS FROM `oc_socnetauth2_customer2account`

0.000286s
SELECT * FROM oc_cart WHERE customer_id = '0' AND session_id = '9d642b3fef160cf9352e46f8941319f0'

0.000284s
UPDATE `oc_socnetauth2_customer2account` SET code = '' WHERE DATE_ADD(mdate, INTERVAL 15 MINUTE)<NOW()

0.000272s
SELECT * FROM oc_product_to_category WHERE product_id = '2564'

0.000270s
SELECT COUNT(DISTINCT p.article_id) AS total FROM oc_article p LEFT JOIN oc_article_description pd ON (p.article_id = pd.article_id) LEFT JOIN oc_article_to_store p2s ON (p.article_id = p2s.article_id) LEFT JOIN oc_article_to_blog_category p2c ON (p.article_id = p2c.article_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.blog_category_id = '0'

0.000236s
SELECT * FROM oc_product_to_layout WHERE product_id = '2564' AND store_id = '0'

0.000228s
SELECT category_id FROM oc_product_to_category WHERE product_id = '2564' AND main_category = '1'

0.000223s
SELECT rd.* FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id WHERE pr.product_id = 2564 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC

0.000208s
SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '9d642b3fef160cf9352e46f8941319f0'

0.000110s
SELECT `model_synonym` FROM `oc_product` WHERE `product_id`=2564;

0.000101s
SELECT `id` FROM `oc_seo_tags_generator_not_use` WHERE `id` = '2564' AND `essence_id` = '1'