Ludovica

Display: Lista Griglia
Ordina per:
Mostra:
Stivaletto Estivo Beige Con Fibbie E Zip Tacco Comodo New 2019

Stivaletto Estivo Beige Con Fibbie E Zip Tacco Comodo New 2019

STIVALETTO BEIGE ESTIVO CON FIBBIE E ZIP LATERALE  NUMERI STANDARD DAL 36 AL 41  ...
19,00€
IVA esclusa: 19,00€
Stivaletto Beige Estivo Con Zip Laterale 4 Fibbie E Tacco Comodo

Stivaletto Beige Estivo Con Zip Laterale 4 Fibbie E Tacco Comodo

STIVALETTO ESTIVO BEIGE CON 4 FIBBIE E ZIP ALTERALE  ALTEZZA TACCO 3,5 CM NUMERI STANDARD...
19,00€
IVA esclusa: 19,00€
Stivaletto Traforato Estivo Camel  Con Zip E 3 Fibbie

Stivaletto Traforato Estivo Camel Con Zip E 3 Fibbie

STIVALETTO CAMEL TRAFORATO ESTIVO CON ZIP LATERALE  NUMERI STANDARD DAL 36 AL 41  AL...
19,00€
IVA esclusa: 19,00€
Stivaletto Nero Traforato Con Zip E Una Fibbia Tacco Comodo

Stivaletto Nero Traforato Con Zip E Una Fibbia Tacco Comodo

STIVALETTO ESTIVO TRAFORATO CON FIBBIA IN ORO  E ZIP LATERALE  NUMERI STANDARD DAL 36 A...
19,00€
IVA esclusa: 19,00€
Sandalo Beige Spuntato  Con Zeppa E Fibbia

Sandalo Beige Spuntato Con Zeppa E Fibbia

SANDALO BEIGE SPUNTATO CON FIBBIA  NEW COLLECTION 2019 CALZATA REGOLARE  NUMERI STAN...
19,00€
IVA esclusa: 19,00€
Sandalo Rosso Con Zeppa  Spuntato  Con Fibbia

Sandalo Rosso Con Zeppa Spuntato Con Fibbia

SANDALO ROSSO CON ZEPPA E FIBBIA SPUNTATO  ALTEZZA ZEPPA : 9CM  NUMERI STANDARD DAL ...
19,00€
IVA esclusa: 19,00€
Sandalo Blu Con Zeppa  E Fibbia

Sandalo Blu Con Zeppa E Fibbia

SANDALO BLU CON ZEPPA E FIBBIA  ALTEZZA ZEPPA : 9CM  NUMERI STANDARD DAL 36 AL 41&nb...
19,00€
IVA esclusa: 19,00€
Sandalo Beige Con Zeppa E Fibbia

Sandalo Beige Con Zeppa E Fibbia

SANDALO BEIGE CON ZEPPA E FIBBIA  ALTEZZA ZEPPA : 9CM  NUMERI STANDARD DAL 36 AL 41&...
19,00€
IVA esclusa: 19,00€
Stivale Jeansato Tacco A Spillo E Zip Laterale New Collection 2019

Stivale Jeansato Tacco A Spillo E Zip Laterale New Collection 2019

STIVALE JEANSATO CON ZIP LATERALE E TACCO A SPILLO  ALTEZZA TACCO : 10,5 CM ALTEZZA GAMBA...
19,00€
IVA esclusa: 19,00€
Decolte Con Cinturino A Punta Rosso Opaco In Ecopelle Tacco Doppio

Decolte Con Cinturino A Punta Rosso Opaco In Ecopelle Tacco Doppio

DECOLTE ROSSO OPACO A PUNTA CON CINTURINO TACCO DOPPIO  ALTEZZA TACCO 9,5 CM CALZATA...
27,00€
IVA esclusa: 27,00€
Decolte Con Cinturino A Punta Nero Opaco In Ecopelle Tacco Doppio

Decolte Con Cinturino A Punta Nero Opaco In Ecopelle Tacco Doppio

DECOLTE NERO OPACO A PUNTA CON CINTURINO TACCO DOPPIO  ALTEZZA TACCO 9,5 CM CALZATATA REG...
27,00€
IVA esclusa: 27,00€
Deco Con Fibbia Alla Caviglia Tacco Largo E Punta  Vernice  Nero

Deco Con Fibbia Alla Caviglia Tacco Largo E Punta Vernice Nero

Tacco Alto 10 cm  Plateao  0.2 cm Allacciatura cinturino caviglia Mate...
27,00€
IVA esclusa: 27,00€
Stivaletto Donna Con Zip Spuntato Traforato   - Rosso

Stivaletto Donna Con Zip Spuntato Traforato - Rosso

Tacco Alto 9 cm  altezza gamba  9 cm Allacciatura zip Materiale ecopell...
28,00€
IVA esclusa: 28,00€
Decollette Donna Concinturino Incrocio Punta Tonda Beige

Decollette Donna Concinturino Incrocio Punta Tonda Beige

Tacco Alto 10cm  Plateao  0.2 cm  Allacciatura cinturino caviglia Calza...
27,00€
IVA esclusa: 27,00€
Decollette Donna Concinturino Incrocio Punta Tonda Blu

Decollette Donna Concinturino Incrocio Punta Tonda Blu

Tacco Alto 10cm  Plateao  0.2 cm  Allacciatura cinturino caviglia Calza...
27,00€
IVA esclusa: 27,00€
Decollette Donna Concinturino Incrocio Punta Tonda Rosso

Decollette Donna Concinturino Incrocio Punta Tonda Rosso

Tacco Alto 10cm  Plateao  0.2 cm  Allacciatura cinturino caviglia Calza...
27,00€
IVA esclusa: 27,00€
Deco Donna Con Tacco Brillantinato  E Conturino Alla Caviglia Ne

Deco Donna Con Tacco Brillantinato E Conturino Alla Caviglia Ne

Tacco Alto 10 cm  Allacciatura cinturino alla caviglia  Materiale CAMOSCIO SINT...
28,00€
IVA esclusa: 28,00€
Deco Donna Con Tacco Brillantinato  E Conturino Alla Caviglia  B

Deco Donna Con Tacco Brillantinato E Conturino Alla Caviglia B

Tacco Alto 10 cm  Allacciatura cinturino alla caviglia  Materiale CAMOSCIO SINT tac...
28,00€
IVA esclusa: 28,00€
Stivaletto Traforato Spuntato Con Zip Spuntato  - Beige

Stivaletto Traforato Spuntato Con Zip Spuntato - Beige

Tacco Alto 9 cm  altezza gamba  9,5 cm Allacciatura zip Materiale CAMOSCIO S...
28,00€
IVA esclusa: 28,00€
Stivaletto Donna Con Zip Spuntato Traforato - Nero

Stivaletto Donna Con Zip Spuntato Traforato - Nero

STIVALETTO SPUNTATO ECOPELLE CON ZIP LATERALE CON FIORI TRAFORATI  ALTEZZA TACCO 9CM  ...
28,00€
IVA esclusa: 28,00€
Stivaletto Donna Con Zip Spuntato Traforato  - Bianco

Stivaletto Donna Con Zip Spuntato Traforato - Bianco

Tacco Alto 9 cm  altezza gamba  9 cm Allacciatura zip Materiale ecopelle Cal...
28,00€
IVA esclusa: 28,00€
Stivaletto Traforato Spuntato Con Zip Aperto Dietro  Beige

Stivaletto Traforato Spuntato Con Zip Aperto Dietro Beige

STIVALETTO DONNA traforato spuntato aperto dietro ALTEZZA TACCO: 10CM  ALTEZZA GAMBA : 6...
28,00€
IVA esclusa: 28,00€
Stivaletto Traforato Spuntato Con Zip Aperto Dietro  Nero

Stivaletto Traforato Spuntato Con Zip Aperto Dietro Nero

STIVALETTO DONNA traforato spuntato aperto dietro ALTEZZA TACCO: 10CM  ALTEZZA GAMBA : 6...
28,00€
IVA esclusa: 28,00€
Tivaletto Ecopelle Silver Spuntato Con Zip Laterale Tacco Comodo

Tivaletto Ecopelle Silver Spuntato Con Zip Laterale Tacco Comodo

Stivaletto Ecopelle Silver Spuntato con Zip laterale Ricamato in Fiori traforato  Altez...
26,00€
IVA esclusa: 26,00€
Tivaletto Ecopelle Oro Spuntato Con Zip Laterale Tacco Comodo

Tivaletto Ecopelle Oro Spuntato Con Zip Laterale Tacco Comodo

Stivaletto Ecopelle Oro Spuntato con Zip laterale Ricamato in Fiori traforato  Altezza ...
26,00€
IVA esclusa: 26,00€
Stivaletto Traforato Spuntato Con Zip Aperto Dietro Rosso

Stivaletto Traforato Spuntato Con Zip Aperto Dietro Rosso

STIVALETTO DONNA traforato spuntato aperto dietro ALTEZZA TACCO: 10CM  ALTEZZA GAMBA...
28,00€
IVA esclusa: 28,00€
Queries: 308, Total time: 157.496 ms [By time] [By id] [By file]
1 (0.538)
SELECT *
FROM store
WHERE REPLACE(`url`, 'www.', '') = 'http://redscarpet.it/'
/var/www/redscarpet.it/public_html/index.php:52
2 (1.630)
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 (0.264)
SELECT *
FROM `language`
WHERE status = '1'
/var/www/redscarpet.it/public_html/index.php:141
4 (0.282)
SELECT *
FROM currency
/var/www/redscarpet.it/public_html/system/library/currency.php:13
5 (0.427)
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 (0.373)
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 (0.814)
SHOW TABLES LIKE 'journal_cp_categories'
/var/www/redscarpet.it/public_html/catalog/model/journal/cp.php:16
8 (0.689)
SHOW TABLES LIKE 'journal_cp_fonts'
/var/www/redscarpet.it/public_html/catalog/model/journal/cp.php:16
9 (0.665)
SHOW TABLES LIKE 'journal_cp_settings'
/var/www/redscarpet.it/public_html/catalog/model/journal/cp.php:16
10 (0.639)
SHOW TABLES LIKE 'journal_cp_subcategories'
/var/www/redscarpet.it/public_html/catalog/model/journal/cp.php:16
11 (0.627)
SHOW TABLES LIKE 'journal_cp_themes'
/var/www/redscarpet.it/public_html/catalog/model/journal/cp.php:16
12 (0.695)
SHOW TABLES LIKE 'journal_cp_theme_settings'
/var/www/redscarpet.it/public_html/catalog/model/journal/cp.php:16
13 (0.584)
SHOW TABLES LIKE "journal_cp_theme_to_store"
/var/www/redscarpet.it/public_html/catalog/model/journal/cp.php:28
14 (0.397)
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 (0.318)
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 (0.243)
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 (1.722)
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 (0.570)
SELECT *
FROM journal_cp_fonts
WHERE font_name = ''
/var/www/redscarpet.it/public_html/catalog/model/journal/cp.php:60
19 (0.459)
SELECT *
FROM journal_cp_fonts
WHERE font_name = ''
/var/www/redscarpet.it/public_html/catalog/model/journal/cp.php:60
20 (0.412)
SELECT *
FROM journal_cp_fonts
WHERE font_name = ''
/var/www/redscarpet.it/public_html/catalog/model/journal/cp.php:60
21 (0.451)
SELECT *
FROM journal_cp_fonts
WHERE font_name = ''
/var/www/redscarpet.it/public_html/catalog/model/journal/cp.php:60
22 (0.472)
SELECT *
FROM journal_cp_fonts
WHERE font_name = ''
/var/www/redscarpet.it/public_html/catalog/model/journal/cp.php:60
23 (0.467)
SELECT *
FROM journal_cp_fonts
WHERE font_name = ''
/var/www/redscarpet.it/public_html/catalog/model/journal/cp.php:60
24 (0.465)
SELECT *
FROM journal_cp_fonts
WHERE font_name = ''
/var/www/redscarpet.it/public_html/catalog/model/journal/cp.php:60
25 (0.457)
SELECT *
FROM journal_cp_fonts
WHERE font_name = ''
/var/www/redscarpet.it/public_html/catalog/model/journal/cp.php:60
26 (0.462)
SELECT *
FROM journal_cp_fonts
WHERE font_name = ''
/var/www/redscarpet.it/public_html/catalog/model/journal/cp.php:60
27 (0.519)
SELECT *
FROM journal_cp_fonts
WHERE font_name = ''
/var/www/redscarpet.it/public_html/catalog/model/journal/cp.php:60
28 (0.495)
SELECT *
FROM journal_cp_fonts
WHERE font_name = ''
/var/www/redscarpet.it/public_html/catalog/model/journal/cp.php:60
29 (0.535)
SELECT *
FROM journal_cp_fonts
WHERE font_name = ''
/var/www/redscarpet.it/public_html/catalog/model/journal/cp.php:60
30 (0.452)
SELECT *
FROM journal_cp_fonts
WHERE font_name = ''
/var/www/redscarpet.it/public_html/catalog/model/journal/cp.php:60
31 (0.445)
SELECT *
FROM journal_cp_fonts
WHERE font_name = ''
/var/www/redscarpet.it/public_html/catalog/model/journal/cp.php:60
32 (0.450)
SELECT *
FROM journal_cp_fonts
WHERE font_name = ''
/var/www/redscarpet.it/public_html/catalog/model/journal/cp.php:60
33 (0.458)
SELECT *
FROM journal_cp_fonts
WHERE font_name = ''
/var/www/redscarpet.it/public_html/catalog/model/journal/cp.php:60
34 (0.431)
SELECT *
FROM journal_cp_fonts
WHERE font_name = ''
/var/www/redscarpet.it/public_html/catalog/model/journal/cp.php:60
35 (0.418)
SELECT *
FROM journal_cp_fonts
WHERE font_name = ''
/var/www/redscarpet.it/public_html/catalog/model/journal/cp.php:60
36 (0.434)
SELECT *
FROM journal_cp_fonts
WHERE font_name = ''
/var/www/redscarpet.it/public_html/catalog/model/journal/cp.php:60
37 (0.480)
SELECT *
FROM journal_cp_fonts
WHERE font_name = ''
/var/www/redscarpet.it/public_html/catalog/model/journal/cp.php:60
38 (0.419)
SELECT *
FROM journal_cp_fonts
WHERE font_name = ''
/var/www/redscarpet.it/public_html/catalog/model/journal/cp.php:60
39 (0.508)
SELECT *
FROM journal_cp_fonts
WHERE font_name = ''
/var/www/redscarpet.it/public_html/catalog/model/journal/cp.php:60
40 (0.424)
SELECT *
FROM journal_cp_fonts
WHERE font_name = ''
/var/www/redscarpet.it/public_html/catalog/model/journal/cp.php:60
41 (0.414)
SELECT *
FROM journal_cp_fonts
WHERE font_name = ''
/var/www/redscarpet.it/public_html/catalog/model/journal/cp.php:60
42 (0.706)
SELECT *
FROM manufacturer m
LEFT JOIN manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '67' AND m2s.store_id = '0'
/var/www/redscarpet.it/public_html/catalog/model/catalog/manufacturer.php:4
43 (0.302)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=67'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
44 (1.627)
SELECT COUNT(DISTINCT p.product_id) AS total
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' AND p.manufacturer_id = '67'
/var/www/redscarpet.it/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:691
45 (2.128)
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' AND p.manufacturer_id = '67' GROUP BY p.product_id
ORDER BY p.product_id DESC LIMIT 0,30
/var/www/redscarpet.it/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:265
46 (1.477)
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 = '104234' 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
47 (1.165)
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 = '103243' 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
48 (1.130)
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 = '103220' 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
49 (1.287)
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 = '103219' 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
50 (1.182)
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 = '103218' 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
51 (1.216)
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 = '102975' 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
52 (1.151)
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 = '102974' 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
53 (1.186)
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 = '102936' 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
54 (1.150)
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 = '102935' 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
55 (1.124)
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
56 (1.203)
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 = '100063' 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
57 (1.114)
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 = '100062' 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
58 (1.095)
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 = '100060' 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
59 (1.120)
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 = '100046' 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
60 (1.128)
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 = '99286' 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
61 (1.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 = '99285' 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
62 (1.104)
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 = '99284' 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
63 (1.100)
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 = '99283' 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
64 (1.104)
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 = '99282' 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
65 (1.141)
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 = '99276' 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
66 (1.151)
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 = '99275' 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
67 (1.099)
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 = '99274' 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
68 (1.515)
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 = '99271' 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
69 (1.388)
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 = '99270' 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
70 (1.315)
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 = '99268' 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
71 (1.190)
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 = '99267' 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
72 (1.170)
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 = '99217' 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
73 (0.776)
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
74 (0.382)
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
75 (0.232)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=67'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
76 (0.157)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=104234'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
77 (0.374)
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
78 (0.363)
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
79 (0.194)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=67'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
80 (0.165)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=103243'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
81 (0.366)
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
82 (0.420)
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
83 (0.163)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=67'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
84 (0.173)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=103220'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
85 (0.358)
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
86 (0.354)
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
87 (0.180)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=67'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
88 (0.178)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=103219'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
89 (0.353)
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
90 (0.358)
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
91 (0.161)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=67'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
92 (0.167)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=103218'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
93 (0.383)
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
94 (0.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
95 (0.216)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=67'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
96 (0.167)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=102975'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
97 (0.348)
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
98 (0.364)
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
99 (0.219)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=67'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
100 (0.169)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=102974'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
101 (0.384)
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 (0.346)
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 (0.309)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=67'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
104 (0.180)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=102936'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
105 (0.365)
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
106 (0.375)
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
107 (0.185)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=67'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
108 (0.269)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=102935'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
109 (0.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 = '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
110 (0.445)
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
111 (0.223)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=67'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
112 (0.161)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=102308'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
113 (0.451)
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 (0.367)
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.190)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=67'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
116 (0.159)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=100063'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
117 (0.351)
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
118 (0.352)
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
119 (0.221)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=67'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
120 (0.143)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=100062'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
121 (0.335)
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
122 (0.342)
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
123 (0.183)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=67'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
124 (0.172)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=100060'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
125 (0.383)
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 (0.389)
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.213)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=67'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
128 (0.509)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=100046'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
129 (0.417)
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
130 (0.482)
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
131 (1.342)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=67'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
132 (0.517)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=99286'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
133 (0.377)
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
134 (0.357)
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
135 (0.204)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=67'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
136 (0.148)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=99285'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
137 (0.352)
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 (0.758)
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 (0.168)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=67'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
140 (0.151)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=99284'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
141 (0.362)
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
142 (0.372)
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
143 (0.165)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=67'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
144 (0.151)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=99283'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
145 (0.352)
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
146 (0.779)
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
147 (0.207)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=67'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
148 (0.148)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=99282'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
149 (0.359)
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.340)
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.160)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=67'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
152 (0.141)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=99276'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
153 (0.353)
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
154 (0.362)
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
155 (0.186)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=67'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
156 (0.161)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=99275'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
157 (0.369)
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
158 (0.403)
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
159 (0.167)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=67'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
160 (0.141)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=99274'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
161 (0.339)
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
162 (0.347)
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
163 (0.203)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=67'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
164 (0.172)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=99271'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
165 (0.389)
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
166 (0.352)
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
167 (0.158)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=67'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
168 (0.142)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=99270'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
169 (0.381)
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
170 (0.366)
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
171 (0.158)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=67'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
172 (0.139)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=99268'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
173 (0.335)
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
174 (0.363)
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
175 (0.158)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=67'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
176 (0.177)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=99267'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
177 (0.388)
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
178 (0.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
179 (0.524)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=67'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
180 (0.173)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=99217'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
181 (0.144)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=67'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
182 (0.147)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=67'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
183 (0.194)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=67'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
184 (0.135)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=67'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
185 (0.126)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=67'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
186 (0.124)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=67'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
187 (0.123)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=67'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
188 (0.156)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=67'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
189 (0.156)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=67'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
190 (0.127)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=67'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
191 (0.122)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=67'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
192 (0.122)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=67'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
193 (0.121)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=67'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
194 (0.148)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=67'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
195 (0.126)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=67'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
196 (0.408)
SELECT *
FROM layout_route
WHERE 'product/manufacturer/info' 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
197 (0.366)
SELECT *
FROM extension
WHERE `type` = 'module'
/var/www/redscarpet.it/public_html/catalog/model/setting/extension.php:4
198 (0.376)
SELECT *
FROM layout_route
WHERE 'product/manufacturer/info' 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
199 (0.319)
SELECT *
FROM extension
WHERE `type` = 'module'
/var/www/redscarpet.it/public_html/catalog/model/setting/extension.php:4
200 (0.300)
SELECT *
FROM layout_route
WHERE 'product/manufacturer/info' 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
201 (0.267)
SELECT *
FROM extension
WHERE `type` = 'module'
/var/www/redscarpet.it/public_html/catalog/model/setting/extension.php:4
202 (0.319)
SELECT *
FROM layout_route
WHERE 'product/manufacturer/info' 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
203 (0.209)
SELECT *
FROM extension
WHERE `type` = 'module'
/var/www/redscarpet.it/public_html/catalog/model/setting/extension.php:4
204 (1.079)
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
205 (0.212)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=4'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
206 (0.207)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=8'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
207 (0.157)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=3'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
208 (0.146)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=5'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
209 (0.128)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=7'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
210 (0.354)
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
211 (0.195)
REPLACE INTO `customer_online` SET `ip` = '34.204.179.0', `customer_id` = '0', `url` = 'http://redscarpet.it/index.php?route=product/manufacturer/info&manufacturer_id=67', `referer` = '', `date_added` = NOW()
/var/www/redscarpet.it/public_html/catalog/model/tool/online.php:6
212 (0.279)
SELECT *
FROM extension
WHERE `type` = 'module'
/var/www/redscarpet.it/public_html/catalog/model/setting/extension.php:4
213 (0.299)
SELECT *
FROM layout_route
WHERE 'product/manufacturer/info' 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
214 (10.892)
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
215 (1.922)
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 = '109131' 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
216 (1.243)
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 = '109126' 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
217 (1.147)
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 = '109125' 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
218 (1.310)
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 = '108875' 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
219 (1.269)
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 = '108864' 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
220 (1.192)
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 = '108855' 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
221 (1.137)
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 = '108812' 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
222 (1.132)
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 = '108027' 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
223 (1.152)
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 = '108018' 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
224 (1.104)
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 = '107823' 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
225 (1.123)
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 = '107818' 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
226 (1.127)
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 = '107802' 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
227 (1.228)
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 = '107760' 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
228 (1.144)
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 = '107758' 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
229 (1.078)
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 = '107683' 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
230 (1.152)
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 = '106953' 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
231 (1.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 = '106113' 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
232 (1.115)
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 = '106109' 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
233 (1.127)
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 = '106108' 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
234 (1.122)
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 = '106105' 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
235 (0.506)
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
236 (0.396)
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
237 (0.178)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=109131'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
238 (0.415)
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
239 (0.374)
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
240 (0.192)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=109126'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
241 (0.408)
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
242 (0.390)
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
243 (0.183)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=109125'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
244 (0.395)
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
245 (0.374)
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
246 (0.183)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=108875'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
247 (0.401)
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
248 (0.362)
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
249 (0.194)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=108864'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
250 (0.380)
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
251 (0.367)
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
252 (0.232)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=108855'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
253 (0.373)
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
254 (0.349)
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
255 (0.174)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=108812'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
256 (0.398)
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
257 (0.419)
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
258 (0.187)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=108027'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
259 (0.367)
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
260 (0.346)
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
261 (0.154)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=108018'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
262 (0.326)
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
263 (0.348)
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
264 (0.157)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=107823'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
265 (0.360)
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
266 (0.417)
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
267 (0.164)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=107818'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
268 (0.344)
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
269 (0.373)
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
270 (0.183)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=107802'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
271 (0.353)
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
272 (0.360)
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
273 (0.162)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=107760'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
274 (0.346)
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
275 (0.386)
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
276 (0.184)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=107758'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
277 (0.370)
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
278 (0.355)
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
279 (0.176)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=107683'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
280 (0.354)
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
281 (0.371)
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
282 (0.164)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=106953'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
283 (0.366)
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
284 (0.367)
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
285 (0.178)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=106113'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
286 (0.374)
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
287 (0.367)
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
288 (0.176)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=106109'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
289 (0.350)
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
290 (0.353)
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
291 (0.162)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=106108'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
292 (0.387)
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
293 (0.354)
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
294 (0.156)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=106105'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
295 (0.623)
SELECT *
FROM setting
WHERE store_id = '0' AND `group` = 'pavmegamenu_params'
/var/www/redscarpet.it/public_html/catalog/model/setting/setting.php:6
296 (1.194)
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
297 (0.232)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=61'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:82
298 (0.194)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=65'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:82
299 (0.238)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=75'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:82
300 (0.182)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=102'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:82
301 (0.150)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=27'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:82
302 (0.132)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=33'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:82
303 (0.130)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=140'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:82
304 (0.140)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=142'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:82
305 (0.242)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=67'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
306 (0.216)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=67'
/var/www/redscarpet.it/public_html/catalog/controller/common/seo_url.php:71
307 (0.426)
SELECT *
FROM extension
WHERE `type` = 'total'
/var/www/redscarpet.it/public_html/catalog/model/setting/extension.php:4
308 (0.356)
SELECT SUM(amount) AS total
FROM customer_transaction
WHERE customer_id = '0'
/var/www/redscarpet.it/public_html/system/library/customer.php:157