Cubos Rubik Moyu Classroom Wind Mirror Plata

$99
Marcas ShengShou
Código de producto: MoyuWindMirrorPlata
Puntos de recompensa: 25
Disponibilidad: En stock

Revisión

La versión de un mirror de una de las mas populares modificaciones de 3x3, el wind Firemirror.Cubos Rubik Moyu Classroom Wind Mir...

La versión de un mirror de una de las mas populares modificaciones de 3x3, el wind Firemirror.

Cubos Rubik Moyu Classroom Wind Mirror Plata

Contactanos por disponibilidad.

Local: 01(33) 36147823

WhatsApp: 3317843484

Correo Electrónico: CubosCubik@gmail.com

Facebook:  https://www.facebook.com/cuboscubik

Twitter:  https://twitter.com/CubosCubik

Escribe una reseña

Nota: ¡HTML no está traducido!
    Malo           Bueno
Queries: 509, Total time: 353.285 ms [By time] [By id] [By file]
1 (0.384)
SELECT `data`
FROM `session`
WHERE session_id = 'a9988de15f1890478709d23790' AND expire > 1526885323
/var/www/cuboscubik.com/public_html/system/library/session/db.php:21
2 (0.223)
SELECT *
FROM extension
WHERE `type` = 'openbay'
/var/www/cuboscubik.com/public_html/system/library/openbay.php:61
3 (0.176)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '0' AND (route = 'engb' OR route = '')
/var/www/cuboscubik.com/public_html/catalog/model/design/translation.php:6
4 (0.160)
SELECT *
FROM extension
WHERE `type` = 'openbay'
/var/www/cuboscubik.com/public_html/system/library/openbay.php:61
5 (0.156)
SELECT `data`
FROM `session`
WHERE session_id = 'e8aab63ec966d5eea974b6b9cc' AND expire > 1526885323
/var/www/cuboscubik.com/public_html/system/library/session/db.php:21
6 (0.237)
SELECT *
FROM store
WHERE REPLACE(`url`, 'www.', '') = 'http://cuboscubik.com/'
/var/www/cuboscubik.com/public_html/catalog/controller/startup/startup.php:8
7 (1.861)
SELECT *
FROM `setting`
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC
/var/www/cuboscubik.com/public_html/catalog/controller/startup/startup.php:25
8 (0.181)
SELECT *
FROM language
WHERE status = '1'
ORDER BY sort_order, name
/var/www/cuboscubik.com/public_html/catalog/model/localisation/language.php:15
9 (0.212)
SELECT *
FROM currency
/var/www/cuboscubik.com/public_html/system/library/cart/currency.php:10
10 (0.917)
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '138' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2158')
ORDER BY tr1.priority ASC
/var/www/cuboscubik.com/public_html/system/library/cart/tax.php:44
11 (0.416)
SELECT *
FROM weight_class wc
LEFT JOIN weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id)
WHERE wcd.language_id = '4'
/var/www/cuboscubik.com/public_html/system/library/cart/weight.php:10
12 (0.343)
SELECT *
FROM length_class mc
LEFT JOIN length_class_description mcd ON (mc.length_class_id = mcd.length_class_id)
WHERE mcd.language_id = '4'
/var/www/cuboscubik.com/public_html/system/library/cart/length.php:10
13 (1.084)
DELETE
FROM cart
WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR)
/var/www/cuboscubik.com/public_html/system/library/cart/cart.php:15
14 (0.155)
SELECT *
FROM extension
WHERE `type` = 'openbay'
/var/www/cuboscubik.com/public_html/system/library/openbay.php:61
15 (0.398)
SELECT *
FROM `event`
WHERE `trigger` LIKE 'catalog/%' AND status = '1'
ORDER BY `sort_order` ASC
/var/www/cuboscubik.com/public_html/catalog/model/setting/event.php:4
16 (0.354)
SELECT *
FROM seo_url
WHERE keyword = 'ShengShou-Cubos-Rubik' AND store_id = '0'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:19
17 (0.220)
SELECT *
FROM seo_url
WHERE keyword = 'Moyu-Wind-Mirror-Plata' AND store_id = '0'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:19
18 (0.737)
SHOW TABLES LIKE 'soconfig'
/var/www/cuboscubik.com/public_html/admin/view/template/extension/soconfig/class/soconfig_settings.php:25
19 (0.236)
select *
from soconfig
where store_id='0'
/var/www/cuboscubik.com/public_html/admin/view/template/extension/soconfig/class/soconfig_settings.php:28
20 (0.586)
SHOW TABLES LIKE 'soconfig'
/var/www/cuboscubik.com/public_html/admin/view/template/extension/soconfig/class/soconfig_settings.php:25
21 (0.151)
select *
from soconfig
where store_id='0'
/var/www/cuboscubik.com/public_html/admin/view/template/extension/soconfig/class/soconfig_settings.php:28
22 (0.161)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '4' AND (route = 'extension/soconfig/soconfig' OR route = 'es-MX')
/var/www/cuboscubik.com/public_html/catalog/model/design/translation.php:6
23 (0.111)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '4' AND (route = 'product/product' OR route = 'es-MX')
/var/www/cuboscubik.com/public_html/catalog/model/design/translation.php:6
24 (0.336)
SELECT *
FROM manufacturer m
LEFT JOIN manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '7' AND m2s.store_id = '0'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/manufacturer.php:4
25 (0.217)
SELECT *
FROM seo_url
WHERE `query` = 'manufacturer_id=7' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
26 (1.717)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '4') AS stock_status, (SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '4') AS weight_class, (SELECT lcd.unit
FROM length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '4') AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1099' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:8
27 (0.210)
SELECT *
FROM seo_url
WHERE `query` = 'manufacturer_id=7' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
28 (0.226)
SELECT *
FROM seo_url
WHERE `query` = 'product_id=1099' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
29 (0.216)
SELECT *
FROM seo_url
WHERE `query` = 'product_id=1099' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
30 (0.181)
SELECT *
FROM seo_url
WHERE `query` = 'manufacturer_id=7' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
31 (0.115)
SELECT date_end, date_start
FROM product_special
WHERE product_id='1099' AND customer_group_id = '1'
/var/www/cuboscubik.com/public_html/catalog/model/extension/soconfig/general.php:5
32 (0.265)
SELECT *
FROM product_image
WHERE product_id = '1099'
ORDER BY sort_order ASC
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:383
33 (0.205)
SELECT *
FROM product_discount
WHERE product_id = '1099' AND customer_group_id = '1' AND quantity > 1 AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY quantity ASC, priority ASC, price ASC
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:377
34 (0.729)
SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
LEFT JOIN option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '1099' AND od.language_id = '4'
ORDER BY o.sort_order
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:340
35 (0.249)
SELECT *
FROM seo_url
WHERE `query` = 'product_id=1099' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
36 (0.436)
SELECT ag.attribute_group_id, agd.name
FROM product_attribute pa
LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '1099' AND agd.language_id = '4' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:312
37 (1.007)
SELECT *
FROM product_related pr
LEFT JOIN product p ON (pr.related_id = p.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pr.product_id = '1099' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:391
38 (1.134)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '4') AS stock_status, (SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '4') AS weight_class, (SELECT lcd.unit
FROM length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '4') AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '69' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:8
39 (1.016)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '4') AS stock_status, (SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '4') AS weight_class, (SELECT lcd.unit
FROM length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '4') AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '330' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:8
40 (1.078)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '4') AS stock_status, (SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '4') AS weight_class, (SELECT lcd.unit
FROM length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '4') AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '341' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:8
41 (1.063)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '4') AS stock_status, (SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '4') AS weight_class, (SELECT lcd.unit
FROM length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '4') AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '591' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:8
42 (1.082)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '4') AS stock_status, (SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '4') AS weight_class, (SELECT lcd.unit
FROM length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '4') AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '615' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:8
43 (1.042)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '4') AS stock_status, (SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '4') AS weight_class, (SELECT lcd.unit
FROM length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '4') AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1008' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:8
44 (1.054)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '4') AS stock_status, (SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '4') AS weight_class, (SELECT lcd.unit
FROM length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '4') AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1029' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:8
45 (1.075)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '4') AS stock_status, (SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '4') AS weight_class, (SELECT lcd.unit
FROM length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '4') AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1083' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:8
46 (1.050)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '4') AS stock_status, (SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '4') AS weight_class, (SELECT lcd.unit
FROM length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '4') AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1097' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:8
47 (1.057)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '4') AS stock_status, (SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '4') AS weight_class, (SELECT lcd.unit
FROM length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '4') AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1098' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:8
48 (0.997)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '4') AS stock_status, (SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '4') AS weight_class, (SELECT lcd.unit
FROM length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '4') AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1099' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:8
49 (1.035)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '4') AS stock_status, (SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '4') AS weight_class, (SELECT lcd.unit
FROM length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '4') AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1100' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:8
50 (1.030)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '4') AS stock_status, (SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '4') AS weight_class, (SELECT lcd.unit
FROM length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '4') AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1113' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:8
51 (1.029)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '4') AS stock_status, (SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '4') AS weight_class, (SELECT lcd.unit
FROM length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '4') AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1114' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:8
52 (1.038)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '4') AS stock_status, (SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '4') AS weight_class, (SELECT lcd.unit
FROM length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '4') AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1115' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:8
53 (1.035)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '4') AS stock_status, (SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '4') AS weight_class, (SELECT lcd.unit
FROM length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '4') AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1116' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:8
54 (1.029)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '4') AS stock_status, (SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '4') AS weight_class, (SELECT lcd.unit
FROM length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '4') AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1117' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:8
55 (1.042)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '4') AS stock_status, (SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '4') AS weight_class, (SELECT lcd.unit
FROM length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '4') AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1118' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:8
56 (1.037)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '4') AS stock_status, (SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '4') AS weight_class, (SELECT lcd.unit
FROM length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '4') AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1154' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:8
57 (0.979)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '4') AS stock_status, (SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '4') AS weight_class, (SELECT lcd.unit
FROM length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '4') AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1189' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:8
58 (1.004)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '4') AS stock_status, (SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '4') AS weight_class, (SELECT lcd.unit
FROM length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '4') AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1190' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:8
59 (1.035)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '4') AS stock_status, (SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '4') AS weight_class, (SELECT lcd.unit
FROM length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '4') AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1192' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:8
60 (1.033)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '4') AS stock_status, (SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '4') AS weight_class, (SELECT lcd.unit
FROM length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '4') AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1208' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:8
61 (1.035)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '4') AS stock_status, (SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '4') AS weight_class, (SELECT lcd.unit
FROM length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '4') AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1265' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:8
62 (1.035)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '4') AS stock_status, (SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '4') AS weight_class, (SELECT lcd.unit
FROM length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '4') AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1278' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:8
63 (1.003)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '4') AS stock_status, (SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '4') AS weight_class, (SELECT lcd.unit
FROM length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '4') AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1280' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:8
64 (0.990)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '4') AS stock_status, (SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '4') AS weight_class, (SELECT lcd.unit
FROM length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '4') AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1281' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:8
65 (1.009)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '4') AS stock_status, (SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '4') AS weight_class, (SELECT lcd.unit
FROM length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '4') AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1285' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:8
66 (1.004)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '4') AS stock_status, (SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '4') AS weight_class, (SELECT lcd.unit
FROM length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '4') AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1286' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:8
67 (0.994)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '4') AS stock_status, (SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '4') AS weight_class, (SELECT lcd.unit
FROM length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '4') AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1288' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:8
68 (1.038)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '4') AS stock_status, (SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '4') AS weight_class, (SELECT lcd.unit
FROM length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '4') AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1289' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:8
69 (1.037)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '4') AS stock_status, (SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '4') AS weight_class, (SELECT lcd.unit
FROM length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '4') AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1290' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:8
70 (0.140)
SELECT date_end, date_start
FROM product_special
WHERE product_id='69' AND customer_group_id = '1'
/var/www/cuboscubik.com/public_html/catalog/model/extension/soconfig/general.php:5
71 (0.224)
SELECT *
FROM seo_url
WHERE `query` = 'product_id=69' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
72 (0.118)
SELECT date_end, date_start
FROM product_special
WHERE product_id='330' AND customer_group_id = '1'
/var/www/cuboscubik.com/public_html/catalog/model/extension/soconfig/general.php:5
73 (0.234)
SELECT *
FROM seo_url
WHERE `query` = 'product_id=330' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
74 (0.118)
SELECT date_end, date_start
FROM product_special
WHERE product_id='341' AND customer_group_id = '1'
/var/www/cuboscubik.com/public_html/catalog/model/extension/soconfig/general.php:5
75 (0.232)
SELECT *
FROM seo_url
WHERE `query` = 'product_id=341' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
76 (0.130)
SELECT date_end, date_start
FROM product_special
WHERE product_id='591' AND customer_group_id = '1'
/var/www/cuboscubik.com/public_html/catalog/model/extension/soconfig/general.php:5
77 (0.237)
SELECT *
FROM seo_url
WHERE `query` = 'product_id=591' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
78 (0.115)
SELECT date_end, date_start
FROM product_special
WHERE product_id='615' AND customer_group_id = '1'
/var/www/cuboscubik.com/public_html/catalog/model/extension/soconfig/general.php:5
79 (0.160)
SELECT *
FROM seo_url
WHERE `query` = 'product_id=615' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
80 (0.114)
SELECT date_end, date_start
FROM product_special
WHERE product_id='1008' AND customer_group_id = '1'
/var/www/cuboscubik.com/public_html/catalog/model/extension/soconfig/general.php:5
81 (0.175)
SELECT *
FROM seo_url
WHERE `query` = 'product_id=1008' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
82 (0.108)
SELECT date_end, date_start
FROM product_special
WHERE product_id='1029' AND customer_group_id = '1'
/var/www/cuboscubik.com/public_html/catalog/model/extension/soconfig/general.php:5
83 (0.183)
SELECT *
FROM seo_url
WHERE `query` = 'product_id=1029' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
84 (0.111)
SELECT date_end, date_start
FROM product_special
WHERE product_id='1083' AND customer_group_id = '1'
/var/www/cuboscubik.com/public_html/catalog/model/extension/soconfig/general.php:5
85 (0.212)
SELECT *
FROM seo_url
WHERE `query` = 'product_id=1083' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
86 (0.107)
SELECT date_end, date_start
FROM product_special
WHERE product_id='1097' AND customer_group_id = '1'
/var/www/cuboscubik.com/public_html/catalog/model/extension/soconfig/general.php:5
87 (0.216)
SELECT *
FROM seo_url
WHERE `query` = 'product_id=1097' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
88 (0.106)
SELECT date_end, date_start
FROM product_special
WHERE product_id='1098' AND customer_group_id = '1'
/var/www/cuboscubik.com/public_html/catalog/model/extension/soconfig/general.php:5
89 (0.219)
SELECT *
FROM seo_url
WHERE `query` = 'product_id=1098' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
90 (0.113)
SELECT date_end, date_start
FROM product_special
WHERE product_id='1099' AND customer_group_id = '1'
/var/www/cuboscubik.com/public_html/catalog/model/extension/soconfig/general.php:5
91 (0.226)
SELECT *
FROM seo_url
WHERE `query` = 'product_id=1099' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
92 (0.108)
SELECT date_end, date_start
FROM product_special
WHERE product_id='1100' AND customer_group_id = '1'
/var/www/cuboscubik.com/public_html/catalog/model/extension/soconfig/general.php:5
93 (0.212)
SELECT *
FROM seo_url
WHERE `query` = 'product_id=1100' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
94 (0.106)
SELECT date_end, date_start
FROM product_special
WHERE product_id='1113' AND customer_group_id = '1'
/var/www/cuboscubik.com/public_html/catalog/model/extension/soconfig/general.php:5
95 (0.224)
SELECT *
FROM seo_url
WHERE `query` = 'product_id=1113' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
96 (0.108)
SELECT date_end, date_start
FROM product_special
WHERE product_id='1114' AND customer_group_id = '1'
/var/www/cuboscubik.com/public_html/catalog/model/extension/soconfig/general.php:5
97 (0.219)
SELECT *
FROM seo_url
WHERE `query` = 'product_id=1114' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
98 (0.111)
SELECT date_end, date_start
FROM product_special
WHERE product_id='1115' AND customer_group_id = '1'
/var/www/cuboscubik.com/public_html/catalog/model/extension/soconfig/general.php:5
99 (0.219)
SELECT *
FROM seo_url
WHERE `query` = 'product_id=1115' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
100 (0.113)
SELECT date_end, date_start
FROM product_special
WHERE product_id='1116' AND customer_group_id = '1'
/var/www/cuboscubik.com/public_html/catalog/model/extension/soconfig/general.php:5
101 (0.220)
SELECT *
FROM seo_url
WHERE `query` = 'product_id=1116' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
102 (0.109)
SELECT date_end, date_start
FROM product_special
WHERE product_id='1117' AND customer_group_id = '1'
/var/www/cuboscubik.com/public_html/catalog/model/extension/soconfig/general.php:5
103 (0.222)
SELECT *
FROM seo_url
WHERE `query` = 'product_id=1117' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
104 (0.109)
SELECT date_end, date_start
FROM product_special
WHERE product_id='1118' AND customer_group_id = '1'
/var/www/cuboscubik.com/public_html/catalog/model/extension/soconfig/general.php:5
105 (0.234)
SELECT *
FROM seo_url
WHERE `query` = 'product_id=1118' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
106 (0.107)
SELECT date_end, date_start
FROM product_special
WHERE product_id='1154' AND customer_group_id = '1'
/var/www/cuboscubik.com/public_html/catalog/model/extension/soconfig/general.php:5
107 (0.238)
SELECT *
FROM seo_url
WHERE `query` = 'product_id=1154' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
108 (0.110)
SELECT date_end, date_start
FROM product_special
WHERE product_id='1189' AND customer_group_id = '1'
/var/www/cuboscubik.com/public_html/catalog/model/extension/soconfig/general.php:5
109 (0.259)
SELECT *
FROM seo_url
WHERE `query` = 'product_id=1189' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
110 (0.111)
SELECT date_end, date_start
FROM product_special
WHERE product_id='1190' AND customer_group_id = '1'
/var/www/cuboscubik.com/public_html/catalog/model/extension/soconfig/general.php:5
111 (0.261)
SELECT *
FROM seo_url
WHERE `query` = 'product_id=1190' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
112 (0.111)
SELECT date_end, date_start
FROM product_special
WHERE product_id='1192' AND customer_group_id = '1'
/var/www/cuboscubik.com/public_html/catalog/model/extension/soconfig/general.php:5
113 (0.260)
SELECT *
FROM seo_url
WHERE `query` = 'product_id=1192' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
114 (0.118)
SELECT date_end, date_start
FROM product_special
WHERE product_id='1208' AND customer_group_id = '1'
/var/www/cuboscubik.com/public_html/catalog/model/extension/soconfig/general.php:5
115 (0.269)
SELECT *
FROM seo_url
WHERE `query` = 'product_id=1208' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
116 (0.109)
SELECT date_end, date_start
FROM product_special
WHERE product_id='1265' AND customer_group_id = '1'
/var/www/cuboscubik.com/public_html/catalog/model/extension/soconfig/general.php:5
117 (0.148)
SELECT *
FROM seo_url
WHERE `query` = 'product_id=1265' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
118 (0.109)
SELECT date_end, date_start
FROM product_special
WHERE product_id='1278' AND customer_group_id = '1'
/var/www/cuboscubik.com/public_html/catalog/model/extension/soconfig/general.php:5
119 (0.163)
SELECT *
FROM seo_url
WHERE `query` = 'product_id=1278' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
120 (0.107)
SELECT date_end, date_start
FROM product_special
WHERE product_id='1280' AND customer_group_id = '1'
/var/www/cuboscubik.com/public_html/catalog/model/extension/soconfig/general.php:5
121 (0.167)
SELECT *
FROM seo_url
WHERE `query` = 'product_id=1280' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
122 (0.120)
SELECT date_end, date_start
FROM product_special
WHERE product_id='1281' AND customer_group_id = '1'
/var/www/cuboscubik.com/public_html/catalog/model/extension/soconfig/general.php:5
123 (0.157)
SELECT *
FROM seo_url
WHERE `query` = 'product_id=1281' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
124 (0.112)
SELECT date_end, date_start
FROM product_special
WHERE product_id='1285' AND customer_group_id = '1'
/var/www/cuboscubik.com/public_html/catalog/model/extension/soconfig/general.php:5
125 (0.156)
SELECT *
FROM seo_url
WHERE `query` = 'product_id=1285' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
126 (0.114)
SELECT date_end, date_start
FROM product_special
WHERE product_id='1286' AND customer_group_id = '1'
/var/www/cuboscubik.com/public_html/catalog/model/extension/soconfig/general.php:5
127 (0.160)
SELECT *
FROM seo_url
WHERE `query` = 'product_id=1286' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
128 (0.111)
SELECT date_end, date_start
FROM product_special
WHERE product_id='1288' AND customer_group_id = '1'
/var/www/cuboscubik.com/public_html/catalog/model/extension/soconfig/general.php:5
129 (0.168)
SELECT *
FROM seo_url
WHERE `query` = 'product_id=1288' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
130 (0.122)
SELECT date_end, date_start
FROM product_special
WHERE product_id='1289' AND customer_group_id = '1'
/var/www/cuboscubik.com/public_html/catalog/model/extension/soconfig/general.php:5
131 (0.159)
SELECT *
FROM seo_url
WHERE `query` = 'product_id=1289' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
132 (0.109)
SELECT date_end, date_start
FROM product_special
WHERE product_id='1290' AND customer_group_id = '1'
/var/www/cuboscubik.com/public_html/catalog/model/extension/soconfig/general.php:5
133 (0.166)
SELECT *
FROM seo_url
WHERE `query` = 'product_id=1290' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
134 (0.438)
SELECT rd.*
FROM product_recurring pr JOIN recurring_description rd ON (rd.language_id = 4 AND rd.recurring_id = pr.recurring_id) JOIN recurring r ON r.recurring_id = rd.recurring_id
WHERE pr.product_id = 1099 AND status = '1' AND pr.customer_group_id = '1'
ORDER BY sort_order ASC
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:525
135 (0.198)
UPDATE product SET viewed = (viewed + 1)
WHERE product_id = '1099'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:4
136 (0.229)
SELECT *
FROM product_to_layout
WHERE product_id = '1099' AND store_id = '0'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:401
137 (0.218)
SELECT *
FROM layout_module
WHERE layout_id = '2' AND position = 'column_left'
ORDER BY sort_order
/var/www/cuboscubik.com/public_html/catalog/model/design/layout.php:14
138 (0.194)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'so-etrostores' AND route = 'common/column_left'
/var/www/cuboscubik.com/public_html/catalog/model/design/theme.php:4
139 (0.167)
SELECT *
FROM product_to_layout
WHERE product_id = '1099' AND store_id = '0'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:401
140 (0.147)
SELECT *
FROM layout_module
WHERE layout_id = '2' AND position = 'column_right'
ORDER BY sort_order
/var/www/cuboscubik.com/public_html/catalog/model/design/layout.php:14
141 (0.116)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'so-etrostores' AND route = 'common/column_right'
/var/www/cuboscubik.com/public_html/catalog/model/design/theme.php:4
142 (0.111)
SELECT *
FROM product_to_layout
WHERE product_id = '1099' AND store_id = '0'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:401
143 (0.139)
SELECT *
FROM layout_module
WHERE layout_id = '2' AND position = 'content_top'
ORDER BY sort_order
/var/www/cuboscubik.com/public_html/catalog/model/design/layout.php:14
144 (0.114)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'so-etrostores' AND route = 'common/content_top'
/var/www/cuboscubik.com/public_html/catalog/model/design/theme.php:4
145 (0.154)
SELECT *
FROM product_to_layout
WHERE product_id = '1099' AND store_id = '0'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:401
146 (0.137)
SELECT *
FROM layout_module
WHERE layout_id = '2' AND position = 'content_bottom'
ORDER BY sort_order
/var/www/cuboscubik.com/public_html/catalog/model/design/layout.php:14
147 (0.116)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'so-etrostores' AND route = 'common/content_bottom'
/var/www/cuboscubik.com/public_html/catalog/model/design/theme.php:4
148 (0.217)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '4' AND (route = 'extension/soconfig/compare' OR route = 'es-MX')
/var/www/cuboscubik.com/public_html/catalog/model/design/translation.php:6
149 (0.120)
SELECT *
FROM product_to_layout
WHERE product_id = '1099' AND store_id = '0'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:401
150 (0.153)
SELECT *
FROM layout_module
WHERE layout_id = '2' AND position = 'footer_block3'
ORDER BY sort_order
/var/www/cuboscubik.com/public_html/catalog/model/design/layout.php:14
151 (0.238)
SELECT *
FROM module
WHERE module_id = '77'
/var/www/cuboscubik.com/public_html/catalog/model/setting/module.php:4
152 (0.150)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '4' AND (route = 'extension/module/so_page_builder' OR route = 'es-MX')
/var/www/cuboscubik.com/public_html/catalog/model/design/translation.php:6
153 (0.122)
SELECT *
FROM module
WHERE module_id = '73'
/var/www/cuboscubik.com/public_html/catalog/model/setting/module.php:4
154 (0.159)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '4' AND (route = 'extension/module/so_newletter_custom_popup' OR route = 'es-MX')
/var/www/cuboscubik.com/public_html/catalog/model/design/translation.php:6
155 (0.193)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'so-etrostores' AND route = 'extension/module/so_newletter_custom_popup/default'
/var/www/cuboscubik.com/public_html/catalog/model/design/theme.php:4
156 (0.154)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'so-etrostores' AND route = 'extension/module/so_page_builder/default'
/var/www/cuboscubik.com/public_html/catalog/model/design/theme.php:4
157 (0.145)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'so-etrostores' AND route = 'position/content_block'
/var/www/cuboscubik.com/public_html/catalog/model/design/theme.php:4
158 (0.145)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '4' AND (route = 'common/footer' OR route = 'es-MX')
/var/www/cuboscubik.com/public_html/catalog/model/design/translation.php:6
159 (2.319)
SELECT *
FROM information i
LEFT JOIN information_description id ON (i.information_id = id.information_id)
LEFT JOIN information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE id.language_id = '4' AND i2s.store_id = '0' AND i.status = '1'
ORDER BY i.sort_order, LCASE(id.title) ASC
/var/www/cuboscubik.com/public_html/catalog/model/catalog/information.php:10
160 (0.239)
SELECT *
FROM seo_url
WHERE `query` = 'information_id=4' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
161 (0.168)
SELECT *
FROM seo_url
WHERE `query` = 'information_id=18' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
162 (0.205)
SELECT *
FROM seo_url
WHERE `query` = 'information_id=58' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
163 (0.163)
SELECT *
FROM seo_url
WHERE `query` = 'information_id=23' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
164 (0.183)
SELECT *
FROM seo_url
WHERE `query` = 'information_id=5' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
165 (0.157)
SELECT *
FROM seo_url
WHERE `query` = 'information_id=17' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
166 (0.194)
SELECT *
FROM seo_url
WHERE `query` = 'information_id=6' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
167 (0.190)
SELECT *
FROM seo_url
WHERE `query` = 'information_id=60' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
168 (0.157)
SELECT *
FROM seo_url
WHERE `query` = 'information_id=16' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
169 (0.115)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'so-etrostores' AND route = 'common/footer'
/var/www/cuboscubik.com/public_html/catalog/model/design/theme.php:4
170 (0.149)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '4' AND (route = 'extension/soconfig/compare' OR route = 'es-MX')
/var/www/cuboscubik.com/public_html/catalog/model/design/translation.php:6
171 (0.119)
SELECT *
FROM product_to_layout
WHERE product_id = '1099' AND store_id = '0'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:401
172 (0.159)
SELECT *
FROM layout_module
WHERE layout_id = '2' AND position = 'content_menu1'
ORDER BY sort_order
/var/www/cuboscubik.com/public_html/catalog/model/design/layout.php:14
173 (0.107)
SELECT *
FROM module
WHERE module_id = '61'
/var/www/cuboscubik.com/public_html/catalog/model/setting/module.php:4
174 (0.394)
SELECT *
FROM mega_menu
WHERE parent_id='0' AND status='0' AND module_id = '61'
ORDER BY rang
/var/www/cuboscubik.com/public_html/catalog/model/extension/module/so_megamenu.php:7
175 (0.173)
SELECT *
FROM mega_menu
WHERE parent_id='129' AND status='0'
ORDER BY rang
/var/www/cuboscubik.com/public_html/catalog/model/extension/module/so_megamenu.php:58
176 (0.176)
SELECT *
FROM mega_menu
WHERE parent_id='131' AND status='0'
ORDER BY rang
/var/www/cuboscubik.com/public_html/catalog/model/extension/module/so_megamenu.php:58
177 (0.176)
SELECT *
FROM seo_url
WHERE `query` = 'product_id=1274' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
178 (0.219)
SELECT *
FROM seo_url
WHERE `query` = 'product_id=274' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
179 (0.223)
SELECT *
FROM seo_url
WHERE `query` = 'product_id=1088' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
180 (0.225)
SELECT *
FROM seo_url
WHERE `query` = 'product_id=312' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
181 (0.367)
SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '0' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:4
182 (0.160)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=0' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
183 (0.787)
SELECT * , c.category_id as id
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '0' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 6
/var/www/cuboscubik.com/public_html/catalog/model/extension/module/so_megamenu.php:362
184 (0.139)
SELECT * , c.category_id as id
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '110' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 0
/var/www/cuboscubik.com/public_html/catalog/model/extension/module/so_megamenu.php:362
185 (0.128)
SELECT * , c.category_id as id
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '114' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 0
/var/www/cuboscubik.com/public_html/catalog/model/extension/module/so_megamenu.php:362
186 (0.129)
SELECT * , c.category_id as id
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '113' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 0
/var/www/cuboscubik.com/public_html/catalog/model/extension/module/so_megamenu.php:362
187 (0.118)
SELECT * , c.category_id as id
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '108' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 0
/var/www/cuboscubik.com/public_html/catalog/model/extension/module/so_megamenu.php:362
188 (0.116)
SELECT * , c.category_id as id
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '107' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 0
/var/www/cuboscubik.com/public_html/catalog/model/extension/module/so_megamenu.php:362
189 (0.121)
SELECT * , c.category_id as id
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '103' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 0
/var/www/cuboscubik.com/public_html/catalog/model/extension/module/so_megamenu.php:362
190 (0.185)
SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '110' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:4
191 (0.172)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=110' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
192 (0.167)
SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '114' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:4
193 (0.163)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=114' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
194 (0.165)
SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '113' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:4
195 (0.163)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=113' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
196 (0.173)
SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '108' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:4
197 (0.160)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=108' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
198 (0.174)
SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '107' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:4
199 (0.157)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=107' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
200 (0.173)
SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '103' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:4
201 (0.156)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=103' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
202 (0.765)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '4') AS stock_status, (SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '4') AS weight_class, (SELECT lcd.unit
FROM length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '4') AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '0' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:8
203 (0.180)
SELECT *
FROM mega_menu
WHERE parent_id='137' AND status='0'
ORDER BY rang
/var/www/cuboscubik.com/public_html/catalog/model/extension/module/so_megamenu.php:58
204 (0.168)
SELECT *
FROM seo_url
WHERE `query` = 'product_id=1274' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
205 (0.222)
SELECT *
FROM seo_url
WHERE `query` = 'product_id=274' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
206 (0.219)
SELECT *
FROM seo_url
WHERE `query` = 'product_id=1088' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
207 (0.227)
SELECT *
FROM seo_url
WHERE `query` = 'product_id=312' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
208 (0.154)
SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '0' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:4
209 (0.144)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=0' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
210 (0.761)
SELECT * , c.category_id as id
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '0' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 6
/var/www/cuboscubik.com/public_html/catalog/model/extension/module/so_megamenu.php:362
211 (0.134)
SELECT * , c.category_id as id
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '110' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 0
/var/www/cuboscubik.com/public_html/catalog/model/extension/module/so_megamenu.php:362
212 (0.120)
SELECT * , c.category_id as id
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '114' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 0
/var/www/cuboscubik.com/public_html/catalog/model/extension/module/so_megamenu.php:362
213 (0.118)
SELECT * , c.category_id as id
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '113' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 0
/var/www/cuboscubik.com/public_html/catalog/model/extension/module/so_megamenu.php:362
214 (0.114)
SELECT * , c.category_id as id
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '108' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 0
/var/www/cuboscubik.com/public_html/catalog/model/extension/module/so_megamenu.php:362
215 (0.114)
SELECT * , c.category_id as id
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '107' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 0
/var/www/cuboscubik.com/public_html/catalog/model/extension/module/so_megamenu.php:362
216 (0.124)
SELECT * , c.category_id as id
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '103' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 0
/var/www/cuboscubik.com/public_html/catalog/model/extension/module/so_megamenu.php:362
217 (0.167)
SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '110' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:4
218 (0.162)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=110' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
219 (0.163)
SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '114' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:4
220 (0.166)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=114' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
221 (0.169)
SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '113' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:4
222 (0.164)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=113' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
223 (0.160)
SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '108' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:4
224 (0.155)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=108' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
225 (0.162)
SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '107' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:4
226 (0.160)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=107' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
227 (0.160)
SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '103' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:4
228 (0.153)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=103' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
229 (0.578)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '4') AS stock_status, (SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '4') AS weight_class, (SELECT lcd.unit
FROM length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '4') AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '0' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:8
230 (0.188)
SELECT *
FROM mega_menu
WHERE parent_id='139' AND status='0'
ORDER BY rang
/var/www/cuboscubik.com/public_html/catalog/model/extension/module/so_megamenu.php:58
231 (0.153)
SELECT *
FROM mega_menu
WHERE parent_id='140' AND status='0'
ORDER BY rang
/var/www/cuboscubik.com/public_html/catalog/model/extension/module/so_megamenu.php:58
232 (0.157)
SELECT *
FROM mega_menu
WHERE parent_id='144' AND status='0'
ORDER BY rang
/var/www/cuboscubik.com/public_html/catalog/model/extension/module/so_megamenu.php:58
233 (0.152)
SELECT *
FROM mega_menu
WHERE parent_id='146' AND status='0'
ORDER BY rang
/var/www/cuboscubik.com/public_html/catalog/model/extension/module/so_megamenu.php:58
234 (0.151)
SELECT *
FROM mega_menu
WHERE parent_id='248' AND status='0'
ORDER BY rang
/var/www/cuboscubik.com/public_html/catalog/model/extension/module/so_megamenu.php:58
235 (0.127)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'so-etrostores' AND route = 'extension/module/so_megamenu/default'
/var/www/cuboscubik.com/public_html/catalog/model/design/theme.php:4
236 (0.105)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'so-etrostores' AND route = 'position/content_block'
/var/www/cuboscubik.com/public_html/catalog/model/design/theme.php:4
237 (0.194)
SELECT *
FROM product_to_layout
WHERE product_id = '1099' AND store_id = '0'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:401
238 (0.162)
SELECT *
FROM layout_module
WHERE layout_id = '2' AND position = 'content_menu2'
ORDER BY sort_order
/var/www/cuboscubik.com/public_html/catalog/model/design/layout.php:14
239 (0.121)
SELECT *
FROM module
WHERE module_id = '75'
/var/www/cuboscubik.com/public_html/catalog/model/setting/module.php:4
240 (0.270)
SELECT *
FROM mega_menu
WHERE parent_id='0' AND status='0' AND module_id = '75'
ORDER BY rang
/var/www/cuboscubik.com/public_html/catalog/model/extension/module/so_megamenu.php:7
241 (0.161)
SELECT *
FROM mega_menu
WHERE parent_id='149' AND status='0'
ORDER BY rang
/var/www/cuboscubik.com/public_html/catalog/model/extension/module/so_megamenu.php:58
242 (0.156)
SELECT *
FROM mega_menu
WHERE parent_id='152' AND status='0'
ORDER BY rang
/var/www/cuboscubik.com/public_html/catalog/model/extension/module/so_megamenu.php:58
243 (0.159)
SELECT *
FROM mega_menu
WHERE parent_id='162' AND status='0'
ORDER BY rang
/var/www/cuboscubik.com/public_html/catalog/model/extension/module/so_megamenu.php:58
244 (0.156)
SELECT *
FROM mega_menu
WHERE parent_id='164' AND status='0'
ORDER BY rang
/var/www/cuboscubik.com/public_html/catalog/model/extension/module/so_megamenu.php:58
245 (0.156)
SELECT *
FROM mega_menu
WHERE parent_id='153' AND status='0'
ORDER BY rang
/var/www/cuboscubik.com/public_html/catalog/model/extension/module/so_megamenu.php:58
246 (0.156)
SELECT *
FROM mega_menu
WHERE parent_id='167' AND status='0'
ORDER BY rang
/var/www/cuboscubik.com/public_html/catalog/model/extension/module/so_megamenu.php:58
247 (0.158)
SELECT *
FROM mega_menu
WHERE parent_id='155' AND status='0'
ORDER BY rang
/var/www/cuboscubik.com/public_html/catalog/model/extension/module/so_megamenu.php:58
248 (0.179)
SELECT *
FROM seo_url
WHERE `query` = 'product_id=1274' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
249 (0.224)
SELECT *
FROM seo_url
WHERE `query` = 'product_id=274' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
250 (0.223)
SELECT *
FROM seo_url
WHERE `query` = 'product_id=1088' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
251 (0.226)
SELECT *
FROM seo_url
WHERE `query` = 'product_id=312' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
252 (0.209)
SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '84' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:4
253 (0.179)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=84' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
254 (0.707)
SELECT * , c.category_id as id
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '84' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 10
/var/www/cuboscubik.com/public_html/catalog/model/extension/module/so_megamenu.php:362
255 (0.336)
SELECT * , c.category_id as id
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '112' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 10
/var/www/cuboscubik.com/public_html/catalog/model/extension/module/so_megamenu.php:362
256 (0.319)
SELECT * , c.category_id as id
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '60' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 10
/var/www/cuboscubik.com/public_html/catalog/model/extension/module/so_megamenu.php:362
257 (0.325)
SELECT * , c.category_id as id
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '62' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 10
/var/www/cuboscubik.com/public_html/catalog/model/extension/module/so_megamenu.php:362
258 (0.313)
SELECT * , c.category_id as id
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '90' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 10
/var/www/cuboscubik.com/public_html/catalog/model/extension/module/so_megamenu.php:362
259 (0.310)
SELECT * , c.category_id as id
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '59' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 10
/var/www/cuboscubik.com/public_html/catalog/model/extension/module/so_megamenu.php:362
260 (0.730)
SELECT * , c.category_id as id
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '101' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 10
/var/www/cuboscubik.com/public_html/catalog/model/extension/module/so_megamenu.php:362
261 (7.570)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM category_path cp
LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN product p ON (p2c.product_id = p.product_id)
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '61'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:513
262 (0.220)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=101' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
263 (0.165)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=61' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
264 (0.467)
SELECT * , c.category_id as id
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '61' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 3
/var/www/cuboscubik.com/public_html/catalog/model/extension/module/so_megamenu.php:362
265 (7.402)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM category_path cp
LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN product p ON (p2c.product_id = p.product_id)
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '88'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:513
266 (0.237)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=101' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
267 (0.176)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=88' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
268 (0.457)
SELECT * , c.category_id as id
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '88' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 3
/var/www/cuboscubik.com/public_html/catalog/model/extension/module/so_megamenu.php:362
269 (7.284)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM category_path cp
LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN product p ON (p2c.product_id = p.product_id)
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '97'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:513
270 (0.220)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=101' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
271 (0.179)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=97' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
272 (0.457)
SELECT * , c.category_id as id
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '97' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 3
/var/www/cuboscubik.com/public_html/catalog/model/extension/module/so_megamenu.php:362
273 (7.245)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM category_path cp
LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN product p ON (p2c.product_id = p.product_id)
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '95'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:513
274 (0.197)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=101' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
275 (0.184)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=95' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
276 (0.377)
SELECT * , c.category_id as id
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '95' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 3
/var/www/cuboscubik.com/public_html/catalog/model/extension/module/so_megamenu.php:362
277 (7.200)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM category_path cp
LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN product p ON (p2c.product_id = p.product_id)
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '87'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:513
278 (0.209)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=101' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
279 (0.183)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=87' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
280 (0.368)
SELECT * , c.category_id as id
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '87' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 3
/var/www/cuboscubik.com/public_html/catalog/model/extension/module/so_megamenu.php:362
281 (7.179)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM category_path cp
LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN product p ON (p2c.product_id = p.product_id)
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '106'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:513
282 (0.193)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=101' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
283 (0.171)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=106' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
284 (0.426)
SELECT * , c.category_id as id
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '106' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 3
/var/www/cuboscubik.com/public_html/catalog/model/extension/module/so_megamenu.php:362
285 (7.202)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM category_path cp
LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN product p ON (p2c.product_id = p.product_id)
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '72'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:513
286 (0.227)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=101' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
287 (0.169)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=72' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
288 (0.483)
SELECT * , c.category_id as id
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '72' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 3
/var/www/cuboscubik.com/public_html/catalog/model/extension/module/so_megamenu.php:362
289 (7.214)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM category_path cp
LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN product p ON (p2c.product_id = p.product_id)
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '89'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:513
290 (0.250)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=101' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
291 (0.175)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=89' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
292 (0.393)
SELECT * , c.category_id as id
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '89' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 3
/var/www/cuboscubik.com/public_html/catalog/model/extension/module/so_megamenu.php:362
293 (7.258)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM category_path cp
LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN product p ON (p2c.product_id = p.product_id)
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '86'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:513
294 (0.192)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=101' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
295 (0.174)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=86' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
296 (0.394)
SELECT * , c.category_id as id
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '86' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 3
/var/www/cuboscubik.com/public_html/catalog/model/extension/module/so_megamenu.php:362
297 (7.151)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM category_path cp
LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN product p ON (p2c.product_id = p.product_id)
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '96'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:513
298 (0.231)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=101' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
299 (0.192)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=96' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
300 (0.404)
SELECT * , c.category_id as id
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '96' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name) LIMIT 3
/var/www/cuboscubik.com/public_html/catalog/model/extension/module/so_megamenu.php:362
301 (0.193)
SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '112' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:4
302 (0.188)
SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '84' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:4
303 (0.199)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=84' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
304 (0.160)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=112' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
305 (0.167)
SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '60' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:4
306 (0.160)
SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '84' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:4
307 (0.172)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=84' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
308 (0.162)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=60' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
309 (0.165)
SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '62' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:4
310 (0.159)
SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '84' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:4
311 (0.172)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=84' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
312 (0.185)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=62' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
313 (0.171)
SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '90' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:4
314 (0.163)
SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '84' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:4
315 (0.171)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=84' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
316 (0.175)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=90' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
317 (0.164)
SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '59' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:4
318 (0.163)
SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '84' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:4
319 (0.168)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=84' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
320 (0.156)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
321 (0.166)
SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '101' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:4
322 (0.161)
SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '84' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:4
323 (0.167)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=84' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
324 (0.154)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=101' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
325 (0.174)
SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '61' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:4
326 (0.156)
SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '101' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:4
327 (0.153)
SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '84' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:4
328 (0.178)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=84' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
329 (0.149)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=101' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
330 (0.172)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=61' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
331 (0.165)
SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '88' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:4
332 (0.159)
SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '101' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:4
333 (0.153)
SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '84' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:4
334 (0.176)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=84' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
335 (0.151)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=101' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
336 (0.166)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=88' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
337 (0.158)
SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '97' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:4
338 (0.158)
SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '101' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:4
339 (0.156)
SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '84' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:4
340 (0.169)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=84' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
341 (0.156)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=101' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
342 (0.171)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=97' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
343 (0.177)
SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '95' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:4
344 (0.156)
SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '101' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:4
345 (0.154)
SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '84' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:4
346 (0.171)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=84' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
347 (0.150)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=101' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
348 (0.169)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=95' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
349 (0.200)
SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '87' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:4
350 (0.157)
SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '101' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:4
351 (0.155)
SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '84' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:4
352 (0.174)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=84' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
353 (0.149)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=101' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
354 (0.164)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=87' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
355 (0.162)
SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '106' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:4
356 (0.159)
SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '101' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:4
357 (0.159)
SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '84' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:4
358 (0.169)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=84' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
359 (0.151)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=101' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
360 (0.162)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=106' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
361 (0.165)
SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '72' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:4
362 (0.155)
SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '101' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:4
363 (0.153)
SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '84' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:4
364 (0.170)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=84' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
365 (0.148)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=101' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
366 (0.171)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=72' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
367 (0.157)
SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '89' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:4
368 (0.155)
SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '101' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:4
369 (0.156)
SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '84' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:4
370 (0.177)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=84' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
371 (0.166)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=101' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
372 (0.178)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=89' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
373 (0.170)
SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '86' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:4
374 (0.167)
SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '101' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:4
375 (0.163)
SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '84' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:4
376 (0.200)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=84' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
377 (0.149)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=101' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
378 (0.165)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=86' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
379 (0.171)
SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '96' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:4
380 (0.157)
SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '101' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:4
381 (0.160)
SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '84' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:4
382 (0.166)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=84' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
383 (0.155)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=101' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
384 (0.170)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=96' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
385 (0.661)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '4') AS stock_status, (SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '4') AS weight_class, (SELECT lcd.unit
FROM length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '4') AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '0' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:8
386 (0.210)
SELECT *
FROM mega_menu
WHERE parent_id='161' AND status='0'
ORDER BY rang
/var/www/cuboscubik.com/public_html/catalog/model/extension/module/so_megamenu.php:58
387 (0.164)
SELECT *
FROM mega_menu
WHERE parent_id='165' AND status='0'
ORDER BY rang
/var/www/cuboscubik.com/public_html/catalog/model/extension/module/so_megamenu.php:58
388 (0.155)
SELECT *
FROM mega_menu
WHERE parent_id='247' AND status='0'
ORDER BY rang
/var/www/cuboscubik.com/public_html/catalog/model/extension/module/so_megamenu.php:58
389 (0.169)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=73' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
390 (0.166)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=66' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
391 (0.169)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=68' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
392 (0.157)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=69' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
393 (0.164)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=74' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
394 (0.147)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=101' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
395 (0.161)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=70' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
396 (0.160)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=71' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
397 (0.121)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'so-etrostores' AND route = 'extension/module/so_megamenu/default'
/var/www/cuboscubik.com/public_html/catalog/model/design/theme.php:4
398 (0.106)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'so-etrostores' AND route = 'position/content_block'
/var/www/cuboscubik.com/public_html/catalog/model/design/theme.php:4
399 (0.110)
SELECT *
FROM product_to_layout
WHERE product_id = '1099' AND store_id = '0'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:401
400 (0.142)
SELECT *
FROM layout_module
WHERE layout_id = '2' AND position = 'header_block'
ORDER BY sort_order
/var/www/cuboscubik.com/public_html/catalog/model/design/layout.php:14
401 (0.103)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'so-etrostores' AND route = 'position/content_block'
/var/www/cuboscubik.com/public_html/catalog/model/design/theme.php:4
402 (0.108)
SELECT *
FROM product_to_layout
WHERE product_id = '1099' AND store_id = '0'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:401
403 (0.133)
SELECT *
FROM layout_module
WHERE layout_id = '2' AND position = 'search_block'
ORDER BY sort_order
/var/www/cuboscubik.com/public_html/catalog/model/design/layout.php:14
404 (0.114)
SELECT *
FROM module
WHERE module_id = '72'
/var/www/cuboscubik.com/public_html/catalog/model/setting/module.php:4
405 (0.103)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '4' AND (route = 'extension/module/so_searchpro' OR route = 'es-MX')
/var/www/cuboscubik.com/public_html/catalog/model/design/translation.php:6
406 (0.096)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '4' AND (route = 'extension/module/so_searchpro' OR route = 'es-MX')
/var/www/cuboscubik.com/public_html/catalog/model/design/translation.php:6
407 (30.646)
SELECT p.product_id, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,(NULL) AS sales
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.status = 1 GROUP BY p.product_id
ORDER BY p.viewed DESC, LCASE(pd.name) DESC LIMIT 0,7
/var/www/cuboscubik.com/public_html/catalog/model/extension/module/so_searchpro.php:145
408 (1.423)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '4') AS stock_status, (SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '4') AS weight_class, (SELECT lcd.unit
FROM length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '4') AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1274' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:8
409 (1.131)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '4') AS stock_status, (SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '4') AS weight_class, (SELECT lcd.unit
FROM length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '4') AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '274' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:8
410 (1.098)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '4') AS stock_status, (SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '4') AS weight_class, (SELECT lcd.unit
FROM length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '4') AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1088' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:8
411 (1.094)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '4') AS stock_status, (SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '4') AS weight_class, (SELECT lcd.unit
FROM length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '4') AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '312' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:8
412 (1.045)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '4') AS stock_status, (SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '4') AS weight_class, (SELECT lcd.unit
FROM length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '4') AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '64' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:8
413 (1.106)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '4') AS stock_status, (SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '4') AS weight_class, (SELECT lcd.unit
FROM length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '4') AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '341' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:8
414 (1.120)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '4') AS stock_status, (SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '4') AS weight_class, (SELECT lcd.unit
FROM length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '4') AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '61' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:8
415 (0.210)
SELECT *
FROM seo_url
WHERE `query` = 'product_id=1274' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
416 (0.220)
SELECT *
FROM seo_url
WHERE `query` = 'product_id=274' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
417 (0.236)
SELECT *
FROM seo_url
WHERE `query` = 'product_id=1088' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
418 (0.232)
SELECT *
FROM seo_url
WHERE `query` = 'product_id=312' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
419 (0.168)
SELECT *
FROM seo_url
WHERE `query` = 'product_id=64' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
420 (0.234)
SELECT *
FROM seo_url
WHERE `query` = 'product_id=341' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
421 (0.163)
SELECT *
FROM seo_url
WHERE `query` = 'product_id=61' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
422 (0.120)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'so-etrostores' AND route = 'position/content_block'
/var/www/cuboscubik.com/public_html/catalog/model/design/theme.php:4
423 (0.214)
SELECT *
FROM extension
WHERE `type` = 'analytics'
/var/www/cuboscubik.com/public_html/catalog/model/setting/extension.php:4
424 (0.291)
SELECT *
FROM setting
WHERE store_id = '0' AND `code` = 'so_sociallogin'
/var/www/cuboscubik.com/public_html/catalog/model/setting/setting.php:6
425 (0.180)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '4' AND (route = 'extension/module/so_sociallogin' OR route = 'es-MX')
/var/www/cuboscubik.com/public_html/catalog/model/design/translation.php:6
426 (0.100)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '4' AND (route = 'common/header' OR route = 'es-MX')
/var/www/cuboscubik.com/public_html/catalog/model/design/translation.php:6
427 (0.098)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '4' AND (route = 'common/language' OR route = 'es-MX')
/var/www/cuboscubik.com/public_html/catalog/model/design/translation.php:6
428 (0.189)
SELECT *
FROM language
WHERE status = '1'
ORDER BY sort_order, name
/var/www/cuboscubik.com/public_html/catalog/model/localisation/language.php:15
429 (0.232)
SELECT *
FROM seo_url
WHERE `query` = 'manufacturer_id=7' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
430 (0.231)
SELECT *
FROM seo_url
WHERE `query` = 'product_id=1099' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
431 (0.112)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'so-etrostores' AND route = 'common/language'
/var/www/cuboscubik.com/public_html/catalog/model/design/theme.php:4
432 (0.104)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '4' AND (route = 'common/currency' OR route = 'es-MX')
/var/www/cuboscubik.com/public_html/catalog/model/design/translation.php:6
433 (0.188)
SELECT *
FROM seo_url
WHERE `query` = 'manufacturer_id=7' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
434 (0.216)
SELECT *
FROM seo_url
WHERE `query` = 'product_id=1099' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:118
435 (0.117)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'so-etrostores' AND route = 'common/currency'
/var/www/cuboscubik.com/public_html/catalog/model/design/theme.php:4
436 (0.164)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '4' AND (route = 'common/search' OR route = 'es-MX')
/var/www/cuboscubik.com/public_html/catalog/model/design/translation.php:6
437 (0.112)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'so-etrostores' AND route = 'common/search'
/var/www/cuboscubik.com/public_html/catalog/model/design/theme.php:4
438 (0.150)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '4' AND (route = 'common/cart' OR route = 'es-MX')
/var/www/cuboscubik.com/public_html/catalog/model/design/translation.php:6
439 (0.107)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '4' AND (route = 'extension/soconfig/cart' OR route = 'es-MX')
/var/www/cuboscubik.com/public_html/catalog/model/design/translation.php:6
440 (0.276)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'e8aab63ec966d5eea974b6b9cc'
/var/www/cuboscubik.com/public_html/system/library/cart/cart.php:36
441 (0.126)
SELECT *
FROM extension
WHERE `type` = 'total'
/var/www/cuboscubik.com/public_html/catalog/model/setting/extension.php:4
442 (0.103)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '4' AND (route = 'extension/total/sub_total' OR route = 'es-MX')
/var/www/cuboscubik.com/public_html/catalog/model/design/translation.php:6
443 (0.138)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'e8aab63ec966d5eea974b6b9cc'
/var/www/cuboscubik.com/public_html/system/library/cart/cart.php:36
444 (0.140)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'e8aab63ec966d5eea974b6b9cc'
/var/www/cuboscubik.com/public_html/system/library/cart/cart.php:36
445 (0.132)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '4' AND (route = 'extension/total/total' OR route = 'es-MX')
/var/www/cuboscubik.com/public_html/catalog/model/design/translation.php:6
446 (0.139)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'e8aab63ec966d5eea974b6b9cc'
/var/www/cuboscubik.com/public_html/system/library/cart/cart.php:36
447 (0.135)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'e8aab63ec966d5eea974b6b9cc'
/var/www/cuboscubik.com/public_html/system/library/cart/cart.php:36
448 (0.110)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'so-etrostores' AND route = 'common/cart'
/var/www/cuboscubik.com/public_html/catalog/model/design/theme.php:4
449 (0.154)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '4' AND (route = 'common/menu' OR route = 'es-MX')
/var/www/cuboscubik.com/public_html/catalog/model/design/translation.php:6
450 (0.967)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '0' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:10
451 (0.329)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '103' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:10
452 (0.177)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=103' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
453 (0.326)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '66' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:10
454 (0.183)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=66' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
455 (0.314)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '67' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:10
456 (0.186)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=67' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
457 (0.311)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '68' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:10
458 (0.185)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=68' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
459 (0.306)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '69' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:10
460 (0.176)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=69' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
461 (0.519)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '84' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:10
462 (7.499)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM category_path cp
LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN product p ON (p2c.product_id = p.product_id)
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '112'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:513
463 (0.228)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=84' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
464 (0.166)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=112' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
465 (7.330)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM category_path cp
LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN product p ON (p2c.product_id = p.product_id)
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '60'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:513
466 (0.237)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=84' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
467 (0.171)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=60' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
468 (7.199)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM category_path cp
LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN product p ON (p2c.product_id = p.product_id)
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '62'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:513
469 (0.202)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=84' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
470 (0.171)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=62' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
471 (7.242)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM category_path cp
LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN product p ON (p2c.product_id = p.product_id)
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '90'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:513
472 (0.222)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=84' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
473 (0.175)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=90' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
474 (7.185)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM category_path cp
LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN product p ON (p2c.product_id = p.product_id)
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '59'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:513
475 (0.210)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=84' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
476 (0.164)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=59' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
477 (26.973)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM category_path cp
LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN product p ON (p2c.product_id = p.product_id)
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '101'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:513
478 (0.423)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=84' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
479 (0.170)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=101' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
480 (0.176)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=84' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
481 (0.563)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '70' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:10
482 (0.180)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=70' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
483 (0.522)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '71' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:10
484 (7.372)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM category_path cp
LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN product p ON (p2c.product_id = p.product_id)
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '92'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:513
485 (0.244)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=71' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
486 (0.181)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=92' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
487 (7.112)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM category_path cp
LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN product p ON (p2c.product_id = p.product_id)
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '111'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:513
488 (0.198)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=71' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
489 (0.163)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=111' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
490 (7.134)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM category_path cp
LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN product p ON (p2c.product_id = p.product_id)
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '93'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:513
491 (0.219)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=71' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
492 (0.179)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=93' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
493 (12.384)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM category_path cp
LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN product p ON (p2c.product_id = p.product_id)
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '75'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:513
494 (0.286)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=71' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
495 (0.173)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=75' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
496 (7.248)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM category_path cp
LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN product p ON (p2c.product_id = p.product_id)
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '102'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:513
497 (0.212)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=71' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
498 (0.161)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=102' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
499 (7.125)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM category_path cp
LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN product p ON (p2c.product_id = p.product_id)
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '115'
/var/www/cuboscubik.com/public_html/catalog/model/catalog/product.php:513
500 (0.232)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=71' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
501 (0.164)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=115' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
502 (0.169)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=71' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
503 (0.557)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '74' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/cuboscubik.com/public_html/catalog/model/catalog/category.php:10
504 (0.182)
SELECT *
FROM seo_url
WHERE `query` = 'category_id=74' AND store_id = '0' AND language_id = '4'
/var/www/cuboscubik.com/storage_other_nw/modification/catalog/controller/startup/seo_url.php:164
505 (0.129)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'so-etrostores' AND route = 'common/menu'
/var/www/cuboscubik.com/public_html/catalog/model/design/theme.php:4
506 (0.106)
SELECT *
FROM translation
WHERE store_id = '0' AND language_id = '4' AND (route = 'extension/soconfig/somobile' OR route = 'es-MX')
/var/www/cuboscubik.com/public_html/catalog/model/design/translation.php:6
507 (0.180)
SELECT *
FROM cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'e8aab63ec966d5eea974b6b9cc'
/var/www/cuboscubik.com/public_html/system/library/cart/cart.php:36
508 (0.113)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'so-etrostores' AND route = 'common/header'
/var/www/cuboscubik.com/public_html/catalog/model/design/theme.php:4
509 (0.112)
SELECT *
FROM theme
WHERE store_id = '0' AND theme = 'so-etrostores' AND route = 'product/product'
/var/www/cuboscubik.com/public_html/catalog/model/design/theme.php:4