Славянские обереги

Фильтры:
  • Тип
Применить фильтр

Издревле наш народ славился умением изготавливать предметы, которые не только украшают одежду и тело человека, но и несут в себе сакральные традиции. В каждый славянский символ вложен определенный смысл. Каждое кольцо или подвеска, каждый рисунок на рубахе имеют глубокие исторические корни, обладают религиозным значением. Славянские обереги защищают человека от нечистых духов, несправедливости и болезней, приносят достаток, любовь и удачу своим владельцам. Коловрат и Ладинец, Колядник и Цветок папоротника, Стрелы Перуна и Молвинец, Новородник и Валькирия - эти и другие славянские обереги Вы можете  купить в нашем интернет-магазине.

 Подвес "Алатырь"латунь Арт.5887л
1079 р.
Браслет "Алатырь и ладинцы с аметистами" Арт. 1088 серебро
10828 р.
Браслет "Алатырь и Ладинцы с аметистами" Арт. 1088с серебрение
7095 р.
Браслет "Алатырь и Ладинцы" Арт. 1088зсс серебрение
4627 р.
Браслет "Алатырь и Ладинцы" Арт. 1088срсс серебрение
4627 р.
Браслет "Валькирия и ладинцы с аметистами" Арт. 1088ва серебро
10828 р.
Браслет "Валькирия и ладинцы" Арт. 1088вгсс серебрение
4627 р.
Браслет "Валькирия" Арт. 1091 серебро
12030 р.
Браслет "Валькирия" Арт. 1091л латунь
3393 р.
Браслет "Валькирия" Арт. 1109л латунь
3084 р.
Браслет "Валькирия" Арт. 1109с серебрение
4627 р.
Браслет "Валькирия" Арт.1091с серебрение
5553 р.
На основе 1 отзывов.
Браслет "Велес и ладинцы" Арт. 1088вссс серебрение
4627 р.
Браслет "Звезда Алатырь" Арт. 1089 серебро
12030 р.
Браслет "Звезда Алатырь" Арт. 1089л латунь
3393 р.
Браслет "Звезда Алатырь" Арт. 1089с серебрение
5553 р.
Браслет "Звезда Лады" Арт. 1108л латунь
3084 р.
Браслет "Звезда Лады" Арт. 1108с серебрение
4627 р.
Браслет "Звезда Руси" Арт. 1105л латунь
3393 р.
Браслет "Звезда Руси" Арт. 1105с серебрение
5553 р.
Браслет "Кожаный с оберегом" Арт. 1101ла латунь
1850 р.
Браслет "Кожаный с оберегом" Арт. 1101лв латунь
1850 р.
Браслет "Кожаный с оберегом" Арт. 1101лм латунь
1850 р.
Браслет "Кожаный с оберегом" Арт. 1101лт латунь
1850 р.
Браслет "Кожаный с оберегом" Арт. 1101лчс латунь
1850 р.
Браслет "Ладинец с аметистами" Арт. 1086 серебро
10828 р.
Браслет "Ладинец с аметистами" Арт. 1086с серебрение
7583 р.
Браслет "Ладинец с янтарём" Арт. 1086я серебро
8187 р.
Браслет "Ладинцы с аметистами" Арт. 1084 серебро
9619 р.
Браслет "Ладинцы с аметистами" Арт. 1084с серебрение
6477 р.
Браслет "Ладинцы с аметистами" Арт. 1087ас серебрение
6785 р.
Браслет "Ладинцы с янтарём" Арт. 1084яс серебрение
4627 р.
Браслет "Ладинцы с янтарём" Арт. 1087 серебро
8187 р.
Браслет "Ладинцы" Арт. 1083 серебро
7220 р.
Браслет "Ладинцы" Арт. 1083л латунь
2776 р.
Браслет "Ладинцы" Арт. 1083с серебрение
3701 р.
Браслет "Молвинец и ладинцы с гематитом" Арт. 1088мгс серебрение
4627 р.
Браслет "Молвинец и ладинцы" Арт. 1088мксс серебрение
4627 р.
Браслет "Молвинец" Арт. 1090 серебро
12030 р.
Браслет "Молвинец" Арт. 1090л латунь
3393 р.
Браслет "Молвинец" Арт. 1090с серебрение
5553 р.
Браслет "Репейник Счастья" Арт. 1094 серебро
12030 р.
Браслет "Репейник Счастья" Арт. 1094л латунь
3393 р.
Браслет "Репейник Счастья" Арт. 1094с серебрение
5553 р.
Браслет "Символ Велеса" Арт. 1095 серебро
12030 р.
Браслет "Символ Велеса" Арт. 1095л латунь
3393 р.
Браслет "Символ Велеса" Арт. 1095с серебрение
5553 р.
Браслет "Трилистник" Арт. 1093 серебро
12030 р.
Браслет "Трилистник" Арт. 1093л латунь
3393 р.
Браслет "Трилистник" Арт. 1093с серебрение
5553 р.
Показано с 1 по 50 из 878 (всего 18 страниц)
Queries: 401, Total time: 82.233 ms [By time] [By id] [By file]
1 (0.035)
SELECT *
FROM pr_store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://yavinav.ru/'
/home/y/yafinafru/yavinav/public_html/index.php:50
2 (0.637)
SELECT *
FROM pr_setting
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC
/home/y/yafinafru/yavinav/public_html/index.php:62
3 (0.075)
SELECT *
FROM `pr_language`
WHERE status = '1'
/home/y/yafinafru/yavinav/public_html/index.php:141
4 (0.075)
SELECT *
FROM pr_currency
/home/y/yafinafru/yavinav/public_html/system/library/currency.php:13
5 (0.037)
SELECT *
FROM pr_weight_class wc
LEFT JOIN pr_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id)
WHERE wcd.language_id = '2'
/home/y/yafinafru/yavinav/public_html/system/library/weight.php:9
6 (0.043)
SELECT *
FROM pr_length_class mc
LEFT JOIN pr_length_class_description mcd ON (mc.length_class_id = mcd.length_class_id)
WHERE mcd.language_id = '2'
/home/y/yafinafru/yavinav/public_html/system/library/length.php:9
7 (0.067)
SELECT *
FROM pr_url_alias
WHERE keyword = 'slavjanskie-oberegi'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:15
8 (0.140)
select curdate() as today, timestampadd(day,1,curdate()) as tommorow
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:5
9 (0.041)
SELECT *
FROM pr_url_alias
WHERE `query` = 'common/home'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
10 (0.047)
SELECT DISTINCT *
FROM pr_category c
LEFT JOIN pr_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN pr_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '57' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/category.php:4
11 (0.027)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
12 (0.025)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
13 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/compare'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
14 (0.033)
SELECT *
FROM pr_category c
LEFT JOIN pr_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN pr_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '57' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/category.php:10
15 (0.048)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM pr_product_to_category p2c
LEFT JOIN pr_product p ON (p2c.product_id = p.product_id)
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0' AND p2c.category_id = '57'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:587
16 (47.010)
SELECT p.product_id, (SELECT AVG(rating) AS total
FROM pr_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price
FROM pr_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 <= '2024-06-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-06-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-06-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-06-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special
FROM pr_product_to_category p2c
LEFT JOIN pr_product p ON (p2c.product_id = p.product_id)
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0' AND p2c.category_id = '57' GROUP BY p.product_id
ORDER BY LCASE(pd.name) ASC, LCASE(pd.name) ASC LIMIT 0,50
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:230
17 (1.971)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-06-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-06-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-06-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-06-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM pr_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '3205' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
18 (0.151)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-06-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-06-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-06-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-06-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM pr_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1228' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
19 (0.087)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-06-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-06-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-06-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-06-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM pr_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1995' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
20 (0.099)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-06-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-06-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-06-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-06-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM pr_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '2397' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
21 (0.080)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-06-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-06-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-06-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-06-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM pr_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '2398' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
22 (0.067)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-06-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-06-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-06-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-06-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM pr_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '2293' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
23 (0.067)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-06-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-06-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-06-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-06-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM pr_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '2399' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
24 (0.083)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-06-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-06-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-06-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-06-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM pr_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1230' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
25 (0.074)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-06-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-06-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-06-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-06-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM pr_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '88' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
26 (0.824)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-06-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-06-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-06-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-06-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM pr_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '3952' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
27 (1.177)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-06-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-06-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-06-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-06-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM pr_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '3953' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
28 (0.068)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-06-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-06-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-06-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-06-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM pr_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '154' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
29 (0.090)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-06-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-06-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-06-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-06-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM pr_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '2400' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
30 (0.086)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-06-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-06-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-06-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-06-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM pr_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1053' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
31 (0.062)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-06-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-06-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-06-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-06-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM pr_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '70' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
32 (0.063)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-06-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-06-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-06-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-06-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM pr_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '109' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
33 (1.225)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-06-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-06-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-06-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-06-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM pr_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '3950' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
34 (0.715)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-06-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-06-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-06-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-06-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM pr_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '3951' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
35 (0.070)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-06-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-06-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-06-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-06-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM pr_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '3103' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
36 (0.608)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-06-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-06-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-06-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-06-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM pr_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '3709' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
37 (0.088)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-06-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-06-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-06-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-06-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM pr_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1765' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
38 (0.070)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-06-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-06-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-06-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-06-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM pr_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1766' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
39 (0.080)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-06-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-06-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-06-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-06-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM pr_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1767' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
40 (0.058)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-06-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-06-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-06-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-06-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM pr_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '2913' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
41 (0.061)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-06-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-06-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-06-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-06-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM pr_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '2848' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
42 (0.077)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-06-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-06-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-06-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-06-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM pr_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1039' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
43 (0.072)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-06-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-06-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-06-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-06-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM pr_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1994' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
44 (0.070)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-06-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-06-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-06-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-06-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM pr_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '2292' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
45 (1.016)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-06-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-06-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-06-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-06-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM pr_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1033' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
46 (0.708)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-06-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-06-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-06-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-06-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM pr_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '79' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
47 (0.069)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-06-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-06-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-06-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-06-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM pr_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '151' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
48 (0.627)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-06-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-06-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-06-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-06-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM pr_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '191' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
49 (0.092)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-06-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-06-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-06-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-06-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM pr_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1048' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
50 (0.655)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-06-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-06-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-06-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-06-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM pr_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1032' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
51 (0.647)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-06-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-06-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-06-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-06-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM pr_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '252' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
52 (0.803)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-06-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-06-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-06-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-06-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM pr_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '190' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
53 (0.082)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-06-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-06-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-06-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-06-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM pr_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '2401' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
54 (0.068)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-06-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-06-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-06-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-06-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM pr_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '2402' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
55 (0.605)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-06-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-06-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-06-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-06-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM pr_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1229' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
56 (0.628)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-06-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-06-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-06-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-06-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM pr_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '69' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
57 (0.579)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-06-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-06-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-06-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-06-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM pr_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '152' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
58 (0.081)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-06-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-06-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-06-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-06-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM pr_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1226' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
59 (0.071)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-06-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-06-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-06-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-06-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM pr_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '87' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
60 (0.066)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-06-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-06-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-06-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-06-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM pr_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '153' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
61 (0.072)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-06-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-06-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-06-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-06-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM pr_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1225' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
62 (0.074)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-06-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-06-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-06-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-06-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM pr_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '71' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
63 (0.064)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-06-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-06-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-06-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-06-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM pr_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '562' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
64 (0.608)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-06-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-06-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-06-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-06-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM pr_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1227' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
65 (0.721)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-06-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-06-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-06-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-06-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM pr_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '86' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
66 (0.659)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_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 <= '2024-06-20') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-06-20'))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM pr_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 <= '2024-06-20') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-06-20'))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM pr_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM pr_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM pr_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM pr_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM pr_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 pr_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM pr_product p
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN pr_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '150' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
67 (0.039)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
68 (0.027)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
69 (0.031)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=3205'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
70 (0.031)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
71 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
72 (0.040)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=1228'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
73 (0.029)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
74 (0.028)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
75 (0.045)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=1995'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
76 (0.053)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
77 (0.035)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
78 (0.028)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=2397'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
79 (0.073)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
80 (0.030)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
81 (0.038)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=2398'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
82 (0.030)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
83 (0.028)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
84 (0.039)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=2293'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
85 (0.030)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
86 (0.028)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
87 (0.028)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=2399'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
88 (0.027)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
89 (0.025)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
90 (0.029)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=1230'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
91 (0.029)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
92 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
93 (0.029)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=88'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
94 (0.027)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
95 (0.029)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
96 (0.230)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=3952'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
97 (0.487)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
98 (0.044)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
99 (0.178)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=3953'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
100 (0.031)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
101 (0.027)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
102 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=154'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
103 (0.030)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
104 (0.025)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
105 (0.028)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=2400'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
106 (0.028)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
107 (0.025)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
108 (0.029)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=1053'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
109 (0.031)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
110 (0.030)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
111 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=70'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
112 (0.028)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
113 (0.041)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
114 (0.024)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=109'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
115 (0.051)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
116 (0.027)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
117 (0.214)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=3950'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
118 (0.033)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
119 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
120 (0.201)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=3951'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
121 (0.031)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
122 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
123 (0.027)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=3103'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
124 (0.027)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
125 (0.048)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
126 (0.144)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=3709'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
127 (0.031)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
128 (0.025)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
129 (0.029)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=1765'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
130 (0.027)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
131 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
132 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=1766'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
133 (0.027)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
134 (0.024)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
135 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=1767'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
136 (0.027)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
137 (0.025)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
138 (0.047)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=2913'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
139 (0.028)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
140 (0.028)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
141 (0.036)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=2848'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
142 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
143 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
144 (0.027)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=1039'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
145 (0.027)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
146 (0.025)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
147 (0.027)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=1994'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
148 (0.045)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
149 (0.025)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
150 (0.028)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=2292'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
151 (0.029)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
152 (0.029)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
153 (0.206)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=1033'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
154 (0.034)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
155 (0.047)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
156 (0.172)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=79'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
157 (0.032)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
158 (0.028)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
159 (0.053)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=151'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
160 (0.027)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
161 (0.023)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
162 (0.207)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=191'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
163 (0.036)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
164 (0.028)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
165 (0.068)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=1048'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
166 (0.027)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
167 (0.025)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
168 (0.123)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=1032'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
169 (0.066)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
170 (0.027)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
171 (0.217)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=252'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
172 (0.034)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
173 (0.029)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
174 (0.237)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=190'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
175 (0.034)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
176 (0.027)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
177 (0.028)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=2401'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
178 (0.028)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
179 (0.025)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
180 (0.029)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=2402'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
181 (0.029)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
182 (0.025)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
183 (0.178)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=1229'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
184 (0.030)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
185 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
186 (0.222)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=69'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
187 (0.039)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
188 (0.029)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
189 (0.161)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=152'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
190 (0.032)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
191 (0.030)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
192 (0.034)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=1226'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
193 (0.028)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
194 (0.040)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
195 (0.028)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=87'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
196 (0.029)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
197 (0.024)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
198 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=153'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
199 (0.046)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
200 (0.025)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
201 (0.027)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=1225'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
202 (0.027)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
203 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
204 (0.025)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=71'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
205 (0.029)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
206 (0.027)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
207 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=562'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
208 (0.043)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
209 (0.024)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
210 (0.171)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=1227'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
211 (0.033)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
212 (0.025)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
213 (0.179)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=86'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
214 (0.041)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
215 (0.061)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
216 (0.178)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=150'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
217 (0.185)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
218 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
219 (0.020)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
220 (0.019)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
221 (0.025)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
222 (0.022)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
223 (0.021)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
224 (0.019)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
225 (0.020)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
226 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
227 (0.023)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
228 (0.021)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
229 (0.021)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
230 (0.023)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
231 (0.021)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
232 (0.019)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
233 (0.021)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
234 (0.023)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
235 (0.020)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
236 (0.019)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
237 (0.021)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
238 (0.027)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
239 (0.023)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
240 (0.021)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
241 (0.025)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
242 (0.019)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
243 (0.020)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
244 (0.022)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
245 (0.021)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
246 (0.042)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
247 (0.025)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
248 (0.020)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
249 (0.021)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
250 (0.022)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
251 (0.021)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
252 (0.027)
SELECT *
FROM pr_url_alias
WHERE `query` = 'common/home'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
253 (1.438)
SELECT *
FROM pr_category_to_layout
WHERE category_id = '57' AND store_id = '0'
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/category.php:105
254 (0.224)
SELECT *
FROM pr_layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/y/yafinafru/yavinav/public_html/catalog/model/design/layout.php:4
255 (0.053)
SELECT *
FROM pr_extension
WHERE `type` = 'module'
/home/y/yafinafru/yavinav/public_html/catalog/model/setting/extension.php:4
256 (0.108)
SELECT DISTINCT *
FROM pr_category c
LEFT JOIN pr_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN pr_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '57' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/category.php:4
257 (0.059)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
258 (0.031)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
259 (0.038)
SELECT filter_id
FROM pr_category_filter
WHERE category_id = '57'
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/category.php:18
260 (0.039)
SELECT DISTINCT f.filter_group_id, fgd.name, fg.sort_order
FROM pr_filter f
LEFT JOIN pr_filter_group fg ON (f.filter_group_id = fg.filter_group_id)
LEFT JOIN pr_filter_group_description fgd ON (fg.filter_group_id = fgd.filter_group_id)
WHERE f.filter_id IN (1,2,3,6,7,9,10) AND fgd.language_id = '2' GROUP BY f.filter_group_id
ORDER BY fg.sort_order, LCASE(fgd.name)
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/category.php:28
261 (0.067)
SELECT DISTINCT f.filter_id, fd.name
FROM pr_filter f
LEFT JOIN pr_filter_description fd ON (f.filter_id = fd.filter_id)
WHERE f.filter_id IN (1,2,3,6,7,9,10) AND f.filter_group_id = '1' AND fd.language_id = '2'
ORDER BY f.sort_order, LCASE(fd.name)
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/category.php:33
262 (0.152)
SELECT *
FROM pr_category c
LEFT JOIN pr_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN pr_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '0' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/category.php:10
263 (0.039)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM pr_product_to_category p2c
LEFT JOIN pr_product p ON (p2c.product_id = p.product_id)
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0' AND p2c.category_id = '99'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:587
264 (0.034)
SELECT *
FROM pr_category c
LEFT JOIN pr_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN pr_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '99' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/category.php:10
265 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
266 (0.049)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=99'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
267 (0.031)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM pr_product_to_category p2c
LEFT JOIN pr_product p ON (p2c.product_id = p.product_id)
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0' AND p2c.category_id = '57'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:587
268 (0.031)
SELECT *
FROM pr_category c
LEFT JOIN pr_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN pr_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '57' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/category.php:10
269 (0.028)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
270 (0.042)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
271 (0.028)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM pr_product_to_category p2c
LEFT JOIN pr_product p ON (p2c.product_id = p.product_id)
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0' AND p2c.category_id = '17'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:587
272 (0.031)
SELECT *
FROM pr_category c
LEFT JOIN pr_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN pr_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '17' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/category.php:10
273 (0.023)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
274 (0.027)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=17'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
275 (0.039)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM pr_product_to_category p2c
LEFT JOIN pr_product p ON (p2c.product_id = p.product_id)
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0' AND p2c.category_id = '60'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:587
276 (0.035)
SELECT *
FROM pr_category c
LEFT JOIN pr_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN pr_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '60' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/category.php:10
277 (0.028)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
278 (0.040)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=60'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
279 (0.029)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM pr_product_to_category p2c
LEFT JOIN pr_product p ON (p2c.product_id = p.product_id)
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0' AND p2c.category_id = '59'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:587
280 (0.032)
SELECT *
FROM pr_category c
LEFT JOIN pr_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN pr_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '59' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/category.php:10
281 (0.024)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
282 (0.045)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=59'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
283 (0.029)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM pr_product_to_category p2c
LEFT JOIN pr_product p ON (p2c.product_id = p.product_id)
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0' AND p2c.category_id = '24'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:587
284 (0.044)
SELECT *
FROM pr_category c
LEFT JOIN pr_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN pr_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '24' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/category.php:10
285 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
286 (0.024)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
287 (0.026)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM pr_product_to_category p2c
LEFT JOIN pr_product p ON (p2c.product_id = p.product_id)
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0' AND p2c.category_id = '64'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:587
288 (0.027)
SELECT *
FROM pr_category c
LEFT JOIN pr_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN pr_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '64' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/category.php:10
289 (0.023)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
290 (0.030)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=64'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
291 (0.030)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM pr_product_to_category p2c
LEFT JOIN pr_product p ON (p2c.product_id = p.product_id)
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0' AND p2c.category_id = '65'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:587
292 (0.028)
SELECT *
FROM pr_category c
LEFT JOIN pr_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN pr_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '65' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/category.php:10
293 (0.163)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
294 (0.058)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=65'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
295 (0.039)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM pr_product_to_category p2c
LEFT JOIN pr_product p ON (p2c.product_id = p.product_id)
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0' AND p2c.category_id = '93'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:587
296 (0.046)
SELECT *
FROM pr_category c
LEFT JOIN pr_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN pr_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '93' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/category.php:10
297 (0.034)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM pr_category_path cp
LEFT JOIN pr_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN pr_product p ON (p2c.product_id = p.product_id)
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0' AND cp.path_id = '94'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:587
298 (0.190)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
299 (0.030)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=93'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
300 (0.076)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=94'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
301 (0.050)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM pr_category_path cp
LEFT JOIN pr_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN pr_product p ON (p2c.product_id = p.product_id)
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0' AND cp.path_id = '95'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:587
302 (0.030)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
303 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=93'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
304 (0.029)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=95'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
305 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
306 (0.027)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=93'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
307 (0.031)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM pr_product_to_category p2c
LEFT JOIN pr_product p ON (p2c.product_id = p.product_id)
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0' AND p2c.category_id = '97'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:587
308 (0.029)
SELECT *
FROM pr_category c
LEFT JOIN pr_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN pr_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '97' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/category.php:10
309 (0.029)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
310 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=97'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
311 (0.026)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM pr_product_to_category p2c
LEFT JOIN pr_product p ON (p2c.product_id = p.product_id)
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0' AND p2c.category_id = '67'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:587
312 (0.031)
SELECT *
FROM pr_category c
LEFT JOIN pr_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN pr_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '67' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/category.php:10
313 (0.023)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
314 (0.041)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=67'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
315 (0.039)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM pr_product_to_category p2c
LEFT JOIN pr_product p ON (p2c.product_id = p.product_id)
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0' AND p2c.category_id = '62'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:587
316 (0.033)
SELECT *
FROM pr_category c
LEFT JOIN pr_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN pr_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '62' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/category.php:10
317 (0.023)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
318 (0.025)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=62'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
319 (0.029)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM pr_product_to_category p2c
LEFT JOIN pr_product p ON (p2c.product_id = p.product_id)
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0' AND p2c.category_id = '90'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:587
320 (0.028)
SELECT *
FROM pr_category c
LEFT JOIN pr_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN pr_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '90' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/category.php:10
321 (0.024)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
322 (0.027)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=90'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
323 (0.028)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM pr_product_to_category p2c
LEFT JOIN pr_product p ON (p2c.product_id = p.product_id)
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-06-20' AND p2s.store_id = '0' AND p2c.category_id = '96'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:587
324 (0.033)
SELECT *
FROM pr_category c
LEFT JOIN pr_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN pr_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '96' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/category.php:10
325 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
326 (0.030)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=96'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
327 (0.048)
SELECT *
FROM pr_banner_image bi
LEFT JOIN pr_banner_image_description bid ON (bi.banner_image_id = bid.banner_image_id)
WHERE bi.banner_id = '6' AND bid.language_id = '2'
/home/y/yafinafru/yavinav/public_html/catalog/model/design/banner.php:4
328 (0.035)
SELECT *
FROM pr_category_to_layout
WHERE category_id = '57' AND store_id = '0'
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/category.php:105
329 (0.030)
SELECT *
FROM pr_layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/y/yafinafru/yavinav/public_html/catalog/model/design/layout.php:4
330 (0.049)
SELECT *
FROM pr_extension
WHERE `type` = 'module'
/home/y/yafinafru/yavinav/public_html/catalog/model/setting/extension.php:4
331 (0.085)
SELECT *
FROM pr_category_to_layout
WHERE category_id = '57' AND store_id = '0'
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/category.php:105
332 (0.030)
SELECT *
FROM pr_layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/y/yafinafru/yavinav/public_html/catalog/model/design/layout.php:4
333 (0.057)
SELECT *
FROM pr_extension
WHERE `type` = 'module'
/home/y/yafinafru/yavinav/public_html/catalog/model/setting/extension.php:4
334 (0.063)
SELECT *
FROM pr_category_to_layout
WHERE category_id = '57' AND store_id = '0'
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/category.php:105
335 (0.031)
SELECT *
FROM pr_layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/y/yafinafru/yavinav/public_html/catalog/model/design/layout.php:4
336 (0.050)
SELECT *
FROM pr_extension
WHERE `type` = 'module'
/home/y/yafinafru/yavinav/public_html/catalog/model/setting/extension.php:4
337 (0.120)
SELECT *
FROM pr_information i
LEFT JOIN pr_information_description id ON (i.information_id = id.information_id)
LEFT JOIN pr_information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE id.language_id = '2' AND i2s.store_id = '0' AND i.status = '1'
ORDER BY i.sort_order, LCASE(id.title) ASC
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/information.php:10
338 (0.030)
SELECT *
FROM pr_url_alias
WHERE `query` = 'information/information'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
339 (0.027)
SELECT *
FROM pr_url_alias
WHERE `query` = 'information_id=6'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
340 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'information/information'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
341 (0.027)
SELECT *
FROM pr_url_alias
WHERE `query` = 'information_id=4'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
342 (0.023)
SELECT *
FROM pr_url_alias
WHERE `query` = 'information/information'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
343 (0.044)
SELECT *
FROM pr_url_alias
WHERE `query` = 'information_id=7'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
344 (0.023)
SELECT *
FROM pr_url_alias
WHERE `query` = 'information/information'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
345 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'information_id=3'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
346 (0.023)
SELECT *
FROM pr_url_alias
WHERE `query` = 'information/information'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
347 (0.045)
SELECT *
FROM pr_url_alias
WHERE `query` = 'information_id=5'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
348 (0.023)
SELECT *
FROM pr_url_alias
WHERE `query` = 'information/contact'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
349 (0.024)
SELECT *
FROM pr_url_alias
WHERE `query` = 'account/return/insert'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
350 (0.024)
SELECT *
FROM pr_url_alias
WHERE `query` = 'information/sitemap'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
351 (0.028)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/manufacturer'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
352 (0.024)
SELECT *
FROM pr_url_alias
WHERE `query` = 'account/voucher'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
353 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'affiliate/account'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
354 (0.025)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/special'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
355 (0.023)
SELECT *
FROM pr_url_alias
WHERE `query` = 'account/account'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
356 (0.024)
SELECT *
FROM pr_url_alias
WHERE `query` = 'account/order'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
357 (0.030)
SELECT *
FROM pr_url_alias
WHERE `query` = 'account/wishlist'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
358 (0.024)
SELECT *
FROM pr_url_alias
WHERE `query` = 'account/newsletter'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
359 (0.468)
DELETE
FROM `pr_customer_online`
WHERE (UNIX_TIMESTAMP(`date_added`) + 3600) < UNIX_TIMESTAMP(NOW())
/home/y/yafinafru/yavinav/public_html/catalog/model/tool/online.php:4
360 (0.128)
REPLACE INTO `pr_customer_online` SET `ip` = '3.236.116.27', `customer_id` = '0', `url` = 'http://yavinav.ru/slavjanskie-oberegi', `referer` = '', `date_added` = NOW()
/home/y/yafinafru/yavinav/public_html/catalog/model/tool/online.php:6
361 (0.037)
SELECT *
FROM pr_url_alias
WHERE `query` = 'account/login'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
362 (0.028)
SELECT *
FROM pr_url_alias
WHERE `query` = 'account/register'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
363 (0.024)
SELECT *
FROM pr_url_alias
WHERE `query` = 'account/account'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
364 (0.024)
SELECT *
FROM pr_url_alias
WHERE `query` = 'account/logout'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
365 (0.024)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/showproductall'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
366 (0.028)
SELECT *
FROM pr_url_alias
WHERE `query` = 'common/home'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
367 (0.025)
SELECT *
FROM pr_url_alias
WHERE `query` = 'account/wishlist'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
368 (0.022)
SELECT *
FROM pr_url_alias
WHERE `query` = 'account/account'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
369 (0.023)
SELECT *
FROM pr_url_alias
WHERE `query` = 'checkout/cart'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
370 (0.022)
SELECT *
FROM pr_url_alias
WHERE `query` = 'checkout/checkout'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
371 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'information/about_us'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
372 (0.023)
SELECT *
FROM pr_url_alias
WHERE `query` = 'information/payment_and_delivery'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
373 (0.133)
SELECT *
FROM pr_category c
LEFT JOIN pr_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN pr_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '0' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/category.php:10
374 (0.037)
SELECT *
FROM pr_category c
LEFT JOIN pr_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN pr_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '57' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/category.php:10
375 (0.024)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
376 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
377 (0.030)
SELECT *
FROM pr_category c
LEFT JOIN pr_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN pr_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '17' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/category.php:10
378 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
379 (0.029)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=17'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
380 (0.037)
SELECT *
FROM pr_category c
LEFT JOIN pr_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN pr_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '60' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/category.php:10
381 (0.038)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
382 (0.039)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=60'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
383 (0.029)
SELECT *
FROM pr_category c
LEFT JOIN pr_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN pr_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '59' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/category.php:10
384 (0.028)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
385 (0.028)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=59'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
386 (0.028)
SELECT *
FROM pr_category c
LEFT JOIN pr_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN pr_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '24' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/category.php:10
387 (0.027)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
388 (0.031)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
389 (0.030)
SELECT *
FROM pr_category c
LEFT JOIN pr_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN pr_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '62' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/category.php:10
390 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
391 (0.028)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=62'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
392 (0.043)
SELECT *
FROM pr_url_alias
WHERE `query` = 'pavblog/blogs'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
393 (0.039)
SELECT *
FROM pr_url_alias
WHERE `query` = 'module/language'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
394 (0.036)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
395 (0.034)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
396 (0.036)
SELECT *
FROM pr_url_alias
WHERE `query` = 'module/currency'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
397 (0.063)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
398 (0.033)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
399 (0.093)
SELECT *
FROM pr_extension
WHERE `type` = 'total'
/home/y/yafinafru/yavinav/public_html/catalog/model/setting/extension.php:4
400 (0.082)
SELECT *
FROM pr_url_alias
WHERE `query` = 'checkout/cart'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
401 (0.029)
SELECT *
FROM pr_url_alias
WHERE `query` = 'checkout/checkout'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95