<

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

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

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

Алмаз (Новосибирск, Россия)

На странице:
Сортировка:
Алмаз 11 Кипарис темный/Шелк металлическая входная дверь
Алмаз 11 Кипарис темный/Шелк металлическая входная дверь имеет цвет внутренней отделки "Кипарис (внеге)". Дверь для своей цены обладает максимальными тепло и шумоизоляционными свойствами. Установлены противосъемные штыри, которые опеспечиваю защиту при спиливании петель. Конструкция обо..
23 800.00 р. 23 700.00 р.
Алмаз Турмалин Капучино/Антик медь металлическая входная дверь
Цена на заказные модели может отличаться от указанной, актуальную цену узнавайте у менеджера при заказе! Алмаз Турмалин Капучино/Антик медь металлическая входная дверь имеет цвет внутренней отделки "Капучино". Дверь для своей цены обладает максимальными тепло и шумоизоляционными свой..
27 000.00 р. 24 500.00 р.
Алмаз Турмалин белый софт металлическая входная дверь
Толщина стали    1,5 мм Глубина короба    120 мм Толщина полотна    80 мм Утеплитель    Минеральная плита высокой плотности Контуры уплотнения    3 Уплотнитель    ТРИ КОНТУРА УПЛОТНЕНИЯ, на полотне и короб..
31 200.00 р. 29 200.00 р.
Алмаз Турмалин Венге 133/Крокодил металлическая входная дверь
Описание: Дверь для своей цены обладает максимальными тепло и шумоизоляционными свойствами. Если данную дверь сравнивать по той же цене с другими производителями, то она выиграет по всем показателям. Толщина используемой стали 1,5 мм. Снаружи дверь покрыта графитотефлоновым покрытием (шелк б..
31 200.00 р. 29 200.00 р.
Алмаз 11 Венге 93/Шелк металлическая входная дверь
Алмаз 11 Венге 93/Шелк металлическая входная дверь имеет цвет внутренней отделки "Венге". Дверь для своей цены обладает максимальными тепло и шумоизоляционными свойствами. Установлены противосъемные штыри, которые опеспечиваю защиту при спиливании петель. Конструкция оборудована петлями..
33 500.00 р. 31 500.00 р.
Алмаз 11 Ель карпатская 93/Шелк металлическая входная дверь
Алмаз 11 Ель карпатская 93/Шелк металлическая входная дверь имеет цвет внутренней отделки "Карпатская ель". Дверь для своей цены обладает максимальными тепло и шумоизоляционными свойствами. Установлены противосъемные штыри, которые опеспечиваю защиту при спиливании петель. Конструк..
33 500.00 р. 31 500.00 р.
Алмаз 11 Капучино 132/Капучино металлическая входная дверь
Алмаз 11 Капучино 132/Капучино металлическая входная дверь имеет цвет внутренней отделки "Капучино". Дверь для своей цены обладает максимальными тепло и шумоизоляционными свойствами. Установлены противосъемные штыри, которые опеспечиваю защиту при спиливании петель. Конструкция обо..
33 500.00 р. 31 500.00 р.
Алмаз 11 Лиственница мокко/Бордо металлическая входная дверь
Алмаз 11 Лиственница мокко/Бордо металлическая входная дверь имеет цвет внутренней отделки "Лиственница мокка (капучино)". Дверь для своей цены обладает максимальными тепло и шумоизоляционными свойствами. Установлены противосъемные штыри, которые опеспечиваю защиту при спиливании п..
35 700.00 р. 33 700.00 р.
Алмаз 11 Св Дуб Z106/Шелк с зеркалом металлическая входная дверь
Алмаз 11 Св Дуб Z106/Шелк с зеркалом металлическая входная дверь имеет цвет внутренней отделки "Светлый дуб". Дверь для своей цены обладает максимальными тепло и шумоизоляционными свойствами. Установлены противосъемные штыри, которые опеспечиваю защиту при спиливании петель. Констр..
36 200.00 р. 34 200.00 р.
Алмаз Гранит Черный шелк/бетон металлическая входная дверь
Толщина стали 2 мм Глубина короба 150 мм Толщина полотна 110 мм Утеплитель Минеральная плита высокой плотности Контуры уплотнения 4 Уплотнитель Специализированный дверной уплотнитель (3 контура на полотне..
36 700.00 р. 34 700.00 р.
Алмаз Циркон крокодил/венге 144 металлическая входная дверь
Описание: Дверь для своей цены обладает максимальными тепло и шумоизоляционными свойствами. Если данную дверь сравнивать по той же цене с другими производителями, то она выиграет по всем показателям. Толщина используемой стали 1,5 мм.  Также установлены противосъемные штыри, которые опе..
36 700.00 р. 34 700.00 р.
Алмаз Циркон сатин графит/софт айс 248 металлическая входная дверь
Описание: Дверь для своей цены обладает максимальными тепло и шумоизоляционными свойствами. Если данную дверь сравнивать по той же цене с другими производителями, то она выиграет по всем показателям. Толщина используемой стали 1,5 мм.  Также установлены противосъемные штыри, которые опе..
36 700.00 р. 34 700.00 р.
Алмаз Циркон серебро/светлый дуб 144 металлическая входная дверь
Описание: Дверь для своей цены обладает максимальными тепло и шумоизоляционными свойствами. Если данную дверь сравнивать по той же цене с другими производителями, то она выиграет по всем показателям. Толщина используемой стали 1,5 мм.  Также установлены противосъемные штыри, которые опеспечи..
36 700.00 р. 34 700.00 р.
Алмаз Яшма 22 медь/медь двустворчатая металлическая входная дверь
Яшма 22 металлическая входная дверь обладает максимальными тепло и шумоизоляционными свойствами. Толщина используемой стали 1,5 мм.  Также установлены противосъемные штыри, которые опеспечиваю защиту при спиливании петель. Петли на подшипниках, поэтому дверь открывается легко и не просядет со в..
37 100.00 р. 35 100.00 р.
Космо Цефей 1 Термо (терморазрыв на полотне и коробе) металлическая входная дверь
Цена на заказные модели может отличаться от указанной, актуальную цену узнавайте у менеджера при заказе! Описание: Входные двери нового поколения серии «Космо» сочетают в себе стильный элегантный дизайн, надежность и безопасность. Отличительной особенностью дверей этой сери..
45 800.00 р. 43 800.00 р.
Алмаз Персей Kale252 Т Дуб 52/Медь Термо (терморазрыв на полотне и коробе) металлическая входная дверь
Цена на заказные модели может отличаться от указанной, актуальную цену узнавайте у менеджера при заказе! Алмаз Персей Kale252 Т Дуб 52/Медь Термо (терморазрыв на полотне и коробе) металлическая входная дверь имеет цвет внутренней отделки "Дуб темный Дверь для своей цены обладает максималь..
45 400.00 р. 43 900.00 р.
Космо Персей ТЕРМО (терморазрыв на полотне и коробе) металлическая входная дверь
Цена на заказные модели может отличаться от указанной, актуальную цену узнавайте у менеджера при заказе! Описание: Входные двери нового поколения серии «Космо» сочетают в себе стильный элегантный дизайн, надежность и безопасность. Отличительной особенностью дверей этой сери..
49 800.00 р. 46 800.00 р.
Космо Кассиопея Венге 186 Зеркало/Венге металлическая входная дверь
Дверь свыше 100 кг. Установка 2500 руб. Описание: Входные двери нового поколения серии «Космо» сочетают в себе стильный элегантный дизайн, надежность и безопасность. Отличительной особенностью дверей этой серии является применение во всех моделях магнитного уплотнителя по в..
51 200.00 р. 49 200.00 р.
Космо Кассиопея Венге/Дуб кантри 186 Зеркало металлическая входная дверь
Дверь свыше 100 кг. Установка 2500 руб. Описание: Входные двери нового поколения серии «Космо» сочетают в себе стильный элегантный дизайн, надежность и безопасность. Отличительной особенностью дверей этой серии является применение во всех моделях магнитного уплотнителя по в..
51 200.00 р. 49 200.00 р.
Алмаз Александрит 221 двухстворчатая металлическая входная дверь
Цена на заказные модели может отличаться от указанной, актуальную цену узнавайте у менеджера при заказе! Толщина стали 1.5 мм Глубина короба 135 мм Толщина полотна 100 мм Утеплитель Минераллоплита Контуры уплотнения 3..
62 800.00 р. 49 800.00 р.
Diamante Porta Марко каштан премиум 202/софт айс 203 металлическая входная дверь
Дверь свыше 100 кг. Установка 2500 руб. Описание: Входные двери нового поколения серии «Космо» сочетают в себе стильный элегантный дизайн, надежность и безопасность. Отличительной особенностью дверей этой серии является применение во всех моделях магнитного уплотнителя по в..
56 500.00 р. 53 500.00 р.
Космо Цефей термо Силк Титан (терморазрыв на полотне и коробе) металлическая входная дверь
  Описание: Входные двери нового поколения серии «Космо» сочетают в себе стильный элегантный дизайн, надежность и безопасность. Отличительной особенностью дверей этой серии является применение во всех моделях магнитного уплотнителя по всему периметру полотна и коробки,..
56 800.00 р.
Космо Цефей термо Софт айс (терморазрыв на полотне и коробе) металлическая входная дверь
  Описание: Входные двери нового поколения серии «Космо» сочетают в себе стильный элегантный дизайн, надежность и безопасность. Отличительной особенностью дверей этой серии является применение во всех моделях магнитного уплотнителя по всему периметру полотна и коробки,..
56 800.00 р.
ИЗУМРУД ТЕРМО цвет сатин синий стекло зеркало серое металлическая входная дверь
Цена на заказные модели может отличаться от указанной, актуальную цену узнавайте у менеджера при заказе! Описание: Серия дверей Diamante Porta - эталон  дверного искусства! Diamante Porta – это двери, которые гармонично впишутся в интерьер современной квартиры, украсят вход любог..
95 500.00 р.
ДИНО ТЕРМО (DINO TERMO) (терморазрыв на полотне и коробе) металлическая входная дверь
Цена на заказные модели может отличаться от указанной, актуальную цену узнавайте у менеджера при заказе! Толщина стали 1,5 - 1,8 мм Глубина короба 160 мм Толщина полотна 107 мм Внутренняя отделка ..
109 450.00 р.
Алмаз Гранит крокодил/венге 144 металлическая входная дверь
Толщина стали 1,5 мм Глубина короба 150 мм Толщина полотна 105 мм Утеплитель Минеральная плита высокой плотности Контуры уплотнения 4 Уплотнитель Специализированный дверной уплотнитель (3 контура на полот..
0.00 р.
Алмаз Гранит серебро/беленый дуб металлическая входная дверь
Толщина стали 1,5 мм Глубина короба 150 мм Толщина полотна 105 мм Утеплитель Минеральная плита высокой плотности Контуры уплотнения 4 Уплотнитель Специализированный дверной уплотнитель (3 контура на полот..
0.00 р.
Алмаз Яшма Тепло Г-3001/Медь (терморазрыв на полотне) металлическая входная дверь
Цену на заказные модели уточняйте у менеджера в магазине! Алмаз Яшма Тепло Г-3001/Медь (терморазрыв на полотне) металлическая входная дверь обладает максимальными тепло и шумоизоляционными свойствами. Толщина используемой стали 1,8 мм. Также установлены противосъемные штыри, которые опе..
0.00 р.
Алмаз Лазурит 3 металлическая входная дверь
Цена на заказные модели может отличаться от указанной, актуальную цену узнавайте у менеджера при заказе! Описание: Дверь для своей цены обладает максимальными тепло и шумоизоляционными свойствами. Если данную дверь сравнивать по той же цене с другими производителями, то она выиграет по всем по..
0.00 р.
Алмаз Яшма 11 металлическая входная дверь
Цена на заказные модели может отличаться от указанной, актуальную цену узнавайте у менеджера при заказе! Алмаз Яшма 11 металлическая входная дверь обладает максимальными тепло и шумоизоляционными свойствами. Толщина используемой стали 1,2 мм. Также установлены противосъемные штыри,..
0.00 р.
Алмаз Н-10 металлическая входная дверь
Цена на заказные модели может отличаться от указанной, актуальную цену узнавайте у менеджера при заказе! Описание: Дверь для своей цены обладает максимальными тепло и шумоизоляционными свойствами. Если данную дверь сравнивать по той же цене с другими производителями, то она выиграет по всем по..
0.00 р.
Алмаз Опал 11 Венге металлическая входная дверь
Цена на заказные модели может отличаться от указанной, актуальную цену узнавайте у менеджера при заказе! Описание: Дверь для своей цены обладает максимальными тепло и шумоизоляционными свойствами. Если данную дверь сравнивать по той же цене с другими производителями, то она выиграет по всем по..
0.00 р.
Алмаз Сталкер 1 металлическая входная дверь
Цена на заказные модели может отличаться от указанной, актуальную цену узнавайте у менеджера при заказе! Описание: Дверь для своей цены обладает максимальными тепло и шумоизоляционными свойствами. Если данную дверь сравнивать по той же цене с другими производителями, то она выиграет по всем по..
0.00 р.
Алмаз Гранат Венге 147/Медь металлическая входная дверь
Алмаз Гранат Венге 147/Медь металлическая входная дверь имеет цвет внутренней отделки "Венге". Дверь для своей цены обладает максимальными тепло и шумоизоляционными свойствами. Установлены противосъемные штыри, которые опеспечиваю защиту при спиливании петель. Конструкция оборудована пе..
0.00 р.
Алмаз Гранат Светл Дуб 147/Медь металлическая входная дверь
Алмаз Гранат Светл Дуб 147/Медь металлическая входная дверь имеет цвет внутренней отделки "Светлый дуб". Дверь для своей цены обладает максимальными тепло и шумоизоляционными свойствами. Установлены противосъемные штыри, которые опеспечиваю защиту при спиливании петель. Конструкция обор..
0.00 р.
Алмаз Гранат Светл Дуб/Серебро металлическая входная дверь
Цена на заказные модели может отличаться от указанной, актуальную цену узнавайте у менеджера при заказе! Алмаз Гранат Светл Дуб/Серебро металлическая входная дверь имеет цвет внутренней отделки "Светлый дуб". Дверь для своей цены обладает максимальными тепло и шумоизоляционными свойс..
0.00 р.
Алмаз Н-16 металлическая входная дверь
Цена на заказные модели может отличаться от указанной, актуальную цену узнавайте у менеджера при заказе! Описание: Дверь для своей цены обладает максимальными тепло и шумоизоляционными свойствами. Если данную дверь сравнивать по той же цене с другими производителями, то она выиграет по всем по..
0.00 р.
Топаз 11 металлическая входная дверь
Цена на заказные модели может отличаться от указанной, актуальную цену узнавайте у менеджера при заказе! Топаз 11 металлическая входная дверь обладает максимальными тепло и шумоизоляционными свойствами. Толщина используемой стали 1,5 мм.  Также установлены противосъемные штыри, кот..
0.00 р.
Алмаз Лазурит 2 металлическая входная дверь
Цена на заказные модели может отличаться от указанной, актуальную цену узнавайте у менеджера при заказе! Описание: Дверь для своей цены обладает максимальными тепло и шумоизоляционными свойствами. Если данную дверь сравнивать по той же цене с другими производителями, то она выиграет по всем по..
0.00 р.
Топаз 11 панель №6/Шелк металлическая входная дверь
Цена на заказные модели может отличаться от указанной, актуальную цену узнавайте у менеджера при заказе! Топаз 11 панель №6/Шелк металлическая входная дверь обладает максимальными тепло и шумоизоляционными свойствами. Толщина используемой стали 1,5 мм.  Также установлены противосъе..
0.00 р.
Алмаз Сталкер 2  металлическая входная дверь
Цена на заказные модели может отличаться от указанной, актуальную цену узнавайте у менеджера при заказе! Описание: Дверь для своей цены обладает максимальными тепло и шумоизоляционными свойствами. Если данную дверь сравнивать по той же цене с другими производителями, то она выиграет по всем по..
0.00 р.
Алмаз Яшма металлическая входная дверь
Цена на заказные модели может отличаться от указанной, актуальную цену узнавайте у менеджера при заказе! Алмаз Яшма металлическая входная дверь обладает максимальными тепло и шумоизоляционными свойствами. Толщина используемой стали 1,5 мм. Также установлены противосъемные штыр..
0.00 р.
Алмаз 11 Дуб светл S-4/Шелк металлическая входная дверь
Толщина стали 1,5 мм Глубина короба 120 мм Толщина полотна 100 мм Утеплитель Минераллоплита Контуры уплотнения 3 Уплотнитель ТРИ КОНТУРА УПЛОТНЕНИЯ, на полотне и коробе по всему периметру двери. ..
0.00 р.
Алмаз 11 Каштан S-4/Шелк металлическая входная дверь
Толщина стали 1,5 мм Глубина короба 120 мм Толщина полотна 100 мм Утеплитель Минераллоплита Контуры уплотнения 3 Уплотнитель ТРИ КОНТУРА УПЛОТНЕНИЯ, на полотне и коробе по всему периметру двери. ..
0.00 р.
Алмаз Топаз металлическая входная дверь
Цена на заказные модели может отличаться от указанной, актуальную цену узнавайте у менеджера при заказе! Алмаз Топаз металлическая входная дверь Дверь для своей цены обладает максимальными тепло и шумоизоляционными свойствами. Установлены противосъемные штыри, которые опеспечиваю защиту при сп..
0.00 р.
Алмаз Сапфир 3 металлическая входная дверь
Цена на заказные модели может отличаться от указанной, актуальную цену узнавайте у менеджера при заказе! Описание: Дверь для своей цены обладает максимальными тепло и шумоизоляционными свойствами. Если данную дверь сравнивать по той же цене с другими производителями, то она выиграет по всем по..
0.00 р.
Алмаз Опал 2 металлическая входная дверь
Цена на заказные модели может отличаться от указанной, актуальную цену узнавайте у менеджера при заказе! Описание: Дверь для своей цены обладает максимальными тепло и шумоизоляционными свойствами. Если данную дверь сравнивать по той же цене с другими производителями, то она выиграет по всем по..
0.00 р.
Алмаз Кварц 11 металлическая входная дверь
Цена на заказные модели может отличаться от указанной, актуальную цену узнавайте у менеджера при заказе! Описание: Дверь для своей цены обладает максимальными тепло и шумоизоляционными свойствами. Если данную дверь сравнивать по той же цене с другими производителями, то она выиграет по всем по..
0.00 р.
Алмаз Сапфир металлическая входная дверь
Цена на заказные модели может отличаться от указанной, актуальную цену узнавайте у менеджера при заказе! Алмаз Сапфир металлическая входная дверь имеет цвет внутренней отделки "Венге и белый шелк". Дверь для своей цены обладает максимальными тепло и шумоизоляционными свойствами. Уста..
0.00 р.
Алмаз Сталкер 5 металлическая входная дверь
Цена на заказные модели может отличаться от указанной, актуальную цену узнавайте у менеджера при заказе! Описание: Дверь для своей цены обладает максимальными тепло и шумоизоляционными свойствами. Если данную дверь сравнивать по той же цене с другими производителями, то она выиграет по всем по..
0.00 р.
Алмаз Топаз 2 металлическая входная дверь
Цена на заказные модели может отличаться от указанной, актуальную цену узнавайте у менеджера при заказе! Алмаз Топаз 2 металлическая входная дверь имеет цвет внутренней отделки "Беленый дуб". Дверь для своей цены обладает максимальными тепло и шумоизоляционными свойствами. Установлен..
0.00 р.
Алмаз Рубин металлическая входная дверь
Цена на заказные модели может отличаться от указанной, актуальную цену узнавайте у менеджера при заказе! Описание: Дверь для своей цены обладает максимальными тепло и шумоизоляционными свойствами. Если данную дверь сравнивать по той же цене с другими производителями, то она выиграет по всем по..
0.00 р.
Алмаз Сапфир 2 металлическая входная дверь
Цена на заказные модели может отличаться от указанной, актуальную цену узнавайте у менеджера при заказе! Описание: Дверь для своей цены обладает максимальными тепло и шумоизоляционными свойствами. Если данную дверь сравнивать по той же цене с другими производителями, то она выиграет по всем по..
0.00 р.
Алмаз Рубин 2 металлическая входная дверь
Цена на заказные модели может отличаться от указанной, актуальную цену узнавайте у менеджера при заказе! Описание: Дверь для своей цены обладает максимальными тепло и шумоизоляционными свойствами. Если данную дверь сравнивать по той же цене с другими производителями, то она выиграет по всем по..
0.00 р.
Алмаз Агат металлическая входная дверь
Цена на заказные модели может отличаться от указанной, актуальную цену узнавайте у менеджера при заказе! Описание: Дверь для своей цены обладает максимальными тепло и шумоизоляционными свойствами. Если данную дверь сравнивать по той же цене с другими производителями, то она выиграет по всем по..
0.00 р.
Алмаз Аметист с зеркалом металлическая входная дверь
Цена на заказные модели может отличаться от указанной, актуальную цену узнавайте у менеджера при заказе! Описание: Дверь для своей цены обладает максимальными тепло и шумоизоляционными свойствами. Если данную дверь сравнивать по той же цене с другими производителями, то она выиграет по всем по..
0.00 р.
Алмаз Н-5 Тик металлическая входная дверь
Цена на заказные модели может отличаться от указанной, актуальную цену узнавайте у менеджера при заказе! Описание: Дверь для своей цены обладает максимальными тепло и шумоизоляционными свойствами. Если данную дверь сравнивать по той же цене с другими производителями, то она выиграет по всем по..
0.00 р.
Алмаз венге металлическая входная дверь
Цена на заказные модели может отличаться от указанной, актуальную цену узнавайте у менеджера при заказе! Толщина стали 1.5 мм Глубина короба 135 мм Толщина полотна 100 мм Утеплитель Минераллоплита Контуры уплотнения 3..
0.00 р.
Алмаз Малахит металлическая входная дверь
Цена на заказные модели может отличаться от указанной, актуальную цену узнавайте у менеджера при заказе! Характеристики:   Толщина стали 1,5 мм Глубина короба 120 мм Толщина полотна 80 мм Утеплител..
0.00 р.
Алмаз Талисман 2114 Венге 108/шелк металлическая входная дверь
Цена на заказные модели может отличаться от указанной, актуальную цену узнавайте у менеджера при заказе! Алмаз Талисман 2114 Венге 108/шелк металлическая входная дверь имеет цвет внутренней отделки "Венге". Конструкция обладает максимальными тепло и шумоизоляционными свойствами. То..
0.00 р.
Алмаз 3 металлическая входная дверь
Цена на заказные модели может отличаться от указанной, актуальную цену узнавайте у менеджера при заказе! Описание: Дверь для своей цены обладает максимальными тепло и шумоизоляционными свойствами. Если данную дверь сравнивать по той же цене с другими производителями, то она выиграет по всем по..
0.00 р.
Космо Орион металлическая входная дверь
Цена на заказные модели может отличаться от указанной, актуальную цену узнавайте у менеджера при заказе! Описание: Входные двери нового поколения серии «Космо» сочетают в себе стильный элегантный дизайн, надежность и безопасность. Отличительной особенностью дверей этой сери..
0.00 р.
Космо Андромеда металлическая входная дверь
Цена на заказные модели может отличаться от указанной, актуальную цену узнавайте у менеджера при заказе! Описание: Входные двери нового поколения серии «Космо» сочетают в себе стильный элегантный дизайн, надежность и безопасность. Отличительной особенностью дверей этой сери..
0.00 р.
Алмаз 2 металлическая входная дверь
Цена на заказные модели может отличаться от указанной, актуальную цену узнавайте у менеджера при заказе! Описание: Дверь для своей цены обладает максимальными тепло и шумоизоляционными свойствами. Если данную дверь сравнивать по той же цене с другими производителями, то она выиграет по всем по..
0.00 р.
Алмаз ТЕПЛО Г-2112 Венге 91/Медь (терморазрыв на полотне) металлическая входная дверь
Алмаз ТЕПЛО Г-2112 Венге 91/Медь (терморазрыв на полотне) металлическая входная дверь имеет цвет внутренней отделки "Венге, алюминиевый молдинг". Дверь для своей цены обладает максимальными тепло и шумоизоляционными свойствами. Установлены противосъемные штыри, которые опеспечиваю защит..
0.00 р.
Космо Висимут металлическая входная дверь
Цена на заказные модели может отличаться от указанной, актуальную цену узнавайте у менеджера при заказе! Описание: Входные двери нового поколения серии «Космо» сочетают в себе стильный элегантный дизайн, надежность и безопасность. Отличительной особенностью дверей этой сери..
0.00 р.
Космо Пегас металлическая входная дверь
Цена на заказные модели может отличаться от указанной, актуальную цену узнавайте у менеджера при заказе! Описание: Входные двери нового поколения серии «Космо» сочетают в себе стильный элегантный дизайн, надежность и безопасность. Отличительной особенностью дверей этой сери..
0.00 р.
Алмаз 1 Руст металлическая входная дверь
Цена на заказные модели может отличаться от указанной, актуальную цену узнавайте у менеджера при заказе! Описание: Дверь для своей цены обладает максимальными тепло и шумоизоляционными свойствами. Если данную дверь сравнивать по той же цене с другими производителями, то она выиграет по всем по..
0.00 р.
Алмаз 1 Руст 2 металлическая входная дверь
Цена на заказные модели может отличаться от указанной, актуальную цену узнавайте у менеджера при заказе! Описание: Дверь для своей цены обладает максимальными тепло и шумоизоляционными свойствами. Если данную дверь сравнивать по той же цене с другими производителями, то она выиграет по всем по..
0.00 р.
Queries: 308, Total time: 210.141 ms [By time] [By id] [By file]
1 (0.156)
SELECT *
FROM omdv_store
WHERE REPLACE(`url`, 'www.', '') = 'http://777dveri.ru/'
/home/c/cg22734/public_html/index.php:59
2 (1.256)
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.187)
SELECT *
FROM `omdv_language`
WHERE status = '1'
/home/c/cg22734/public_html/index.php:148
4 (0.152)
SELECT *
FROM omdv_currency
/home/c/cg22734/public_html/system/library/currency.php:13
5 (0.179)
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.140)
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.463)
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 = '59' AND md.language_id = '1' AND m2s.store_id = '0'
/home/c/cg22734/public_html/catalog/model/catalog/manufacturer.php:4
8 (6.002)
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-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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-19 14:15:00' AND p2s.store_id = '0' AND p.manufacturer_id = '59' 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.060)
SELECT FOUND_ROWS() AS `found_rows`
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:257
10 (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-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '4221' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
11 (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 = '4221'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
12 (0.086)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
13 (2.069)
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-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '7321' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
14 (0.156)
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 = '7321'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
15 (0.088)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
16 (2.240)
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-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '5844' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
17 (0.155)
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 = '5844'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
18 (0.088)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
19 (2.175)
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-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '10197' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
20 (0.153)
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 = '10197'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
21 (0.081)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
22 (2.282)
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-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '4220' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
23 (0.153)
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 = '4220'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
24 (0.093)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
25 (2.108)
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-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '4219' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
26 (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 = '4219'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
27 (0.084)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
28 (2.159)
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-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '4216' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
29 (0.156)
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 = '4216'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
30 (0.084)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
31 (2.047)
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-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '5768' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
32 (0.153)
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 = '5768'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
33 (0.078)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
34 (2.185)
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-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '4093' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
35 (0.159)
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 = '4093'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
36 (0.084)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
37 (2.138)
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-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '5848' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
38 (0.152)
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 = '5848'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
39 (0.081)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
40 (2.238)
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-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '11663' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
41 (0.215)
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 = '11663'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
42 (0.107)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
43 (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-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '7350' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
44 (0.158)
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 = '7350'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
45 (0.083)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
46 (2.272)
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-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '4321' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
47 (0.160)
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 = '4321'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
48 (0.082)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
49 (2.499)
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-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '5911' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
50 (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 = '5911'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
51 (0.092)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
52 (2.165)
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-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '4233' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
53 (0.188)
SELECT s.*, ps.product_show, ps.category_show, ps.sort_order, ps.product_id
FROM omdv_product_status ps
LEFT JOIN omdv_status s ON ps.status_id = s.status_id
WHERE s.language_id = '1' AND ps.product_id = '4233'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
54 (0.086)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
55 (2.311)
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-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '7339' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
56 (0.165)
SELECT s.*, ps.product_show, ps.category_show, ps.sort_order, ps.product_id
FROM omdv_product_status ps
LEFT JOIN omdv_status s ON ps.status_id = s.status_id
WHERE s.language_id = '1' AND ps.product_id = '7339'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
57 (0.086)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
58 (2.189)
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-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '5906' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
59 (0.198)
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 = '5906'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
60 (0.086)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
61 (2.165)
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-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '7346' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
62 (0.166)
SELECT s.*, ps.product_show, ps.category_show, ps.sort_order, ps.product_id
FROM omdv_product_status ps
LEFT JOIN omdv_status s ON ps.status_id = s.status_id
WHERE s.language_id = '1' AND ps.product_id = '7346'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
63 (0.086)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
64 (2.270)
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-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '7348' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
65 (0.163)
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 = '7348'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
66 (0.087)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
67 (2.199)
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-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '7341' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
68 (0.159)
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 = '7341'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
69 (0.085)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
70 (2.082)
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-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '7313' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
71 (0.158)
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 = '7313'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
72 (0.084)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
73 (2.202)
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-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '12211' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
74 (0.162)
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 = '12211'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
75 (0.086)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
76 (2.172)
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-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '13613' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
77 (0.195)
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 = '13613'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
78 (0.086)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
79 (2.154)
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-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '7342' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
80 (0.160)
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 = '7342'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
81 (0.084)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
82 (2.294)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2025-04-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '7336' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
83 (0.160)
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 = '7336'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
84 (0.120)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
85 (2.309)
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-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '13612' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
86 (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 = '13612'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
87 (0.086)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
88 (2.180)
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-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '12209' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
89 (0.153)
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 = '12209'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
90 (0.080)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
91 (2.178)
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-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '8966' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
92 (0.153)
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 = '8966'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
93 (0.080)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
94 (2.156)
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-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '4231' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
95 (0.152)
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 = '4231'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
96 (0.080)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
97 (2.151)
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-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '7323' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
98 (0.155)
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 = '7323'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
99 (0.083)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
100 (2.193)
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-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '7319' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
101 (0.163)
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 = '7319'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
102 (0.085)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
103 (2.328)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2025-04-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '4309' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
104 (0.161)
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 = '4309'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
105 (0.085)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
106 (2.192)
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-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '4331' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
107 (0.162)
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 = '4331'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
108 (0.084)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
109 (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-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '4314' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
110 (0.159)
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 = '4314'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
111 (0.081)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
112 (2.262)
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-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '4214' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
113 (0.161)
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 = '4214'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
114 (0.084)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
115 (2.182)
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-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '4668' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
116 (0.161)
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 = '4668'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
117 (0.087)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
118 (2.179)
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-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '7322' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
119 (0.160)
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 = '7322'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
120 (0.083)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
121 (2.374)
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-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '4307' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
122 (0.161)
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 = '4307'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
123 (0.087)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
124 (2.142)
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-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '4320' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
125 (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 = '4320'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
126 (0.084)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
127 (2.177)
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-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '4325' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
128 (0.158)
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 = '4325'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
129 (0.101)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
130 (2.397)
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-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '7325' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
131 (0.158)
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 = '7325'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
132 (0.085)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
133 (2.262)
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-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '4313' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
134 (0.182)
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 = '4313'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
135 (0.084)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
136 (2.236)
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-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '7320' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
137 (0.158)
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 = '7320'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
138 (0.082)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
139 (2.355)
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-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '6157' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
140 (0.160)
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 = '6157'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
141 (0.082)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
142 (2.168)
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-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '6156' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
143 (0.184)
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 = '6156'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
144 (0.091)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
145 (2.118)
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-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '7318' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
146 (0.158)
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 = '7318'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
147 (0.082)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
148 (2.511)
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-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '4324' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
149 (0.163)
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 = '4324'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
150 (0.085)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
151 (2.163)
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-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '4326' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
152 (0.182)
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 = '4326'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
153 (0.085)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
154 (2.111)
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-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '4315' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
155 (0.156)
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 = '4315'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
156 (0.078)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
157 (2.235)
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-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '4311' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
158 (0.166)
SELECT s.*, ps.product_show, ps.category_show, ps.sort_order, ps.product_id
FROM omdv_product_status ps
LEFT JOIN omdv_status s ON ps.status_id = s.status_id
WHERE s.language_id = '1' AND ps.product_id = '4311'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
159 (0.087)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
160 (2.398)
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-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '4312' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
161 (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 = '4312'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
162 (0.103)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
163 (2.375)
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-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '4227' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
164 (0.184)
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 = '4227'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
165 (0.094)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
166 (2.280)
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-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '4317' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
167 (0.163)
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 = '4317'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
168 (0.088)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
169 (2.461)
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-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '4328' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
170 (0.160)
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 = '4328'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
171 (0.083)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
172 (2.350)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2025-04-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '4316' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
173 (0.161)
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 = '4316'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
174 (0.125)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
175 (2.249)
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-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '4319' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
176 (0.160)
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 = '4319'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
177 (0.082)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
178 (2.241)
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-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '7316' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
179 (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 = '7316'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
180 (0.088)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
181 (2.272)
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-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '4330' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
182 (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 = '4330'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
183 (0.119)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
184 (2.293)
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-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '7326' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
185 (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 = '7326'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
186 (0.097)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
187 (2.445)
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-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '4323' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
188 (0.184)
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 = '4323'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
189 (0.091)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
190 (2.320)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2025-04-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '4229' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
191 (0.162)
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 = '4229'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
192 (0.085)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
193 (2.380)
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-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '4237' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
194 (0.166)
SELECT s.*, ps.product_show, ps.category_show, ps.sort_order, ps.product_id
FROM omdv_product_status ps
LEFT JOIN omdv_status s ON ps.status_id = s.status_id
WHERE s.language_id = '1' AND ps.product_id = '4237'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
195 (0.084)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
196 (2.248)
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-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '7345' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
197 (0.161)
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 = '7345'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
198 (0.113)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
199 (2.278)
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-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '7347' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
200 (0.161)
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 = '7347'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
201 (0.081)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
202 (2.265)
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-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '7317' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
203 (0.163)
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 = '7317'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
204 (0.114)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
205 (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-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '5904' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
206 (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 = '5904'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
207 (0.089)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
208 (2.253)
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-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '7312' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
209 (0.192)
SELECT s.*, ps.product_show, ps.category_show, ps.sort_order, ps.product_id
FROM omdv_product_status ps
LEFT JOIN omdv_status s ON ps.status_id = s.status_id
WHERE s.language_id = '1' AND ps.product_id = '7312'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
210 (0.088)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
211 (2.414)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM omdv_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < '2025-04-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '7344' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
212 (0.198)
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 = '7344'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
213 (0.087)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
214 (2.255)
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-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '4310' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
215 (0.159)
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 = '4310'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
216 (0.083)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
217 (2.246)
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-19 14:15:00') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2025-04-19 14:15: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-19 14:15:00') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2025-04-19 14:15: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 = '4322' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2025-04-19 14:15:00' AND p2s.store_id = '0'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
218 (0.165)
SELECT s.*, ps.product_show, ps.category_show, ps.sort_order, ps.product_id
FROM omdv_product_status ps
LEFT JOIN omdv_status s ON ps.status_id = s.status_id
WHERE s.language_id = '1' AND ps.product_id = '4322'
ORDER BY ps.sort_order ASC
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:153
219 (0.086)
SELECT *
FROM omdv_status
/home/c/cg22734/public_html/catalog/model/catalog/product_status.php:343
220 (3.818)
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-19 14:15:00' AND p2s.store_id = '0' AND p.manufacturer_id = '59'
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:643
221 (0.202)
SELECT *
FROM omdv_product_image
WHERE product_id = '4221'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
222 (0.495)
SELECT *
FROM omdv_product_image
WHERE product_id = '7321'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
223 (0.249)
SELECT *
FROM omdv_product_image
WHERE product_id = '5844'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
224 (0.228)
SELECT *
FROM omdv_product_image
WHERE product_id = '10197'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
225 (0.232)
SELECT *
FROM omdv_product_image
WHERE product_id = '4220'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
226 (0.258)
SELECT *
FROM omdv_product_image
WHERE product_id = '4219'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
227 (0.224)
SELECT *
FROM omdv_product_image
WHERE product_id = '4216'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
228 (0.245)
SELECT *
FROM omdv_product_image
WHERE product_id = '5768'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
229 (0.264)
SELECT *
FROM omdv_product_image
WHERE product_id = '4093'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
230 (0.229)
SELECT *
FROM omdv_product_image
WHERE product_id = '5848'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
231 (0.238)
SELECT *
FROM omdv_product_image
WHERE product_id = '11663'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
232 (0.229)
SELECT *
FROM omdv_product_image
WHERE product_id = '7350'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
233 (0.231)
SELECT *
FROM omdv_product_image
WHERE product_id = '4321'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
234 (0.231)
SELECT *
FROM omdv_product_image
WHERE product_id = '5911'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
235 (0.230)
SELECT *
FROM omdv_product_image
WHERE product_id = '4233'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
236 (0.223)
SELECT *
FROM omdv_product_image
WHERE product_id = '7339'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
237 (0.259)
SELECT *
FROM omdv_product_image
WHERE product_id = '5906'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
238 (0.229)
SELECT *
FROM omdv_product_image
WHERE product_id = '7346'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
239 (0.232)
SELECT *
FROM omdv_product_image
WHERE product_id = '7348'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
240 (0.227)
SELECT *
FROM omdv_product_image
WHERE product_id = '7341'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
241 (0.232)
SELECT *
FROM omdv_product_image
WHERE product_id = '7313'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
242 (0.227)
SELECT *
FROM omdv_product_image
WHERE product_id = '12211'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
243 (0.235)
SELECT *
FROM omdv_product_image
WHERE product_id = '13613'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
244 (0.222)
SELECT *
FROM omdv_product_image
WHERE product_id = '7342'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
245 (0.220)
SELECT *
FROM omdv_product_image
WHERE product_id = '7336'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
246 (0.215)
SELECT *
FROM omdv_product_image
WHERE product_id = '13612'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
247 (0.218)
SELECT *
FROM omdv_product_image
WHERE product_id = '12209'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
248 (0.219)
SELECT *
FROM omdv_product_image
WHERE product_id = '8966'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
249 (0.232)
SELECT *
FROM omdv_product_image
WHERE product_id = '4231'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
250 (0.218)
SELECT *
FROM omdv_product_image
WHERE product_id = '7323'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
251 (0.201)
SELECT *
FROM omdv_product_image
WHERE product_id = '7319'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
252 (0.219)
SELECT *
FROM omdv_product_image
WHERE product_id = '4309'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
253 (0.219)
SELECT *
FROM omdv_product_image
WHERE product_id = '4331'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
254 (0.219)
SELECT *
FROM omdv_product_image
WHERE product_id = '4314'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
255 (0.215)
SELECT *
FROM omdv_product_image
WHERE product_id = '4214'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
256 (0.224)
SELECT *
FROM omdv_product_image
WHERE product_id = '4668'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
257 (0.217)
SELECT *
FROM omdv_product_image
WHERE product_id = '7322'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
258 (0.238)
SELECT *
FROM omdv_product_image
WHERE product_id = '4307'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
259 (0.278)
SELECT *
FROM omdv_product_image
WHERE product_id = '4320'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
260 (0.220)
SELECT *
FROM omdv_product_image
WHERE product_id = '4325'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
261 (0.220)
SELECT *
FROM omdv_product_image
WHERE product_id = '7325'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
262 (0.221)
SELECT *
FROM omdv_product_image
WHERE product_id = '4313'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
263 (0.216)
SELECT *
FROM omdv_product_image
WHERE product_id = '7320'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
264 (0.253)
SELECT *
FROM omdv_product_image
WHERE product_id = '6157'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
265 (0.257)
SELECT *
FROM omdv_product_image
WHERE product_id = '6156'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
266 (0.220)
SELECT *
FROM omdv_product_image
WHERE product_id = '7318'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
267 (0.219)
SELECT *
FROM omdv_product_image
WHERE product_id = '4324'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
268 (0.220)
SELECT *
FROM omdv_product_image
WHERE product_id = '4326'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
269 (0.218)
SELECT *
FROM omdv_product_image
WHERE product_id = '4315'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
270 (0.202)
SELECT *
FROM omdv_product_image
WHERE product_id = '4311'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
271 (0.258)
SELECT *
FROM omdv_product_image
WHERE product_id = '4312'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
272 (0.220)
SELECT *
FROM omdv_product_image
WHERE product_id = '4227'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
273 (0.221)
SELECT *
FROM omdv_product_image
WHERE product_id = '4317'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
274 (0.216)
SELECT *
FROM omdv_product_image
WHERE product_id = '4328'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
275 (0.240)
SELECT *
FROM omdv_product_image
WHERE product_id = '4316'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
276 (0.231)
SELECT *
FROM omdv_product_image
WHERE product_id = '4319'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
277 (0.221)
SELECT *
FROM omdv_product_image
WHERE product_id = '7316'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
278 (0.228)
SELECT *
FROM omdv_product_image
WHERE product_id = '4330'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
279 (0.246)
SELECT *
FROM omdv_product_image
WHERE product_id = '7326'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
280 (0.176)
SELECT *
FROM omdv_product_image
WHERE product_id = '4323'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
281 (0.177)
SELECT *
FROM omdv_product_image
WHERE product_id = '4229'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
282 (0.237)
SELECT *
FROM omdv_product_image
WHERE product_id = '4237'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
283 (0.197)
SELECT *
FROM omdv_product_image
WHERE product_id = '7345'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
284 (0.172)
SELECT *
FROM omdv_product_image
WHERE product_id = '7347'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
285 (0.180)
SELECT *
FROM omdv_product_image
WHERE product_id = '7317'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
286 (0.197)
SELECT *
FROM omdv_product_image
WHERE product_id = '5904'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
287 (0.159)
SELECT *
FROM omdv_product_image
WHERE product_id = '7312'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
288 (0.170)
SELECT *
FROM omdv_product_image
WHERE product_id = '7344'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
289 (0.161)
SELECT *
FROM omdv_product_image
WHERE product_id = '4310'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
290 (0.228)
SELECT *
FROM omdv_product_image
WHERE product_id = '4322'
ORDER BY sort_order ASC
/home/c/cg22734/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:488
291 (0.237)
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
292 (0.189)
SELECT *
FROM omdv_extension
WHERE `type` = 'module'
/home/c/cg22734/public_html/catalog/model/setting/extension.php:4
293 (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
294 (0.121)
SELECT *
FROM omdv_extension
WHERE `type` = 'module'
/home/c/cg22734/public_html/catalog/model/setting/extension.php:4
295 (0.193)
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
296 (0.119)
SELECT *
FROM omdv_extension
WHERE `type` = 'module'
/home/c/cg22734/public_html/catalog/model/setting/extension.php:4
297 (0.193)
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
298 (0.118)
SELECT *
FROM omdv_extension
WHERE `type` = 'module'
/home/c/cg22734/public_html/catalog/model/setting/extension.php:4
299 (1.031)
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
300 (0.723)
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
301 (0.544)
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
302 (0.418)
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
303 (0.801)
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
304 (0.496)
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
305 (0.487)
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
306 (0.345)
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
307 (0.367)
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
308 (0.341)
SELECT *
FROM omdv_extension
WHERE `type` = 'total'
/home/c/cg22734/public_html/catalog/model/setting/extension.php:4