Sandalo Donna Tacco Largo Con Incrocio E Cinturino Alla Caviglia Gold Campagne

29,00€
IVA Inclusa
Marche: Moda Alice
Codice Prodotto: AF66-08
Disponibilità: 10

Opzioni Disponibili

Taglie Disponibili: 37


* DONNA 35/41:

SANDALO GOLD CON INCROCIO E CINTURINO 

ALTEZZA TACCO 13 CM 

ALTEZZA PLATEAU 4CM 

CALZATA REGOLARE 

NUMERI STANDARD 

SPEDIZIONE IN 48 ORE IN TUTTA ITALIA CON CORRIERE GLS   

Colore
Champagne Champagne

Scrivi una recensione

Nome:


La tua recensione: Note: Non inserire codice HTML!

Valutazione: Pessimo           Buono

Inserisci il codice nel box sottostante:





Queries: 175, Total time: 942.291 ms [By time] [By id] [By file]
1 (14.039)
SELECT *
FROM store
WHERE REPLACE(`url`, 'www.', '') = 'http://redscarpet.it/'
/var/www/redscarpet.it/public_html/index.php:52
2 (9.259)
SELECT *
FROM setting
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC
/var/www/redscarpet.it/public_html/index.php:62
3 (4.628)
SELECT *
FROM `language`
WHERE status = '1'
/var/www/redscarpet.it/public_html/index.php:141
4 (6.122)
SELECT *
FROM currency
/var/www/redscarpet.it/public_html/system/library/currency.php:13
5 (10.440)
SELECT *
FROM weight_class wc
LEFT JOIN weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id)
WHERE wcd.language_id = '2'
/var/www/redscarpet.it/public_html/system/library/weight.php:9
6 (8.079)
SELECT *
FROM length_class mc
LEFT JOIN length_class_description mcd ON (mc.length_class_id = mcd.length_class_id)
WHERE mcd.language_id = '2'
/var/www/redscarpet.it/public_html/system/library/length.php:9
7 (8.577)
SHOW TABLES LIKE 'journal_cp_categories'
/var/www/redscarpet.it/public_html/catalog/model/journal/cp.php:16
8 (8.304)
SHOW TABLES LIKE 'journal_cp_fonts'
/var/www/redscarpet.it/public_html/catalog/model/journal/cp.php:16
9 (7.700)
SHOW TABLES LIKE 'journal_cp_settings'
/var/www/redscarpet.it/public_html/catalog/model/journal/cp.php:16
10 (15.091)
SHOW TABLES LIKE 'journal_cp_subcategories'
/var/www/redscarpet.it/public_html/catalog/model/journal/cp.php:16
11 (11.899)
SHOW TABLES LIKE 'journal_cp_themes'
/var/www/redscarpet.it/public_html/catalog/model/journal/cp.php:16
12 (9.284)
SHOW TABLES LIKE 'journal_cp_theme_settings'
/var/www/redscarpet.it/public_html/catalog/model/journal/cp.php:16
13 (6.040)
SHOW TABLES LIKE "journal_cp_theme_to_store"
/var/www/redscarpet.it/public_html/catalog/model/journal/cp.php:28
14 (5.582)
SELECT *
FROM journal_cp_theme_to_store
WHERE store_id=0 LIMIT 0, 1
/var/www/redscarpet.it/public_html/catalog/model/journal/cp.php:30
15 (8.293)
SELECT theme_id, status
FROM journal_cp_themes
WHERE active = 'yes' LIMIT 0, 1
/var/www/redscarpet.it/public_html/catalog/model/journal/cp.php:36
16 (5.194)
SELECT theme_id, status
FROM journal_cp_themes
WHERE theme_id = 'journal_i'
/var/www/redscarpet.it/public_html/catalog/model/journal/cp.php:41
17 (13.453)
SELECT name, type, value, input, default_value, css_selector, css_property, is_serialized
FROM journal_cp_theme_settings
INNER JOIN journal_cp_settings on (journal_cp_theme_settings.setting_name = journal_cp_settings.name)
WHERE theme_id = 'journal_i'
/var/www/redscarpet.it/public_html/catalog/model/journal/cp.php:55
18 (3.810)
SELECT *
FROM journal_cp_fonts
WHERE font_name = ''
/var/www/redscarpet.it/public_html/catalog/model/journal/cp.php:60
19 (5.575)
SELECT *
FROM journal_cp_fonts
WHERE font_name = ''
/var/www/redscarpet.it/public_html/catalog/model/journal/cp.php:60
20 (4.927)
SELECT *
FROM journal_cp_fonts
WHERE font_name = ''
/var/www/redscarpet.it/public_html/catalog/model/journal/cp.php:60
21 (6.770)
SELECT *
FROM journal_cp_fonts
WHERE font_name = ''
/var/www/redscarpet.it/public_html/catalog/model/journal/cp.php:60
22 (6.253)
SELECT *
FROM journal_cp_fonts
WHERE font_name = ''
/var/www/redscarpet.it/public_html/catalog/model/journal/cp.php:60
23 (6.654)
SELECT *
FROM journal_cp_fonts
WHERE font_name = ''
/var/www/redscarpet.it/public_html/catalog/model/journal/cp.php:60
24 (2.861)
SELECT *
FROM journal_cp_fonts
WHERE font_name = ''
/var/www/redscarpet.it/public_html/catalog/model/journal/cp.php:60
25 (8.972)
SELECT *
FROM journal_cp_fonts
WHERE font_name = ''
/var/www/redscarpet.it/public_html/catalog/model/journal/cp.php:60
26 (9.881)
SELECT *
FROM journal_cp_fonts
WHERE font_name = ''
/var/www/redscarpet.it/public_html/catalog/model/journal/cp.php:60
27 (7.718)
SELECT *
FROM journal_cp_fonts
WHERE font_name = ''
/var/www/redscarpet.it/public_html/catalog/model/journal/cp.php:60
28 (7.233)
SELECT *
FROM journal_cp_fonts
WHERE font_name = ''
/var/www/redscarpet.it/public_html/catalog/model/journal/cp.php:60
29 (4.951)
SELECT *
FROM journal_cp_fonts
WHERE font_name = ''
/var/www/redscarpet.it/public_html/catalog/model/journal/cp.php:60
30 (5.859)
SELECT *
FROM journal_cp_fonts
WHERE font_name = ''
/var/www/redscarpet.it/public_html/catalog/model/journal/cp.php:60
31 (8.571)
SELECT *
FROM journal_cp_fonts
WHERE font_name = ''
/var/www/redscarpet.it/public_html/catalog/model/journal/cp.php:60
32 (7.636)
SELECT *
FROM journal_cp_fonts
WHERE font_name = ''
/var/www/redscarpet.it/public_html/catalog/model/journal/cp.php:60
33 (0.751)
SELECT *
FROM journal_cp_fonts
WHERE font_name = ''
/var/www/redscarpet.it/public_html/catalog/model/journal/cp.php:60
34 (3.025)
SELECT *
FROM journal_cp_fonts
WHERE font_name = ''
/var/www/redscarpet.it/public_html/catalog/model/journal/cp.php:60
35 (4.623)
SELECT *
FROM journal_cp_fonts
WHERE font_name = ''
/var/www/redscarpet.it/public_html/catalog/model/journal/cp.php:60
36 (6.991)
SELECT *
FROM journal_cp_fonts
WHERE font_name = ''
/var/www/redscarpet.it/public_html/catalog/model/journal/cp.php:60
37 (4.773)
SELECT *
FROM journal_cp_fonts
WHERE font_name = ''
/var/www/redscarpet.it/public_html/catalog/model/journal/cp.php:60
38 (0.731)
SELECT *
FROM journal_cp_fonts
WHERE font_name = ''
/var/www/redscarpet.it/public_html/catalog/model/journal/cp.php:60
39 (6.658)
SELECT *
FROM journal_cp_fonts
WHERE font_name = ''
/var/www/redscarpet.it/public_html/catalog/model/journal/cp.php:60
40 (5.915)
SELECT *
FROM journal_cp_fonts
WHERE font_name = ''
/var/www/redscarpet.it/public_html/catalog/model/journal/cp.php:60
41 (4.939)
SELECT *
FROM journal_cp_fonts
WHERE font_name = ''
/var/www/redscarpet.it/public_html/catalog/model/journal/cp.php:60
42 (5.241)
SHOW TABLES LIKE 'journal_product_tabs'
/var/www/redscarpet.it/public_html/catalog/controller/module/journal_cp.php:926
43 (8.239)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM 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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM 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 < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '99008' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/redscarpet.it/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:14
44 (6.011)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=99008'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
45 (4.692)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=99008'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
46 (5.781)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=82'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
47 (6.269)
SELECT *
FROM product_image
WHERE product_id = '99008'
ORDER BY sort_order ASC
/var/www/redscarpet.it/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:491
48 (6.105)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '0' AND tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '105' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3899')
ORDER BY tr1.priority ASC
/var/www/redscarpet.it/public_html/system/library/tax.php:91
49 (6.808)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '0' AND tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '105' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3899')
ORDER BY tr1.priority ASC
/var/www/redscarpet.it/public_html/system/library/tax.php:119
50 (3.783)
SELECT *
FROM product_discount
WHERE product_id = '99008' AND customer_group_id = '1' AND quantity > 1 AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY quantity ASC, priority ASC, price ASC
/var/www/redscarpet.it/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:485
51 (6.831)
SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
LEFT JOIN option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '99008' AND od.language_id = '2'
ORDER BY o.sort_order
/var/www/redscarpet.it/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:431
52 (11.756)
SELECT *
FROM product_option_value pov,option_value ov,option_value_description ovd
WHERE pov.option_value_id = ov.option_value_id and ov.option_value_id = ovd.option_value_id and pov.quantity = 1 and pov.product_id = '99008' AND pov.product_option_id = '97133' AND ovd.language_id = '2' group by ovd.name
ORDER BY ov.sort_order
/var/www/redscarpet.it/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:437
53 (5.759)
SELECT ag.attribute_group_id, agd.name
FROM product_attribute pa
LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '99008' AND agd.language_id = '2' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/redscarpet.it/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:402
54 (8.802)
SELECT a.attribute_id, ad.name, pa.text
FROM product_attribute pa
LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '99008' AND a.attribute_group_id = '3' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name
/var/www/redscarpet.it/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:407
55 (5.901)
SELECT *
FROM product_related pr
LEFT JOIN product p ON (pr.related_id = p.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pr.product_id = '99008' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/redscarpet.it/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:499
56 (7.587)
UPDATE product SET viewed = (viewed + 1)
WHERE product_id = '99008'
/var/www/redscarpet.it/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:4
57 (5.052)
SELECT *
FROM product_to_layout
WHERE product_id = '99008' AND store_id = '0'
/var/www/redscarpet.it/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:509
58 (6.009)
SELECT *
FROM layout_route
WHERE 'product/product' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/redscarpet.it/public_html/catalog/model/design/layout.php:4
59 (5.354)
SELECT *
FROM extension
WHERE `type` = 'module'
/var/www/redscarpet.it/public_html/catalog/model/setting/extension.php:4
60 (7.585)
SELECT *
FROM product_to_layout
WHERE product_id = '99008' AND store_id = '0'
/var/www/redscarpet.it/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:509
61 (3.215)
SELECT *
FROM layout_route
WHERE 'product/product' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/redscarpet.it/public_html/catalog/model/design/layout.php:4
62 (7.745)
SELECT *
FROM extension
WHERE `type` = 'module'
/var/www/redscarpet.it/public_html/catalog/model/setting/extension.php:4
63 (4.306)
SELECT *
FROM product_to_layout
WHERE product_id = '99008' AND store_id = '0'
/var/www/redscarpet.it/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:509
64 (1.355)
SELECT *
FROM layout_route
WHERE 'product/product' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/redscarpet.it/public_html/catalog/model/design/layout.php:4
65 (0.474)
SELECT *
FROM extension
WHERE `type` = 'module'
/var/www/redscarpet.it/public_html/catalog/model/setting/extension.php:4
66 (1.319)
SELECT *
FROM product_to_layout
WHERE product_id = '99008' AND store_id = '0'
/var/www/redscarpet.it/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:509
67 (3.977)
SELECT *
FROM layout_route
WHERE 'product/product' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/redscarpet.it/public_html/catalog/model/design/layout.php:4
68 (7.828)
SELECT *
FROM extension
WHERE `type` = 'module'
/var/www/redscarpet.it/public_html/catalog/model/setting/extension.php:4
69 (4.815)
SELECT *
FROM information i
LEFT JOIN information_description id ON (i.information_id = id.information_id)
LEFT JOIN 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
/var/www/redscarpet.it/public_html/catalog/model/catalog/information.php:10
70 (4.839)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=4'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
71 (4.044)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=8'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
72 (6.634)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=3'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
73 (6.473)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=5'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
74 (9.503)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=7'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
75 (7.793)
DELETE
FROM `customer_online`
WHERE (UNIX_TIMESTAMP(`date_added`) + 3600) < UNIX_TIMESTAMP(NOW())
/var/www/redscarpet.it/public_html/catalog/model/tool/online.php:4
76 (4.104)
REPLACE INTO `customer_online` SET `ip` = '184.73.14.222', `customer_id` = '0', `url` = 'http://redscarpet.it/index.php?route=product/product&product_id=99008', `referer` = '', `date_added` = NOW()
/var/www/redscarpet.it/public_html/catalog/model/tool/online.php:6
77 (4.248)
SELECT *
FROM extension
WHERE `type` = 'module'
/var/www/redscarpet.it/public_html/catalog/model/setting/extension.php:4
78 (3.793)
SELECT *
FROM product_to_layout
WHERE product_id = '99008' AND store_id = '0'
/var/www/redscarpet.it/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:509
79 (4.023)
SELECT *
FROM layout_route
WHERE 'product/product' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/redscarpet.it/public_html/catalog/model/design/layout.php:4
80 (73.912)
SELECT p.product_id, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price
FROM 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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM 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 < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' GROUP BY p.product_id
ORDER BY p.product_id DESC LIMIT 0,20
/var/www/redscarpet.it/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:265
81 (10.652)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM 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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM 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 < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '102372' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/redscarpet.it/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:14
82 (5.121)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM 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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM 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 < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '102324' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/redscarpet.it/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:14
83 (2.049)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM 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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM 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 < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '102321' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/redscarpet.it/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:14
84 (2.543)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM 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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM 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 < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '102308' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/redscarpet.it/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:14
85 (2.084)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM 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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM 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 < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '102225' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/redscarpet.it/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:14
86 (3.213)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM 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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM 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 < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '102224' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/redscarpet.it/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:14
87 (2.712)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM 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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM 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 < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '102223' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/redscarpet.it/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:14
88 (2.430)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM 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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM 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 < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '102215' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/redscarpet.it/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:14
89 (8.119)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM 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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM 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 < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '102214' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/redscarpet.it/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:14
90 (2.985)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM 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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM 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 < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '102210' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/redscarpet.it/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:14
91 (2.279)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM 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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM 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 < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '102209' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/redscarpet.it/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:14
92 (2.440)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM 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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM 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 < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '102181' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/redscarpet.it/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:14
93 (2.536)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM 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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM 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 < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '102179' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/redscarpet.it/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:14
94 (2.423)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM 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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM 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 < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '102178' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/redscarpet.it/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:14
95 (3.328)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM 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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM 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 < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '102177' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/redscarpet.it/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:14
96 (6.898)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM 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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM 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 < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '102176' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/redscarpet.it/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:14
97 (2.848)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM 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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM 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 < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '102175' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/redscarpet.it/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:14
98 (4.072)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM 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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM 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 < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '102174' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/redscarpet.it/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:14
99 (3.105)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM 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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM 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 < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '102172' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/redscarpet.it/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:14
100 (4.172)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM 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 < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM 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 < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '101634' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/redscarpet.it/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:14
101 (3.240)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '0' AND tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '105' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3899')
ORDER BY tr1.priority ASC
/var/www/redscarpet.it/public_html/system/library/tax.php:91
102 (1.812)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '0' AND tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '105' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3899')
ORDER BY tr1.priority ASC
/var/www/redscarpet.it/public_html/system/library/tax.php:119
103 (1.052)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=102372'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
104 (1.701)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '0' AND tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '105' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3899')
ORDER BY tr1.priority ASC
/var/www/redscarpet.it/public_html/system/library/tax.php:91
105 (0.810)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '0' AND tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '105' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3899')
ORDER BY tr1.priority ASC
/var/www/redscarpet.it/public_html/system/library/tax.php:119
106 (0.358)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=102324'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
107 (1.548)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '0' AND tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '105' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3899')
ORDER BY tr1.priority ASC
/var/www/redscarpet.it/public_html/system/library/tax.php:91
108 (0.858)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '0' AND tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '105' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3899')
ORDER BY tr1.priority ASC
/var/www/redscarpet.it/public_html/system/library/tax.php:119
109 (0.352)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=102321'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
110 (0.828)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '0' AND tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '105' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3899')
ORDER BY tr1.priority ASC
/var/www/redscarpet.it/public_html/system/library/tax.php:91
111 (1.502)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '0' AND tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '105' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3899')
ORDER BY tr1.priority ASC
/var/www/redscarpet.it/public_html/system/library/tax.php:119
112 (0.400)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=102308'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
113 (0.948)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '0' AND tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '105' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3899')
ORDER BY tr1.priority ASC
/var/www/redscarpet.it/public_html/system/library/tax.php:91
114 (1.458)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '0' AND tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '105' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3899')
ORDER BY tr1.priority ASC
/var/www/redscarpet.it/public_html/system/library/tax.php:119
115 (0.445)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=102225'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
116 (1.867)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '0' AND tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '105' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3899')
ORDER BY tr1.priority ASC
/var/www/redscarpet.it/public_html/system/library/tax.php:91
117 (1.160)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '0' AND tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '105' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3899')
ORDER BY tr1.priority ASC
/var/www/redscarpet.it/public_html/system/library/tax.php:119
118 (0.391)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=102224'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
119 (1.645)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '0' AND tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '105' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3899')
ORDER BY tr1.priority ASC
/var/www/redscarpet.it/public_html/system/library/tax.php:91
120 (1.310)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '0' AND tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '105' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3899')
ORDER BY tr1.priority ASC
/var/www/redscarpet.it/public_html/system/library/tax.php:119
121 (0.551)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=102223'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
122 (1.341)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '0' AND tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '105' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3899')
ORDER BY tr1.priority ASC
/var/www/redscarpet.it/public_html/system/library/tax.php:91
123 (1.503)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '0' AND tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '105' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3899')
ORDER BY tr1.priority ASC
/var/www/redscarpet.it/public_html/system/library/tax.php:119
124 (0.438)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=102215'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
125 (0.873)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '0' AND tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '105' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3899')
ORDER BY tr1.priority ASC
/var/www/redscarpet.it/public_html/system/library/tax.php:91
126 (1.460)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '0' AND tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '105' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3899')
ORDER BY tr1.priority ASC
/var/www/redscarpet.it/public_html/system/library/tax.php:119
127 (0.484)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=102214'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
128 (9.602)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '0' AND tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '105' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3899')
ORDER BY tr1.priority ASC
/var/www/redscarpet.it/public_html/system/library/tax.php:91
129 (4.821)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '0' AND tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '105' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3899')
ORDER BY tr1.priority ASC
/var/www/redscarpet.it/public_html/system/library/tax.php:119
130 (5.098)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=102210'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
131 (10.538)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '0' AND tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '105' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3899')
ORDER BY tr1.priority ASC
/var/www/redscarpet.it/public_html/system/library/tax.php:91
132 (6.376)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '0' AND tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '105' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3899')
ORDER BY tr1.priority ASC
/var/www/redscarpet.it/public_html/system/library/tax.php:119
133 (6.190)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=102209'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
134 (7.149)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '0' AND tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '105' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3899')
ORDER BY tr1.priority ASC
/var/www/redscarpet.it/public_html/system/library/tax.php:91
135 (9.618)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '0' AND tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '105' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3899')
ORDER BY tr1.priority ASC
/var/www/redscarpet.it/public_html/system/library/tax.php:119
136 (5.885)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=102181'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
137 (2.840)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '0' AND tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '105' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3899')
ORDER BY tr1.priority ASC
/var/www/redscarpet.it/public_html/system/library/tax.php:91
138 (9.902)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '0' AND tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '105' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3899')
ORDER BY tr1.priority ASC
/var/www/redscarpet.it/public_html/system/library/tax.php:119
139 (11.488)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=102179'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
140 (7.543)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '0' AND tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '105' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3899')
ORDER BY tr1.priority ASC
/var/www/redscarpet.it/public_html/system/library/tax.php:91
141 (8.317)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '0' AND tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '105' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3899')
ORDER BY tr1.priority ASC
/var/www/redscarpet.it/public_html/system/library/tax.php:119
142 (9.458)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=102178'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
143 (1.314)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '0' AND tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '105' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3899')
ORDER BY tr1.priority ASC
/var/www/redscarpet.it/public_html/system/library/tax.php:91
144 (0.620)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '0' AND tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '105' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3899')
ORDER BY tr1.priority ASC
/var/www/redscarpet.it/public_html/system/library/tax.php:119
145 (7.442)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=102177'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
146 (0.781)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '0' AND tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '105' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3899')
ORDER BY tr1.priority ASC
/var/www/redscarpet.it/public_html/system/library/tax.php:91
147 (0.565)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '0' AND tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '105' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3899')
ORDER BY tr1.priority ASC
/var/www/redscarpet.it/public_html/system/library/tax.php:119
148 (0.270)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=102176'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
149 (0.591)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '0' AND tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '105' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3899')
ORDER BY tr1.priority ASC
/var/www/redscarpet.it/public_html/system/library/tax.php:91
150 (0.459)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '0' AND tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '105' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3899')
ORDER BY tr1.priority ASC
/var/www/redscarpet.it/public_html/system/library/tax.php:119
151 (0.244)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=102175'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
152 (2.793)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '0' AND tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '105' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3899')
ORDER BY tr1.priority ASC
/var/www/redscarpet.it/public_html/system/library/tax.php:91
153 (0.568)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '0' AND tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '105' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3899')
ORDER BY tr1.priority ASC
/var/www/redscarpet.it/public_html/system/library/tax.php:119
154 (8.404)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=102174'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
155 (1.106)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '0' AND tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '105' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3899')
ORDER BY tr1.priority ASC
/var/www/redscarpet.it/public_html/system/library/tax.php:91
156 (5.968)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '0' AND tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '105' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3899')
ORDER BY tr1.priority ASC
/var/www/redscarpet.it/public_html/system/library/tax.php:119
157 (5.722)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=102172'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
158 (1.475)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '0' AND tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '105' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3899')
ORDER BY tr1.priority ASC
/var/www/redscarpet.it/public_html/system/library/tax.php:91
159 (0.804)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '0' AND tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '105' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3899')
ORDER BY tr1.priority ASC
/var/www/redscarpet.it/public_html/system/library/tax.php:119
160 (8.685)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=101634'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
161 (4.309)
SELECT *
FROM setting
WHERE store_id = '0' AND `group` = 'pavmegamenu_params'
/var/www/redscarpet.it/public_html/catalog/model/setting/setting.php:6
162 (6.157)
SELECT m.*, md.title,md.description
FROM megamenu m
LEFT JOIN megamenu_description md ON m.megamenu_id=md.megamenu_id AND language_id=2
WHERE m.`published`=1 AND store_id=0
ORDER BY `position`
/var/www/redscarpet.it/public_html/catalog/model/menu/megamenu.php:47
163 (2.587)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=61'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:82
164 (8.918)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=65'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:82
165 (2.034)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=75'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:82
166 (7.010)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=102'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:82
167 (12.425)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=27'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:82
168 (9.262)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=33'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:82
169 (7.871)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=140'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:82
170 (3.860)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=142'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:82
171 (10.149)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=99008'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
172 (4.397)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=99008'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
173 (8.362)
SELECT *
FROM extension
WHERE `type` = 'total'
/var/www/redscarpet.it/public_html/catalog/model/setting/extension.php:4
174 (4.636)
SELECT SUM(amount) AS total
FROM customer_transaction
WHERE customer_id = '0'
/var/www/redscarpet.it/public_html/system/library/customer.php:157
175 (5.309)
SELECT *
FROM product_to_redirect
WHERE product_id = '99008' AND active = '1'
/var/www/redscarpet.it/public_html/vqmod/vqcache/vq2-catalog_view_theme_pav_towner_template_product_product.tpl:153