WitEden

Cubos especialmente raros como el 3x3x9, los Camouflage, etc.



$499 mxn
Cubos Rubik  WitEden 2x2x5 Cuboide NegroUno d...
Cubos Rubik  WitEden 2x2x5 Cuboide NegroUno de los cuboides que no puede faltar en tu colección. Contáctanos por disponibilidad Local: 01(33) 36147823WhatsApp: 3317843484Correo ..

$599 mxn
Cubos Rubik  WitEden 2x2x6 Cuboide NegroUno d...
Cubos Rubik  WitEden 2x2x6 Cuboide NegroUno de los cuboides que no puede faltar en tu colección. Contáctanos por disponibilidad Local: 01(33) 36147823WhatsApp: 3317843484Correo ..

$499 mxn
Cubos Rubik  WitEden 3x3x7 Cuboide NegroUno d...
Cubos Rubik  WitEden 3x3x7 Cuboide NegroUno de los cuboides mas populares que no puede faltar en tu colección. Contáctanos por disponibilidad Local: 01(33) 36147823WhatsApp: 331..

$399 mxn
Cubos Rubik WitEden 3x3x7 Base Negra Un Cubo co...
Cubos Rubik WitEden 3x3x7 Base Negra Un Cubo con una dificultad extra, parecido a los cuboides. Con una movilidad muy buena para ser este tipo de Variaciones, Contactanos por dis..

$399 mxn
Cubos Rubik WitEden 3x3x9 V2 Base Negra la vers...
Cubos Rubik WitEden 3x3x9 V2 Base Negra la version 2 de este complicado cubo, uno de los favoritos  Contactanos por disponibilidad Local: 01(33) 36147823WhatsApp: 3317843484Cor..

$560 mxn
Un gran cubo que tiene corte a los 45° algo increí...
Un gran cubo que tiene corte a los 45° algo increíble que solo WitEden puede crearWitEden 3x3x3 MixUp Base Negra Contactanos por disponibilidad Local: 01(33) 36147823WhatsApp: 33178434..

$339 mxn
Cubos Rubik  WitEden 3x3x4 Cuboide NegroUno d...
Cubos Rubik  WitEden 3x3x4 Cuboide NegroUno de los cuboides mas populares que no puede faltar en tu colección. Contáctanos por disponibilidad Local: 01(33) 36147823WhatsApp: 331..

$389 mxn
Cubos Rubik  WitEden 3x3x5 Cuboide NegroUno d...
Cubos Rubik  WitEden 3x3x5 Cuboide NegroUno de los cuboides mas populares que no puede faltar en tu colección. Contáctanos por disponibilidad Local: 01(33) 36147823WhatsApp: 331..

$399 mxn
Cubos Rubik WitEden 3x3x9 V1 Base Negra la...
Cubos Rubik WitEden 3x3x9 V1 Base Negra la version 2 de este complicado cubo, uno de los favoritos Contactanos por disponibilidad Local: 01(33) 36147823WhatsApp: 3317843484Co..

$560 mxn
Un gran cubo que tiene corte a los 45° algo increí...
Un gran cubo que tiene corte a los 45° algo increíble que solo WitEden puede crearWitEden 3x3x4 MixUp Base Negra Contactanos por disponibilidad Local: 01(33) 36147823WhatsApp: 33178434..

$249 mxn
Cubos Rubik WitEden 3x3x3 Crazy Base NegraContácta...
Cubos Rubik WitEden 3x3x3 Crazy Base NegraContáctanos por disponibilidad Local: 01(33) 36147823WhatsApp: 3317843484Correo Electrónico: CubosCubik@gmail.comFacebook:  https://www..

$349 mxn
Cubos Rubik WitEden 3x3x4 Crazy Base NegraContácta...
Cubos Rubik WitEden 3x3x4 Crazy Base NegraContáctanos por disponibilidad Local: 01(33) 36147823WhatsApp: 3317843484Correo Electrónico: CubosCubik@gmail.comFacebook:  https://www..

$560 mxn
Un gran cubo que tiene corte a los 45° algo increí...
Un gran cubo que tiene corte a los 45° algo increíble que solo WitEden puede crearWitEden 4x4x4 MixUp Base Negra Contactanos por disponibilidad Local: 01(33) 36147823WhatsApp: 331..

$339 mxn
WitEden 2x2x3 Camouflage Base Negra Contactanos...
WitEden 2x2x3 Camouflage Base Negra Contactanos por disponibilidad Local: 01(33) 36147823WhatsApp: 3317843484Correo Electrónico: CubosCubik@gmail.comFacebook:  https://www.fa..

$339 mxn
WitEden 2x3x4 Camouflage Base Negra Contactanos...
WitEden 2x3x4 Camouflage Base Negra Contactanos por disponibilidad Local: 01(33) 36147823WhatsApp: 3317843484Correo Electrónico: CubosCubik@gmail.comFacebook:  https://www.fa..
Viendo 1 para 15 de 19 (2 Pages)
Queries: 377, Total time: 753.573 ms [By time] [By id] [By file]
1 (0.279)
SELECT *
FROM store
WHERE REPLACE(`url`, 'www.', '') = 'http://cuboscubik.com/'
/home/garccom/public_html/cuboscubik.com/index.php:43
2 (1.531)
SELECT *
FROM `setting`
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC
/home/garccom/public_html/cuboscubik.com/index.php:54
3 (0.268)
SELECT *
FROM `language`
WHERE status = '1'
/home/garccom/public_html/cuboscubik.com/index.php:140
4 (0.216)
SELECT *
FROM currency
/home/garccom/public_html/cuboscubik.com/system/library/currency.php:13
5 (0.541)
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 = 'shipping' 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
/home/garccom/public_html/cuboscubik.com/system/library/tax.php:26
6 (0.360)
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
/home/garccom/public_html/cuboscubik.com/system/library/tax.php:54
7 (0.296)
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'
/home/garccom/public_html/cuboscubik.com/system/library/weight.php:9
8 (0.250)
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'
/home/garccom/public_html/cuboscubik.com/system/library/length.php:9
9 (0.227)
SELECT *
FROM extension
WHERE `type` = 'openbay'
/home/garccom/public_html/cuboscubik.com/system/library/openbay.php:116
10 (0.175)
SELECT *
FROM event
/home/garccom/public_html/cuboscubik.com/index.php:244
11 (0.359)
SELECT *
FROM url_alias
WHERE keyword = 'Cubos-Rubik-Por-Marca'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:19
12 (0.284)
SELECT *
FROM url_alias
WHERE keyword = 'Todas-las-Marcas'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:19
13 (0.294)
SELECT *
FROM url_alias
WHERE keyword = 'WitEden'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:19
14 (0.409)
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'
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/category.php:4
15 (0.306)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=84'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
16 (0.296)
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'
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/category.php:4
17 (0.278)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=84'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
18 (0.237)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=101'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
19 (0.267)
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 = '99' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/category.php:4
20 (0.266)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=84'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
21 (0.233)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=101'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
22 (0.258)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=99'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
23 (0.264)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=84'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
24 (0.236)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=101'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
25 (0.259)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=99'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
26 (0.570)
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 = '99' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/category.php:10
27 (13.236)
SELECT p.product_id, NULL as rating, NULL as special
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' GROUP BY p.product_id
ORDER BY p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,8
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:321
28 (1.725)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '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 = '1314' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:134
29 (1.217)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '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 = '1312' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:134
30 (1.187)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '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 = '1311' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:134
31 (1.214)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '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 = '1310' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:134
32 (1.788)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '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 = '1309' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:134
33 (1.203)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '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 = '1308' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:134
34 (1.229)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '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 = '1307' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:134
35 (1.712)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '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 = '1306' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:134
36 (0.621)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM product_to_category p2c
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 p2c.category_id = '99' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:628
37 (0.733)
SELECT p.product_id, NULL as rating, NULL as special
FROM product_to_category p2c
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 p2c.category_id = '99' GROUP BY p.product_id
ORDER BY CASE WHEN p.quantity > 0 THEN 1 ELSE 2 END ASC, p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,15
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:321
38 (1.295)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '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 = '1156' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:134
39 (1.227)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '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 = '1157' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:134
40 (1.306)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '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 = '1022' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:134
41 (1.224)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '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 = '1247' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:134
42 (1.207)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '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 = '209' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:134
43 (1.210)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '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 = '506' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:134
44 (1.225)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '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 = '1304' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:134
45 (1.210)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '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 = '1084' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:134
46 (0.292)
SELECT DISTINCT *
FROM stock_tickets
WHERE stock_status_id = '5' AND `language_id` = '4' AND `status` = '1'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:19
47 (1.273)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '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 = '391' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:134
48 (0.225)
SELECT DISTINCT *
FROM stock_tickets
WHERE stock_status_id = '5' AND `language_id` = '4' AND `status` = '1'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:19
49 (1.212)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '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 = '507' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:134
50 (0.241)
SELECT DISTINCT *
FROM stock_tickets
WHERE stock_status_id = '5' AND `language_id` = '4' AND `status` = '1'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:19
51 (1.208)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '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 = '1168' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:134
52 (0.224)
SELECT DISTINCT *
FROM stock_tickets
WHERE stock_status_id = '5' AND `language_id` = '4' AND `status` = '1'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:19
53 (1.183)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '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 = '1169' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:134
54 (0.251)
SELECT DISTINCT *
FROM stock_tickets
WHERE stock_status_id = '5' AND `language_id` = '4' AND `status` = '1'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:19
55 (1.202)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '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 = '511' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:134
56 (0.223)
SELECT DISTINCT *
FROM stock_tickets
WHERE stock_status_id = '5' AND `language_id` = '4' AND `status` = '1'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:19
57 (1.196)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '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 = '505' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:134
58 (0.229)
SELECT DISTINCT *
FROM stock_tickets
WHERE stock_status_id = '5' AND `language_id` = '4' AND `status` = '1'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:19
59 (1.226)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '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 = '710' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:134
60 (0.235)
SELECT DISTINCT *
FROM stock_tickets
WHERE stock_status_id = '5' AND `language_id` = '4' AND `status` = '1'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:19
61 (0.288)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=84'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
62 (0.247)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=101'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
63 (0.281)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=99'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
64 (0.366)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=1156'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
65 (0.267)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=84'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
66 (0.243)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=101'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
67 (0.257)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=99'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
68 (0.359)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=1157'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
69 (0.260)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=84'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
70 (0.241)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=101'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
71 (0.280)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=99'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
72 (0.283)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=1022'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
73 (0.253)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=84'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
74 (0.245)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=101'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
75 (0.276)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=99'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
76 (0.425)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=1247'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
77 (0.277)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=84'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
78 (0.227)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=101'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
79 (0.254)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=99'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
80 (0.302)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=209'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
81 (0.249)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=84'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
82 (0.227)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=101'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
83 (0.259)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=99'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
84 (0.283)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=506'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
85 (0.250)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=84'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
86 (0.230)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=101'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
87 (0.269)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=99'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
88 (0.247)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=1304'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
89 (0.245)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=84'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
90 (0.248)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=101'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
91 (0.252)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=99'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
92 (0.300)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=1084'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
93 (0.266)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=84'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
94 (0.289)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=101'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
95 (0.304)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=99'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
96 (0.278)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=391'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
97 (0.292)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=84'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
98 (0.269)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=101'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
99 (0.299)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=99'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
100 (0.309)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=507'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
101 (0.293)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=84'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
102 (0.257)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=101'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
103 (0.284)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=99'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
104 (0.387)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=1168'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
105 (0.282)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=84'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
106 (0.255)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=101'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
107 (0.294)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=99'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
108 (0.377)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=1169'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
109 (0.298)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=84'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
110 (0.259)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=101'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
111 (0.278)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=99'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
112 (0.323)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=511'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
113 (0.283)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=84'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
114 (0.254)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=101'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
115 (0.300)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=99'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
116 (0.299)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=505'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
117 (0.280)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=84'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
118 (0.276)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=101'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
119 (0.283)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=99'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
120 (0.298)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=710'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
121 (0.286)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=84'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
122 (0.251)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=101'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
123 (0.278)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=99'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
124 (0.291)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=84'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
125 (0.258)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=101'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
126 (0.280)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=99'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
127 (0.284)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=84'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
128 (0.252)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=101'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
129 (0.285)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=99'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
130 (0.285)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=84'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
131 (0.254)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=101'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
132 (0.284)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=99'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
133 (0.306)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=84'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
134 (0.254)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=101'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
135 (0.287)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=99'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
136 (0.286)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=84'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
137 (0.256)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=101'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
138 (0.277)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=99'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
139 (0.290)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=84'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
140 (0.252)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=101'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
141 (0.281)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=99'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
142 (0.274)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=84'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
143 (0.252)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=101'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
144 (0.281)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=99'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
145 (0.281)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=84'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
146 (0.280)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=101'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
147 (0.278)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=99'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
148 (0.309)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=84'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
149 (0.261)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=101'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
150 (0.277)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=99'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
151 (0.279)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=84'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
152 (0.267)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=101'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
153 (0.278)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=99'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
154 (0.278)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=84'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
155 (0.263)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=101'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
156 (0.291)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=99'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
157 (0.274)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=84'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
158 (0.262)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=101'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
159 (0.281)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=99'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
160 (0.275)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=84'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
161 (0.262)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=101'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
162 (0.279)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=99'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
163 (0.311)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=84'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
164 (0.263)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=101'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
165 (0.282)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=99'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
166 (0.255)
SELECT *
FROM category_to_layout
WHERE category_id = '99' AND store_id = '0'
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/category.php:55
167 (0.271)
SELECT *
FROM layout_module
WHERE layout_id = '3' AND position = 'column_left'
ORDER BY sort_order
/home/garccom/public_html/cuboscubik.com/catalog/model/design/layout.php:14
168 (0.228)
SELECT *
FROM category_to_layout
WHERE category_id = '99' AND store_id = '0'
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/category.php:55
169 (0.238)
SELECT *
FROM layout_module
WHERE layout_id = '3' AND position = 'column_right'
ORDER BY sort_order
/home/garccom/public_html/cuboscubik.com/catalog/model/design/layout.php:14
170 (0.227)
SELECT *
FROM category_to_layout
WHERE category_id = '99' AND store_id = '0'
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/category.php:55
171 (0.239)
SELECT *
FROM layout_module
WHERE layout_id = '3' AND position = 'content_top'
ORDER BY sort_order
/home/garccom/public_html/cuboscubik.com/catalog/model/design/layout.php:14
172 (0.224)
SELECT *
FROM category_to_layout
WHERE category_id = '99' AND store_id = '0'
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/category.php:55
173 (0.246)
SELECT *
FROM layout_module
WHERE layout_id = '3' AND position = 'content_bottom'
ORDER BY sort_order
/home/garccom/public_html/cuboscubik.com/catalog/model/design/layout.php:14
174 (2.277)
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
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/information.php:10
175 (0.377)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=4'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
176 (0.286)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=18'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
177 (0.327)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=58'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
178 (0.285)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=23'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
179 (0.304)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=5'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
180 (0.283)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=17'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
181 (0.304)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=6'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
182 (0.308)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=60'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
183 (0.273)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=16'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
184 (0.269)
SELECT *
FROM category_to_layout
WHERE category_id = '99' AND store_id = '0'
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/category.php:55
185 (0.281)
SELECT *
FROM layout_module
WHERE layout_id = '3' AND position = 'footer_top'
ORDER BY sort_order
/home/garccom/public_html/cuboscubik.com/catalog/model/design/layout.php:14
186 (0.297)
DELETE
FROM `customer_online`
WHERE date_added < '2018-04-26 01:30:43'
/home/garccom/public_html/cuboscubik.com/catalog/model/tool/online.php:4
187 (0.238)
SELECT COUNT(*) AS total
FROM `customer_online`
WHERE `ip` = '54.224.234.8'
/home/garccom/public_html/cuboscubik.com/catalog/model/tool/online.php:6
188 (2.150)
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
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/information.php:10
189 (0.353)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=4'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
190 (0.307)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=18'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
191 (0.321)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=58'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
192 (0.327)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=23'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
193 (0.351)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=5'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
194 (0.289)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=17'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
195 (0.325)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=6'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
196 (0.316)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=60'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
197 (0.281)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=16'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
198 (1.151)
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)
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/category.php:10
199 (0.504)
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 = '73' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/category.php:10
200 (0.314)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=73'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
201 (0.479)
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)
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/category.php:10
202 (0.307)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=66'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
203 (0.482)
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)
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/category.php:10
204 (0.307)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=67'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
205 (0.484)
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)
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/category.php:10
206 (0.306)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=68'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
207 (0.479)
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)
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/category.php:10
208 (0.303)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=69'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
209 (0.688)
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)
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/category.php:10
210 (0.320)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=84'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
211 (0.747)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=112'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
212 (0.278)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=84'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
213 (0.262)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=60'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
214 (0.283)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=84'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
215 (0.257)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=62'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
216 (0.258)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=84'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
217 (1.180)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=90'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
218 (0.286)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=84'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
219 (0.241)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=59'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
220 (0.263)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=84'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
221 (0.263)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=101'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
222 (0.286)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=84'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
223 (0.630)
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)
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/category.php:10
224 (0.304)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=70'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
225 (0.697)
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)
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/category.php:10
226 (0.310)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=71'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
227 (0.325)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=92'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
228 (0.300)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=71'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
229 (0.284)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=111'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
230 (0.309)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=71'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
231 (0.295)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=93'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
232 (0.290)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=71'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
233 (0.296)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=75'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
234 (0.293)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=71'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
235 (0.276)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=102'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
236 (0.343)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=71'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
237 (0.286)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=115'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
238 (0.301)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=71'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
239 (0.559)
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)
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/category.php:10
240 (0.296)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=74'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
241 (1.089)
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)
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/category.php:10
242 (0.337)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=73'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
243 (0.500)
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 = '73' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/category.php:10
244 (0.308)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=66'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
245 (0.483)
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)
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/category.php:10
246 (0.313)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=67'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
247 (0.477)
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)
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/category.php:10
248 (0.304)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=68'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
249 (0.482)
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)
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/category.php:10
250 (0.317)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=69'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
251 (0.486)
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)
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/category.php:10
252 (0.311)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=84'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
253 (0.702)
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)
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/category.php:10
254 (14.798)
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 cp.path_id = '112' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:628
255 (0.438)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=112'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
256 (0.647)
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 = '112' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/category.php:10
257 (14.799)
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 cp.path_id = '60' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:628
258 (0.482)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=60'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
259 (0.654)
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 = '60' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/category.php:10
260 (14.998)
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 cp.path_id = '62' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:628
261 (0.416)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=62'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
262 (0.651)
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 = '62' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/category.php:10
263 (14.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 cp.path_id = '90' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:628
264 (0.438)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=90'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
265 (0.658)
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 = '90' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/category.php:10
266 (14.487)
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 cp.path_id = '59' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:628
267 (0.412)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=59'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
268 (0.643)
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 = '59' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/category.php:10
269 (14.784)
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 cp.path_id = '101' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:628
270 (0.339)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=101'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
271 (1.136)
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 = '101' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/category.php:10
272 (14.438)
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 cp.path_id = '61' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:628
273 (0.407)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=61'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
274 (0.624)
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 = '61' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/category.php:10
275 (14.148)
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 cp.path_id = '88' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:628
276 (0.413)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=88'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
277 (0.622)
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 = '88' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/category.php:10
278 (14.145)
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 cp.path_id = '97' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:628
279 (0.441)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=97'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
280 (0.644)
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 = '97' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/category.php:10
281 (14.293)
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 cp.path_id = '95' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:628
282 (0.453)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=95'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
283 (0.651)
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 = '95' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/category.php:10
284 (14.166)
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 cp.path_id = '87' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:628
285 (72.215)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=87'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
286 (0.697)
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 = '87' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/category.php:10
287 (14.213)
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 cp.path_id = '106' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:628
288 (0.336)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=106'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
289 (0.569)
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 = '106' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/category.php:10
290 (14.801)
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 cp.path_id = '72' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:628
291 (0.445)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=72'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
292 (0.638)
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 = '72' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/category.php:10
293 (14.987)
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 cp.path_id = '89' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:628
294 (0.450)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=89'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
295 (0.671)
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 = '89' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/category.php:10
296 (14.436)
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 cp.path_id = '86' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:628
297 (0.428)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=86'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
298 (0.634)
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 = '86' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/category.php:10
299 (14.531)
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 cp.path_id = '96' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:628
300 (0.449)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=96'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
301 (0.634)
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 = '96' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/category.php:10
302 (14.729)
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 cp.path_id = '63' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:628
303 (0.428)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=63'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
304 (0.657)
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 = '63' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/category.php:10
305 (14.361)
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 cp.path_id = '105' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:628
306 (0.445)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=105'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
307 (0.640)
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 = '105' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/category.php:10
308 (14.497)
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 cp.path_id = '91' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:628
309 (0.476)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=91'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
310 (0.669)
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 = '91' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/category.php:10
311 (15.011)
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 cp.path_id = '98' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:628
312 (0.471)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=98'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
313 (0.652)
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 = '98' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/category.php:10
314 (14.702)
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 cp.path_id = '99' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:628
315 (0.481)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=99'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
316 (0.651)
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 = '99' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/category.php:10
317 (14.366)
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 cp.path_id = '104' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:628
318 (0.458)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=104'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
319 (0.670)
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 = '104' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/category.php:10
320 (14.969)
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 cp.path_id = '64' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:628
321 (0.436)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=64'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
322 (0.647)
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 = '64' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/category.php:10
323 (14.318)
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 cp.path_id = '100' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:628
324 (0.448)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=100'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
325 (0.690)
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 = '100' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/category.php:10
326 (14.324)
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 cp.path_id = '65' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:628
327 (0.427)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=65'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
328 (0.640)
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 = '65' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/category.php:10
329 (0.301)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=70'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
330 (0.485)
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)
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/category.php:10
331 (0.293)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=71'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
332 (0.675)
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)
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/category.php:10
333 (14.806)
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 cp.path_id = '92' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:628
334 (0.380)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=92'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
335 (0.612)
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 = '92' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/category.php:10
336 (14.367)
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 cp.path_id = '111' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:628
337 (0.329)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=111'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
338 (0.639)
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 = '111' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/category.php:10
339 (14.173)
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 cp.path_id = '93' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:628
340 (0.429)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=93'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
341 (0.610)
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 = '93' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/category.php:10
342 (14.079)
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 cp.path_id = '75' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:628
343 (0.416)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=75'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
344 (0.754)
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 = '75' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/category.php:10
345 (14.075)
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 cp.path_id = '76' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:628
346 (0.421)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=76'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
347 (0.603)
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 = '76' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/category.php:10
348 (14.042)
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 cp.path_id = '80' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:628
349 (0.418)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=80'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
350 (0.587)
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 = '80' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/category.php:10
351 (14.088)
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 cp.path_id = '78' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:628
352 (0.334)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=78'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
353 (0.579)
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 = '78' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/category.php:10
354 (13.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 cp.path_id = '81' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:628
355 (0.394)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=81'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
356 (0.569)
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 = '81' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/category.php:10
357 (13.829)
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 cp.path_id = '79' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:628
358 (0.395)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=79'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
359 (0.577)
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 = '79' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/category.php:10
360 (13.460)
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 cp.path_id = '102' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:628
361 (0.281)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=102'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
362 (0.510)
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 = '102' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/category.php:10
363 (13.802)
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 cp.path_id = '115' AND pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:628
364 (0.337)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=115'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
365 (0.526)
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 = '115' AND cd.language_id = '4' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/category.php:10
366 (0.293)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=74'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
367 (0.456)
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)
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/category.php:10
368 (0.295)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=84'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
369 (0.251)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=101'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
370 (0.278)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=99'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
371 (0.288)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=84'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
372 (0.243)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=101'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
373 (0.269)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=99'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
374 (0.229)
SELECT *
FROM extension
WHERE `type` = 'total'
/home/garccom/public_html/cuboscubik.com/catalog/model/extension/extension.php:4
375 (0.318)
SELECT setting,module_id
FROM module
WHERE code = 'promotion'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/total/promotion_total.php:163
376 (0.308)
SELECT customer_id
FROM promotion
WHERE promotion_id=80
/home/garccom/public_html/cuboscubik.com/catalog/model/module/promotion.php:85
377 (0.255)
SELECT customer_id
FROM promotion
WHERE promotion_id=79
/home/garccom/public_html/cuboscubik.com/catalog/model/module/promotion.php:85