<

Примерка двери

Здесь вы можете узнать, как работает функция посмотреть эту дверь в своем интерьере

Посмотреть пример

ВЛАДИМИРСКАЯ ДВЕРНАЯ КОМПАНИЯ, (Россия, Владимир)

На странице:
Сортировка:
1Г1 полотно глухое (беленый дуб) межкомнатная дверь
Каркасная система сборки двери. Внутри по периметру двери имеется брус из сосны, который служит основой и уже поверх него листы МДФ толщиной 4 мм. Внутри дверь заполнена гофрокартоном. Толщина двери составляет 40 мм. Основа двери материал МДФ, что оберегает ее от линейного изменения размеров при пер..
0.00 р.
1Г1 полотно глухое (венге) межкомнатная дверь
Каркасная система сборки двери. Внутри по периметру двери имеется брус из сосны, который служит основой и уже поверх него листы МДФ толщиной 4 мм. Внутри дверь заполнена гофрокартоном. Толщина двери составляет 40 мм. Основа двери материал МДФ, что оберегает ее от линейного изменения размеров при пер..
0.00 р.
1Г1 полотно глухое (итальянский орех) межкомнатная дверь
Каркасная система сборки двери. Внутри по периметру двери имеется брус из сосны, который служит основой и уже поверх него листы МДФ толщиной 4 мм. Внутри дверь заполнена гофрокартоном. Толщина двери составляет 40 мм. Основа двери материал МДФ, что оберегает ее от линейного изменения размеров при пер..
0.00 р.
1Г1 полотно глухое (миланский орех) межкомнатная дверь
Каркасная система сборки двери. Внутри по периметру двери имеется брус из сосны, который служит основой и уже поверх него листы МДФ толщиной 4 мм. Внутри дверь заполнена гофрокартоном. Толщина двери составляет 40 мм. Основа двери материал МДФ, что оберегает ее от линейного изменения размеров при пер..
0.00 р.
4Г13 глухая (итальянский орех) межкомнатная дверь
Каркасная система сборки двери. Внутри по периметру двери имеется брус из сосны, который служит основой и уже поверх него листы МДФ толщиной 4 мм. Внутри дверь заполнена гофрокартоном. Толщина двери составляет 40 мм. Основа двери материал МДФ, что оберегает ее от линейного изменения размеров при пер..
0.00 р.
4Г13 глухая (миланский орех) межкомнатная дверь
Каркасная система сборки двери. Внутри по периметру двери имеется брус из сосны, который служит основой и уже поверх него листы МДФ толщиной 4 мм. Внутри дверь заполнена гофрокартоном. Толщина двери составляет 40 мм. Основа двери материал МДФ, что оберегает ее от линейного изменения размеров при пер..
0.00 р.
4Г6 глухая (итальянский орех) межкомнатная дверь
Каркасная система сборки двери. Внутри по периметру двери имеется брус из сосны, который служит основой и уже поверх него листы МДФ толщиной 4 мм. Внутри дверь заполнена гофрокартоном. Толщина двери составляет 40 мм. Основа двери материал МДФ, что оберегает ее от линейного изменения размеров при пер..
0.00 р.
4Г6 глухая (миланский орех) межкомнатная дверь
Каркасная система сборки двери. Внутри по периметру двери имеется брус из сосны, который служит основой и уже поверх него листы МДФ толщиной 4 мм. Внутри дверь заполнена гофрокартоном. Толщина двери составляет 40 мм. Основа двери материал МДФ, что оберегает ее от линейного изменения размеров при пер..
0.00 р.
4С1 (беленый дуб) межкомнатная дверь
Каркасная система сборки двери. Внутри по периметру двери имеется брус из сосны, который служит основой и уже поверх него листы МДФ толщиной 4 мм. Внутри дверь заполнена гофрокартоном. Толщина двери составляет 40 мм. Основа двери материал МДФ, что оберегает ее от линейного изменения размеров при пер..
0.00 р.
4С1 (венге) межкомнатная дверь
Каркасная система сборки двери. Внутри по периметру двери имеется брус из сосны, который служит основой и уже поверх него листы МДФ толщиной 4 мм. Внутри дверь заполнена гофрокартоном. Толщина двери составляет 40 мм. Основа двери материал МДФ, что оберегает ее от линейного изменения размеров при пер..
0.00 р.
4С1 (миланский орех) межкомнатная дверь
Каркасная система сборки двери. Внутри по периметру двери имеется брус из сосны, который служит основой и уже поверх него листы МДФ толщиной 4 мм. Внутри дверь заполнена гофрокартоном. Толщина двери составляет 40 мм. Основа двери материал МДФ, что оберегает ее от линейного изменения размеров при пер..
0.00 р.
4С11 (итальянски орех) межкомнатная дверь
Каркасная система сборки двери. Внутри по периметру двери имеется брус из сосны, который служит основой и уже поверх него листы МДФ толщиной 4 мм. Внутри дверь заполнена гофрокартоном. Толщина двери составляет 40 мм. Основа двери материал МДФ, что оберегает ее от линейного изменения размеров при пер..
0.00 р.
4С11 (миланский орех) межкомнатная дверь
Каркасная система сборки двери. Внутри по периметру двери имеется брус из сосны, который служит основой и уже поверх него листы МДФ толщиной 4 мм. Внутри дверь заполнена гофрокартоном. Толщина двери составляет 40 мм. Основа двери материал МДФ, что оберегает ее от линейного изменения размеров при пер..
0.00 р.
4С13 стекло (итальянский орех) межкомнатная дверь
Каркасная система сборки двери. Внутри по периметру двери имеется брус из сосны, который служит основой и уже поверх него листы МДФ толщиной 4 мм. Внутри дверь заполнена гофрокартоном. Толщина двери составляет 40 мм. Основа двери материал МДФ, что оберегает ее от линейного изменения размеров при пер..
0.00 р.
4С13 стекло (миланский орех) межкомнатная дверь
Каркасная система сборки двери. Внутри по периметру двери имеется брус из сосны, который служит основой и уже поверх него листы МДФ толщиной 4 мм. Внутри дверь заполнена гофрокартоном. Толщина двери составляет 40 мм. Основа двери материал МДФ, что оберегает ее от линейного изменения размеров при пер..
0.00 р.
4С5 (итальянский орех) межкомнатная дверь
Каркасная система сборки двери. Внутри по периметру двери имеется брус из сосны, который служит основой и уже поверх него листы МДФ толщиной 4 мм. Внутри дверь заполнена гофрокартоном. Толщина двери составляет 40 мм. Основа двери материал МДФ, что оберегает ее от линейного изменения размеров при пер..
0.00 р.
4С5 (миланский орех) межкомнатная дверь
Каркасная система сборки двери. Внутри по периметру двери имеется брус из сосны, который служит основой и уже поверх него листы МДФ толщиной 4 мм. Внутри дверь заполнена гофрокартоном. Толщина двери составляет 40 мм. Основа двери материал МДФ, что оберегает ее от линейного изменения размеров при пер..
0.00 р.
4С6 стекло (итальянский орех) межкомнатная дверь
Каркасная система сборки двери. Внутри по периметру двери имеется брус из сосны, который служит основой и уже поверх него листы МДФ толщиной 4 мм. Внутри дверь заполнена гофрокартоном. Толщина двери составляет 40 мм. Основа двери материал МДФ, что оберегает ее от линейного изменения размеров при пер..
0.00 р.
4С6 стекло (миланский орех) межкомнатная дверь
Каркасная система сборки двери. Внутри по периметру двери имеется брус из сосны, который служит основой и уже поверх него листы МДФ толщиной 4 мм. Внутри дверь заполнена гофрокартоном. Толщина двери составляет 40 мм. Основа двери материал МДФ, что оберегает ее от линейного изменения размеров при пер..
0.00 р.
4Ф13 фьюзинг (итальянский орех) межкомнатная дверь
Каркасная система сборки двери. Внутри по периметру двери имеется брус из сосны, который служит основой и уже поверх него листы МДФ толщиной 4 мм. Внутри дверь заполнена гофрокартоном. Толщина двери составляет 40 мм. Основа двери материал МДФ, что оберегает ее от линейного изменения размеров при пер..
0.00 р.
4Ф13 фьюзинг (миланский орех) межкомнатная дверь
Каркасная система сборки двери. Внутри по периметру двери имеется брус из сосны, который служит основой и уже поверх него листы МДФ толщиной 4 мм. Внутри дверь заполнена гофрокартоном. Толщина двери составляет 40 мм. Основа двери материал МДФ, что оберегает ее от линейного изменения размеров при пер..
0.00 р.
4Ф14 (миланский орех) межкомнатная дверь
Каркасная система сборки двери. Внутри по периметру двери имеется брус из сосны, который служит основой и уже поверх него листы МДФ толщиной 4 мм. Внутри дверь заполнена гофрокартоном. Толщина двери составляет 40 мм. Основа двери материал МДФ, что оберегает ее от линейного изменения размеров при пер..
0.00 р.
Палитра глухая (белая) межкомнатная дверь
Каркасная система сборки двери. Внутри по периметру двери имеется брус из сосны, который служит основой и уже поверх него листы МДФ толщиной 4 мм. Внутри дверь заполнена гофрокартоном. Толщина двери составляет 40 мм. Основа двери материал МДФ, что оберегает ее от линейного изменения размеров при пер..
0.00 р.
Палитра глухая (итальянский орех) межкомнатная дверь
Каркасная система сборки двери. Внутри по периметру двери имеется брус из сосны, который служит основой и уже поверх него листы МДФ толщиной 4 мм. Внутри дверь заполнена гофрокартоном. Толщина двери составляет 40 мм. Основа двери материал МДФ, что оберегает ее от линейного изменения размеров при пер..
0.00 р.
Палитра глухая (миланский орех) межкомнатная дверь
Каркасная система сборки двери. Внутри по периметру двери имеется брус из сосны, который служит основой и уже поверх него листы МДФ толщиной 4 мм. Внутри дверь заполнена гофрокартоном. Толщина двери составляет 40 мм. Основа двери материал МДФ, что оберегает ее от линейного изменения размеров при пер..
0.00 р.
Палитра остеклен (белая) межкомнатная дверь
Каркасная система сборки двери. Внутри по периметру двери имеется брус из сосны, который служит основой и уже поверх него листы МДФ толщиной 4 мм. Внутри дверь заполнена гофрокартоном. Толщина двери составляет 40 мм. Основа двери материал МДФ, что оберегает ее от линейного изменения размеров при пер..
0.00 р.
Палитра остеклен (итальянский орех) межкомнатная дверь
Каркасная система сборки двери. Внутри по периметру двери имеется брус из сосны, который служит основой и уже поверх него листы МДФ толщиной 4 мм. Внутри дверь заполнена гофрокартоном. Толщина двери составляет 40 мм. Основа двери материал МДФ, что оберегает ее от линейного изменения размеров при пер..
0.00 р.
Палитра остеклен (миланский орех) межкомнатная дверь
Каркасная система сборки двери. Внутри по периметру двери имеется брус из сосны, который служит основой и уже поверх него листы МДФ толщиной 4 мм. Внутри дверь заполнена гофрокартоном. Толщина двери составляет 40 мм. Основа двери материал МДФ, что оберегает ее от линейного изменения размеров при пер..
0.00 р.
Queries: 140, Total time: 97.790 ms [By time] [By id] [By file]
1 (0.145)
SELECT *
FROM omdv_store
WHERE REPLACE(`url`, 'www.', '') = 'http://777dveri.ru/'
/home/c/cg22734/public_html/index.php:59
2 (1.327)
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.170)
SELECT *
FROM `omdv_language`
WHERE status = '1'
/home/c/cg22734/public_html/index.php:148
4 (0.154)
SELECT *
FROM omdv_currency
/home/c/cg22734/public_html/system/library/currency.php:13
5 (0.165)
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.138)
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.528)
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 = '104' AND md.language_id = '1' AND m2s.store_id = '0'
/home/c/cg22734/public_html/catalog/model/catalog/manufacturer.php:4
8 (4.645)
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-04-18 22:01:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-18 22:01: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-04-18 22:01:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-18 22:01: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-04-18 22:01:00' AND p2s.store_id = '0' AND p.manufacturer_id = '104' 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.065)
SELECT FOUND_ROWS() AS `found_rows`
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:257
10 (2.603)
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-04-18 22:01:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-18 22:01: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-04-18 22:01:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-18 22:01: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 = '465' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-18 22:01:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
11 (0.233)
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 = '465'
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.376)
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-04-18 22:01:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-18 22:01: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-04-18 22:01:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-18 22:01: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 = '164' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-18 22:01:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
14 (0.170)
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 = '164'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
15 (0.090)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
16 (2.358)
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-04-18 22:01:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-18 22:01: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-04-18 22:01:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-18 22:01: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 = '163' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-18 22:01:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
17 (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 = '163'
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.376)
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-04-18 22:01:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-18 22:01: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-04-18 22:01:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-18 22:01: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 = '466' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-18 22:01:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
20 (0.175)
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 = '466'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
21 (0.093)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
22 (2.307)
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-04-18 22:01:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-18 22:01: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-04-18 22:01:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-18 22:01: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 = '4772' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-18 22:01:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
23 (0.170)
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 = '4772'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
24 (0.093)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
25 (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-04-18 22:01:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-18 22:01: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-04-18 22:01:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-18 22:01: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 = '4773' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-18 22:01:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
26 (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 = '4773'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
27 (0.091)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
28 (2.425)
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-04-18 22:01:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-18 22:01: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-04-18 22:01:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-18 22:01: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 = '4764' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-18 22:01:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
29 (0.171)
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 = '4764'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
30 (0.097)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
31 (2.395)
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-04-18 22:01:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-18 22:01: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-04-18 22:01:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-18 22:01: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 = '4765' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-18 22:01:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
32 (0.168)
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 = '4765'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
33 (0.092)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
34 (2.350)
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-04-18 22:01:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-18 22:01: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-04-18 22:01:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-18 22:01: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 = '5695' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-18 22:01:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
35 (0.175)
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 = '5695'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
36 (0.093)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
37 (2.389)
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-04-18 22:01:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-18 22:01: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-04-18 22:01:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-18 22:01: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 = '4194' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-18 22:01:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
38 (0.170)
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 = '4194'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
39 (0.089)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
40 (2.306)
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-04-18 22:01:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-18 22:01: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-04-18 22:01:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-18 22:01: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 = '5305' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-18 22:01:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
41 (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 = '5305'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
42 (0.089)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
43 (2.323)
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-04-18 22:01:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-18 22:01: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-04-18 22:01:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-18 22:01: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 = '4770' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-18 22:01: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 = '4770'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
45 (0.092)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
46 (2.362)
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-04-18 22:01:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-18 22:01: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-04-18 22:01:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-18 22:01: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 = '4771' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-18 22:01:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
47 (0.171)
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 = '4771'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
48 (0.093)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
49 (2.372)
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-04-18 22:01:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-18 22:01: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-04-18 22:01:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-18 22:01: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 = '4774' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-18 22:01:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
50 (0.176)
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 = '4774'
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.359)
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-04-18 22:01:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-18 22:01: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-04-18 22:01:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-18 22:01: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 = '4775' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-18 22:01:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
53 (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 = '4775'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
54 (0.094)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
55 (2.354)
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-04-18 22:01:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-18 22:01: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-04-18 22:01:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-18 22:01: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 = '4769' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-18 22:01:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
56 (0.175)
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 = '4769'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
57 (0.094)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
58 (2.353)
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-04-18 22:01:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-18 22:01: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-04-18 22:01:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-18 22:01: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 = '4768' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-18 22:01:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
59 (0.171)
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 = '4768'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
60 (0.096)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
61 (2.399)
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-04-18 22:01:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-18 22:01: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-04-18 22:01:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-18 22:01: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 = '4766' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-18 22:01:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
62 (0.170)
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 = '4766'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
63 (0.091)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
64 (2.302)
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-04-18 22:01:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-18 22:01: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-04-18 22:01:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-18 22:01: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 = '4767' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-18 22:01:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
65 (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 = '4767'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
66 (0.091)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
67 (2.292)
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-04-18 22:01:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-18 22:01: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-04-18 22:01:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-18 22:01: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 = '4776' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-18 22:01:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
68 (0.166)
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 = '4776'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
69 (0.090)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
70 (2.381)
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-04-18 22:01:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-18 22:01: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-04-18 22:01:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-18 22:01: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 = '4777' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-18 22:01:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
71 (0.172)
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 = '4777'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
72 (0.092)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
73 (2.331)
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-04-18 22:01:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-18 22:01: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-04-18 22:01:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-18 22:01: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 = '4785' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-18 22:01:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
74 (0.170)
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 = '4785'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
75 (0.089)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
76 (2.294)
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-04-18 22:01:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-18 22:01: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-04-18 22:01:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-18 22:01: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 = '468' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-18 22:01:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
77 (0.165)
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 = '468'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
78 (0.087)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
79 (2.320)
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-04-18 22:01:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-18 22:01: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-04-18 22:01:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-18 22:01: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 = '168' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-18 22:01:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
80 (0.168)
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 = '168'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
81 (0.091)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
82 (2.315)
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-04-18 22:01:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-18 22:01: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-04-18 22:01:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-18 22:01: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 = '467' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-18 22:01:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
83 (0.192)
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 = '467'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
84 (0.109)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
85 (2.333)
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-04-18 22:01:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-18 22:01: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-04-18 22:01:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-18 22:01: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 = '469' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-18 22:01:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
86 (0.185)
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 = '469'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
87 (0.090)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
88 (2.402)
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-04-18 22:01:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-18 22:01: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-04-18 22:01:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-18 22:01: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 = '167' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-18 22:01:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
89 (0.171)
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 = '167'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
90 (0.091)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
91 (2.456)
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-04-18 22:01:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-18 22:01: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-04-18 22:01:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-18 22:01: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 = '748' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-18 22:01:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
92 (0.170)
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 = '748'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
93 (0.090)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
94 (3.603)
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-04-18 22:01:00' AND p2s.store_id = '0' AND p.manufacturer_id = '104'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:643
95 (0.204)
SELECT *
FROM omdv_product_image
WHERE product_id = '465'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
96 (0.552)
SELECT *
FROM omdv_product_image
WHERE product_id = '164'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
97 (0.223)
SELECT *
FROM omdv_product_image
WHERE product_id = '163'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
98 (0.222)
SELECT *
FROM omdv_product_image
WHERE product_id = '466'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
99 (0.220)
SELECT *
FROM omdv_product_image
WHERE product_id = '4772'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
100 (0.219)
SELECT *
FROM omdv_product_image
WHERE product_id = '4773'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
101 (0.233)
SELECT *
FROM omdv_product_image
WHERE product_id = '4764'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
102 (0.219)
SELECT *
FROM omdv_product_image
WHERE product_id = '4765'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
103 (0.221)
SELECT *
FROM omdv_product_image
WHERE product_id = '5695'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
104 (0.238)
SELECT *
FROM omdv_product_image
WHERE product_id = '4194'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
105 (0.217)
SELECT *
FROM omdv_product_image
WHERE product_id = '5305'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
106 (0.218)
SELECT *
FROM omdv_product_image
WHERE product_id = '4770'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
107 (0.217)
SELECT *
FROM omdv_product_image
WHERE product_id = '4771'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
108 (0.222)
SELECT *
FROM omdv_product_image
WHERE product_id = '4774'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
109 (0.223)
SELECT *
FROM omdv_product_image
WHERE product_id = '4775'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
110 (0.221)
SELECT *
FROM omdv_product_image
WHERE product_id = '4769'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
111 (0.219)
SELECT *
FROM omdv_product_image
WHERE product_id = '4768'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
112 (0.222)
SELECT *
FROM omdv_product_image
WHERE product_id = '4766'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
113 (0.218)
SELECT *
FROM omdv_product_image
WHERE product_id = '4767'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
114 (0.218)
SELECT *
FROM omdv_product_image
WHERE product_id = '4776'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
115 (0.255)
SELECT *
FROM omdv_product_image
WHERE product_id = '4777'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
116 (0.219)
SELECT *
FROM omdv_product_image
WHERE product_id = '4785'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
117 (0.242)
SELECT *
FROM omdv_product_image
WHERE product_id = '468'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
118 (0.219)
SELECT *
FROM omdv_product_image
WHERE product_id = '168'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
119 (0.196)
SELECT *
FROM omdv_product_image
WHERE product_id = '467'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
120 (0.233)
SELECT *
FROM omdv_product_image
WHERE product_id = '469'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
121 (0.227)
SELECT *
FROM omdv_product_image
WHERE product_id = '167'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
122 (0.229)
SELECT *
FROM omdv_product_image
WHERE product_id = '748'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
123 (0.241)
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
124 (0.189)
SELECT *
FROM omdv_extension
WHERE `type` = 'module'
/home/c/cg22734/public_html/catalog/model/setting/extension.php:4
125 (0.197)
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
126 (0.120)
SELECT *
FROM omdv_extension
WHERE `type` = 'module'
/home/c/cg22734/public_html/catalog/model/setting/extension.php:4
127 (0.191)
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
128 (0.118)
SELECT *
FROM omdv_extension
WHERE `type` = 'module'
/home/c/cg22734/public_html/catalog/model/setting/extension.php:4
129 (0.190)
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
130 (0.119)
SELECT *
FROM omdv_extension
WHERE `type` = 'module'
/home/c/cg22734/public_html/catalog/model/setting/extension.php:4
131 (1.034)
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
132 (0.691)
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
133 (0.572)
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
134 (0.423)
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
135 (0.701)
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
136 (0.449)
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
137 (0.445)
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
138 (0.292)
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
139 (0.396)
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
140 (0.226)
SELECT *
FROM omdv_extension
WHERE `type` = 'total'
/home/c/cg22734/public_html/catalog/model/setting/extension.php:4