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.6460030078888 354 0.9723 0


No Amazon API Requests Made.


App Debug - Total Time 1.6460030078888 seconds

Number Time From Start Name Description
1 0.65347099304199 Initialise Initialise FSB Function
2 0.65606689453125 App Controller Start Start of the App controller (called before the controller of every page)
3 0.68732285499573 Start of getCategoryListByGroup Function Before first category groups query
4 0.68789887428284 After initial query Before first category groups query
5 0.68790102005005 Get Category List for Group Before the call to getCategoryList function
6 0.687903881073 Start of GetCategoryList function Start of the function
7 0.68790698051453 Before getting categories Query to get specific category list
8 0.68862295150757 After getting categories Query to get specific category list
9 0.68862390518188 Before getting category custom Before call to function getCategoryCustom
10 0.70501399040222 After getting category custom After call to function getCategoryCustom
11 0.70501804351807 Before getting category custom Before call to function getCategoryCustom
12 0.71658182144165 After getting category custom After call to function getCategoryCustom
13 0.71658682823181 Before getting category custom Before call to function getCategoryCustom
14 0.72361087799072 After getting category custom After call to function getCategoryCustom
15 0.72361493110657 Before getting category custom Before call to function getCategoryCustom
16 0.72863292694092 After getting category custom After call to function getCategoryCustom
17 0.72863602638245 Before getting category custom Before call to function getCategoryCustom
18 0.73916101455688 After getting category custom After call to function getCategoryCustom
19 0.73916482925415 Before getting category custom Before call to function getCategoryCustom
20 0.75018501281738 After getting category custom After call to function getCategoryCustom
21 0.75018882751465 End of GetCategoryList function End of the function
22 0.75019693374634 Get Category List for Group Before the call to getCategoryList function
23 0.75019884109497 Start of GetCategoryList function Start of the function
24 0.7502019405365 Before getting categories Query to get specific category list
25 0.75117182731628 End of getCategoryListByGroup Function Before return()
26 1.320750951767 App Controller End End of the App controller (called before the controller of every page)
27 1.321240901947 Product Start Start of the product info controller
28 1.3231589794159 Cache file not found Starting get product details
29 1.3694050312042 Related products Start getting related products if enabled
30 1.3694078922272 Related Products Start Before the related products are found
31 1.3694100379944 Related Products Keywords Before the related product keywords are found
32 1.3694169521332 Create Keyword List Function Start of function
33 1.3694498538971 Create Keyword List Function After looping provided content - 6 keywords found
34 1.3698709011078 Create Keyword List Function After looping initial keyword list - 6 keywords remaining
35 1.3698790073395 Create Keyword List Function After reducing keyword list
36 1.3698909282684 Create Keyword List Function After selecting by scoring keywords
37 1.3698959350586 Create Keyword List Function After final loop of keywords
38 1.3698990345001 Related Products Keywords After the related product keywords are found
39 1.4604020118713 Related Products End After the related products are found
40 1.559149980545 Product End End of the product info controller (Product Info)
41 1.5602879524231 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.5612699985504 Before Get Options Before the call to getOptions in the tpl class
43 1.6284549236298 After Get Options After the call to getOptions in the tpl class
44 1.6285538673401 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.6286020278931 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.6342189311981 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.6342239379883 Product Info: Before Template Display Before the template is displayed
48 1.6459758281708 Product Info: After Template Display After the template is displayed
49 1.6459889411926 Finalizing debug Before the debug is output to the page.
50 1.6460008621216 End of App This is the end of the app logging, final timestamp


Query Debug - 354 Database Queries. Total time 0.9723 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0017 0.0017099380493164
SELECT parameter, value FROM parameters
2 0.0053 0.00531005859375
SELECT * FROM `bad_bots`
3 0.0005 0.00046515464782715
SET time_zone = 'Europe/London'
4 0.0010 0.0010209083557129
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0008 0.00081491470336914
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:12:\"3.149.239.72\";}'
6 0.0007 0.00067687034606934
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1722057807'
7 0.0010 0.0010149478912354
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0005 0.00053977966308594
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0007 0.00071096420288086
SELECT id FROM pages WHERE pagename = 'ocun-eternal-pants' LIMIT 1
10 0.0008 0.00077700614929199
SELECT id FROM products WHERE pagename = 'ocun-eternal-pants' AND hidden = 0 LIMIT 1
11 0.0018 0.0017910003662109
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0283 0.02833104133606
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0005 0.00054597854614258
SELECT * FROM pages WHERE pagename = 'ocun-eternal-pants'
14 0.0006 0.00056290626525879
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0007 0.00069808959960938
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0067 0.0066649913787842
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.0007 0.0006868839263916
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.0005 0.00047802925109863
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0005 0.00047993659973145
SELECT id FROM categories WHERE parent_id = '26'
20 0.0057 0.0056860446929932
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.0007 0.00065398216247559
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.0006 0.00062394142150879
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.0005 0.0005040168762207
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0005 0.00046896934509277
SELECT * FROM categorygroups WHERE id = '1'
25 0.0039 0.0038590431213379
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.0006 0.00057196617126465
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.0005 0.00048613548278809
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0004 0.00043082237243652
SELECT id FROM categories WHERE parent_id = '27'
29 0.0037 0.003680944442749
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.0006 0.00062894821166992
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.0007 0.00070905685424805
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.0006 0.00055480003356934
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0005 0.00052499771118164
SELECT * FROM categorygroups WHERE id = '1'
34 0.0016 0.0016000270843506
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.0006 0.00057101249694824
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.0005 0.0004730224609375
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0005 0.00048589706420898
SELECT id FROM categories WHERE parent_id = '28'
38 0.0015 0.0015010833740234
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.0007 0.00069403648376465
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.0006 0.00056600570678711
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.00052309036254883
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0005 0.00047612190246582
SELECT * FROM categorygroups WHERE id = '1'
43 0.0006 0.00064682960510254
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.0005 0.00052809715270996
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.00044989585876465
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0005 0.00052189826965332
SELECT id FROM categories WHERE parent_id = '29'
47 0.0007 0.0007011890411377
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.0005340576171875
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.00056099891662598
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.00050616264343262
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0005 0.00048089027404785
SELECT * FROM categorygroups WHERE id = '1'
52 0.0006 0.00060105323791504
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.0006 0.00063419342041016
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.0020 0.0019941329956055
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0005 0.00051212310791016
SELECT id FROM categories WHERE parent_id = '30'
56 0.0022 0.0021660327911377
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.0011 0.0011410713195801
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.0012 0.0011811256408691
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.0012 0.0011789798736572
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0010 0.0010190010070801
SELECT * FROM categorygroups WHERE id = '1'
61 0.0015 0.0014629364013672
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.0010 0.0010251998901367
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.0012 0.0012390613555908
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0009 0.0009150505065918
SELECT id FROM categories WHERE parent_id = '31'
65 0.0018 0.0017540454864502
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.0013 0.0012979507446289
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.0013 0.0012850761413574
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.0010 0.0010039806365967
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0009 0.00092792510986328
SELECT * FROM categorygroups WHERE id = '1'
70 0.0010 0.00096011161804199
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0032 0.0031909942626953
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0009 0.00090789794921875
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0008 0.00078701972961426
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.0006 0.00059390068054199
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0020 0.0019650459289551
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0016 0.0015809535980225
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.5575 0.55752015113831
SELECT * FROM ipgeocountries WHERE INET_ATON('3.149.239.72') >= INET_ATON(ip_start) AND INET_ATON('3.149.239.72') <= INET_ATON(ip_end)
78 0.0014 0.001352071762085
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0006 0.00058388710021973
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0009 0.00091218948364258
SELECT * FROM products WHERE pagename = 'ocun-eternal-pants'
81 0.0005 0.00048089027404785
UPDATE products SET viewcount = viewcount + 1 WHERE id = 3434
82 0.0006 0.00059103965759277
SELECT * FROM manufacturers WHERE id = '438'
83 0.0005 0.00049996376037598
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '438'
84 0.0005 0.00048398971557617
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '438' LIMIT 1
85 0.0007 0.00071501731872559
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.0006 0.00058603286743164
SELECT * FROM productimages WHERE product_id = '3434' ORDER BY sortorder ASC
87 0.0005 0.0005180835723877
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '438'
88 0.0006 0.00056600570678711
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.0004 0.00037789344787598
SELECT * FROM manufacturerimages WHERE manufacturer_id = '438'
90 0.0006 0.00055098533630371
SELECT category_id FROM products_categories WHERE product_id = '3434'
91 0.0006 0.00064492225646973
SELECT * FROM categories WHERE id = '27'
92 0.0035 0.0035278797149658
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.0006 0.0005500316619873
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
94 0.0006 0.00064706802368164
SELECT id FROM categories WHERE parent_id = '27'
95 0.0052 0.0052340030670166
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.0006 0.00062990188598633
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.0009 0.000885009765625
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.0007 0.00072717666625977
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
99 0.0008 0.00080204010009766
SELECT * FROM productimages WHERE product_id = '3434' ORDER BY sortorder ASC
100 0.0011 0.0010809898376465
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.00074291229248047
SELECT * FROM product_image_select WHERE product_id = '3434'
102 0.0005 0.00053691864013672
SELECT * FROM productcustomimages WHERE product_id = '3434'
103 0.0010 0.0010499954223633
SELECT * FROM productfeeds WHERE product_id = '3434' ORDER BY item_date DESC
104 0.0018 0.0017759799957275
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.0015 0.0015068054199219
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.0011 0.0010819435119629
SELECT * FROM productamazoncontent WHERE product_id = '3434'
107 0.0016 0.0016229152679443
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.0033 0.0033090114593506
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.0010 0.0010380744934082
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.0021 0.0021398067474365
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3434' AND a.name = n.originalname
111 0.0006 0.00060391426086426
SELECT * FROM productoffers WHERE product_id = '3434' AND merchantid = 'A1X6FK5RDHNB96'
112 0.0008 0.00077295303344727
SELECT * FROM productoffers
                WHERE product_id = '3434' AND price > 0
                ORDER BY price ASC LIMIT 1
113 0.0005 0.00051307678222656
SELECT * FROM productoffers
                WHERE product_id = 3434
                ORDER BY price ASC LIMIT 1
114 0.0006 0.0006101131439209
SELECT value FROM productattributes
                WHERE product_id = '3434'
                AND name = 'ListPriceAmount'
115 0.0009 0.00092983245849609
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.0021 0.0020780563354492
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.0008 0.00079894065856934
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.0008 0.00077390670776367
SELECT value FROM productattributes WHERE product_id = '3434' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
119 0.0015 0.0015020370483398
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.0012 0.001168966293335
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.0009 0.00087118148803711
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.0141 0.014094114303589
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.0010 0.0010039806365967
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.0006 0.00062394142150879
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.0010 0.0010499954223633
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.0096 0.0096080303192139
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.0010 0.00095391273498535
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.0006 0.00061988830566406
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.0015 0.0014510154724121
SELECT * FROM productimages WHERE product_id = '881' ORDER BY sortorder ASC
130 0.0028 0.0028200149536133
SELECT * FROM product_image_select WHERE product_id = '881'
131 0.0010 0.0010249614715576
SELECT * FROM productcustomimages WHERE product_id = '881'
132 0.0035 0.0035419464111328
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '881' AND a.name = n.originalname
133 0.0013 0.0012578964233398
SELECT * FROM productoffers WHERE product_id = '881' AND merchantid = 'A1X6FK5RDHNB96'
134 0.0010 0.001046895980835
SELECT * FROM productoffers
                WHERE product_id = '881' AND price > 0
                ORDER BY price ASC LIMIT 1
135 0.0011 0.0010740756988525
SELECT value FROM productattributes WHERE product_id = '881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
136 0.0011 0.0010771751403809
SELECT * FROM productimages WHERE product_id = '1446' ORDER BY sortorder ASC
137 0.0016 0.001594066619873
SELECT * FROM product_image_select WHERE product_id = '1446'
138 0.0015 0.0014760494232178
SELECT * FROM productcustomimages WHERE product_id = '1446'
139 0.0025 0.0025279521942139
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1446' AND a.name = n.originalname
140 0.0010 0.0010111331939697
SELECT * FROM productoffers WHERE product_id = '1446' AND merchantid = 'A1X6FK5RDHNB96'
141 0.0007 0.00073003768920898
SELECT * FROM productoffers
                WHERE product_id = '1446' AND price > 0
                ORDER BY price ASC LIMIT 1
142 0.0008 0.00082492828369141
SELECT * FROM productoffers
                WHERE product_id = 1446
                ORDER BY price ASC LIMIT 1
143 0.0009 0.00086784362792969
SELECT value FROM productattributes
                WHERE product_id = '1446'
                AND name = 'ListPriceAmount'
144 0.0010 0.0009608268737793
SELECT value FROM productattributes WHERE product_id = '1446' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
145 0.0011 0.0010690689086914
SELECT * FROM productimages WHERE product_id = '943' ORDER BY sortorder ASC
146 0.0012 0.0012309551239014
SELECT * FROM product_image_select WHERE product_id = '943'
147 0.0008 0.00076794624328613
SELECT * FROM productcustomimages WHERE product_id = '943'
148 0.0015 0.0015318393707275
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '943' AND a.name = n.originalname
149 0.0009 0.00085997581481934
SELECT * FROM productoffers WHERE product_id = '943' AND merchantid = 'A1X6FK5RDHNB96'
150 0.0007 0.00067496299743652
SELECT * FROM productoffers
                WHERE product_id = '943' AND price > 0
                ORDER BY price ASC LIMIT 1
151 0.0006 0.00062203407287598
SELECT * FROM productoffers
                WHERE product_id = 943
                ORDER BY price ASC LIMIT 1
152 0.0008 0.00082612037658691
SELECT value FROM productattributes
                WHERE product_id = '943'
                AND name = 'ListPriceAmount'
153 0.0007 0.0006711483001709
SELECT value FROM productattributes WHERE product_id = '943' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
154 0.0008 0.00080609321594238
SELECT * FROM productimages WHERE product_id = '1436' ORDER BY sortorder ASC
155 0.0011 0.0010528564453125
SELECT * FROM product_image_select WHERE product_id = '1436'
156 0.0007 0.0006868839263916
SELECT * FROM productcustomimages WHERE product_id = '1436'
157 0.0019 0.0019299983978271
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1436' AND a.name = n.originalname
158 0.0008 0.00077295303344727
SELECT * FROM productoffers WHERE product_id = '1436' AND merchantid = 'A1X6FK5RDHNB96'
159 0.0006 0.00061392784118652
SELECT * FROM productoffers
                WHERE product_id = '1436' AND price > 0
                ORDER BY price ASC LIMIT 1
160 0.0006 0.00055217742919922
SELECT * FROM productoffers
                WHERE product_id = 1436
                ORDER BY price ASC LIMIT 1
161 0.0006 0.00059294700622559
SELECT value FROM productattributes
                WHERE product_id = '1436'
                AND name = 'ListPriceAmount'
162 0.0007 0.00067806243896484
SELECT value FROM productattributes WHERE product_id = '1436' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
163 0.0007 0.00072693824768066
SELECT * FROM productimages WHERE product_id = '2519' ORDER BY sortorder ASC
164 0.0009 0.00087285041809082
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2519' AND p.id = pi.product_id ORDER BY pi.sortorder
165 0.0011 0.0010769367218018
SELECT * FROM product_image_select WHERE product_id = '2519'
166 0.0007 0.00065398216247559
SELECT * FROM productcustomimages WHERE product_id = '2519'
167 0.0008 0.00081801414489746
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 = '2519'
                GROUP BY o.product_id
168 0.0009 0.00093698501586914
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     = '2519'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
169 0.0006 0.00055813789367676
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2519
170 0.0017 0.0016560554504395
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2519' AND a.name = n.originalname
171 0.0007 0.00068306922912598
SELECT * FROM productoffers WHERE product_id = '2519' AND merchantid = 'A1X6FK5RDHNB96'
172 0.0007 0.00068402290344238
SELECT * FROM productoffers
                WHERE product_id = '2519' AND price > 0
                ORDER BY price ASC LIMIT 1
173 0.0005 0.0005190372467041
SELECT * FROM productoffers
                WHERE product_id = 2519
                ORDER BY price ASC LIMIT 1
174 0.0006 0.00056600570678711
SELECT value FROM productattributes
                WHERE product_id = '2519'
                AND name = 'ListPriceAmount'
175 0.0006 0.00061607360839844
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 = '2519'
                GROUP BY o.product_id
176 0.0009 0.0009150505065918
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     = '2519'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
177 0.0006 0.00057697296142578
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2519
178 0.0008 0.00079512596130371
SELECT value FROM productattributes WHERE product_id = '2519' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
179 0.0007 0.0006558895111084
SELECT * FROM products WHERE parent_id = '2519'
180 0.0007 0.00074410438537598
SELECT * FROM productimages WHERE product_id = '1381' ORDER BY sortorder ASC
181 0.0010 0.00095796585083008
SELECT * FROM product_image_select WHERE product_id = '1381'
182 0.0006 0.0005500316619873
SELECT * FROM productcustomimages WHERE product_id = '1381'
183 0.0012 0.0011742115020752
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1381' AND a.name = n.originalname
184 0.0007 0.00068306922912598
SELECT * FROM productoffers WHERE product_id = '1381' AND merchantid = 'A1X6FK5RDHNB96'
185 0.0006 0.0005791187286377
SELECT * FROM productoffers
                WHERE product_id = '1381' AND price > 0
                ORDER BY price ASC LIMIT 1
186 0.0005 0.00048995018005371
SELECT * FROM productoffers
                WHERE product_id = 1381
                ORDER BY price ASC LIMIT 1
187 0.0006 0.00056004524230957
SELECT value FROM productattributes
                WHERE product_id = '1381'
                AND name = 'ListPriceAmount'
188 0.0006 0.00059914588928223
SELECT value FROM productattributes WHERE product_id = '1381' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
189 0.0008 0.00080180168151855
SELECT id,asin FROM products WHERE parent_id = 3434
190 0.0017 0.0016911029815674
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3435
191 0.0015 0.0015280246734619
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3435
192 0.0006 0.0005950927734375
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3437
193 0.0007 0.00072002410888672
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3437
194 0.0005 0.00046610832214355
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3439
195 0.0020 0.0019941329956055
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3439
196 0.0015 0.0014801025390625
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3441
197 0.0007 0.0006709098815918
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3441
198 0.0005 0.00048112869262695
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3442
199 0.0007 0.00067901611328125
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3442
200 0.0005 0.00051784515380859
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3443
201 0.0007 0.00067687034606934
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3443
202 0.0005 0.00048589706420898
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3446
203 0.0007 0.00074195861816406
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3446
204 0.0005 0.00051093101501465
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3447
205 0.0008 0.0007939338684082
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3447
206 0.0005 0.00050902366638184
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3448
207 0.0007 0.0007469654083252
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3448
208 0.0005 0.00053000450134277
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3449
209 0.0007 0.00074601173400879
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3449
210 0.0006 0.00060391426086426
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3576
211 0.0008 0.00080299377441406
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3576
212 0.0006 0.00062108039855957
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4321
213 0.0010 0.00098490715026855
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4321
214 0.0007 0.00066184997558594
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3780
215 0.0008 0.00083303451538086
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3780
216 0.0005 0.00053691864013672
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3921
217 0.0007 0.00071597099304199
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3921
218 0.0005 0.00049614906311035
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4303
219 0.0009 0.00088405609130859
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4303
220 0.0006 0.00055813789367676
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4304
221 0.0007 0.00072598457336426
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4304
222 0.0005 0.00051784515380859
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4305
223 0.0007 0.00074005126953125
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4305
224 0.0005 0.00054717063903809
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4306
225 0.0008 0.00078415870666504
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4306
226 0.0007 0.00066113471984863
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4308
227 0.0009 0.00094389915466309
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4308
228 0.0005 0.00050711631774902
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4309
229 0.0007 0.00070810317993164
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4309
230 0.0005 0.00052595138549805
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4310
231 0.0008 0.00075697898864746
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4310
232 0.0005 0.00054287910461426
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4599
233 0.0021 0.0021340847015381
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4599
234 0.0016 0.0016188621520996
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4600
235 0.0008 0.00080513954162598
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4600
236 0.0005 0.00054216384887695
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4601
237 0.0007 0.0007479190826416
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4601
238 0.0005 0.00052118301391602
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4602
239 0.0008 0.00079894065856934
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4602
240 0.0005 0.00053215026855469
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4603
241 0.0007 0.00072407722473145
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4603
242 0.0005 0.00047802925109863
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4604
243 0.0008 0.00078797340393066
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4604
244 0.0006 0.00056695938110352
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4605
245 0.0008 0.00079607963562012
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4605
246 0.0007 0.00065803527832031
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4606
247 0.0008 0.00078105926513672
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4606
248 0.0006 0.00055503845214844
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4607
249 0.0009 0.00085592269897461
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4607
250 0.0008 0.0007789134979248
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3434' ORDER BY timestamp DESC
251 0.0008 0.00084280967712402
SELECT category_id FROM products_categories WHERE product_id = '3434'
252 0.0009 0.00089001655578613
SELECT * FROM categories WHERE id = '27'
253 0.0079 0.0078780651092529
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
254 0.0007 0.00070595741271973
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
255 0.0006 0.00056982040405273
SELECT id FROM categories WHERE parent_id = '27'
256 0.0062 0.0061779022216797
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 
257 0.0007 0.0007479190826416
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 
258 0.0008 0.00075697898864746
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
259 0.0006 0.00055980682373047
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
260 0.0013 0.0013079643249512
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3434' AND a.name = n.originalname
261 0.0006 0.00060606002807617
SELECT * FROM productoffers WHERE product_id = '3434' AND merchantid = 'A1X6FK5RDHNB96'
262 0.0005 0.00049495697021484
SELECT * FROM productoffers
                WHERE product_id = '3434' AND price > 0
                ORDER BY price ASC LIMIT 1
263 0.0005 0.00051116943359375
SELECT * FROM productoffers
                WHERE product_id = 3434
                ORDER BY price ASC LIMIT 1
264 0.0006 0.00056099891662598
SELECT value FROM productattributes
                WHERE product_id = '3434'
                AND name = 'ListPriceAmount'
265 0.0007 0.00070500373840332
SELECT * FROM products WHERE id = '3434'
266 0.0009 0.00085592269897461
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
267 0.0016 0.0015900135040283
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
268 0.0007 0.00065088272094727
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
269 0.0008 0.0007779598236084
SELECT value FROM productattributes WHERE product_id = '3434' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
270 0.0012 0.0012249946594238
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3434' AND a.name = n.originalname
271 0.0006 0.00058817863464355
SELECT * FROM productoffers WHERE product_id = '3434' AND merchantid = 'A1X6FK5RDHNB96'
272 0.0005 0.00050997734069824
SELECT * FROM productoffers
                WHERE product_id = '3434' AND price > 0
                ORDER BY price ASC LIMIT 1
273 0.0006 0.00058698654174805
SELECT * FROM productoffers
                WHERE product_id = 3434
                ORDER BY price ASC LIMIT 1
274 0.0006 0.00056791305541992
SELECT value FROM productattributes
                WHERE product_id = '3434'
                AND name = 'ListPriceAmount'
275 0.0008 0.00079488754272461
SELECT DISTINCT (name) FROM productoptions
276 0.0009 0.00090217590332031
SELECT * FROM productoptions WHERE product_id IN (SELECT product_id FROM productoffers WHERE product_id IN (SELECT id from products WHERE parent_id = 3434))
277 0.0009 0.00091695785522461
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
278 0.0009 0.00085878372192383
SELECT * FROM translationsfilter
279 0.0007 0.00067496299743652
SELECT category_id FROM products_categories WHERE product_id = '3434' AND prod_type = 'amz'
280 0.0006 0.00057077407836914
SELECT parent_id FROM categories WHERE id = '27'
281 0.0004 0.00044918060302734
SELECT * FROM categories WHERE id = '27'
282 0.0052 0.0052080154418945
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
283 0.0006 0.00057291984558105
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
284 0.0005 0.00045204162597656
SELECT id FROM categories WHERE parent_id = '27'
285 0.0048 0.0047512054443359
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 
286 0.0007 0.00065016746520996
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 
287 0.0007 0.00072288513183594
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
288 0.0006 0.00055408477783203
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
289 0.0006 0.00063204765319824
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
290 0.0005 0.0004880428314209
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
291 0.0004 0.0003960132598877
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
292 0.0152 0.015244960784912
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
293 0.0010 0.0010290145874023
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
294 0.0006 0.00063514709472656
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
295 0.0006 0.00060892105102539
SELECT * FROM products WHERE id = 1626
296 0.0006 0.00063681602478027
SELECT * FROM products WHERE id = 4041
297 0.0006 0.00060200691223145
SELECT * FROM products WHERE id = 4312
298 0.0006 0.00060200691223145
SELECT * FROM products WHERE id = 777
299 0.0006 0.00060296058654785
SELECT * FROM products WHERE id = 3881
300 0.0009 0.00088000297546387
SELECT * FROM products WHERE id = 4213
301 0.0011 0.0010600090026855
SELECT * FROM products WHERE id = '1626'
302 0.0006 0.00056290626525879
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
303 0.0007 0.00067591667175293
SELECT * FROM product_image_select WHERE product_id = '1626'
304 0.0006 0.00059103965759277
SELECT * FROM productcustomimages WHERE product_id = '1626'
305 0.0011 0.001060962677002
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
306 0.0006 0.00062084197998047
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
307 0.0006 0.00060486793518066
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
308 0.0005 0.00054001808166504
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
309 0.0007 0.0006859302520752
SELECT * FROM products WHERE id = '4041'
310 0.0006 0.00056195259094238
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
311 0.0008 0.00076794624328613
SELECT * FROM product_image_select WHERE product_id = '4041'
312 0.0005 0.00047612190246582
SELECT * FROM productcustomimages WHERE product_id = '4041'
313 0.0014 0.0014431476593018
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
314 0.0007 0.0006561279296875
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
315 0.0005 0.00054597854614258
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
316 0.0005 0.00053501129150391
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
317 0.0007 0.00067520141601562
SELECT * FROM products WHERE id = '4312'
318 0.0006 0.00058698654174805
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
319 0.0007 0.00072503089904785
SELECT * FROM product_image_select WHERE product_id = '4312'
320 0.0005 0.00049495697021484
SELECT * FROM productcustomimages WHERE product_id = '4312'
321 0.0015 0.0014750957489014
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
322 0.0008 0.00079703330993652
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
323 0.0005 0.00054311752319336
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
324 0.0005 0.00050806999206543
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
325 0.0007 0.00067806243896484
SELECT * FROM products WHERE id = '777'
326 0.0006 0.0006411075592041
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
327 0.0009 0.00085306167602539
SELECT * FROM product_image_select WHERE product_id = '777'
328 0.0006 0.00055909156799316
SELECT * FROM productcustomimages WHERE product_id = '777'
329 0.0014 0.00136399269104
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
330 0.0007 0.00065207481384277
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
331 0.0006 0.00058698654174805
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
332 0.0006 0.0005950927734375
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
333 0.0008 0.00081801414489746
SELECT * FROM products WHERE id = '3881'
334 0.0009 0.0009310245513916
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
335 0.0008 0.00077009201049805
SELECT * FROM product_image_select WHERE product_id = '3881'
336 0.0005 0.00054311752319336
SELECT * FROM productcustomimages WHERE product_id = '3881'
337 0.0019 0.0019240379333496
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
338 0.0008 0.00078606605529785
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
339 0.0007 0.00066900253295898
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
340 0.0007 0.00067305564880371
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
341 0.0009 0.00088191032409668
SELECT * FROM products WHERE id = '4213'
342 0.0011 0.0011119842529297
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
343 0.0010 0.00098800659179688
SELECT * FROM product_image_select WHERE product_id = '4213'
344 0.0005 0.00052905082702637
SELECT * FROM productcustomimages WHERE product_id = '4213'
345 0.0016 0.001561164855957
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
346 0.0006 0.00057601928710938
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
347 0.0007 0.00068116188049316
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
348 0.0006 0.00056600570678711
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
349 0.0014 0.0013599395751953
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
350 0.0012 0.001183032989502
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
351 0.0021 0.0020990371704102
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
352 0.0009 0.00094389915466309
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
353 0.0008 0.00078201293945312
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
354 0.0015 0.0014820098876953
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'