How We Use Cookies

A cookie is a small piece of text sent to your browser by a website you visit. It helps the website to remember information about your visit like your preferred language, the contents of your basket and other settings. That can make your next visit easier and the site more useful to you. Cookies play an important role. Without them, using the web would be a much more frustrating experience.

We use cookies for many purposes to help our website improve and to make your experience better. We use them, for example, to count how many visitors we receive to a page. Our privacy policy explains how we protect your privacy in our use of cookies and other information.


Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
0.51567101478577 148 0.0664 0


No Amazon API Requests Made.

Total time 0.51567101478577 seconds

Number Time From Start Name Description
1 0.39246702194214 Initialise Initialise FSB Function
2 0.39414000511169 App Controller Start Start of the App controller (called before the controller of every page)
3 0.39714097976685 Start of getCategoryListByGroup Function Before first category groups query
4 0.39752507209778 After initial query Before first category groups query
5 0.39752793312073 Get Category List for Group Before the call to getCategoryList function
6 0.39753198623657 Start of GetCategoryList function Start of the function
7 0.39753699302673 Before getting categories Query to get specific category list
8 0.3979320526123 After getting categories Query to get specific category list
9 0.39793300628662 Before getting category custom Before call to function getCategoryCustom
10 0.41536593437195 After getting category custom After call to function getCategoryCustom
11 0.41536808013916 Before getting category custom Before call to function getCategoryCustom
12 0.41748809814453 After getting category custom After call to function getCategoryCustom
13 0.41749000549316 Before getting category custom Before call to function getCategoryCustom
14 0.42241501808167 After getting category custom After call to function getCategoryCustom
15 0.42241811752319 Before getting category custom Before call to function getCategoryCustom
16 0.42491507530212 After getting category custom After call to function getCategoryCustom
17 0.42491793632507 Before getting category custom Before call to function getCategoryCustom
18 0.42720794677734 After getting category custom After call to function getCategoryCustom
19 0.42721009254456 Before getting category custom Before call to function getCategoryCustom
20 0.42968893051147 After getting category custom After call to function getCategoryCustom
21 0.429692029953 End of GetCategoryList function End of the function
22 0.4296989440918 End of getCategoryListByGroup Function Before return()
23 0.43473696708679 App Controller End End of the App controller (called before the controller of every page)
24 0.43872499465942 App_after Controller Start Start of the App_after controller (called after the controller of every page)
25 0.43916606903076 Before Get Options Before the call to getOptions in the tpl class
26 0.46278595924377 After Get Options After the call to getOptions in the tpl class
27 0.46282505989075 App_after Controller End End of the App_after controller (called after the controller of every page)
28 0.51565599441528 Finalizing debug Before the debug is output to the page.
29 0.51566910743713 End of App This is the end of the app logging, final timestamp


Query Debug - 148 Database Queries. Total time 0.0664 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0006 0.00058484077453613
SELECT parameter, value FROM parameters
2 0.0008 0.00084495544433594
SELECT * FROM `bad_bots`
3 0.0002 0.00024986267089844
SET time_zone = 'Europe/London'
4 0.0003 0.00029611587524414
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0017 0.0017409324645996
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"3.236.110.106\";}'
6 0.0008 0.00082111358642578
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1627536807'
7 0.0006 0.00057697296142578
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0002 0.00021505355834961
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0004 0.00036191940307617
SELECT id FROM pages WHERE pagename = 'cookie-consent' LIMIT 1
10 0.0004 0.00040102005004883
SELECT * FROM pages WHERE id = 33
11 0.0009 0.00092887878417969
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
12 0.0009 0.00087094306945801
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
13 0.0006 0.00059986114501953
SELECT * FROM pages WHERE pagename = 'cookie-consent'
14 0.0004 0.0003669261932373
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0004 0.00037288665771484
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0092 0.0091919898986816
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.00019502639770508
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.00020408630371094
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0002 0.00019216537475586
SELECT id FROM categories WHERE parent_id = '26'
20 0.0067 0.0066750049591064
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.00022387504577637
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.00019407272338867
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.00024700164794922
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0002 0.00017213821411133
SELECT * FROM categorygroups WHERE id = '1'
25 0.0002 0.00019216537475586
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.00021910667419434
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.0002 0.00016999244689941
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0002 0.00019097328186035
SELECT id FROM categories WHERE parent_id = '27'
29 0.0002 0.00016689300537109
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.0004 0.00035190582275391
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.0004 0.00037884712219238
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.00016903877258301
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0002 0.00017285346984863
SELECT * FROM categorygroups WHERE id = '1'
34 0.0018 0.0018429756164551
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.00020503997802734
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.0001671314239502
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0002 0.00018095970153809
SELECT id FROM categories WHERE parent_id = '28'
38 0.0016 0.0015759468078613
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.00021719932556152
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.00019192695617676
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.0001838207244873
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0002 0.00024604797363281
SELECT * FROM categorygroups WHERE id = '1'
43 0.0005 0.0005490779876709
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.00022292137145996
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.00016307830810547
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0002 0.0002288818359375
SELECT id FROM categories WHERE parent_id = '29'
47 0.0005 0.00050115585327148
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.00019097328186035
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.00019097328186035
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.00017380714416504
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0002 0.00016593933105469
SELECT * FROM categorygroups WHERE id = '1'
52 0.0005 0.00048303604125977
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.00018310546875
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.00016093254089355
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0002 0.00017595291137695
SELECT id FROM categories WHERE parent_id = '30'
56 0.0005 0.0005040168762207
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.0002 0.00019001960754395
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.00016498565673828
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.00015783309936523
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0002 0.00017309188842773
SELECT * FROM categorygroups WHERE id = '1'
61 0.0005 0.00048494338989258
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.00016903877258301
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.0001978874206543
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0002 0.00017714500427246
SELECT id FROM categories WHERE parent_id = '31'
65 0.0005 0.00052595138549805
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.0002 0.00021791458129883
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.00016999244689941
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.00024795532226562
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0002 0.00018191337585449
SELECT * FROM categorygroups WHERE id = '1'
70 0.0003 0.00025391578674316
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
71 0.0002 0.00024604797363281
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
72 0.0002 0.00023889541625977
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.00019288063049316
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
74 0.0005 0.00045919418334961
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
75 0.0006 0.00061798095703125
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
76 0.0002 0.00022387504577637
SELECT * FROM ipgeocountries WHERE INET_ATON('3.236.110.106') >= INET_ATON(ip_start) AND INET_ATON('3.236.110.106') <= INET_ATON(ip_end)
77 0.0002 0.00021100044250488
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
78 0.0002 0.00018882751464844
SELECT * FROM countryredirects WHERE countrycode = 'US'
79 0.0004 0.00040602684020996
SELECT * FROM pages WHERE pagename = 'cookie-consent'
80 0.0003 0.00034689903259277
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
81 0.0002 0.00018596649169922
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
82 0.0002 0.00017380714416504
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
83 0.0003 0.00031590461730957
SELECT * FROM pages WHERE id = 38
84 0.0003 0.00025391578674316
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
85 0.0003 0.00032401084899902
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:1627536807;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:10:\"808|amazon\";i:4;s:10:\"810|amazon\";i:5;s:11:\"4947|amazon\";}}' WHERE id = '160'
86 0.0003 0.00028491020202637
SELECT * FROM products WHERE id = 790
87 0.0004 0.00041103363037109
SELECT * FROM products WHERE id = 788
88 0.0005 0.00054192543029785
SELECT * FROM products WHERE id = 787
89 0.0004 0.0003659725189209
SELECT * FROM products WHERE id = 808
90 0.0003 0.00032997131347656
SELECT * FROM products WHERE id = 810
91 0.0003 0.00034213066101074
SELECT * FROM products WHERE id = 4947
92 0.0003 0.00033211708068848
SELECT * FROM products WHERE id = '790'
93 0.0004 0.0004119873046875
SELECT * FROM productimages WHERE product_id = '790' ORDER BY sortorder ASC
94 0.0004 0.00040578842163086
SELECT * FROM product_image_select WHERE product_id = '790'
95 0.0003 0.00028204917907715
SELECT * FROM productcustomimages WHERE product_id = '790'
96 0.0002 0.00023889541625977
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '790' AND a.name = n.originalname
97 0.0002 0.00022315979003906
SELECT * FROM productoffers WHERE product_id = '790' AND merchantid = 'A1X6FK5RDHNB96'
98 0.0002 0.00021719932556152
SELECT * FROM productoffers
                WHERE product_id = '790' AND price > 0
                ORDER BY price ASC LIMIT 1
99 0.0003 0.00029706954956055
SELECT value FROM productattributes WHERE product_id = '790' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
100 0.0003 0.00028705596923828
SELECT * FROM products WHERE id = '788'
101 0.0002 0.00022506713867188
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
102 0.0002 0.00023198127746582
SELECT * FROM product_image_select WHERE product_id = '788'
103 0.0002 0.00024986267089844
SELECT * FROM productcustomimages WHERE product_id = '788'
104 0.0002 0.00020599365234375
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
105 0.0002 0.00020313262939453
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
106 0.0002 0.00021100044250488
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
107 0.0002 0.0002288818359375
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
108 0.0003 0.00029110908508301
SELECT * FROM products WHERE id = '787'
109 0.0002 0.00019192695617676
SELECT * FROM productimages WHERE product_id = '787' ORDER BY sortorder ASC
110 0.0002 0.00018882751464844
SELECT * FROM product_image_select WHERE product_id = '787'
111 0.0002 0.0001990795135498
SELECT * FROM productcustomimages WHERE product_id = '787'
112 0.0002 0.00023007392883301
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '787' AND a.name = n.originalname
113 0.0002 0.00020599365234375
SELECT * FROM productoffers WHERE product_id = '787' AND merchantid = 'A1X6FK5RDHNB96'
114 0.0002 0.00021791458129883
SELECT * FROM productoffers
                WHERE product_id = '787' AND price > 0
                ORDER BY price ASC LIMIT 1
115 0.0002 0.00020289421081543
SELECT value FROM productattributes WHERE product_id = '787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
116 0.0003 0.0002899169921875
SELECT * FROM products WHERE id = '808'
117 0.0002 0.00020599365234375
SELECT * FROM productimages WHERE product_id = '808' ORDER BY sortorder ASC
118 0.0002 0.00020503997802734
SELECT * FROM product_image_select WHERE product_id = '808'
119 0.0002 0.00020003318786621
SELECT * FROM productcustomimages WHERE product_id = '808'
120 0.0002 0.0002129077911377
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '808' AND a.name = n.originalname
121 0.0003 0.00025486946105957
SELECT * FROM productoffers WHERE product_id = '808' AND merchantid = 'A1X6FK5RDHNB96'
122 0.0003 0.00025010108947754
SELECT * FROM productoffers
                WHERE product_id = '808' AND price > 0
                ORDER BY price ASC LIMIT 1
123 0.0003 0.00029993057250977
SELECT value FROM productattributes WHERE product_id = '808' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
124 0.0003 0.00028419494628906
SELECT * FROM products WHERE id = '810'
125 0.0004 0.00040292739868164
SELECT * FROM productimages WHERE product_id = '810' ORDER BY sortorder ASC
126 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '810'
127 0.0002 0.00024986267089844
SELECT * FROM productcustomimages WHERE product_id = '810'
128 0.0002 0.00022578239440918
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '810' AND a.name = n.originalname
129 0.0002 0.00020313262939453
SELECT * FROM productoffers WHERE product_id = '810' AND merchantid = 'A1X6FK5RDHNB96'
130 0.0002 0.00023508071899414
SELECT * FROM productoffers
                WHERE product_id = '810' AND price > 0
                ORDER BY price ASC LIMIT 1
131 0.0003 0.00031518936157227
SELECT value FROM productattributes WHERE product_id = '810' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
132 0.0003 0.0002899169921875
SELECT * FROM products WHERE id = '4947'
133 0.0006 0.00057005882263184
SELECT * FROM productimages WHERE product_id = '4947' ORDER BY sortorder ASC
134 0.0006 0.00061607360839844
SELECT * FROM product_image_select WHERE product_id = '4947'
135 0.0006 0.00059008598327637
SELECT * FROM productcustomimages WHERE product_id = '4947'
136 0.0003 0.00032806396484375
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4947' AND a.name = n.originalname
137 0.0002 0.00022506713867188
SELECT * FROM productoffers WHERE product_id = '4947' AND merchantid = 'A1X6FK5RDHNB96'
138 0.0003 0.00025200843811035
SELECT * FROM productoffers
                WHERE product_id = '4947' AND price > 0
                ORDER BY price ASC LIMIT 1
139 0.0006 0.00061798095703125
SELECT value FROM productattributes WHERE product_id = '4947' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
140 0.0007 0.00072002410888672
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
141 0.0005 0.00052213668823242
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
142 0.0016 0.0016458034515381
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
143 0.0006 0.00063991546630859
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
144 0.0005 0.00049090385437012
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
145 0.0004 0.00044512748718262
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
146 0.0004 0.00037288665771484
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
147 0.0004 0.0004429817199707
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
148 0.0004 0.00039196014404297
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'