0

All Products

Wait! We have a something for you...

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

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

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.7028729915619 335 1.2764 0


No Amazon API Requests Made.


App Debug - Total Time 1.7028729915619 seconds

Number Time From Start Name Description
1 0.38188195228577 Initialise Initialise FSB Function
2 0.3862190246582 App Controller Start Start of the App controller (called before the controller of every page)
3 0.4347288608551 Start of getCategoryListByGroup Function Before first category groups query
4 0.43588399887085 After initial query Before first category groups query
5 0.43588495254517 Get Category List for Group Before the call to getCategoryList function
6 0.43588781356812 Start of GetCategoryList function Start of the function
7 0.43589091300964 Before getting categories Query to get specific category list
8 0.43691682815552 After getting categories Query to get specific category list
9 0.43691802024841 Before getting category custom Before call to function getCategoryCustom
10 0.45794796943665 After getting category custom After call to function getCategoryCustom
11 0.45794987678528 Before getting category custom Before call to function getCategoryCustom
12 0.48035788536072 After getting category custom After call to function getCategoryCustom
13 0.48036098480225 Before getting category custom Before call to function getCategoryCustom
14 0.49150490760803 After getting category custom After call to function getCategoryCustom
15 0.49150681495667 Before getting category custom Before call to function getCategoryCustom
16 0.50007891654968 After getting category custom After call to function getCategoryCustom
17 0.50008082389832 Before getting category custom Before call to function getCategoryCustom
18 0.50629997253418 After getting category custom After call to function getCategoryCustom
19 0.50630283355713 Before getting category custom Before call to function getCategoryCustom
20 0.51337385177612 After getting category custom After call to function getCategoryCustom
21 0.51337599754333 End of GetCategoryList function End of the function
22 0.51338195800781 Get Category List for Group Before the call to getCategoryList function
23 0.51338386535645 Start of GetCategoryList function Start of the function
24 0.51338601112366 Before getting categories Query to get specific category list
25 0.51437997817993 End of getCategoryListByGroup Function Before return()
26 1.4617428779602 App Controller End End of the App controller (called before the controller of every page)
27 1.5956239700317 After Getting Product/Bundle Reviews After getting full product/bundle customer review in the All Products Controller
28 1.5979769229889 App_after Controller Start Start of the App_after controller (called after the controller of every page)
29 1.6006870269775 Before Get Options Before the call to getOptions in the tpl class
30 1.6684508323669 After Get Options After the call to getOptions in the tpl class
31 1.6685960292816 App_after Controller End End of the App_after controller (called after the controller of every page)
32 1.7028629779816 Finalizing debug Before the debug is output to the page.
33 1.7028729915619 End of App This is the end of the app logging, final timestamp


Query Debug - 335 Database Queries. Total time 1.2764 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0015 0.0015048980712891
SELECT parameter, value FROM parameters
2 0.0052 0.0052220821380615
SELECT * FROM `bad_bots`
3 0.0003 0.00030803680419922
SET time_zone = 'Europe/London'
4 0.0014 0.0014421939849854
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0016 0.0015630722045898
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"216.73.216.192\";}'
6 0.0014 0.0013980865478516
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1754027030'
7 0.0020 0.0019679069519043
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0008 0.00080585479736328
UPDATE autorun SET lastrun = '2025-08-01 05:43:50' WHERE id = '15'
9 0.0006 0.00063204765319824
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0026 0.0026230812072754
SELECT id FROM pages WHERE pagename = 'all-products' LIMIT 1
11 0.0004 0.00043892860412598
SELECT * FROM pages WHERE id = 37
12 0.0032 0.0031530857086182
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13 0.0442 0.044153928756714
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14 0.0006 0.00062084197998047
SELECT * FROM pages WHERE pagename = 'all-products'
15 0.0011 0.0011441707611084
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0010 0.0010099411010742
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0058 0.0057809352874756
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
18 0.0010 0.0009911060333252
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
19 0.0007 0.0006868839263916
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20 0.0003 0.00031399726867676
SELECT id FROM categories WHERE parent_id = '26'
21 0.0055 0.0054769515991211
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 
22 0.0027 0.0026919841766357
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 
23 0.0027 0.0026619434356689
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
24 0.0018 0.0017669200897217
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25 0.0005 0.00054383277893066
SELECT * FROM categorygroups WHERE id = '1'
26 0.0101 0.010133028030396
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
27 0.0007 0.0007319450378418
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
28 0.0006 0.0006411075592041
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29 0.0006 0.00063586235046387
SELECT id FROM categories WHERE parent_id = '27'
30 0.0076 0.0075950622558594
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 
31 0.0008 0.0007779598236084
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 
32 0.0007 0.00072312355041504
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
33 0.0006 0.0005638599395752
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34 0.0005 0.00050711631774902
SELECT * FROM categorygroups WHERE id = '1'
35 0.0029 0.0028891563415527
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
36 0.0011 0.0010669231414795
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
37 0.0005 0.00046205520629883
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38 0.0009 0.00089812278747559
SELECT id FROM categories WHERE parent_id = '28'
39 0.0030 0.0029730796813965
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 
40 0.0005 0.00053977966308594
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 
41 0.0005 0.00053906440734863
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
42 0.0005 0.00049686431884766
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43 0.0012 0.0012390613555908
SELECT * FROM categorygroups WHERE id = '1'
44 0.0015 0.0014579296112061
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
45 0.0016 0.0016279220581055
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
46 0.0007 0.0006709098815918
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47 0.0007 0.00068783760070801
SELECT id FROM categories WHERE parent_id = '29'
48 0.0011 0.0010840892791748
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 
49 0.0008 0.00084090232849121
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 
50 0.0008 0.00083088874816895
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
51 0.0008 0.00075197219848633
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52 0.0006 0.00057792663574219
SELECT * FROM categorygroups WHERE id = '1'
53 0.0009 0.00089693069458008
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
54 0.0006 0.00061893463134766
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
55 0.0006 0.00060391426086426
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56 0.0006 0.00057291984558105
SELECT id FROM categories WHERE parent_id = '30'
57 0.0010 0.00096583366394043
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 
58 0.0007 0.00065302848815918
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 
59 0.0007 0.00068402290344238
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
60 0.0006 0.00058984756469727
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61 0.0006 0.00058197975158691
SELECT * FROM categorygroups WHERE id = '1'
62 0.0013 0.0012979507446289
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
63 0.0007 0.00068283081054688
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
64 0.0005 0.00050711631774902
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65 0.0006 0.00058412551879883
SELECT id FROM categories WHERE parent_id = '31'
66 0.0011 0.0010638236999512
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 
67 0.0009 0.00094008445739746
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 
68 0.0007 0.00072622299194336
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
69 0.0006 0.00062894821166992
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70 0.0006 0.00055098533630371
SELECT * FROM categorygroups WHERE id = '1'
71 0.0010 0.00098395347595215
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
72 0.0023 0.0022950172424316
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73 0.0010 0.00096678733825684
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74 0.0005 0.00047683715820312
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
75 0.0008 0.00079703330993652
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76 0.0010 0.0010209083557129
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77 0.0007 0.00065016746520996
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78 0.9370 0.93696689605713
SELECT * FROM ipgeocountries WHERE INET_ATON('216.73.216.192') >= INET_ATON(ip_start) AND INET_ATON('216.73.216.192') <= INET_ATON(ip_end)
79 0.0018 0.0018050670623779
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80 0.0006 0.00064587593078613
SELECT * FROM countryredirects WHERE countrycode = 'US'
81 0.0004 0.00042581558227539
SELECT * FROM pages WHERE pagename = 'all-products'
82 0.0048 0.0048251152038574
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
83 0.0014 0.0013511180877686
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
84 0.0010 0.001025915145874
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
85 0.0048 0.0047590732574463
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
86 0.0014 0.0014359951019287
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
87 0.0004 0.00037002563476562
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
88 0.0037 0.0037240982055664
SELECT COUNT(*) FROM products p WHERE parent_id = 0 AND hidden = 0 AND enabled = 1  AND 1 = 1
89 0.0045 0.0044879913330078
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
90 0.0012 0.0012388229370117
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
91 0.0003 0.00034785270690918
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
92 0.0037 0.0037448406219482
SELECT p.* FROM products p WHERE hidden = 0 AND enabled = 1 AND parent_id = 0 AND 1 = 1 ORDER BY salesrank ASC  LIMIT 108, 18
93 0.0011 0.0010590553283691
SELECT * FROM productimages WHERE product_id = '941' ORDER BY sortorder ASC
94 0.0008 0.00082993507385254
SELECT * FROM product_image_select WHERE product_id = '941'
95 0.0006 0.00064992904663086
SELECT * FROM productcustomimages WHERE product_id = '941'
96 0.0011 0.001115083694458
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '941' AND a.name = n.originalname
97 0.0007 0.00073099136352539
SELECT * FROM productoffers WHERE product_id = '941' AND merchantid = 'A1X6FK5RDHNB96'
98 0.0003 0.00028300285339355
SELECT * FROM productoffers
                WHERE product_id = '941' AND price > 0
                ORDER BY price ASC LIMIT 1
99 0.0004 0.00041699409484863
SELECT value FROM productattributes WHERE product_id = '941' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
100 0.0003 0.00032591819763184
SELECT * FROM productimages WHERE product_id = '4814' ORDER BY sortorder ASC
101 0.0005 0.00047993659973145
SELECT * FROM product_image_select WHERE product_id = '4814'
102 0.0003 0.00028204917907715
SELECT * FROM productcustomimages WHERE product_id = '4814'
103 0.0006 0.00062799453735352
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4814' AND a.name = n.originalname
104 0.0003 0.00033688545227051
SELECT * FROM productoffers WHERE product_id = '4814' AND merchantid = 'A1X6FK5RDHNB96'
105 0.0003 0.00028181076049805
SELECT * FROM productoffers
                WHERE product_id = '4814' AND price > 0
                ORDER BY price ASC LIMIT 1
106 0.0003 0.00028395652770996
SELECT value FROM productattributes WHERE product_id = '4814' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
107 0.0003 0.00031185150146484
SELECT * FROM productimages WHERE product_id = '2883' ORDER BY sortorder ASC
108 0.0005 0.0004580020904541
SELECT * FROM product_image_select WHERE product_id = '2883'
109 0.0003 0.00029683113098145
SELECT * FROM productcustomimages WHERE product_id = '2883'
110 0.0005 0.0005340576171875
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2883' AND a.name = n.originalname
111 0.0003 0.00031399726867676
SELECT * FROM productoffers WHERE product_id = '2883' AND merchantid = 'A1X6FK5RDHNB96'
112 0.0003 0.0002739429473877
SELECT * FROM productoffers
                WHERE product_id = '2883' AND price > 0
                ORDER BY price ASC LIMIT 1
113 0.0003 0.0002589225769043
SELECT * FROM productoffers
                WHERE product_id = 2883
                ORDER BY price ASC LIMIT 1
114 0.0003 0.00025105476379395
SELECT value FROM productattributes
                WHERE product_id = '2883'
                AND name = 'ListPriceAmount'
115 0.0003 0.00027203559875488
SELECT value FROM productattributes WHERE product_id = '2883' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
116 0.0005 0.00049591064453125
SELECT * FROM productimages WHERE product_id = '3828' ORDER BY sortorder ASC
117 0.0006 0.00059700012207031
SELECT * FROM product_image_select WHERE product_id = '3828'
118 0.0003 0.00030207633972168
SELECT * FROM productcustomimages WHERE product_id = '3828'
119 0.0007 0.0006861686706543
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3828' AND a.name = n.originalname
120 0.0003 0.00032806396484375
SELECT * FROM productoffers WHERE product_id = '3828' AND merchantid = 'A1X6FK5RDHNB96'
121 0.0003 0.00030303001403809
SELECT * FROM productoffers
                WHERE product_id = '3828' AND price > 0
                ORDER BY price ASC LIMIT 1
122 0.0003 0.00028681755065918
SELECT value FROM productattributes WHERE product_id = '3828' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
123 0.0003 0.00032877922058105
SELECT * FROM productimages WHERE product_id = '3575' ORDER BY sortorder ASC
124 0.0005 0.00050520896911621
SELECT * FROM product_image_select WHERE product_id = '3575'
125 0.0003 0.00028204917907715
SELECT * FROM productcustomimages WHERE product_id = '3575'
126 0.0007 0.00071001052856445
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3575' AND a.name = n.originalname
127 0.0003 0.00031089782714844
SELECT * FROM productoffers WHERE product_id = '3575' AND merchantid = 'A1X6FK5RDHNB96'
128 0.0002 0.00024199485778809
SELECT * FROM productoffers
                WHERE product_id = '3575' AND price > 0
                ORDER BY price ASC LIMIT 1
129 0.0002 0.00024604797363281
SELECT * FROM productoffers
                WHERE product_id = 3575
                ORDER BY price ASC LIMIT 1
130 0.0003 0.00025200843811035
SELECT value FROM productattributes
                WHERE product_id = '3575'
                AND name = 'ListPriceAmount'
131 0.0003 0.00026607513427734
SELECT value FROM productattributes WHERE product_id = '3575' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
132 0.0003 0.00030994415283203
SELECT * FROM productimages WHERE product_id = '1418' ORDER BY sortorder ASC
133 0.0005 0.00046086311340332
SELECT * FROM product_image_select WHERE product_id = '1418'
134 0.0003 0.00026679039001465
SELECT * FROM productcustomimages WHERE product_id = '1418'
135 0.0008 0.00080704689025879
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1418' AND a.name = n.originalname
136 0.0003 0.00031185150146484
SELECT * FROM productoffers WHERE product_id = '1418' AND merchantid = 'A1X6FK5RDHNB96'
137 0.0003 0.00026082992553711
SELECT * FROM productoffers
                WHERE product_id = '1418' AND price > 0
                ORDER BY price ASC LIMIT 1
138 0.0003 0.00026106834411621
SELECT value FROM productattributes WHERE product_id = '1418' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
139 0.0003 0.00030303001403809
SELECT * FROM productimages WHERE product_id = '2220' ORDER BY sortorder ASC
140 0.0005 0.00052905082702637
SELECT * FROM product_image_select WHERE product_id = '2220'
141 0.0003 0.00026416778564453
SELECT * FROM productcustomimages WHERE product_id = '2220'
142 0.0006 0.00058293342590332
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2220' AND a.name = n.originalname
143 0.0003 0.00030899047851562
SELECT * FROM productoffers WHERE product_id = '2220' AND merchantid = 'A1X6FK5RDHNB96'
144 0.0003 0.00026202201843262
SELECT * FROM productoffers
                WHERE product_id = '2220' AND price > 0
                ORDER BY price ASC LIMIT 1
145 0.0003 0.0003058910369873
SELECT value FROM productattributes WHERE product_id = '2220' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
146 0.0004 0.0003809928894043
SELECT * FROM productimages WHERE product_id = '774' ORDER BY sortorder ASC
147 0.0005 0.0004580020904541
SELECT * FROM product_image_select WHERE product_id = '774'
148 0.0003 0.00026988983154297
SELECT * FROM productcustomimages WHERE product_id = '774'
149 0.0005 0.00054192543029785
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '774' AND a.name = n.originalname
150 0.0003 0.00030803680419922
SELECT * FROM productoffers WHERE product_id = '774' AND merchantid = 'A1X6FK5RDHNB96'
151 0.0002 0.00024795532226562
SELECT * FROM productoffers
                WHERE product_id = '774' AND price > 0
                ORDER BY price ASC LIMIT 1
152 0.0002 0.00022602081298828
SELECT * FROM productoffers
                WHERE product_id = 774
                ORDER BY price ASC LIMIT 1
153 0.0002 0.00024580955505371
SELECT value FROM productattributes
                WHERE product_id = '774'
                AND name = 'ListPriceAmount'
154 0.0003 0.00025701522827148
SELECT value FROM productattributes WHERE product_id = '774' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
155 0.0003 0.00032496452331543
SELECT * FROM productimages WHERE product_id = '1093' ORDER BY sortorder ASC
156 0.0005 0.0005190372467041
SELECT * FROM product_image_select WHERE product_id = '1093'
157 0.0003 0.00029611587524414
SELECT * FROM productcustomimages WHERE product_id = '1093'
158 0.0005 0.00054001808166504
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1093' AND a.name = n.originalname
159 0.0003 0.00032401084899902
SELECT * FROM productoffers WHERE product_id = '1093' AND merchantid = 'A1X6FK5RDHNB96'
160 0.0003 0.00026512145996094
SELECT * FROM productoffers
                WHERE product_id = '1093' AND price > 0
                ORDER BY price ASC LIMIT 1
161 0.0003 0.00026583671569824
SELECT value FROM productattributes WHERE product_id = '1093' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
162 0.0004 0.00036191940307617
SELECT * FROM productimages WHERE product_id = '1354' ORDER BY sortorder ASC
163 0.0005 0.00045204162597656
SELECT * FROM product_image_select WHERE product_id = '1354'
164 0.0003 0.00027298927307129
SELECT * FROM productcustomimages WHERE product_id = '1354'
165 0.0006 0.00060606002807617
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1354' AND a.name = n.originalname
166 0.0003 0.0003049373626709
SELECT * FROM productoffers WHERE product_id = '1354' AND merchantid = 'A1X6FK5RDHNB96'
167 0.0003 0.0002751350402832
SELECT * FROM productoffers
                WHERE product_id = '1354' AND price > 0
                ORDER BY price ASC LIMIT 1
168 0.0003 0.00030398368835449
SELECT value FROM productattributes WHERE product_id = '1354' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
169 0.0003 0.00033903121948242
SELECT * FROM productimages WHERE product_id = '4032' ORDER BY sortorder ASC
170 0.0006 0.00058388710021973
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4032' AND p.id = pi.product_id ORDER BY pi.sortorder
171 0.0005 0.00045013427734375
SELECT * FROM product_image_select WHERE product_id = '4032'
172 0.0003 0.0002899169921875
SELECT * FROM productcustomimages WHERE product_id = '4032'
173 0.0004 0.00035977363586426
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 = '4032'
                GROUP BY o.product_id
174 0.0014 0.001446008682251
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     = '4032'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
175 0.0004 0.00038290023803711
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4032
176 0.0005 0.00054216384887695
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4032' AND a.name = n.originalname
177 0.0002 0.00024795532226562
SELECT * FROM productoffers WHERE product_id = '4032' AND merchantid = 'A1X6FK5RDHNB96'
178 0.0003 0.00034999847412109
SELECT * FROM productoffers
                WHERE product_id = '4032' AND price > 0
                ORDER BY price ASC LIMIT 1
179 0.0002 0.00023984909057617
SELECT * FROM productoffers
                WHERE product_id = 4032
                ORDER BY price ASC LIMIT 1
180 0.0003 0.0002591609954834
SELECT value FROM productattributes
                WHERE product_id = '4032'
                AND name = 'ListPriceAmount'
181 0.0003 0.00028896331787109
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 = '4032'
                GROUP BY o.product_id
182 0.0005 0.00045108795166016
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     = '4032'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
183 0.0003 0.00027203559875488
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4032
184 0.0003 0.00034189224243164
SELECT value FROM productattributes WHERE product_id = '4032' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
185 0.0004 0.00043511390686035
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4032'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
186 0.0004 0.00036716461181641
SELECT * FROM productimages WHERE product_id = '3786' ORDER BY sortorder ASC
187 0.0003 0.00034189224243164
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3786' AND p.id = pi.product_id ORDER BY pi.sortorder
188 0.0004 0.00044798851013184
SELECT * FROM product_image_select WHERE product_id = '3786'
189 0.0003 0.00027799606323242
SELECT * FROM productcustomimages WHERE product_id = '3786'
190 0.0003 0.00033307075500488
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 = '3786'
                GROUP BY o.product_id
191 0.0004 0.0004270076751709
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     = '3786'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
192 0.0003 0.00026106834411621
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3786
193 0.0005 0.00054311752319336
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3786' AND a.name = n.originalname
194 0.0002 0.00024008750915527
SELECT * FROM productoffers WHERE product_id = '3786' AND merchantid = 'A1X6FK5RDHNB96'
195 0.0002 0.00023794174194336
SELECT * FROM productoffers
                WHERE product_id = '3786' AND price > 0
                ORDER BY price ASC LIMIT 1
196 0.0002 0.0002288818359375
SELECT * FROM productoffers
                WHERE product_id = 3786
                ORDER BY price ASC LIMIT 1
197 0.0002 0.00024604797363281
SELECT value FROM productattributes
                WHERE product_id = '3786'
                AND name = 'ListPriceAmount'
198 0.0003 0.00028896331787109
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 = '3786'
                GROUP BY o.product_id
199 0.0006 0.00061416625976562
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     = '3786'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
200 0.0003 0.00029397010803223
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3786
201 0.0006 0.00059700012207031
SELECT value FROM productattributes WHERE product_id = '3786' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
202 0.0004 0.00041985511779785
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3786'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
203 0.0004 0.00036191940307617
SELECT * FROM productimages WHERE product_id = '2851' ORDER BY sortorder ASC
204 0.0005 0.0005040168762207
SELECT * FROM product_image_select WHERE product_id = '2851'
205 0.0009 0.00086402893066406
SELECT * FROM productcustomimages WHERE product_id = '2851'
206 0.0009 0.00089502334594727
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2851' AND a.name = n.originalname
207 0.0005 0.0004580020904541
SELECT * FROM productoffers WHERE product_id = '2851' AND merchantid = 'A1X6FK5RDHNB96'
208 0.0004 0.00035810470581055
SELECT * FROM productoffers
                WHERE product_id = '2851' AND price > 0
                ORDER BY price ASC LIMIT 1
209 0.0004 0.00037217140197754
SELECT value FROM productattributes WHERE product_id = '2851' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
210 0.0007 0.0007319450378418
SELECT * FROM productimages WHERE product_id = '1348' ORDER BY sortorder ASC
211 0.0007 0.00065493583679199
SELECT * FROM product_image_select WHERE product_id = '1348'
212 0.0004 0.00036191940307617
SELECT * FROM productcustomimages WHERE product_id = '1348'
213 0.0015 0.0015480518341064
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1348' AND a.name = n.originalname
214 0.0007 0.00074100494384766
SELECT * FROM productoffers WHERE product_id = '1348' AND merchantid = 'A1X6FK5RDHNB96'
215 0.0015 0.0015451908111572
SELECT * FROM productoffers
                WHERE product_id = '1348' AND price > 0
                ORDER BY price ASC LIMIT 1
216 0.0008 0.00077199935913086
SELECT value FROM productattributes WHERE product_id = '1348' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
217 0.0008 0.00084805488586426
SELECT * FROM productimages WHERE product_id = '1339' ORDER BY sortorder ASC
218 0.0010 0.00097894668579102
SELECT * FROM product_image_select WHERE product_id = '1339'
219 0.0005 0.00051593780517578
SELECT * FROM productcustomimages WHERE product_id = '1339'
220 0.0020 0.0020310878753662
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1339' AND a.name = n.originalname
221 0.0009 0.00092816352844238
SELECT * FROM productoffers WHERE product_id = '1339' AND merchantid = 'A1X6FK5RDHNB96'
222 0.0006 0.0005800724029541
SELECT * FROM productoffers
                WHERE product_id = '1339' AND price > 0
                ORDER BY price ASC LIMIT 1
223 0.0005 0.00049710273742676
SELECT * FROM productoffers
                WHERE product_id = 1339
                ORDER BY price ASC LIMIT 1
224 0.0012 0.0011839866638184
SELECT value FROM productattributes
                WHERE product_id = '1339'
                AND name = 'ListPriceAmount'
225 0.0006 0.00062108039855957
SELECT value FROM productattributes WHERE product_id = '1339' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
226 0.0007 0.00072097778320312
SELECT * FROM productimages WHERE product_id = '843' ORDER BY sortorder ASC
227 0.0010 0.00097203254699707
SELECT * FROM product_image_select WHERE product_id = '843'
228 0.0005 0.00050210952758789
SELECT * FROM productcustomimages WHERE product_id = '843'
229 0.0015 0.0014519691467285
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '843' AND a.name = n.originalname
230 0.0006 0.00057101249694824
SELECT * FROM productoffers WHERE product_id = '843' AND merchantid = 'A1X6FK5RDHNB96'
231 0.0004 0.00042605400085449
SELECT * FROM productoffers
                WHERE product_id = '843' AND price > 0
                ORDER BY price ASC LIMIT 1
232 0.0004 0.00041103363037109
SELECT * FROM productoffers
                WHERE product_id = 843
                ORDER BY price ASC LIMIT 1
233 0.0004 0.00043392181396484
SELECT value FROM productattributes
                WHERE product_id = '843'
                AND name = 'ListPriceAmount'
234 0.0005 0.00049901008605957
SELECT value FROM productattributes WHERE product_id = '843' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
235 0.0006 0.00057196617126465
SELECT * FROM productimages WHERE product_id = '4910' ORDER BY sortorder ASC
236 0.0010 0.0010020732879639
SELECT * FROM product_image_select WHERE product_id = '4910'
237 0.0005 0.00046992301940918
SELECT * FROM productcustomimages WHERE product_id = '4910'
238 0.0014 0.0014028549194336
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4910' AND a.name = n.originalname
239 0.0006 0.00055599212646484
SELECT * FROM productoffers WHERE product_id = '4910' AND merchantid = 'A1X6FK5RDHNB96'
240 0.0005 0.00048685073852539
SELECT * FROM productoffers
                WHERE product_id = '4910' AND price > 0
                ORDER BY price ASC LIMIT 1
241 0.0005 0.0005180835723877
SELECT value FROM productattributes WHERE product_id = '4910' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
242 0.0006 0.00062394142150879
SELECT * FROM productimages WHERE product_id = '2671' ORDER BY sortorder ASC
243 0.0010 0.0009770393371582
SELECT * FROM product_image_select WHERE product_id = '2671'
244 0.0005 0.0004570484161377
SELECT * FROM productcustomimages WHERE product_id = '2671'
245 0.0013 0.0012729167938232
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2671' AND a.name = n.originalname
246 0.0006 0.00057101249694824
SELECT * FROM productoffers WHERE product_id = '2671' AND merchantid = 'A1X6FK5RDHNB96'
247 0.0005 0.00053215026855469
SELECT * FROM productoffers
                WHERE product_id = '2671' AND price > 0
                ORDER BY price ASC LIMIT 1
248 0.0004 0.0003819465637207
SELECT * FROM productoffers
                WHERE product_id = 2671
                ORDER BY price ASC LIMIT 1
249 0.0005 0.00047802925109863
SELECT value FROM productattributes
                WHERE product_id = '2671'
                AND name = 'ListPriceAmount'
250 0.0004 0.00044798851013184
SELECT value FROM productattributes WHERE product_id = '2671' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
251 0.0018 0.0018329620361328
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '941' ORDER BY timestamp DESC
252 0.0004 0.00039196014404297
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4814' ORDER BY timestamp DESC
253 0.0003 0.00033307075500488
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2883' ORDER BY timestamp DESC
254 0.0003 0.00034594535827637
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3828' ORDER BY timestamp DESC
255 0.0003 0.00031208992004395
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3575' ORDER BY timestamp DESC
256 0.0003 0.00033903121948242
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1418' ORDER BY timestamp DESC
257 0.0003 0.0003049373626709
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2220' ORDER BY timestamp DESC
258 0.0003 0.00031399726867676
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '774' ORDER BY timestamp DESC
259 0.0003 0.00034809112548828
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1093' ORDER BY timestamp DESC
260 0.0004 0.00036811828613281
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1354' ORDER BY timestamp DESC
261 0.0003 0.00030899047851562
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4032' ORDER BY timestamp DESC
262 0.0003 0.00032305717468262
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3786' ORDER BY timestamp DESC
263 0.0003 0.0003211498260498
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2851' ORDER BY timestamp DESC
264 0.0004 0.00035500526428223
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1348' ORDER BY timestamp DESC
265 0.0007 0.00073909759521484
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1339' ORDER BY timestamp DESC
266 0.0004 0.00036406517028809
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '843' ORDER BY timestamp DESC
267 0.0003 0.00030899047851562
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4910' ORDER BY timestamp DESC
268 0.0003 0.00031208992004395
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2671' ORDER BY timestamp DESC
269 0.0018 0.0018088817596436
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
270 0.0022 0.0022399425506592
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
271 0.0004 0.00041413307189941
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
272 0.0333 0.033309936523438
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
273 0.0024 0.0024139881134033
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
274 0.0005 0.00046586990356445
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
275 0.0004 0.00042104721069336
SELECT * FROM products WHERE id = 1626
276 0.0004 0.00036501884460449
SELECT * FROM products WHERE id = 4041
277 0.0004 0.00035381317138672
SELECT * FROM products WHERE id = 4312
278 0.0003 0.0003349781036377
SELECT * FROM products WHERE id = 777
279 0.0004 0.0003669261932373
SELECT * FROM products WHERE id = 3881
280 0.0004 0.00039410591125488
SELECT * FROM products WHERE id = 4213
281 0.0004 0.00035285949707031
SELECT * FROM products WHERE id = '1626'
282 0.0005 0.00046801567077637
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
283 0.0005 0.00048398971557617
SELECT * FROM product_image_select WHERE product_id = '1626'
284 0.0003 0.00032997131347656
SELECT * FROM productcustomimages WHERE product_id = '1626'
285 0.0007 0.0006868839263916
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
286 0.0005 0.00045108795166016
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
287 0.0003 0.00032806396484375
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
288 0.0004 0.0004279613494873
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
289 0.0004 0.00042605400085449
SELECT * FROM products WHERE id = '4041'
290 0.0004 0.00044393539428711
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
291 0.0006 0.00055217742919922
SELECT * FROM product_image_select WHERE product_id = '4041'
292 0.0003 0.00034308433532715
SELECT * FROM productcustomimages WHERE product_id = '4041'
293 0.0008 0.00082492828369141
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
294 0.0004 0.00039505958557129
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
295 0.0004 0.00038814544677734
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
296 0.0005 0.00046300888061523
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
297 0.0004 0.00042486190795898
SELECT * FROM products WHERE id = '4312'
298 0.0005 0.00046682357788086
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
299 0.0006 0.00060606002807617
SELECT * FROM product_image_select WHERE product_id = '4312'
300 0.0003 0.00034093856811523
SELECT * FROM productcustomimages WHERE product_id = '4312'
301 0.0008 0.00077700614929199
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
302 0.0006 0.0006098747253418
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
303 0.0003 0.00030779838562012
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
304 0.0004 0.00037503242492676
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
305 0.0005 0.00045299530029297
SELECT * FROM products WHERE id = '777'
306 0.0004 0.00040888786315918
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
307 0.0005 0.00046300888061523
SELECT * FROM product_image_select WHERE product_id = '777'
308 0.0003 0.00028300285339355
SELECT * FROM productcustomimages WHERE product_id = '777'
309 0.0007 0.0007479190826416
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
310 0.0004 0.00035786628723145
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
311 0.0003 0.00034999847412109
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
312 0.0003 0.00033903121948242
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
313 0.0004 0.00041604042053223
SELECT * FROM products WHERE id = '3881'
314 0.0004 0.00039887428283691
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
315 0.0006 0.0006098747253418
SELECT * FROM product_image_select WHERE product_id = '3881'
316 0.0003 0.00033187866210938
SELECT * FROM productcustomimages WHERE product_id = '3881'
317 0.0009 0.00089097023010254
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
318 0.0003 0.00034284591674805
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
319 0.0003 0.0002748966217041
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
320 0.0003 0.00033307075500488
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
321 0.0004 0.00040602684020996
SELECT * FROM products WHERE id = '4213'
322 0.0006 0.00061583518981934
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
323 0.0005 0.00051784515380859
SELECT * FROM product_image_select WHERE product_id = '4213'
324 0.0003 0.00030303001403809
SELECT * FROM productcustomimages WHERE product_id = '4213'
325 0.0008 0.00075912475585938
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
326 0.0004 0.00035381317138672
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
327 0.0003 0.0002899169921875
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
328 0.0004 0.00035905838012695
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
329 0.0016 0.0016438961029053
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
330 0.0005 0.00051093101501465
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
331 0.0018 0.0018460750579834
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
332 0.0013 0.0012772083282471
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
333 0.0005 0.00052905082702637
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
334 0.0005 0.00046801567077637
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
335 0.0005 0.00048589706420898
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'