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.6619489192963 371 1.2476 0


No Amazon API Requests Made.


App Debug - Total Time 1.6619489192963 seconds

Number Time From Start Name Description
1 0.28673100471497 Initialise Initialise FSB Function
2 0.30820488929749 App Controller Start Start of the App controller (called before the controller of every page)
3 0.33689594268799 Start of getCategoryListByGroup Function Before first category groups query
4 0.33838486671448 After initial query Before first category groups query
5 0.33838582038879 Get Category List for Group Before the call to getCategoryList function
6 0.33838891983032 Start of GetCategoryList function Start of the function
7 0.33839082717896 Before getting categories Query to get specific category list
8 0.33896493911743 After getting categories Query to get specific category list
9 0.33896589279175 Before getting category custom Before call to function getCategoryCustom
10 0.35695600509644 After getting category custom After call to function getCategoryCustom
11 0.35695791244507 Before getting category custom Before call to function getCategoryCustom
12 0.3675229549408 After getting category custom After call to function getCategoryCustom
13 0.36752390861511 Before getting category custom Before call to function getCategoryCustom
14 0.37360692024231 After getting category custom After call to function getCategoryCustom
15 0.37360787391663 Before getting category custom Before call to function getCategoryCustom
16 0.37812280654907 After getting category custom After call to function getCategoryCustom
17 0.37812280654907 Before getting category custom Before call to function getCategoryCustom
18 0.38729286193848 After getting category custom After call to function getCategoryCustom
19 0.38729286193848 Before getting category custom Before call to function getCategoryCustom
20 0.39728093147278 After getting category custom After call to function getCategoryCustom
21 0.39728188514709 End of GetCategoryList function End of the function
22 0.39728689193726 Get Category List for Group Before the call to getCategoryList function
23 0.39728784561157 Start of GetCategoryList function Start of the function
24 0.39728879928589 Before getting categories Query to get specific category list
25 0.39807200431824 End of getCategoryListByGroup Function Before return()
26 1.2528359889984 App Controller End End of the App controller (called before the controller of every page)
27 1.4703528881073 App_after Controller Start Start of the App_after controller (called after the controller of every page)
28 1.4718689918518 Before Get Options Before the call to getOptions in the tpl class
29 1.5239109992981 After Get Options After the call to getOptions in the tpl class
30 1.5239419937134 App_after Controller End End of the App_after controller (called after the controller of every page)
31 1.6619379520416 Finalizing debug Before the debug is output to the page.
32 1.6619479656219 End of App This is the end of the app logging, final timestamp


Query Debug - 371 Database Queries. Total time 1.2476 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0022 0.0022270679473877 
SELECT parameter, value FROM parameters
2 0.0054 0.0053720474243164 
SELECT * FROM `bad_bots`
3 0.0004 0.00035500526428223 
SET time_zone = 'Europe/London'
4 0.0042 0.0042080879211426 
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0039 0.0039339065551758 
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"18.117.172.41\";}'
6 0.0034 0.0034499168395996 
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1747061230'
7 0.0038 0.0037579536437988 
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0008 0.00079202651977539 
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0031 0.0031290054321289 
SELECT id FROM pages WHERE pagename = 'tag' LIMIT 1
10 0.0039 0.0039031505584717 
SELECT id FROM products WHERE pagename = 'tag' AND hidden = 0 LIMIT 1
11 0.0027 0.0026519298553467 
SELECT id FROM ebay_products WHERE pagename = 'tag'
12 0.0022 0.0021600723266602 
SELECT id FROM custom_products WHERE pagename = 'tag'
13 0.0022 0.0021779537200928 
SELECT id FROM categories WHERE pagename = 'tag' LIMIT 1
14 0.0020 0.0020411014556885 
SELECT id FROM manufacturers WHERE pagename = 'tag' LIMIT 1
15 0.0022 0.0021629333496094 
SELECT id FROM bundles WHERE pagename = 'tag' LIMIT 1
16 0.0018 0.0017890930175781 
SELECT id FROM tags WHERE pagename = 'cafe' LIMIT 1
17 0.0025 0.0025360584259033 
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
18 0.0252 0.025223016738892 
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
19 0.0006 0.00059390068054199 
SELECT * FROM pages WHERE pagename = 'tag'
20 0.0015 0.0014810562133789 
SELECT * FROM categorygroups ORDER BY sortorder ASC
21 0.0006 0.0005648136138916 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
22 0.0063 0.0062730312347412 
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
23 0.0005 0.00048685073852539 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
24 0.0012 0.0012359619140625 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
25 0.0004 0.00042080879211426 
SELECT id FROM categories WHERE parent_id = '26'
26 0.0056 0.0056188106536865 
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
27 0.0012 0.0011649131774902 
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
28 0.0006 0.00058507919311523 
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
29 0.0016 0.0016069412231445 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
30 0.0005 0.00051999092102051 
SELECT * FROM categorygroups WHERE id = '1'
31 0.0035 0.003521203994751 
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
32 0.0005 0.00051403045654297 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
33 0.0004 0.00038981437683105 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
34 0.0004 0.00040793418884277 
SELECT id FROM categories WHERE parent_id = '27'
35 0.0036 0.0036220550537109 
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
36 0.0006 0.00064301490783691 
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
37 0.0005 0.00052785873413086 
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
38 0.0005 0.00045609474182129 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
39 0.0004 0.00043892860412598 
SELECT * FROM categorygroups WHERE id = '1'
40 0.0014 0.0014219284057617 
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
41 0.0005 0.00048494338989258 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
42 0.0004 0.0003972053527832 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
43 0.0004 0.00040292739868164 
SELECT id FROM categories WHERE parent_id = '28'
44 0.0014 0.0014200210571289 
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
45 0.0005 0.00048112869262695 
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
46 0.0005 0.00052094459533691 
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
47 0.0005 0.00050187110900879 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
48 0.0004 0.00043106079101562 
SELECT * FROM categorygroups WHERE id = '1'
49 0.0006 0.00057291984558105 
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
50 0.0007 0.00074195861816406 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
51 0.0004 0.00037479400634766 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
52 0.0004 0.00041294097900391 
SELECT id FROM categories WHERE parent_id = '29'
53 0.0007 0.00066399574279785 
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
54 0.0004 0.0004270076751709 
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
55 0.0005 0.00046300888061523 
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
56 0.0004 0.00042605400085449 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
57 0.0004 0.00041389465332031 
SELECT * FROM categorygroups WHERE id = '1'
58 0.0006 0.00058484077453613 
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
59 0.0013 0.0013389587402344 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
60 0.0009 0.00087404251098633 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
61 0.0008 0.0008389949798584 
SELECT id FROM categories WHERE parent_id = '30'
62 0.0016 0.0016038417816162 
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
63 0.0010 0.00099396705627441 
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
64 0.0011 0.0011000633239746 
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
65 0.0010 0.0010421276092529 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
66 0.0008 0.00077319145202637 
SELECT * FROM categorygroups WHERE id = '1'
67 0.0017 0.0017061233520508 
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
68 0.0010 0.00095701217651367 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
69 0.0008 0.00083088874816895 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
70 0.0009 0.00092101097106934 
SELECT id FROM categories WHERE parent_id = '31'
71 0.0018 0.0017549991607666 
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
72 0.0009 0.00090813636779785 
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
73 0.0013 0.001291036605835 
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
74 0.0009 0.000885009765625 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
75 0.0007 0.00070285797119141 
SELECT * FROM categorygroups WHERE id = '1'
76 0.0008 0.00077986717224121 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
77 0.0036 0.0035901069641113 
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
78 0.0040 0.0039889812469482 
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
79 0.0008 0.00083780288696289 
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
80 0.0020 0.0020101070404053 
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
81 0.0015 0.0015020370483398 
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
82 0.0010 0.0010020732879639 
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
83 0.8368 0.8367760181427 
SELECT * FROM ipgeocountries WHERE INET_ATON('18.117.172.41') >= INET_ATON(ip_start) AND INET_ATON('18.117.172.41') <= INET_ATON(ip_end)
84 0.0024 0.0024409294128418 
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
85 0.0012 0.0011570453643799 
SELECT * FROM countryredirects WHERE countrycode = 'US'
86 0.0107 0.010746002197266 
SELECT * FROM tags WHERE pagename = 'cafe'
87 0.0079 0.007936954498291 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
88 0.0027 0.002683162689209 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
89 0.0024 0.0023958683013916 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
90 0.0073 0.007349967956543 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
91 0.0049 0.0048987865447998 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
92 0.0010 0.0010030269622803 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
93 0.0074 0.0074398517608643 
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
94 0.0052 0.0052261352539062 
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 36, 18
95 0.0025 0.0025131702423096 
SELECT * FROM productimages WHERE product_id = '2689' ORDER BY sortorder ASC
96 0.0010 0.00097012519836426 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2689' AND p.id = pi.product_id ORDER BY pi.sortorder
97 0.0023 0.0023179054260254 
SELECT * FROM product_image_select WHERE product_id = '2689'
98 0.0021 0.0020887851715088 
SELECT * FROM productcustomimages WHERE product_id = '2689'
99 0.0024 0.002443790435791 
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 = '2689'
                GROUP BY o.product_id
100 0.0027 0.0027170181274414 
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     = '2689'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
101 0.0006 0.0005950927734375 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2689
102 0.0023 0.002331018447876 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2689' AND a.name = n.originalname
103 0.0007 0.00068497657775879 
SELECT * FROM productoffers WHERE product_id = '2689' AND merchantid = 'A1X6FK5RDHNB96'
104 0.0007 0.00066018104553223 
SELECT * FROM productoffers
                WHERE product_id = '2689' AND price > 0
                ORDER BY price ASC LIMIT 1
105 0.0004 0.00041007995605469 
SELECT * FROM productoffers
                WHERE product_id = 2689
                ORDER BY price ASC LIMIT 1
106 0.0005 0.00046801567077637 
SELECT value FROM productattributes
                WHERE product_id = '2689'
                AND name = 'ListPriceAmount'
107 0.0008 0.00075411796569824 
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 = '2689'
                GROUP BY o.product_id
108 0.0009 0.00087189674377441 
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     = '2689'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
109 0.0005 0.0005190372467041 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2689
110 0.0007 0.00065708160400391 
SELECT value FROM productattributes WHERE product_id = '2689' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
111 0.0004 0.00043082237243652 
SELECT * FROM products WHERE parent_id = '2689'
112 0.0005 0.00048494338989258 
SELECT * FROM productimages WHERE product_id = '3770' ORDER BY sortorder ASC
113 0.0006 0.00060296058654785 
SELECT * FROM product_image_select WHERE product_id = '3770'
114 0.0004 0.00037980079650879 
SELECT * FROM productcustomimages WHERE product_id = '3770'
115 0.0009 0.00093698501586914 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3770' AND a.name = n.originalname
116 0.0006 0.00056195259094238 
SELECT * FROM productoffers WHERE product_id = '3770' AND merchantid = 'A1X6FK5RDHNB96'
117 0.0018 0.001762866973877 
SELECT * FROM productoffers
                WHERE product_id = '3770' AND price > 0
                ORDER BY price ASC LIMIT 1
118 0.0010 0.0010318756103516 
SELECT value FROM productattributes WHERE product_id = '3770' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
119 0.0013 0.0012869834899902 
SELECT * FROM productimages WHERE product_id = '826' ORDER BY sortorder ASC
120 0.0017 0.0016529560089111 
SELECT * FROM product_image_select WHERE product_id = '826'
121 0.0013 0.0012619495391846 
SELECT * FROM productcustomimages WHERE product_id = '826'
122 0.0022 0.0022249221801758 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '826' AND a.name = n.originalname
123 0.0010 0.0010340213775635 
SELECT * FROM productoffers WHERE product_id = '826' AND merchantid = 'A1X6FK5RDHNB96'
124 0.0007 0.00069189071655273 
SELECT * FROM productoffers
                WHERE product_id = '826' AND price > 0
                ORDER BY price ASC LIMIT 1
125 0.0007 0.00066685676574707 
SELECT * FROM productoffers
                WHERE product_id = 826
                ORDER BY price ASC LIMIT 1
126 0.0009 0.00090789794921875 
SELECT value FROM productattributes
                WHERE product_id = '826'
                AND name = 'ListPriceAmount'
127 0.0011 0.0010650157928467 
SELECT value FROM productattributes WHERE product_id = '826' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
128 0.0011 0.001115083694458 
SELECT * FROM productimages WHERE product_id = '1859' ORDER BY sortorder ASC
129 0.0014 0.001399040222168 
SELECT * FROM product_image_select WHERE product_id = '1859'
130 0.0007 0.00073003768920898 
SELECT * FROM productcustomimages WHERE product_id = '1859'
131 0.0028 0.0027580261230469 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1859' AND a.name = n.originalname
132 0.0009 0.00090503692626953 
SELECT * FROM productoffers WHERE product_id = '1859' AND merchantid = 'A1X6FK5RDHNB96'
133 0.0009 0.00087094306945801 
SELECT * FROM productoffers
                WHERE product_id = '1859' AND price > 0
                ORDER BY price ASC LIMIT 1
134 0.0008 0.00082898139953613 
SELECT * FROM productoffers
                WHERE product_id = 1859
                ORDER BY price ASC LIMIT 1
135 0.0007 0.00070786476135254 
SELECT value FROM productattributes
                WHERE product_id = '1859'
                AND name = 'ListPriceAmount'
136 0.0008 0.00079202651977539 
SELECT value FROM productattributes WHERE product_id = '1859' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
137 0.0009 0.00088906288146973 
SELECT * FROM productimages WHERE product_id = '1650' ORDER BY sortorder ASC
138 0.0014 0.0013730525970459 
SELECT * FROM product_image_select WHERE product_id = '1650'
139 0.0006 0.00062298774719238 
SELECT * FROM productcustomimages WHERE product_id = '1650'
140 0.0019 0.0019149780273438 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1650' AND a.name = n.originalname
141 0.0007 0.00068092346191406 
SELECT * FROM productoffers WHERE product_id = '1650' AND merchantid = 'A1X6FK5RDHNB96'
142 0.0007 0.00065803527832031 
SELECT * FROM productoffers
                WHERE product_id = '1650' AND price > 0
                ORDER BY price ASC LIMIT 1
143 0.0005 0.00048184394836426 
SELECT * FROM productoffers
                WHERE product_id = 1650
                ORDER BY price ASC LIMIT 1
144 0.0006 0.00058889389038086 
SELECT value FROM productattributes
                WHERE product_id = '1650'
                AND name = 'ListPriceAmount'
145 0.0008 0.00076508522033691 
SELECT * FROM productimages WHERE product_id = '1465' ORDER BY sortorder ASC
146 0.0016 0.0015740394592285 
SELECT * FROM product_image_select WHERE product_id = '1465'
147 0.0006 0.0006411075592041 
SELECT * FROM productcustomimages WHERE product_id = '1465'
148 0.0029 0.002885103225708 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1465' AND a.name = n.originalname
149 0.0007 0.0007479190826416 
SELECT * FROM productoffers WHERE product_id = '1465' AND merchantid = 'A1X6FK5RDHNB96'
150 0.0005 0.0005190372467041 
SELECT * FROM productoffers
                WHERE product_id = '1465' AND price > 0
                ORDER BY price ASC LIMIT 1
151 0.0004 0.00035190582275391 
SELECT * FROM productoffers
                WHERE product_id = 1465
                ORDER BY price ASC LIMIT 1
152 0.0004 0.00044107437133789 
SELECT value FROM productattributes
                WHERE product_id = '1465'
                AND name = 'ListPriceAmount'
153 0.0006 0.0005638599395752 
SELECT * FROM productimages WHERE product_id = '4136' ORDER BY sortorder ASC
154 0.0009 0.00091195106506348 
SELECT * FROM product_image_select WHERE product_id = '4136'
155 0.0006 0.00056099891662598 
SELECT * FROM productcustomimages WHERE product_id = '4136'
156 0.0016 0.0015559196472168 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4136' AND a.name = n.originalname
157 0.0006 0.00057005882263184 
SELECT * FROM productoffers WHERE product_id = '4136' AND merchantid = 'A1X6FK5RDHNB96'
158 0.0004 0.00041794776916504 
SELECT * FROM productoffers
                WHERE product_id = '4136' AND price > 0
                ORDER BY price ASC LIMIT 1
159 0.0006 0.00062298774719238 
SELECT value FROM productattributes WHERE product_id = '4136' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
160 0.0007 0.00065708160400391 
SELECT * FROM productimages WHERE product_id = '1712' ORDER BY sortorder ASC
161 0.0008 0.00080609321594238 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1712' AND p.id = pi.product_id ORDER BY pi.sortorder
162 0.0007 0.00069689750671387 
SELECT * FROM product_image_select WHERE product_id = '1712'
163 0.0003 0.00034809112548828 
SELECT * FROM productcustomimages WHERE product_id = '1712'
164 0.0005 0.0005028247833252 
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 = '1712'
                GROUP BY o.product_id
165 0.0015 0.0015120506286621 
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     = '1712'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
166 0.0023 0.0022830963134766 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1712
167 0.0028 0.0027761459350586 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1712' AND a.name = n.originalname
168 0.0025 0.0024580955505371 
SELECT * FROM productoffers WHERE product_id = '1712' AND merchantid = 'A1X6FK5RDHNB96'
169 0.0011 0.0010640621185303 
SELECT * FROM productoffers
                WHERE product_id = '1712' AND price > 0
                ORDER BY price ASC LIMIT 1
170 0.0005 0.00052714347839355 
SELECT * FROM productoffers
                WHERE product_id = 1712
                ORDER BY price ASC LIMIT 1
171 0.0005 0.00050806999206543 
SELECT value FROM productattributes
                WHERE product_id = '1712'
                AND name = 'ListPriceAmount'
172 0.0006 0.00062394142150879 
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 = '1712'
                GROUP BY o.product_id
173 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     = '1712'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
174 0.0004 0.00040411949157715 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1712
175 0.0006 0.00063109397888184 
SELECT value FROM productattributes WHERE product_id = '1712' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
176 0.0045 0.0045490264892578 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '1712'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
177 0.0004 0.00043702125549316 
SELECT * FROM products WHERE parent_id = '1712'
178 0.0007 0.00070500373840332 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2881' AND a.name = n.originalname
179 0.0004 0.00044989585876465 
SELECT * FROM productoffers WHERE product_id = '2881' AND merchantid = 'A1X6FK5RDHNB96'
180 0.0004 0.00035715103149414 
SELECT * FROM productoffers
                WHERE product_id = '2881' AND price > 0
                ORDER BY price ASC LIMIT 1
181 0.0004 0.0004279613494873 
SELECT * FROM productoffers
                WHERE product_id = 2881
                ORDER BY price ASC LIMIT 1
182 0.0004 0.00036811828613281 
SELECT value FROM productattributes
                WHERE product_id = '2881'
                AND name = 'ListPriceAmount'
183 0.0006 0.0006098747253418 
SELECT * FROM productimages WHERE product_id = '3849' ORDER BY sortorder ASC
184 0.0006 0.00062012672424316 
SELECT * FROM product_image_select WHERE product_id = '3849'
185 0.0004 0.00041699409484863 
SELECT * FROM productcustomimages WHERE product_id = '3849'
186 0.0010 0.0010139942169189 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3849' AND a.name = n.originalname
187 0.0005 0.00049495697021484 
SELECT * FROM productoffers WHERE product_id = '3849' AND merchantid = 'A1X6FK5RDHNB96'
188 0.0004 0.00036311149597168 
SELECT * FROM productoffers
                WHERE product_id = '3849' AND price > 0
                ORDER BY price ASC LIMIT 1
189 0.0003 0.00033092498779297 
SELECT * FROM productoffers
                WHERE product_id = 3849
                ORDER BY price ASC LIMIT 1
190 0.0004 0.00043582916259766 
SELECT value FROM productattributes
                WHERE product_id = '3849'
                AND name = 'ListPriceAmount'
191 0.0004 0.0004429817199707 
SELECT value FROM productattributes WHERE product_id = '3849' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
192 0.0005 0.00049877166748047 
SELECT * FROM productimages WHERE product_id = '3916' ORDER BY sortorder ASC
193 0.0006 0.00056004524230957 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3916' AND p.id = pi.product_id ORDER BY pi.sortorder
194 0.0006 0.000640869140625 
SELECT * FROM product_image_select WHERE product_id = '3916'
195 0.0004 0.00038886070251465 
SELECT * FROM productcustomimages WHERE product_id = '3916'
196 0.0005 0.00051999092102051 
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 = '3916'
                GROUP BY o.product_id
197 0.0006 0.00063490867614746 
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     = '3916'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
198 0.0004 0.00040888786315918 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3916
199 0.0008 0.00079894065856934 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3916' AND a.name = n.originalname
200 0.0005 0.00048184394836426 
SELECT * FROM productoffers WHERE product_id = '3916' AND merchantid = 'A1X6FK5RDHNB96'
201 0.0005 0.00049114227294922 
SELECT * FROM productoffers
                WHERE product_id = '3916' AND price > 0
                ORDER BY price ASC LIMIT 1
202 0.0004 0.00038313865661621 
SELECT * FROM productoffers
                WHERE product_id = 3916
                ORDER BY price ASC LIMIT 1
203 0.0004 0.00038695335388184 
SELECT value FROM productattributes
                WHERE product_id = '3916'
                AND name = 'ListPriceAmount'
204 0.0004 0.0004119873046875 
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 = '3916'
                GROUP BY o.product_id
205 0.0006 0.00057888031005859 
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     = '3916'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
206 0.0004 0.00043416023254395 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3916
207 0.0005 0.00053000450134277 
SELECT value FROM productattributes WHERE product_id = '3916' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
208 0.0006 0.00060105323791504 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3916'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
209 0.0006 0.00063705444335938 
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
210 0.0006 0.00058507919311523 
SELECT * FROM product_image_select WHERE product_id = '4041'
211 0.0004 0.00039386749267578 
SELECT * FROM productcustomimages WHERE product_id = '4041'
212 0.0014 0.0014340877532959 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
213 0.0005 0.00046396255493164 
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
214 0.0004 0.00041007995605469 
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
215 0.0006 0.00057411193847656 
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
216 0.0005 0.0004889965057373 
SELECT * FROM productimages WHERE product_id = '4114' ORDER BY sortorder ASC
217 0.0006 0.00057888031005859 
SELECT * FROM product_image_select WHERE product_id = '4114'
218 0.0005 0.0004880428314209 
SELECT * FROM productcustomimages WHERE product_id = '4114'
219 0.0011 0.0010910034179688 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4114' AND a.name = n.originalname
220 0.0006 0.00056099891662598 
SELECT * FROM productoffers WHERE product_id = '4114' AND merchantid = 'A1X6FK5RDHNB96'
221 0.0004 0.00040507316589355 
SELECT * FROM productoffers
                WHERE product_id = '4114' AND price > 0
                ORDER BY price ASC LIMIT 1
222 0.0004 0.00038409233093262 
SELECT * FROM productoffers
                WHERE product_id = 4114
                ORDER BY price ASC LIMIT 1
223 0.0005 0.00045394897460938 
SELECT value FROM productattributes
                WHERE product_id = '4114'
                AND name = 'ListPriceAmount'
224 0.0004 0.00044107437133789 
SELECT value FROM productattributes WHERE product_id = '4114' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
225 0.0005 0.0004889965057373 
SELECT * FROM productimages WHERE product_id = '782' ORDER BY sortorder ASC
226 0.0006 0.00056982040405273 
SELECT * FROM product_image_select WHERE product_id = '782'
227 0.0004 0.00040221214294434 
SELECT * FROM productcustomimages WHERE product_id = '782'
228 0.0008 0.00084519386291504 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '782' AND a.name = n.originalname
229 0.0005 0.00046181678771973 
SELECT * FROM productoffers WHERE product_id = '782' AND merchantid = 'A1X6FK5RDHNB96'
230 0.0004 0.00035691261291504 
SELECT * FROM productoffers
                WHERE product_id = '782' AND price > 0
                ORDER BY price ASC LIMIT 1
231 0.0005 0.00045990943908691 
SELECT * FROM productoffers
                WHERE product_id = 782
                ORDER BY price ASC LIMIT 1
232 0.0005 0.00048184394836426 
SELECT value FROM productattributes
                WHERE product_id = '782'
                AND name = 'ListPriceAmount'
233 0.0004 0.00038599967956543 
SELECT value FROM productattributes WHERE product_id = '782' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
234 0.0005 0.00049805641174316 
SELECT * FROM productimages WHERE product_id = '4128' ORDER BY sortorder ASC
235 0.0007 0.00066184997558594 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4128' AND p.id = pi.product_id ORDER BY pi.sortorder
236 0.0006 0.00055789947509766 
SELECT * FROM product_image_select WHERE product_id = '4128'
237 0.0004 0.00040507316589355 
SELECT * FROM productcustomimages WHERE product_id = '4128'
238 0.0005 0.00054597854614258 
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 = '4128'
                GROUP BY o.product_id
239 0.0006 0.00059413909912109 
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     = '4128'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
240 0.0004 0.00037312507629395 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4128
241 0.0008 0.00079703330993652 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4128' AND a.name = n.originalname
242 0.0005 0.00050497055053711 
SELECT * FROM productoffers WHERE product_id = '4128' AND merchantid = 'A1X6FK5RDHNB96'
243 0.0004 0.0003809928894043 
SELECT * FROM productoffers
                WHERE product_id = '4128' AND price > 0
                ORDER BY price ASC LIMIT 1
244 0.0004 0.00040197372436523 
SELECT * FROM productoffers
                WHERE product_id = 4128
                ORDER BY price ASC LIMIT 1
245 0.0004 0.00042080879211426 
SELECT value FROM productattributes
                WHERE product_id = '4128'
                AND name = 'ListPriceAmount'
246 0.0006 0.00055909156799316 
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 = '4128'
                GROUP BY o.product_id
247 0.0007 0.00072598457336426 
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     = '4128'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
248 0.0004 0.00040411949157715 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4128
249 0.0007 0.00071597099304199 
SELECT value FROM productattributes WHERE product_id = '4128' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
250 0.0013 0.0013480186462402 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4128'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
251 0.0006 0.00064611434936523 
SELECT * FROM productimages WHERE product_id = '1355' ORDER BY sortorder ASC
252 0.0008 0.00076413154602051 
SELECT * FROM product_image_select WHERE product_id = '1355'
253 0.0004 0.00044488906860352 
SELECT * FROM productcustomimages WHERE product_id = '1355'
254 0.0012 0.0011539459228516 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1355' AND a.name = n.originalname
255 0.0005 0.00047087669372559 
SELECT * FROM productoffers WHERE product_id = '1355' AND merchantid = 'A1X6FK5RDHNB96'
256 0.0005 0.00049996376037598 
SELECT * FROM productoffers
                WHERE product_id = '1355' AND price > 0
                ORDER BY price ASC LIMIT 1
257 0.0004 0.00039315223693848 
SELECT * FROM productoffers
                WHERE product_id = 1355
                ORDER BY price ASC LIMIT 1
258 0.0004 0.0003809928894043 
SELECT value FROM productattributes
                WHERE product_id = '1355'
                AND name = 'ListPriceAmount'
259 0.0004 0.00039005279541016 
SELECT value FROM productattributes WHERE product_id = '1355' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
260 0.0005 0.00051116943359375 
SELECT * FROM productimages WHERE product_id = '772' ORDER BY sortorder ASC
261 0.0006 0.00060915946960449 
SELECT * FROM product_image_select WHERE product_id = '772'
262 0.0004 0.00040888786315918 
SELECT * FROM productcustomimages WHERE product_id = '772'
263 0.0010 0.0010020732879639 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '772' AND a.name = n.originalname
264 0.0006 0.00060296058654785 
SELECT * FROM productoffers WHERE product_id = '772' AND merchantid = 'A1X6FK5RDHNB96'
265 0.0004 0.00041294097900391 
SELECT * FROM productoffers
                WHERE product_id = '772' AND price > 0
                ORDER BY price ASC LIMIT 1
266 0.0004 0.00041103363037109 
SELECT * FROM productoffers
                WHERE product_id = 772
                ORDER BY price ASC LIMIT 1
267 0.0005 0.0004889965057373 
SELECT value FROM productattributes
                WHERE product_id = '772'
                AND name = 'ListPriceAmount'
268 0.0005 0.00049400329589844 
SELECT value FROM productattributes WHERE product_id = '772' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
269 0.0005 0.00053906440734863 
SELECT * FROM productimages WHERE product_id = '4151' ORDER BY sortorder ASC
270 0.0007 0.00068092346191406 
SELECT * FROM product_image_select WHERE product_id = '4151'
271 0.0006 0.0006401538848877 
SELECT * FROM productcustomimages WHERE product_id = '4151'
272 0.0007 0.00072503089904785 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4151' AND a.name = n.originalname
273 0.0005 0.00051307678222656 
SELECT * FROM productoffers WHERE product_id = '4151' AND merchantid = 'A1X6FK5RDHNB96'
274 0.0004 0.00041818618774414 
SELECT * FROM productoffers
                WHERE product_id = '4151' AND price > 0
                ORDER BY price ASC LIMIT 1
275 0.0003 0.00033283233642578 
SELECT * FROM productoffers
                WHERE product_id = 4151
                ORDER BY price ASC LIMIT 1
276 0.0004 0.00040102005004883 
SELECT value FROM productattributes
                WHERE product_id = '4151'
                AND name = 'ListPriceAmount'
277 0.0004 0.00037908554077148 
SELECT value FROM productattributes WHERE product_id = '4151' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
278 0.0006 0.00056791305541992 
SELECT * FROM productimages WHERE product_id = '835' ORDER BY sortorder ASC
279 0.0007 0.00068998336791992 
SELECT * FROM product_image_select WHERE product_id = '835'
280 0.0004 0.00041794776916504 
SELECT * FROM productcustomimages WHERE product_id = '835'
281 0.0008 0.00081920623779297 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '835' AND a.name = n.originalname
282 0.0005 0.00053000450134277 
SELECT * FROM productoffers WHERE product_id = '835' AND merchantid = 'A1X6FK5RDHNB96'
283 0.0004 0.00042605400085449 
SELECT * FROM productoffers
                WHERE product_id = '835' AND price > 0
                ORDER BY price ASC LIMIT 1
284 0.0004 0.00035619735717773 
SELECT * FROM productoffers
                WHERE product_id = 835
                ORDER BY price ASC LIMIT 1
285 0.0004 0.00037789344787598 
SELECT value FROM productattributes
                WHERE product_id = '835'
                AND name = 'ListPriceAmount'
286 0.0006 0.00059700012207031 
SELECT value FROM productattributes WHERE product_id = '835' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
287 0.0016 0.0016288757324219 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2689' ORDER BY timestamp DESC
288 0.0004 0.00036096572875977 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3770' ORDER BY timestamp DESC
289 0.0003 0.00033712387084961 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '826' ORDER BY timestamp DESC
290 0.0003 0.00034713745117188 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1859' ORDER BY timestamp DESC
291 0.0004 0.00036096572875977 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1650' ORDER BY timestamp DESC
292 0.0004 0.00035691261291504 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1465' ORDER BY timestamp DESC
293 0.0003 0.0003058910369873 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4136' ORDER BY timestamp DESC
294 0.0003 0.00028681755065918 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1712' ORDER BY timestamp DESC
295 0.0003 0.00029301643371582 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3849' ORDER BY timestamp DESC
296 0.0003 0.0002739429473877 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3916' ORDER BY timestamp DESC
297 0.0003 0.00031590461730957 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4041' ORDER BY timestamp DESC
298 0.0003 0.00029802322387695 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4114' ORDER BY timestamp DESC
299 0.0003 0.00031304359436035 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '782' ORDER BY timestamp DESC
300 0.0003 0.0002739429473877 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4128' ORDER BY timestamp DESC
301 0.0003 0.0002598762512207 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1355' ORDER BY timestamp DESC
302 0.0003 0.00026679039001465 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '772' ORDER BY timestamp DESC
303 0.0003 0.00026297569274902 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4151' ORDER BY timestamp DESC
304 0.0003 0.0002741813659668 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '835' ORDER BY timestamp DESC
305 0.0014 0.0013601779937744 
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
306 0.0012 0.0011701583862305 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
307 0.0003 0.00031208992004395 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
308 0.0131 0.013061046600342 
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
309 0.0016 0.0016028881072998 
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
310 0.0005 0.00049400329589844 
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
311 0.0005 0.00052380561828613 
SELECT * FROM products WHERE id = 1626
312 0.0005 0.00045084953308105 
SELECT * FROM products WHERE id = 4041
313 0.0005 0.00045895576477051 
SELECT * FROM products WHERE id = 4312
314 0.0004 0.0003969669342041 
SELECT * FROM products WHERE id = 777
315 0.0004 0.00037789344787598 
SELECT * FROM products WHERE id = 3881
316 0.0004 0.00041317939758301 
SELECT * FROM products WHERE id = 4213
317 0.0003 0.00032997131347656 
SELECT * FROM products WHERE id = '1626'
318 0.0005 0.0004580020904541 
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
319 0.0006 0.00056004524230957 
SELECT * FROM product_image_select WHERE product_id = '1626'
320 0.0004 0.00040984153747559 
SELECT * FROM productcustomimages WHERE product_id = '1626'
321 0.0008 0.00084400177001953 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
322 0.0005 0.00048208236694336 
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
323 0.0004 0.00038290023803711 
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
324 0.0004 0.00043606758117676 
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
325 0.0005 0.00045490264892578 
SELECT * FROM products WHERE id = '4041'
326 0.0004 0.00044107437133789 
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
327 0.0006 0.00055098533630371 
SELECT * FROM product_image_select WHERE product_id = '4041'
328 0.0003 0.0003349781036377 
SELECT * FROM productcustomimages WHERE product_id = '4041'
329 0.0010 0.0010390281677246 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
330 0.0005 0.00045490264892578 
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
331 0.0004 0.0004119873046875 
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
332 0.0004 0.00041389465332031 
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
333 0.0005 0.00053215026855469 
SELECT * FROM products WHERE id = '4312'
334 0.0004 0.00039792060852051 
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
335 0.0005 0.00052595138549805 
SELECT * FROM product_image_select WHERE product_id = '4312'
336 0.0003 0.0003211498260498 
SELECT * FROM productcustomimages WHERE product_id = '4312'
337 0.0010 0.00095605850219727 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
338 0.0004 0.00043892860412598 
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
339 0.0005 0.00045180320739746 
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
340 0.0004 0.00039505958557129 
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
341 0.0005 0.00054287910461426 
SELECT * FROM products WHERE id = '777'
342 0.0004 0.00041913986206055 
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
343 0.0005 0.00052094459533691 
SELECT * FROM product_image_select WHERE product_id = '777'
344 0.0004 0.00039005279541016 
SELECT * FROM productcustomimages WHERE product_id = '777'
345 0.0010 0.001046895980835 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
346 0.0004 0.00041699409484863 
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
347 0.0003 0.00034499168395996 
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
348 0.0004 0.00039219856262207 
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
349 0.0005 0.00051212310791016 
SELECT * FROM products WHERE id = '3881'
350 0.0005 0.00054097175598145 
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
351 0.0006 0.00062108039855957 
SELECT * FROM product_image_select WHERE product_id = '3881'
352 0.0005 0.00047087669372559 
SELECT * FROM productcustomimages WHERE product_id = '3881'
353 0.0014 0.0013790130615234 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
354 0.0005 0.00046110153198242 
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
355 0.0004 0.00036096572875977 
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
356 0.0005 0.00045609474182129 
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
357 0.0006 0.00057601928710938 
SELECT * FROM products WHERE id = '4213'
358 0.0006 0.00056600570678711 
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
359 0.0006 0.00058603286743164 
SELECT * FROM product_image_select WHERE product_id = '4213'
360 0.0004 0.00039911270141602 
SELECT * FROM productcustomimages WHERE product_id = '4213'
361 0.0014 0.001446008682251 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
362 0.0006 0.00062704086303711 
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
363 0.0004 0.00043892860412598 
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
364 0.0005 0.00050020217895508 
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
365 0.0020 0.0019650459289551 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
366 0.0006 0.00062298774719238 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
367 0.0024 0.0023658275604248 
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
368 0.0015 0.0015039443969727 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
369 0.0005 0.00048995018005371 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
370 0.0009 0.00086808204650879 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
371 0.0010 0.0010271072387695 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'