0

Filter Products

Use this page to filter the products to your requirements. Simply select the options below and click filter.

Filter Options

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.4246299266815 150 0.8415 0


No Amazon API Requests Made.


App Debug - Total Time 1.4246299266815 seconds

Number Time From Start Name Description
1 0.43312287330627 Initialise Initialise FSB Function
2 0.43741989135742 App Controller Start Start of the App controller (called before the controller of every page)
3 0.46614599227905 Start of getCategoryListByGroup Function Before first category groups query
4 0.46779894828796 After initial query Before first category groups query
5 0.4678008556366 Get Category List for Group Before the call to getCategoryList function
6 0.46780395507812 Start of GetCategoryList function Start of the function
7 0.46780896186829 Before getting categories Query to get specific category list
8 0.46980500221252 After getting categories Query to get specific category list
9 0.46980690956116 Before getting category custom Before call to function getCategoryCustom
10 0.49445390701294 After getting category custom After call to function getCategoryCustom
11 0.49445986747742 Before getting category custom Before call to function getCategoryCustom
12 0.50733184814453 After getting category custom After call to function getCategoryCustom
13 0.50733685493469 Before getting category custom Before call to function getCategoryCustom
14 0.51407289505005 After getting category custom After call to function getCategoryCustom
15 0.51407599449158 Before getting category custom Before call to function getCategoryCustom
16 0.51898789405823 After getting category custom After call to function getCategoryCustom
17 0.51899194717407 Before getting category custom Before call to function getCategoryCustom
18 0.52402591705322 After getting category custom After call to function getCategoryCustom
19 0.52402997016907 Before getting category custom Before call to function getCategoryCustom
20 0.52879786491394 After getting category custom After call to function getCategoryCustom
21 0.5288028717041 End of GetCategoryList function End of the function
22 0.52881383895874 Get Category List for Group Before the call to getCategoryList function
23 0.52881693840027 Start of GetCategoryList function Start of the function
24 0.52882194519043 Before getting categories Query to get specific category list
25 0.52941489219666 End of getCategoryListByGroup Function Before return()
26 1.1676559448242 App Controller End End of the App controller (called before the controller of every page)
27 1.2124538421631 App_after Controller Start Start of the App_after controller (called after the controller of every page)
28 1.2145028114319 Before Get Options Before the call to getOptions in the tpl class
29 1.2823920249939 After Get Options After the call to getOptions in the tpl class
30 1.2824418544769 App_after Controller End End of the App_after controller (called after the controller of every page)
31 1.4246098995209 Finalizing debug Before the debug is output to the page.
32 1.4246280193329 End of App This is the end of the app logging, final timestamp


Query Debug - 150 Database Queries. Total time 0.8415 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0024 0.0023620128631592
SELECT parameter, value FROM parameters
2 0.0094 0.0093610286712646
SELECT * FROM `bad_bots`
3 0.0007 0.00066304206848145
SET time_zone = 'Europe/London'
4 0.0035 0.0034868717193604
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0038 0.0037980079650879
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:11:\"18.97.14.85\";}'
6 0.0037 0.0037100315093994
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1739267205'
7 0.0026 0.0025949478149414
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0008 0.00080108642578125
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0021 0.0020809173583984
SELECT id FROM pages WHERE pagename = 'filter-products' LIMIT 1
10 0.0006 0.0005500316619873
SELECT * FROM pages WHERE id = 35
11 0.0029 0.0029418468475342
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0245 0.024500846862793
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0007 0.00069093704223633
SELECT * FROM pages WHERE pagename = 'filter-products'
14 0.0016 0.0016350746154785
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0020 0.0019681453704834
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0089 0.0088510513305664
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.0020 0.0019700527191162
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.0016 0.0015521049499512
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0005 0.00052714347839355
SELECT id FROM categories WHERE parent_id = '26'
20 0.0059 0.005925178527832
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.0019 0.001945972442627
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.0017 0.0016939640045166
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.0015 0.0014669895172119
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0005 0.0004880428314209
SELECT * FROM categorygroups WHERE id = '1'
25 0.0046 0.0045850276947021
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
26 0.0006 0.00061416625976562
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.0004 0.00042200088500977
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0005 0.00049519538879395
SELECT id FROM categories WHERE parent_id = '27'
29 0.0042 0.004180908203125
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.0006 0.00056600570678711
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.0007 0.00072193145751953
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.00066208839416504
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0005 0.00047421455383301
SELECT * FROM categorygroups WHERE id = '1'
34 0.0016 0.0016160011291504
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
35 0.0005 0.00050997734069824
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
36 0.0004 0.00040316581726074
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0005 0.00047087669372559
SELECT id FROM categories WHERE parent_id = '28'
38 0.0016 0.0015599727630615
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
39 0.0005 0.00054407119750977
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0 
40 0.0005 0.00053596496582031
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.00053095817565918
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0005 0.00045299530029297
SELECT * FROM categorygroups WHERE id = '1'
43 0.0006 0.0006101131439209
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.00046992301940918
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.00039100646972656
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0004 0.0004429817199707
SELECT id FROM categories WHERE parent_id = '29'
47 0.0008 0.00079488754272461
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.00059390068054199
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.00061202049255371
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.00049591064453125
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0004 0.0003960132598877
SELECT * FROM categorygroups WHERE id = '1'
52 0.0007 0.00067281723022461
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.00049686431884766
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.0004 0.00044393539428711
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0005 0.00051712989807129
SELECT id FROM categories WHERE parent_id = '30'
56 0.0007 0.0007319450378418
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
57 0.0006 0.00057506561279297
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.0005 0.00051999092102051
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
59 0.0005 0.00052094459533691
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0005 0.00045204162597656
SELECT * FROM categorygroups WHERE id = '1'
61 0.0006 0.00059413909912109
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.00047898292541504
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.00040102005004883
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0005 0.00046896934509277
SELECT id FROM categories WHERE parent_id = '31'
65 0.0007 0.00069403648376465
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.0005 0.00048208236694336
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
67 0.0005 0.00053191184997559
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
68 0.0005 0.00048398971557617
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0005 0.00052189826965332
SELECT * FROM categorygroups WHERE id = '1'
70 0.0006 0.00057482719421387
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0029 0.0029239654541016
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0033 0.0033390522003174
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0006 0.00059390068054199
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
74 0.0013 0.0012919902801514
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0013 0.001276969909668
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0012 0.0012340545654297
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.6214 0.62144804000854
SELECT * FROM ipgeocountries WHERE INET_ATON('18.97.14.85') >= INET_ATON(ip_start) AND INET_ATON('18.97.14.85') <= INET_ATON(ip_end)
78 0.0021 0.0020599365234375
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0014 0.0014050006866455
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0021 0.002112865447998
SELECT * FROM pages WHERE pagename = 'filter-products'
81 0.0095 0.0094649791717529
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
82 0.0029 0.0029079914093018
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
83 0.0022 0.0021591186523438
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
84 0.0025 0.0025110244750977
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
85 0.0015 0.0015430450439453
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
86 0.0004 0.00040102005004883
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
87 0.0147 0.014683961868286
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
88 0.0016 0.0015921592712402
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
89 0.0020 0.0019888877868652
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
90 0.0006 0.00061392784118652
SELECT * FROM products WHERE id = 1626
91 0.0006 0.00057482719421387
SELECT * FROM products WHERE id = 4041
92 0.0005 0.00052213668823242
SELECT * FROM products WHERE id = 4312
93 0.0004 0.00044107437133789
SELECT * FROM products WHERE id = 777
94 0.0006 0.00055313110351562
SELECT * FROM products WHERE id = 3881
95 0.0008 0.00079894065856934
SELECT * FROM products WHERE id = 4213
96 0.0005 0.00049901008605957
SELECT * FROM products WHERE id = '1626'
97 0.0005 0.00049901008605957
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
98 0.0015 0.0014541149139404
SELECT * FROM product_image_select WHERE product_id = '1626'
99 0.0005 0.00047183036804199
SELECT * FROM productcustomimages WHERE product_id = '1626'
100 0.0015 0.0015480518341064
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
101 0.0009 0.00093889236450195
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
102 0.0004 0.00044417381286621
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
103 0.0005 0.00050616264343262
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
104 0.0009 0.00086593627929688
SELECT * FROM products WHERE id = '4041'
105 0.0015 0.0015320777893066
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
106 0.0013 0.0013129711151123
SELECT * FROM product_image_select WHERE product_id = '4041'
107 0.0013 0.0013020038604736
SELECT * FROM productcustomimages WHERE product_id = '4041'
108 0.0022 0.0022358894348145
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
109 0.0006 0.0005958080291748
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
110 0.0005 0.00045990943908691
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
111 0.0005 0.00047898292541504
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
112 0.0006 0.00061798095703125
SELECT * FROM products WHERE id = '4312'
113 0.0005 0.00047612190246582
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
114 0.0006 0.00058698654174805
SELECT * FROM product_image_select WHERE product_id = '4312'
115 0.0004 0.00040197372436523
SELECT * FROM productcustomimages WHERE product_id = '4312'
116 0.0011 0.0010738372802734
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
117 0.0005 0.0004889965057373
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
118 0.0004 0.0004420280456543
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
119 0.0004 0.00041985511779785
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
120 0.0005 0.00053215026855469
SELECT * FROM products WHERE id = '777'
121 0.0005 0.00049209594726562
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
122 0.0006 0.00059390068054199
SELECT * FROM product_image_select WHERE product_id = '777'
123 0.0004 0.00042009353637695
SELECT * FROM productcustomimages WHERE product_id = '777'
124 0.0011 0.001072883605957
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
125 0.0005 0.00049495697021484
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
126 0.0005 0.00046706199645996
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
127 0.0005 0.00046992301940918
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
128 0.0008 0.00082302093505859
SELECT * FROM products WHERE id = '3881'
129 0.0007 0.00071096420288086
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
130 0.0006 0.00057101249694824
SELECT * FROM product_image_select WHERE product_id = '3881'
131 0.0004 0.00040793418884277
SELECT * FROM productcustomimages WHERE product_id = '3881'
132 0.0011 0.0011041164398193
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
133 0.0005 0.00051498413085938
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
134 0.0004 0.00040912628173828
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
135 0.0004 0.00042891502380371
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
136 0.0006 0.00055694580078125
SELECT * FROM products WHERE id = '4213'
137 0.0007 0.00069618225097656
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
138 0.0006 0.00056600570678711
SELECT * FROM product_image_select WHERE product_id = '4213'
139 0.0005 0.00045394897460938
SELECT * FROM productcustomimages WHERE product_id = '4213'
140 0.0011 0.0011169910430908
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
141 0.0005 0.00048303604125977
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
142 0.0005 0.00045108795166016
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
143 0.0005 0.00047588348388672
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
144 0.0021 0.0020921230316162
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
145 0.0007 0.00072097778320312
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
146 0.0025 0.0025219917297363
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
147 0.0017 0.0016908645629883
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
148 0.0007 0.00074005126953125
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
149 0.0007 0.00073814392089844
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
150 0.0007 0.0007011890411377
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'