0
  1. My Store
  2. Tags
  3. Café

Café

Browse Categories

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.

no thanks

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.6487631797791 398 1.1087 0


No Amazon API Requests Made.


App Debug - Total Time 1.6487631797791 seconds

Number Time From Start Name Description
1 0.52903318405151 Initialise Initialise FSB Function
2 0.55030202865601 App Controller Start Start of the App controller (called before the controller of every page)
3 0.57728409767151 Start of getCategoryListByGroup Function Before first category groups query
4 0.57848000526428 After initial query Before first category groups query
5 0.57848119735718 Get Category List for Group Before the call to getCategoryList function
6 0.57848310470581 Start of GetCategoryList function Start of the function
7 0.57848501205444 Before getting categories Query to get specific category list
8 0.57916116714478 After getting categories Query to get specific category list
9 0.57916212081909 Before getting category custom Before call to function getCategoryCustom
10 0.59622621536255 After getting category custom After call to function getCategoryCustom
11 0.59622716903687 Before getting category custom Before call to function getCategoryCustom
12 0.60623621940613 After getting category custom After call to function getCategoryCustom
13 0.60623717308044 Before getting category custom Before call to function getCategoryCustom
14 0.61254000663757 After getting category custom After call to function getCategoryCustom
15 0.61254119873047 Before getting category custom Before call to function getCategoryCustom
16 0.61702418327332 After getting category custom After call to function getCategoryCustom
17 0.61702513694763 Before getting category custom Before call to function getCategoryCustom
18 0.62131404876709 After getting category custom After call to function getCategoryCustom
19 0.62131500244141 Before getting category custom Before call to function getCategoryCustom
20 0.62579202651978 After getting category custom After call to function getCategoryCustom
21 0.62579321861267 End of GetCategoryList function End of the function
22 0.62579703330994 Get Category List for Group Before the call to getCategoryList function
23 0.62579917907715 Start of GetCategoryList function Start of the function
24 0.62580013275146 Before getting categories Query to get specific category list
25 0.62627220153809 End of getCategoryListByGroup Function Before return()
26 1.389564037323 App Controller End End of the App controller (called before the controller of every page)
27 1.5711162090302 App_after Controller Start Start of the App_after controller (called after the controller of every page)
28 1.5729551315308 Before Get Options Before the call to getOptions in the tpl class
29 1.6250200271606 After Get Options After the call to getOptions in the tpl class
30 1.6250510215759 App_after Controller End End of the App_after controller (called after the controller of every page)
31 1.648754119873 Finalizing debug Before the debug is output to the page.
32 1.6487631797791 End of App This is the end of the app logging, final timestamp


Query Debug - 398 Database Queries. Total time 1.1087 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0021 0.002108097076416 
SELECT parameter, value FROM parameters
2 0.0056 0.0055608749389648 
SELECT * FROM `bad_bots`
3 0.0004 0.00037288665771484 
SET time_zone = 'Europe/London'
4 0.0019 0.0019400119781494 
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0024 0.0024039745330811 
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"13.58.212.163\";}'
6 0.0025 0.0024821758270264 
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1747090670'
7 0.0040 0.0039880275726318 
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0007 0.00074601173400879 
UPDATE autorun SET lastrun = '2025-05-12 22:57:50' WHERE id = '16'
9 0.0008 0.00083708763122559 
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0034 0.0034248828887939 
SELECT id FROM pages WHERE pagename = 'tag' LIMIT 1
11 0.0037 0.0036540031433105 
SELECT id FROM products WHERE pagename = 'tag' AND hidden = 0 LIMIT 1
12 0.0029 0.0028600692749023 
SELECT id FROM ebay_products WHERE pagename = 'tag'
13 0.0022 0.0022079944610596 
SELECT id FROM custom_products WHERE pagename = 'tag'
14 0.0021 0.0020620822906494 
SELECT id FROM categories WHERE pagename = 'tag' LIMIT 1
15 0.0019 0.0019330978393555 
SELECT id FROM manufacturers WHERE pagename = 'tag' LIMIT 1
16 0.0019 0.001945972442627 
SELECT id FROM bundles WHERE pagename = 'tag' LIMIT 1
17 0.0018 0.0017819404602051 
SELECT id FROM tags WHERE pagename = 'cafe' LIMIT 1
18 0.0025 0.0024709701538086 
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
19 0.0237 0.02372407913208 
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
20 0.0005 0.00051593780517578 
SELECT * FROM pages WHERE pagename = 'tag'
21 0.0012 0.0011899471282959 
SELECT * FROM categorygroups ORDER BY sortorder ASC
22 0.0007 0.00066590309143066 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
23 0.0069 0.0068860054016113 
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
24 0.0005 0.0004730224609375 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
25 0.0012 0.0012061595916748 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
26 0.0005 0.0004730224609375 
SELECT id FROM categories WHERE parent_id = '26'
27 0.0053 0.0052540302276611 
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
28 0.0005 0.00046515464782715 
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
29 0.0005 0.00051116943359375 
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
30 0.0013 0.0013430118560791 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
31 0.0004 0.00041079521179199 
SELECT * FROM categorygroups WHERE id = '1'
32 0.0032 0.0032250881195068 
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
33 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 = 27
34 0.0004 0.00035691261291504 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
35 0.0004 0.00040411949157715 
SELECT id FROM categories WHERE parent_id = '27'
36 0.0034 0.0034480094909668 
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
37 0.0005 0.0004889965057373 
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
38 0.0006 0.00059700012207031 
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
39 0.0004 0.00043797492980957 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
40 0.0005 0.00052499771118164 
SELECT * FROM categorygroups WHERE id = '1'
41 0.0018 0.001755952835083 
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
42 0.0005 0.00046682357788086 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
43 0.0004 0.00038409233093262 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
44 0.0004 0.00037312507629395 
SELECT id FROM categories WHERE parent_id = '28'
45 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
46 0.0005 0.00050210952758789 
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
47 0.0005 0.00046086311340332 
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
48 0.0005 0.00045490264892578 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
49 0.0004 0.00038599967956543 
SELECT * FROM categorygroups WHERE id = '1'
50 0.0005 0.00054502487182617 
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
51 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 = 29
52 0.0004 0.00038599967956543 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
53 0.0004 0.00044417381286621 
SELECT id FROM categories WHERE parent_id = '29'
54 0.0007 0.00065708160400391 
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
55 0.0005 0.00052714347839355 
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
56 0.0006 0.00057196617126465 
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
57 0.0004 0.00043797492980957 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
58 0.0005 0.00045895576477051 
SELECT * FROM categorygroups WHERE id = '1'
59 0.0006 0.0005950927734375 
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
60 0.0005 0.0004889965057373 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
61 0.0004 0.00037002563476562 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
62 0.0004 0.00037217140197754 
SELECT id FROM categories WHERE parent_id = '30'
63 0.0006 0.00061607360839844 
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
64 0.0005 0.00046396255493164 
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
65 0.0005 0.00046801567077637 
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
66 0.0005 0.00046205520629883 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
67 0.0004 0.00043606758117676 
SELECT * FROM categorygroups WHERE id = '1'
68 0.0006 0.00059008598327637 
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
69 0.0004 0.00040912628173828 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
70 0.0003 0.00034499168395996 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
71 0.0004 0.00035285949707031 
SELECT id FROM categories WHERE parent_id = '31'
72 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 (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
73 0.0006 0.00056695938110352 
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
74 0.0005 0.00051188468933105 
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
75 0.0006 0.0005500316619873 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
76 0.0004 0.00043201446533203 
SELECT * FROM categorygroups WHERE id = '1'
77 0.0005 0.00046801567077637 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
78 0.0015 0.0014910697937012 
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
79 0.0017 0.001690149307251 
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
80 0.0005 0.00049400329589844 
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
81 0.0012 0.0011770725250244 
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
82 0.0011 0.001079797744751 
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
83 0.0008 0.00080204010009766 
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
84 0.7518 0.75175285339355 
SELECT * FROM ipgeocountries WHERE INET_ATON('13.58.212.163') >= INET_ATON(ip_start) AND INET_ATON('13.58.212.163') <= INET_ATON(ip_end)
85 0.0021 0.0021440982818604 
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
86 0.0013 0.001262903213501 
SELECT * FROM countryredirects WHERE countrycode = 'US'
87 0.0095 0.0095219612121582 
SELECT * FROM tags WHERE pagename = 'cafe'
88 0.0066 0.006619930267334 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
89 0.0016 0.0016078948974609 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
90 0.0016 0.0015938282012939 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
91 0.0077 0.0076708793640137 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
92 0.0015 0.0015487670898438 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
93 0.0005 0.00050520896911621 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
94 0.0020 0.0019738674163818 
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t WHERE p.id = t.product_id AND parent_id = 0 AND t.tag_id = '91' AND hidden = 0 AND enabled = 1  AND 1 = 1
95 0.0025 0.0024840831756592 
SELECT DISTINCT(p.id), p.*, IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank FROM products p, product_tags t WHERE p.id = t.product_id AND p.parent_id = 0 AND t.tag_id = '91' AND hidden = 0 AND enabled = 1  AND 1 = 1 ORDER BY salesrank ASC LIMIT 54, 18
96 0.0013 0.001262903213501 
SELECT * FROM productimages WHERE product_id = '4175' ORDER BY sortorder ASC
97 0.0013 0.0012619495391846 
SELECT * FROM product_image_select WHERE product_id = '4175'
98 0.0011 0.0010910034179688 
SELECT * FROM productcustomimages WHERE product_id = '4175'
99 0.0018 0.0017938613891602 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4175' AND a.name = n.originalname
100 0.0013 0.0012819766998291 
SELECT * FROM productoffers WHERE product_id = '4175' AND merchantid = 'A1X6FK5RDHNB96'
101 0.0004 0.00037097930908203 
SELECT * FROM productoffers
                WHERE product_id = '4175' AND price > 0
                ORDER BY price ASC LIMIT 1
102 0.0003 0.00030303001403809 
SELECT * FROM productoffers
                WHERE product_id = 4175
                ORDER BY price ASC LIMIT 1
103 0.0005 0.00047898292541504 
SELECT value FROM productattributes
                WHERE product_id = '4175'
                AND name = 'ListPriceAmount'
104 0.0004 0.00036501884460449 
SELECT value FROM productattributes WHERE product_id = '4175' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
105 0.0004 0.00042104721069336 
SELECT * FROM productimages WHERE product_id = '4311' ORDER BY sortorder ASC
106 0.0005 0.00051403045654297 
SELECT * FROM product_image_select WHERE product_id = '4311'
107 0.0003 0.00033092498779297 
SELECT * FROM productcustomimages WHERE product_id = '4311'
108 0.0009 0.00088000297546387 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4311' AND a.name = n.originalname
109 0.0004 0.00044393539428711 
SELECT * FROM productoffers WHERE product_id = '4311' AND merchantid = 'A1X6FK5RDHNB96'
110 0.0003 0.00034713745117188 
SELECT * FROM productoffers
                WHERE product_id = '4311' AND price > 0
                ORDER BY price ASC LIMIT 1
111 0.0004 0.00037598609924316 
SELECT value FROM productattributes WHERE product_id = '4311' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
112 0.0004 0.00041508674621582 
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
113 0.0005 0.00053095817565918 
SELECT * FROM product_image_select WHERE product_id = '4312'
114 0.0003 0.00032997131347656 
SELECT * FROM productcustomimages WHERE product_id = '4312'
115 0.0009 0.00085306167602539 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
116 0.0004 0.00040507316589355 
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
117 0.0004 0.00036811828613281 
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
118 0.0004 0.00039100646972656 
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
119 0.0004 0.00039291381835938 
SELECT * FROM productimages WHERE product_id = '1378' ORDER BY sortorder ASC
120 0.0005 0.00050997734069824 
SELECT * FROM product_image_select WHERE product_id = '1378'
121 0.0004 0.00038290023803711 
SELECT * FROM productcustomimages WHERE product_id = '1378'
122 0.0007 0.00069594383239746 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1378' AND a.name = n.originalname
123 0.0004 0.00043892860412598 
SELECT * FROM productoffers WHERE product_id = '1378' AND merchantid = 'A1X6FK5RDHNB96'
124 0.0003 0.0003211498260498 
SELECT * FROM productoffers
                WHERE product_id = '1378' AND price > 0
                ORDER BY price ASC LIMIT 1
125 0.0003 0.00029397010803223 
SELECT * FROM productoffers
                WHERE product_id = 1378
                ORDER BY price ASC LIMIT 1
126 0.0004 0.00037407875061035 
SELECT value FROM productattributes
                WHERE product_id = '1378'
                AND name = 'ListPriceAmount'
127 0.0004 0.00039505958557129 
SELECT value FROM productattributes WHERE product_id = '1378' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
128 0.0005 0.00053501129150391 
SELECT * FROM productimages WHERE product_id = '964' ORDER BY sortorder ASC
129 0.0005 0.00051498413085938 
SELECT * FROM product_image_select WHERE product_id = '964'
130 0.0003 0.0003349781036377 
SELECT * FROM productcustomimages WHERE product_id = '964'
131 0.0009 0.00091910362243652 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '964' AND a.name = n.originalname
132 0.0005 0.00045108795166016 
SELECT * FROM productoffers WHERE product_id = '964' AND merchantid = 'A1X6FK5RDHNB96'
133 0.0003 0.00032901763916016 
SELECT * FROM productoffers
                WHERE product_id = '964' AND price > 0
                ORDER BY price ASC LIMIT 1
134 0.0003 0.00029611587524414 
SELECT * FROM productoffers
                WHERE product_id = 964
                ORDER BY price ASC LIMIT 1
135 0.0004 0.0003819465637207 
SELECT value FROM productattributes
                WHERE product_id = '964'
                AND name = 'ListPriceAmount'
136 0.0004 0.00037503242492676 
SELECT value FROM productattributes WHERE product_id = '964' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
137 0.0005 0.00047993659973145 
SELECT * FROM productimages WHERE product_id = '4895' ORDER BY sortorder ASC
138 0.0005 0.00047993659973145 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4895' AND p.id = pi.product_id ORDER BY pi.sortorder
139 0.0006 0.00055885314941406 
SELECT * FROM product_image_select WHERE product_id = '4895'
140 0.0004 0.00036096572875977 
SELECT * FROM productcustomimages WHERE product_id = '4895'
141 0.0006 0.00055599212646484 
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 = '4895'
                GROUP BY o.product_id
142 0.0032 0.0032448768615723 
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     = '4895'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
143 0.0006 0.00056195259094238 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4895
144 0.0010 0.00099515914916992 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4895' AND a.name = n.originalname
145 0.0004 0.0004270076751709 
SELECT * FROM productoffers WHERE product_id = '4895' AND merchantid = 'A1X6FK5RDHNB96'
146 0.0004 0.00040698051452637 
SELECT * FROM productoffers
                WHERE product_id = '4895' AND price > 0
                ORDER BY price ASC LIMIT 1
147 0.0004 0.00043892860412598 
SELECT * FROM productoffers
                WHERE product_id = 4895
                ORDER BY price ASC LIMIT 1
148 0.0005 0.00046110153198242 
SELECT value FROM productattributes
                WHERE product_id = '4895'
                AND name = 'ListPriceAmount'
149 0.0005 0.00051403045654297 
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 = '4895'
                GROUP BY o.product_id
150 0.0007 0.00074410438537598 
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     = '4895'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
151 0.0004 0.00044512748718262 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4895
152 0.0006 0.00060105323791504 
SELECT value FROM productattributes WHERE product_id = '4895' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
153 0.0008 0.00077199935913086 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4895'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
154 0.0006 0.00058794021606445 
SELECT * FROM productimages WHERE product_id = '2711' ORDER BY sortorder ASC
155 0.0007 0.00067591667175293 
SELECT * FROM product_image_select WHERE product_id = '2711'
156 0.0004 0.00041294097900391 
SELECT * FROM productcustomimages WHERE product_id = '2711'
157 0.0012 0.0011739730834961 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2711' AND a.name = n.originalname
158 0.0006 0.00055193901062012 
SELECT * FROM productoffers WHERE product_id = '2711' AND merchantid = 'A1X6FK5RDHNB96'
159 0.0004 0.00041985511779785 
SELECT * FROM productoffers
                WHERE product_id = '2711' AND price > 0
                ORDER BY price ASC LIMIT 1
160 0.0004 0.00039005279541016 
SELECT * FROM productoffers
                WHERE product_id = 2711
                ORDER BY price ASC LIMIT 1
161 0.0005 0.00051593780517578 
SELECT value FROM productattributes
                WHERE product_id = '2711'
                AND name = 'ListPriceAmount'
162 0.0005 0.00049400329589844 
SELECT value FROM productattributes WHERE product_id = '2711' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
163 0.0005 0.00049209594726562 
SELECT * FROM productimages WHERE product_id = '2133' ORDER BY sortorder ASC
164 0.0006 0.00061607360839844 
SELECT * FROM product_image_select WHERE product_id = '2133'
165 0.0003 0.00034403800964355 
SELECT * FROM productcustomimages WHERE product_id = '2133'
166 0.0008 0.00081706047058105 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2133' AND a.name = n.originalname
167 0.0004 0.00043582916259766 
SELECT * FROM productoffers WHERE product_id = '2133' AND merchantid = 'A1X6FK5RDHNB96'
168 0.0005 0.00049495697021484 
SELECT * FROM productoffers
                WHERE product_id = '2133' AND price > 0
                ORDER BY price ASC LIMIT 1
169 0.0003 0.00032711029052734 
SELECT * FROM productoffers
                WHERE product_id = 2133
                ORDER BY price ASC LIMIT 1
170 0.0003 0.00034499168395996 
SELECT value FROM productattributes
                WHERE product_id = '2133'
                AND name = 'ListPriceAmount'
171 0.0004 0.00036096572875977 
SELECT value FROM productattributes WHERE product_id = '2133' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
172 0.0005 0.00046491622924805 
SELECT * FROM productimages WHERE product_id = '2356' ORDER BY sortorder ASC
173 0.0005 0.00052499771118164 
SELECT * FROM product_image_select WHERE product_id = '2356'
174 0.0003 0.00032901763916016 
SELECT * FROM productcustomimages WHERE product_id = '2356'
175 0.0009 0.00092101097106934 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2356' AND a.name = n.originalname
176 0.0004 0.0004420280456543 
SELECT * FROM productoffers WHERE product_id = '2356' AND merchantid = 'A1X6FK5RDHNB96'
177 0.0004 0.00037693977355957 
SELECT * FROM productoffers
                WHERE product_id = '2356' AND price > 0
                ORDER BY price ASC LIMIT 1
178 0.0003 0.00031590461730957 
SELECT * FROM productoffers
                WHERE product_id = 2356
                ORDER BY price ASC LIMIT 1
179 0.0003 0.00034809112548828 
SELECT value FROM productattributes
                WHERE product_id = '2356'
                AND name = 'ListPriceAmount'
180 0.0004 0.00038909912109375 
SELECT value FROM productattributes WHERE product_id = '2356' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
181 0.0004 0.00042200088500977 
SELECT * FROM productimages WHERE product_id = '2440' ORDER BY sortorder ASC
182 0.0006 0.00055098533630371 
SELECT * FROM product_image_select WHERE product_id = '2440'
183 0.0004 0.00036501884460449 
SELECT * FROM productcustomimages WHERE product_id = '2440'
184 0.0008 0.00076103210449219 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2440' AND a.name = n.originalname
185 0.0005 0.0005180835723877 
SELECT * FROM productoffers WHERE product_id = '2440' AND merchantid = 'A1X6FK5RDHNB96'
186 0.0004 0.00037908554077148 
SELECT * FROM productoffers
                WHERE product_id = '2440' AND price > 0
                ORDER BY price ASC LIMIT 1
187 0.0003 0.00031208992004395 
SELECT * FROM productoffers
                WHERE product_id = 2440
                ORDER BY price ASC LIMIT 1
188 0.0004 0.00037288665771484 
SELECT value FROM productattributes
                WHERE product_id = '2440'
                AND name = 'ListPriceAmount'
189 0.0004 0.00042200088500977 
SELECT value FROM productattributes WHERE product_id = '2440' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
190 0.0005 0.00049304962158203 
SELECT * FROM productimages WHERE product_id = '2447' ORDER BY sortorder ASC
191 0.0006 0.00055193901062012 
SELECT * FROM product_image_select WHERE product_id = '2447'
192 0.0005 0.00045418739318848 
SELECT * FROM productcustomimages WHERE product_id = '2447'
193 0.0007 0.00074005126953125 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2447' AND a.name = n.originalname
194 0.0006 0.00055408477783203 
SELECT * FROM productoffers WHERE product_id = '2447' AND merchantid = 'A1X6FK5RDHNB96'
195 0.0004 0.00041699409484863 
SELECT * FROM productoffers
                WHERE product_id = '2447' AND price > 0
                ORDER BY price ASC LIMIT 1
196 0.0003 0.00034999847412109 
SELECT * FROM productoffers
                WHERE product_id = 2447
                ORDER BY price ASC LIMIT 1
197 0.0004 0.00039911270141602 
SELECT value FROM productattributes
                WHERE product_id = '2447'
                AND name = 'ListPriceAmount'
198 0.0004 0.00040888786315918 
SELECT value FROM productattributes WHERE product_id = '2447' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
199 0.0004 0.00042104721069336 
SELECT * FROM productimages WHERE product_id = '2598' ORDER BY sortorder ASC
200 0.0005 0.00049805641174316 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2598' AND p.id = pi.product_id ORDER BY pi.sortorder
201 0.0006 0.0005640983581543 
SELECT * FROM product_image_select WHERE product_id = '2598'
202 0.0004 0.00039196014404297 
SELECT * FROM productcustomimages WHERE product_id = '2598'
203 0.0005 0.00049400329589844 
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 = '2598'
                GROUP BY o.product_id
204 0.0005 0.00053906440734863 
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     = '2598'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
205 0.0003 0.00034999847412109 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2598
206 0.0010 0.0010309219360352 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2598' AND a.name = n.originalname
207 0.0004 0.00035810470581055 
SELECT * FROM productoffers WHERE product_id = '2598' AND merchantid = 'A1X6FK5RDHNB96'
208 0.0004 0.00036096572875977 
SELECT * FROM productoffers
                WHERE product_id = '2598' AND price > 0
                ORDER BY price ASC LIMIT 1
209 0.0003 0.00033783912658691 
SELECT * FROM productoffers
                WHERE product_id = 2598
                ORDER BY price ASC LIMIT 1
210 0.0004 0.00037288665771484 
SELECT value FROM productattributes
                WHERE product_id = '2598'
                AND name = 'ListPriceAmount'
211 0.0004 0.00037598609924316 
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 = '2598'
                GROUP BY o.product_id
212 0.0005 0.0005338191986084 
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     = '2598'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
213 0.0004 0.00035190582275391 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2598
214 0.0005 0.00052499771118164 
SELECT value FROM productattributes WHERE product_id = '2598' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
215 0.0004 0.00035500526428223 
SELECT * FROM products WHERE parent_id = '2598'
216 0.0004 0.00044703483581543 
SELECT * FROM productimages WHERE product_id = '2619' ORDER BY sortorder ASC
217 0.0006 0.0006248950958252 
SELECT * FROM product_image_select WHERE product_id = '2619'
218 0.0004 0.00037288665771484 
SELECT * FROM productcustomimages WHERE product_id = '2619'
219 0.0009 0.00089502334594727 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2619' AND a.name = n.originalname
220 0.0004 0.00042319297790527 
SELECT * FROM productoffers WHERE product_id = '2619' AND merchantid = 'A1X6FK5RDHNB96'
221 0.0004 0.0003659725189209 
SELECT * FROM productoffers
                WHERE product_id = '2619' AND price > 0
                ORDER BY price ASC LIMIT 1
222 0.0003 0.00031805038452148 
SELECT * FROM productoffers
                WHERE product_id = 2619
                ORDER BY price ASC LIMIT 1
223 0.0003 0.00033211708068848 
SELECT value FROM productattributes
                WHERE product_id = '2619'
                AND name = 'ListPriceAmount'
224 0.0004 0.00037384033203125 
SELECT value FROM productattributes WHERE product_id = '2619' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
225 0.0004 0.00043106079101562 
SELECT * FROM productimages WHERE product_id = '2637' ORDER BY sortorder ASC
226 0.0006 0.00055313110351562 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2637' AND p.id = pi.product_id ORDER BY pi.sortorder
227 0.0006 0.00060415267944336 
SELECT * FROM product_image_select WHERE product_id = '2637'
228 0.0004 0.00040292739868164 
SELECT * FROM productcustomimages WHERE product_id = '2637'
229 0.0005 0.00046801567077637 
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 = '2637'
                GROUP BY o.product_id
230 0.0006 0.00055408477783203 
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     = '2637'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
231 0.0004 0.0003821849822998 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2637
232 0.0010 0.0010159015655518 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2637' AND a.name = n.originalname
233 0.0003 0.00034713745117188 
SELECT * FROM productoffers WHERE product_id = '2637' AND merchantid = 'A1X6FK5RDHNB96'
234 0.0004 0.00038409233093262 
SELECT * FROM productoffers
                WHERE product_id = '2637' AND price > 0
                ORDER BY price ASC LIMIT 1
235 0.0004 0.00036001205444336 
SELECT * FROM productoffers
                WHERE product_id = 2637
                ORDER BY price ASC LIMIT 1
236 0.0004 0.00036382675170898 
SELECT value FROM productattributes
                WHERE product_id = '2637'
                AND name = 'ListPriceAmount'
237 0.0004 0.00039815902709961 
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 = '2637'
                GROUP BY o.product_id
238 0.0006 0.00056004524230957 
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     = '2637'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
239 0.0004 0.00035214424133301 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2637
240 0.0005 0.00049805641174316 
SELECT value FROM productattributes WHERE product_id = '2637' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
241 0.0006 0.00057005882263184 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '2637'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'PackageQuantity'
                GROUP BY o.value
                ORDER BY o.value ASC
242 0.0004 0.00044798851013184 
SELECT * FROM products WHERE parent_id = '2637'
243 0.0005 0.00050520896911621 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2638' AND a.name = n.originalname
244 0.0004 0.00043296813964844 
SELECT * FROM productoffers WHERE product_id = '2638' AND merchantid = 'A1X6FK5RDHNB96'
245 0.0004 0.00035810470581055 
SELECT * FROM productoffers
                WHERE product_id = '2638' AND price > 0
                ORDER BY price ASC LIMIT 1
246 0.0003 0.00032997131347656 
SELECT * FROM productoffers
                WHERE product_id = 2638
                ORDER BY price ASC LIMIT 1
247 0.0004 0.00035810470581055 
SELECT value FROM productattributes
                WHERE product_id = '2638'
                AND name = 'ListPriceAmount'
248 0.0005 0.00051212310791016 
SELECT * FROM productimages WHERE product_id = '2074' ORDER BY sortorder ASC
249 0.0008 0.00078010559082031 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2074' AND p.id = pi.product_id ORDER BY pi.sortorder
250 0.0005 0.0005488395690918 
SELECT * FROM product_image_select WHERE product_id = '2074'
251 0.0004 0.00040602684020996 
SELECT * FROM productcustomimages WHERE product_id = '2074'
252 0.0005 0.0005490779876709 
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 = '2074'
                GROUP BY o.product_id
253 0.0007 0.00069308280944824 
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     = '2074'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
254 0.0011 0.0011019706726074 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2074
255 0.0019 0.0018761157989502 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2074' AND a.name = n.originalname
256 0.0007 0.0006568431854248 
SELECT * FROM productoffers WHERE product_id = '2074' AND merchantid = 'A1X6FK5RDHNB96'
257 0.0006 0.00064802169799805 
SELECT * FROM productoffers
                WHERE product_id = '2074' AND price > 0
                ORDER BY price ASC LIMIT 1
258 0.0005 0.0005490779876709 
SELECT * FROM productoffers
                WHERE product_id = 2074
                ORDER BY price ASC LIMIT 1
259 0.0007 0.00072288513183594 
SELECT value FROM productattributes
                WHERE product_id = '2074'
                AND name = 'ListPriceAmount'
260 0.0008 0.00082707405090332 
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 = '2074'
                GROUP BY o.product_id
261 0.0016 0.0015740394592285 
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     = '2074'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
262 0.0007 0.00074505805969238 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2074
263 0.0010 0.0010359287261963 
SELECT value FROM productattributes WHERE product_id = '2074' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
264 0.0015 0.001478910446167 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '2074'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
265 0.0010 0.00095605850219727 
SELECT * FROM productimages WHERE product_id = '2663' ORDER BY sortorder ASC
266 0.0010 0.0010349750518799 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2663' AND p.id = pi.product_id ORDER BY pi.sortorder
267 0.0016 0.0016100406646729 
SELECT * FROM product_image_select WHERE product_id = '2663'
268 0.0010 0.00099420547485352 
SELECT * FROM productcustomimages WHERE product_id = '2663'
269 0.0011 0.0010788440704346 
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 = '2663'
                GROUP BY o.product_id
270 0.0012 0.0011720657348633 
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     = '2663'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
271 0.0007 0.00066184997558594 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2663
272 0.0018 0.0017731189727783 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2663' AND a.name = n.originalname
273 0.0006 0.00056004524230957 
SELECT * FROM productoffers WHERE product_id = '2663' AND merchantid = 'A1X6FK5RDHNB96'
274 0.0006 0.00057196617126465 
SELECT * FROM productoffers
                WHERE product_id = '2663' AND price > 0
                ORDER BY price ASC LIMIT 1
275 0.0005 0.00052595138549805 
SELECT * FROM productoffers
                WHERE product_id = 2663
                ORDER BY price ASC LIMIT 1
276 0.0006 0.00058412551879883 
SELECT value FROM productattributes
                WHERE product_id = '2663'
                AND name = 'ListPriceAmount'
277 0.0006 0.00060796737670898 
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 = '2663'
                GROUP BY o.product_id
278 0.0012 0.0011520385742188 
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     = '2663'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
279 0.0006 0.00057888031005859 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2663
280 0.0009 0.0009000301361084 
SELECT value FROM productattributes WHERE product_id = '2663' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
281 0.0010 0.001025915145874 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '2663'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
282 0.0006 0.00057792663574219 
SELECT * FROM products WHERE parent_id = '2663'
283 0.0008 0.00077414512634277 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4887' AND a.name = n.originalname
284 0.0009 0.00094914436340332 
SELECT * FROM productoffers WHERE product_id = '4887' AND merchantid = 'A1X6FK5RDHNB96'
285 0.0007 0.00073003768920898 
SELECT * FROM productoffers
                WHERE product_id = '4887' AND price > 0
                ORDER BY price ASC LIMIT 1
286 0.0021 0.0021319389343262 
SELECT * FROM productoffers
                WHERE product_id = 4887
                ORDER BY price ASC LIMIT 1
287 0.0006 0.00063991546630859 
SELECT value FROM productattributes
                WHERE product_id = '4887'
                AND name = 'ListPriceAmount'
288 0.0008 0.00082898139953613 
SELECT * FROM productimages WHERE product_id = '2023' ORDER BY sortorder ASC
289 0.0009 0.00090289115905762 
SELECT * FROM product_image_select WHERE product_id = '2023'
290 0.0006 0.00055384635925293 
SELECT * FROM productcustomimages WHERE product_id = '2023'
291 0.0012 0.0011680126190186 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2023' AND a.name = n.originalname
292 0.0007 0.00072979927062988 
SELECT * FROM productoffers WHERE product_id = '2023' AND merchantid = 'A1X6FK5RDHNB96'
293 0.0005 0.0005180835723877 
SELECT * FROM productoffers
                WHERE product_id = '2023' AND price > 0
                ORDER BY price ASC LIMIT 1
294 0.0005 0.0005180835723877 
SELECT * FROM productoffers
                WHERE product_id = 2023
                ORDER BY price ASC LIMIT 1
295 0.0005 0.00053596496582031 
SELECT value FROM productattributes
                WHERE product_id = '2023'
                AND name = 'ListPriceAmount'
296 0.0007 0.00067305564880371 
SELECT value FROM productattributes WHERE product_id = '2023' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
297 0.0007 0.00074100494384766 
SELECT * FROM productimages WHERE product_id = '1939' ORDER BY sortorder ASC
298 0.0009 0.00091981887817383 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1939' AND p.id = pi.product_id ORDER BY pi.sortorder
299 0.0009 0.00094199180603027 
SELECT * FROM product_image_select WHERE product_id = '1939'
300 0.0006 0.00062394142150879 
SELECT * FROM productcustomimages WHERE product_id = '1939'
301 0.0007 0.00070691108703613 
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 = '1939'
                GROUP BY o.product_id
302 0.0009 0.00089097023010254 
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     = '1939'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
303 0.0006 0.00056600570678711 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1939
304 0.0018 0.0017969608306885 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1939' AND a.name = n.originalname
305 0.0006 0.00058388710021973 
SELECT * FROM productoffers WHERE product_id = '1939' AND merchantid = 'A1X6FK5RDHNB96'
306 0.0005 0.00048303604125977 
SELECT * FROM productoffers
                WHERE product_id = '1939' AND price > 0
                ORDER BY price ASC LIMIT 1
307 0.0004 0.00037193298339844 
SELECT * FROM productoffers
                WHERE product_id = 1939
                ORDER BY price ASC LIMIT 1
308 0.0004 0.0004429817199707 
SELECT value FROM productattributes
                WHERE product_id = '1939'
                AND name = 'ListPriceAmount'
309 0.0005 0.00046896934509277 
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 = '1939'
                GROUP BY o.product_id
310 0.0007 0.00073599815368652 
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     = '1939'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
311 0.0005 0.00050687789916992 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1939
312 0.0007 0.00072097778320312 
SELECT value FROM productattributes WHERE product_id = '1939' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
313 0.0005 0.0004570484161377 
SELECT * FROM products WHERE parent_id = '1939'
314 0.0021 0.0021390914916992 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4175' ORDER BY timestamp DESC
315 0.0004 0.00041103363037109 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4311' ORDER BY timestamp DESC
316 0.0003 0.00034785270690918 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4312' ORDER BY timestamp DESC
317 0.0004 0.00039410591125488 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1378' ORDER BY timestamp DESC
318 0.0004 0.00037002563476562 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '964' ORDER BY timestamp DESC
319 0.0005 0.00048184394836426 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4895' ORDER BY timestamp DESC
320 0.0004 0.00037193298339844 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2711' ORDER BY timestamp DESC
321 0.0004 0.00035500526428223 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2133' ORDER BY timestamp DESC
322 0.0003 0.00032615661621094 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2356' ORDER BY timestamp DESC
323 0.0003 0.00031304359436035 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2440' ORDER BY timestamp DESC
324 0.0003 0.00029802322387695 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2447' ORDER BY timestamp DESC
325 0.0003 0.00029182434082031 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2598' ORDER BY timestamp DESC
326 0.0003 0.00032401084899902 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2619' ORDER BY timestamp DESC
327 0.0004 0.00037503242492676 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2637' ORDER BY timestamp DESC
328 0.0003 0.00034093856811523 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2074' ORDER BY timestamp DESC
329 0.0004 0.00036191940307617 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2663' ORDER BY timestamp DESC
330 0.0003 0.00032401084899902 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2023' ORDER BY timestamp DESC
331 0.0003 0.00031113624572754 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1939' ORDER BY timestamp DESC
332 0.0016 0.0016160011291504 
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
333 0.0014 0.0014030933380127 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
334 0.0004 0.0003819465637207 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
335 0.0148 0.014832019805908 
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
336 0.0015 0.0015151500701904 
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
337 0.0005 0.00051403045654297 
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
338 0.0006 0.00055480003356934 
SELECT * FROM products WHERE id = 1626
339 0.0004 0.00035190582275391 
SELECT * FROM products WHERE id = 4041
340 0.0004 0.00043916702270508 
SELECT * FROM products WHERE id = 4312
341 0.0005 0.00045514106750488 
SELECT * FROM products WHERE id = 777
342 0.0005 0.00049400329589844 
SELECT * FROM products WHERE id = 3881
343 0.0004 0.00039386749267578 
SELECT * FROM products WHERE id = 4213
344 0.0003 0.0003209114074707 
SELECT * FROM products WHERE id = '1626'
345 0.0004 0.00042104721069336 
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
346 0.0006 0.00056290626525879 
SELECT * FROM product_image_select WHERE product_id = '1626'
347 0.0004 0.00037193298339844 
SELECT * FROM productcustomimages WHERE product_id = '1626'
348 0.0009 0.00089693069458008 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
349 0.0005 0.00046896934509277 
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
350 0.0004 0.00040602684020996 
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
351 0.0004 0.00040602684020996 
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
352 0.0005 0.00047397613525391 
SELECT * FROM products WHERE id = '4041'
353 0.0004 0.00041484832763672 
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
354 0.0006 0.00057697296142578 
SELECT * FROM product_image_select WHERE product_id = '4041'
355 0.0004 0.00035881996154785 
SELECT * FROM productcustomimages WHERE product_id = '4041'
356 0.0011 0.0010640621185303 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
357 0.0004 0.00044989585876465 
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
358 0.0004 0.00037598609924316 
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
359 0.0004 0.00039100646972656 
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
360 0.0005 0.00050497055053711 
SELECT * FROM products WHERE id = '4312'
361 0.0004 0.00042104721069336 
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
362 0.0005 0.00054788589477539 
SELECT * FROM product_image_select WHERE product_id = '4312'
363 0.0004 0.0003819465637207 
SELECT * FROM productcustomimages WHERE product_id = '4312'
364 0.0010 0.00098299980163574 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
365 0.0005 0.00045394897460938 
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
366 0.0004 0.00038695335388184 
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
367 0.0004 0.00043511390686035 
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
368 0.0005 0.00050783157348633 
SELECT * FROM products WHERE id = '777'
369 0.0004 0.00041604042053223 
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
370 0.0006 0.00057101249694824 
SELECT * FROM product_image_select WHERE product_id = '777'
371 0.0004 0.0003669261932373 
SELECT * FROM productcustomimages WHERE product_id = '777'
372 0.0009 0.00093889236450195 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
373 0.0004 0.00042414665222168 
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
374 0.0004 0.00036287307739258 
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
375 0.0004 0.00036501884460449 
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
376 0.0006 0.00055098533630371 
SELECT * FROM products WHERE id = '3881'
377 0.0005 0.00047898292541504 
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
378 0.0006 0.00055503845214844 
SELECT * FROM product_image_select WHERE product_id = '3881'
379 0.0004 0.00038409233093262 
SELECT * FROM productcustomimages WHERE product_id = '3881'
380 0.0011 0.0010850429534912 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
381 0.0005 0.0004570484161377 
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
382 0.0004 0.00038695335388184 
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
383 0.0004 0.00041007995605469 
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
384 0.0005 0.00047802925109863 
SELECT * FROM products WHERE id = '4213'
385 0.0005 0.00048017501831055 
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
386 0.0005 0.00054216384887695 
SELECT * FROM product_image_select WHERE product_id = '4213'
387 0.0004 0.00037097930908203 
SELECT * FROM productcustomimages WHERE product_id = '4213'
388 0.0011 0.0011160373687744 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
389 0.0005 0.00045204162597656 
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
390 0.0005 0.00053501129150391 
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
391 0.0004 0.00039100646972656 
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
392 0.0018 0.0017740726470947 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
393 0.0006 0.00060606002807617 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
394 0.0020 0.002032995223999 
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
395 0.0015 0.0014870166778564 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
396 0.0005 0.00045299530029297 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
397 0.0005 0.00049781799316406 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
398 0.0006 0.00061702728271484 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'