Эксклюзивные украшения ручной работы. Украшения с натуральными камнями и кристаллами Swarovski.

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

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

Браслет ю0307"Янтарь" серебро
2500 р.
Браслет ю0308"Янтарь" серебро
3500 р.
Браслет ю0736 "Перламутр" серебрение
2250 р.
Браслет ю0850 "Розовый кварц" серебрение
400 р.
Браслет ю0854 "Майорка" серебрение
200 р.
Браслет ю0880 "Цитрин" латунь, серебрение
850 р.
Браслет ю0890 "Кот" латунь
1000 р.
Брошь ю0816 "Винтажная с фианитом" латунь
1500 р.
Заколка для волос ю0795 "Винтажная с жемчугом" латунь
1000 р.
Колье ю0007"Крест на ленте"
850 р.
Колье ю0008"Крест на ленте"зеленый
850 р.
Колье ю0061"Жемчуг белый"
1650 р.
Колье ю0062"Жемчуг белый продолговатый"
1600 р.
Колье ю0135"Бронзовый котик" бронза
1200 р.
Колье ю0141"Бронза и аметист" бронза
1800 р.
Колье ю0633"Царевна лягушка" латунь
950 р.
Колье ю0675 "Бирюза" серебрение
2500 р.
Колье ю0680 "Белый жемчуг" серебрение
1500 р.
Колье ю0682 "Swarovski" серебрение
2200 р.
Колье ю0737 "Винтажное" латунь
1800 р.
Колье ю0738 "Хризопраз" латунь
1600 р.
Колье ю0740 "Ольха" латунь
3500 р.
Колье ю0741 "Листья ландышей" меднение
3200 р.
Колье ю0742 "Скарабей" латунь
1850 р.
Колье ю0743 "Скарабей" латунь
1850 р.
Колье ю0745 "Жук полосатый" латунь
1700 р.
Колье ю0747 "Аметист" латунь
1350 р.
Колье ю0750 "Капли дождя" латунь
800 р.
Колье ю0753.1 "Снежные шары" латунь
1400 р.
Колье ю0756 "Анх" латунь
1000 р.
Колье ю0759.1 "Лазурит" серебрение
1700 р.
Колье ю0760.1 "Коралл" серебрение
1200 р.
Колье ю0798 "Нефрит" латунь
3000 р.
Колье ю0799 "Розовый кварц" латунь
4200 р.
Колье ю0801 "Нефрит" серебрение
4500 р.
Колье ю0810 "Винтажное с кристаллом Swarovski" серебрение
2500 р.
Колье ю0811 "Винтажное с кристаллом Swarovski" серебрение
1700 р.
Колье ю0851 "Майорка" серебрение
400 р.
Колье ю0874 "Аметист" латунь,серебрение
3700 р.
Колье ю0875 "Листья ландыша" латунь
3500 р.
Колье ю0876 "Змеевик" латунь
1600 р.
Колье ю0877 "Жемчуг" латунь,серебрение
1500 р.
Колье ю0881 "Жемчуг" латунь, серебрение
2000 р.
Колье ю0882 "Малахит с латунью" латунь
1100 р.
Колье ю0884 "Ключик" латунь
1000 р.
Колье ю0885 "Рококо" латунь
1200 р.
Колье ю0886 "Цветы с жемчугом" латунь
2100 р.
Колье ю0888 "Треугольник с хризолитом" латунь
1250 р.
Кольцо ив0003"Агат" серебро
7000 р.
Кольцо ю0589"Флоренция" серебрение
1300 р.
Показано с 1 по 50 из 252 (всего 6 страниц)
Queries: 401, Total time: 21.963 ms [By time] [By id] [By file]
1 (0.051)
SELECT *
FROM pr_store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://yavinav.ru/'
/home/y/yafinafru/yavinav/public_html/index.php:50
2 (0.753)
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.107)
SELECT *
FROM `pr_language`
WHERE status = '1'
/home/y/yafinafru/yavinav/public_html/index.php:141
4 (0.046)
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.028)
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.077)
SELECT *
FROM pr_url_alias
WHERE keyword = 'Ukrasheniya-s-naturalnymi-kamnyami-i-kristallami-Swarovski'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:15
8 (0.146)
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.078)
SELECT *
FROM pr_url_alias
WHERE `query` = 'common/home'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
10 (0.051)
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 = '90' 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.028)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
12 (0.025)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=90'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
13 (0.027)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/compare'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
14 (0.033)
SELECT *
FROM pr_category c
LEFT JOIN pr_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN pr_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '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
15 (0.043)
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
16 (0.094)
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 = '90' 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.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 = '2246' 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.093)
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 = '2245' 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.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 = '3585' 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.092)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start <= '2024-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 = '3920' 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.085)
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 = '3922' 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.087)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start <= '2024-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 = '4216' 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.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 = '4225' 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 = '3875' 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.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 = '3847' 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.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 = '1885' 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.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 = '4270' 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.119)
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 = '2191' 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.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 = '2192' 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.114)
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 = '2188' 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.071)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start <= '2024-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 = '1833' 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.063)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start <= '2024-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 = '2952' 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.060)
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 = '3490' 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.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 = '3495' 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.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 = '3497' 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 = '3586' 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.113)
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 = '3587' 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.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 = '3589' 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.063)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start <= '2024-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 = '3590' 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.062)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start <= '2024-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 = '3591' 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.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 = '3592' 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.089)
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 = '3594' 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.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 = '3596' 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.085)
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 = '3654' 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.080)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start <= '2024-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 = '3785' 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
46 (0.073)
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 = '3660' 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
47 (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 = '3791' 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
48 (0.062)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start <= '2024-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 = '3792' 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
49 (0.089)
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 = '3857' 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
50 (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 = '3858' 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
51 (0.107)
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 = '3860' 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
52 (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 = '3869' 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
53 (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 = '3870' 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
54 (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 = '3921' 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
55 (0.075)
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 = '4211' 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
56 (0.108)
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 = '4212' 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
57 (0.073)
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 = '4213' 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
58 (0.094)
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 = '4214' 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
59 (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 = '4217' 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
60 (0.071)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM pr_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start <= '2024-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 = '4218' 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
61 (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 = '4220' 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
62 (0.075)
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 = '4221' 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
63 (0.075)
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 = '4222' 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
64 (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 = '4224' 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
65 (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 = '2981' 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
66 (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 = '2625' 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
67 (0.068)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
68 (0.031)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=90'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
69 (0.044)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=2246'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
70 (0.086)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
71 (0.034)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=90'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
72 (0.031)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=2245'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
73 (0.080)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
74 (0.036)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=90'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
75 (0.028)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=3585'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
76 (0.071)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
77 (0.033)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=90'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
78 (0.024)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=3920'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
79 (0.029)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
80 (0.029)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=90'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
81 (0.032)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=3922'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
82 (0.057)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
83 (0.028)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=90'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
84 (0.029)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=4216'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
85 (0.034)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
86 (0.031)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=90'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
87 (0.029)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=4225'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
88 (0.058)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
89 (0.044)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=90'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
90 (0.063)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=3875'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
91 (0.044)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
92 (0.030)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=90'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
93 (0.031)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=3847'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
94 (0.038)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
95 (0.063)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=90'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
96 (0.043)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=1885'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
97 (0.027)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
98 (0.028)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=90'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
99 (0.023)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=4270'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
100 (0.049)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
101 (0.034)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=90'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
102 (0.033)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=2191'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
103 (0.070)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
104 (0.043)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=90'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
105 (0.029)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=2192'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
106 (0.068)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
107 (0.029)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=90'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
108 (0.030)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=2188'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
109 (0.030)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
110 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=90'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
111 (0.057)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=1833'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
112 (0.046)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
113 (0.024)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=90'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
114 (0.023)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=2952'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
115 (0.029)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
116 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=90'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
117 (0.024)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=3490'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
118 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
119 (0.093)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=90'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
120 (0.034)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=3495'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
121 (0.051)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
122 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=90'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
123 (0.025)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=3497'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
124 (0.033)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
125 (0.029)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=90'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
126 (0.083)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=3586'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
127 (0.059)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
128 (0.025)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=90'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
129 (0.028)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=3587'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
130 (0.091)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
131 (0.028)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=90'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
132 (0.031)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=3589'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
133 (0.054)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
134 (0.027)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=90'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
135 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=3590'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
136 (0.035)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
137 (0.030)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=90'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
138 (0.027)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=3591'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
139 (0.057)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
140 (0.044)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=90'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
141 (0.034)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=3592'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
142 (0.033)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
143 (0.031)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=90'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
144 (0.027)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=3594'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
145 (0.055)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
146 (0.027)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=90'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
147 (0.028)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=3596'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
148 (0.032)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
149 (0.031)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=90'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
150 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=3654'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
151 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
152 (0.027)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=90'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
153 (0.021)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=3785'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
154 (0.025)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
155 (0.022)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=90'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
156 (0.024)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=3660'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
157 (0.056)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
158 (0.030)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=90'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
159 (0.023)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=3791'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
160 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
161 (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
162 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=3792'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
163 (0.053)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
164 (0.027)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=90'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
165 (0.025)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=3857'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
166 (0.084)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
167 (0.030)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=90'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
168 (0.031)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=3858'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
169 (0.027)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
170 (0.043)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=90'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
171 (0.023)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=3860'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
172 (0.032)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
173 (0.031)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=90'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
174 (0.042)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=3869'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
175 (0.066)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
176 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=90'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
177 (0.025)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=3870'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
178 (0.071)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
179 (0.028)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=90'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
180 (0.062)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=3921'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
181 (0.028)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
182 (0.027)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=90'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
183 (0.027)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=4211'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
184 (0.029)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
185 (0.030)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=90'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
186 (0.042)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=4212'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
187 (0.027)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
188 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=90'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
189 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=4213'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
190 (0.029)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
191 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=90'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
192 (0.042)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=4214'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
193 (0.027)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
194 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=90'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
195 (0.030)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=4217'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
196 (0.067)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
197 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=90'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
198 (0.029)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=4218'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
199 (0.062)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
200 (0.028)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=90'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
201 (0.036)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=4220'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
202 (0.027)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
203 (0.028)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=90'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
204 (0.023)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=4221'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
205 (0.031)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
206 (0.033)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=90'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
207 (0.092)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=4222'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
208 (0.039)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
209 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=90'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
210 (0.028)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=4224'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
211 (0.063)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
212 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=90'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
213 (0.028)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=2981'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
214 (0.062)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/product'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
215 (0.045)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=90'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
216 (0.027)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product_id=2625'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
217 (0.025)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
218 (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
219 (0.022)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
220 (0.020)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
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.021)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=90'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
223 (0.021)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
224 (0.020)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
225 (0.021)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
226 (0.024)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=90'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
227 (0.020)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
228 (0.021)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
229 (0.024)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
230 (0.024)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=90'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
231 (0.021)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
232 (0.021)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
233 (0.023)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
234 (0.061)
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.020)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
236 (0.019)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
237 (0.021)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
238 (0.021)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=90'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
239 (0.021)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
240 (0.021)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
241 (0.024)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=90'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
242 (0.019)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
243 (0.020)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
244 (0.021)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=90'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
245 (0.021)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
246 (0.038)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
247 (0.049)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=90'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
248 (0.022)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
249 (0.022)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
250 (0.023)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=90'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
251 (0.022)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
252 (0.028)
SELECT *
FROM pr_url_alias
WHERE `query` = 'common/home'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
253 (0.040)
SELECT *
FROM pr_category_to_layout
WHERE category_id = '90' AND store_id = '0'
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/category.php:105
254 (0.099)
SELECT *
FROM pr_layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/y/yafinafru/yavinav/public_html/catalog/model/design/layout.php:4
255 (0.109)
SELECT *
FROM pr_extension
WHERE `type` = 'module'
/home/y/yafinafru/yavinav/public_html/catalog/model/setting/extension.php:4
256 (0.116)
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 = '90' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/category.php:4
257 (0.037)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
258 (0.030)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=90'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
259 (0.048)
SELECT filter_id
FROM pr_category_filter
WHERE category_id = '90'
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/category.php:18
260 (0.032)
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,15,16) AND fgd.language_id = '2' GROUP BY f.filter_group_id
ORDER BY fg.sort_order, LCASE(fgd.name)
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/category.php:28
261 (0.054)
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,15,16) AND f.filter_group_id = '1' AND fd.language_id = '2'
ORDER BY f.sort_order, LCASE(fd.name)
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/category.php:33
262 (0.145)
SELECT *
FROM pr_category c
LEFT JOIN pr_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN pr_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '0' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/category.php:10
263 (0.043)
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
264 (0.035)
SELECT *
FROM pr_category c
LEFT JOIN pr_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN pr_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '99' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/category.php:10
265 (0.025)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
266 (0.025)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=99'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
267 (0.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
268 (0.033)
SELECT *
FROM pr_category c
LEFT JOIN pr_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN pr_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '57' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/category.php:10
269 (0.025)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
270 (0.031)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
271 (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 = '17'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:587
272 (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
273 (0.024)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
274 (0.024)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=17'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
275 (0.032)
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
276 (0.033)
SELECT *
FROM pr_category c
LEFT JOIN pr_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN pr_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '60' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/category.php:10
277 (0.023)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
278 (0.028)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=60'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
279 (0.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 = '59'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:587
280 (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 = '59' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/category.php:10
281 (0.031)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
282 (0.031)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=59'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
283 (0.034)
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
284 (0.052)
SELECT *
FROM pr_category c
LEFT JOIN pr_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN pr_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '24' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/category.php:10
285 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
286 (0.030)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
287 (0.033)
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
288 (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 = '64' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/category.php:10
289 (0.070)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
290 (0.023)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=64'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
291 (0.028)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM pr_product_to_category p2c
LEFT JOIN pr_product p ON (p2c.product_id = p.product_id)
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-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
292 (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 = '65' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/category.php:10
293 (0.021)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
294 (0.035)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=65'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
295 (0.030)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM pr_product_to_category p2c
LEFT JOIN pr_product p ON (p2c.product_id = p.product_id)
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-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
296 (0.061)
SELECT *
FROM pr_category c
LEFT JOIN pr_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN pr_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '93' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/category.php:10
297 (0.031)
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
298 (0.029)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
299 (0.050)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=93'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
300 (0.027)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=94'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
301 (0.030)
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
302 (0.025)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
303 (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
304 (0.029)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=95'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
305 (0.043)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
306 (0.050)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=93'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
307 (0.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 = '97'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:587
308 (0.029)
SELECT *
FROM pr_category c
LEFT JOIN pr_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN pr_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '97' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/category.php:10
309 (0.023)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
310 (0.043)
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.028)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM pr_product_to_category p2c
LEFT JOIN pr_product p ON (p2c.product_id = p.product_id)
LEFT JOIN pr_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN pr_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= '2024-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
312 (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 = '67' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/category.php:10
313 (0.021)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
314 (0.025)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=67'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
315 (0.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 = '62'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:587
316 (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 = '62' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/category.php:10
317 (0.024)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
318 (0.025)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=62'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
319 (0.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 = '90'
/home/y/yafinafru/yavinav/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:587
320 (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 = '90' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/category.php:10
321 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
322 (0.029)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=90'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
323 (0.035)
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
324 (0.065)
SELECT *
FROM pr_category c
LEFT JOIN pr_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN pr_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '96' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/category.php:10
325 (0.020)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
326 (0.025)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=96'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
327 (0.049)
SELECT *
FROM pr_banner_image bi
LEFT JOIN pr_banner_image_description bid ON (bi.banner_image_id = bid.banner_image_id)
WHERE bi.banner_id = '6' AND bid.language_id = '2'
/home/y/yafinafru/yavinav/public_html/catalog/model/design/banner.php:4
328 (0.035)
SELECT *
FROM pr_category_to_layout
WHERE category_id = '90' AND store_id = '0'
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/category.php:105
329 (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
330 (0.060)
SELECT *
FROM pr_extension
WHERE `type` = 'module'
/home/y/yafinafru/yavinav/public_html/catalog/model/setting/extension.php:4
331 (0.059)
SELECT *
FROM pr_category_to_layout
WHERE category_id = '90' AND store_id = '0'
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/category.php:105
332 (0.037)
SELECT *
FROM pr_layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/y/yafinafru/yavinav/public_html/catalog/model/design/layout.php:4
333 (0.065)
SELECT *
FROM pr_extension
WHERE `type` = 'module'
/home/y/yafinafru/yavinav/public_html/catalog/model/setting/extension.php:4
334 (0.037)
SELECT *
FROM pr_category_to_layout
WHERE category_id = '90' AND store_id = '0'
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/category.php:105
335 (0.034)
SELECT *
FROM pr_layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/y/yafinafru/yavinav/public_html/catalog/model/design/layout.php:4
336 (0.048)
SELECT *
FROM pr_extension
WHERE `type` = 'module'
/home/y/yafinafru/yavinav/public_html/catalog/model/setting/extension.php:4
337 (0.112)
SELECT *
FROM pr_information i
LEFT JOIN pr_information_description id ON (i.information_id = id.information_id)
LEFT JOIN pr_information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE id.language_id = '2' AND i2s.store_id = '0' AND i.status = '1'
ORDER BY i.sort_order, LCASE(id.title) ASC
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/information.php:10
338 (0.027)
SELECT *
FROM pr_url_alias
WHERE `query` = 'information/information'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
339 (0.025)
SELECT *
FROM pr_url_alias
WHERE `query` = 'information_id=6'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
340 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'information/information'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
341 (0.032)
SELECT *
FROM pr_url_alias
WHERE `query` = 'information_id=4'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
342 (0.033)
SELECT *
FROM pr_url_alias
WHERE `query` = 'information/information'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
343 (0.052)
SELECT *
FROM pr_url_alias
WHERE `query` = 'information_id=7'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
344 (0.029)
SELECT *
FROM pr_url_alias
WHERE `query` = 'information/information'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
345 (0.062)
SELECT *
FROM pr_url_alias
WHERE `query` = 'information_id=3'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
346 (0.042)
SELECT *
FROM pr_url_alias
WHERE `query` = 'information/information'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
347 (0.029)
SELECT *
FROM pr_url_alias
WHERE `query` = 'information_id=5'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:73
348 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'information/contact'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
349 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'account/return/insert'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
350 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'information/sitemap'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
351 (0.028)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/manufacturer'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
352 (0.027)
SELECT *
FROM pr_url_alias
WHERE `query` = 'account/voucher'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
353 (0.027)
SELECT *
FROM pr_url_alias
WHERE `query` = 'affiliate/account'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
354 (0.028)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/special'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
355 (0.053)
SELECT *
FROM pr_url_alias
WHERE `query` = 'account/account'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
356 (0.029)
SELECT *
FROM pr_url_alias
WHERE `query` = 'account/order'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
357 (0.025)
SELECT *
FROM pr_url_alias
WHERE `query` = 'account/wishlist'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
358 (0.023)
SELECT *
FROM pr_url_alias
WHERE `query` = 'account/newsletter'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
359 (2.992)
DELETE
FROM `pr_customer_online`
WHERE (UNIX_TIMESTAMP(`date_added`) + 3600) < UNIX_TIMESTAMP(NOW())
/home/y/yafinafru/yavinav/public_html/catalog/model/tool/online.php:4
360 (0.115)
REPLACE INTO `pr_customer_online` SET `ip` = '54.225.1.66', `customer_id` = '0', `url` = 'http://yavinav.ru/Ukrasheniya-s-naturalnymi-kamnyami-i-kristallami-Swarovski', `referer` = '', `date_added` = NOW()
/home/y/yafinafru/yavinav/public_html/catalog/model/tool/online.php:6
361 (0.069)
SELECT *
FROM pr_url_alias
WHERE `query` = 'account/login'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
362 (0.039)
SELECT *
FROM pr_url_alias
WHERE `query` = 'account/register'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
363 (0.035)
SELECT *
FROM pr_url_alias
WHERE `query` = 'account/account'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
364 (0.052)
SELECT *
FROM pr_url_alias
WHERE `query` = 'account/logout'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
365 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/showproductall'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
366 (0.025)
SELECT *
FROM pr_url_alias
WHERE `query` = 'common/home'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
367 (0.020)
SELECT *
FROM pr_url_alias
WHERE `query` = 'account/wishlist'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
368 (0.022)
SELECT *
FROM pr_url_alias
WHERE `query` = 'account/account'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
369 (0.023)
SELECT *
FROM pr_url_alias
WHERE `query` = 'checkout/cart'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
370 (0.020)
SELECT *
FROM pr_url_alias
WHERE `query` = 'checkout/checkout'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
371 (0.023)
SELECT *
FROM pr_url_alias
WHERE `query` = 'information/about_us'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
372 (0.020)
SELECT *
FROM pr_url_alias
WHERE `query` = 'information/payment_and_delivery'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
373 (0.126)
SELECT *
FROM pr_category c
LEFT JOIN pr_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN pr_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '0' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/category.php:10
374 (0.046)
SELECT *
FROM pr_category c
LEFT JOIN pr_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN pr_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '57' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/category.php:10
375 (0.025)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
376 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=57'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
377 (0.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
378 (0.040)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
379 (0.022)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=17'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
380 (0.035)
SELECT *
FROM pr_category c
LEFT JOIN pr_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN pr_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '60' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/category.php:10
381 (0.024)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
382 (0.025)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=60'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
383 (0.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 = '59' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/category.php:10
384 (0.035)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
385 (0.024)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=59'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
386 (0.026)
SELECT *
FROM pr_category c
LEFT JOIN pr_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN pr_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '24' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/category.php:10
387 (0.021)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
388 (0.021)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=24'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
389 (0.041)
SELECT *
FROM pr_category c
LEFT JOIN pr_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN pr_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '62' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/y/yafinafru/yavinav/public_html/catalog/model/catalog/category.php:10
390 (0.021)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
391 (0.023)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=62'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
392 (0.026)
SELECT *
FROM pr_url_alias
WHERE `query` = 'pavblog/blogs'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
393 (0.032)
SELECT *
FROM pr_url_alias
WHERE `query` = 'module/language'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
394 (0.032)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
395 (0.029)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=90'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
396 (0.035)
SELECT *
FROM pr_url_alias
WHERE `query` = 'module/currency'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
397 (0.047)
SELECT *
FROM pr_url_alias
WHERE `query` = 'product/category'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
398 (0.034)
SELECT *
FROM pr_url_alias
WHERE `query` = 'category_id=90'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:84
399 (0.096)
SELECT *
FROM pr_extension
WHERE `type` = 'total'
/home/y/yafinafru/yavinav/public_html/catalog/model/setting/extension.php:4
400 (0.073)
SELECT *
FROM pr_url_alias
WHERE `query` = 'checkout/cart'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95
401 (1.423)
SELECT *
FROM pr_url_alias
WHERE `query` = 'checkout/checkout'
/home/y/yafinafru/yavinav/public_html/catalog/controller/common/seo_url.php:95