0

All Products

Select your options below to filter out the products you don't want to see.

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
2.3574569225311 312 1.2493 0


No Amazon API Requests Made.


App Debug - Total Time 2.3574569225311 seconds

Number Time From Start Name Description
1 0.99047493934631 Initialise Initialise FSB Function
2 1.0107259750366 App Controller Start Start of the App controller (called before the controller of every page)
3 1.0640158653259 Start of getCategoryListByGroup Function Before first category groups query
4 1.0661239624023 After initial query Before first category groups query
5 1.0661268234253 Get Category List for Group Before the call to getCategoryList function
6 1.0661330223083 Start of GetCategoryList function Start of the function
7 1.0661389827728 Before getting categories Query to get specific category list
8 1.07457280159 After getting categories Query to get specific category list
9 1.0745768547058 Before getting category custom Before call to function getCategoryCustom
10 1.1663529872894 After getting category custom After call to function getCategoryCustom
11 1.1663589477539 Before getting category custom Before call to function getCategoryCustom
12 1.2245209217072 After getting category custom After call to function getCategoryCustom
13 1.2245268821716 Before getting category custom Before call to function getCategoryCustom
14 1.2324860095978 After getting category custom After call to function getCategoryCustom
15 1.2324910163879 Before getting category custom Before call to function getCategoryCustom
16 1.2378299236298 After getting category custom After call to function getCategoryCustom
17 1.2378358840942 Before getting category custom Before call to function getCategoryCustom
18 1.2439298629761 After getting category custom After call to function getCategoryCustom
19 1.2439358234406 Before getting category custom Before call to function getCategoryCustom
20 1.2502059936523 After getting category custom After call to function getCategoryCustom
21 1.2502110004425 End of GetCategoryList function End of the function
22 1.2502219676971 Get Category List for Group Before the call to getCategoryList function
23 1.250226020813 Start of GetCategoryList function Start of the function
24 1.2502298355103 Before getting categories Query to get specific category list
25 1.2508180141449 End of getCategoryListByGroup Function Before return()
26 1.8890058994293 App Controller End End of the App controller (called before the controller of every page)
27 2.1296799182892 After Getting Product/Bundle Reviews After getting full product/bundle customer review in the All Products Controller
28 2.1463859081268 App_after Controller Start Start of the App_after controller (called after the controller of every page)
29 2.1505279541016 Before Get Options Before the call to getOptions in the tpl class
30 2.2514009475708 After Get Options After the call to getOptions in the tpl class
31 2.2519659996033 App_after Controller End End of the App_after controller (called after the controller of every page)
32 2.3574249744415 Finalizing debug Before the debug is output to the page.
33 2.3574538230896 End of App This is the end of the app logging, final timestamp


Query Debug - 312 Database Queries. Total time 1.2493 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0022 0.0021848678588867
SELECT parameter, value FROM parameters
2 0.0095 0.0095100402832031
SELECT * FROM `bad_bots`
3 0.0006 0.00060892105102539
SET time_zone = 'Europe/London'
4 0.0038 0.0037529468536377
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0038 0.0038020610809326
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"98.82.120.188\";}'
6 0.0037 0.0037438869476318
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1725943380'
7 0.0066 0.0065710544586182
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0008 0.00083589553833008
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0069 0.0069320201873779
SELECT id FROM pages WHERE pagename = 'all-products' LIMIT 1
10 0.0040 0.0039761066436768
SELECT * FROM pages WHERE id = 37
11 0.0077 0.0076549053192139
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0438 0.04380989074707
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0009 0.00092411041259766
SELECT * FROM pages WHERE pagename = 'all-products'
14 0.0017 0.001723051071167
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0084 0.0083878040313721
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0117 0.011713981628418
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.0080 0.0079531669616699
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.0081 0.0080602169036865
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0079 0.0078580379486084
SELECT id FROM categories WHERE parent_id = '26'
20 0.0201 0.020051002502441
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.0079 0.0078928470611572
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.0120 0.01195502281189
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.0120 0.011954069137573
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0040 0.0039758682250977
SELECT * FROM categorygroups WHERE id = '1'
25 0.0199 0.019934892654419
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.0080 0.0079731941223145
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.0040 0.0040240287780762
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0079 0.0079147815704346
SELECT id FROM categories WHERE parent_id = '27'
29 0.0120 0.01202392578125
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.0039 0.0038909912109375
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.0009 0.00090909004211426
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.0007 0.00068902969360352
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0005 0.00052094459533691
SELECT * FROM categorygroups WHERE id = '1'
34 0.0017 0.0017430782318115
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.0007 0.00067591667175293
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
36 0.0005 0.00048017501831055
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0006 0.00056600570678711
SELECT id FROM categories WHERE parent_id = '28'
38 0.0019 0.0019361972808838
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
39 0.0007 0.00069499015808105
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0 
40 0.0006 0.00064897537231445
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
41 0.0005 0.00054717063903809
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0005 0.00049018859863281
SELECT * FROM categorygroups WHERE id = '1'
43 0.0007 0.00069284439086914
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
44 0.0005 0.0005490779876709
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.00040912628173828
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0005 0.00053095817565918
SELECT id FROM categories WHERE parent_id = '29'
47 0.0009 0.00085282325744629
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.0006 0.0005648136138916
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0 
49 0.0006 0.0005950927734375
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
50 0.0005 0.0005180835723877
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0005 0.00046086311340332
SELECT * FROM categorygroups WHERE id = '1'
52 0.0006 0.00061416625976562
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.00051403045654297
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.00047206878662109
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0005 0.00046801567077637
SELECT id FROM categories WHERE parent_id = '30'
56 0.0007 0.00072693824768066
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.0005 0.00051593780517578
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.0007 0.00069022178649902
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
59 0.0012 0.0012459754943848
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0007 0.00067996978759766
SELECT * FROM categorygroups WHERE id = '1'
61 0.0008 0.00075793266296387
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.0005 0.00053310394287109
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.00043106079101562
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0005 0.00046396255493164
SELECT id FROM categories WHERE parent_id = '31'
65 0.0008 0.00077414512634277
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.0014 0.001413106918335
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.0006 0.00061511993408203
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.0007 0.00065302848815918
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0005 0.00045394897460938
SELECT * FROM categorygroups WHERE id = '1'
70 0.0006 0.00056910514831543
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0031 0.0030789375305176
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0017 0.0017271041870117
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0011 0.0011498928070068
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.0017 0.0016951560974121
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0013 0.0013220310211182
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0012 0.00118088722229
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.6215 0.62154603004456
SELECT * FROM ipgeocountries WHERE INET_ATON('98.82.120.188') >= INET_ATON(ip_start) AND INET_ATON('98.82.120.188') <= INET_ATON(ip_end)
78 0.0021 0.0020630359649658
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0013 0.0012531280517578
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0009 0.00087189674377441
SELECT * FROM pages WHERE pagename = 'all-products'
81 0.0087 0.0086820125579834
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
82 0.0034 0.003371000289917
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
83 0.0027 0.0027430057525635
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
84 0.0074 0.0073950290679932
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
85 0.0031 0.0030710697174072
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
86 0.0006 0.00056195259094238
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
87 0.0051 0.0051178932189941
SELECT COUNT(*) FROM products p WHERE parent_id = 0 AND hidden = 0 AND enabled = 1  AND 1 = 1
88 0.0057 0.0057330131530762
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
89 0.0085 0.0084707736968994
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
90 0.0017 0.0017240047454834
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
91 0.0076 0.0076198577880859
SELECT p.* FROM products p WHERE hidden = 0 AND enabled = 1 AND parent_id = 0 AND 1 = 1 ORDER BY salesrank ASC  LIMIT 0, 18
92 0.0046 0.0046350955963135
SELECT * FROM productimages WHERE product_id = '4950' ORDER BY sortorder ASC
93 0.0055 0.0055348873138428
SELECT * FROM product_image_select WHERE product_id = '4950'
94 0.0044 0.0044410228729248
SELECT * FROM productcustomimages WHERE product_id = '4950'
95 0.0060 0.0060012340545654
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4950' AND a.name = n.originalname
96 0.0057 0.0057179927825928
SELECT * FROM productoffers WHERE product_id = '4950' AND merchantid = 'A1X6FK5RDHNB96'
97 0.0031 0.0031318664550781
SELECT * FROM productoffers
                WHERE product_id = '4950' AND price > 0
                ORDER BY price ASC LIMIT 1
98 0.0018 0.0017938613891602
SELECT value FROM productattributes WHERE product_id = '4950' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
99 0.0015 0.0015048980712891
SELECT * FROM productimages WHERE product_id = '4953' ORDER BY sortorder ASC
100 0.0015 0.0015361309051514
SELECT * FROM product_image_select WHERE product_id = '4953'
101 0.0008 0.00079917907714844
SELECT * FROM productcustomimages WHERE product_id = '4953'
102 0.0024 0.0024189949035645
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4953' AND a.name = n.originalname
103 0.0010 0.00095796585083008
SELECT * FROM productoffers WHERE product_id = '4953' AND merchantid = 'A1X6FK5RDHNB96'
104 0.0006 0.00062799453735352
SELECT * FROM productoffers
                WHERE product_id = '4953' AND price > 0
                ORDER BY price ASC LIMIT 1
105 0.0009 0.00090789794921875
SELECT value FROM productattributes WHERE product_id = '4953' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
106 0.0009 0.00085091590881348
SELECT * FROM productimages WHERE product_id = '4933' ORDER BY sortorder ASC
107 0.0010 0.0010390281677246
SELECT * FROM product_image_select WHERE product_id = '4933'
108 0.0006 0.00058889389038086
SELECT * FROM productcustomimages WHERE product_id = '4933'
109 0.0025 0.0024690628051758
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4933' AND a.name = n.originalname
110 0.0008 0.00076603889465332
SELECT * FROM productoffers WHERE product_id = '4933' AND merchantid = 'A1X6FK5RDHNB96'
111 0.0006 0.00057792663574219
SELECT * FROM productoffers
                WHERE product_id = '4933' AND price > 0
                ORDER BY price ASC LIMIT 1
112 0.0005 0.0005490779876709
SELECT value FROM productattributes WHERE product_id = '4933' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
113 0.0006 0.00064992904663086
SELECT * FROM productimages WHERE product_id = '4926' ORDER BY sortorder ASC
114 0.0010 0.0009610652923584
SELECT * FROM product_image_select WHERE product_id = '4926'
115 0.0005 0.00048279762268066
SELECT * FROM productcustomimages WHERE product_id = '4926'
116 0.0014 0.0014278888702393
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4926' AND a.name = n.originalname
117 0.0006 0.00055813789367676
SELECT * FROM productoffers WHERE product_id = '4926' AND merchantid = 'A1X6FK5RDHNB96'
118 0.0005 0.00050210952758789
SELECT * FROM productoffers
                WHERE product_id = '4926' AND price > 0
                ORDER BY price ASC LIMIT 1
119 0.0006 0.0005648136138916
SELECT value FROM productattributes WHERE product_id = '4926' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
120 0.0008 0.00081014633178711
SELECT * FROM productimages WHERE product_id = '4925' ORDER BY sortorder ASC
121 0.0007 0.00069594383239746
SELECT * FROM product_image_select WHERE product_id = '4925'
122 0.0005 0.00045394897460938
SELECT * FROM productcustomimages WHERE product_id = '4925'
123 0.0012 0.0011990070343018
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4925' AND a.name = n.originalname
124 0.0006 0.00055599212646484
SELECT * FROM productoffers WHERE product_id = '4925' AND merchantid = 'A1X6FK5RDHNB96'
125 0.0005 0.00051093101501465
SELECT * FROM productoffers
                WHERE product_id = '4925' AND price > 0
                ORDER BY price ASC LIMIT 1
126 0.0005 0.00045394897460938
SELECT value FROM productattributes WHERE product_id = '4925' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
127 0.0008 0.00075006484985352
SELECT * FROM productimages WHERE product_id = '868' ORDER BY sortorder ASC
128 0.0007 0.00071597099304199
SELECT * FROM product_image_select WHERE product_id = '868'
129 0.0004 0.00043582916259766
SELECT * FROM productcustomimages WHERE product_id = '868'
130 0.0011 0.0011138916015625
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '868' AND a.name = n.originalname
131 0.0006 0.00057005882263184
SELECT * FROM productoffers WHERE product_id = '868' AND merchantid = 'A1X6FK5RDHNB96'
132 0.0004 0.00043797492980957
SELECT * FROM productoffers
                WHERE product_id = '868' AND price > 0
                ORDER BY price ASC LIMIT 1
133 0.0005 0.00051999092102051
SELECT value FROM productattributes WHERE product_id = '868' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
134 0.0007 0.00067591667175293
SELECT * FROM productimages WHERE product_id = '4919' ORDER BY sortorder ASC
135 0.0006 0.00062704086303711
SELECT * FROM product_image_select WHERE product_id = '4919'
136 0.0005 0.0004570484161377
SELECT * FROM productcustomimages WHERE product_id = '4919'
137 0.0012 0.0012259483337402
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4919' AND a.name = n.originalname
138 0.0005 0.00053286552429199
SELECT * FROM productoffers WHERE product_id = '4919' AND merchantid = 'A1X6FK5RDHNB96'
139 0.0023 0.0023329257965088
SELECT * FROM productoffers
                WHERE product_id = '4919' AND price > 0
                ORDER BY price ASC LIMIT 1
140 0.0006 0.00055408477783203
SELECT value FROM productattributes WHERE product_id = '4919' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
141 0.0009 0.00094485282897949
SELECT * FROM productimages WHERE product_id = '2029' ORDER BY sortorder ASC
142 0.0013 0.0012519359588623
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2029' AND p.id = pi.product_id ORDER BY pi.sortorder
143 0.0008 0.00081086158752441
SELECT * FROM product_image_select WHERE product_id = '2029'
144 0.0005 0.00054097175598145
SELECT * FROM productcustomimages WHERE product_id = '2029'
145 0.0008 0.0008089542388916
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 = '2029'
                GROUP BY o.product_id
146 0.0064 0.0063960552215576
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     = '2029'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
147 0.0007 0.0006558895111084
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2029
148 0.0014 0.0013980865478516
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2029' AND a.name = n.originalname
149 0.0005 0.0005338191986084
SELECT * FROM productoffers WHERE product_id = '2029' AND merchantid = 'A1X6FK5RDHNB96'
150 0.0004 0.00043392181396484
SELECT * FROM productoffers
                WHERE product_id = '2029' AND price > 0
                ORDER BY price ASC LIMIT 1
151 0.0004 0.00037193298339844
SELECT * FROM productoffers
                WHERE product_id = 2029
                ORDER BY price ASC LIMIT 1
152 0.0004 0.0004270076751709
SELECT value FROM productattributes
                WHERE product_id = '2029'
                AND name = 'ListPriceAmount'
153 0.0006 0.00055885314941406
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 = '2029'
                GROUP BY o.product_id
154 0.0007 0.00071406364440918
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     = '2029'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
155 0.0005 0.00046801567077637
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2029
156 0.0006 0.00060701370239258
SELECT value FROM productattributes WHERE product_id = '2029' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
157 0.0006 0.00063395500183105
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '2029'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
158 0.0006 0.00062918663024902
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
159 0.0007 0.000701904296875
SELECT * FROM product_image_select WHERE product_id = '862'
160 0.0004 0.00043702125549316
SELECT * FROM productcustomimages WHERE product_id = '862'
161 0.0011 0.0010972023010254
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
162 0.0005 0.00052714347839355
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
163 0.0005 0.00048112869262695
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
164 0.0005 0.00050520896911621
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
165 0.0006 0.0006411075592041
SELECT * FROM productimages WHERE product_id = '1011' ORDER BY sortorder ASC
166 0.0006 0.00061202049255371
SELECT * FROM product_image_select WHERE product_id = '1011'
167 0.0005 0.00046086311340332
SELECT * FROM productcustomimages WHERE product_id = '1011'
168 0.0010 0.00099301338195801
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1011' AND a.name = n.originalname
169 0.0005 0.00050187110900879
SELECT * FROM productoffers WHERE product_id = '1011' AND merchantid = 'A1X6FK5RDHNB96'
170 0.0004 0.00043797492980957
SELECT * FROM productoffers
                WHERE product_id = '1011' AND price > 0
                ORDER BY price ASC LIMIT 1
171 0.0004 0.00043392181396484
SELECT value FROM productattributes WHERE product_id = '1011' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
172 0.0006 0.00059199333190918
SELECT * FROM productimages WHERE product_id = '4122' ORDER BY sortorder ASC
173 0.0006 0.00058913230895996
SELECT * FROM product_image_select WHERE product_id = '4122'
174 0.0004 0.00042009353637695
SELECT * FROM productcustomimages WHERE product_id = '4122'
175 0.0011 0.0011260509490967
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4122' AND a.name = n.originalname
176 0.0006 0.00058889389038086
SELECT * FROM productoffers WHERE product_id = '4122' AND merchantid = 'A1X6FK5RDHNB96'
177 0.0005 0.00050806999206543
SELECT * FROM productoffers
                WHERE product_id = '4122' AND price > 0
                ORDER BY price ASC LIMIT 1
178 0.0005 0.0004730224609375
SELECT value FROM productattributes WHERE product_id = '4122' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
179 0.0006 0.00058293342590332
SELECT * FROM productimages WHERE product_id = '1010' ORDER BY sortorder ASC
180 0.0006 0.00064516067504883
SELECT * FROM product_image_select WHERE product_id = '1010'
181 0.0005 0.00046992301940918
SELECT * FROM productcustomimages WHERE product_id = '1010'
182 0.0010 0.0010058879852295
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1010' AND a.name = n.originalname
183 0.0005 0.00048494338989258
SELECT * FROM productoffers WHERE product_id = '1010' AND merchantid = 'A1X6FK5RDHNB96'
184 0.0004 0.00043010711669922
SELECT * FROM productoffers
                WHERE product_id = '1010' AND price > 0
                ORDER BY price ASC LIMIT 1
185 0.0004 0.00043702125549316
SELECT value FROM productattributes WHERE product_id = '1010' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
186 0.0006 0.0006248950958252
SELECT * FROM productimages WHERE product_id = '1140' ORDER BY sortorder ASC
187 0.0006 0.0006260871887207
SELECT * FROM product_image_select WHERE product_id = '1140'
188 0.0004 0.00042486190795898
SELECT * FROM productcustomimages WHERE product_id = '1140'
189 0.0008 0.00082302093505859
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1140' AND a.name = n.originalname
190 0.0005 0.00053501129150391
SELECT * FROM productoffers WHERE product_id = '1140' AND merchantid = 'A1X6FK5RDHNB96'
191 0.0004 0.00044584274291992
SELECT * FROM productoffers
                WHERE product_id = '1140' AND price > 0
                ORDER BY price ASC LIMIT 1
192 0.0005 0.00046586990356445
SELECT value FROM productattributes WHERE product_id = '1140' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
193 0.0007 0.00065088272094727
SELECT * FROM productimages WHERE product_id = '1061' ORDER BY sortorder ASC
194 0.0006 0.00063610076904297
SELECT * FROM product_image_select WHERE product_id = '1061'
195 0.0004 0.00042891502380371
SELECT * FROM productcustomimages WHERE product_id = '1061'
196 0.0013 0.0013279914855957
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1061' AND a.name = n.originalname
197 0.0006 0.00056815147399902
SELECT * FROM productoffers WHERE product_id = '1061' AND merchantid = 'A1X6FK5RDHNB96'
198 0.0005 0.00051212310791016
SELECT * FROM productoffers
                WHERE product_id = '1061' AND price > 0
                ORDER BY price ASC LIMIT 1
199 0.0005 0.00050997734069824
SELECT value FROM productattributes WHERE product_id = '1061' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
200 0.0006 0.0006110668182373
SELECT * FROM productimages WHERE product_id = '2165' ORDER BY sortorder ASC
201 0.0007 0.00067782402038574
SELECT * FROM product_image_select WHERE product_id = '2165'
202 0.0007 0.00066590309143066
SELECT * FROM productcustomimages WHERE product_id = '2165'
203 0.0009 0.00092101097106934
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2165' AND a.name = n.originalname
204 0.0006 0.00058293342590332
SELECT * FROM productoffers WHERE product_id = '2165' AND merchantid = 'A1X6FK5RDHNB96'
205 0.0007 0.00068497657775879
SELECT * FROM productoffers
                WHERE product_id = '2165' AND price > 0
                ORDER BY price ASC LIMIT 1
206 0.0025 0.0024590492248535
SELECT value FROM productattributes WHERE product_id = '2165' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
207 0.0008 0.00079512596130371
SELECT * FROM productimages WHERE product_id = '4939' ORDER BY sortorder ASC
208 0.0010 0.0010080337524414
SELECT * FROM product_image_select WHERE product_id = '4939'
209 0.0005 0.00052499771118164
SELECT * FROM productcustomimages WHERE product_id = '4939'
210 0.0012 0.0011529922485352
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4939' AND a.name = n.originalname
211 0.0007 0.00070905685424805
SELECT * FROM productoffers WHERE product_id = '4939' AND merchantid = 'A1X6FK5RDHNB96'
212 0.0007 0.00066113471984863
SELECT * FROM productoffers
                WHERE product_id = '4939' AND price > 0
                ORDER BY price ASC LIMIT 1
213 0.0006 0.0006098747253418
SELECT value FROM productattributes WHERE product_id = '4939' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
214 0.0010 0.00098609924316406
SELECT * FROM productimages WHERE product_id = '1110' ORDER BY sortorder ASC
215 0.0007 0.0007479190826416
SELECT * FROM product_image_select WHERE product_id = '1110'
216 0.0006 0.0006258487701416
SELECT * FROM productcustomimages WHERE product_id = '1110'
217 0.0012 0.0012168884277344
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1110' AND a.name = n.originalname
218 0.0007 0.00068497657775879
SELECT * FROM productoffers WHERE product_id = '1110' AND merchantid = 'A1X6FK5RDHNB96'
219 0.0006 0.00060486793518066
SELECT * FROM productoffers
                WHERE product_id = '1110' AND price > 0
                ORDER BY price ASC LIMIT 1
220 0.0007 0.00066900253295898
SELECT value FROM productattributes WHERE product_id = '1110' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
221 0.0007 0.00067400932312012
SELECT * FROM productimages WHERE product_id = '4930' ORDER BY sortorder ASC
222 0.0007 0.00067400932312012
SELECT * FROM product_image_select WHERE product_id = '4930'
223 0.0005 0.00048208236694336
SELECT * FROM productcustomimages WHERE product_id = '4930'
224 0.0101 0.010071992874146
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4930' AND a.name = n.originalname
225 0.0018 0.0018229484558105
SELECT * FROM productoffers WHERE product_id = '4930' AND merchantid = 'A1X6FK5RDHNB96'
226 0.0034 0.0034301280975342
SELECT * FROM productoffers
                WHERE product_id = '4930' AND price > 0
                ORDER BY price ASC LIMIT 1
227 0.0009 0.00089120864868164
SELECT value FROM productattributes WHERE product_id = '4930' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
228 0.0024 0.002357006072998
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4950' ORDER BY timestamp DESC
229 0.0006 0.00055813789367676
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4953' ORDER BY timestamp DESC
230 0.0006 0.00057578086853027
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4933' ORDER BY timestamp DESC
231 0.0005 0.00054097175598145
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4926' ORDER BY timestamp DESC
232 0.0004 0.00042295455932617
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4925' ORDER BY timestamp DESC
233 0.0009 0.00085902214050293
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '868' ORDER BY timestamp DESC
234 0.0008 0.00083684921264648
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4919' ORDER BY timestamp DESC
235 0.0007 0.00065207481384277
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2029' ORDER BY timestamp DESC
236 0.0014 0.0013940334320068
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '862' ORDER BY timestamp DESC
237 0.0009 0.00090408325195312
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1011' ORDER BY timestamp DESC
238 0.0006 0.00059103965759277
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4122' ORDER BY timestamp DESC
239 0.0005 0.00053095817565918
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1010' ORDER BY timestamp DESC
240 0.0005 0.00047707557678223
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1140' ORDER BY timestamp DESC
241 0.0004 0.00042414665222168
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1061' ORDER BY timestamp DESC
242 0.0012 0.0012331008911133
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2165' ORDER BY timestamp DESC
243 0.0005 0.00054097175598145
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4939' ORDER BY timestamp DESC
244 0.0011 0.001072883605957
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1110' ORDER BY timestamp DESC
245 0.0007 0.00067687034606934
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4930' ORDER BY timestamp DESC
246 0.0158 0.015779972076416
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
247 0.0035 0.0035429000854492
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
248 0.0005 0.00046610832214355
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
249 0.0222 0.022243022918701
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
250 0.0022 0.0021800994873047
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
251 0.0006 0.00060892105102539
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
252 0.0006 0.0006411075592041
SELECT * FROM products WHERE id = 1626
253 0.0005 0.00047492980957031
SELECT * FROM products WHERE id = 4041
254 0.0005 0.00049901008605957
SELECT * FROM products WHERE id = 4312
255 0.0005 0.0005030632019043
SELECT * FROM products WHERE id = 777
256 0.0005 0.00047993659973145
SELECT * FROM products WHERE id = 3881
257 0.0005 0.00049901008605957
SELECT * FROM products WHERE id = 4213
258 0.0005 0.00046610832214355
SELECT * FROM products WHERE id = '1626'
259 0.0006 0.00057482719421387
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
260 0.0007 0.00074291229248047
SELECT * FROM product_image_select WHERE product_id = '1626'
261 0.0005 0.0004570484161377
SELECT * FROM productcustomimages WHERE product_id = '1626'
262 0.0011 0.0011169910430908
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
263 0.0006 0.00059604644775391
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
264 0.0005 0.00052905082702637
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
265 0.0006 0.00057101249694824
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
266 0.0007 0.00069689750671387
SELECT * FROM products WHERE id = '4041'
267 0.0005 0.00053310394287109
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
268 0.0006 0.00064802169799805
SELECT * FROM product_image_select WHERE product_id = '4041'
269 0.0004 0.00043010711669922
SELECT * FROM productcustomimages WHERE product_id = '4041'
270 0.0027 0.002720832824707
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
271 0.0012 0.0012171268463135
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
272 0.0004 0.00044989585876465
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
273 0.0019 0.0019419193267822
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
274 0.0052 0.0052399635314941
SELECT * FROM products WHERE id = '4312'
275 0.0012 0.001162052154541
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
276 0.0021 0.0020751953125
SELECT * FROM product_image_select WHERE product_id = '4312'
277 0.0023 0.0022549629211426
SELECT * FROM productcustomimages WHERE product_id = '4312'
278 0.0049 0.0049450397491455
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
279 0.0011 0.0010969638824463
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
280 0.0008 0.0008389949798584
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
281 0.0010 0.0010089874267578
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
282 0.0009 0.00093507766723633
SELECT * FROM products WHERE id = '777'
283 0.0009 0.00086092948913574
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
284 0.0007 0.00068807601928711
SELECT * FROM product_image_select WHERE product_id = '777'
285 0.0008 0.00076007843017578
SELECT * FROM productcustomimages WHERE product_id = '777'
286 0.0017 0.0017220973968506
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
287 0.0006 0.00062894821166992
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
288 0.0005 0.00049209594726562
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
289 0.0007 0.00068902969360352
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
290 0.0008 0.00081610679626465
SELECT * FROM products WHERE id = '3881'
291 0.0007 0.00073003768920898
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
292 0.0007 0.00065493583679199
SELECT * FROM product_image_select WHERE product_id = '3881'
293 0.0004 0.0003960132598877
SELECT * FROM productcustomimages WHERE product_id = '3881'
294 0.0017 0.0017249584197998
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
295 0.0006 0.00064992904663086
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
296 0.0008 0.00083088874816895
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
297 0.0009 0.00087785720825195
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
298 0.0007 0.00074505805969238
SELECT * FROM products WHERE id = '4213'
299 0.0008 0.00079083442687988
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
300 0.0010 0.0010499954223633
SELECT * FROM product_image_select WHERE product_id = '4213'
301 0.0010 0.00096702575683594
SELECT * FROM productcustomimages WHERE product_id = '4213'
302 0.0029 0.0028979778289795
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
303 0.0015 0.0014688968658447
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
304 0.0009 0.00087594985961914
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
305 0.0008 0.00084304809570312
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
306 0.0042 0.0042350292205811
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
307 0.0009 0.00090909004211426
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
308 0.0035 0.003460168838501
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
309 0.0025 0.0024888515472412
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
310 0.0019 0.0019059181213379
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
311 0.0014 0.0013599395751953
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
312 0.0011 0.0011498928070068
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'