YuXin



$1.949 mxn

Yuxin se esta especializando en hacer los cubos mas ...
Yuxin se esta especializando en hacer los cubos mas grandes y de mejor movilidad en el mercado, lo hace ahora con un 10x10 que promete suavidad en su giro.Cubos Rubik YuXin 10x10 HuangLong Sti..


$2.150 mxn

Yuxin se esta especializando en hacer los cubos mas ...
Yuxin se esta especializando en hacer los cubos mas grandes y de mejor movilidad en el mercado, lo hace ahora con un 10x10 que promete suavidad en su giro.Cubos Rubik YuXin 10x10 HuangLong Sti..


$159 mxn

Utilizado para el Record Mundial por Collin Bur...
Utilizado para el Record Mundial por Collin Burns.Con su nuevo diseño, con una rapidez inigualable y una estabilidad únicaCon un tiempo de 5.25 segundosNo te quedes sin élCubos Rubik YuXi..


$279 mxn

El grande de Yuxin ahora con luz led integrada en su...
El grande de Yuxin ahora con luz led integrada en su núcleo para que puedas resolverlo sin importar la hora. No puede faltar en tu colección. Cubos Rubik YuXin 3x3 Jueju Big Led ..


$159 mxn

Utilizado para el Record Mundial por Collin Bur...
Utilizado para el Record Mundial por Collin Burns.Con su nuevo diseño, con una rapidez inigualable y una estabilidad únicaCon un tiempo de 5.25 segundosNo te quedes sin élCubos Rubik YuXi..


$109 mxn

Nuevo diseño, con una rapidez inigualable y una esta...
Nuevo diseño, con una rapidez inigualable y una estabilidad única, pero sobre todo precio super económico.No te quedes sin él.Cubos Rubik YuXin 2x2 Golden Unicorn Colored ..


$109 mxn

Nuevo diseño, con una rapidez inigualable y una esta...
Nuevo diseño, con una rapidez inigualable y una estabilidad única, pero sobre todo precio super económico.No te quedes sin él.Cubos Rubik YuXin 2x2 Golden Unicorn Negro Contá..


$99 mxn

Nuevo diseño, con una rapidez inigualable y una esta...
Nuevo diseño, con una rapidez inigualable y una estabilidad única, pero sobre todo precio super económico.No te quedes sin él.Cubos Rubik YuXin 3x3 Fire Unicorn Blanco Contáctanos..


$249 mxn

El Nuevo 4x4 que no deja de estar en boca de todosCu...
El Nuevo 4x4 que no deja de estar en boca de todosCubos Rubik YuXin 4x4 Blue Unicorn BlancoContáctanos por disponibilidad Local: 01(33) 36147823WhatsApp: 3317843484Correo Electrónico:&nbs..


$279 mxn

El Nuevo 5x5 que no deja de estar en boca de todosYu...
El Nuevo 5x5 que no deja de estar en boca de todosYuXin 5x5 Blanco Contáctanos por disponibilidad Local: 01(33) 36147823WhatsApp: 3317843484Correo Electrónico: CubosCubik@gma..


$279 mxn

El Nuevo 5x5 que no deja de estar en boca de todosYu...
El Nuevo 5x5 que no deja de estar en boca de todosYuXin 5x5 Colored Contáctanos por disponibilidad Local: 01(33) 36147823WhatsApp: 3317843484Correo Electrónico: CubosCubik@gmail.c..


$499 mxn

El Nuevo 6x6 que no deja de estar en boca de todosYu...
El Nuevo 6x6 que no deja de estar en boca de todosYuXin 6x6 Red Unicorn Colored Contactanos por disponibilidad Local: 01(33) 36147823WhatsApp: 3317843484Correo Electrónico: C..


$1.429 mxn

La mejor calidad en 9x9, lo mas nuevo del mercado qu...
La mejor calidad en 9x9, lo mas nuevo del mercado que supera a todas las demás marcas También contiene piezas de repuestoCubos Rubik YuXin 9x9 HuangLong Stickerless Contactanos por dis..


$699 mxn

¿Te quieres sorprender con un cubo 7x7? Yuxin lo log...
¿Te quieres sorprender con un cubo 7x7? Yuxin lo logra con la Movilidad de este cubo que sin duda te ayudará a romper todos tus récords personales. También contiene piezas de repuestoCubo..


$259 mxn

El cronometro más novedoso del mercadoNo olvides adq...
El cronometro más novedoso del mercadoNo olvides adquirir tu Tapete Yuxin aquí Cubos Rubik Yuxin Timer Cronometro BlancoContáctanos por disponibilidad Local: 01(33) 36147823What..
Viendo 31 para 45 de 45 (3 Pages)
Queries: 328, Total time: 860.234 ms [By time] [By id] [By file]
1 (0.284)
SELECT *
FROM store
WHERE REPLACE(`url`, 'www.', '') = 'http://cuboscubik.com/'
/home/garccom/public_html/cuboscubik.com/index.php:43
2 (1.794)
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.243)
SELECT *
FROM currency
/home/garccom/public_html/cuboscubik.com/system/library/currency.php:13
5 (0.533)
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.420)
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.327)
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.302)
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.257)
SELECT *
FROM extension
WHERE `type` = 'openbay'
/home/garccom/public_html/cuboscubik.com/system/library/openbay.php:116
10 (0.205)
SELECT *
FROM event
/home/garccom/public_html/cuboscubik.com/index.php:244
11 (0.316)
SELECT *
FROM url_alias
WHERE keyword = 'YuXin-Cubos-Rubik'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:19
12 (0.424)
SELECT *
FROM manufacturer m
LEFT JOIN manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '30' AND m2s.store_id = '0'
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/manufacturer.php:4
13 (0.338)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=30'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
14 (0.322)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=30'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
15 (13.663)
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
16 (1.521)
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
17 (1.213)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '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
18 (1.459)
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
19 (1.206)
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
20 (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 = '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
21 (1.185)
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
22 (1.240)
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 = '1305' 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
23 (1.236)
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
24 (9.275)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '4' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '30'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:628
25 (8.278)
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' AND p.manufacturer_id = '30' 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 30,15
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/catalog/product.php:321
26 (1.450)
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 = '1040' 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
27 (1.238)
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 = '1257' 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
28 (1.680)
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 = '314' 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 (0.326)
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
30 (1.268)
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 = '1027' 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 (0.263)
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
32 (1.395)
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 = '555' 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 (0.258)
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
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 = '559' 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 (0.261)
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
36 (1.272)
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 = '558' 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
37 (0.332)
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
38 (1.511)
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 = '556' 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 (0.334)
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
40 (1.239)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '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 = '922' 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 (0.258)
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
42 (1.221)
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 = '812' 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 (0.261)
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
44 (1.249)
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 = '530' 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 (0.266)
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
46 (1.259)
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 = '953' 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
47 (0.252)
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
48 (1.462)
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 = '992' 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
49 (0.295)
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
50 (1.936)
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 = '1039' 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
51 (0.394)
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
52 (1.627)
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 = '636' 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
53 (0.269)
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
54 (0.342)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=30'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
55 (0.339)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=1040'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
56 (0.326)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=30'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
57 (0.364)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=1257'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
58 (0.427)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=30'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
59 (0.455)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=314'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
60 (0.420)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=30'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
61 (0.463)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=1027'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
62 (0.408)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=30'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
63 (0.486)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=555'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
64 (0.378)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=30'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
65 (0.439)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=559'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
66 (0.404)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=30'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
67 (0.482)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=558'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
68 (0.607)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=30'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
69 (0.448)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=556'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
70 (0.422)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=30'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
71 (0.480)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=922'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
72 (0.310)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=30'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
73 (0.386)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=812'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
74 (0.306)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=30'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
75 (0.330)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=530'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
76 (0.304)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=30'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
77 (0.429)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=953'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
78 (0.301)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=30'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
79 (0.504)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=992'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
80 (0.380)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=30'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
81 (0.435)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=1039'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
82 (0.304)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=30'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
83 (0.347)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=636'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
84 (0.320)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=30'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
85 (0.393)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=30'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
86 (0.306)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=30'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
87 (0.745)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=30'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
88 (0.296)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=30'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
89 (0.319)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=30'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
90 (0.474)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=30'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
91 (0.317)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=30'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
92 (0.283)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=30'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
93 (0.296)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=30'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
94 (0.312)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=30'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
95 (0.276)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=30'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
96 (0.279)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=30'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
97 (0.300)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=30'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
98 (0.287)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=30'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
99 (0.263)
SELECT *
FROM layout_route
WHERE 'product/manufacturer/info' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/garccom/public_html/cuboscubik.com/catalog/model/design/layout.php:4
100 (0.336)
SELECT *
FROM layout_module
WHERE layout_id = '4' AND position = 'column_left'
ORDER BY sort_order
/home/garccom/public_html/cuboscubik.com/catalog/model/design/layout.php:14
101 (0.272)
SELECT *
FROM module
WHERE module_id = '58'
/home/garccom/public_html/cuboscubik.com/catalog/model/extension/module.php:4
102 (17.985)
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
103 (2.153)
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
104 (1.365)
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
105 (1.677)
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
106 (1.321)
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
107 (1.289)
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
108 (2.282)
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
109 (1.418)
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 = '1305' 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
110 (1.249)
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
111 (0.437)
SELECT COUNT(*) AS total
FROM review r
LEFT JOIN product p ON (r.product_id = p.product_id)
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
WHERE p.product_id = '274' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '4'
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/review.php:61
112 (0.615)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=11'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
113 (0.390)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=274'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
114 (0.419)
SELECT COUNT(*) AS total
FROM review r
LEFT JOIN product p ON (r.product_id = p.product_id)
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
WHERE p.product_id = '341' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '4'
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/review.php:61
115 (0.321)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=7'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
116 (0.445)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=341'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
117 (0.347)
SELECT COUNT(*) AS total
FROM review r
LEFT JOIN product p ON (r.product_id = p.product_id)
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
WHERE p.product_id = '61' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '4'
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/review.php:61
118 (0.292)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=5'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
119 (0.354)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=61'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
120 (0.325)
SELECT COUNT(*) AS total
FROM review r
LEFT JOIN product p ON (r.product_id = p.product_id)
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
WHERE p.product_id = '64' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '4'
/home/garccom/public_html/cuboscubik.com/catalog/model/catalog/review.php:61
121 (0.298)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=5'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
122 (0.535)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=64'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
123 (0.278)
SELECT *
FROM layout_route
WHERE 'product/manufacturer/info' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/garccom/public_html/cuboscubik.com/catalog/model/design/layout.php:4
124 (0.253)
SELECT *
FROM layout_module
WHERE layout_id = '4' AND position = 'column_right'
ORDER BY sort_order
/home/garccom/public_html/cuboscubik.com/catalog/model/design/layout.php:14
125 (0.248)
SELECT *
FROM layout_route
WHERE 'product/manufacturer/info' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/garccom/public_html/cuboscubik.com/catalog/model/design/layout.php:4
126 (0.231)
SELECT *
FROM layout_module
WHERE layout_id = '4' AND position = 'content_top'
ORDER BY sort_order
/home/garccom/public_html/cuboscubik.com/catalog/model/design/layout.php:14
127 (0.229)
SELECT *
FROM layout_route
WHERE 'product/manufacturer/info' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/garccom/public_html/cuboscubik.com/catalog/model/design/layout.php:4
128 (0.236)
SELECT *
FROM layout_module
WHERE layout_id = '4' AND position = 'content_bottom'
ORDER BY sort_order
/home/garccom/public_html/cuboscubik.com/catalog/model/design/layout.php:14
129 (2.375)
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
130 (0.367)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=4'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
131 (0.271)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=18'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
132 (0.290)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=58'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
133 (0.282)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=23'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
134 (0.325)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=5'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
135 (0.265)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=17'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
136 (0.301)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=6'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
137 (0.285)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=60'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
138 (0.266)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=16'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
139 (0.267)
SELECT *
FROM layout_route
WHERE 'product/manufacturer/info' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/garccom/public_html/cuboscubik.com/catalog/model/design/layout.php:4
140 (0.270)
SELECT *
FROM layout_module
WHERE layout_id = '4' AND position = 'footer_top'
ORDER BY sort_order
/home/garccom/public_html/cuboscubik.com/catalog/model/design/layout.php:14
141 (0.371)
DELETE
FROM `customer_online`
WHERE date_added < '2018-04-24 16:24:51'
/home/garccom/public_html/cuboscubik.com/catalog/model/tool/online.php:4
142 (0.254)
SELECT COUNT(*) AS total
FROM `customer_online`
WHERE `ip` = '54.198.122.70'
/home/garccom/public_html/cuboscubik.com/catalog/model/tool/online.php:6
143 (1.990)
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
144 (0.330)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=4'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
145 (0.333)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=18'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
146 (0.357)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=58'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
147 (0.334)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=23'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
148 (0.322)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=5'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
149 (74.559)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=17'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
150 (0.402)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=6'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
151 (0.387)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=60'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
152 (0.315)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=16'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
153 (1.099)
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
154 (0.513)
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
155 (0.335)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=73'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
156 (0.488)
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
157 (0.315)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=66'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
158 (0.469)
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
159 (0.312)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=67'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
160 (0.463)
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
161 (0.308)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=68'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
162 (0.464)
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
163 (0.294)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=69'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
164 (0.663)
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
165 (0.323)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=84'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
166 (0.297)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=112'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
167 (0.297)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=84'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
168 (0.287)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=60'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
169 (0.297)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=84'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
170 (0.306)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=62'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
171 (0.319)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=84'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
172 (0.295)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=90'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
173 (0.296)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=84'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
174 (0.285)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=59'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
175 (0.290)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=84'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
176 (0.270)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=101'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
177 (0.308)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=84'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
178 (0.517)
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
179 (0.322)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=70'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
180 (0.704)
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
181 (0.313)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=71'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
182 (0.343)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=92'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
183 (0.340)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=71'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
184 (0.276)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=111'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
185 (0.302)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=71'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
186 (0.303)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=93'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
187 (0.290)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=71'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
188 (0.289)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=75'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
189 (0.287)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=71'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
190 (0.269)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=102'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
191 (0.296)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=71'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
192 (0.285)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=115'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
193 (0.330)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=71'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
194 (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 = '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
195 (0.390)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=74'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
196 (1.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 = '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
197 (0.416)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=73'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
198 (0.715)
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
199 (0.385)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=66'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
200 (0.503)
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
201 (0.288)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=67'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
202 (0.846)
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
203 (0.316)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=68'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
204 (0.491)
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
205 (0.304)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=69'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
206 (0.560)
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
207 (0.317)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=84'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
208 (0.729)
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
209 (16.875)
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
210 (0.342)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=112'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
211 (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 = '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
212 (20.206)
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
213 (0.466)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=60'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
214 (0.567)
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
215 (17.228)
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
216 (0.613)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=62'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
217 (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 = '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
218 (16.483)
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
219 (0.452)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=90'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
220 (0.607)
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
221 (16.061)
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
222 (0.354)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=59'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
223 (0.623)
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
224 (17.151)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM category_path cp
LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN product p ON (p2c.product_id = p.product_id)
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE 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
225 (0.366)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=101'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
226 (1.077)
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
227 (17.457)
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
228 (0.332)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=61'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
229 (0.825)
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
230 (19.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 = '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
231 (0.426)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=88'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
232 (0.563)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '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
233 (17.449)
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
234 (0.443)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=97'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
235 (0.660)
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
236 (15.837)
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
237 (0.483)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=95'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
238 (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 = '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
239 (17.917)
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
240 (0.425)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=87'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
241 (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 = '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
242 (16.868)
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
243 (0.379)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=106'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
244 (0.691)
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
245 (16.019)
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
246 (0.425)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=72'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
247 (0.588)
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
248 (15.200)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM category_path cp
LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN product p ON (p2c.product_id = p.product_id)
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE 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
249 (0.502)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=89'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
250 (0.846)
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
251 (17.185)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM category_path cp
LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN product p ON (p2c.product_id = p.product_id)
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE 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
252 (0.604)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=86'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
253 (0.663)
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
254 (17.040)
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
255 (0.410)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=96'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
256 (0.576)
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
257 (17.589)
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
258 (0.549)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=63'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
259 (0.661)
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
260 (18.996)
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
261 (0.427)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=105'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
262 (0.613)
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
263 (14.867)
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
264 (0.440)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=91'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
265 (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 = '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
266 (14.885)
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
267 (0.411)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=98'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
268 (0.626)
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
269 (15.067)
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
270 (0.376)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=99'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
271 (0.601)
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
272 (16.182)
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
273 (0.311)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=104'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
274 (0.662)
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
275 (20.034)
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
276 (0.342)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=64'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
277 (0.615)
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
278 (14.908)
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
279 (0.317)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=100'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
280 (0.915)
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
281 (14.523)
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
282 (0.364)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=65'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
283 (0.574)
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
284 (0.300)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=70'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
285 (0.501)
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
286 (0.325)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=71'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
287 (0.660)
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
288 (14.407)
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
289 (0.331)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=92'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
290 (0.517)
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
291 (14.121)
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
292 (0.318)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=111'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
293 (0.498)
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
294 (13.865)
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
295 (0.335)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=93'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
296 (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 = '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
297 (17.059)
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
298 (0.353)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=75'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
299 (0.685)
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
300 (14.348)
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
301 (0.316)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=76'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
302 (0.520)
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
303 (14.007)
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
304 (0.329)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=80'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
305 (0.501)
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
306 (14.036)
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
307 (0.316)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=78'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
308 (0.489)
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
309 (14.136)
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
310 (0.378)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=81'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
311 (0.586)
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
312 (14.379)
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
313 (0.339)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=79'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
314 (0.561)
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
315 (15.956)
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
316 (0.405)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=102'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
317 (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 = '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
318 (14.620)
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
319 (0.324)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=115'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
320 (0.545)
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
321 (0.300)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=74'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:95
322 (0.488)
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
323 (0.339)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=30'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
324 (0.334)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=30'
/home/garccom/public_html/cuboscubik.com/catalog/controller/common/seo_url.php:84
325 (0.257)
SELECT *
FROM extension
WHERE `type` = 'total'
/home/garccom/public_html/cuboscubik.com/catalog/model/extension/extension.php:4
326 (0.269)
SELECT setting,module_id
FROM module
WHERE code = 'promotion'
/home/garccom/public_html/cuboscubik.com/system/modification/catalog/model/total/promotion_total.php:163
327 (0.276)
SELECT customer_id
FROM promotion
WHERE promotion_id=80
/home/garccom/public_html/cuboscubik.com/catalog/model/module/promotion.php:85
328 (0.243)
SELECT customer_id
FROM promotion
WHERE promotion_id=79
/home/garccom/public_html/cuboscubik.com/catalog/model/module/promotion.php:85