CATEGORII
> Producător > REGA > REGA - RP1 Union Flag Edition
Pick-up Stereo + Performance Pack - CEL MAI BUN PICK-UP DIN LUME LA CATEGORIA SA DE PRET

REGA

RP1 Union Flag Edition

Pick-up Stereo + Performance Pack - CEL MAI BUN PICK-UP DIN LUME LA CATEGORIA SA DE PRET

Unic distribuitor Premiera absoluta
Made in England REGA 40 YEARS BEST BUY 5 STARS WHAT HIFI - SOUND AND VISION WHAT HIFI GROUP TEST WINNER HIFI CHOICE GROUPTEST WINNER STEREOPHILE RECOMMENDED COMPONENT HIFI NEWS OUTSTANDING PRODUCT
2,199.00 RON (TVA inclus) Compara
Cantitate:
Stoc:DISPONIBIL
CEL MAI BINE VANDUT PICK-UP DIN LUME SI DIN ROMANIA -
RECORD ABSOLUT DE VANZARI IN PRIMELE 4 LUNI DE LA APARITIA PRODUSULUI: 200 BUCATI !!!

Adevarata legenda vie a pietei Hi-Fi europene si mondiale, Rega, este prezenta de acum si in Romania, datorita parteneriatului cu STEREO PLANET.

Recunoscuta pentru calitatea impecabila a produselor sale, Rega isi selecteaza foarte riguros partenerii.
Este unul din putinele Brand-uri care-si permit sa-si selecteze Distribuitorii dupa criterii legate atat de competitivitatea acestora pe pietele in care activeaza cat si legate de calitatea oamenilor si principiilor din spatele acestor Distribuitori.
Tocmai de aceea, NE ONOREAZA acest parteneriat.

For over 30 years, Rega has been the first name on everyone's lips when it comes to turntables.
With the new RP1, Rega quality is now available at the lowest price ever.

Replacing the hugely successful P1 the RP1 has been designed and engineered to achieve
outstanding performance way beyond the expectations of a product at this price point.
Excellent build quality, reliability and ease of use combine to make a product which if used
correctly will offer a lifetime of musical enjoyment.
Omitting all the usual gimmicks allows us to concentrate the manufacturing costs on the
high quality parts necessary to reproduce records accurately. Using a manual speed change
rather than an automatic mechanism, eliminates speed inconsistencies and reduces wear of the drive belt.
The money Rega save is spent across the design including a new hand assembled
RB101 tonearm, precision main bearing, phenolic resin platter and a high quality
low vibration motor which would normally be used on a turntable costing two or three times the amount.

The minimalist design of the Rega RP1 and the use of extremely high quality components
ensure that this turntable will last for many years.

The RP1 is available in three new high quality finishes at no extra cost which can be ordered in any split you require.

The RP1 is the first in a new generation of Rega turntables offering far greater performance
than their predecessors.
Rega is confident the performance of this amazing new product will impress you.
Rest assured the only thing entry level about the RP1 is the price!

NOTA:
Capacul din acryl pentru protectia impotriva prafului ESTE inclus in cutie si in pretul produsului.
Pretul include Performance Pack.
Specifications
100% Plug and Play design
High performance RB101 Tonearm
High performance Phenolic resin platter
Bias2 cartridge fitted as standard

Color: White Union Flag

NOTA:
Capacul din acryl pentru protectia impotriva prafului ESTE inclus in cutie si in pretul produsului.
Pretul include Performance Pack.
Producator: Produs:
Imagine
Pick-up Stereo + Performance Pack - CEL MAI BUN PICK-UP DIN LUME LA CATEGORIA SA DE PRET
Produs REGA
Pick-up Stereo + Performance Pack - CEL MAI BUN PICK-UP DIN LUME LA CATEGORIA SA DE PRET
RP1 Union Flag Edition
Descriere CEL MAI BINE VANDUT PICK-UP DIN LUME SI DIN ROMANIA -
RECORD ABSOLUT DE VANZARI IN PRIMELE 4 LUNI DE LA APARITIA PRODUSULUI: 200 BUCATI !!!

Adevarata legenda vie a pietei Hi-Fi europene si mondiale, Rega, este prezenta de acum si in Romania, datorita parteneriatului cu STEREO PLANET.

Recunoscuta pentru calitatea impecabila a produselor sale, Rega isi selecteaza foarte riguros partenerii.
Specificatii Specifications
100% Plug and Play design
High performance RB101 Tonearm
High performance Phenolic resin platter
Bias2 cartridge fitted as standard

Color: White Union Flag

NOTA:
Capacul din acryl pentru protectia impotriva prafului ESTE inclus in cutie si in pretul produsului.
Pretul include Performance Pack.
Premii
DVDPLANET DVDPLANET DVDPLANET DVDPLANET DVDPLANET
Preţ: 2,199.00 RON (TVA inclus)
Disponibilitate Disponibil
REVIEWS CLIENTI
Adauga review
Ascunde review

Spune-ţi opinia

Numele tău:


Numarul de telefon:


Email-ul:


Opinia ta: Notă: Codul HTML este citit ca şi text!

Nota: Rău           Bun

Introduceţi codul din imagine:



Continuare
Queries: 300, Total time: 1,420.558 ms [By time] [By id] [By file]
1 (0.220)
SELECT *
FROM store
WHERE store_id = 0
/home/stereoplanet/public_html/index.php:112
2 (0.964)
SELECT *
FROM setting
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC
/home/stereoplanet/public_html/index.php:122
3 (0.134)
SELECT *
FROM language
WHERE status = '1'
/home/stereoplanet/public_html/index.php:203
4 (0.139)
SELECT *
FROM currency
/home/stereoplanet/public_html/system/library/currency.php:13
5 (0.202)
SELECT *
FROM weight_class wc
LEFT JOIN weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id)
WHERE wcd.language_id = '2'
/home/stereoplanet/public_html/system/library/weight.php:9
6 (0.120)
SELECT *
FROM length_class mc
LEFT JOIN length_class_description mcd ON (mc.length_class_id = mcd.length_class_id)
WHERE mcd.language_id = '2'
/home/stereoplanet/public_html/system/library/length.php:9
7 (0.193)
SELECT *
FROM url_alias
WHERE keyword = 'rega'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:55
8 (0.120)
SELECT *
FROM url_alias
WHERE keyword = 'rega_rp1_union_flag_edition'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:55
9 (0.299)
SELECT m.*,m2s.store_id
FROM manufacturer m
LEFT JOIN manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '163' AND m2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/manufacturer.php:11
10 (0.280)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=163'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
11 (1.485)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, p.warranty, (SELECT price
FROM product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start <= NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '9591' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:145
12 (0.184)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=163'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
13 (0.121)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=9591'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
14 (0.157)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=9591'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
15 (0.199)
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 = '9591' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '2'
/home/stereoplanet/public_html/catalog/model/catalog/review.php:50
16 (0.179)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=163'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
17 (4.367)
SELECT r.review_id, r.author, r.name as rname, r.rating, pra.text, p.product_id, pd.name, p.price, p.image, r.date_added, r.image AS review_img, pra.file
FROM review_awards r
LEFT JOIN product_review_awards pra ON (pra.review_awards_id = r.review_id)
LEFT JOIN product p ON (pra.product_id = p.product_id)
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
WHERE p.product_id = '9591' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '2'
ORDER BY pra.sort_order ASC, pra.data_added DESC LIMIT 0,20
/home/stereoplanet/public_html/catalog/model/catalog/review_award.php:36
18 (4.287)
SELECT r.review_id, r.author, r.name as rname, r.rating, pra.text, p.product_id, pd.name, p.price, p.image, r.date_added, r.image AS review_img, pra.file
FROM review_awards r
LEFT JOIN product_review_awards pra ON (pra.review_awards_id = r.review_id)
LEFT JOIN product p ON (pra.product_id = p.product_id)
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
WHERE p.product_id = '9591' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '2' AND r.show_bottom = 1
ORDER BY pra.sort_order ASC, pra.data_added DESC LIMIT 0,20
/home/stereoplanet/public_html/catalog/model/catalog/review_award.php:36
19 (0.135)
SELECT *
FROM `review_awards`
WHERE `review_id` = 27 or `review_id` = 28 or `review_id` = 74;
/home/stereoplanet/public_html/catalog/model/catalog/product.php:117
20 (1.609)
SELECT *
FROM product_image
WHERE product_id = '9591'
ORDER BY sort_order ASC
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2077
21 (0.253)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '175' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2688')
ORDER BY tr1.priority ASC
/home/stereoplanet/public_html/system/library/tax.php:91
22 (0.185)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '175' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2688')
ORDER BY tr1.priority ASC
/home/stereoplanet/public_html/system/library/tax.php:119
23 (0.105)
SELECT *
FROM product_discount
WHERE product_id = '9591' AND customer_group_id = '1' AND quantity > 1 AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY quantity ASC, priority ASC, price ASC
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2071
24 (0.160)
SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
LEFT JOIN option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '9591' AND od.language_id = '2'
ORDER BY o.sort_order
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2018
25 (0.248)
SELECT ag.attribute_group_id, agd.name
FROM product_attribute pa
LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '9591' AND agd.language_id = '2' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/stereoplanet/public_html/catalog/model/catalog/product.php:1990
26 (0.209)
SELECT *
FROM product_related pr
LEFT JOIN product p ON (pr.related_id = p.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pr.product_id = '9591' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2085
27 (0.130)
UPDATE product SET viewed = (viewed + 1)
WHERE product_id = '9591'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:4
28 (0.136)
SELECT *
FROM product_to_layout
WHERE product_id = '9591' AND store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2095
29 (0.115)
SELECT *
FROM layout_route
WHERE 'product/product' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route ASC LIMIT 1
/home/stereoplanet/public_html/catalog/model/design/layout.php:4
30 (0.131)
SELECT *
FROM extension
WHERE `type` = 'module'
/home/stereoplanet/public_html/catalog/model/setting/extension.php:4
31 (0.521)
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 = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/stereoplanet/public_html/catalog/model/catalog/category.php:10
32 (0.283)
SELECT *
FROM banner_image bi
LEFT JOIN banner_image_description bid ON (bi.banner_image_id = bid.banner_image_id)
WHERE bi.banner_id = '6' AND bid.language_id = '2'
ORDER BY bi.sort_order ASC, bid.title ASC
/home/stereoplanet/public_html/catalog/model/design/banner.php:5
33 (0.148)
CREATE TABLE IF NOT EXISTS subscribe ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `email_id` varchar(225) NOT NULL, `name` varchar(225) NOT NULL, `option1` varchar(225) NOT NULL, `option2` varchar(225) NOT NULL, `option3` varchar(225) NOT NULL, `option4` varchar(225) NOT NULL, `option5` varchar(225) NOT NULL, `option6` varchar(225) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `Index_2` (`email_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/home/stereoplanet/public_html/catalog/model/account/newslettersubscribe.php:46
34 (0.111)
SELECT *
FROM product_to_layout
WHERE product_id = '9591' AND store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2095
35 (0.127)
SELECT *
FROM layout_route
WHERE 'product/product' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route ASC LIMIT 1
/home/stereoplanet/public_html/catalog/model/design/layout.php:4
36 (0.130)
SELECT *
FROM extension
WHERE `type` = 'module'
/home/stereoplanet/public_html/catalog/model/setting/extension.php:4
37 (0.104)
SELECT *
FROM product_to_layout
WHERE product_id = '9591' AND store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2095
38 (0.118)
SELECT *
FROM layout_route
WHERE 'product/product' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route ASC LIMIT 1
/home/stereoplanet/public_html/catalog/model/design/layout.php:4
39 (0.130)
SELECT *
FROM extension
WHERE `type` = 'module'
/home/stereoplanet/public_html/catalog/model/setting/extension.php:4
40 (0.099)
SELECT *
FROM product_to_layout
WHERE product_id = '9591' AND store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2095
41 (0.119)
SELECT *
FROM layout_route
WHERE 'product/product' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route ASC LIMIT 1
/home/stereoplanet/public_html/catalog/model/design/layout.php:4
42 (0.132)
SELECT *
FROM extension
WHERE `type` = 'module'
/home/stereoplanet/public_html/catalog/model/setting/extension.php:4
43 (0.092)
SELECT *
FROM extension
WHERE `type` = 'module'
/home/stereoplanet/public_html/catalog/model/setting/extension.php:4
44 (4.302)
SELECT *
FROM banner_image bi
LEFT JOIN banner_image_description bid ON ( bi.banner_image_id = bid.banner_image_id )
LEFT JOIN ( SELECT `manufacturer_id` , CONCAT( 'index.php?route=product/manufacturer/info&manufacturer_id=', manufacturer.manufacturer_id ) AS manlink, CONCAT( 'manufacturer_id=', manufacturer.manufacturer_id ) AS manquery
FROM `manufacturer` ) AS tmpman ON ( tmpman.manlink = bi.link )
LEFT JOIN url_alias ua ON ( tmpman.manquery = ua.query )
WHERE bi.banner_id = '8' AND bid.language_id = '2'
ORDER BY bi.sort_order ASC , bid.title ASC
/home/stereoplanet/public_html/catalog/model/design/banner.php:22
45 (0.605)
SELECT *
FROM information i
LEFT JOIN information_description id ON (i.information_id = id.information_id)
LEFT JOIN information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE id.language_id = '2' AND i2s.store_id = '0' AND i.status = '1'
ORDER BY CAST(i.sort_order AS CHAR), LCASE(id.title) ASC
/home/stereoplanet/public_html/catalog/model/catalog/information.php:31
46 (0.159)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=23'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
47 (0.122)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=5'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
48 (0.123)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=4'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
49 (0.124)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=25'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
50 (0.126)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=6'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
51 (0.130)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=3'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
52 (0.414)
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 = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/stereoplanet/public_html/catalog/model/catalog/category.php:10
53 (0.598)
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 = '14' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/stereoplanet/public_html/catalog/model/catalog/category.php:10
54 (0.109)
SELECT category_id
FROM category
WHERE parent_id = '248'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
55 (0.068)
SELECT category_id
FROM category
WHERE parent_id = '328'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
56 (0.076)
SELECT category_id
FROM category
WHERE parent_id = '330'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
57 (0.072)
SELECT category_id
FROM category
WHERE parent_id = '331'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
58 (36.483)
SELECT COUNT(DISTINCT p2c.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)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) AND p2c.category_id IN (248, 328, 330, 331)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2159
59 (0.166)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
60 (0.111)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=248'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
61 (0.086)
SELECT category_id
FROM category
WHERE parent_id = '261'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
62 (0.068)
SELECT category_id
FROM category
WHERE parent_id = '332'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
63 (0.061)
SELECT category_id
FROM category
WHERE parent_id = '333'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
64 (0.060)
SELECT category_id
FROM category
WHERE parent_id = '334'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
65 (34.511)
SELECT COUNT(DISTINCT p2c.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)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) AND p2c.category_id IN (261, 332, 333, 334)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2159
66 (0.145)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
67 (0.128)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=261'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
68 (0.088)
SELECT category_id
FROM category
WHERE parent_id = '255'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
69 (0.070)
SELECT category_id
FROM category
WHERE parent_id = '335'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
70 (0.066)
SELECT category_id
FROM category
WHERE parent_id = '336'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
71 (0.066)
SELECT category_id
FROM category
WHERE parent_id = '337'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
72 (34.503)
SELECT COUNT(DISTINCT p2c.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)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) AND p2c.category_id IN (255, 335, 336, 337)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2159
73 (0.164)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
74 (0.131)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=255'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
75 (0.094)
SELECT category_id
FROM category
WHERE parent_id = '268'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
76 (30.262)
SELECT COUNT(DISTINCT p2c.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)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) AND p2c.category_id IN (268)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2159
77 (0.155)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
78 (0.132)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=268'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
79 (0.091)
SELECT category_id
FROM category
WHERE parent_id = '516'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
80 (30.330)
SELECT COUNT(DISTINCT p2c.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)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) AND p2c.category_id IN (516)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2159
81 (0.157)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
82 (0.163)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=516'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
83 (0.102)
SELECT category_id
FROM category
WHERE parent_id = '249'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
84 (0.082)
SELECT category_id
FROM category
WHERE parent_id = '338'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
85 (0.082)
SELECT category_id
FROM category
WHERE parent_id = '339'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
86 (34.223)
SELECT COUNT(DISTINCT p2c.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)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) AND p2c.category_id IN (249, 338, 339)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2159
87 (0.163)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
88 (0.131)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=249'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
89 (0.120)
SELECT category_id
FROM category
WHERE parent_id = '262'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
90 (0.085)
SELECT category_id
FROM category
WHERE parent_id = '340'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
91 (0.078)
SELECT category_id
FROM category
WHERE parent_id = '341'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
92 (36.673)
SELECT COUNT(DISTINCT p2c.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)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) AND p2c.category_id IN (262, 340, 341)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2159
93 (0.137)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
94 (0.111)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=262'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
95 (0.080)
SELECT category_id
FROM category
WHERE parent_id = '259'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
96 (30.517)
SELECT COUNT(DISTINCT p2c.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)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) AND p2c.category_id IN (259)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2159
97 (0.160)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
98 (0.135)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=259'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
99 (0.093)
SELECT category_id
FROM category
WHERE parent_id = '271'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
100 (30.165)
SELECT COUNT(DISTINCT p2c.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)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) AND p2c.category_id IN (271)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2159
101 (0.179)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
102 (0.136)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=271'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
103 (0.098)
SELECT category_id
FROM category
WHERE parent_id = '269'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
104 (30.168)
SELECT COUNT(DISTINCT p2c.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)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) AND p2c.category_id IN (269)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2159
105 (0.159)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
106 (0.140)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=269'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
107 (0.091)
SELECT category_id
FROM category
WHERE parent_id = '487'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
108 (30.332)
SELECT COUNT(DISTINCT p2c.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)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) AND p2c.category_id IN (487)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2159
109 (0.164)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
110 (0.157)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=487'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
111 (0.095)
SELECT category_id
FROM category
WHERE parent_id = '272'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
112 (30.227)
SELECT COUNT(DISTINCT p2c.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)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) AND p2c.category_id IN (272)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2159
113 (0.588)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
114 (0.315)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=272'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
115 (0.256)
SELECT category_id
FROM category
WHERE parent_id = '273'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
116 (31.615)
SELECT COUNT(DISTINCT p2c.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)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) AND p2c.category_id IN (273)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2159
117 (0.163)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
118 (0.150)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=273'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
119 (0.093)
SELECT category_id
FROM category
WHERE parent_id = '256'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
120 (30.367)
SELECT COUNT(DISTINCT p2c.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)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) AND p2c.category_id IN (256)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2159
121 (0.161)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
122 (0.158)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=256'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
123 (0.090)
SELECT category_id
FROM category
WHERE parent_id = '486'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
124 (30.287)
SELECT COUNT(DISTINCT p2c.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)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) AND p2c.category_id IN (486)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2159
125 (0.140)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
126 (0.154)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=486'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
127 (0.098)
SELECT category_id
FROM category
WHERE parent_id = '263'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
128 (30.263)
SELECT COUNT(DISTINCT p2c.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)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) AND p2c.category_id IN (263)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2159
129 (0.136)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
130 (0.132)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=263'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
131 (0.088)
SELECT category_id
FROM category
WHERE parent_id = '434'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
132 (30.389)
SELECT COUNT(DISTINCT p2c.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)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) AND p2c.category_id IN (434)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2159
133 (0.139)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
134 (0.145)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=434'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
135 (0.090)
SELECT category_id
FROM category
WHERE parent_id = '435'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
136 (30.441)
SELECT COUNT(DISTINCT p2c.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)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) AND p2c.category_id IN (435)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2159
137 (0.144)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
138 (0.148)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=435'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
139 (0.089)
SELECT category_id
FROM category
WHERE parent_id = '278'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
140 (30.454)
SELECT COUNT(DISTINCT p2c.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)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) AND p2c.category_id IN (278)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2159
141 (0.162)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
142 (0.137)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=278'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
143 (0.092)
SELECT category_id
FROM category
WHERE parent_id = '446'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
144 (33.360)
SELECT COUNT(DISTINCT p2c.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)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) AND p2c.category_id IN (446)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2159
145 (0.325)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
146 (0.169)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=446'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
147 (0.124)
SELECT category_id
FROM category
WHERE parent_id = '251'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
148 (0.090)
SELECT category_id
FROM category
WHERE parent_id = '342'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
149 (0.087)
SELECT category_id
FROM category
WHERE parent_id = '343'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
150 (0.086)
SELECT category_id
FROM category
WHERE parent_id = '344'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
151 (35.413)
SELECT COUNT(DISTINCT p2c.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)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) AND p2c.category_id IN (251, 342, 343, 344)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2159
152 (0.158)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
153 (0.133)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=251'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
154 (0.090)
SELECT category_id
FROM category
WHERE parent_id = '252'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
155 (30.481)
SELECT COUNT(DISTINCT p2c.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)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) AND p2c.category_id IN (252)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2159
156 (0.156)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
157 (0.139)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=252'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
158 (0.089)
SELECT category_id
FROM category
WHERE parent_id = '250'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
159 (31.749)
SELECT COUNT(DISTINCT p2c.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)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) AND p2c.category_id IN (250)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2159
160 (0.166)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
161 (0.136)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=250'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
162 (0.124)
SELECT category_id
FROM category
WHERE parent_id = '510'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
163 (0.099)
SELECT category_id
FROM category
WHERE parent_id = '450'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
164 (0.097)
SELECT category_id
FROM category
WHERE parent_id = '451'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
165 (0.089)
SELECT category_id
FROM category
WHERE parent_id = '452'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
166 (0.088)
SELECT category_id
FROM category
WHERE parent_id = '453'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
167 (0.091)
SELECT category_id
FROM category
WHERE parent_id = '455'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
168 (0.092)
SELECT category_id
FROM category
WHERE parent_id = '456'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
169 (0.086)
SELECT category_id
FROM category
WHERE parent_id = '457'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
170 (0.095)
SELECT category_id
FROM category
WHERE parent_id = '458'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
171 (0.101)
SELECT category_id
FROM category
WHERE parent_id = '459'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
172 (0.092)
SELECT category_id
FROM category
WHERE parent_id = '460'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
173 (0.093)
SELECT category_id
FROM category
WHERE parent_id = '461'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
174 (0.091)
SELECT category_id
FROM category
WHERE parent_id = '464'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
175 (0.086)
SELECT category_id
FROM category
WHERE parent_id = '491'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
176 (34.876)
SELECT COUNT(DISTINCT p2c.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)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) AND p2c.category_id IN (510, 450, 451, 452, 453, 455, 456, 457, 458, 459, 460, 461, 464, 491)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2159
177 (0.153)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
178 (0.162)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=510'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
179 (0.089)
SELECT category_id
FROM category
WHERE parent_id = '513'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
180 (30.187)
SELECT COUNT(DISTINCT p2c.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)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) AND p2c.category_id IN (513)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2159
181 (0.150)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
182 (0.155)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=513'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
183 (0.093)
SELECT category_id
FROM category
WHERE parent_id = '462'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
184 (33.016)
SELECT COUNT(DISTINCT p2c.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)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) AND p2c.category_id IN (462)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2159
185 (0.320)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
186 (0.161)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=462'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
187 (0.106)
SELECT category_id
FROM category
WHERE parent_id = '463'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
188 (35.327)
SELECT COUNT(DISTINCT p2c.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)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) AND p2c.category_id IN (463)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2159
189 (0.203)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
190 (0.156)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=463'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
191 (0.120)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
192 (0.669)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '40' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/stereoplanet/public_html/catalog/model/catalog/category.php:10
193 (0.111)
SELECT category_id
FROM category
WHERE parent_id = '274'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
194 (30.819)
SELECT COUNT(DISTINCT p2c.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)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) AND p2c.category_id IN (274)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2159
195 (0.158)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=40'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
196 (0.133)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=274'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
197 (0.089)
SELECT category_id
FROM category
WHERE parent_id = '290'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
198 (30.870)
SELECT COUNT(DISTINCT p2c.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)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) AND p2c.category_id IN (290)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2159
199 (0.191)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=40'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
200 (0.147)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=290'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
201 (0.088)
SELECT category_id
FROM category
WHERE parent_id = '292'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
202 (30.560)
SELECT COUNT(DISTINCT p2c.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)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) AND p2c.category_id IN (292)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2159
203 (0.176)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=40'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
204 (0.470)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=292'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
205 (0.214)
SELECT category_id
FROM category
WHERE parent_id = '293'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
206 (30.788)
SELECT COUNT(DISTINCT p2c.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)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) AND p2c.category_id IN (293)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2159
207 (0.210)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=40'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
208 (0.131)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=293'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
209 (0.091)
SELECT category_id
FROM category
WHERE parent_id = '257'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
210 (0.067)
SELECT category_id
FROM category
WHERE parent_id = '385'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
211 (0.064)
SELECT category_id
FROM category
WHERE parent_id = '386'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
212 (0.062)
SELECT category_id
FROM category
WHERE parent_id = '387'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
213 (34.433)
SELECT COUNT(DISTINCT p2c.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)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) AND p2c.category_id IN (257, 385, 386, 387)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2159
214 (0.166)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=40'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
215 (0.113)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=257'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
216 (0.077)
SELECT category_id
FROM category
WHERE parent_id = '275'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
217 (29.930)
SELECT COUNT(DISTINCT p2c.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)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) AND p2c.category_id IN (275)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2159
218 (0.150)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=40'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
219 (0.110)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=275'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
220 (0.088)
SELECT category_id
FROM category
WHERE parent_id = '279'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
221 (0.068)
SELECT category_id
FROM category
WHERE parent_id = '518'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
222 (0.075)
SELECT category_id
FROM category
WHERE parent_id = '389'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
223 (0.076)
SELECT category_id
FROM category
WHERE parent_id = '390'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
224 (0.065)
SELECT category_id
FROM category
WHERE parent_id = '391'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
225 (0.063)
SELECT category_id
FROM category
WHERE parent_id = '440'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
226 (0.063)
SELECT category_id
FROM category
WHERE parent_id = '447'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
227 (34.695)
SELECT COUNT(DISTINCT p2c.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)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) AND p2c.category_id IN (279, 518, 389, 390, 391, 440, 447)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2159
228 (0.175)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=40'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
229 (0.118)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=279'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
230 (0.075)
SELECT category_id
FROM category
WHERE parent_id = '514'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
231 (30.249)
SELECT COUNT(DISTINCT p2c.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)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) AND p2c.category_id IN (514)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2159
232 (0.183)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=40'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
233 (0.146)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=514'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
234 (0.073)
SELECT category_id
FROM category
WHERE parent_id = '519'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
235 (30.161)
SELECT COUNT(DISTINCT p2c.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)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) AND p2c.category_id IN (519)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2159
236 (0.154)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=40'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
237 (0.149)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=519'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
238 (0.076)
SELECT category_id
FROM category
WHERE parent_id = '294'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
239 (30.068)
SELECT COUNT(DISTINCT p2c.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)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) AND p2c.category_id IN (294)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2159
240 (0.158)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=40'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
241 (0.116)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=294'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
242 (0.119)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=40'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
243 (0.585)
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 = '30' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/stereoplanet/public_html/catalog/model/catalog/category.php:10
244 (0.104)
SELECT category_id
FROM category
WHERE parent_id = '233'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
245 (30.067)
SELECT COUNT(DISTINCT p2c.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)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) AND p2c.category_id IN (233)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2159
246 (0.145)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=30'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
247 (0.106)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=233'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
248 (0.085)
SELECT category_id
FROM category
WHERE parent_id = '266'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
249 (0.072)
SELECT category_id
FROM category
WHERE parent_id = '350'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
250 (0.065)
SELECT category_id
FROM category
WHERE parent_id = '352'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
251 (0.069)
SELECT category_id
FROM category
WHERE parent_id = '353'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
252 (0.060)
SELECT category_id
FROM category
WHERE parent_id = '364'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
253 (34.078)
SELECT COUNT(DISTINCT p2c.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)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) AND p2c.category_id IN (266, 350, 352, 353, 364)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2159
254 (0.150)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=30'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
255 (0.111)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=266'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
256 (0.083)
SELECT category_id
FROM category
WHERE parent_id = '267'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
257 (0.066)
SELECT category_id
FROM category
WHERE parent_id = '354'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
258 (0.076)
SELECT category_id
FROM category
WHERE parent_id = '356'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
259 (0.068)
SELECT category_id
FROM category
WHERE parent_id = '357'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
260 (0.063)
SELECT category_id
FROM category
WHERE parent_id = '365'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
261 (34.073)
SELECT COUNT(DISTINCT p2c.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)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) AND p2c.category_id IN (267, 354, 356, 357, 365)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2159
262 (0.144)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=30'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
263 (0.111)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=267'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
264 (0.071)
SELECT category_id
FROM category
WHERE parent_id = '254'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
265 (29.987)
SELECT COUNT(DISTINCT p2c.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)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) AND p2c.category_id IN (254)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2159
266 (0.154)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=30'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
267 (0.120)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=254'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
268 (0.075)
SELECT category_id
FROM category
WHERE parent_id = '280'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
269 (30.398)
SELECT COUNT(DISTINCT p2c.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)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) AND p2c.category_id IN (280)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2159
270 (0.153)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=30'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
271 (0.111)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=280'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
272 (0.076)
SELECT category_id
FROM category
WHERE parent_id = '265'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
273 (29.996)
SELECT COUNT(DISTINCT p2c.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)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) AND p2c.category_id IN (265)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2159
274 (0.144)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=30'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
275 (0.114)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=265'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
276 (0.110)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=30'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
277 (0.112)
SELECT *
FROM extension
WHERE `type` = 'module'
/home/stereoplanet/public_html/catalog/model/setting/extension.php:4
278 (0.757)
SELECT *
FROM information i
LEFT JOIN information_description id ON (i.information_id = id.information_id)
LEFT JOIN information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE id.language_id = '2' AND i2s.store_id = '0' AND i.status = '1'
ORDER BY CAST(i.sort_order AS CHAR), LCASE(id.title) ASC
/home/stereoplanet/public_html/catalog/model/catalog/information.php:31
279 (0.160)
SELECT *
from url_alias
where query='information_id=23' limit 1;
/home/stereoplanet/public_html/catalog/model/catalog/information.php:23
280 (0.129)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=23'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
281 (0.121)
SELECT *
from url_alias
where query='information_id=5' limit 1;
/home/stereoplanet/public_html/catalog/model/catalog/information.php:23
282 (0.117)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=5'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
283 (0.129)
SELECT *
from url_alias
where query='information_id=4' limit 1;
/home/stereoplanet/public_html/catalog/model/catalog/information.php:23
284 (0.127)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=4'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
285 (0.127)
SELECT *
from url_alias
where query='information_id=25' limit 1;
/home/stereoplanet/public_html/catalog/model/catalog/information.php:23
286 (0.123)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=25'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
287 (0.125)
SELECT *
from url_alias
where query='information_id=6' limit 1;
/home/stereoplanet/public_html/catalog/model/catalog/information.php:23
288 (0.124)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=6'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
289 (0.121)
SELECT *
from url_alias
where query='information_id=3' limit 1;
/home/stereoplanet/public_html/catalog/model/catalog/information.php:23
290 (0.135)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=3'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
291 (0.122)
SELECT *
from url_alias
where query='information_id=7' limit 1;
/home/stereoplanet/public_html/catalog/model/catalog/information.php:23
292 (0.122)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=7'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
293 (0.120)
SELECT *
from url_alias
where query='information_id=24' limit 1;
/home/stereoplanet/public_html/catalog/model/catalog/information.php:23
294 (0.124)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=24'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
295 (0.137)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=163'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
296 (0.104)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=9591'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
297 (0.135)
SELECT *
FROM url_alias
WHERE `query` = 'manufacturer_id=163'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
298 (0.104)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=9591'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
299 (0.094)
SELECT *
FROM extension
WHERE `type` = 'total'
/home/stereoplanet/public_html/catalog/model/setting/extension.php:4
300 (0.085)
SELECT SUM(amount) AS total
FROM customer_transaction
WHERE customer_id = '0'
/home/stereoplanet/public_html/system/library/customer.php:201