0

Ocun Eternal Pants

Price: Click Button for Price
Product prices and availability are accurate as of 2022-01-10 19:55:06 UTC and are subject to change. Any price and availability information displayed on https://www.amazon.fr/ at the time of purchase will apply to the purchase of this product.
CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED 'AS IS' AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME.

Product Features

Nylon, Herren Baumwolle 55%, Nylon 42%, Spandex 3%, Rip-Stop look

There are no customer reviews yet. Be the first to Write a Review!

Wait! We have a something for you...

Don't leave empty-handed! Simply enter your email below and we will send you a great discount on our products:

We hate spam as much as you do! Your details are never shared and you can unsubscribe at any time.

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.4735310077667 346 1.1195 0


No Amazon API Requests Made.


App Debug - Total Time 1.4735310077667 seconds

Number Time From Start Name Description
1 0.33873391151428 Initialise Initialise FSB Function
2 0.34228301048279 App Controller Start Start of the App controller (called before the controller of every page)
3 0.38417291641235 Start of getCategoryListByGroup Function Before first category groups query
4 0.38462686538696 After initial query Before first category groups query
5 0.38462686538696 Get Category List for Group Before the call to getCategoryList function
6 0.38462901115417 Start of GetCategoryList function Start of the function
7 0.38463091850281 Before getting categories Query to get specific category list
8 0.38521885871887 After getting categories Query to get specific category list
9 0.38521981239319 Before getting category custom Before call to function getCategoryCustom
10 0.41122198104858 After getting category custom After call to function getCategoryCustom
11 0.41122484207153 Before getting category custom Before call to function getCategoryCustom
12 0.42245888710022 After getting category custom After call to function getCategoryCustom
13 0.42246079444885 Before getting category custom Before call to function getCategoryCustom
14 0.42861390113831 After getting category custom After call to function getCategoryCustom
15 0.42861485481262 Before getting category custom Before call to function getCategoryCustom
16 0.43333983421326 After getting category custom After call to function getCategoryCustom
17 0.43334078788757 Before getting category custom Before call to function getCategoryCustom
18 0.43949890136719 After getting category custom After call to function getCategoryCustom
19 0.4394998550415 Before getting category custom Before call to function getCategoryCustom
20 0.44443893432617 After getting category custom After call to function getCategoryCustom
21 0.44443988800049 End of GetCategoryList function End of the function
22 0.44444489479065 Get Category List for Group Before the call to getCategoryList function
23 0.44444584846497 Start of GetCategoryList function Start of the function
24 0.44444799423218 Before getting categories Query to get specific category list
25 0.4450409412384 End of getCategoryListByGroup Function Before return()
26 1.2653388977051 App Controller End End of the App controller (called before the controller of every page)
27 1.2658979892731 Product Start Start of the product info controller
28 1.2692120075226 Cache file not found Starting get product details
29 1.2978639602661 Related products Start getting related products if enabled
30 1.2978649139404 Related Products Start Before the related products are found
31 1.2978658676147 Related Products Keywords Before the related product keywords are found
32 1.2978689670563 Create Keyword List Function Start of function
33 1.2978868484497 Create Keyword List Function After looping provided content - 6 keywords found
34 1.2980139255524 Create Keyword List Function After looping initial keyword list - 6 keywords remaining
35 1.2980179786682 Create Keyword List Function After reducing keyword list
36 1.2980208396912 Create Keyword List Function After selecting by scoring keywords
37 1.2980239391327 Create Keyword List Function After final loop of keywords
38 1.298024892807 Related Products Keywords After the related product keywords are found
39 1.3511497974396 Related Products End After the related products are found
40 1.4055609703064 Product End End of the product info controller (Product Info)
41 1.4063818454742 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.4072518348694 Before Get Options Before the call to getOptions in the tpl class
43 1.452507019043 After Get Options After the call to getOptions in the tpl class
44 1.4525768756866 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.4525969028473 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.4602088928223 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.4602119922638 Product Info: Before Template Display Before the template is displayed
48 1.4735109806061 Product Info: After Template Display After the template is displayed
49 1.4735209941864 Finalizing debug Before the debug is output to the page.
50 1.4735298156738 End of App This is the end of the app logging, final timestamp


Query Debug - 346 Database Queries. Total time 1.1195 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0029 0.0028970241546631
SELECT parameter, value FROM parameters
2 0.0060 0.0059809684753418
SELECT * FROM `bad_bots`
3 0.0005 0.0004727840423584
SET time_zone = 'Europe/London'
4 0.0010 0.001032829284668
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0012 0.001209020614624
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"18.117.244.233\";}'
6 0.0010 0.0010030269622803
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1746168709'
7 0.0013 0.0012781620025635
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0006 0.00059199333190918
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0011 0.0010750293731689
SELECT id FROM pages WHERE pagename = 'ocun-eternal-pants' LIMIT 1
10 0.0016 0.0016391277313232
SELECT id FROM products WHERE pagename = 'ocun-eternal-pants' AND hidden = 0 LIMIT 1
11 0.0043 0.0043070316314697
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0366 0.036602020263672
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0007 0.00072884559631348
SELECT * FROM pages WHERE pagename = 'ocun-eternal-pants'
14 0.0005 0.00045013427734375
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0006 0.0005791187286377
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0100 0.010035991668701
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
17 0.0005 0.00049805641174316
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
18 0.0004 0.00036406517028809
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0004 0.00037789344787598
SELECT id FROM categories WHERE parent_id = '26'
20 0.0106 0.010641098022461
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
21 0.0009 0.00087690353393555
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0 
22 0.0017 0.0016889572143555
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
23 0.0010 0.00099515914916992
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0005 0.00046110153198242
SELECT * FROM categorygroups WHERE id = '1'
25 0.0041 0.0041148662567139
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
26 0.0005 0.00051689147949219
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
27 0.0004 0.00043392181396484
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0004 0.00039291381835938
SELECT id FROM categories WHERE parent_id = '27'
29 0.0038 0.0038280487060547
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
30 0.0005 0.00052380561828613
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
31 0.0005 0.00052404403686523
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
32 0.0005 0.00046992301940918
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0004 0.00038290023803711
SELECT * FROM categorygroups WHERE id = '1'
34 0.0014 0.0014078617095947
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
35 0.0004 0.00043702125549316
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
36 0.0004 0.00035309791564941
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0004 0.0003960132598877
SELECT id FROM categories WHERE parent_id = '28'
38 0.0015 0.0015418529510498
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
39 0.0005 0.0005030632019043
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0 
40 0.0005 0.0005040168762207
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
41 0.0005 0.00050497055053711
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0005 0.00046992301940918
SELECT * FROM categorygroups WHERE id = '1'
43 0.0006 0.00055813789367676
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
44 0.0004 0.0004270076751709
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
45 0.0004 0.00038409233093262
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0004 0.00041103363037109
SELECT id FROM categories WHERE parent_id = '29'
47 0.0006 0.00064516067504883
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
48 0.0005 0.00047087669372559
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0 
49 0.0006 0.00055289268493652
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
50 0.0005 0.0004889965057373
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0008 0.00076413154602051
SELECT * FROM categorygroups WHERE id = '1'
52 0.0009 0.00091099739074707
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
53 0.0007 0.00068092346191406
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
54 0.0006 0.00062680244445801
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0005 0.0005190372467041
SELECT id FROM categories WHERE parent_id = '30'
56 0.0011 0.0010750293731689
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
57 0.0007 0.00069117546081543
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0 
58 0.0006 0.00055599212646484
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
59 0.0006 0.00060701370239258
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0005 0.00047111511230469
SELECT * FROM categorygroups WHERE id = '1'
61 0.0007 0.00067520141601562
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
62 0.0005 0.00048208236694336
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
63 0.0005 0.0005040168762207
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0005 0.0004580020904541
SELECT id FROM categories WHERE parent_id = '31'
65 0.0008 0.00080609321594238
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
66 0.0005 0.0005340576171875
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
67 0.0006 0.00060582160949707
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
68 0.0005 0.00046586990356445
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0004 0.00038886070251465
SELECT * FROM categorygroups WHERE id = '1'
70 0.0006 0.00058889389038086
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0021 0.0020542144775391
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0006 0.00056004524230957
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0005 0.00049805641174316
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
74 0.0004 0.00037813186645508
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0011 0.0010831356048584
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0008 0.00077605247497559
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.8127 0.81274890899658
SELECT * FROM ipgeocountries WHERE INET_ATON('18.117.244.233') >= INET_ATON(ip_start) AND INET_ATON('18.117.244.233') <= INET_ATON(ip_end)
78 0.0011 0.0010747909545898
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0004 0.00043511390686035
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0006 0.00061607360839844
SELECT * FROM products WHERE pagename = 'ocun-eternal-pants'
81 0.0004 0.0004270076751709
UPDATE products SET viewcount = viewcount + 1 WHERE id = 3434
82 0.0006 0.00064682960510254
SELECT * FROM manufacturers WHERE id = '438'
83 0.0005 0.00046491622924805
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '438'
84 0.0004 0.00041699409484863
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '438' LIMIT 1
85 0.0005 0.00053310394287109
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '438' ORDER BY RAND() LIMIT 1
86 0.0004 0.00038480758666992
SELECT * FROM productimages WHERE product_id = '3576' ORDER BY sortorder ASC
87 0.0004 0.00038599967956543
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '438'
88 0.0004 0.00039482116699219
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '438'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
89 0.0003 0.00029397010803223
SELECT * FROM manufacturerimages WHERE manufacturer_id = '438'
90 0.0004 0.00044989585876465
SELECT category_id FROM products_categories WHERE product_id = '3434'
91 0.0005 0.00050091743469238
SELECT * FROM categories WHERE id = '27'
92 0.0037 0.0037219524383545
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
93 0.0004 0.00042200088500977
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
94 0.0004 0.00036096572875977
SELECT id FROM categories WHERE parent_id = '27'
95 0.0037 0.0036790370941162
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
96 0.0005 0.00053811073303223
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
97 0.0005 0.00052905082702637
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
98 0.0005 0.00050210952758789
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
99 0.0005 0.00052285194396973
SELECT * FROM productimages WHERE product_id = '3434' ORDER BY sortorder ASC
100 0.0008 0.00075387954711914
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3434' AND p.id = pi.product_id ORDER BY pi.sortorder
101 0.0007 0.00065898895263672
SELECT * FROM product_image_select WHERE product_id = '3434'
102 0.0004 0.00042009353637695
SELECT * FROM productcustomimages WHERE product_id = '3434'
103 0.0004 0.00041413307189941
SELECT * FROM productfeeds WHERE product_id = '3434' ORDER BY item_date DESC
104 0.0007 0.00066804885864258
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '3434' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
105 0.0006 0.00058102607727051
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '3434' AND t.hidden = 0 AND display_product = 1
106 0.0008 0.00082015991210938
SELECT * FROM productamazoncontent WHERE product_id = '3434'
107 0.0006 0.00064301490783691
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '3434'
                GROUP BY o.product_id
108 0.0011 0.0011208057403564
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '3434'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
109 0.0005 0.00049901008605957
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3434
110 0.0010 0.00099992752075195
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3434' AND a.name = n.originalname
111 0.0003 0.00033903121948242
SELECT * FROM productoffers WHERE product_id = '3434' AND merchantid = 'A1X6FK5RDHNB96'
112 0.0003 0.00033903121948242
SELECT * FROM productoffers
                WHERE product_id = '3434' AND price > 0
                ORDER BY price ASC LIMIT 1
113 0.0003 0.00031089782714844
SELECT * FROM productoffers
                WHERE product_id = 3434
                ORDER BY price ASC LIMIT 1
114 0.0003 0.0003352165222168
SELECT value FROM productattributes
                WHERE product_id = '3434'
                AND name = 'ListPriceAmount'
115 0.0005 0.00052905082702637
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '3434'
                GROUP BY o.product_id
116 0.0010 0.0009758472442627
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '3434'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
117 0.0005 0.00047993659973145
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3434
118 0.0005 0.00047206878662109
SELECT value FROM productattributes WHERE product_id = '3434' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
119 0.0008 0.0008089542388916
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3434'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
120 0.0007 0.00068807601928711
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3434'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
121 0.0005 0.00050902366638184
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
122 0.0090 0.0090489387512207
SELECT *, MATCH (description, title) AGAINST ('ocun eternal pants' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('ocun eternal pants' IN BOOLEAN MODE) AND 3434 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
123 0.0006 0.000579833984375
SELECT *, MATCH (description, title) AGAINST ('ocun eternal pants' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('ocun eternal pants' IN BOOLEAN MODE) AND 3434 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
124 0.0005 0.00051498413085938
SELECT *, MATCH (description, title) AGAINST ('ocun eternal pants' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('ocun eternal pants' IN BOOLEAN MODE) AND 3434 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
125 0.0009 0.00093293190002441
SELECT categories.id, COUNT(*) as productcount FROM products_categories, categories WHERE categories.id IN (SELECT category_id FROM products_categories WHERE product_id = '3434') AND products_categories.category_id = categories.id GROUP BY categories.id ORDER BY productcount ASC
126 0.0078 0.0078060626983643
SELECT p.* FROM products p, products_categories pc WHERE p.parent_id = 0 AND p.id = pc.product_id AND pc.category_id = '27' AND pc.prod_type = 'amz'  AND p.id <> '3434' ORDER BY RAND()
127 0.0006 0.00058293342590332
SELECT p.* FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND pc.category_id = '27' AND pc.prod_type = 'ebay' AND p.id <> '3434' ORDER BY RAND()
128 0.0005 0.00052785873413086
SELECT p.* FROM custom_products p, products_categories pc WHERE p.id = pc.product_id AND pc.category_id = '27' AND pc.prod_type = 'custom' AND p.id <> '3434' ORDER BY RAND()
129 0.0005 0.00046396255493164
SELECT * FROM productimages WHERE product_id = '1277' ORDER BY sortorder ASC
130 0.0005 0.00053691864013672
SELECT * FROM product_image_select WHERE product_id = '1277'
131 0.0004 0.00040102005004883
SELECT * FROM productcustomimages WHERE product_id = '1277'
132 0.0010 0.0010409355163574
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1277' AND a.name = n.originalname
133 0.0004 0.00041580200195312
SELECT * FROM productoffers WHERE product_id = '1277' AND merchantid = 'A1X6FK5RDHNB96'
134 0.0003 0.00032806396484375
SELECT * FROM productoffers
                WHERE product_id = '1277' AND price > 0
                ORDER BY price ASC LIMIT 1
135 0.0003 0.00029301643371582
SELECT * FROM productoffers
                WHERE product_id = 1277
                ORDER BY price ASC LIMIT 1
136 0.0004 0.00037789344787598
SELECT value FROM productattributes
                WHERE product_id = '1277'
                AND name = 'ListPriceAmount'
137 0.0004 0.0003819465637207
SELECT value FROM productattributes WHERE product_id = '1277' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
138 0.0004 0.00040292739868164
SELECT * FROM productimages WHERE product_id = '983' ORDER BY sortorder ASC
139 0.0013 0.0012829303741455
SELECT * FROM product_image_select WHERE product_id = '983'
140 0.0018 0.0017609596252441
SELECT * FROM productcustomimages WHERE product_id = '983'
141 0.0021 0.0020840167999268
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '983' AND a.name = n.originalname
142 0.0020 0.0020360946655273
SELECT * FROM productoffers WHERE product_id = '983' AND merchantid = 'A1X6FK5RDHNB96'
143 0.0019 0.0018551349639893
SELECT * FROM productoffers
                WHERE product_id = '983' AND price > 0
                ORDER BY price ASC LIMIT 1
144 0.0012 0.0011589527130127
SELECT * FROM productoffers
                WHERE product_id = 983
                ORDER BY price ASC LIMIT 1
145 0.0005 0.00045394897460938
SELECT value FROM productattributes
                WHERE product_id = '983'
                AND name = 'ListPriceAmount'
146 0.0004 0.00041604042053223
SELECT value FROM productattributes WHERE product_id = '983' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
147 0.0005 0.00053191184997559
SELECT * FROM productimages WHERE product_id = '1204' ORDER BY sortorder ASC
148 0.0006 0.00060296058654785
SELECT * FROM product_image_select WHERE product_id = '1204'
149 0.0004 0.00037789344787598
SELECT * FROM productcustomimages WHERE product_id = '1204'
150 0.0008 0.00076603889465332
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1204' AND a.name = n.originalname
151 0.0004 0.00044894218444824
SELECT * FROM productoffers WHERE product_id = '1204' AND merchantid = 'A1X6FK5RDHNB96'
152 0.0004 0.00038719177246094
SELECT * FROM productoffers
                WHERE product_id = '1204' AND price > 0
                ORDER BY price ASC LIMIT 1
153 0.0004 0.00040197372436523
SELECT value FROM productattributes WHERE product_id = '1204' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
154 0.0005 0.00047612190246582
SELECT * FROM productimages WHERE product_id = '1448' ORDER BY sortorder ASC
155 0.0006 0.00059700012207031
SELECT * FROM product_image_select WHERE product_id = '1448'
156 0.0004 0.00036001205444336
SELECT * FROM productcustomimages WHERE product_id = '1448'
157 0.0012 0.0011820793151855
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1448' AND a.name = n.originalname
158 0.0004 0.0004429817199707
SELECT * FROM productoffers WHERE product_id = '1448' AND merchantid = 'A1X6FK5RDHNB96'
159 0.0003 0.00034880638122559
SELECT * FROM productoffers
                WHERE product_id = '1448' AND price > 0
                ORDER BY price ASC LIMIT 1
160 0.0003 0.00031089782714844
SELECT * FROM productoffers
                WHERE product_id = 1448
                ORDER BY price ASC LIMIT 1
161 0.0004 0.00035715103149414
SELECT value FROM productattributes
                WHERE product_id = '1448'
                AND name = 'ListPriceAmount'
162 0.0004 0.00040698051452637
SELECT value FROM productattributes WHERE product_id = '1448' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
163 0.0005 0.0004580020904541
SELECT * FROM productimages WHERE product_id = '4612' ORDER BY sortorder ASC
164 0.0006 0.00058794021606445
SELECT * FROM product_image_select WHERE product_id = '4612'
165 0.0003 0.0003201961517334
SELECT * FROM productcustomimages WHERE product_id = '4612'
166 0.0010 0.0010499954223633
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4612' AND a.name = n.originalname
167 0.0005 0.00047397613525391
SELECT * FROM productoffers WHERE product_id = '4612' AND merchantid = 'A1X6FK5RDHNB96'
168 0.0004 0.00035810470581055
SELECT * FROM productoffers
                WHERE product_id = '4612' AND price > 0
                ORDER BY price ASC LIMIT 1
169 0.0003 0.00029206275939941
SELECT * FROM productoffers
                WHERE product_id = 4612
                ORDER BY price ASC LIMIT 1
170 0.0003 0.00034308433532715
SELECT value FROM productattributes
                WHERE product_id = '4612'
                AND name = 'ListPriceAmount'
171 0.0004 0.00036501884460449
SELECT value FROM productattributes WHERE product_id = '4612' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
172 0.0004 0.00040817260742188
SELECT * FROM productimages WHERE product_id = '903' ORDER BY sortorder ASC
173 0.0006 0.00057387351989746
SELECT * FROM product_image_select WHERE product_id = '903'
174 0.0003 0.00034379959106445
SELECT * FROM productcustomimages WHERE product_id = '903'
175 0.0007 0.00069713592529297
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '903' AND a.name = n.originalname
176 0.0004 0.00042390823364258
SELECT * FROM productoffers WHERE product_id = '903' AND merchantid = 'A1X6FK5RDHNB96'
177 0.0003 0.00033307075500488
SELECT * FROM productoffers
                WHERE product_id = '903' AND price > 0
                ORDER BY price ASC LIMIT 1
178 0.0003 0.00032496452331543
SELECT * FROM productoffers
                WHERE product_id = 903
                ORDER BY price ASC LIMIT 1
179 0.0003 0.00034689903259277
SELECT value FROM productattributes
                WHERE product_id = '903'
                AND name = 'ListPriceAmount'
180 0.0004 0.00037193298339844
SELECT value FROM productattributes WHERE product_id = '903' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
181 0.0006 0.00055193901062012
SELECT id,asin FROM products WHERE parent_id = 3434
182 0.0004 0.00040102005004883
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3435
183 0.0005 0.00054788589477539
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3435
184 0.0003 0.00032186508178711
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3437
185 0.0004 0.0003819465637207
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3437
186 0.0003 0.00028705596923828
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3439
187 0.0004 0.00038504600524902
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3439
188 0.0003 0.0002739429473877
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3441
189 0.0004 0.00041985511779785
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3441
190 0.0003 0.00029087066650391
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3442
191 0.0004 0.0003669261932373
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3442
192 0.0004 0.00038695335388184
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3443
193 0.0004 0.00039100646972656
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3443
194 0.0003 0.00028300285339355
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3446
195 0.0004 0.00038814544677734
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3446
196 0.0003 0.00028300285339355
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3447
197 0.0004 0.00039410591125488
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3447
198 0.0003 0.00032305717468262
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3448
199 0.0004 0.00037479400634766
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3448
200 0.0003 0.00029087066650391
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3449
201 0.0004 0.00040483474731445
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3449
202 0.0003 0.00029397010803223
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3576
203 0.0004 0.00043082237243652
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3576
204 0.0004 0.00040984153747559
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4321
205 0.0004 0.00040698051452637
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4321
206 0.0003 0.00032401084899902
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3780
207 0.0004 0.00038695335388184
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3780
208 0.0003 0.00028395652770996
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3921
209 0.0004 0.00040602684020996
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3921
210 0.0003 0.00030803680419922
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4303
211 0.0003 0.00034117698669434
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4303
212 0.0003 0.00027298927307129
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4304
213 0.0003 0.00034689903259277
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4304
214 0.0003 0.00025796890258789
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4305
215 0.0003 0.00034403800964355
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4305
216 0.0003 0.00026488304138184
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4306
217 0.0004 0.00035691261291504
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4306
218 0.0003 0.00026512145996094
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4308
219 0.0004 0.00035905838012695
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4308
220 0.0003 0.0002739429473877
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4309
221 0.0004 0.00041699409484863
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4309
222 0.0003 0.00028014183044434
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4310
223 0.0004 0.00038599967956543
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4310
224 0.0003 0.00030303001403809
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4599
225 0.0004 0.00035691261291504
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4599
226 0.0003 0.00028419494628906
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4600
227 0.0004 0.00035810470581055
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4600
228 0.0003 0.00026392936706543
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4601
229 0.0004 0.00038290023803711
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4601
230 0.0003 0.00032210350036621
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4602
231 0.0003 0.00034809112548828
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4602
232 0.0003 0.00026392936706543
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4603
233 0.0004 0.00038886070251465
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4603
234 0.0003 0.00027990341186523
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4604
235 0.0004 0.00043416023254395
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4604
236 0.0003 0.00029301643371582
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4605
237 0.0004 0.00038886070251465
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4605
238 0.0003 0.00027894973754883
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4606
239 0.0004 0.00037503242492676
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4606
240 0.0003 0.00029301643371582
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4607
241 0.0004 0.00039982795715332
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4607
242 0.0004 0.00043106079101562
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3434' ORDER BY timestamp DESC
243 0.0004 0.00043177604675293
SELECT category_id FROM products_categories WHERE product_id = '3434'
244 0.0004 0.00043582916259766
SELECT * FROM categories WHERE id = '27'
245 0.0038 0.0037810802459717
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
246 0.0004 0.00042605400085449
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
247 0.0003 0.0003209114074707
SELECT id FROM categories WHERE parent_id = '27'
248 0.0038 0.0037550926208496
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
249 0.0005 0.0005030632019043
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
250 0.0005 0.00051093101501465
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
251 0.0004 0.00042486190795898
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
252 0.0010 0.00099015235900879
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3434' AND a.name = n.originalname
253 0.0005 0.00047898292541504
SELECT * FROM productoffers WHERE product_id = '3434' AND merchantid = 'A1X6FK5RDHNB96'
254 0.0003 0.00032806396484375
SELECT * FROM productoffers
                WHERE product_id = '3434' AND price > 0
                ORDER BY price ASC LIMIT 1
255 0.0003 0.00028085708618164
SELECT * FROM productoffers
                WHERE product_id = 3434
                ORDER BY price ASC LIMIT 1
256 0.0003 0.00032591819763184
SELECT value FROM productattributes
                WHERE product_id = '3434'
                AND name = 'ListPriceAmount'
257 0.0004 0.00043296813964844
SELECT * FROM products WHERE id = '3434'
258 0.0005 0.00048398971557617
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '3434'
                GROUP BY o.product_id
259 0.0011 0.001060962677002
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '3434'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
260 0.0005 0.0004730224609375
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3434
261 0.0005 0.00050497055053711
SELECT value FROM productattributes WHERE product_id = '3434' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
262 0.0009 0.00091290473937988
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3434' AND a.name = n.originalname
263 0.0004 0.00036191940307617
SELECT * FROM productoffers WHERE product_id = '3434' AND merchantid = 'A1X6FK5RDHNB96'
264 0.0003 0.00033903121948242
SELECT * FROM productoffers
                WHERE product_id = '3434' AND price > 0
                ORDER BY price ASC LIMIT 1
265 0.0003 0.00030994415283203
SELECT * FROM productoffers
                WHERE product_id = 3434
                ORDER BY price ASC LIMIT 1
266 0.0004 0.0004429817199707
SELECT value FROM productattributes
                WHERE product_id = '3434'
                AND name = 'ListPriceAmount'
267 0.0006 0.0005800724029541
SELECT DISTINCT (name) FROM productoptions
268 0.0006 0.0005650520324707
SELECT * FROM productoptions WHERE product_id IN (SELECT product_id FROM productoffers WHERE product_id IN (SELECT id from products WHERE parent_id = 3434))
269 0.0007 0.00065708160400391
SELECT	o.value, o.name
			FROM	products			p,
					productoptions		o
			WHERE	p.parent_id		= 3434
			  AND	p.id			= o.product_id 
			GROUP BY o.value ORDER BY o.value ASC
270 0.0017 0.0016639232635498
SELECT * FROM translationsfilter
271 0.0004 0.0004279613494873
SELECT category_id FROM products_categories WHERE product_id = '3434' AND prod_type = 'amz'
272 0.0004 0.00039410591125488
SELECT parent_id FROM categories WHERE id = '27'
273 0.0003 0.00033116340637207
SELECT * FROM categories WHERE id = '27'
274 0.0035 0.0034501552581787
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
275 0.0004 0.00040507316589355
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
276 0.0003 0.00033688545227051
SELECT id FROM categories WHERE parent_id = '27'
277 0.0035 0.0034840106964111
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
278 0.0004 0.00044393539428711
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
279 0.0005 0.00049185752868652
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
280 0.0004 0.00040793418884277
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
281 0.0005 0.00045394897460938
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
282 0.0005 0.00048589706420898
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
283 0.0003 0.0003361701965332
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
284 0.0130 0.012984991073608
SELECT p.id,p.parent_id, o.price,p.asin FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND hidden = 0 AND offers > 0 AND (SELECT COUNT(pi.id) FROM productimages pi WHERE pi.product_id = p.id) > 1 AND o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price)) ORDER BY p.title DESC LIMIT 6
285 0.0006 0.00062108039855957
SELECT p.id,p.price,p.listingtype FROM ebay_products p WHERE hide = 0 AND (SELECT COUNT(pi.id) FROM ebay_prod_images pi WHERE pi.prodid = p.id) > 1 ORDER BY p.title DESC LIMIT 6
286 0.0005 0.00052618980407715
SELECT p.id,p.price,p.currency FROM custom_products p WHERE hide = 0 AND orginalprice > 0 AND (SELECT COUNT(pi.id) FROM productcustomimages pi WHERE pi.product_id = p.id) > 1 ORDER BY p.title DESC LIMIT 6
287 0.0005 0.00054311752319336
SELECT * FROM products WHERE id = 1626
288 0.0004 0.00038695335388184
SELECT * FROM products WHERE id = 4041
289 0.0004 0.00042581558227539
SELECT * FROM products WHERE id = 4312
290 0.0003 0.00030398368835449
SELECT * FROM products WHERE id = 777
291 0.0004 0.0003819465637207
SELECT * FROM products WHERE id = 3881
292 0.0004 0.00037598609924316
SELECT * FROM products WHERE id = 4213
293 0.0004 0.00037598609924316
SELECT * FROM products WHERE id = '1626'
294 0.0004 0.0004429817199707
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
295 0.0005 0.00054812431335449
SELECT * FROM product_image_select WHERE product_id = '1626'
296 0.0003 0.00034999847412109
SELECT * FROM productcustomimages WHERE product_id = '1626'
297 0.0008 0.0008080005645752
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
298 0.0005 0.00045299530029297
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
299 0.0004 0.00035715103149414
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
300 0.0004 0.00038719177246094
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
301 0.0004 0.0004420280456543
SELECT * FROM products WHERE id = '4041'
302 0.0004 0.00038409233093262
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
303 0.0005 0.00053787231445312
SELECT * FROM product_image_select WHERE product_id = '4041'
304 0.0004 0.00036096572875977
SELECT * FROM productcustomimages WHERE product_id = '4041'
305 0.0010 0.0010011196136475
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
306 0.0004 0.00044894218444824
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
307 0.0003 0.00034308433532715
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
308 0.0004 0.00036311149597168
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
309 0.0005 0.00048398971557617
SELECT * FROM products WHERE id = '4312'
310 0.0004 0.00040006637573242
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
311 0.0005 0.00054383277893066
SELECT * FROM product_image_select WHERE product_id = '4312'
312 0.0004 0.00037980079650879
SELECT * FROM productcustomimages WHERE product_id = '4312'
313 0.0011 0.0011270046234131
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
314 0.0004 0.00041985511779785
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
315 0.0003 0.00033378601074219
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
316 0.0004 0.00036406517028809
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
317 0.0005 0.00049591064453125
SELECT * FROM products WHERE id = '777'
318 0.0004 0.00041007995605469
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
319 0.0005 0.00054192543029785
SELECT * FROM product_image_select WHERE product_id = '777'
320 0.0003 0.00034999847412109
SELECT * FROM productcustomimages WHERE product_id = '777'
321 0.0010 0.00097107887268066
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
322 0.0004 0.00044703483581543
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
323 0.0004 0.00036501884460449
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
324 0.0004 0.00038504600524902
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
325 0.0005 0.00054597854614258
SELECT * FROM products WHERE id = '3881'
326 0.0005 0.00049996376037598
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
327 0.0005 0.00054502487182617
SELECT * FROM product_image_select WHERE product_id = '3881'
328 0.0003 0.00033402442932129
SELECT * FROM productcustomimages WHERE product_id = '3881'
329 0.0010 0.0009610652923584
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
330 0.0004 0.00041294097900391
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
331 0.0003 0.00034284591674805
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
332 0.0004 0.00037789344787598
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
333 0.0005 0.0004730224609375
SELECT * FROM products WHERE id = '4213'
334 0.0005 0.00045204162597656
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
335 0.0005 0.00053906440734863
SELECT * FROM product_image_select WHERE product_id = '4213'
336 0.0003 0.00031399726867676
SELECT * FROM productcustomimages WHERE product_id = '4213'
337 0.0010 0.00098180770874023
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
338 0.0004 0.00043201446533203
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
339 0.0003 0.00034999847412109
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
340 0.0004 0.00043106079101562
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
341 0.0007 0.00068879127502441
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
342 0.0007 0.00073599815368652
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
343 0.0014 0.0013961791992188
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
344 0.0007 0.00065088272094727
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
345 0.0005 0.00052094459533691
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
346 0.0005 0.00051593780517578
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'