Filter Products

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


Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
2.0664780139923 151 0.0734 0


No Amazon API Requests Made.

Total time 2.0664780139923 seconds

Number Time From Start Name Description
1 0.80928683280945 Initialise Initialise FSB Function
2 0.81161499023438 App Controller Start Start of the App controller (called before the controller of every page)
3 0.81428980827332 Start of getCategoryListByGroup Function Before first category groups query
4 0.8146288394928 After initial query Before first category groups query
5 0.81463003158569 Get Category List for Group Before the call to getCategoryList function
6 0.81463384628296 Start of GetCategoryList function Start of the function
7 0.8146378993988 Before getting categories Query to get specific category list
8 0.81494283676147 After getting categories Query to get specific category list
9 0.81494402885437 Before getting category custom Before call to function getCategoryCustom
10 0.81673002243042 After getting category custom After call to function getCategoryCustom
11 0.81673288345337 Before getting category custom Before call to function getCategoryCustom
12 0.82873797416687 After getting category custom After call to function getCategoryCustom
13 0.82874202728271 Before getting category custom Before call to function getCategoryCustom
14 0.83381104469299 After getting category custom After call to function getCategoryCustom
15 0.83381390571594 Before getting category custom Before call to function getCategoryCustom
16 0.83654999732971 After getting category custom After call to function getCategoryCustom
17 0.83655190467834 Before getting category custom Before call to function getCategoryCustom
18 0.84033989906311 After getting category custom After call to function getCategoryCustom
19 0.84034204483032 Before getting category custom Before call to function getCategoryCustom
20 0.84379887580872 After getting category custom After call to function getCategoryCustom
21 0.84380197525024 End of GetCategoryList function End of the function
22 0.84380888938904 End of getCategoryListByGroup Function Before return()
23 0.87876081466675 App Controller End End of the App controller (called before the controller of every page)
24 1.0660529136658 App_after Controller Start Start of the App_after controller (called after the controller of every page)
25 1.0665838718414 Before Get Options Before the call to getOptions in the tpl class
26 1.1670370101929 After Get Options After the call to getOptions in the tpl class
27 1.1671028137207 App_after Controller End End of the App_after controller (called after the controller of every page)
28 2.0664539337158 Finalizing debug Before the debug is output to the page.
29 2.0664758682251 End of App This is the end of the app logging, final timestamp


Query Debug - 151 Database Queries. Total time 0.0734 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0007 0.0006711483001709
SELECT parameter, value FROM parameters
2 0.0008 0.00084686279296875
SELECT * FROM `bad_bots`
3 0.0002 0.00022602081298828
SET time_zone = 'Europe/London'
4 0.0003 0.00032305717468262
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0023 0.0023059844970703
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"18.205.192.201\";}'
6 0.0014 0.0013809204101562
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1628129260'
7 0.0004 0.00037097930908203
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0002 0.00020503997802734
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0007 0.00072097778320312
SELECT id FROM pages WHERE pagename = 'filter-products' LIMIT 1
10 0.0006 0.00063300132751465
SELECT * FROM pages WHERE id = 35
11 0.0010 0.0009770393371582
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
12 0.0007 0.00072598457336426
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
13 0.0004 0.00039196014404297
SELECT * FROM pages WHERE pagename = 'filter-products'
14 0.0003 0.00032591819763184
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0003 0.00028586387634277
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0002 0.0002138614654541
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.0002 0.00018405914306641
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.0002 0.0001678466796875
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0002 0.00019407272338867
SELECT id FROM categories WHERE parent_id = '26'
20 0.0002 0.00018906593322754
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.0002 0.00017619132995605
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.0002 0.00017309188842773
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.0002 0.00020098686218262
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0002 0.00017285346984863
SELECT * FROM categorygroups WHERE id = '1'
25 0.0048 0.0047898292541504
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.0002 0.00017309188842773
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.0003 0.00027203559875488
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0002 0.00015592575073242
SELECT id FROM categories WHERE parent_id = '27'
29 0.0050 0.0049571990966797
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.0002 0.00020384788513184
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.00093483924865723
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.0002 0.00016999244689941
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0002 0.00017619132995605
SELECT * FROM categorygroups WHERE id = '1'
34 0.0019 0.0018818378448486
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.0002 0.00021100044250488
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.0002 0.00016093254089355
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0002 0.0001671314239502
SELECT id FROM categories WHERE parent_id = '28'
38 0.0017 0.0017170906066895
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.0002 0.00019407272338867
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.0002 0.00024604797363281
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.0002 0.00018620491027832
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0002 0.00018787384033203
SELECT * FROM categorygroups WHERE id = '1'
43 0.0008 0.00080609321594238
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.0002 0.00021600723266602
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.0002 0.00021505355834961
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0002 0.00018811225891113
SELECT id FROM categories WHERE parent_id = '29'
47 0.0005 0.00053501129150391
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.0002 0.00016880035400391
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.0002 0.0001981258392334
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.0002 0.00016093254089355
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0002 0.00015807151794434
SELECT * FROM categorygroups WHERE id = '1'
52 0.0005 0.0005040168762207
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.0002 0.00016093254089355
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.0002 0.00015115737915039
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0002 0.00015616416931152
SELECT id FROM categories WHERE parent_id = '30'
56 0.0014 0.0014221668243408
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.0008 0.00081515312194824
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.0002 0.0001678466796875
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.0002 0.00016307830810547
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0002 0.00015687942504883
SELECT * FROM categorygroups WHERE id = '1'
61 0.0006 0.00064897537231445
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.0002 0.00017213821411133
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.0002 0.0001518726348877
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0002 0.00015878677368164
SELECT id FROM categories WHERE parent_id = '31'
65 0.0011 0.0011448860168457
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.00052094459533691
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.0002 0.00021600723266602
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.0002 0.00017213821411133
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0002 0.00015997886657715
SELECT * FROM categorygroups WHERE id = '1'
70 0.0002 0.00018191337585449
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
71 0.0002 0.00024318695068359
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
72 0.0004 0.00043606758117676
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
73 0.0002 0.00020194053649902
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
74 0.0022 0.0021519660949707
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
75 0.0005 0.00052690505981445
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
76 0.0002 0.00020909309387207
SELECT * FROM ipgeocountries WHERE INET_ATON('18.205.192.201') >= INET_ATON(ip_start) AND INET_ATON('18.205.192.201') <= INET_ATON(ip_end)
77 0.0003 0.00026512145996094
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
78 0.0002 0.00020790100097656
SELECT * FROM countryredirects WHERE countrycode = 'US'
79 0.0003 0.00033998489379883
SELECT * FROM pages WHERE pagename = 'filter-products'
80 0.0090 0.0090081691741943
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
81 0.0002 0.00023794174194336
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
82 0.0002 0.0001978874206543
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
83 0.0002 0.00023913383483887
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
84 0.0003 0.00025296211242676
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
85 0.0002 0.00017905235290527
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
86 0.0002 0.00021982192993164
SELECT * FROM pages WHERE id = 38
87 0.0002 0.00018906593322754
SELECT DISTINCT p.id FROM products p, productoffers o
            WHERE p.id IN (SELECT product_id FROM productoffers WHERE 1 ) OR p.parent_id IN (SELECT product_id FROM productoffers WHERE 1 ) AND p.parent_id = 0 LIMIT 6
88 0.0004 0.00036191940307617
UPDATE template_options SET value = 'a:10:{s:14:\"populationtype\";s:9:\"automatic\";s:12:\"productcount\";s:1:\"6\";s:12:\"maxsalesrank\";s:0:\"\";s:8:\"minprice\";s:1:\"0\";s:8:\"maxprice\";s:1:\"0\";s:9:\"minimages\";s:0:\"\";s:10:\"updatetime\";s:1:\"0\";s:13:\"selectiontype\";s:6:\"random\";s:11:\"lastupdated\";i:1628129261;s:8:\"products\";a:6:{i:0;s:10:\"790|amazon\";i:1;s:10:\"788|amazon\";i:2;s:10:\"787|amazon\";i:3;s:11:\"1287|amazon\";i:4;s:10:\"777|amazon\";i:5;s:10:\"776|amazon\";}}' WHERE id = '160'
89 0.0003 0.00032615661621094
SELECT * FROM products WHERE id = 790
90 0.0004 0.00042200088500977
SELECT * FROM products WHERE id = 788
91 0.0005 0.00052595138549805
SELECT * FROM products WHERE id = 787
92 0.0004 0.00040984153747559
SELECT * FROM products WHERE id = 1287
93 0.0004 0.00040197372436523
SELECT * FROM products WHERE id = 777
94 0.0004 0.0004119873046875
SELECT * FROM products WHERE id = 776
95 0.0004 0.00042891502380371
SELECT * FROM products WHERE id = '790'
96 0.0004 0.00039505958557129
SELECT * FROM productimages WHERE product_id = '790' ORDER BY sortorder ASC
97 0.0002 0.00019192695617676
SELECT * FROM product_image_select WHERE product_id = '790'
98 0.0002 0.00020599365234375
SELECT * FROM productcustomimages WHERE product_id = '790'
99 0.0002 0.0002138614654541
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '790' AND a.name = n.originalname
100 0.0002 0.00020313262939453
SELECT * FROM productoffers WHERE product_id = '790' AND merchantid = 'A1X6FK5RDHNB96'
101 0.0002 0.00023698806762695
SELECT * FROM productoffers
                WHERE product_id = '790' AND price > 0
                ORDER BY price ASC LIMIT 1
102 0.0003 0.00028014183044434
SELECT value FROM productattributes WHERE product_id = '790' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
103 0.0003 0.00029110908508301
SELECT * FROM products WHERE id = '788'
104 0.0002 0.00021195411682129
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
105 0.0002 0.00023794174194336
SELECT * FROM product_image_select WHERE product_id = '788'
106 0.0002 0.00020289421081543
SELECT * FROM productcustomimages WHERE product_id = '788'
107 0.0002 0.00019407272338867
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
108 0.0002 0.00020289421081543
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
109 0.0002 0.0002140998840332
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
110 0.0002 0.00020694732666016
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
111 0.0003 0.00029492378234863
SELECT * FROM products WHERE id = '787'
112 0.0002 0.00019288063049316
SELECT * FROM productimages WHERE product_id = '787' ORDER BY sortorder ASC
113 0.0002 0.00021195411682129
SELECT * FROM product_image_select WHERE product_id = '787'
114 0.0002 0.00020480155944824
SELECT * FROM productcustomimages WHERE product_id = '787'
115 0.0003 0.00030088424682617
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '787' AND a.name = n.originalname
116 0.0003 0.00025486946105957
SELECT * FROM productoffers WHERE product_id = '787' AND merchantid = 'A1X6FK5RDHNB96'
117 0.0002 0.0002138614654541
SELECT * FROM productoffers
                WHERE product_id = '787' AND price > 0
                ORDER BY price ASC LIMIT 1
118 0.0002 0.0001828670501709
SELECT value FROM productattributes WHERE product_id = '787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
119 0.0003 0.00029301643371582
SELECT * FROM products WHERE id = '1287'
120 0.0004 0.0003969669342041
SELECT * FROM productimages WHERE product_id = '1287' ORDER BY sortorder ASC
121 0.0002 0.00018596649169922
SELECT * FROM product_image_select WHERE product_id = '1287'
122 0.0002 0.00020289421081543
SELECT * FROM productcustomimages WHERE product_id = '1287'
123 0.0003 0.00027084350585938
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1287' AND a.name = n.originalname
124 0.0003 0.00026893615722656
SELECT * FROM productoffers WHERE product_id = '1287' AND merchantid = 'A1X6FK5RDHNB96'
125 0.0002 0.00021719932556152
SELECT * FROM productoffers
                WHERE product_id = '1287' AND price > 0
                ORDER BY price ASC LIMIT 1
126 0.0003 0.00031685829162598
SELECT value FROM productattributes WHERE product_id = '1287' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
127 0.0003 0.00032687187194824
SELECT * FROM products WHERE id = '777'
128 0.0002 0.00019288063049316
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
129 0.0002 0.00022506713867188
SELECT * FROM product_image_select WHERE product_id = '777'
130 0.0002 0.00019383430480957
SELECT * FROM productcustomimages WHERE product_id = '777'
131 0.0002 0.0002448558807373
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
132 0.0002 0.00021600723266602
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
133 0.0003 0.00026702880859375
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
134 0.0003 0.00030684471130371
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
135 0.0004 0.00035405158996582
SELECT * FROM products WHERE id = '776'
136 0.0002 0.00021696090698242
SELECT * FROM productimages WHERE product_id = '776' ORDER BY sortorder ASC
137 0.0002 0.00023794174194336
SELECT * FROM product_image_select WHERE product_id = '776'
138 0.0002 0.00022101402282715
SELECT * FROM productcustomimages WHERE product_id = '776'
139 0.0003 0.00026512145996094
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '776' AND a.name = n.originalname
140 0.0002 0.00020718574523926
SELECT * FROM productoffers WHERE product_id = '776' AND merchantid = 'A1X6FK5RDHNB96'
141 0.0003 0.00025701522827148
SELECT * FROM productoffers
                WHERE product_id = '776' AND price > 0
                ORDER BY price ASC LIMIT 1
142 0.0002 0.00019001960754395
SELECT value FROM productattributes WHERE product_id = '776' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
143 0.0004 0.00037384033203125
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
144 0.0003 0.0003359317779541
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
145 0.0010 0.00097107887268066
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
146 0.0006 0.00058197975158691
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
147 0.0005 0.00049614906311035
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
148 0.0006 0.00060486793518066
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
149 0.0006 0.0005648136138916
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
150 0.0004 0.00040817260742188
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
151 0.0005 0.00050091743469238
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'