1 (0.152)
SELECT *
FROM omdv_store
WHERE REPLACE(`url`, 'www.', '') = 'http://777dveri.ru/'
/home/c/cg22734/public_html/index.php:59
2 (1.517)
SELECT *
FROM omdv_setting
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC
/home/c/cg22734/public_html/index.php:69
3 (0.174)
SELECT *
FROM `omdv_language`
WHERE status = '1'
/home/c/cg22734/public_html/index.php:148
4 (0.173)
SELECT *
FROM omdv_currency
/home/c/cg22734/public_html/system/library/currency.php:13
5 (0.230)
SELECT *
FROM omdv_weight_class wc
LEFT JOIN omdv_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id)
WHERE wcd.language_id = '1'
/home/c/cg22734/public_html/system/library/weight.php:9
6 (0.194)
SELECT *
FROM omdv_length_class mc
LEFT JOIN omdv_length_class_description mcd ON (mc.length_class_id = mcd.length_class_id)
WHERE mcd.language_id = '1'
/home/c/cg22734/public_html/system/library/length.php:9
7 (0.503)
SELECT DISTINCT *
FROM omdv_manufacturer m
LEFT JOIN omdv_manufacturer_description md ON (m.manufacturer_id = md.manufacturer_id)
LEFT JOIN omdv_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '14' AND md.language_id = '1' AND m2s.store_id = '0'
/home/c/cg22734/public_html/catalog/model/catalog/manufacturer.php:4
8 (4.747)
SELECT DISTINCT SQL_CALC_FOUND_ROWS p.product_id, (SELECT AVG(rating) AS total
FROM omdv_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price
FROM omdv_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-02-11 04:34:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-02-11 04:34:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM omdv_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-02-11 04:34:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-02-11 04:34:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special
FROM omdv_product p
LEFT JOIN omdv_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN omdv_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-02-11 04:34:00' AND p2s.store_id = '0' AND p.manufacturer_id = '14' GROUP BY p.product_id
ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,36
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:255
9 (0.068)
SELECT FOUND_ROWS() AS `found_rows`
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:257
10 (2.586)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_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-02-11 04:34:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-02-11 04:34:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM omdv_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-02-11 04:34:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-02-11 04:34:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM omdv_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM omdv_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM omdv_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 omdv_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 omdv_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 omdv_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM omdv_product p
LEFT JOIN omdv_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN omdv_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN omdv_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '322' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-02-11 04:34:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
11 (2.632)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_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-02-11 04:34:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-02-11 04:34:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM omdv_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-02-11 04:34:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-02-11 04:34:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM omdv_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM omdv_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM omdv_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 omdv_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 omdv_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 omdv_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM omdv_product p
LEFT JOIN omdv_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN omdv_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN omdv_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '333' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-02-11 04:34:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
12 (2.620)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_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-02-11 04:34:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-02-11 04:34:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM omdv_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-02-11 04:34:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-02-11 04:34:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM omdv_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM omdv_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM omdv_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 omdv_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 omdv_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 omdv_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM omdv_product p
LEFT JOIN omdv_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN omdv_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN omdv_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '328' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-02-11 04:34:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
13 (0.429)
SELECT s.*, ps.product_show, ps.category_show, ps.sort_order, ps.product_id
FROM omdv_product_status ps
LEFT JOIN omdv_status s ON ps.status_id = s.status_id
WHERE s.language_id = '1' AND ps.product_id = '328'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
14 (0.554)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
15 (0.166)
SELECT *
FROM omdv_status_attribute
WHERE status_id = 21 AND attribute_id = 73
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:360
16 (0.145)
SELECT *
FROM omdv_status_attribute
WHERE status_id = 30 AND attribute_id = 48
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:360
17 (0.127)
SELECT *
FROM omdv_status_attribute
WHERE status_id = 31 AND attribute_id = 48
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:360
18 (0.133)
SELECT *
FROM omdv_status_attribute
WHERE status_id = 32 AND attribute_id = 48
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:360
19 (0.154)
SELECT *
FROM omdv_status_attribute
WHERE status_id = 33 AND attribute_id = 48
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:360
20 (0.140)
SELECT *
FROM omdv_status_attribute
WHERE status_id = 34 AND attribute_id = 48
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:360
21 (0.125)
SELECT *
FROM omdv_status_attribute
WHERE status_id = 35 AND attribute_id = 113
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:360
22 (0.131)
SELECT *
FROM omdv_status_attribute
WHERE status_id = 38 AND attribute_id = 19
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:360
23 (0.142)
SELECT *
FROM omdv_status_attribute
WHERE status_id = 39 AND attribute_id = 19
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:360
24 (0.129)
SELECT *
FROM omdv_status_attribute
WHERE status_id = 40 AND attribute_id = 19
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:360
25 (0.135)
SELECT *
FROM omdv_status_attribute
WHERE status_id = 42 AND attribute_id = 19
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:360
26 (0.136)
SELECT *
FROM omdv_status_attribute
WHERE status_id = 43 AND attribute_id = 48
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:360
27 (0.129)
SELECT *
FROM omdv_status_attribute
WHERE status_id = 44 AND attribute_id = 48
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:360
28 (0.139)
SELECT *
FROM omdv_status_attribute
WHERE status_id = 45 AND attribute_id = 48
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:360
29 (0.132)
SELECT *
FROM omdv_status_attribute
WHERE status_id = 46 AND attribute_id = 48
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:360
30 (0.233)
SELECT COUNT(*) as promotion_count
FROM information_schema.tables
WHERE table_schema = DATABASE()
AND table_name = 'omdv_promotion'
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:382
31 (0.516)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '328' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
32 (0.471)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '328' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
33 (0.361)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '328' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
34 (0.147)
SELECT *
FROM omdv_product_to_category
WHERE product_id = '328'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:516
35 (0.318)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '328' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
36 (0.326)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '328' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
37 (0.305)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '328' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
38 (0.291)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '328' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
39 (0.334)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '328' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
40 (0.289)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '328' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
41 (0.289)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '328' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
42 (0.318)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '328' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
43 (0.286)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '328' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
44 (0.294)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '328' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
45 (0.316)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '328' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
46 (0.304)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '328' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
47 (0.289)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '328' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
48 (0.317)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '328' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
49 (0.287)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '328' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
50 (0.291)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '328' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
51 (0.348)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '328' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
52 (0.295)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '328' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
53 (0.320)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '328' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
54 (0.340)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '328' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
55 (0.322)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '328' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
56 (0.319)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '328' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
57 (0.341)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '328' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
58 (0.347)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '328' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
59 (0.318)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '328' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
60 (0.336)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '328' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
61 (0.321)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '328' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
62 (0.325)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '328' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
63 (0.337)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '328' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
64 (0.323)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '328' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
65 (0.318)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '328' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
66 (0.341)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '328' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
67 (0.321)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '328' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
68 (0.295)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '328' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
69 (0.361)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '328' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
70 (0.331)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '328' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
71 (0.320)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '328' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
72 (0.341)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '328' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
73 (0.326)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '328' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
74 (0.318)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '328' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
75 (0.350)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '328' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
76 (0.322)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '328' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
77 (2.622)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_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-02-11 04:34:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-02-11 04:34:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM omdv_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-02-11 04:34:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-02-11 04:34:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM omdv_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM omdv_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM omdv_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 omdv_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 omdv_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 omdv_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM omdv_product p
LEFT JOIN omdv_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN omdv_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN omdv_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '329' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-02-11 04:34:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
78 (2.672)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_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-02-11 04:34:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-02-11 04:34:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM omdv_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-02-11 04:34:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-02-11 04:34:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM omdv_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM omdv_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM omdv_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 omdv_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 omdv_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 omdv_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM omdv_product p
LEFT JOIN omdv_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN omdv_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN omdv_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '5765' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-02-11 04:34:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
79 (2.670)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_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-02-11 04:34:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-02-11 04:34:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM omdv_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-02-11 04:34:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-02-11 04:34:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM omdv_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM omdv_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM omdv_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 omdv_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 omdv_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 omdv_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM omdv_product p
LEFT JOIN omdv_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN omdv_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN omdv_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '330' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-02-11 04:34:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
80 (2.688)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_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-02-11 04:34:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-02-11 04:34:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM omdv_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-02-11 04:34:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-02-11 04:34:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM omdv_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM omdv_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM omdv_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 omdv_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 omdv_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 omdv_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM omdv_product p
LEFT JOIN omdv_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN omdv_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN omdv_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1680' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-02-11 04:34:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
81 (2.662)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_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-02-11 04:34:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-02-11 04:34:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM omdv_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-02-11 04:34:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-02-11 04:34:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM omdv_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM omdv_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM omdv_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 omdv_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 omdv_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 omdv_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM omdv_product p
LEFT JOIN omdv_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN omdv_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN omdv_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1682' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-02-11 04:34:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
82 (2.834)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_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-02-11 04:34:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-02-11 04:34:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM omdv_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-02-11 04:34:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-02-11 04:34:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM omdv_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM omdv_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM omdv_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 omdv_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 omdv_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 omdv_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM omdv_product p
LEFT JOIN omdv_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN omdv_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN omdv_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1683' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-02-11 04:34:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
83 (0.536)
SELECT s.*, ps.product_show, ps.category_show, ps.sort_order, ps.product_id
FROM omdv_product_status ps
LEFT JOIN omdv_status s ON ps.status_id = s.status_id
WHERE s.language_id = '1' AND ps.product_id = '1683'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
84 (0.470)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '1683' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
85 (0.481)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '1683' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
86 (0.348)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '1683' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
87 (0.130)
SELECT *
FROM omdv_product_to_category
WHERE product_id = '1683'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:516
88 (0.337)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '1683' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
89 (0.371)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '1683' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
90 (0.343)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '1683' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
91 (0.329)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '1683' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
92 (0.364)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '1683' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
93 (0.329)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '1683' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
94 (0.305)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '1683' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
95 (0.361)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '1683' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
96 (0.392)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '1683' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
97 (0.340)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '1683' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
98 (0.383)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '1683' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
99 (0.359)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '1683' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
100 (0.322)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '1683' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
101 (0.353)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '1683' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
102 (0.321)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '1683' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
103 (0.322)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '1683' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
104 (0.327)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '1683' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
105 (0.334)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '1683' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
106 (0.319)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '1683' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
107 (0.351)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '1683' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
108 (0.319)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '1683' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
109 (0.324)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '1683' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
110 (0.341)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '1683' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
111 (0.320)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '1683' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
112 (0.319)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '1683' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
113 (0.344)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '1683' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
114 (0.319)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '1683' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
115 (0.302)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '1683' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
116 (0.365)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '1683' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
117 (0.328)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '1683' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
118 (0.324)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '1683' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
119 (0.342)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '1683' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
120 (0.321)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '1683' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
121 (0.354)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '1683' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
122 (0.347)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '1683' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
123 (0.321)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '1683' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
124 (0.324)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '1683' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
125 (0.340)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '1683' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
126 (0.294)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '1683' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
127 (0.341)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '1683' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
128 (0.343)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '1683' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
129 (0.327)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '1683' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
130 (2.664)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_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-02-11 04:34:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-02-11 04:34:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM omdv_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-02-11 04:34:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-02-11 04:34:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM omdv_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM omdv_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM omdv_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 omdv_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 omdv_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 omdv_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM omdv_product p
LEFT JOIN omdv_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN omdv_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN omdv_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '8362' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-02-11 04:34:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
131 (2.748)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_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-02-11 04:34:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-02-11 04:34:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM omdv_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-02-11 04:34:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-02-11 04:34:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM omdv_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM omdv_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM omdv_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 omdv_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 omdv_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 omdv_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM omdv_product p
LEFT JOIN omdv_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN omdv_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN omdv_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1677' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-02-11 04:34:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
132 (2.825)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_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-02-11 04:34:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-02-11 04:34:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM omdv_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-02-11 04:34:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-02-11 04:34:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM omdv_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM omdv_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM omdv_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 omdv_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 omdv_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 omdv_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM omdv_product p
LEFT JOIN omdv_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN omdv_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN omdv_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1678' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-02-11 04:34:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
133 (4.001)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_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-02-11 04:34:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-02-11 04:34:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM omdv_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-02-11 04:34:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-02-11 04:34:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM omdv_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM omdv_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM omdv_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 omdv_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 omdv_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 omdv_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM omdv_product p
LEFT JOIN omdv_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN omdv_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN omdv_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1679' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-02-11 04:34:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
134 (2.591)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_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-02-11 04:34:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-02-11 04:34:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM omdv_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-02-11 04:34:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-02-11 04:34:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM omdv_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM omdv_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM omdv_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 omdv_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 omdv_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 omdv_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM omdv_product p
LEFT JOIN omdv_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN omdv_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN omdv_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '8617' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-02-11 04:34:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
135 (2.929)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_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-02-11 04:34:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-02-11 04:34:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM omdv_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-02-11 04:34:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-02-11 04:34:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM omdv_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM omdv_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM omdv_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 omdv_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 omdv_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 omdv_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM omdv_product p
LEFT JOIN omdv_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN omdv_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN omdv_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '5710' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-02-11 04:34:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
136 (2.697)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_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-02-11 04:34:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-02-11 04:34:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM omdv_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-02-11 04:34:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-02-11 04:34:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM omdv_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM omdv_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM omdv_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 omdv_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 omdv_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 omdv_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM omdv_product p
LEFT JOIN omdv_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN omdv_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN omdv_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '5706' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-02-11 04:34:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
137 (0.627)
SELECT s.*, ps.product_show, ps.category_show, ps.sort_order, ps.product_id
FROM omdv_product_status ps
LEFT JOIN omdv_status s ON ps.status_id = s.status_id
WHERE s.language_id = '1' AND ps.product_id = '5706'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
138 (0.506)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '5706' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
139 (0.491)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5706' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
140 (0.345)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5706' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
141 (0.136)
SELECT *
FROM omdv_product_to_category
WHERE product_id = '5706'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:516
142 (0.340)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '5706' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
143 (0.348)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5706' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
144 (0.405)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5706' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
145 (0.367)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '5706' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
146 (0.374)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5706' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
147 (0.362)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5706' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
148 (0.347)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '5706' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
149 (0.380)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5706' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
150 (0.367)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5706' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
151 (0.361)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '5706' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
152 (0.358)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5706' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
153 (0.310)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5706' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
154 (0.412)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '5706' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
155 (0.392)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5706' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
156 (0.343)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5706' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
157 (0.331)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '5706' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
158 (0.373)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5706' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
159 (0.353)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5706' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
160 (0.347)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '5706' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
161 (0.400)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5706' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
162 (0.328)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5706' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
163 (0.348)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '5706' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
164 (0.382)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5706' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
165 (0.329)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5706' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
166 (0.346)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '5706' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
167 (0.376)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5706' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
168 (0.318)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5706' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
169 (0.364)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '5706' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
170 (0.361)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5706' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
171 (0.329)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5706' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
172 (0.328)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '5706' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
173 (0.384)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5706' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
174 (0.345)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5706' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
175 (0.341)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '5706' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
176 (0.350)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5706' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
177 (0.322)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5706' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
178 (0.330)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '5706' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
179 (0.457)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5706' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
180 (0.383)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5706' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
181 (0.333)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '5706' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
182 (0.355)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5706' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
183 (0.329)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5706' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
184 (2.814)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_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-02-11 04:34:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-02-11 04:34:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM omdv_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-02-11 04:34:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-02-11 04:34:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM omdv_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM omdv_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM omdv_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 omdv_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 omdv_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 omdv_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM omdv_product p
LEFT JOIN omdv_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN omdv_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN omdv_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '5708' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-02-11 04:34:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
185 (2.706)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_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-02-11 04:34:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-02-11 04:34:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM omdv_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-02-11 04:34:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-02-11 04:34:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM omdv_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM omdv_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM omdv_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 omdv_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 omdv_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 omdv_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM omdv_product p
LEFT JOIN omdv_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN omdv_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN omdv_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '5717' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-02-11 04:34:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
186 (0.493)
SELECT s.*, ps.product_show, ps.category_show, ps.sort_order, ps.product_id
FROM omdv_product_status ps
LEFT JOIN omdv_status s ON ps.status_id = s.status_id
WHERE s.language_id = '1' AND ps.product_id = '5717'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
187 (0.917)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '5717' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
188 (0.549)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5717' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
189 (0.391)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5717' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
190 (0.135)
SELECT *
FROM omdv_product_to_category
WHERE product_id = '5717'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:516
191 (0.534)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '5717' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
192 (0.443)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5717' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
193 (0.392)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5717' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
194 (0.844)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '5717' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
195 (0.467)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5717' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
196 (0.393)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5717' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
197 (0.533)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '5717' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
198 (0.435)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5717' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
199 (0.357)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5717' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
200 (0.532)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '5717' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
201 (0.450)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5717' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
202 (0.360)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5717' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
203 (0.551)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '5717' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
204 (0.453)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5717' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
205 (0.513)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5717' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
206 (0.539)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '5717' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
207 (0.432)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5717' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
208 (0.358)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5717' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
209 (0.547)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '5717' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
210 (0.480)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5717' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
211 (0.382)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5717' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
212 (0.544)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '5717' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
213 (0.438)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5717' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
214 (0.360)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5717' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
215 (0.536)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '5717' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
216 (0.438)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5717' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
217 (0.361)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5717' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
218 (0.554)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '5717' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
219 (0.455)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5717' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
220 (0.374)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5717' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
221 (0.535)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '5717' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
222 (0.448)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5717' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
223 (0.371)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5717' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
224 (0.537)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '5717' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
225 (0.429)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5717' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
226 (0.407)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5717' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
227 (0.549)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '5717' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
228 (0.451)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5717' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
229 (0.367)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5717' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
230 (0.579)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '5717' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
231 (0.429)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5717' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
232 (0.453)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5717' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
233 (2.677)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_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-02-11 04:34:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-02-11 04:34:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM omdv_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-02-11 04:34:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-02-11 04:34:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM omdv_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM omdv_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM omdv_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 omdv_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 omdv_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 omdv_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM omdv_product p
LEFT JOIN omdv_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN omdv_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN omdv_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1402' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-02-11 04:34:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
234 (2.859)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_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-02-11 04:34:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-02-11 04:34:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM omdv_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-02-11 04:34:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-02-11 04:34:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM omdv_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM omdv_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM omdv_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 omdv_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 omdv_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 omdv_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM omdv_product p
LEFT JOIN omdv_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN omdv_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN omdv_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '5714' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-02-11 04:34:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
235 (3.016)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_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-02-11 04:34:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-02-11 04:34:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM omdv_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-02-11 04:34:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-02-11 04:34:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM omdv_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM omdv_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM omdv_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 omdv_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 omdv_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 omdv_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM omdv_product p
LEFT JOIN omdv_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN omdv_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN omdv_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '5715' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-02-11 04:34:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
236 (0.464)
SELECT s.*, ps.product_show, ps.category_show, ps.sort_order, ps.product_id
FROM omdv_product_status ps
LEFT JOIN omdv_status s ON ps.status_id = s.status_id
WHERE s.language_id = '1' AND ps.product_id = '5715'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
237 (0.455)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '5715' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
238 (0.515)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5715' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
239 (0.363)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5715' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
240 (0.134)
SELECT *
FROM omdv_product_to_category
WHERE product_id = '5715'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:516
241 (0.335)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '5715' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
242 (0.426)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5715' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
243 (0.349)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5715' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
244 (0.358)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '5715' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
245 (0.373)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5715' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
246 (0.378)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5715' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
247 (0.426)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '5715' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
248 (0.413)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5715' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
249 (0.337)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5715' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
250 (0.364)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '5715' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
251 (0.373)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5715' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
252 (0.370)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5715' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
253 (0.346)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '5715' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
254 (0.361)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5715' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
255 (0.302)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5715' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
256 (0.347)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '5715' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
257 (0.343)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5715' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
258 (0.329)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5715' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
259 (0.347)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '5715' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
260 (0.389)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5715' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
261 (0.328)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5715' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
262 (0.346)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '5715' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
263 (0.342)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5715' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
264 (0.367)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5715' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
265 (0.362)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '5715' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
266 (0.394)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5715' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
267 (0.329)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5715' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
268 (0.355)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '5715' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
269 (0.388)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5715' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
270 (0.345)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5715' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
271 (0.387)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '5715' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
272 (0.379)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5715' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
273 (0.362)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5715' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
274 (0.370)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '5715' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
275 (0.395)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5715' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
276 (0.350)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5715' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
277 (0.374)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '5715' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
278 (0.386)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5715' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
279 (0.340)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5715' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
280 (0.389)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '5715' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
281 (0.392)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5715' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
282 (0.366)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5715' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
283 (2.751)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_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-02-11 04:34:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-02-11 04:34:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM omdv_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-02-11 04:34:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-02-11 04:34:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM omdv_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM omdv_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM omdv_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 omdv_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 omdv_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 omdv_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM omdv_product p
LEFT JOIN omdv_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN omdv_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN omdv_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '5711' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-02-11 04:34:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
284 (4.513)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_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-02-11 04:34:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-02-11 04:34:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM omdv_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-02-11 04:34:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-02-11 04:34:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM omdv_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM omdv_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM omdv_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 omdv_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 omdv_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 omdv_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM omdv_product p
LEFT JOIN omdv_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN omdv_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN omdv_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '5713' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-02-11 04:34:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
285 (2.775)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_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-02-11 04:34:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-02-11 04:34:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM omdv_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-02-11 04:34:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-02-11 04:34:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM omdv_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM omdv_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM omdv_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 omdv_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 omdv_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 omdv_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM omdv_product p
LEFT JOIN omdv_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN omdv_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN omdv_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '5709' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-02-11 04:34:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
286 (2.865)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_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-02-11 04:34:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-02-11 04:34:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM omdv_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-02-11 04:34:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-02-11 04:34:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM omdv_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM omdv_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM omdv_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 omdv_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 omdv_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 omdv_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM omdv_product p
LEFT JOIN omdv_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN omdv_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN omdv_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '5712' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-02-11 04:34:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
287 (0.505)
SELECT s.*, ps.product_show, ps.category_show, ps.sort_order, ps.product_id
FROM omdv_product_status ps
LEFT JOIN omdv_status s ON ps.status_id = s.status_id
WHERE s.language_id = '1' AND ps.product_id = '5712'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
288 (0.768)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '5712' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
289 (0.574)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5712' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
290 (0.388)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5712' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
291 (0.140)
SELECT *
FROM omdv_product_to_category
WHERE product_id = '5712'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:516
292 (0.532)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '5712' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
293 (0.490)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5712' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
294 (0.399)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5712' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
295 (0.557)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '5712' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
296 (0.480)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5712' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
297 (0.390)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5712' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
298 (0.545)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '5712' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
299 (0.450)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5712' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
300 (0.358)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5712' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
301 (0.543)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '5712' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
302 (0.474)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5712' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
303 (0.450)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5712' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
304 (0.555)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '5712' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
305 (0.465)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5712' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
306 (0.380)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5712' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
307 (0.540)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '5712' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
308 (0.472)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5712' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
309 (0.379)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5712' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
310 (0.808)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '5712' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
311 (0.460)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5712' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
312 (0.395)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5712' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
313 (0.556)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '5712' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
314 (0.439)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5712' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
315 (0.346)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5712' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
316 (0.548)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '5712' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
317 (0.472)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5712' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
318 (0.379)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5712' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
319 (0.567)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '5712' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
320 (0.455)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5712' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
321 (0.361)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5712' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
322 (0.548)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '5712' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
323 (0.488)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5712' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
324 (0.396)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5712' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
325 (0.552)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '5712' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
326 (0.459)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5712' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
327 (0.368)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5712' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
328 (0.537)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '5712' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
329 (0.460)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5712' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
330 (0.370)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5712' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
331 (0.543)
SELECT ag.attribute_group_id, agd.name
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN omdv_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '5712' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:395
332 (0.489)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5712' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
333 (0.382)
SELECT a.attribute_id, ad.name, pa.text
FROM omdv_product_attribute pa
LEFT JOIN omdv_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN omdv_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '5712' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:400
334 (2.906)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_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-02-11 04:34:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-02-11 04:34:00'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM omdv_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-02-11 04:34:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-02-11 04:34:00'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM omdv_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM omdv_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit
FROM omdv_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 omdv_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 omdv_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 omdv_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM omdv_product p
LEFT JOIN omdv_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN omdv_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN omdv_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '5716' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-02-11 04:34:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
335 (3.268)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM omdv_product p
LEFT JOIN omdv_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN omdv_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '1' AND p.status = '1' AND p2s.store_id = '0' AND p.manufacturer_id = '14'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:644
336 (0.435)
SELECT *
FROM omdv_layout_route
WHERE 'product/manufacturer/info' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/c/cg22734/public_html/catalog/model/design/layout.php:4
337 (0.199)
SELECT *
FROM omdv_extension
WHERE `type` = 'module'
/home/c/cg22734/public_html/catalog/model/setting/extension.php:4
338 (0.158)
SELECT *
FROM omdv_layout_route
WHERE 'product/manufacturer/info' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/c/cg22734/public_html/catalog/model/design/layout.php:4
339 (0.137)
SELECT *
FROM omdv_extension
WHERE `type` = 'module'
/home/c/cg22734/public_html/catalog/model/setting/extension.php:4
340 (0.206)
SELECT *
FROM omdv_layout_route
WHERE 'product/manufacturer/info' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/c/cg22734/public_html/catalog/model/design/layout.php:4
341 (0.128)
SELECT *
FROM omdv_extension
WHERE `type` = 'module'
/home/c/cg22734/public_html/catalog/model/setting/extension.php:4
342 (0.195)
SELECT *
FROM omdv_layout_route
WHERE 'product/manufacturer/info' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/c/cg22734/public_html/catalog/model/design/layout.php:4
343 (0.127)
SELECT *
FROM omdv_extension
WHERE `type` = 'module'
/home/c/cg22734/public_html/catalog/model/setting/extension.php:4
344 (1.057)
SELECT *
FROM omdv_information i
LEFT JOIN omdv_information_description id ON (i.information_id = id.information_id)
LEFT JOIN omdv_information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1'
ORDER BY i.sort_order, LCASE(id.title) ASC
/home/c/cg22734/public_html/catalog/model/catalog/information.php:10
345 (0.712)
SELECT *
FROM omdv_information i
LEFT JOIN omdv_information_description id ON (i.information_id = id.information_id)
LEFT JOIN omdv_information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1'
ORDER BY i.sort_order, LCASE(id.title) ASC
/home/c/cg22734/public_html/catalog/model/catalog/information.php:10
346 (0.604)
SELECT *
FROM omdv_category c
LEFT JOIN omdv_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN omdv_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '0' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/c/cg22734/public_html/catalog/model/catalog/category.php:10
347 (0.411)
SELECT *
FROM omdv_category c
LEFT JOIN omdv_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN omdv_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '92' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/c/cg22734/public_html/catalog/model/catalog/category.php:10
348 (0.632)
SELECT *
FROM omdv_category c
LEFT JOIN omdv_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN omdv_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '93' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/c/cg22734/public_html/catalog/model/catalog/category.php:10
349 (0.503)
SELECT *
FROM omdv_category c
LEFT JOIN omdv_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN omdv_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '99' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/c/cg22734/public_html/catalog/model/catalog/category.php:10
350 (0.420)
SELECT *
FROM omdv_category c
LEFT JOIN omdv_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN omdv_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '118' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/c/cg22734/public_html/catalog/model/catalog/category.php:10
351 (0.333)
SELECT *
FROM omdv_category c
LEFT JOIN omdv_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN omdv_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '143' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/c/cg22734/public_html/catalog/model/catalog/category.php:10
352 (0.429)
SELECT *
FROM omdv_category c
LEFT JOIN omdv_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN omdv_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '162' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/c/cg22734/public_html/catalog/model/catalog/category.php:10
353 (0.340)
SELECT *
FROM omdv_extension
WHERE `type` = 'total'
/home/c/cg22734/public_html/catalog/model/setting/extension.php:4