1 (0.152)
SELECT *
FROM omdv_store
WHERE REPLACE(`url`, 'www.', '') = 'http://777dveri.ru/'
/home/c/cg22734/public_html/index.php:59
2 (1.347)
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.173)
SELECT *
FROM `omdv_language`
WHERE status = '1'
/home/c/cg22734/public_html/index.php:148
4 (0.168)
SELECT *
FROM omdv_currency
/home/c/cg22734/public_html/system/library/currency.php:13
5 (0.164)
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.146)
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.480)
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 = '62' AND md.language_id = '1' AND m2s.store_id = '0'
/home/c/cg22734/public_html/catalog/model/catalog/manufacturer.php:4
8 (4.958)
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-06-19 21:46:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-06-19 21:46: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-06-19 21:46:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-06-19 21:46: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-06-19 21:46:00' AND p2s.store_id = '0' AND p.manufacturer_id = '62' GROUP BY p.product_id
ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,70
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:255
9 (0.064)
SELECT FOUND_ROWS() AS `found_rows`
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:257
10 (2.509)
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-06-19 21:46:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-06-19 21:46: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-06-19 21:46:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-06-19 21:46: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 = '2458' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-06-19 21:46:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
11 (0.243)
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 = '2458'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
12 (0.100)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
13 (2.411)
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-06-19 21:46:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-06-19 21:46: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-06-19 21:46:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-06-19 21:46: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 = '2459' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-06-19 21:46:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
14 (0.178)
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 = '2459'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
15 (0.108)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
16 (2.422)
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-06-19 21:46:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-06-19 21:46: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-06-19 21:46:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-06-19 21:46: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 = '1938' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-06-19 21:46:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
17 (0.177)
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 = '1938'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
18 (0.096)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
19 (2.414)
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-06-19 21:46:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-06-19 21:46: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-06-19 21:46:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-06-19 21:46: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 = '8367' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-06-19 21:46:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
20 (0.178)
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 = '8367'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
21 (0.094)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
22 (2.371)
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-06-19 21:46:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-06-19 21:46: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-06-19 21:46:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-06-19 21:46: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 = '2454' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-06-19 21:46:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
23 (0.188)
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 = '2454'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
24 (0.094)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
25 (2.312)
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-06-19 21:46:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-06-19 21:46: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-06-19 21:46:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-06-19 21:46: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 = '8185' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-06-19 21:46:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
26 (0.174)
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 = '8185'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
27 (0.095)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
28 (2.346)
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-06-19 21:46:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-06-19 21:46: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-06-19 21:46:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-06-19 21:46: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 = '8368' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-06-19 21:46:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
29 (0.177)
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 = '8368'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
30 (0.096)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
31 (2.364)
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-06-19 21:46:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-06-19 21:46: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-06-19 21:46:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-06-19 21:46: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 = '1937' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-06-19 21:46:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
32 (0.181)
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 = '1937'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
33 (0.095)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
34 (2.324)
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-06-19 21:46:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-06-19 21:46: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-06-19 21:46:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-06-19 21:46: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 = '1939' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-06-19 21:46:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
35 (0.193)
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 = '1939'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
36 (0.107)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
37 (2.349)
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-06-19 21:46:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-06-19 21:46: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-06-19 21:46:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-06-19 21:46: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 = '1940' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-06-19 21:46:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
38 (0.177)
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 = '1940'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
39 (0.094)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
40 (2.360)
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-06-19 21:46:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-06-19 21:46: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-06-19 21:46:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-06-19 21:46: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 = '2453' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-06-19 21:46:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
41 (0.178)
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 = '2453'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
42 (0.094)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
43 (2.342)
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-06-19 21:46:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-06-19 21:46: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-06-19 21:46:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-06-19 21:46: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 = '5694' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-06-19 21:46:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
44 (0.174)
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 = '5694'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
45 (0.096)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
46 (2.336)
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-06-19 21:46:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-06-19 21:46: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-06-19 21:46:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-06-19 21:46: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 = '1941' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-06-19 21:46:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
47 (0.173)
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 = '1941'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
48 (0.096)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
49 (2.346)
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-06-19 21:46:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-06-19 21:46: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-06-19 21:46:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-06-19 21:46: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 = '8366' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-06-19 21:46:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
50 (0.174)
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 = '8366'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
51 (0.094)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
52 (2.342)
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-06-19 21:46:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-06-19 21:46: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-06-19 21:46:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-06-19 21:46: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 = '8364' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-06-19 21:46:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
53 (0.177)
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 = '8364'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
54 (0.098)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
55 (2.328)
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-06-19 21:46:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-06-19 21:46: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-06-19 21:46:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-06-19 21:46: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 = '8365' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-06-19 21:46:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
56 (0.173)
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 = '8365'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
57 (0.093)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
58 (3.558)
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 p.date_available <= '2025-06-19 21:46:00' AND p2s.store_id = '0' AND p.manufacturer_id = '62'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:643
59 (0.189)
SELECT *
FROM omdv_product_image
WHERE product_id = '2458'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
60 (0.257)
SELECT category_id
FROM omdv_product_to_category
WHERE product_id = '2458'
ORDER BY main_category DESC LIMIT 1
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_pro.php:277
61 (0.290)
SELECT *
FROM omdv_product_image
WHERE product_id = '2459'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
62 (0.199)
SELECT category_id
FROM omdv_product_to_category
WHERE product_id = '2459'
ORDER BY main_category DESC LIMIT 1
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_pro.php:277
63 (0.287)
SELECT *
FROM omdv_product_image
WHERE product_id = '1938'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
64 (0.173)
SELECT category_id
FROM omdv_product_to_category
WHERE product_id = '1938'
ORDER BY main_category DESC LIMIT 1
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_pro.php:277
65 (0.334)
SELECT *
FROM omdv_product_image
WHERE product_id = '8367'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
66 (0.175)
SELECT category_id
FROM omdv_product_to_category
WHERE product_id = '8367'
ORDER BY main_category DESC LIMIT 1
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_pro.php:277
67 (0.251)
SELECT *
FROM omdv_product_image
WHERE product_id = '2454'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
68 (0.177)
SELECT category_id
FROM omdv_product_to_category
WHERE product_id = '2454'
ORDER BY main_category DESC LIMIT 1
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_pro.php:277
69 (0.254)
SELECT *
FROM omdv_product_image
WHERE product_id = '8185'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
70 (0.147)
SELECT category_id
FROM omdv_product_to_category
WHERE product_id = '8185'
ORDER BY main_category DESC LIMIT 1
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_pro.php:277
71 (0.284)
SELECT *
FROM omdv_product_image
WHERE product_id = '8368'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
72 (0.185)
SELECT category_id
FROM omdv_product_to_category
WHERE product_id = '8368'
ORDER BY main_category DESC LIMIT 1
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_pro.php:277
73 (0.319)
SELECT *
FROM omdv_product_image
WHERE product_id = '1937'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
74 (0.204)
SELECT category_id
FROM omdv_product_to_category
WHERE product_id = '1937'
ORDER BY main_category DESC LIMIT 1
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_pro.php:277
75 (0.234)
SELECT *
FROM omdv_product_image
WHERE product_id = '1939'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
76 (0.202)
SELECT category_id
FROM omdv_product_to_category
WHERE product_id = '1939'
ORDER BY main_category DESC LIMIT 1
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_pro.php:277
77 (0.415)
SELECT *
FROM omdv_product_image
WHERE product_id = '1940'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
78 (0.210)
SELECT category_id
FROM omdv_product_to_category
WHERE product_id = '1940'
ORDER BY main_category DESC LIMIT 1
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_pro.php:277
79 (0.476)
SELECT *
FROM omdv_product_image
WHERE product_id = '2453'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
80 (0.216)
SELECT category_id
FROM omdv_product_to_category
WHERE product_id = '2453'
ORDER BY main_category DESC LIMIT 1
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_pro.php:277
81 (0.328)
SELECT *
FROM omdv_product_image
WHERE product_id = '5694'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
82 (0.196)
SELECT category_id
FROM omdv_product_to_category
WHERE product_id = '5694'
ORDER BY main_category DESC LIMIT 1
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_pro.php:277
83 (0.298)
SELECT *
FROM omdv_product_image
WHERE product_id = '1941'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
84 (0.198)
SELECT category_id
FROM omdv_product_to_category
WHERE product_id = '1941'
ORDER BY main_category DESC LIMIT 1
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_pro.php:277
85 (0.295)
SELECT *
FROM omdv_product_image
WHERE product_id = '8366'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
86 (0.197)
SELECT category_id
FROM omdv_product_to_category
WHERE product_id = '8366'
ORDER BY main_category DESC LIMIT 1
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_pro.php:277
87 (0.301)
SELECT *
FROM omdv_product_image
WHERE product_id = '8364'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
88 (0.197)
SELECT category_id
FROM omdv_product_to_category
WHERE product_id = '8364'
ORDER BY main_category DESC LIMIT 1
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_pro.php:277
89 (0.458)
SELECT *
FROM omdv_product_image
WHERE product_id = '8365'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
90 (0.203)
SELECT category_id
FROM omdv_product_to_category
WHERE product_id = '8365'
ORDER BY main_category DESC LIMIT 1
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_pro.php:277
91 (0.255)
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
92 (0.195)
SELECT *
FROM omdv_extension
WHERE `type` = 'module'
/home/c/cg22734/public_html/catalog/model/setting/extension.php:4
93 (0.196)
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
94 (0.130)
SELECT *
FROM omdv_extension
WHERE `type` = 'module'
/home/c/cg22734/public_html/catalog/model/setting/extension.php:4
95 (0.173)
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
96 (0.129)
SELECT *
FROM omdv_extension
WHERE `type` = 'module'
/home/c/cg22734/public_html/catalog/model/setting/extension.php:4
97 (0.199)
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
98 (0.125)
SELECT *
FROM omdv_extension
WHERE `type` = 'module'
/home/c/cg22734/public_html/catalog/model/setting/extension.php:4
99 (0.910)
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
100 (0.641)
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
101 (0.494)
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
102 (0.372)
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
103 (0.327)
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
104 (0.404)
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
105 (0.343)
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
106 (0.346)
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
107 (0.190)
SELECT *
FROM omdv_extension
WHERE `type` = 'total'
/home/c/cg22734/public_html/catalog/model/setting/extension.php:4
.png)
