<

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

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

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

Румакс, г. Владимир

На странице:
Сортировка:
Троя-1 ДО (беленый дуб) межкомнатная дверь (распродажа витринный образец)
Распродажа 800 (Витрина) Состояние: Битый край Забирать по адресу: ул. Красный Путь, 18 Щитовая система сборки двери. Щиты толщиной 16 мм, в результате чего дверь получается очень крепкой. Толщина двери составляет 40 мм. Основа двери материал МДФ, что оберегает ее от линейного изменени..
6 600.00 р. 1 000.00 р.
Троя-1 ДО (беленый дуб) межкомнатная дверь (Витрииа)
Распродажа 800 (Витрина) Забирать по адресу: ул. 10 лет Октября, 113 Щитовая система сборки двери. Щиты толщиной 16 мм, в результате чего дверь получается очень крепкой. Толщина двери составляет 40 мм. Основа двери материал МДФ, что оберегает ее от линейного изменения размеров при перемен..
6 600.00 р. 4 900.00 р.
Ампир ДГ каштан межкомнатная дверь
  Щитовая система сборки двери. Щиты толщиной 16 мм, в результате чего дверь получается очень крепкой. Толщина двери составляет 40 мм. Основа двери материал МДФ, что оберегает ее от линейного изменения размеров при перемене влажности и температур в отличии от дверей из массива дерева. Дверь ..
0.00 р.
Ампир ДГ каштан межкомнатная дверь
  Щитовая система сборки двери. Щиты толщиной 16 мм, в результате чего дверь получается очень крепкой. Толщина двери составляет 40 мм. Основа двери материал МДФ, что оберегает ее от линейного изменения размеров при перемене влажности и температур в отличии от дверей из массива дерева. Дверь ..
0.00 р.
Ампир ДО каштан межкомнатная дверь
Щитовая система сборки двери. Щиты толщиной 16 мм, в результате чего дверь получается очень крепкой. Толщина двери составляет 40 мм. Основа двери материал МДФ, что оберегает ее от линейного изменения размеров при перемене влажности и температур в отличии от дверей из массива дерева. Дверь покрыта шп..
0.00 р.
Ампир ДО каштан межкомнатная дверь (Витрина)
Щитовая система сборки двери. Щиты толщиной 16 мм, в результате чего дверь получается очень крепкой. Толщина двери составляет 40 мм. Основа двери материал МДФ, что оберегает ее от линейного изменения размеров при перемене влажности и температур в отличии от дверей из массива дерева. Дверь покрыта шп..
0.00 р. 1 000.00 р.
Арго ДГ каштан межкомнатная дверь
Щитовая система сборки двери. Щиты толщиной 16 мм, в результате чего дверь получается очень крепкой. Толщина двери составляет 40 мм. Основа двери материал МДФ, что оберегает ее от линейного изменения размеров при перемене влажности и температур в отличии от дверей из массива дерева. Дверь покрыта шп..
0.00 р.
Арго ДО каштан межкомнатная дверь
Щитовая система сборки двери. Щиты толщиной 16 мм, в результате чего дверь получается очень крепкой. Толщина двери составляет 40 мм. Основа двери материал МДФ, что оберегает ее от линейного изменения размеров при перемене влажности и температур в отличии от дверей из массива дерева. Дверь покрыта шп..
0.00 р.
Камелия ДГ (Карелия) межкомнатная дверь (Остатки)
Распродажа (Остатки на складе) По остаткам уточнять вы можете уточнить у менеджера в магазине! Щитовая система сборки двери. Щиты толщиной 16 мм, в результате чего дверь получается очень крепкой. Толщина двери составляет 40 мм. Основа двери материал МДФ, что оберегает ее от линейного изменения..
0.00 р.
Камелия ДО рисунок (Карелия) межкомнатная дверь (Остатки)
Распродажа (Остатки на складе) По остаткам уточнять вы можете уточнить у менеджера в магазине! Щитовая система сборки двери. Щиты толщиной 16 мм, в результате чего дверь получается очень крепкой. Толщина двери составляет 40 мм. Основа двери материал МДФ, что оберегает ее от линейного изменения..
0.00 р.
Карелия ДГ (Карелия) межкомнатная дверь (Остатки)
Распродажа (Остатки на складе) По остаткам уточнять вы можете уточнить у менеджера в магазине! Щитовая система сборки двери. Щиты толщиной 16 мм, в результате чего дверь получается очень крепкой. Толщина двери составляет 40 мм. Основа двери материал МДФ, что оберегает ее от линейного изменения..
0.00 р.
Карелия ДО рисунок (Карелия) межкомнатная дверь (Остатки)
Распродажа (Остатки на складе) По остаткам уточнять вы можете уточнить у менеджера в магазине! Щитовая система сборки двери. Щиты толщиной 16 мм, в результате чего дверь получается очень крепкой. Толщина двери составляет 40 мм. Основа двери материал МДФ, что оберегает ее от линейного изменения..
0.00 р.
Карелия-2 ДГ (мореный дуб) межкомнатная дверь
Щитовая система сборки двери. Щиты толщиной 16 мм, в результате чего дверь получается очень крепкой. Толщина двери составляет 40 мм. Основа двери материал МДФ, что оберегает ее от линейного изменения размеров при перемене влажности и температур в отличии от дверей из массива дерева. Дверь покрыта шп..
0.00 р.
Карелия-2 ДО (мореный дуб) межкомнатная дверь
Щитовая система сборки двери. Щиты толщиной 16 мм, в результате чего дверь получается очень крепкой. Толщина двери составляет 40 мм. Основа двери материал МДФ, что оберегает ее от линейного изменения размеров при перемене влажности и температур в отличии от дверей из массива дерева. Дверь покрыта шп..
0.00 р.
Карелия-2 ДО (мореный дуб) межкомнатная дверь (Витрина)
Распродажа (Витрина) Забирать по адресу: бул. Архитекторов, 5 Щитовая система сборки двери. Щиты толщиной 16 мм, в результате чего дверь получается очень крепкой. Толщина двери составляет 40 мм. Основа двери материал МДФ, что оберегает ее от линейного изменения размеров при перемене влажн..
0.00 р.
Каролина-1 ДГ (орех) межкомнатная дверь
Щитовая система сборки двери. Щиты толщиной 16 мм, в результате чего дверь получается очень крепкой. Толщина двери составляет 40 мм. Основа двери материал МДФ, что оберегает ее от линейного изменения размеров при перемене влажности и температур в отличии от дверей из массива дерева. Дверь покрыта шп..
0.00 р.
Каролина-1 ДО (орех) межкомнатная дверь
Щитовая система сборки двери. Щиты толщиной 16 мм, в результате чего дверь получается очень крепкой. Толщина двери составляет 40 мм. Основа двери материал МДФ, что оберегает ее от линейного изменения размеров при перемене влажности и температур в отличии от дверей из массива дерева. Дверь покрыта шп..
0.00 р.
Кристалл-1 ДО межкомнатная дверь
Щитовая система сборки двери. Щиты толщиной 16 мм, в результате чего дверь получается очень крепкой. Толщина двери составляет 40 мм. Основа двери материал МДФ, что оберегает ее от линейного изменения размеров при перемене влажности и температур в отличии от дверей из массива дерева. Дверь покрыта шп..
0.00 р.
Леди ДГ 4 (орех) межкомнатная дверь
Щитовая система сборки двери. Щиты толщиной 16 мм, в результате чего дверь получается очень крепкой. Толщина двери составляет 40 мм. Основа двери материал МДФ, что оберегает ее от линейного изменения размеров при перемене влажности и температур в отличии от дверей из массива дерева. Дверь покрыта шп..
0.00 р.
Леди ДО 4 (орех) матовое стекло фьюзинг межкомнатная дверь
Щитовая система сборки двери. Щиты толщиной 16 мм, в результате чего дверь получается очень крепкой. Толщина двери составляет 40 мм. Основа двери материал МДФ, что оберегает ее от линейного изменения размеров при перемене влажности и температур в отличии от дверей из массива дерева. Дверь покрыта шп..
0.00 р.
Румакс ДГ (Карелия) межкомнатная дверь
Щитовая система сборки двери. Щиты толщиной 16 мм, в результате чего дверь получается очень крепкой. Толщина двери составляет 40 мм. Основа двери материал МДФ, что оберегает ее от линейного изменения размеров при перемене влажности и температур в отличии от дверей из массива дерева. Дверь покрыта шп..
0.00 р.
Румакс ДО рисунок (Карелия) межкомнатная дверь
Щитовая система сборки двери. Щиты толщиной 16 мм, в результате чего дверь получается очень крепкой. Толщина двери составляет 40 мм. Основа двери материал МДФ, что оберегает ее от линейного изменения размеров при перемене влажности и температур в отличии от дверей из массива дерева. Дверь покрыта шп..
0.00 р.
Соната ДГ (орех) межкомнатная дверь
Щитовая система сборки двери. Щиты толщиной 16 мм, в результате чего дверь получается очень крепкой. Толщина двери составляет 40 мм. Основа двери материал МДФ, что оберегает ее от линейного изменения размеров при перемене влажности и температур в отличии от дверей из массива дерева. Дверь покрыта шп..
0.00 р.
Соната ДО (орех) межкомнатная дверь
Щитовая система сборки двери. Щиты толщиной 16 мм, в результате чего дверь получается очень крепкой. Толщина двери составляет 40 мм. Основа двери материал МДФ, что оберегает ее от линейного изменения размеров при перемене влажности и температур в отличии от дверей из массива дерева. Дверь покрыта шп..
0.00 р.
Троя-1 ДГ  (орех) межкомнатная дверь
Щитовая система сборки двери. Щиты толщиной 16 мм, в результате чего дверь получается очень крепкой. Толщина двери составляет 40 мм. Основа двери материал МДФ, что оберегает ее от линейного изменения размеров при перемене влажности и температур в отличии от дверей из массива дерева. Дверь покрыта шп..
0.00 р.
Троя-1 ДГ (беленый дуб) межкомнатная дверь
Щитовая система сборки двери. Щиты толщиной 16 мм, в результате чего дверь получается очень крепкой. Толщина двери составляет 40 мм. Основа двери материал МДФ, что оберегает ее от линейного изменения размеров при перемене влажности и температур в отличии от дверей из массива дерева. Дверь покрыта шп..
0.00 р.
Троя-1 ДГ (мореный дуб) межкомнатная дверь
Щитовая система сборки двери. Щиты толщиной 16 мм, в результате чего дверь получается очень крепкой. Толщина двери составляет 40 мм. Основа двери материал МДФ, что оберегает ее от линейного изменения размеров при перемене влажности и температур в отличии от дверей из массива дерева. Дверь покрыта шп..
0.00 р.
Троя-1 ДО  (мореный дуб) межкомнатная дверь
Щитовая система сборки двери. Щиты толщиной 16 мм, в результате чего дверь получается очень крепкой. Толщина двери составляет 40 мм. Основа двери материал МДФ, что оберегает ее от линейного изменения размеров при перемене влажности и температур в отличии от дверей из массива дерева. Дверь покрыта шп..
0.00 р.
Троя-1 ДО (орех) межкомнатная дверь
Щитовая система сборки двери. Щиты толщиной 16 мм, в результате чего дверь получается очень крепкой. Толщина двери составляет 40 мм. Основа двери материал МДФ, что оберегает ее от линейного изменения размеров при перемене влажности и температур в отличии от дверей из массива дерева. Дверь покрыта шп..
0.00 р.
Элегия ДГ (светлый дуб) межкомнатная дверь (Остатки)
Распродажа (Остатки на складе) По остаткам уточнять вы можете уточнить у менеджера в магазине! Щитовая система сборки двери. Щиты толщиной 16 мм, в результате чего дверь получается очень крепкой. Толщина двери составляет 40 мм. Основа двери материал МДФ, что оберегает ее от линейного изменения..
0.00 р.
Элегия ДО (светлый дуб) межкомнатная дверь (Остатки)
Распродажа (Остатки на складе) По остаткам уточнять вы можете уточнить у менеджера в магазине! Щитовая система сборки двери. Щиты толщиной 16 мм, в результате чего дверь получается очень крепкой. Толщина двери составляет 40 мм. Основа двери материал МДФ, что оберегает ее от линейного изменения..
0.00 р.
Элегия Дуэт ДГ (светлый дуб) межкомнатная дверь
Щитовая система сборки двери. Щиты толщиной 16 мм, в результате чего дверь получается очень крепкой. Толщина двери составляет 40 мм. Основа двери материал МДФ, что оберегает ее от линейного изменения размеров при перемене влажности и температур в отличии от дверей из массива дерева. Дверь покрыта шп..
0.00 р.
Элегия Дуэт ДО (светлый дуб) межкомнатная дверь
Щитовая система сборки двери. Щиты толщиной 16 мм, в результате чего дверь получается очень крепкой. Толщина двери составляет 40 мм. Основа двери материал МДФ, что оберегает ее от линейного изменения размеров при перемене влажности и температур в отличии от дверей из массива дерева. Дверь покрыта шп..
0.00 р.
Элегия Дуэт ДО (светлый дуб) межкомнатная дверь
Щитовая система сборки двери. Щиты толщиной 16 мм, в результате чего дверь получается очень крепкой. Толщина двери составляет 40 мм. Основа двери материал МДФ, что оберегает ее от линейного изменения размеров при перемене влажности и температур в отличии от дверей из массива дерева. Дверь покрыта шп..
0.00 р.
Эллада ДГ (светлый дуб) межкомнатная дверь
Щитовая система сборки двери. Щиты толщиной 16 мм, в результате чего дверь получается очень крепкой. Толщина двери составляет 40 мм. Основа двери материал МДФ, что оберегает ее от линейного изменения размеров при перемене влажности и температур в отличии от дверей из массива дерева. Дверь покрыта шп..
0.00 р.
Эллада ДО рисунок (светлый дуб) межкомнатная дверь
Щитовая система сборки двери. Щиты толщиной 16 мм, в результате чего дверь получается очень крепкой. Толщина двери составляет 40 мм. Основа двери материал МДФ, что оберегает ее от линейного изменения размеров при перемене влажности и температур в отличии от дверей из массива дерева. Дверь покрыта шп..
0.00 р.

О компании

Компания ООО «RUMAX» была создана в 2001 году в городе Ковров. Предприятие занимается изготовлением и продажей межкомнатных дверей оптом и в розницу по всей России. На данный момент мы можем предложить вам следующую продукцию:

1. Межкомнатные двери, облицованные натуральным шпоном (шпонированные двери) ценных пород древесины (ясень, дуб, красное дерево, бук, эссо, FINE LINE).

2. Тонированные межкомнатные двери из МДФ (тонировка: темно-красное дерево, спелая вишня, апельсин). Белые межкомнатные двери с рисунком, покрытые высококачественной эмалью.

3. Строительные межкомнатные двери (гладкие окрашенные в белый цвет).

С первых дней работы предприятия девизом компании «RUMAX» стали слова: достойное качество по разумной цене. В наши дни в условиях постоянной конкуренции в сфере производства межкомнатных дверей, успехов добьются лишь те производители, которые стремятся к повышению качества изготавливаемой ими продукции.

Для нашей компании очень важно, чтобы каждый клиент, который воспользовался нашими услугами, остался доволен качеством нашей продукции, поэтому на предприятии «RUMAX» действует служба контроля качества (ОТК).

Продажа межкомнатных дверей - основа деятельности компании «RUMAX». Мы поставляем на российский рынок разнообразные шпонированные двери облицованные натуральным шпоном ценных пород древесины и тонированные двери МДФ, выполненные из высококачественных древесных материалов. Белые двери порадуют Вас своей традиционной строгостью, которые с легкостью украсят любое помещение.

Шпонированные межкомнатные двери от производителя компании "RUMAX" (город Ковров) изготовлены из экологически чистых пород древесины и отличаются надежностью и современным дизайном. У нас Вы можете приобрести межкомнатные двери даже на заказ.

Мы дорожим каждым клиентом, поэтому сотрудничество с компанией «RUMAX» - это:

Быстрота в работе и надежность при выполнении заказов на производство шпонированных межкомнатных дверей и тонированных дверей МДФ;

Гарантия качества нашей продукции, благодаря службе контроля качества (ОТК);

Индивидуальная работа с каждым клиентом.

Продажа межкомнатных дверей оптом и в розницу, а также исполнение Ваших заказов в разумные сроки.

Безопасность здоровья и окружающей среды: при изготовлении нашей продукции мы используем экологически чистые материалы.

Мы будем рады сотрудничеству с Вами, и сделаем все возможное для того, чтобы вы остались довольны сервисом и качеством компании «RUMAX».

Queries: 172, Total time: 122.623 ms [By time] [By id] [By file]
1 (0.168)
SELECT *
FROM omdv_store
WHERE REPLACE(`url`, 'www.', '') = 'http://777dveri.ru/'
/home/c/cg22734/public_html/index.php:59
2 (1.654)
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.175)
SELECT *
FROM `omdv_language`
WHERE status = '1'
/home/c/cg22734/public_html/index.php:148
4 (0.168)
SELECT *
FROM omdv_currency
/home/c/cg22734/public_html/system/library/currency.php:13
5 (0.177)
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.157)
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.707)
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 = '26' AND md.language_id = '1' AND m2s.store_id = '0'
/home/c/cg22734/public_html/catalog/model/catalog/manufacturer.php:4
8 (6.017)
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-24 03:06:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-24 03:06: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-24 03:06:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-24 03:06: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-24 03:06:00' AND p2s.store_id = '0' AND p.manufacturer_id = '26' 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.067)
SELECT FOUND_ROWS() AS `found_rows`
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:257
10 (2.575)
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-24 03:06:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-24 03:06: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-24 03:06:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-24 03:06: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 = '11581' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-24 03:06:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
11 (0.210)
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 = '11581'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
12 (0.096)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
13 (2.203)
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-24 03:06:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-24 03:06: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-24 03:06:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-24 03:06: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 = '1147' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-24 03:06:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
14 (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 = '1147'
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.347)
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-24 03:06:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-24 03:06: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-24 03:06:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-24 03:06: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 = '8513' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-24 03:06:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
17 (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 = '8513'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
18 (0.094)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
19 (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-24 03:06:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-24 03:06: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-24 03:06:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-24 03:06: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 = '2015' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-24 03:06:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
20 (0.169)
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 = '2015'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
21 (0.089)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
22 (2.224)
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-24 03:06:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-24 03:06: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-24 03:06:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-24 03:06: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 = '8514' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-24 03:06:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
23 (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 = '8514'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
24 (0.088)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
25 (2.363)
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-24 03:06:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-24 03:06: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-24 03:06:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-24 03:06: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 = '1144' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-24 03:06:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
26 (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 = '1144'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
27 (0.088)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
28 (2.363)
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-24 03:06:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-24 03:06: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-24 03:06:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-24 03:06: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 = '1145' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-24 03:06:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
29 (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 = '1145'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
30 (0.094)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
31 (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-24 03:06:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-24 03:06: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-24 03:06:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-24 03:06: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 = '1146' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-24 03:06:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
32 (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 = '1146'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
33 (0.089)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
34 (2.428)
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-24 03:06:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-24 03:06: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-24 03:06:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-24 03:06: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 = '1156' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-24 03:06:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
35 (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 = '1156'
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.439)
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-24 03:06:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-24 03:06: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-24 03:06:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-24 03:06: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 = '1160' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-24 03:06:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
38 (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 = '1160'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
39 (0.091)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
40 (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-24 03:06:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-24 03:06: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-24 03:06:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-24 03:06: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 = '1161' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-24 03:06:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
41 (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 = '1161'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
42 (0.092)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
43 (2.334)
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-24 03:06:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-24 03:06: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-24 03:06:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-24 03:06: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 = '1162' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-24 03:06:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
44 (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 = '1162'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
45 (0.093)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
46 (2.404)
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-24 03:06:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-24 03:06: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-24 03:06:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-24 03:06: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 = '1157' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-24 03:06:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
47 (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 = '1157'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
48 (0.094)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
49 (2.364)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2025-04-24 03:06:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-24 03:06: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-24 03:06:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-24 03:06: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 = '1149' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-24 03:06:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
50 (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 = '1149'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
51 (0.090)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
52 (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-24 03:06:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-24 03:06: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-24 03:06:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-24 03:06: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 = '8409' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-24 03:06:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
53 (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 = '8409'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
54 (0.090)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
55 (2.440)
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-24 03:06:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-24 03:06: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-24 03:06:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-24 03:06: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 = '1154' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-24 03:06:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
56 (0.191)
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 = '1154'
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.369)
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-24 03:06:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-24 03:06: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-24 03:06:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-24 03:06: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 = '1152' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-24 03:06:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
59 (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 = '1152'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
60 (0.092)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
61 (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-24 03:06:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-24 03:06: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-24 03:06:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-24 03:06: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 = '1264' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-24 03:06:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
62 (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 = '1264'
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.356)
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-24 03:06:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-24 03:06: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-24 03:06:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-24 03:06: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 = '8299' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-24 03:06:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
65 (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 = '8299'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
66 (0.092)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
67 (2.383)
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-24 03:06:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-24 03:06: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-24 03:06:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-24 03:06: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 = '8300' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-24 03:06:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
68 (0.167)
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 = '8300'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
69 (0.088)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
70 (2.335)
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-24 03:06:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-24 03:06: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-24 03:06:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-24 03:06: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 = '1165' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-24 03:06:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
71 (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 = '1165'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
72 (0.088)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
73 (2.433)
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-24 03:06:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-24 03:06: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-24 03:06:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-24 03:06: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 = '1166' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-24 03:06:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
74 (0.169)
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 = '1166'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
75 (0.108)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
76 (2.290)
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-24 03:06:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-24 03:06: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-24 03:06:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-24 03:06: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 = '1167' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-24 03:06:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
77 (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 = '1167'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
78 (0.104)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
79 (2.510)
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-24 03:06:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-24 03:06: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-24 03:06:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-24 03:06: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 = '1168' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-24 03:06:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
80 (0.167)
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 = '1168'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
81 (0.160)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
82 (2.391)
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-24 03:06:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-24 03:06: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-24 03:06:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-24 03:06: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 = '1155' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-24 03:06:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
83 (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 = '1155'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
84 (0.105)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
85 (2.222)
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-24 03:06:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-24 03:06: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-24 03:06:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-24 03:06: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 = '1148' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-24 03:06:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
86 (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 = '1148'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
87 (0.092)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
88 (2.365)
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-24 03:06:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-24 03:06: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-24 03:06:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-24 03:06: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 = '1158' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-24 03:06:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
89 (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 = '1158'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
90 (0.089)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
91 (2.283)
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-24 03:06:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-24 03:06: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-24 03:06:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-24 03:06: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 = '1159' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-24 03:06:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
92 (0.164)
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 = '1159'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
93 (0.087)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
94 (2.373)
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-24 03:06:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-24 03:06: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-24 03:06:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-24 03:06: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 = '1150' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-24 03:06:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
95 (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 = '1150'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
96 (0.091)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
97 (2.213)
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-24 03:06:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-24 03:06: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-24 03:06:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-24 03:06: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 = '1169' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-24 03:06:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
98 (0.167)
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 = '1169'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
99 (0.088)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
100 (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-24 03:06:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-24 03:06: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-24 03:06:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-24 03:06: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 = '1170' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-24 03:06:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
101 (0.169)
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 = '1170'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
102 (0.102)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
103 (2.535)
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-24 03:06:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-24 03:06: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-24 03:06:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-24 03:06: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 = '1171' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-24 03:06:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
104 (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 = '1171'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
105 (0.092)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
106 (2.301)
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-24 03:06:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-24 03:06: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-24 03:06:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-24 03:06: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 = '8416' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-24 03:06:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
107 (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 = '8416'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
108 (0.090)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
109 (2.369)
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-24 03:06:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-24 03:06: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-24 03:06:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-24 03:06: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 = '1172' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-24 03:06:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
110 (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 = '1172'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
111 (0.094)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
112 (2.377)
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-24 03:06:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-24 03:06: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-24 03:06:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-24 03:06: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 = '1173' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-24 03:06:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
113 (0.167)
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 = '1173'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
114 (0.087)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
115 (2.383)
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-24 03:06:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-24 03:06: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-24 03:06:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-24 03:06: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 = '1174' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-24 03:06:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
116 (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 = '1174'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
117 (0.088)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
118 (3.700)
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-24 03:06:00' AND p2s.store_id = '0' AND p.manufacturer_id = '26'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:643
119 (0.204)
SELECT *
FROM omdv_product_image
WHERE product_id = '11581'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
120 (0.399)
SELECT *
FROM omdv_product_image
WHERE product_id = '1147'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
121 (0.268)
SELECT *
FROM omdv_product_image
WHERE product_id = '8513'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
122 (0.346)
SELECT *
FROM omdv_product_image
WHERE product_id = '2015'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
123 (0.257)
SELECT *
FROM omdv_product_image
WHERE product_id = '8514'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
124 (0.253)
SELECT *
FROM omdv_product_image
WHERE product_id = '1144'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
125 (0.257)
SELECT *
FROM omdv_product_image
WHERE product_id = '1145'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
126 (0.200)
SELECT *
FROM omdv_product_image
WHERE product_id = '1146'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
127 (0.167)
SELECT *
FROM omdv_product_image
WHERE product_id = '1156'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
128 (0.233)
SELECT *
FROM omdv_product_image
WHERE product_id = '1160'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
129 (0.261)
SELECT *
FROM omdv_product_image
WHERE product_id = '1161'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
130 (0.233)
SELECT *
FROM omdv_product_image
WHERE product_id = '1162'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
131 (0.238)
SELECT *
FROM omdv_product_image
WHERE product_id = '1157'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
132 (0.227)
SELECT *
FROM omdv_product_image
WHERE product_id = '1149'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
133 (0.227)
SELECT *
FROM omdv_product_image
WHERE product_id = '8409'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
134 (0.221)
SELECT *
FROM omdv_product_image
WHERE product_id = '1154'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
135 (0.220)
SELECT *
FROM omdv_product_image
WHERE product_id = '1152'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
136 (0.212)
SELECT *
FROM omdv_product_image
WHERE product_id = '1264'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
137 (0.221)
SELECT *
FROM omdv_product_image
WHERE product_id = '8299'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
138 (0.216)
SELECT *
FROM omdv_product_image
WHERE product_id = '8300'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
139 (0.241)
SELECT *
FROM omdv_product_image
WHERE product_id = '1165'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
140 (0.219)
SELECT *
FROM omdv_product_image
WHERE product_id = '1166'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
141 (0.217)
SELECT *
FROM omdv_product_image
WHERE product_id = '1167'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
142 (0.221)
SELECT *
FROM omdv_product_image
WHERE product_id = '1168'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
143 (0.184)
SELECT *
FROM omdv_product_image
WHERE product_id = '1155'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
144 (0.224)
SELECT *
FROM omdv_product_image
WHERE product_id = '1148'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
145 (0.210)
SELECT *
FROM omdv_product_image
WHERE product_id = '1158'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
146 (0.245)
SELECT *
FROM omdv_product_image
WHERE product_id = '1159'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
147 (0.212)
SELECT *
FROM omdv_product_image
WHERE product_id = '1150'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
148 (0.208)
SELECT *
FROM omdv_product_image
WHERE product_id = '1169'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
149 (0.165)
SELECT *
FROM omdv_product_image
WHERE product_id = '1170'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
150 (0.216)
SELECT *
FROM omdv_product_image
WHERE product_id = '1171'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
151 (0.224)
SELECT *
FROM omdv_product_image
WHERE product_id = '8416'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
152 (0.217)
SELECT *
FROM omdv_product_image
WHERE product_id = '1172'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
153 (0.217)
SELECT *
FROM omdv_product_image
WHERE product_id = '1173'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
154 (0.213)
SELECT *
FROM omdv_product_image
WHERE product_id = '1174'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
155 (0.229)
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
156 (0.169)
SELECT *
FROM omdv_extension
WHERE `type` = 'module'
/home/c/cg22734/public_html/catalog/model/setting/extension.php:4
157 (0.194)
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
158 (0.118)
SELECT *
FROM omdv_extension
WHERE `type` = 'module'
/home/c/cg22734/public_html/catalog/model/setting/extension.php:4
159 (0.192)
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
160 (0.119)
SELECT *
FROM omdv_extension
WHERE `type` = 'module'
/home/c/cg22734/public_html/catalog/model/setting/extension.php:4
161 (0.164)
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
162 (0.111)
SELECT *
FROM omdv_extension
WHERE `type` = 'module'
/home/c/cg22734/public_html/catalog/model/setting/extension.php:4
163 (1.035)
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
164 (0.716)
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
165 (0.577)
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
166 (0.401)
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
167 (0.612)
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
168 (0.436)
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
169 (0.377)
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
170 (0.285)
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
171 (0.385)
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
172 (0.377)
SELECT *
FROM omdv_extension
WHERE `type` = 'total'
/home/c/cg22734/public_html/catalog/model/setting/extension.php:4