0
  1. My Store
  2. All Products

All Products

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
2.2544598579407 322 1.8729 0


No Amazon API Requests Made.


App Debug - Total Time 2.2544598579407 seconds

Number Time From Start Name Description
1 0.36470293998718 Initialise Initialise FSB Function
2 0.37066698074341 App Controller Start Start of the App controller (called before the controller of every page)
3 0.40987277030945 Start of getCategoryListByGroup Function Before first category groups query
4 0.41119599342346 After initial query Before first category groups query
5 0.41119694709778 Get Category List for Group Before the call to getCategoryList function
6 0.41119790077209 Start of GetCategoryList function Start of the function
7 0.41119980812073 Before getting categories Query to get specific category list
8 0.41269993782043 After getting categories Query to get specific category list
9 0.41270089149475 Before getting category custom Before call to function getCategoryCustom
10 0.43519592285156 After getting category custom After call to function getCategoryCustom
11 0.4351978302002 Before getting category custom Before call to function getCategoryCustom
12 0.44785380363464 After getting category custom After call to function getCategoryCustom
13 0.44785594940186 Before getting category custom Before call to function getCategoryCustom
14 0.45406889915466 After getting category custom After call to function getCategoryCustom
15 0.45406985282898 Before getting category custom Before call to function getCategoryCustom
16 0.45861577987671 After getting category custom After call to function getCategoryCustom
17 0.4586169719696 Before getting category custom Before call to function getCategoryCustom
18 0.46415185928345 After getting category custom After call to function getCategoryCustom
19 0.46415281295776 Before getting category custom Before call to function getCategoryCustom
20 0.46955895423889 After getting category custom After call to function getCategoryCustom
21 0.46955990791321 End of GetCategoryList function End of the function
22 0.46956396102905 Get Category List for Group Before the call to getCategoryList function
23 0.46956491470337 Start of GetCategoryList function Start of the function
24 0.46956586837769 Before getting categories Query to get specific category list
25 0.47013092041016 End of getCategoryListByGroup Function Before return()
26 1.9750018119812 App Controller End End of the App controller (called before the controller of every page)
27 2.1697747707367 After Getting Product/Bundle Reviews After getting full product/bundle customer review in the All Products Controller
28 2.1706988811493 App_after Controller Start Start of the App_after controller (called after the controller of every page)
29 2.1716949939728 Before Get Options Before the call to getOptions in the tpl class
30 2.2385878562927 After Get Options After the call to getOptions in the tpl class
31 2.2387537956238 App_after Controller End End of the App_after controller (called after the controller of every page)
32 2.2544519901276 Finalizing debug Before the debug is output to the page.
33 2.2544589042664 End of App This is the end of the app logging, final timestamp


Query Debug - 322 Database Queries. Total time 1.8729 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0022 0.0021591186523438 
SELECT parameter, value FROM parameters
2 0.0055 0.0054631233215332 
SELECT * FROM `bad_bots`
3 0.0006 0.00056004524230957 
SET time_zone = 'Europe/London'
4 0.0037 0.0036690235137939 
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0010 0.00099587440490723 
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"18.117.240.120\";}'
6 0.0013 0.0012810230255127 
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1746014280'
7 0.0038 0.0037999153137207 
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0013 0.0013298988342285 
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0035 0.0034561157226562 
SELECT id FROM pages WHERE pagename = 'all-products' LIMIT 1
10 0.0006 0.00063395500183105 
SELECT * FROM pages WHERE id = 37
11 0.0063 0.0063309669494629 
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0319 0.031889200210571 
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0006 0.00055694580078125 
SELECT * FROM pages WHERE pagename = 'all-products'
14 0.0013 0.0013158321380615 
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0015 0.0014908313751221 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0072 0.0072109699249268 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
17 0.0018 0.0017759799957275 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
18 0.0013 0.001255989074707 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0005 0.00047802925109863 
SELECT id FROM categories WHERE parent_id = '26'
20 0.0068 0.0067510604858398 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
21 0.0016 0.0016419887542725 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0
22 0.0016 0.0015659332275391 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
23 0.0013 0.0013349056243896 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0004 0.00041913986206055 
SELECT * FROM categorygroups WHERE id = '1'
25 0.0041 0.0040631294250488 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
26 0.0006 0.00055098533630371 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
27 0.0005 0.00049686431884766 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0007 0.00069689750671387 
SELECT id FROM categories WHERE parent_id = '27'
29 0.0043 0.0043239593505859 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
30 0.0009 0.00094485282897949 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0
31 0.0006 0.0005638599395752 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
32 0.0005 0.00052499771118164 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0004 0.00044918060302734 
SELECT * FROM categorygroups WHERE id = '1'
34 0.0015 0.0014820098876953 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
35 0.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 = 28
36 0.0004 0.00041699409484863 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0004 0.00042009353637695 
SELECT id FROM categories WHERE parent_id = '28'
38 0.0016 0.0016238689422607 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
39 0.0005 0.00045299530029297 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0
40 0.0005 0.00049304962158203 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
41 0.0004 0.00043296813964844 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0004 0.00039196014404297 
SELECT * FROM categorygroups WHERE id = '1'
43 0.0006 0.00055599212646484 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
44 0.0004 0.00042295455932617 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
45 0.0004 0.00040721893310547 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0004 0.00041294097900391 
SELECT id FROM categories WHERE parent_id = '29'
47 0.0007 0.0006868839263916 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
48 0.0007 0.00067901611328125 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0
49 0.0005 0.00050902366638184 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
50 0.0004 0.00044703483581543 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0004 0.00039005279541016 
SELECT * FROM categorygroups WHERE id = '1'
52 0.0005 0.00054693222045898 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
53 0.0005 0.0005488395690918 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
54 0.0005 0.00045680999755859 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0007 0.00071597099304199 
SELECT id FROM categories WHERE parent_id = '30'
56 0.0011 0.0010929107666016 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
57 0.0006 0.00059413909912109 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0
58 0.0006 0.00058794021606445 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
59 0.0005 0.00054097175598145 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0004 0.00041699409484863 
SELECT * FROM categorygroups WHERE id = '1'
61 0.0008 0.00083088874816895 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
62 0.0006 0.00061392784118652 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
63 0.0004 0.00042104721069336 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0005 0.00048303604125977 
SELECT id FROM categories WHERE parent_id = '31'
65 0.0007 0.00073790550231934 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
66 0.0007 0.00071096420288086 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0
67 0.0005 0.0005490779876709 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
68 0.0005 0.00054812431335449 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0005 0.00048208236694336 
SELECT * FROM categorygroups WHERE id = '1'
70 0.0006 0.00056099891662598 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0034 0.0033760070800781 
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0016 0.0015859603881836 
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0005 0.00051212310791016 
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
74 0.0013 0.0012538433074951 
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0011 0.0011060237884521 
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0008 0.00083088874816895 
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 1.4894 1.4894161224365 
SELECT * FROM ipgeocountries WHERE INET_ATON('18.117.240.120') >= INET_ATON(ip_start) AND INET_ATON('18.117.240.120') <= INET_ATON(ip_end)
78 0.0036 0.0035760402679443 
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0018 0.0017509460449219 
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0008 0.00080084800720215 
SELECT * FROM pages WHERE pagename = 'all-products'
81 0.0074 0.0074381828308105 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
82 0.0023 0.0022580623626709 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
83 0.0028 0.0027871131896973 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
84 0.0075 0.0075299739837646 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
85 0.0023 0.0023109912872314 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
86 0.0006 0.00056695938110352 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
87 0.0067 0.0066511631011963 
SELECT COUNT(*) FROM products p WHERE parent_id = 0 AND hidden = 0 AND enabled = 1  AND 1 = 1
88 0.0129 0.012869834899902 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
89 0.0048 0.0048389434814453 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
90 0.0009 0.00094103813171387 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
91 0.0049 0.0048980712890625 
SELECT p.* FROM products p WHERE hidden = 0 AND enabled = 1 AND parent_id = 0 AND 1 = 1 ORDER BY salesrank ASC  LIMIT 18, 18
92 0.0012 0.0011739730834961 
SELECT * FROM productimages WHERE product_id = '1160' ORDER BY sortorder ASC
93 0.0010 0.001046895980835 
SELECT * FROM product_image_select WHERE product_id = '1160'
94 0.0006 0.00060701370239258 
SELECT * FROM productcustomimages WHERE product_id = '1160'
95 0.0019 0.0019171237945557 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1160' AND a.name = n.originalname
96 0.0007 0.0006709098815918 
SELECT * FROM productoffers WHERE product_id = '1160' AND merchantid = 'A1X6FK5RDHNB96'
97 0.0006 0.00060009956359863 
SELECT * FROM productoffers
                WHERE product_id = '1160' AND price > 0
                ORDER BY price ASC LIMIT 1
98 0.0006 0.00061798095703125 
SELECT value FROM productattributes WHERE product_id = '1160' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
99 0.0011 0.0011379718780518 
SELECT * FROM productimages WHERE product_id = '4940' ORDER BY sortorder ASC
100 0.0016 0.0016341209411621 
SELECT * FROM product_image_select WHERE product_id = '4940'
101 0.0009 0.00086498260498047 
SELECT * FROM productcustomimages WHERE product_id = '4940'
102 0.0018 0.0017759799957275 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4940' AND a.name = n.originalname
103 0.0014 0.0014128684997559 
SELECT * FROM productoffers WHERE product_id = '4940' AND merchantid = 'A1X6FK5RDHNB96'
104 0.0008 0.0007939338684082 
SELECT * FROM productoffers
                WHERE product_id = '4940' AND price > 0
                ORDER BY price ASC LIMIT 1
105 0.0009 0.00088000297546387 
SELECT value FROM productattributes WHERE product_id = '4940' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
106 0.0011 0.0010781288146973 
SELECT * FROM productimages WHERE product_id = '4954' ORDER BY sortorder ASC
107 0.0014 0.0014030933380127 
SELECT * FROM product_image_select WHERE product_id = '4954'
108 0.0010 0.0010371208190918 
SELECT * FROM productcustomimages WHERE product_id = '4954'
109 0.0033 0.0032579898834229 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4954' AND a.name = n.originalname
110 0.0012 0.0012180805206299 
SELECT * FROM productoffers WHERE product_id = '4954' AND merchantid = 'A1X6FK5RDHNB96'
111 0.0006 0.00063514709472656 
SELECT * FROM productoffers
                WHERE product_id = '4954' AND price > 0
                ORDER BY price ASC LIMIT 1
112 0.0007 0.00069785118103027 
SELECT value FROM productattributes WHERE product_id = '4954' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
113 0.0008 0.00084900856018066 
SELECT * FROM productimages WHERE product_id = '1055' ORDER BY sortorder ASC
114 0.0008 0.00084996223449707 
SELECT * FROM product_image_select WHERE product_id = '1055'
115 0.0005 0.00054311752319336 
SELECT * FROM productcustomimages WHERE product_id = '1055'
116 0.0018 0.0017769336700439 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1055' AND a.name = n.originalname
117 0.0007 0.00071310997009277 
SELECT * FROM productoffers WHERE product_id = '1055' AND merchantid = 'A1X6FK5RDHNB96'
118 0.0005 0.00053310394287109 
SELECT * FROM productoffers
                WHERE product_id = '1055' AND price > 0
                ORDER BY price ASC LIMIT 1
119 0.0006 0.0005948543548584 
SELECT value FROM productattributes WHERE product_id = '1055' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
120 0.0008 0.00081896781921387 
SELECT * FROM productimages WHERE product_id = '1215' ORDER BY sortorder ASC
121 0.0010 0.00096297264099121 
SELECT * FROM product_image_select WHERE product_id = '1215'
122 0.0005 0.00054502487182617 
SELECT * FROM productcustomimages WHERE product_id = '1215'
123 0.0019 0.0019040107727051 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1215' AND a.name = n.originalname
124 0.0005 0.00053095817565918 
SELECT * FROM productoffers WHERE product_id = '1215' AND merchantid = 'A1X6FK5RDHNB96'
125 0.0004 0.00044894218444824 
SELECT * FROM productoffers
                WHERE product_id = '1215' AND price > 0
                ORDER BY price ASC LIMIT 1
126 0.0006 0.00055289268493652 
SELECT value FROM productattributes WHERE product_id = '1215' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
127 0.0007 0.00070405006408691 
SELECT * FROM productimages WHERE product_id = '770' ORDER BY sortorder ASC
128 0.0008 0.00077486038208008 
SELECT * FROM product_image_select WHERE product_id = '770'
129 0.0005 0.00054693222045898 
SELECT * FROM productcustomimages WHERE product_id = '770'
130 0.0020 0.0020270347595215 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '770' AND a.name = n.originalname
131 0.0007 0.00065398216247559 
SELECT * FROM productoffers WHERE product_id = '770' AND merchantid = 'A1X6FK5RDHNB96'
132 0.0005 0.00050592422485352 
SELECT * FROM productoffers
                WHERE product_id = '770' AND price > 0
                ORDER BY price ASC LIMIT 1
133 0.0007 0.00073385238647461 
SELECT value FROM productattributes WHERE product_id = '770' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
134 0.0007 0.00071001052856445 
SELECT * FROM productimages WHERE product_id = '4948' ORDER BY sortorder ASC
135 0.0010 0.00099587440490723 
SELECT * FROM product_image_select WHERE product_id = '4948'
136 0.0005 0.00049686431884766 
SELECT * FROM productcustomimages WHERE product_id = '4948'
137 0.0012 0.0011701583862305 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4948' AND a.name = n.originalname
138 0.0006 0.00062298774719238 
SELECT * FROM productoffers WHERE product_id = '4948' AND merchantid = 'A1X6FK5RDHNB96'
139 0.0005 0.00046896934509277 
SELECT * FROM productoffers
                WHERE product_id = '4948' AND price > 0
                ORDER BY price ASC LIMIT 1
140 0.0005 0.00050997734069824 
SELECT value FROM productattributes WHERE product_id = '4948' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
141 0.0006 0.00063490867614746 
SELECT * FROM productimages WHERE product_id = '2009' ORDER BY sortorder ASC
142 0.0008 0.00081110000610352 
SELECT * FROM product_image_select WHERE product_id = '2009'
143 0.0005 0.00045609474182129 
SELECT * FROM productcustomimages WHERE product_id = '2009'
144 0.0012 0.0012099742889404 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2009' AND a.name = n.originalname
145 0.0006 0.00056099891662598 
SELECT * FROM productoffers WHERE product_id = '2009' AND merchantid = 'A1X6FK5RDHNB96'
146 0.0005 0.00053191184997559 
SELECT * FROM productoffers
                WHERE product_id = '2009' AND price > 0
                ORDER BY price ASC LIMIT 1
147 0.0005 0.00053501129150391 
SELECT value FROM productattributes WHERE product_id = '2009' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
148 0.0006 0.00057005882263184 
SELECT * FROM productimages WHERE product_id = '4287' ORDER BY sortorder ASC
149 0.0006 0.00058794021606445 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4287' AND p.id = pi.product_id ORDER BY pi.sortorder
150 0.0005 0.0005488395690918 
SELECT * FROM product_image_select WHERE product_id = '4287'
151 0.0004 0.0003819465637207 
SELECT * FROM productcustomimages WHERE product_id = '4287'
152 0.0006 0.00055718421936035 
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 = '4287'
                GROUP BY o.product_id
153 0.0036 0.0036270618438721 
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     = '4287'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
154 0.0013 0.0012531280517578 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4287
155 0.0013 0.0013060569763184 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4287' AND a.name = n.originalname
156 0.0004 0.00044107437133789 
SELECT * FROM productoffers WHERE product_id = '4287' AND merchantid = 'A1X6FK5RDHNB96'
157 0.0005 0.00051093101501465 
SELECT * FROM productoffers
                WHERE product_id = '4287' AND price > 0
                ORDER BY price ASC LIMIT 1
158 0.0005 0.00045585632324219 
SELECT * FROM productoffers
                WHERE product_id = 4287
                ORDER BY price ASC LIMIT 1
159 0.0006 0.00055980682373047 
SELECT value FROM productattributes
                WHERE product_id = '4287'
                AND name = 'ListPriceAmount'
160 0.0006 0.00061988830566406 
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 = '4287'
                GROUP BY o.product_id
161 0.0010 0.0010268688201904 
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     = '4287'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
162 0.0004 0.00044798851013184 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4287
163 0.0007 0.00067400932312012 
SELECT value FROM productattributes WHERE product_id = '4287' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
164 0.0008 0.00080299377441406 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4287'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
165 0.0006 0.00058794021606445 
SELECT * FROM productimages WHERE product_id = '4941' ORDER BY sortorder ASC
166 0.0008 0.00076103210449219 
SELECT * FROM product_image_select WHERE product_id = '4941'
167 0.0005 0.0005040168762207 
SELECT * FROM productcustomimages WHERE product_id = '4941'
168 0.0017 0.0016670227050781 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4941' AND a.name = n.originalname
169 0.0006 0.0006251335144043 
SELECT * FROM productoffers WHERE product_id = '4941' AND merchantid = 'A1X6FK5RDHNB96'
170 0.0005 0.00046491622924805 
SELECT * FROM productoffers
                WHERE product_id = '4941' AND price > 0
                ORDER BY price ASC LIMIT 1
171 0.0006 0.00063586235046387 
SELECT value FROM productattributes WHERE product_id = '4941' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
172 0.0008 0.00082302093505859 
SELECT * FROM productimages WHERE product_id = '3809' ORDER BY sortorder ASC
173 0.0007 0.00071382522583008 
SELECT * FROM product_image_select WHERE product_id = '3809'
174 0.0005 0.00049090385437012 
SELECT * FROM productcustomimages WHERE product_id = '3809'
175 0.0013 0.0012741088867188 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3809' AND a.name = n.originalname
176 0.0006 0.00055289268493652 
SELECT * FROM productoffers WHERE product_id = '3809' AND merchantid = 'A1X6FK5RDHNB96'
177 0.0005 0.0005028247833252 
SELECT * FROM productoffers
                WHERE product_id = '3809' AND price > 0
                ORDER BY price ASC LIMIT 1
178 0.0005 0.0005340576171875 
SELECT value FROM productattributes WHERE product_id = '3809' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
179 0.0006 0.0006260871887207 
SELECT * FROM productimages WHERE product_id = '1948' ORDER BY sortorder ASC
180 0.0010 0.0010089874267578 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1948' AND p.id = pi.product_id ORDER BY pi.sortorder
181 0.0008 0.00079083442687988 
SELECT * FROM product_image_select WHERE product_id = '1948'
182 0.0005 0.00045108795166016 
SELECT * FROM productcustomimages WHERE product_id = '1948'
183 0.0008 0.00076794624328613 
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 = '1948'
                GROUP BY o.product_id
184 0.0010 0.0010159015655518 
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     = '1948'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
185 0.0006 0.00064492225646973 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1948
186 0.0017 0.0017118453979492 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1948' AND a.name = n.originalname
187 0.0005 0.0004730224609375 
SELECT * FROM productoffers WHERE product_id = '1948' AND merchantid = 'A1X6FK5RDHNB96'
188 0.0005 0.00047492980957031 
SELECT * FROM productoffers
                WHERE product_id = '1948' AND price > 0
                ORDER BY price ASC LIMIT 1
189 0.0004 0.00038409233093262 
SELECT * FROM productoffers
                WHERE product_id = 1948
                ORDER BY price ASC LIMIT 1
190 0.0005 0.00047612190246582 
SELECT value FROM productattributes
                WHERE product_id = '1948'
                AND name = 'ListPriceAmount'
191 0.0006 0.0006260871887207 
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 = '1948'
                GROUP BY o.product_id
192 0.0010 0.0010418891906738 
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     = '1948'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
193 0.0006 0.00064802169799805 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1948
194 0.0007 0.00068807601928711 
SELECT value FROM productattributes WHERE product_id = '1948' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
195 0.0008 0.00083589553833008 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '1948'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Style'
                GROUP BY o.value
                ORDER BY o.value ASC
196 0.0006 0.00064611434936523 
SELECT * FROM productimages WHERE product_id = '4937' ORDER BY sortorder ASC
197 0.0008 0.0008399486541748 
SELECT * FROM product_image_select WHERE product_id = '4937'
198 0.0008 0.00075411796569824 
SELECT * FROM productcustomimages WHERE product_id = '4937'
199 0.0020 0.002032995223999 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4937' AND a.name = n.originalname
200 0.0006 0.00061988830566406 
SELECT * FROM productoffers WHERE product_id = '4937' AND merchantid = 'A1X6FK5RDHNB96'
201 0.0005 0.00045084953308105 
SELECT * FROM productoffers
                WHERE product_id = '4937' AND price > 0
                ORDER BY price ASC LIMIT 1
202 0.0005 0.00052094459533691 
SELECT value FROM productattributes WHERE product_id = '4937' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
203 0.0006 0.00057411193847656 
SELECT * FROM productimages WHERE product_id = '4934' ORDER BY sortorder ASC
204 0.0008 0.00077009201049805 
SELECT * FROM product_image_select WHERE product_id = '4934'
205 0.0006 0.00060415267944336 
SELECT * FROM productcustomimages WHERE product_id = '4934'
206 0.0016 0.0015687942504883 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4934' AND a.name = n.originalname
207 0.0006 0.00061798095703125 
SELECT * FROM productoffers WHERE product_id = '4934' AND merchantid = 'A1X6FK5RDHNB96'
208 0.0004 0.00041794776916504 
SELECT * FROM productoffers
                WHERE product_id = '4934' AND price > 0
                ORDER BY price ASC LIMIT 1
209 0.0005 0.00053000450134277 
SELECT value FROM productattributes WHERE product_id = '4934' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
210 0.0006 0.00057291984558105 
SELECT * FROM productimages WHERE product_id = '4952' ORDER BY sortorder ASC
211 0.0007 0.00072598457336426 
SELECT * FROM product_image_select WHERE product_id = '4952'
212 0.0004 0.00044488906860352 
SELECT * FROM productcustomimages WHERE product_id = '4952'
213 0.0011 0.0010957717895508 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4952' AND a.name = n.originalname
214 0.0006 0.00064492225646973 
SELECT * FROM productoffers WHERE product_id = '4952' AND merchantid = 'A1X6FK5RDHNB96'
215 0.0005 0.0005338191986084 
SELECT * FROM productoffers
                WHERE product_id = '4952' AND price > 0
                ORDER BY price ASC LIMIT 1
216 0.0006 0.0006108283996582 
SELECT value FROM productattributes WHERE product_id = '4952' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
217 0.0007 0.00070285797119141 
SELECT * FROM productimages WHERE product_id = '970' ORDER BY sortorder ASC
218 0.0008 0.00076889991760254 
SELECT * FROM product_image_select WHERE product_id = '970'
219 0.0006 0.00055599212646484 
SELECT * FROM productcustomimages WHERE product_id = '970'
220 0.0013 0.0012729167938232 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '970' AND a.name = n.originalname
221 0.0006 0.00059914588928223 
SELECT * FROM productoffers WHERE product_id = '970' AND merchantid = 'A1X6FK5RDHNB96'
222 0.0005 0.00048208236694336 
SELECT * FROM productoffers
                WHERE product_id = '970' AND price > 0
                ORDER BY price ASC LIMIT 1
223 0.0005 0.00046181678771973 
SELECT value FROM productattributes WHERE product_id = '970' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
224 0.0005 0.0005190372467041 
SELECT * FROM productimages WHERE product_id = '4924' ORDER BY sortorder ASC
225 0.0007 0.00072216987609863 
SELECT * FROM product_image_select WHERE product_id = '4924'
226 0.0005 0.00048494338989258 
SELECT * FROM productcustomimages WHERE product_id = '4924'
227 0.0014 0.0013799667358398 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4924' AND a.name = n.originalname
228 0.0006 0.00058197975158691 
SELECT * FROM productoffers WHERE product_id = '4924' AND merchantid = 'A1X6FK5RDHNB96'
229 0.0005 0.00046682357788086 
SELECT * FROM productoffers
                WHERE product_id = '4924' AND price > 0
                ORDER BY price ASC LIMIT 1
230 0.0005 0.00049996376037598 
SELECT value FROM productattributes WHERE product_id = '4924' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
231 0.0006 0.00059390068054199 
SELECT * FROM productimages WHERE product_id = '966' ORDER BY sortorder ASC
232 0.0007 0.00067591667175293 
SELECT * FROM product_image_select WHERE product_id = '966'
233 0.0004 0.00043797492980957 
SELECT * FROM productcustomimages WHERE product_id = '966'
234 0.0010 0.00095009803771973 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '966' AND a.name = n.originalname
235 0.0006 0.00055408477783203 
SELECT * FROM productoffers WHERE product_id = '966' AND merchantid = 'A1X6FK5RDHNB96'
236 0.0005 0.00046420097351074 
SELECT * FROM productoffers
                WHERE product_id = '966' AND price > 0
                ORDER BY price ASC LIMIT 1
237 0.0005 0.00050711631774902 
SELECT value FROM productattributes WHERE product_id = '966' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
238 0.0006 0.00059103965759277 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1160' ORDER BY timestamp DESC
239 0.0003 0.00033688545227051 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4940' ORDER BY timestamp DESC
240 0.0003 0.0003349781036377 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4954' ORDER BY timestamp DESC
241 0.0003 0.00032401084899902 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1055' ORDER BY timestamp DESC
242 0.0003 0.0003049373626709 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1215' ORDER BY timestamp DESC
243 0.0003 0.00029611587524414 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '770' ORDER BY timestamp DESC
244 0.0004 0.0003821849822998 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4948' ORDER BY timestamp DESC
245 0.0003 0.00033807754516602 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2009' ORDER BY timestamp DESC
246 0.0003 0.00032401084899902 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4287' ORDER BY timestamp DESC
247 0.0003 0.0003349781036377 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4941' ORDER BY timestamp DESC
248 0.0004 0.00038003921508789 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3809' ORDER BY timestamp DESC
249 0.0004 0.00043106079101562 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1948' ORDER BY timestamp DESC
250 0.0005 0.00046515464782715 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4937' ORDER BY timestamp DESC
251 0.0003 0.00033807754516602 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4934' ORDER BY timestamp DESC
252 0.0004 0.00039196014404297 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4952' ORDER BY timestamp DESC
253 0.0003 0.00034189224243164 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '970' ORDER BY timestamp DESC
254 0.0004 0.00040388107299805 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4924' ORDER BY timestamp DESC
255 0.0003 0.00034093856811523 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '966' ORDER BY timestamp DESC
256 0.0006 0.0006101131439209 
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
257 0.0006 0.0005800724029541 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
258 0.0004 0.00037622451782227 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
259 0.0189 0.018905878067017 
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
260 0.0016 0.0016031265258789 
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
261 0.0012 0.0012059211730957 
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
262 0.0010 0.001011848449707 
SELECT * FROM products WHERE id = 1626
263 0.0009 0.00089907646179199 
SELECT * FROM products WHERE id = 4041
264 0.0007 0.00067806243896484 
SELECT * FROM products WHERE id = 4312
265 0.0007 0.00072193145751953 
SELECT * FROM products WHERE id = 777
266 0.0006 0.0005948543548584 
SELECT * FROM products WHERE id = 3881
267 0.0008 0.00084400177001953 
SELECT * FROM products WHERE id = 4213
268 0.0006 0.00062108039855957 
SELECT * FROM products WHERE id = '1626'
269 0.0011 0.001121997833252 
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
270 0.0014 0.00136399269104 
SELECT * FROM product_image_select WHERE product_id = '1626'
271 0.0007 0.00069284439086914 
SELECT * FROM productcustomimages WHERE product_id = '1626'
272 0.0018 0.0018370151519775 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
273 0.0010 0.00097203254699707 
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
274 0.0008 0.00077676773071289 
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
275 0.0011 0.0010731220245361 
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
276 0.0014 0.0013930797576904 
SELECT * FROM products WHERE id = '4041'
277 0.0007 0.00072097778320312 
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
278 0.0010 0.0010080337524414 
SELECT * FROM product_image_select WHERE product_id = '4041'
279 0.0006 0.00055980682373047 
SELECT * FROM productcustomimages WHERE product_id = '4041'
280 0.0020 0.0019950866699219 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
281 0.0006 0.000640869140625 
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
282 0.0005 0.00045299530029297 
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
283 0.0006 0.00062298774719238 
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
284 0.0007 0.00069093704223633 
SELECT * FROM products WHERE id = '4312'
285 0.0008 0.00082015991210938 
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
286 0.0008 0.00083088874816895 
SELECT * FROM product_image_select WHERE product_id = '4312'
287 0.0005 0.00048303604125977 
SELECT * FROM productcustomimages WHERE product_id = '4312'
288 0.0012 0.001230001449585 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
289 0.0005 0.00046682357788086 
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
290 0.0005 0.0004580020904541 
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
291 0.0005 0.00046896934509277 
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
292 0.0005 0.00051999092102051 
SELECT * FROM products WHERE id = '777'
293 0.0005 0.00047588348388672 
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
294 0.0006 0.00061893463134766 
SELECT * FROM product_image_select WHERE product_id = '777'
295 0.0004 0.00040388107299805 
SELECT * FROM productcustomimages WHERE product_id = '777'
296 0.0011 0.0011429786682129 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
297 0.0006 0.00057816505432129 
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
298 0.0005 0.00045108795166016 
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
299 0.0005 0.00053787231445312 
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
300 0.0008 0.00076103210449219 
SELECT * FROM products WHERE id = '3881'
301 0.0006 0.00064897537231445 
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
302 0.0008 0.0008389949798584 
SELECT * FROM product_image_select WHERE product_id = '3881'
303 0.0005 0.00053191184997559 
SELECT * FROM productcustomimages WHERE product_id = '3881'
304 0.0011 0.0010669231414795 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
305 0.0004 0.00043320655822754 
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
306 0.0004 0.00041007995605469 
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
307 0.0004 0.00040388107299805 
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
308 0.0005 0.00050806999206543 
SELECT * FROM products WHERE id = '4213'
309 0.0005 0.00054597854614258 
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
310 0.0007 0.00066995620727539 
SELECT * FROM product_image_select WHERE product_id = '4213'
311 0.0004 0.00036406517028809 
SELECT * FROM productcustomimages WHERE product_id = '4213'
312 0.0012 0.0011899471282959 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
313 0.0005 0.00049090385437012 
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
314 0.0004 0.00041294097900391 
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
315 0.0004 0.00037693977355957 
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
316 0.0008 0.00079202651977539 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
317 0.0006 0.00057601928710938 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
318 0.0014 0.0013618469238281 
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
319 0.0006 0.00063204765319824 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
320 0.0004 0.00044798851013184 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
321 0.0006 0.00061607360839844 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
322 0.0005 0.00049114227294922 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'