Sportdeals Facebook Sportdeals Twitter Sportdeals Instagram Sportdeals blog Sportdeals Youtube Sportdeals Google+ Sportdeals Pinterest
[ΣΥΝΔΕΣΗ ΠΕΛΑΤΗ] [ΝΕΟΣ ΠΕΛΑΤΗΣ] [ΛΙΣΤΑ ΕΠΙΘΥΜΙΩΝ (0)] [Ο ΛΟΓΑΡΙΑΣΜΟΣ ΜΟΥ] [ΑΓΟΡΑ]
Το καλάθι σας είναι άδειο!

MAUI MAUI

Ταξινόμηση ως:
Εμφάνιση:
 

 

Φίλτρα
  • Τιμή
    € -
  • Υποκατηγορία
    0
    0
    0
    0
  • Γένος
    0
    0
    0
  • Ρούχο Νο
    0
    0
    0
    0
  • Ρούχο Παιδικά
    0
    0
    0
    0
    0
  • Χρώμα
35%

ΚΔ:1165400023 DARK DENIM
11,90€7,73€
Διαθέσιμο νούμερα 128
35%

ΚΔ:1165400026 RED F1
11,90€7,73€
Διαθέσιμο νούμερα 1068
35%

ΚΔ:1165400029 SULPHUR SPRING
10,90€7,08€
Διαθέσιμο νούμερα 101214
35%

ΚΔ:1165400025 SWEDISH BLUE
11,90€7,73€
Διαθέσιμο νούμερα 1012148
35%

ΚΔ:1165400002 JET BLACK
9,90€6,43€
Διαθέσιμο νούμερα M
35%

ΚΔ:1165400002 SMOKED PEARL
9,90€6,43€
Διαθέσιμο νούμερα LMXL
35%

ΚΔ:1165400002 BLOSSOM
9,90€6,43€
Διαθέσιμο νούμερα LMS
35%

ΚΔ:1165400001 BRIGHT WHITE
9,90€6,43€
Διαθέσιμο νούμερα M
35%

ΚΔ:0865380006 TURQUOISE-BLACK
26,90€17,48€
Διαθέσιμο νούμερα L
35%

ΚΔ:0865380006 NAVY-ORANGE
26,90€17,48€
Διαθέσιμο νούμερα L
35%

ΚΔ:1165380026 HOT CORAL
9,90€6,43€
Διαθέσιμο νούμερα M
20%

ΚΔ:1965370007 TOTAL ECLIPSE MELANZE
40,90€32,72€
Διαθέσιμο νούμερα M
20%

ΚΔ:1965370005 INSIGNIA BLUE
40,90€32,72€
Διαθέσιμο νούμερα M
35%

ΚΔ:1165360018 INSIGNIA BLUE
11,90€7,73€
Διαθέσιμο νούμερα 8
35%

ΚΔ:1165360018 VIBRANT YELLOW
11,90€7,73€
Διαθέσιμο νούμερα 108
30%

ΚΔ:1165340024 IRON GATE
11,90€8,33€
Διαθέσιμο νούμερα 8
MAUI ΜΠΛΟΥΖΑ ΠΑΙΔΙΚΗ ΜΑΚΟ ΚΟΝΤΟΜΑΝΙΚΗ ΜΠΛΕ ΜΕ ΣΤΑΜΠΑ..
11,90€ 7,73€

MAUI ΠΑΙΔΙΚΗ ΜΠΛΟΥΖΑ ΜΑΚΟ ΚΟΝΤΟΜΑΝΙΚΗ ΚΟΚΚΙΝΗ ΜΕ ΣΤΑΜΠΑ ΜΠΡΟΣΤΑ..
11,90€ 7,73€

MAUI ΠΑΙΔΙΚΗ ΜΠΛΟΥΖΑ ΑΜΑΝΙΚΗ ΚΙΤΡΙΝΗ..
10,90€ 7,08€

MAUI ΠΑΙΔΙΚΗ ΜΠΛΟΥΖΑ ΜΑΚΟ ΚΟΝΤΟΜΑΝΙΚΗ ΜΠΛΕ ΜΕ ΣΤΑΜΠΑ..
11,90€ 7,73€

MAUI T/S ΓΥΝΑΙΚΕΙΟ ΒΑΜΒΑΚΕΡΟ ΜΠΛΟΥΖΑΚΙ ΜΑΥΡΟ..
9,90€ 6,43€

MAUI ΜΑΚΟ ΚΟΝΤΟΜΑΝΙΚΟ ΓΥΝΑΙΚΕΙΟ ΜΠΛΟΥΖΑΚΙ ΓΚΡΙ..
9,90€ 6,43€

MAUI ΜΑΚΟ ΓΥΝΑΙΚΕΙΟ ΚΟΝΤΟΜΑΝΙΚΟ ΜΠΛΟΥΖΑΚΙ ΡΟΖ..
9,90€ 6,43€

MAUI ΑΝΔΡΙΚΗ ΜΠΛΟΥΖΑ ΜΑΚΟ ΚΟΝΤΟΜΑΝΙΚΗ ΑΣΠΡΗ..
9,90€ 6,43€

MAUI ΒΕΡΜΟΥΔΑ ΜΑΓΙΟ ΜΕ ΤΣΕΠΕΣ ΤΥΡΚΟΥΑΖ ΜΕ ΡΙΓΕΣ ΜΑΥΡΕΣ..
26,90€ 17,48€

MAUI ΜΑΓΙΟ ΒΕΡΜΟΥΔΑ ΜΠΛΕ ΜΕ ΡΙΓΕΣ ΚΑΙ ΤΣΕΠΕΣ..
26,90€ 17,48€

MAUI T-S ΓΥΝΑΙΚΕΙΟ ΜΑΚΟ ΜΠΛΟΥΖΑΚΙ ΜΕ ΣΤΑΜΠΑ ΚΟΡΑΛΙ..
9,90€ 6,43€

MAUI & SONS ΖΑΚΕΤΑ ΜΕ ΚΟΥΚΟΥΛΑ ΑΝΔΡΙΚΗ ΚΑΙ ΣΤΑΜΠΑ ΣΤΗΝ ΠΛΑΤΗ ΜΕΓΑΛΗ..
40,90€ 32,72€

MAUI & SONS ΖΑΚΕΤΑ ΜΕ ΚΟΥΚΟΥΛΑ ΜΠΛΕ ΑΝΔΡΙΚΗ ΜΕ ΣΤΑΜΠΑ ΜΕΓΑΛΗ ΣΤΗΝ ΠΛΑΤΗ..
40,90€ 32,72€

MAUI ΜΑΚΟ ΠΑΙΔΙΚΟ ΚΟΝΤΟΜΑΝΙΚΟ ΜΠΛΕ ΜΕ ΣΤΑΜΠΑ..
11,90€ 7,73€

MAUI ΚΟΝΤΟΜΑΝΙΚΟ ΠΑΙΔΙΚΟ ΜΠΛΟΥΖΑΚΙ ΚΙΤΡΙΝΟ ΜΕ ΣΤΑΜΠΑ..
11,90€ 7,73€

MAUI κοντομάνικο μπλουζάκι παιδικό γκρί σκούρο με στάμπα μεγάλη μπροστά...
11,90€ 8,33€

Queries: 574, Total time: 1,938.575 ms [By time] [By id] [By file]
1 (0.082)
SELECT *
FROM oc_store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://sportdeals.gr/'
/home/spor8371/public_html/index.php:50
2 (3.138)
SELECT *
FROM oc_setting
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC
/home/spor8371/public_html/index.php:62
3 (0.097)
SELECT *
FROM `oc_language`
WHERE status = '1'
/home/spor8371/public_html/index.php:141
4 (0.090)
SELECT *
FROM oc_currency
/home/spor8371/public_html/system/library/currency.php:13
5 (0.086)
SELECT *
FROM oc_weight_class wc
LEFT JOIN oc_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id)
WHERE wcd.language_id = '2'
/home/spor8371/public_html/system/library/weight.php:9
6 (0.083)
SELECT *
FROM oc_length_class mc
LEFT JOIN oc_length_class_description mcd ON (mc.length_class_id = mcd.length_class_id)
WHERE mcd.language_id = '2'
/home/spor8371/public_html/system/library/length.php:9
7 (1.435)
SELECT *
FROM oc_url_alias
WHERE keyword = 'maui'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:73
8 (0.347)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '30' AND m2s.store_id = '0'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_manufacturer.php:4
9 (0.730)
SHOW TABLES LIKE 'oc_manufacturer_description'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_manufacturer.php:10
10 (0.256)
SELECT *
FROM oc_manufacturer_description
WHERE manufacturer_id = '30' AND language_id = '2'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_manufacturer.php:18
11 (1.339)
SELECT *
FROM oc_url_alias
WHERE `query` = 'manufacturer_id=30'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:154
12 (20.230)
SELECT COUNT(DISTINCT `product_id`) AS `total`
FROM(SELECT DISTINCT `p`.`product_id`
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE IF( `p`.`quantity` > 0, 7, `p`.`stock_status_id` ) IN(7) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=1 AND p2s.store_id = '0' AND p.manufacturer_id = '30') AS `tmp`
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:656
13 (21.607)
SELECT *
FROM(SELECT p.product_id , p.descr2 , (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price
FROM oc_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 oc_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 oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE IF( `p`.`quantity` > 0, 7, `p`.`stock_status_id` ) IN(7) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=1 AND p2s.store_id = '0' AND p.manufacturer_id = '30' GROUP BY p.product_id
ORDER BY p.date_added DESC, LCASE(pd.name) DESC ) AS `tmp` LIMIT 0,24
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:251
14 (0.831)
SELECT DISTINCT * ,p.descr2 , pd.name AS name, p.OC_series, p.image, m.name AS manufacturer, m.image AS man_img, (SELECT price
FROM oc_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 oc_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 oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_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 oc_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 oc_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 oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order, pd.sizechart_id
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '7020' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=0 AND p2s.store_id = '0'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:16
15 (0.670)
SELECT DISTINCT * ,p.descr2 , pd.name AS name, p.OC_series, p.image, m.name AS manufacturer, m.image AS man_img, (SELECT price
FROM oc_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 oc_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 oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_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 oc_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 oc_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 oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order, pd.sizechart_id
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '7019' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=0 AND p2s.store_id = '0'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:16
16 (0.650)
SELECT DISTINCT * ,p.descr2 , pd.name AS name, p.OC_series, p.image, m.name AS manufacturer, m.image AS man_img, (SELECT price
FROM oc_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 oc_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 oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_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 oc_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 oc_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 oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order, pd.sizechart_id
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '7018' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=0 AND p2s.store_id = '0'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:16
17 (0.655)
SELECT DISTINCT * ,p.descr2 , pd.name AS name, p.OC_series, p.image, m.name AS manufacturer, m.image AS man_img, (SELECT price
FROM oc_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 oc_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 oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_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 oc_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 oc_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 oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order, pd.sizechart_id
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '7017' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=0 AND p2s.store_id = '0'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:16
18 (0.657)
SELECT DISTINCT * ,p.descr2 , pd.name AS name, p.OC_series, p.image, m.name AS manufacturer, m.image AS man_img, (SELECT price
FROM oc_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 oc_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 oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_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 oc_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 oc_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 oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order, pd.sizechart_id
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '6726' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=0 AND p2s.store_id = '0'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:16
19 (0.642)
SELECT DISTINCT * ,p.descr2 , pd.name AS name, p.OC_series, p.image, m.name AS manufacturer, m.image AS man_img, (SELECT price
FROM oc_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 oc_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 oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_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 oc_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 oc_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 oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order, pd.sizechart_id
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '6725' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=0 AND p2s.store_id = '0'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:16
20 (0.658)
SELECT DISTINCT * ,p.descr2 , pd.name AS name, p.OC_series, p.image, m.name AS manufacturer, m.image AS man_img, (SELECT price
FROM oc_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 oc_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 oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_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 oc_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 oc_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 oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order, pd.sizechart_id
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '6724' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=0 AND p2s.store_id = '0'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:16
21 (0.652)
SELECT DISTINCT * ,p.descr2 , pd.name AS name, p.OC_series, p.image, m.name AS manufacturer, m.image AS man_img, (SELECT price
FROM oc_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 oc_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 oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_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 oc_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 oc_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 oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order, pd.sizechart_id
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '6684' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=0 AND p2s.store_id = '0'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:16
22 (0.650)
SELECT DISTINCT * ,p.descr2 , pd.name AS name, p.OC_series, p.image, m.name AS manufacturer, m.image AS man_img, (SELECT price
FROM oc_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 oc_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 oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_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 oc_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 oc_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 oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order, pd.sizechart_id
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '5431' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=0 AND p2s.store_id = '0'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:16
23 (0.637)
SELECT DISTINCT * ,p.descr2 , pd.name AS name, p.OC_series, p.image, m.name AS manufacturer, m.image AS man_img, (SELECT price
FROM oc_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 oc_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 oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_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 oc_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 oc_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 oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order, pd.sizechart_id
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '5430' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=0 AND p2s.store_id = '0'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:16
24 (0.672)
SELECT DISTINCT * ,p.descr2 , pd.name AS name, p.OC_series, p.image, m.name AS manufacturer, m.image AS man_img, (SELECT price
FROM oc_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 oc_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 oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_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 oc_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 oc_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 oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order, pd.sizechart_id
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '5114' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=0 AND p2s.store_id = '0'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:16
25 (0.632)
SELECT DISTINCT * ,p.descr2 , pd.name AS name, p.OC_series, p.image, m.name AS manufacturer, m.image AS man_img, (SELECT price
FROM oc_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 oc_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 oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_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 oc_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 oc_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 oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order, pd.sizechart_id
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '4893' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=0 AND p2s.store_id = '0'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:16
26 (0.659)
SELECT DISTINCT * ,p.descr2 , pd.name AS name, p.OC_series, p.image, m.name AS manufacturer, m.image AS man_img, (SELECT price
FROM oc_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 oc_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 oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_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 oc_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 oc_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 oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order, pd.sizechart_id
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '4892' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=0 AND p2s.store_id = '0'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:16
27 (0.639)
SELECT DISTINCT * ,p.descr2 , pd.name AS name, p.OC_series, p.image, m.name AS manufacturer, m.image AS man_img, (SELECT price
FROM oc_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 oc_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 oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_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 oc_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 oc_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 oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order, pd.sizechart_id
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '4103' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=0 AND p2s.store_id = '0'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:16
28 (0.643)
SELECT DISTINCT * ,p.descr2 , pd.name AS name, p.OC_series, p.image, m.name AS manufacturer, m.image AS man_img, (SELECT price
FROM oc_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 oc_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 oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_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 oc_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 oc_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 oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order, pd.sizechart_id
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '4102' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=0 AND p2s.store_id = '0'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:16
29 (0.670)
SELECT DISTINCT * ,p.descr2 , pd.name AS name, p.OC_series, p.image, m.name AS manufacturer, m.image AS man_img, (SELECT price
FROM oc_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 oc_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 oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_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 oc_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 oc_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 oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order, pd.sizechart_id
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '2804' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=0 AND p2s.store_id = '0'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:16
30 (0.659)
SELECT DISTINCT * ,p.descr2 , pd.name AS name, p.OC_series, p.image, m.name AS manufacturer, m.image AS man_img, (SELECT price
FROM oc_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 oc_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 oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_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 oc_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 oc_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 oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order, pd.sizechart_id
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '7020' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=0 AND p2s.store_id = '0'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:16
31 (0.066)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1280')
ORDER BY tr1.priority ASC
/home/spor8371/public_html/system/library/tax.php:91
32 (0.061)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1280')
ORDER BY tr1.priority ASC
/home/spor8371/public_html/system/library/tax.php:119
33 (0.064)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1280')
ORDER BY tr1.priority ASC
/home/spor8371/public_html/system/library/tax.php:91
34 (0.055)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1280')
ORDER BY tr1.priority ASC
/home/spor8371/public_html/system/library/tax.php:119
35 (0.057)
SELECT *
FROM oc_url_alias
WHERE `query` = 'manufacturer_id=30'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:154
36 (0.055)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=7020'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:154
37 (0.663)
SELECT DISTINCT * ,p.descr2 , pd.name AS name, p.OC_series, p.image, m.name AS manufacturer, m.image AS man_img, (SELECT price
FROM oc_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 oc_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 oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_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 oc_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 oc_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 oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order, pd.sizechart_id
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '7019' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=0 AND p2s.store_id = '0'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:16
38 (0.064)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1280')
ORDER BY tr1.priority ASC
/home/spor8371/public_html/system/library/tax.php:91
39 (0.065)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1280')
ORDER BY tr1.priority ASC
/home/spor8371/public_html/system/library/tax.php:119
40 (0.052)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1280')
ORDER BY tr1.priority ASC
/home/spor8371/public_html/system/library/tax.php:91
41 (0.064)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1280')
ORDER BY tr1.priority ASC
/home/spor8371/public_html/system/library/tax.php:119
42 (0.057)
SELECT *
FROM oc_url_alias
WHERE `query` = 'manufacturer_id=30'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:154
43 (0.053)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=7019'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:154
44 (0.699)
SELECT DISTINCT * ,p.descr2 , pd.name AS name, p.OC_series, p.image, m.name AS manufacturer, m.image AS man_img, (SELECT price
FROM oc_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 oc_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 oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_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 oc_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 oc_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 oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order, pd.sizechart_id
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '7018' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=0 AND p2s.store_id = '0'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:16
45 (0.056)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1280')
ORDER BY tr1.priority ASC
/home/spor8371/public_html/system/library/tax.php:91
46 (0.056)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1280')
ORDER BY tr1.priority ASC
/home/spor8371/public_html/system/library/tax.php:119
47 (0.052)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1280')
ORDER BY tr1.priority ASC
/home/spor8371/public_html/system/library/tax.php:91
48 (0.054)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1280')
ORDER BY tr1.priority ASC
/home/spor8371/public_html/system/library/tax.php:119
49 (0.052)
SELECT *
FROM oc_url_alias
WHERE `query` = 'manufacturer_id=30'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:154
50 (0.052)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=7018'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:154
51 (0.730)
SELECT DISTINCT * ,p.descr2 , pd.name AS name, p.OC_series, p.image, m.name AS manufacturer, m.image AS man_img, (SELECT price
FROM oc_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 oc_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 oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_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 oc_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 oc_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 oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order, pd.sizechart_id
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '7017' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=0 AND p2s.store_id = '0'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:16
52 (0.074)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1280')
ORDER BY tr1.priority ASC
/home/spor8371/public_html/system/library/tax.php:91
53 (0.062)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1280')
ORDER BY tr1.priority ASC
/home/spor8371/public_html/system/library/tax.php:119
54 (0.057)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1280')
ORDER BY tr1.priority ASC
/home/spor8371/public_html/system/library/tax.php:91
55 (0.061)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1280')
ORDER BY tr1.priority ASC
/home/spor8371/public_html/system/library/tax.php:119
56 (0.060)
SELECT *
FROM oc_url_alias
WHERE `query` = 'manufacturer_id=30'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:154
57 (0.063)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=7017'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:154
58 (0.707)
SELECT DISTINCT * ,p.descr2 , pd.name AS name, p.OC_series, p.image, m.name AS manufacturer, m.image AS man_img, (SELECT price
FROM oc_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 oc_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 oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_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 oc_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 oc_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 oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order, pd.sizechart_id
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '6726' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=0 AND p2s.store_id = '0'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:16
59 (0.061)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1280')
ORDER BY tr1.priority ASC
/home/spor8371/public_html/system/library/tax.php:91
60 (0.055)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1280')
ORDER BY tr1.priority ASC
/home/spor8371/public_html/system/library/tax.php:119
61 (0.051)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1280')
ORDER BY tr1.priority ASC
/home/spor8371/public_html/system/library/tax.php:91
62 (0.055)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1280')
ORDER BY tr1.priority ASC
/home/spor8371/public_html/system/library/tax.php:119
63 (0.069)
SELECT *
FROM oc_url_alias
WHERE `query` = 'manufacturer_id=30'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:154
64 (0.053)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=6726'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:154
65 (0.695)
SELECT DISTINCT * ,p.descr2 , pd.name AS name, p.OC_series, p.image, m.name AS manufacturer, m.image AS man_img, (SELECT price
FROM oc_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 oc_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 oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_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 oc_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 oc_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 oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order, pd.sizechart_id
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '6725' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=0 AND p2s.store_id = '0'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:16
66 (0.074)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1280')
ORDER BY tr1.priority ASC
/home/spor8371/public_html/system/library/tax.php:91
67 (0.072)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1280')
ORDER BY tr1.priority ASC
/home/spor8371/public_html/system/library/tax.php:119
68 (0.070)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1280')
ORDER BY tr1.priority ASC
/home/spor8371/public_html/system/library/tax.php:91
69 (0.073)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1280')
ORDER BY tr1.priority ASC
/home/spor8371/public_html/system/library/tax.php:119
70 (0.068)
SELECT *
FROM oc_url_alias
WHERE `query` = 'manufacturer_id=30'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:154
71 (0.071)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=6725'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:154
72 (0.723)
SELECT DISTINCT * ,p.descr2 , pd.name AS name, p.OC_series, p.image, m.name AS manufacturer, m.image AS man_img, (SELECT price
FROM oc_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 oc_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 oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_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 oc_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 oc_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 oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order, pd.sizechart_id
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '6724' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=0 AND p2s.store_id = '0'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:16
73 (0.061)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1280')
ORDER BY tr1.priority ASC
/home/spor8371/public_html/system/library/tax.php:91
74 (0.068)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1280')
ORDER BY tr1.priority ASC
/home/spor8371/public_html/system/library/tax.php:119
75 (0.055)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1280')
ORDER BY tr1.priority ASC
/home/spor8371/public_html/system/library/tax.php:91
76 (0.055)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1280')
ORDER BY tr1.priority ASC
/home/spor8371/public_html/system/library/tax.php:119
77 (0.053)
SELECT *
FROM oc_url_alias
WHERE `query` = 'manufacturer_id=30'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:154
78 (0.051)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=6724'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:154
79 (0.759)
SELECT DISTINCT * ,p.descr2 , pd.name AS name, p.OC_series, p.image, m.name AS manufacturer, m.image AS man_img, (SELECT price
FROM oc_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 oc_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 oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_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 oc_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 oc_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 oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order, pd.sizechart_id
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '6684' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=0 AND p2s.store_id = '0'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:16
80 (0.081)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1280')
ORDER BY tr1.priority ASC
/home/spor8371/public_html/system/library/tax.php:91
81 (0.078)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1280')
ORDER BY tr1.priority ASC
/home/spor8371/public_html/system/library/tax.php:119
82 (0.068)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1280')
ORDER BY tr1.priority ASC
/home/spor8371/public_html/system/library/tax.php:91
83 (0.073)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1280')
ORDER BY tr1.priority ASC
/home/spor8371/public_html/system/library/tax.php:119
84 (0.070)
SELECT *
FROM oc_url_alias
WHERE `query` = 'manufacturer_id=30'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:154
85 (1.118)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=6684'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:154
86 (0.762)
SELECT DISTINCT * ,p.descr2 , pd.name AS name, p.OC_series, p.image, m.name AS manufacturer, m.image AS man_img, (SELECT price
FROM oc_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 oc_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 oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_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 oc_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 oc_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 oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order, pd.sizechart_id
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '5431' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=0 AND p2s.store_id = '0'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:16
87 (0.084)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1280')
ORDER BY tr1.priority ASC
/home/spor8371/public_html/system/library/tax.php:91
88 (0.075)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1280')
ORDER BY tr1.priority ASC
/home/spor8371/public_html/system/library/tax.php:119
89 (0.072)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1280')
ORDER BY tr1.priority ASC
/home/spor8371/public_html/system/library/tax.php:91
90 (0.077)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1280')
ORDER BY tr1.priority ASC
/home/spor8371/public_html/system/library/tax.php:119
91 (0.076)
SELECT *
FROM oc_url_alias
WHERE `query` = 'manufacturer_id=30'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:154
92 (1.093)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=5431'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:154
93 (0.824)
SELECT DISTINCT * ,p.descr2 , pd.name AS name, p.OC_series, p.image, m.name AS manufacturer, m.image AS man_img, (SELECT price
FROM oc_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 oc_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 oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_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 oc_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 oc_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 oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order, pd.sizechart_id
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '5430' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=0 AND p2s.store_id = '0'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:16
94 (0.077)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1280')
ORDER BY tr1.priority ASC
/home/spor8371/public_html/system/library/tax.php:91
95 (0.081)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1280')
ORDER BY tr1.priority ASC
/home/spor8371/public_html/system/library/tax.php:119
96 (0.073)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1280')
ORDER BY tr1.priority ASC
/home/spor8371/public_html/system/library/tax.php:91
97 (0.074)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1280')
ORDER BY tr1.priority ASC
/home/spor8371/public_html/system/library/tax.php:119
98 (0.073)
SELECT *
FROM oc_url_alias
WHERE `query` = 'manufacturer_id=30'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:154
99 (1.056)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=5430'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:154
100 (0.795)
SELECT DISTINCT * ,p.descr2 , pd.name AS name, p.OC_series, p.image, m.name AS manufacturer, m.image AS man_img, (SELECT price
FROM oc_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 oc_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 oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_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 oc_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 oc_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 oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order, pd.sizechart_id
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '5114' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=0 AND p2s.store_id = '0'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:16
101 (0.077)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1280')
ORDER BY tr1.priority ASC
/home/spor8371/public_html/system/library/tax.php:91
102 (0.083)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1280')
ORDER BY tr1.priority ASC
/home/spor8371/public_html/system/library/tax.php:119
103 (0.073)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1280')
ORDER BY tr1.priority ASC
/home/spor8371/public_html/system/library/tax.php:91
104 (0.075)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1280')
ORDER BY tr1.priority ASC
/home/spor8371/public_html/system/library/tax.php:119
105 (0.071)
SELECT *
FROM oc_url_alias
WHERE `query` = 'manufacturer_id=30'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:154
106 (0.071)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=5114'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:154
107 (0.723)
SELECT DISTINCT * ,p.descr2 , pd.name AS name, p.OC_series, p.image, m.name AS manufacturer, m.image AS man_img, (SELECT price
FROM oc_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 oc_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 oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_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 oc_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 oc_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 oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order, pd.sizechart_id
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '4893' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=0 AND p2s.store_id = '0'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:16
108 (0.077)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1280')
ORDER BY tr1.priority ASC
/home/spor8371/public_html/system/library/tax.php:91
109 (0.074)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1280')
ORDER BY tr1.priority ASC
/home/spor8371/public_html/system/library/tax.php:119
110 (0.072)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1280')
ORDER BY tr1.priority ASC
/home/spor8371/public_html/system/library/tax.php:91
111 (0.081)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1280')
ORDER BY tr1.priority ASC
/home/spor8371/public_html/system/library/tax.php:119
112 (0.071)
SELECT *
FROM oc_url_alias
WHERE `query` = 'manufacturer_id=30'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:154
113 (0.071)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=4893'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:154
114 (0.710)
SELECT DISTINCT * ,p.descr2 , pd.name AS name, p.OC_series, p.image, m.name AS manufacturer, m.image AS man_img, (SELECT price
FROM oc_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 oc_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 oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_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 oc_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 oc_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 oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order, pd.sizechart_id
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '4892' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=0 AND p2s.store_id = '0'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:16
115 (0.076)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1280')
ORDER BY tr1.priority ASC
/home/spor8371/public_html/system/library/tax.php:91
116 (0.080)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1280')
ORDER BY tr1.priority ASC
/home/spor8371/public_html/system/library/tax.php:119
117 (0.074)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1280')
ORDER BY tr1.priority ASC
/home/spor8371/public_html/system/library/tax.php:91
118 (0.075)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1280')
ORDER BY tr1.priority ASC
/home/spor8371/public_html/system/library/tax.php:119
119 (0.072)
SELECT *
FROM oc_url_alias
WHERE `query` = 'manufacturer_id=30'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:154
120 (0.072)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=4892'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:154
121 (0.728)
SELECT DISTINCT * ,p.descr2 , pd.name AS name, p.OC_series, p.image, m.name AS manufacturer, m.image AS man_img, (SELECT price
FROM oc_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 oc_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 oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_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 oc_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 oc_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 oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order, pd.sizechart_id
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '4103' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=0 AND p2s.store_id = '0'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:16
122 (0.077)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1280')
ORDER BY tr1.priority ASC
/home/spor8371/public_html/system/library/tax.php:91
123 (0.076)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1280')
ORDER BY tr1.priority ASC
/home/spor8371/public_html/system/library/tax.php:119
124 (0.080)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1280')
ORDER BY tr1.priority ASC
/home/spor8371/public_html/system/library/tax.php:91
125 (0.077)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1280')
ORDER BY tr1.priority ASC
/home/spor8371/public_html/system/library/tax.php:119
126 (0.072)
SELECT *
FROM oc_url_alias
WHERE `query` = 'manufacturer_id=30'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:154
127 (1.072)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=4103'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:154
128 (0.746)
SELECT DISTINCT * ,p.descr2 , pd.name AS name, p.OC_series, p.image, m.name AS manufacturer, m.image AS man_img, (SELECT price
FROM oc_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 oc_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 oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_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 oc_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 oc_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 oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order, pd.sizechart_id
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '4102' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=0 AND p2s.store_id = '0'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:16
129 (0.080)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1280')
ORDER BY tr1.priority ASC
/home/spor8371/public_html/system/library/tax.php:91
130 (0.078)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1280')
ORDER BY tr1.priority ASC
/home/spor8371/public_html/system/library/tax.php:119
131 (0.070)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1280')
ORDER BY tr1.priority ASC
/home/spor8371/public_html/system/library/tax.php:91
132 (0.075)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1280')
ORDER BY tr1.priority ASC
/home/spor8371/public_html/system/library/tax.php:119
133 (0.079)
SELECT *
FROM oc_url_alias
WHERE `query` = 'manufacturer_id=30'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:154
134 (1.051)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=4102'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:154
135 (0.754)
SELECT DISTINCT * ,p.descr2 , pd.name AS name, p.OC_series, p.image, m.name AS manufacturer, m.image AS man_img, (SELECT price
FROM oc_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 oc_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 oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_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 oc_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 oc_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 oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order, pd.sizechart_id
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '2804' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=0 AND p2s.store_id = '0'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:16
136 (0.083)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1280')
ORDER BY tr1.priority ASC
/home/spor8371/public_html/system/library/tax.php:91
137 (0.080)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1280')
ORDER BY tr1.priority ASC
/home/spor8371/public_html/system/library/tax.php:119
138 (0.071)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1280')
ORDER BY tr1.priority ASC
/home/spor8371/public_html/system/library/tax.php:91
139 (0.074)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '1280')
ORDER BY tr1.priority ASC
/home/spor8371/public_html/system/library/tax.php:119
140 (0.076)
SELECT *
FROM oc_url_alias
WHERE `query` = 'manufacturer_id=30'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:154
141 (1.056)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=2804'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:154
142 (0.073)
SELECT *
FROM oc_url_alias
WHERE `query` = 'manufacturer_id=30'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:154
143 (0.071)
SELECT *
FROM oc_url_alias
WHERE `query` = 'manufacturer_id=30'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:154
144 (0.074)
SELECT *
FROM oc_url_alias
WHERE `query` = 'manufacturer_id=30'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:154
145 (0.071)
SELECT *
FROM oc_url_alias
WHERE `query` = 'manufacturer_id=30'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:154
146 (0.070)
SELECT *
FROM oc_url_alias
WHERE `query` = 'manufacturer_id=30'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:154
147 (0.085)
SELECT *
FROM oc_url_alias
WHERE `query` = 'manufacturer_id=30'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:154
148 (0.072)
SELECT *
FROM oc_url_alias
WHERE `query` = 'manufacturer_id=30'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:154
149 (0.077)
SELECT *
FROM oc_url_alias
WHERE `query` = 'manufacturer_id=30'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:154
150 (0.073)
SELECT *
FROM oc_url_alias
WHERE `query` = 'manufacturer_id=30'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:154
151 (0.071)
SELECT *
FROM oc_url_alias
WHERE `query` = 'manufacturer_id=30'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:154
152 (0.070)
SELECT *
FROM oc_url_alias
WHERE `query` = 'manufacturer_id=30'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:154
153 (0.069)
SELECT *
FROM oc_url_alias
WHERE `query` = 'manufacturer_id=30'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:154
154 (0.070)
SELECT *
FROM oc_url_alias
WHERE `query` = 'manufacturer_id=30'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:154
155 (0.262)
SELECT *
FROM oc_manufacturer_to_layout
WHERE manufacturer_id = '30' AND store_id = '0'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_manufacturer.php:32
156 (0.255)
SELECT *
FROM oc_layout_route
WHERE 'product/manufacturer/info' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/spor8371/public_html/catalog/model/design/layout.php:4
157 (0.161)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_setting_extension.php:4
158 (0.067)
SELECT *
FROM oc_manufacturer_to_layout
WHERE manufacturer_id = '30' AND store_id = '0'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_manufacturer.php:32
159 (0.056)
SELECT *
FROM oc_layout_route
WHERE 'product/manufacturer/info' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/spor8371/public_html/catalog/model/design/layout.php:4
160 (0.097)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_setting_extension.php:4
161 (0.062)
SELECT *
FROM oc_manufacturer_to_layout
WHERE manufacturer_id = '30' AND store_id = '0'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_manufacturer.php:32
162 (0.060)
SELECT *
FROM oc_layout_route
WHERE 'product/manufacturer/info' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/spor8371/public_html/catalog/model/design/layout.php:4
163 (0.101)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_setting_extension.php:4
164 (34.247)
SELECT `a`.`attribute_id`, REPLACE(REPLACE(TRIM(pa.text), ' ', ''), ' ', '') AS `txt`, `ad`.`name`, `agd`.`name` AS `gname`, `agd`.`attribute_group_id`
FROM `oc_product` AS `p`
INNER JOIN `oc_product_to_store` AS `pts` ON `p`.`product_id` = `pts`.`product_id` AND `pts`.`store_id` = 0
INNER JOIN `oc_product_attribute` AS `pa` ON `p`.`product_id` = `pa`.`product_id` AND `pa`.`language_id` = 2
INNER JOIN `oc_attribute` AS `a` ON `a`.`attribute_id` = `pa`.`attribute_id`
INNER JOIN `oc_attribute_description` AS `ad` ON `ad`.`attribute_id` = `a`.`attribute_id` AND `ad`.`language_id` = 2
INNER JOIN `oc_attribute_group` AS `ag` ON `ag`.`attribute_group_id` = `a`.`attribute_group_id`
INNER JOIN `oc_attribute_group_description` AS `agd` ON `agd`.`attribute_group_id` = `ag`.`attribute_group_id` AND `agd`.`language_id` = 2
WHERE `p`.`date_available` <= NOW() AND `p`.`status` = '1' AND `p`.`manufacturer_id` = 30 AND ( `p`.`quantity` > 0 OR `p`.`stock_status_id` = 7 ) GROUP BY `txt`, `pa`.`attribute_id` HAVING `txt` != ''
ORDER BY `a`.`sort_order`, `txt`
/home/spor8371/public_html/catalog/model/module/mega_filter.php:2552
165 (46.631)
SELECT `o`.`option_id`, `ov`.`option_value_id`, `od`.`name` AS `gname`, `ov`.`image`, `ovd`.`name`
FROM `oc_product` AS `p`
INNER JOIN `oc_product_to_store` AS `p2s` ON `p`.`product_id` = `p2s`.`product_id` AND `p2s`.`store_id` = 0
INNER JOIN `oc_product_option_value` AS `pov` ON `p`.`product_id` = `pov`.`product_id`
INNER JOIN `oc_option_value` AS `ov` ON `ov`.`option_value_id` = `pov`.`option_value_id`
INNER JOIN `oc_option_value_description` AS `ovd` ON `ov`.`option_value_id` = `ovd`.`option_value_id` AND `ovd`.`language_id` = 2
INNER JOIN `oc_option` AS `o` ON `o`.`option_id` = `pov`.`option_id`
INNER JOIN `oc_option_description` AS `od` ON `od`.`option_id` = `o`.`option_id` AND `od`.`language_id` = 2
WHERE `p`.`date_available` <= NOW() AND `p`.`status` = '1' AND `p`.`manufacturer_id` = 30 AND `o`.`type` IN('radio','checkbox','select','image') AND `pov`.`quantity` > 0 AND ( `p`.`quantity` > 0 OR `p`.`stock_status_id` = 7 ) GROUP BY `o`.`option_id`, `ov`.`option_value_id`
ORDER BY `ov`.`sort_order`, `ovd`.`name`
/home/spor8371/public_html/catalog/model/module/mega_filter.php:2427
166 (183.069)
SELECT `fgd`.`name` AS `gname`, `f`.`filter_group_id`, `f`.`filter_id`, `fd`.`name`
FROM `oc_product` AS `p`
INNER JOIN `oc_product_to_store` AS `p2s` ON `p`.`product_id` = `p2s`.`product_id` AND `p2s`.`store_id` = 0
INNER JOIN `oc_product_filter` AS `pf` ON `p`.`product_id` = `pf`.`product_id`
INNER JOIN `oc_filter` AS `f` ON `pf`.`filter_id` = `f`.`filter_id`
INNER JOIN `oc_filter_description` AS `fd` ON `pf`.`filter_id` = `fd`.`filter_id` AND `fd`.`language_id` = 2
INNER JOIN `oc_filter_group_description` AS `fgd` ON `f`.`filter_group_id` = `fgd`.`filter_group_id` AND `fgd`.`language_id` = 2
WHERE `p`.`date_available` <= NOW() AND `p`.`status` = '1' AND `p`.`manufacturer_id` = 30 AND ( `p`.`quantity` > 0 OR `p`.`stock_status_id` = 7 ) GROUP BY `f`.`filter_group_id`, `f`.`filter_id`
ORDER BY `f`.`sort_order`, `fd`.`name`
/home/spor8371/public_html/catalog/model/module/mega_filter.php:2324
167 (22.652)
SELECT MIN(`price`) AS `p_min`, MAX(`price`) AS `p_max`
FROM( SELECT ( `price_tmp` * ( 1 + IFNULL(`p_tax`, 0) / 100 ) + IFNULL(`f_tax`, 0) ) AS `price`
FROM( SELECT IFNULL( (SELECT `price`
FROM `oc_product_special` AS `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), IFNULL( (SELECT `price`
FROM `oc_product_discount` AS `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), `p`.`price` ) ) AS `price_tmp` , ( SELECT SUM(`tr2`.`rate`)
FROM `oc_tax_rule` AS `tr1`
LEFT JOIN `oc_tax_rate` AS `tr2` ON `tr1`.`tax_rate_id` = `tr2`.`tax_rate_id`
INNER JOIN `oc_tax_rate_to_customer_group` AS `tr2cg` ON `tr2`.`tax_rate_id` = `tr2cg`.`tax_rate_id`
LEFT JOIN `oc_zone_to_geo_zone` AS `z2gz` ON `tr2`.`geo_zone_id` = `z2gz`.`geo_zone_id`
WHERE `tr1`.`tax_class_id` = `p`.`tax_class_id` AND `tr2`.`type` = 'F' AND ( ( `tr1`.`based` = 'store' AND `z2gz`.`country_id` = 84 AND ( `z2gz`.`zone_id` = '0' OR `z2gz`.`zone_id` = '1280' ) ) OR ( `tr1`.`based` = 'payment' AND `z2gz`.`country_id` = 84 AND ( `z2gz`.`zone_id` = '0' OR `z2gz`.`zone_id` = '1280' ) ) OR ( `tr1`.`based` = 'shipping' AND `z2gz`.`country_id` = 84 AND ( `z2gz`.`zone_id` = '0' OR `z2gz`.`zone_id` = '1280' ) ) ) AND `tr2cg`.`customer_group_id` = 1 ) AS f_tax , ( SELECT SUM(`tr2`.`rate`)
FROM `oc_tax_rule` AS `tr1`
LEFT JOIN `oc_tax_rate` AS `tr2` ON `tr1`.`tax_rate_id` = `tr2`.`tax_rate_id`
INNER JOIN `oc_tax_rate_to_customer_group` AS `tr2cg` ON `tr2`.`tax_rate_id` = `tr2cg`.`tax_rate_id`
LEFT JOIN `oc_zone_to_geo_zone` AS `z2gz` ON `tr2`.`geo_zone_id` = `z2gz`.`geo_zone_id`
WHERE `tr1`.`tax_class_id` = `p`.`tax_class_id` AND `tr2`.`type` = 'P' AND ( ( `tr1`.`based` = 'store' AND `z2gz`.`country_id` = 84 AND ( `z2gz`.`zone_id` = '0' OR `z2gz`.`zone_id` = '1280' ) ) OR ( `tr1`.`based` = 'payment' AND `z2gz`.`country_id` = 84 AND ( `z2gz`.`zone_id` = '0' OR `z2gz`.`zone_id` = '1280' ) ) OR ( `tr1`.`based` = 'shipping' AND `z2gz`.`country_id` = 84 AND ( `z2gz`.`zone_id` = '0' OR `z2gz`.`zone_id` = '1280' ) ) ) AND `tr2cg`.`customer_group_id` = 1 ) AS p_tax
FROM `oc_product` AS `p`
INNER JOIN `oc_product_description` AS `pd` ON `pd`.`product_id` = `p`.`product_id` AND `pd`.`language_id` = 2
INNER JOIN `oc_product_to_store` AS `p2s` ON `p2s`.`product_id` = `p`.`product_id` AND `p2s`.`store_id` = 0
WHERE `p`.`date_available` <= NOW() AND `p`.`status` = '1' AND IF( `p`.`quantity` > 0, 7, `p`.`stock_status_id` ) IN(7) AND `p`.`manufacturer_id` = 30 ) AS `tmp` ) AS `tmp`
/home/spor8371/public_html/catalog/model/module/mega_filter.php:1382
168 (0.100)
SELECT *
FROM oc_newstickers
/home/spor8371/public_html/catalog/view/theme/default/template/module/newsticker.tpl:2
169 (0.064)
SELECT *
FROM oc_manufacturer_to_layout
WHERE manufacturer_id = '30' AND store_id = '0'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_manufacturer.php:32
170 (0.064)
SELECT *
FROM oc_layout_route
WHERE 'product/manufacturer/info' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/spor8371/public_html/catalog/model/design/layout.php:4
171 (0.106)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_setting_extension.php:4
172 (0.096)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'tawkto_widget'
/home/spor8371/public_html/catalog/model/setting/setting.php:6
173 (0.056)
SELECT *
FROM oc_layout_route
WHERE 'product/manufacturer/info' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/spor8371/public_html/catalog/model/design/layout.php:4
174 (0.079)
SELECT *
FROM oc_company_details
WHERE status ='1'
/home/spor8371/public_html/catalog/model/richsnippets/richsnippets.php:6
175 (0.273)
SELECT *
FROM oc_information i
LEFT JOIN oc_information_description id ON (i.information_id = id.information_id)
LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE id.language_id = '2' AND i2s.store_id = '0' AND i.status = '1'
ORDER BY i.sort_order, LCASE(id.title) ASC
/home/spor8371/public_html/catalog/model/catalog/information.php:10
176 (0.077)
SELECT *
FROM oc_url_alias
WHERE `query` = 'information_id=4'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:154
177 (0.057)
SELECT *
FROM oc_url_alias
WHERE `query` = 'information_id=6'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:154
178 (0.056)
SELECT *
FROM oc_url_alias
WHERE `query` = 'information_id=3'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:154
179 (0.054)
SELECT *
FROM oc_url_alias
WHERE `query` = 'information_id=5'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:154
180 (0.056)
SELECT *
FROM oc_url_alias
WHERE `query` = 'information_id=7'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:154
181 (0.055)
SELECT *
FROM oc_url_alias
WHERE `query` = 'information_id=8'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:154
182 (0.054)
SELECT *
FROM oc_url_alias
WHERE `query` = 'information_id=9'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:154
183 (0.055)
SELECT *
FROM oc_url_alias
WHERE `query` = 'information_id=11'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:154
184 (0.710)
SELECT DISTINCT * ,p.descr2 , pd.name AS name, p.OC_series, p.image, m.name AS manufacturer, m.image AS man_img, (SELECT price
FROM oc_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 oc_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 oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_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 oc_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 oc_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 oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order, pd.sizechart_id
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '0' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=0 AND p2s.store_id = '0'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:16
185 (0.132)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '0' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' AND c.sort_order <> '-1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_category.php:10
186 (0.135)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '1' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' AND c.sort_order <> '-1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_category.php:10
187 (39.796)
SELECT COUNT(DISTINCT `product_id`) AS `total`
FROM(SELECT DISTINCT `p`.`product_id`
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE IF( `p`.`quantity` > 0, 7, `p`.`stock_status_id` ) IN(7) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=1 AND p2s.store_id = '0' AND cp.path_id = '8') AS `tmp`
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:656
188 (0.072)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
189 (0.075)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=8'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
190 (37.354)
SELECT COUNT(DISTINCT `product_id`) AS `total`
FROM(SELECT DISTINCT `p`.`product_id`
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE IF( `p`.`quantity` > 0, 7, `p`.`stock_status_id` ) IN(7) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=1 AND p2s.store_id = '0' AND cp.path_id = '9') AS `tmp`
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:656
191 (0.088)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
192 (0.088)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=9'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
193 (34.644)
SELECT COUNT(DISTINCT `product_id`) AS `total`
FROM(SELECT DISTINCT `p`.`product_id`
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE IF( `p`.`quantity` > 0, 7, `p`.`stock_status_id` ) IN(7) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=1 AND p2s.store_id = '0' AND cp.path_id = '10') AS `tmp`
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:656
194 (0.093)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
195 (0.074)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=10'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
196 (34.156)
SELECT COUNT(DISTINCT `product_id`) AS `total`
FROM(SELECT DISTINCT `p`.`product_id`
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE IF( `p`.`quantity` > 0, 7, `p`.`stock_status_id` ) IN(7) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=1 AND p2s.store_id = '0' AND cp.path_id = '11') AS `tmp`
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:656
197 (0.090)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
198 (0.077)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=11'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
199 (33.126)
SELECT COUNT(DISTINCT `product_id`) AS `total`
FROM(SELECT DISTINCT `p`.`product_id`
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE IF( `p`.`quantity` > 0, 7, `p`.`stock_status_id` ) IN(7) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=1 AND p2s.store_id = '0' AND cp.path_id = '161') AS `tmp`
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:656
200 (0.071)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
201 (0.058)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=161'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
202 (31.466)
SELECT COUNT(DISTINCT `product_id`) AS `total`
FROM(SELECT DISTINCT `p`.`product_id`
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE IF( `p`.`quantity` > 0, 7, `p`.`stock_status_id` ) IN(7) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=1 AND p2s.store_id = '0' AND cp.path_id = '95') AS `tmp`
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:656
203 (0.075)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
204 (0.065)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
205 (31.192)
SELECT COUNT(DISTINCT `product_id`) AS `total`
FROM(SELECT DISTINCT `p`.`product_id`
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE IF( `p`.`quantity` > 0, 7, `p`.`stock_status_id` ) IN(7) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=1 AND p2s.store_id = '0' AND cp.path_id = '97') AS `tmp`
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:656
206 (0.084)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
207 (0.073)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=97'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
208 (0.079)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
209 (0.076)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=1'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
210 (0.074)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '123' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' AND c.sort_order <> '-1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_category.php:10
211 (0.074)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=123'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
212 (0.073)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=123'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
213 (0.102)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '207' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' AND c.sort_order <> '-1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_category.php:10
214 (32.461)
SELECT COUNT(DISTINCT `product_id`) AS `total`
FROM(SELECT DISTINCT `p`.`product_id`
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE IF( `p`.`quantity` > 0, 7, `p`.`stock_status_id` ) IN(7) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=1 AND p2s.store_id = '0' AND cp.path_id = '168') AS `tmp`
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:656
215 (0.073)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=207'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
216 (0.060)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=168'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
217 (31.574)
SELECT COUNT(DISTINCT `product_id`) AS `total`
FROM(SELECT DISTINCT `p`.`product_id`
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE IF( `p`.`quantity` > 0, 7, `p`.`stock_status_id` ) IN(7) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=1 AND p2s.store_id = '0' AND cp.path_id = '170') AS `tmp`
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:656
218 (0.071)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=207'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
219 (0.059)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=170'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
220 (37.546)
SELECT COUNT(DISTINCT `product_id`) AS `total`
FROM(SELECT DISTINCT `p`.`product_id`
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE IF( `p`.`quantity` > 0, 7, `p`.`stock_status_id` ) IN(7) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=1 AND p2s.store_id = '0' AND cp.path_id = '171') AS `tmp`
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:656
221 (0.228)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=207'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
222 (0.139)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=171'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
223 (32.414)
SELECT COUNT(DISTINCT `product_id`) AS `total`
FROM(SELECT DISTINCT `p`.`product_id`
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE IF( `p`.`quantity` > 0, 7, `p`.`stock_status_id` ) IN(7) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=1 AND p2s.store_id = '0' AND cp.path_id = '169') AS `tmp`
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:656
224 (0.075)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=207'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
225 (0.067)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=169'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
226 (0.063)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=207'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
227 (0.060)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=207'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
228 (0.112)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '2' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' AND c.sort_order <> '-1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_category.php:10
229 (35.625)
SELECT COUNT(DISTINCT `product_id`) AS `total`
FROM(SELECT DISTINCT `p`.`product_id`
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE IF( `p`.`quantity` > 0, 7, `p`.`stock_status_id` ) IN(7) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=1 AND p2s.store_id = '0' AND cp.path_id = '12') AS `tmp`
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:656
230 (0.064)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=2'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
231 (0.055)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=12'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
232 (34.006)
SELECT COUNT(DISTINCT `product_id`) AS `total`
FROM(SELECT DISTINCT `p`.`product_id`
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE IF( `p`.`quantity` > 0, 7, `p`.`stock_status_id` ) IN(7) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=1 AND p2s.store_id = '0' AND cp.path_id = '13') AS `tmp`
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:656
233 (0.099)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=2'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
234 (0.077)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=13'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
235 (32.620)
SELECT COUNT(DISTINCT `product_id`) AS `total`
FROM(SELECT DISTINCT `p`.`product_id`
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE IF( `p`.`quantity` > 0, 7, `p`.`stock_status_id` ) IN(7) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=1 AND p2s.store_id = '0' AND cp.path_id = '14') AS `tmp`
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:656
236 (0.073)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=2'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
237 (0.063)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=14'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
238 (32.753)
SELECT COUNT(DISTINCT `product_id`) AS `total`
FROM(SELECT DISTINCT `p`.`product_id`
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE IF( `p`.`quantity` > 0, 7, `p`.`stock_status_id` ) IN(7) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=1 AND p2s.store_id = '0' AND cp.path_id = '15') AS `tmp`
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:656
239 (0.098)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=2'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
240 (0.075)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=15'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
241 (31.169)
SELECT COUNT(DISTINCT `product_id`) AS `total`
FROM(SELECT DISTINCT `p`.`product_id`
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE IF( `p`.`quantity` > 0, 7, `p`.`stock_status_id` ) IN(7) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=1 AND p2s.store_id = '0' AND cp.path_id = '215') AS `tmp`
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:656
242 (0.085)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=2'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
243 (0.074)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=215'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
244 (0.070)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=2'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
245 (0.076)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=2'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
246 (0.109)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '135' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' AND c.sort_order <> '-1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_category.php:10
247 (31.070)
SELECT COUNT(DISTINCT `product_id`) AS `total`
FROM(SELECT DISTINCT `p`.`product_id`
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE IF( `p`.`quantity` > 0, 7, `p`.`stock_status_id` ) IN(7) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=1 AND p2s.store_id = '0' AND cp.path_id = '127') AS `tmp`
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:656
248 (0.079)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=135'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
249 (0.071)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=127'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
250 (31.701)
SELECT COUNT(DISTINCT `product_id`) AS `total`
FROM(SELECT DISTINCT `p`.`product_id`
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE IF( `p`.`quantity` > 0, 7, `p`.`stock_status_id` ) IN(7) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=1 AND p2s.store_id = '0' AND cp.path_id = '190') AS `tmp`
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:656
251 (0.079)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=135'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
252 (0.078)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=190'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
253 (31.640)
SELECT COUNT(DISTINCT `product_id`) AS `total`
FROM(SELECT DISTINCT `p`.`product_id`
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE IF( `p`.`quantity` > 0, 7, `p`.`stock_status_id` ) IN(7) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=1 AND p2s.store_id = '0' AND cp.path_id = '126') AS `tmp`
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:656
254 (0.077)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=135'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
255 (0.070)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=126'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
256 (30.865)
SELECT COUNT(DISTINCT `product_id`) AS `total`
FROM(SELECT DISTINCT `p`.`product_id`
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE IF( `p`.`quantity` > 0, 7, `p`.`stock_status_id` ) IN(7) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=1 AND p2s.store_id = '0' AND cp.path_id = '189') AS `tmp`
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:656
257 (0.073)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=135'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
258 (0.073)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=189'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
259 (30.901)
SELECT COUNT(DISTINCT `product_id`) AS `total`
FROM(SELECT DISTINCT `p`.`product_id`
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE IF( `p`.`quantity` > 0, 7, `p`.`stock_status_id` ) IN(7) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=1 AND p2s.store_id = '0' AND cp.path_id = '181') AS `tmp`
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:656
260 (0.083)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=135'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
261 (0.071)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=181'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
262 (0.068)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=135'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
263 (0.073)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=135'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
264 (0.098)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '3' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' AND c.sort_order <> '-1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_category.php:10
265 (32.377)
SELECT COUNT(DISTINCT `product_id`) AS `total`
FROM(SELECT DISTINCT `p`.`product_id`
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE IF( `p`.`quantity` > 0, 7, `p`.`stock_status_id` ) IN(7) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=1 AND p2s.store_id = '0' AND cp.path_id = '147') AS `tmp`
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:656
266 (0.132)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=3'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
267 (0.117)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=147'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
268 (47.452)
SELECT COUNT(DISTINCT `product_id`) AS `total`
FROM(SELECT DISTINCT `p`.`product_id`
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE IF( `p`.`quantity` > 0, 7, `p`.`stock_status_id` ) IN(7) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=1 AND p2s.store_id = '0' AND cp.path_id = '150') AS `tmp`
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:656
269 (0.095)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=3'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
270 (0.095)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=150'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
271 (48.112)
SELECT COUNT(DISTINCT `product_id`) AS `total`
FROM(SELECT DISTINCT `p`.`product_id`
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE IF( `p`.`quantity` > 0, 7, `p`.`stock_status_id` ) IN(7) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=1 AND p2s.store_id = '0' AND cp.path_id = '187') AS `tmp`
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:656
272 (0.087)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=3'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
273 (0.074)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=187'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
274 (0.067)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=3'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
275 (0.067)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=3'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
276 (0.165)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '4' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' AND c.sort_order <> '-1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_category.php:10
277 (38.313)
SELECT COUNT(DISTINCT `product_id`) AS `total`
FROM(SELECT DISTINCT `p`.`product_id`
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE IF( `p`.`quantity` > 0, 7, `p`.`stock_status_id` ) IN(7) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=1 AND p2s.store_id = '0' AND cp.path_id = '85') AS `tmp`
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:656
278 (0.083)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=4'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
279 (0.070)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=85'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
280 (34.648)
SELECT COUNT(DISTINCT `product_id`) AS `total`
FROM(SELECT DISTINCT `p`.`product_id`
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE IF( `p`.`quantity` > 0, 7, `p`.`stock_status_id` ) IN(7) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=1 AND p2s.store_id = '0' AND cp.path_id = '213') AS `tmp`
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:656
281 (0.095)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=4'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
282 (0.089)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=213'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
283 (42.995)
SELECT COUNT(DISTINCT `product_id`) AS `total`
FROM(SELECT DISTINCT `p`.`product_id`
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE IF( `p`.`quantity` > 0, 7, `p`.`stock_status_id` ) IN(7) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=1 AND p2s.store_id = '0' AND cp.path_id = '212') AS `tmp`
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:656
284 (0.080)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=4'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
285 (0.072)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=212'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
286 (31.253)
SELECT COUNT(DISTINCT `product_id`) AS `total`
FROM(SELECT DISTINCT `p`.`product_id`
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE IF( `p`.`quantity` > 0, 7, `p`.`stock_status_id` ) IN(7) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=1 AND p2s.store_id = '0' AND cp.path_id = '936') AS `tmp`
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:656
287 (0.084)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=4'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
288 (0.065)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=936'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
289 (32.307)
SELECT COUNT(DISTINCT `product_id`) AS `total`
FROM(SELECT DISTINCT `p`.`product_id`
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE IF( `p`.`quantity` > 0, 7, `p`.`stock_status_id` ) IN(7) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=1 AND p2s.store_id = '0' AND cp.path_id = '87') AS `tmp`
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:656
290 (0.084)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=4'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
291 (0.098)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=87'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
292 (34.587)
SELECT COUNT(DISTINCT `product_id`) AS `total`
FROM(SELECT DISTINCT `p`.`product_id`
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE IF( `p`.`quantity` > 0, 7, `p`.`stock_status_id` ) IN(7) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=1 AND p2s.store_id = '0' AND cp.path_id = '83') AS `tmp`
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:656
293 (0.075)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=4'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
294 (0.069)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=83'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
295 (33.057)
SELECT COUNT(DISTINCT `product_id`) AS `total`
FROM(SELECT DISTINCT `p`.`product_id`
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE IF( `p`.`quantity` > 0, 7, `p`.`stock_status_id` ) IN(7) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=1 AND p2s.store_id = '0' AND cp.path_id = '84') AS `tmp`
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:656
296 (0.076)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=4'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
297 (0.083)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=84'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
298 (44.718)
SELECT COUNT(DISTINCT `product_id`) AS `total`
FROM(SELECT DISTINCT `p`.`product_id`
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE IF( `p`.`quantity` > 0, 7, `p`.`stock_status_id` ) IN(7) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=1 AND p2s.store_id = '0' AND cp.path_id = '114') AS `tmp`
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:656
299 (0.076)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=4'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
300 (0.074)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=114'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
301 (45.063)
SELECT COUNT(DISTINCT `product_id`) AS `total`
FROM(SELECT DISTINCT `p`.`product_id`
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE IF( `p`.`quantity` > 0, 7, `p`.`stock_status_id` ) IN(7) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=1 AND p2s.store_id = '0' AND cp.path_id = '16') AS `tmp`
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:656
302 (0.084)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=4'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
303 (0.072)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=16'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
304 (44.085)
SELECT COUNT(DISTINCT `product_id`) AS `total`
FROM(SELECT DISTINCT `p`.`product_id`
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE IF( `p`.`quantity` > 0, 7, `p`.`stock_status_id` ) IN(7) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=1 AND p2s.store_id = '0' AND cp.path_id = '118') AS `tmp`
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:656
305 (0.082)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=4'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
306 (0.079)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=118'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
307 (37.064)
SELECT COUNT(DISTINCT `product_id`) AS `total`
FROM(SELECT DISTINCT `p`.`product_id`
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE IF( `p`.`quantity` > 0, 7, `p`.`stock_status_id` ) IN(7) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=1 AND p2s.store_id = '0' AND cp.path_id = '146') AS `tmp`
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:656
308 (0.090)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=4'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
309 (0.071)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=146'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
310 (35.129)
SELECT COUNT(DISTINCT `product_id`) AS `total`
FROM(SELECT DISTINCT `p`.`product_id`
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE IF( `p`.`quantity` > 0, 7, `p`.`stock_status_id` ) IN(7) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=1 AND p2s.store_id = '0' AND cp.path_id = '214') AS `tmp`
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:656
311 (0.077)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=4'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
312 (0.084)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=214'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
313 (37.984)
SELECT COUNT(DISTINCT `product_id`) AS `total`
FROM(SELECT DISTINCT `p`.`product_id`
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE IF( `p`.`quantity` > 0, 7, `p`.`stock_status_id` ) IN(7) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=1 AND p2s.store_id = '0' AND cp.path_id = '90') AS `tmp`
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:656
314 (0.080)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=4'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
315 (0.072)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=90'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
316 (49.128)
SELECT COUNT(DISTINCT `product_id`) AS `total`
FROM(SELECT DISTINCT `p`.`product_id`
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE IF( `p`.`quantity` > 0, 7, `p`.`stock_status_id` ) IN(7) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=1 AND p2s.store_id = '0' AND cp.path_id = '50') AS `tmp`
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:656
317 (0.082)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=4'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
318 (0.075)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=50'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
319 (52.203)
SELECT COUNT(DISTINCT `product_id`) AS `total`
FROM(SELECT DISTINCT `p`.`product_id`
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE IF( `p`.`quantity` > 0, 7, `p`.`stock_status_id` ) IN(7) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=1 AND p2s.store_id = '0' AND cp.path_id = '66') AS `tmp`
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:656
320 (0.099)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=4'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
321 (0.083)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=66'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
322 (81.421)
SELECT COUNT(DISTINCT `product_id`) AS `total`
FROM(SELECT DISTINCT `p`.`product_id`
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE IF( `p`.`quantity` > 0, 7, `p`.`stock_status_id` ) IN(7) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() and p.quantity>=1 AND p2s.store_id = '0' AND cp.path_id = '65') AS `tmp`
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:656
323 (0.097)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=4'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
324 (0.088)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=65'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
325 (0.087)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=4'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
326 (0.089)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=4'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
327 (0.105)
SELECT *
FROM oc_url_alias
WHERE `query` = 'manufacturer_id=30'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:154
328 (3.323)
SELECT *
FROM oc_url_alias
WHERE `query` = 'manufacturer_id=30'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:154
329 (4.015)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_setting_extension.php:4
330 (5.944)
SELECT SUM(amount) AS total
FROM oc_customer_transaction
WHERE customer_id = '0'
/home/spor8371/public_html/vqmod/vqcache/vq2-system_library_customer.php:260
331 (1.060)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '8' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' AND c.sort_order <> '-1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_category.php:10
332 (0.485)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '9' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' AND c.sort_order <> '-1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_category.php:10
333 (1.150)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '10' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' AND c.sort_order <> '-1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_category.php:10
334 (2.016)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '11' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' AND c.sort_order <> '-1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_category.php:10
335 (0.150)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '161' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' AND c.sort_order <> '-1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_category.php:10
336 (1.797)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '95' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' AND c.sort_order <> '-1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_category.php:10
337 (0.086)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '97' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' AND c.sort_order <> '-1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_category.php:10
338 (0.081)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '168' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' AND c.sort_order <> '-1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_category.php:10
339 (0.072)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '170' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' AND c.sort_order <> '-1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_category.php:10
340 (0.071)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '171' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' AND c.sort_order <> '-1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_category.php:10
341 (0.071)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '169' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' AND c.sort_order <> '-1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_category.php:10
342 (0.123)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '12' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' AND c.sort_order <> '-1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_category.php:10
343 (0.077)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=2'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
344 (0.074)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=12'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
345 (0.069)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=71'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
346 (0.150)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=2'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
347 (0.087)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=12'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
348 (0.316)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=21'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
349 (6.120)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=2'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
350 (0.091)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=12'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
351 (0.076)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=59'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
352 (0.080)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=2'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
353 (0.082)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=12'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
354 (0.074)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=38'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
355 (0.073)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=2'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
356 (0.076)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=12'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
357 (0.083)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=165'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
358 (0.077)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=2'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
359 (0.077)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=12'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
360 (0.076)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=79'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
361 (0.079)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=2'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
362 (0.067)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=12'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
363 (0.063)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=55'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
364 (0.064)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=2'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
365 (0.066)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=12'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
366 (0.063)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=141'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
367 (0.120)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '13' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' AND c.sort_order <> '-1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_category.php:10
368 (0.070)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=2'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
369 (0.070)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=13'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
370 (0.309)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=72'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
371 (0.829)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=2'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
372 (0.086)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=13'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
373 (0.084)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=22'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
374 (0.076)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=2'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
375 (0.068)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=13'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
376 (0.070)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=116'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
377 (0.079)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=2'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
378 (0.080)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=13'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
379 (0.079)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=39'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
380 (0.077)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=2'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
381 (0.077)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=13'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
382 (0.068)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=60'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
383 (0.063)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=2'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
384 (0.278)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=13'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
385 (0.086)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=128'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
386 (0.091)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=2'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
387 (0.087)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=13'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
388 (0.076)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=80'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
389 (0.075)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=2'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
390 (0.082)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=13'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
391 (0.084)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=145'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
392 (0.127)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '14' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' AND c.sort_order <> '-1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_category.php:10
393 (0.067)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=2'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
394 (0.067)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=14'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
395 (0.068)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=53'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
396 (0.072)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=2'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
397 (0.070)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=14'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
398 (0.067)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=23'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
399 (0.062)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=2'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
400 (0.066)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=14'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
401 (0.068)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=57'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
402 (0.101)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=2'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
403 (0.065)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=14'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
404 (0.065)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=40'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
405 (0.090)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=2'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
406 (0.066)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=14'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
407 (0.074)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=61'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
408 (0.066)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=2'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
409 (0.074)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=14'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
410 (0.072)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=155'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
411 (0.067)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=2'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
412 (0.066)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=14'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
413 (0.067)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=81'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
414 (0.066)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=2'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
415 (0.066)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=14'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
416 (0.067)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=154'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
417 (0.125)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '15' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' AND c.sort_order <> '-1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_category.php:10
418 (0.068)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=2'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
419 (0.069)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=15'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
420 (0.066)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=54'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
421 (0.066)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=2'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
422 (0.068)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=15'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
423 (0.064)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=24'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
424 (0.066)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=2'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
425 (0.069)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=15'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
426 (0.069)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=131'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
427 (0.066)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=2'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
428 (0.069)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=15'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
429 (0.065)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=41'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
430 (0.069)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=2'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
431 (0.069)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=15'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
432 (0.067)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=62'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
433 (0.066)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=2'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
434 (0.070)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=15'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
435 (0.069)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=132'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
436 (0.080)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=2'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
437 (0.074)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=15'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
438 (0.069)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=82'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
439 (0.070)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=2'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
440 (0.076)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=15'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
441 (0.077)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=160'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
442 (0.119)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '215' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' AND c.sort_order <> '-1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_category.php:10
443 (0.076)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=2'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
444 (0.067)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=215'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
445 (0.064)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=30'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
446 (0.073)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=2'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
447 (0.066)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=215'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
448 (0.064)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=34'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
449 (0.067)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=2'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
450 (0.068)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=215'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
451 (0.064)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=134'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
452 (0.064)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=2'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
453 (0.069)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=215'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
454 (0.066)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=206'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
455 (0.072)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '127' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' AND c.sort_order <> '-1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_category.php:10
456 (0.073)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '190' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' AND c.sort_order <> '-1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_category.php:10
457 (0.069)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '126' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' AND c.sort_order <> '-1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_category.php:10
458 (0.069)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '189' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' AND c.sort_order <> '-1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_category.php:10
459 (0.069)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '181' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' AND c.sort_order <> '-1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_category.php:10
460 (0.151)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '147' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' AND c.sort_order <> '-1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_category.php:10
461 (0.070)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=3'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
462 (0.071)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=147'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
463 (0.064)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=152'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
464 (0.064)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=3'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
465 (0.069)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=147'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
466 (0.065)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=159'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
467 (0.063)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=3'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
468 (0.068)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=147'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
469 (0.064)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=176'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
470 (0.064)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=3'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
471 (0.067)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=147'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
472 (0.065)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=144'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
473 (0.064)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=3'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
474 (0.070)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=147'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
475 (0.069)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=178'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
476 (0.065)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=3'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
477 (0.070)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=147'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
478 (0.066)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=142'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
479 (0.065)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=3'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
480 (0.069)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=147'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
481 (0.067)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=143'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
482 (0.084)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=3'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
483 (0.074)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=147'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
484 (0.077)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=115'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
485 (0.072)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=3'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
486 (8.325)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=147'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
487 (0.154)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=136'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
488 (0.150)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=3'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
489 (0.152)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=147'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
490 (0.139)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=6'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
491 (0.140)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=3'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
492 (0.150)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=147'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
493 (0.156)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=63'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
494 (0.149)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=3'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
495 (0.153)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=147'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
496 (0.150)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=64'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
497 (0.149)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '150' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' AND c.sort_order <> '-1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_category.php:10
498 (0.084)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=3'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
499 (0.074)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=150'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
500 (0.073)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=163'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
501 (0.106)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=3'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
502 (0.115)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=150'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
503 (0.077)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=204'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
504 (0.112)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=3'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
505 (0.121)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=150'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
506 (0.076)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=180'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
507 (0.071)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=3'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
508 (0.090)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=150'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
509 (0.073)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=205'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
510 (0.071)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=3'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
511 (0.076)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=150'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
512 (0.079)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=164'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
513 (0.084)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=3'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
514 (0.252)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=150'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
515 (0.146)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=162'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
516 (0.112)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=3'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
517 (0.079)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=150'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
518 (0.073)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=158'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
519 (0.072)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=3'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
520 (0.085)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=150'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
521 (0.074)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=151'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
522 (0.073)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=3'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
523 (0.079)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=150'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
524 (0.078)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=179'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
525 (0.071)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=3'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
526 (0.077)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=150'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
527 (0.072)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=17'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
528 (0.169)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '187' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' AND c.sort_order <> '-1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_category.php:10
529 (0.074)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=3'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
530 (0.078)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=187'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
531 (0.074)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=197'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
532 (0.073)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=3'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
533 (0.074)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=187'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
534 (0.072)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=199'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
535 (0.072)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=3'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
536 (0.079)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=187'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
537 (0.079)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=188'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
538 (0.074)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=3'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
539 (0.080)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=187'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
540 (0.115)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=194'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
541 (0.075)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=3'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
542 (0.089)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=187'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
543 (0.083)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=196'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
544 (0.072)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=3'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
545 (0.079)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=187'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
546 (0.073)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=195'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
547 (0.064)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=3'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
548 (0.069)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=187'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
549 (0.065)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=200'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
550 (0.064)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=3'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
551 (0.077)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=187'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
552 (0.073)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=193'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
553 (0.072)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=3'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
554 (0.072)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=187'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
555 (0.072)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=192'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
556 (0.071)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=3'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
557 (0.072)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=187'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
558 (0.070)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=203'
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php:165
559 (0.080)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '85' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' AND c.sort_order <> '-1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_category.php:10
560 (0.077)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '213' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' AND c.sort_order <> '-1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_category.php:10
561 (0.076)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '212' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' AND c.sort_order <> '-1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_category.php:10
562 (0.126)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '936' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' AND c.sort_order <> '-1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_category.php:10
563 (0.079)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '87' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' AND c.sort_order <> '-1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_category.php:10
564 (0.077)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '83' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' AND c.sort_order <> '-1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_category.php:10
565 (0.076)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '84' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' AND c.sort_order <> '-1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_category.php:10
566 (0.077)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '114' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' AND c.sort_order <> '-1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_category.php:10
567 (0.077)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '16' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' AND c.sort_order <> '-1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_category.php:10
568 (0.076)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '118' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' AND c.sort_order <> '-1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_category.php:10
569 (0.076)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '146' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' AND c.sort_order <> '-1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_category.php:10
570 (0.078)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '214' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' AND c.sort_order <> '-1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_category.php:10
571 (0.077)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '90' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' AND c.sort_order <> '-1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_category.php:10
572 (0.076)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '50' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' AND c.sort_order <> '-1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_category.php:10
573 (0.075)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '66' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' AND c.sort_order <> '-1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_category.php:10
574 (0.080)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '65' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' AND c.sort_order <> '-1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/spor8371/public_html/vqmod/vqcache/vq2-catalog_model_catalog_category.php:10