Украшения из Индии ручной работы

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

Украшения из Индии ручной работы

Браслет ин0003"Рубин" серебрение
1700 р.
Браслет ин0005"Малахит" серебрение
1700 р.
Колье ин0008"Топаз" серебрение
3175 р.
Кольцо ин0032"Агат" серебрение
350 р.
Кольцо ин0036"Кварц" серебрение
350 р.
Кольцо ин0047"Рутил кварц" серебрение
1200 р.
Кольцо ин0064"Кварц" серебрение
850 р.
Кулон ин0017"Кварц" серебрение
250 р.
Кулон ин0019"Кварц" серебрение
250 р.
Кулон ин0020"Кварц" серебрение
250 р.
Кулон ин0021"Кварц" серебрение
250 р.
Кулон ин0022"Кварц" серебрение
250 р.
Кулон ин0024"Кварц" серебрение
250 р.
Кулон ю0179"Волосатик" серебро
4000 р.
Кулон ю0357"Аметист треугольный" позолота
1920 р.
Кулон ю0366"Кварц" позолота
2100 р.
Кулон ю0367"Аметист фигурный" позолота
2400 р.
Кулон ю0501"Кварц" серебрение
2340 р.
Кулон ю0502"Кварц" серебрение
1910 р.
Кулон ю0503"Кварц" серебрение
1930 р.
Кулон ю0504"Кварц" серебрение
1870 р.
Серьги ин0009"Кварц" серебрение
480 р.
Серьги ин0010"Раухтопаз" серебрение
480 р.
Серьги ин0011"Кварц" серебрение
480 р.
Серьги ин0013"Кварц" серебрение
480 р.
Серьги ин0015"Аметист" серебрение
480 р.
Серьги ин0016"Кварц" серебрение
480 р.
Серьги ин0061"Топазы" серебрение
1300 р.
Показано с 1 по 28 из 28 (всего 1 страниц)
Queries: 313, Total time: 17.170 ms [By time] [By id] [By file]
1 (0.045)
SELECT *
FROM pr_store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://yavinav.ru/'
/home/y/yafinafru/yavinav/public_html/index.php:50
2 (0.750)
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.080)
SELECT *
FROM pr_currency
/home/y/yafinafru/yavinav/public_html/system/library/currency.php:13
5 (0.032)
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.106)
SELECT *
FROM pr_url_alias
WHERE keyword = 'Ukrasheniya-iz-Indii-ruchnoj-raboty'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:15
8 (0.161)
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.082)
SELECT *
FROM pr_url_alias
WHERE `query` = 'common/home'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
10 (0.041)
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 = '97' 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.032)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
12 (0.029)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=97'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
13 (0.098)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/compare'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
14 (0.043)
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
15 (0.036)
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-03-19' 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
16 (0.068)
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-03-19') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-03-19'))
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-03-19') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-03-19'))
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-03-19' AND p2s.store_id = '0' AND p2c.category_id = '97' 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 (0.079)
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-03-19') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-03-19'))
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-03-19') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-03-19'))
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 = '2910' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-03-19' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
18 (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-03-19') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-03-19'))
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-03-19') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-03-19'))
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 = '2915' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-03-19' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
19 (0.128)
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-03-19') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-03-19'))
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-03-19') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-03-19'))
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 = '2918' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-03-19' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
20 (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-03-19') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-03-19'))
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-03-19') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-03-19'))
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 = '2942' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-03-19' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
21 (0.091)
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-03-19') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-03-19'))
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-03-19') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-03-19'))
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 = '2946' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-03-19' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
22 (0.106)
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-03-19') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-03-19'))
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-03-19') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-03-19'))
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 = '2988' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-03-19' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
23 (0.065)
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-03-19') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-03-19'))
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-03-19') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-03-19'))
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 = '3029' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-03-19' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
24 (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-03-19') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-03-19'))
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-03-19') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-03-19'))
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 = '2927' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-03-19' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
25 (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-03-19') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-03-19'))
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-03-19') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-03-19'))
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 = '2929' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-03-19' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
26 (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-03-19') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-03-19'))
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-03-19') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-03-19'))
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 = '2930' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-03-19' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
27 (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-03-19') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-03-19'))
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-03-19') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-03-19'))
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 = '2931' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-03-19' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
28 (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-03-19') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-03-19'))
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-03-19') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-03-19'))
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 = '2932' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-03-19' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
29 (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-03-19') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-03-19'))
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-03-19') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-03-19'))
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 = '2934' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-03-19' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
30 (0.095)
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-03-19') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-03-19'))
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-03-19') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-03-19'))
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 = '2244' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-03-19' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
31 (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-03-19') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-03-19'))
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-03-19') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-03-19'))
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 = '1692' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-03-19' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
32 (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-03-19') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-03-19'))
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-03-19') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-03-19'))
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 = '2038' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-03-19' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
33 (0.106)
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-03-19') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-03-19'))
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-03-19') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-03-19'))
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 = '2039' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-03-19' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
34 (0.097)
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-03-19') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-03-19'))
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-03-19') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-03-19'))
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 = '2300' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-03-19' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
35 (0.131)
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-03-19') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-03-19'))
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-03-19') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-03-19'))
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 = '2301' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-03-19' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
36 (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-03-19') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-03-19'))
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-03-19') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-03-19'))
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 = '2302' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-03-19' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
37 (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-03-19') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-03-19'))
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-03-19') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-03-19'))
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 = '2303' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-03-19' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
38 (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-03-19') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-03-19'))
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-03-19') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-03-19'))
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 = '2919' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-03-19' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
39 (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-03-19') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-03-19'))
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-03-19') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-03-19'))
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 = '2920' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-03-19' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
40 (0.105)
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-03-19') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-03-19'))
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-03-19') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-03-19'))
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 = '2921' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-03-19' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
41 (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-03-19') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-03-19'))
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-03-19') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-03-19'))
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 = '2923' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-03-19' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
42 (0.130)
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-03-19') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-03-19'))
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-03-19') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-03-19'))
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 = '2925' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-03-19' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
43 (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-03-19') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-03-19'))
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-03-19') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-03-19'))
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 = '2926' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-03-19' 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-03-19') AND (pd2.date_end = '0000-00-00' OR pd2.date_end > '2024-03-19'))
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-03-19') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-03-19'))
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 = '3022' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-03-19' AND p2s.store_id = '0'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:25
45 (0.037)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
46 (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
47 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=2910'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
48 (0.032)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
49 (0.028)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=97'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
50 (0.028)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=2915'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
51 (0.029)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
52 (0.025)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=97'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
53 (0.049)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=2918'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
54 (0.028)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
55 (0.031)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=97'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
56 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=2942'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
57 (0.031)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
58 (0.030)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=97'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
59 (0.031)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=2946'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
60 (0.091)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
61 (0.031)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=97'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
62 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=2988'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
63 (0.029)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
64 (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
65 (0.025)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=3029'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
66 (0.032)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
67 (0.030)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=97'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
68 (0.073)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=2927'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
69 (0.027)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
70 (0.030)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=97'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
71 (0.030)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=2929'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
72 (0.030)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
73 (0.061)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=97'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
74 (0.044)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=2930'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
75 (0.028)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
76 (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
77 (0.025)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=2931'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
78 (0.048)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
79 (0.047)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=97'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
80 (0.030)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=2932'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
81 (0.041)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
82 (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
83 (0.023)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=2934'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
84 (0.059)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
85 (0.025)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=97'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
86 (0.025)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=2244'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
87 (0.027)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
88 (0.025)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=97'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
89 (0.029)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=1692'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
90 (0.031)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
91 (0.046)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=97'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
92 (0.042)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=2038'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
93 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
94 (0.029)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=97'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
95 (0.024)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=2039'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
96 (0.088)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
97 (0.035)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=97'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
98 (0.046)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=2300'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
99 (0.039)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
100 (0.082)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=97'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
101 (0.030)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=2301'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
102 (0.065)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
103 (0.050)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=97'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
104 (0.041)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=2302'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
105 (0.034)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
106 (0.030)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=97'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
107 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=2303'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
108 (0.040)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
109 (0.029)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=97'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
110 (0.421)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=2919'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
111 (0.029)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
112 (0.045)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=97'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
113 (0.023)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=2920'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
114 (0.074)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
115 (0.025)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=97'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
116 (0.031)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=2921'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
117 (0.034)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
118 (0.068)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=97'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
119 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=2923'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
120 (0.027)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
121 (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
122 (0.027)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=2925'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
123 (0.032)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
124 (0.027)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=97'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
125 (0.064)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=2926'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
126 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
127 (0.023)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=97'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
128 (0.024)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=3022'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
129 (0.021)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
130 (0.023)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=97'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
131 (0.019)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
132 (0.019)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
133 (0.021)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
134 (0.025)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=97'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
135 (0.024)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
136 (0.022)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
137 (0.025)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
138 (0.025)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=97'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
139 (0.039)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
140 (0.019)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
141 (0.021)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
142 (0.024)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=97'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
143 (0.021)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
144 (0.019)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
145 (0.020)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
146 (0.022)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=97'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
147 (0.019)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
148 (0.019)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
149 (0.021)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
150 (0.025)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=97'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
151 (0.019)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
152 (0.020)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
153 (0.027)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=97'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
154 (0.023)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
155 (0.023)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
156 (0.027)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=97'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
157 (0.022)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
158 (0.021)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
159 (0.022)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=97'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
160 (0.020)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
161 (0.022)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
162 (0.028)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=97'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
163 (0.021)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
164 (0.044)
SELECT *
FROM pr_url_alias
WHERE `query` = 'common/home'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
165 (0.040)
SELECT *
FROM pr_category_to_layout
WHERE category_id = '97' AND store_id = '0'
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/category.php:105
166 (0.035)
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
167 (0.066)
SELECT *
FROM pr_extension
WHERE `type` = 'module'
/home/y/yafinafru/yavinav/public_html/catalog/model/setting/extension.php:4
168 (0.091)
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 = '97' 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
169 (0.085)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
170 (0.031)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=97'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
171 (0.036)
SELECT filter_id
FROM pr_category_filter
WHERE category_id = '97'
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/category.php:18
172 (0.051)
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,3,6,9,10,14) 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
173 (0.060)
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,3,6,9,10,14) 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
174 (0.165)
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
175 (0.078)
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-03-19' 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
176 (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 = '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
177 (0.046)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
178 (1.237)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=99'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
179 (0.036)
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-03-19' 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
180 (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 = '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
181 (0.025)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
182 (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
183 (0.042)
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-03-19' 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
184 (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 = '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
185 (0.023)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
186 (0.023)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=17'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
187 (0.027)
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-03-19' 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
188 (0.047)
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
189 (0.029)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
190 (0.030)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=60'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
191 (0.027)
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-03-19' 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
192 (0.056)
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
193 (0.022)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
194 (0.038)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=59'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
195 (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-03-19' 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
196 (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 = '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
197 (0.021)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
198 (0.025)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
199 (0.025)
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-03-19' 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
200 (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
201 (0.020)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
202 (0.053)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=64'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
203 (0.027)
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-03-19' 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
204 (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
205 (0.042)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
206 (0.046)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=65'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
207 (0.025)
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-03-19' 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
208 (0.042)
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
209 (0.025)
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-03-19' 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
210 (0.036)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
211 (0.029)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=93'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
212 (0.023)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=94'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
213 (0.024)
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-03-19' 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
214 (0.022)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
215 (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
216 (0.023)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=95'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
217 (0.022)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
218 (0.044)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=93'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
219 (0.040)
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-03-19' 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
220 (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
221 (0.021)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
222 (0.024)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=97'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
223 (0.046)
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-03-19' 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
224 (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 = '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
225 (0.038)
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=67'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
227 (0.081)
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-03-19' 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
228 (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
229 (0.027)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
230 (0.045)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=62'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
231 (0.024)
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-03-19' 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
232 (0.024)
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
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.025)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=90'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
235 (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-03-19' 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
236 (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 = '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
237 (0.024)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
238 (0.023)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=96'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
239 (0.037)
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
240 (0.036)
SELECT *
FROM pr_category_to_layout
WHERE category_id = '97' AND store_id = '0'
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/category.php:105
241 (0.027)
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
242 (0.040)
SELECT *
FROM pr_extension
WHERE `type` = 'module'
/home/y/yafinafru/yavinav/public_html/catalog/model/setting/extension.php:4
243 (0.030)
SELECT *
FROM pr_category_to_layout
WHERE category_id = '97' AND store_id = '0'
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/category.php:105
244 (0.026)
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
245 (0.060)
SELECT *
FROM pr_extension
WHERE `type` = 'module'
/home/y/yafinafru/yavinav/public_html/catalog/model/setting/extension.php:4
246 (0.046)
SELECT *
FROM pr_category_to_layout
WHERE category_id = '97' AND store_id = '0'
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/category.php:105
247 (0.028)
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
248 (0.044)
SELECT *
FROM pr_extension
WHERE `type` = 'module'
/home/y/yafinafru/yavinav/public_html/catalog/model/setting/extension.php:4
249 (0.064)
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
250 (0.027)
SELECT *
FROM pr_url_alias
WHERE `query` = 'information/information'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
251 (0.024)
SELECT *
FROM pr_url_alias
WHERE `query` = 'information_id=6'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
252 (0.021)
SELECT *
FROM pr_url_alias
WHERE `query` = 'information/information'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
253 (0.028)
SELECT *
FROM pr_url_alias
WHERE `query` = 'information_id=4'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
254 (0.020)
SELECT *
FROM pr_url_alias
WHERE `query` = 'information/information'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
255 (0.054)
SELECT *
FROM pr_url_alias
WHERE `query` = 'information_id=7'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
256 (0.020)
SELECT *
FROM pr_url_alias
WHERE `query` = 'information/information'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
257 (0.023)
SELECT *
FROM pr_url_alias
WHERE `query` = 'information_id=3'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
258 (0.022)
SELECT *
FROM pr_url_alias
WHERE `query` = 'information/information'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
259 (0.025)
SELECT *
FROM pr_url_alias
WHERE `query` = 'information_id=5'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
260 (0.020)
SELECT *
FROM pr_url_alias
WHERE `query` = 'information/contact'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
261 (0.020)
SELECT *
FROM pr_url_alias
WHERE `query` = 'account/return/insert'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
262 (0.031)
SELECT *
FROM pr_url_alias
WHERE `query` = 'information/sitemap'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
263 (0.025)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/manufacturer'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
264 (0.024)
SELECT *
FROM pr_url_alias
WHERE `query` = 'account/voucher'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
265 (0.023)
SELECT *
FROM pr_url_alias
WHERE `query` = 'affiliate/account'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
266 (0.039)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/special'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
267 (0.023)
SELECT *
FROM pr_url_alias
WHERE `query` = 'account/account'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
268 (0.019)
SELECT *
FROM pr_url_alias
WHERE `query` = 'account/order'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
269 (0.019)
SELECT *
FROM pr_url_alias
WHERE `query` = 'account/wishlist'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
270 (0.036)
SELECT *
FROM pr_url_alias
WHERE `query` = 'account/newsletter'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
271 (2.220)
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
272 (0.150)
REPLACE INTO `pr_customer_online` SET `ip` = '34.229.223.223', `customer_id` = '0', `url` = 'http://yavinav.ru/Ukrasheniya-iz-Indii-ruchnoj-raboty', `referer` = '', `date_added` = NOW()
/home/y/yafinafru/yavinav/public_html/catalog/model/tool/online.php:6
273 (0.075)
SELECT *
FROM pr_url_alias
WHERE `query` = 'account/login'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
274 (0.034)
SELECT *
FROM pr_url_alias
WHERE `query` = 'account/register'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
275 (0.029)
SELECT *
FROM pr_url_alias
WHERE `query` = 'account/account'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
276 (0.046)
SELECT *
FROM pr_url_alias
WHERE `query` = 'account/logout'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
277 (0.027)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/showproductall'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
278 (0.051)
SELECT *
FROM pr_url_alias
WHERE `query` = 'common/home'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
279 (0.044)
SELECT *
FROM pr_url_alias
WHERE `query` = 'account/wishlist'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
280 (0.024)
SELECT *
FROM pr_url_alias
WHERE `query` = 'account/account'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
281 (0.025)
SELECT *
FROM pr_url_alias
WHERE `query` = 'checkout/cart'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
282 (0.023)
SELECT *
FROM pr_url_alias
WHERE `query` = 'checkout/checkout'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
283 (0.040)
SELECT *
FROM pr_url_alias
WHERE `query` = 'information/about_us'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
284 (0.021)
SELECT *
FROM pr_url_alias
WHERE `query` = 'information/payment_and_delivery'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
285 (0.142)
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
286 (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 = '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
287 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
288 (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
289 (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 = '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
290 (0.022)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
291 (0.021)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=17'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
292 (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 = '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
293 (0.020)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
294 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=60'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
295 (0.025)
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
296 (0.021)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
297 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=59'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
298 (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
299 (0.024)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
300 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
301 (0.043)
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
302 (0.021)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
303 (0.041)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=62'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
304 (0.025)
SELECT *
FROM pr_url_alias
WHERE `query` = 'pavblog/blogs'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
305 (0.031)
SELECT *
FROM pr_url_alias
WHERE `query` = 'module/language'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
306 (0.030)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
307 (0.025)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=97'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
308 (0.099)
SELECT *
FROM pr_url_alias
WHERE `query` = 'module/currency'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
309 (0.030)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
310 (0.030)
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.096)
SELECT *
FROM pr_extension
WHERE `type` = 'total'
/home/y/yafinafru/yavinav/public_html/catalog/model/setting/extension.php:4
312 (0.073)
SELECT *
FROM pr_url_alias
WHERE `query` = 'checkout/cart'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
313 (0.024)
SELECT *
FROM pr_url_alias
WHERE `query` = 'checkout/checkout'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95