Chocolats Chauds


Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
0.94631505012512 341 0.1923 0


No Amazon API Requests Made.

Total time 0.94631505012512 seconds

Number Time From Start Name Description
1 0.66513800621033 Initialise Initialise FSB Function
2 0.66969203948975 App Controller Start Start of the App controller (called before the controller of every page)
3 0.67930722236633 App Controller End End of the App controller (called before the controller of every page)
4 0.67987012863159 Category Start Start of the category controller
5 0.67987322807312 Before Get Category Before getting the category information
6 0.68907308578491 After Get Category After getting the category information
7 0.68907499313354 Before Get Category List Before getting the updated category list
8 0.68932914733887 Start of getCategoryListByGroup Function Before first category groups query
9 0.68958306312561 After initial query Before first category groups query
10 0.68958520889282 Get Category List for Group Before the call to getCategoryList function
11 0.68958806991577 Start of GetCategoryList function Start of the function
12 0.68959021568298 Before getting categories Query to get specific category list
13 0.68988013267517 After getting categories Query to get specific category list
14 0.6898820400238 Before getting category custom Before call to function getCategoryCustom
15 0.70634007453918 After getting category custom After call to function getCategoryCustom
16 0.70634412765503 Before getting category custom Before call to function getCategoryCustom
17 0.71755313873291 After getting category custom After call to function getCategoryCustom
18 0.71755599975586 Before getting category custom Before call to function getCategoryCustom
19 0.72284412384033 After getting category custom After call to function getCategoryCustom
20 0.72284722328186 Before getting category custom Before call to function getCategoryCustom
21 0.72581315040588 After getting category custom After call to function getCategoryCustom
22 0.72581505775452 Before getting category custom Before call to function getCategoryCustom
23 0.7285680770874 After getting category custom After call to function getCategoryCustom
24 0.72857022285461 Before getting category custom Before call to function getCategoryCustom
25 0.73059010505676 After getting category custom After call to function getCategoryCustom
26 0.73059105873108 Before getting sub category list Before call to recursive function getCategoryList
27 0.73059415817261 Start of GetCategoryList function Start of the function
28 0.73059606552124 Before getting categories Query to get specific category list
29 0.73085999488831 After getting sub category list After call to recursive function getCategoryList
30 0.73086214065552 End of GetCategoryList function End of the function
31 0.73086810112 End of getCategoryListByGroup Function Before return()
32 0.73087120056152 After Get Category List After getting the updated category list
33 0.73087215423584 Before Category Images Before getting the category images
34 0.73112106323242 After Category Images After getting the category images
35 0.73142719268799 Before Sub Category Check Before checking for sub category or products category
36 0.73182821273804 Before Category Products Controller Before loading the category products controller
37 0.73273420333862 Start Category Products Start of Category Products Controller
38 0.73275303840637 After Pagination Options After pagination options in Category Products Controller
39 0.73351407051086 After Cache After Cache checking in Category Products Controller
40 0.74238610267639 After Filter Options After getting filter options and SQL in Category Products Controller
41 0.74352312088013 After Counting Products After counting products in the Category Products Controller
42 0.74410104751587 After Counting Bundles After counting bundles in the Category Products Controller
43 0.7445011138916 After Counting Products After counting products in the Category Products Controller
44 0.74640202522278 After Getting Products After getting products and bundles in the Category Products Controller
45 0.74643707275391 After Pagination Links After getting pagination listing links in the Category Products Controller
46 0.74643921852112 After Getting Bundle Details After getting full details for the bundles in the Category Products Controller
47 0.82492303848267 After Getting Product Details After getting full product details in the Category Products Controller
48 0.83157801628113 After Getting Product/Bundle Reviews After getting full product/bundle customer review in the Category Products Controller
49 0.83317708969116 App_after Controller Start Start of the App_after controller (called after the controller of every page)
50 0.83388614654541 Before Get Options Before the call to getOptions in the tpl class
51 0.86251211166382 After Get Options After the call to getOptions in the tpl class
52 0.86266613006592 App_after Controller End End of the App_after controller (called after the controller of every page)
53 0.86269021034241 Before Smarty Before passing everything over to Smarty in the Category Products Controller
54 0.94629502296448 After Loading sub/product controller After checking for sub category or products category and then loading the relevant controller
55 0.94630122184753 Finalizing debug Before the debug is output to the page.
56 0.94631314277649 End of App This is the end of the app logging, final timestamp


Query Debug - 341 Database Queries. Total time 0.1923 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0006 0.00064396858215332
SELECT parameter, value FROM parameters
2 0.0011 0.0010759830474854
SELECT * FROM `bad_bots`
3 0.0005 0.00045299530029297
SET time_zone = 'Europe/London'
4 0.0005 0.00048303604125977
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0020 0.0019619464874268
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"3.238.180.255\";}'
6 0.0015 0.001533031463623
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1653090956'
7 0.0007 0.00070405006408691
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0004 0.00042891502380371
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0006 0.00064992904663086
SELECT id FROM pages WHERE pagename = 'chocolats-chauds' LIMIT 1
10 0.0007 0.00069499015808105
SELECT id FROM products WHERE pagename = 'chocolats-chauds' AND hidden = 0 LIMIT 1
11 0.0006 0.0005948543548584
SELECT id FROM ebay_products WHERE pagename = 'chocolats-chauds'
12 0.0009 0.0008699893951416
SELECT id FROM custom_products WHERE pagename = 'chocolats-chauds'
13 0.0008 0.0007779598236084
SELECT id FROM categories WHERE pagename = 'chocolats-chauds' LIMIT 1
14 0.0013 0.001276969909668
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
15 0.0008 0.00084304809570312
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
16 0.0006 0.00063300132751465
SELECT * FROM pages WHERE pagename = 'chocolats-chauds'
17 0.0003 0.00032901763916016
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
18 0.0003 0.00033402442932129
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
19 0.0005 0.00048089027404785
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
20 0.0003 0.00030994415283203
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
21 0.0010 0.0009760856628418
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
22 0.0007 0.00068402290344238
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
23 0.0004 0.00040006637573242
SELECT * FROM ipgeocountries WHERE INET_ATON('3.238.180.255') >= INET_ATON(ip_start) AND INET_ATON('3.238.180.255') <= INET_ATON(ip_end)
24 0.0004 0.00041604042053223
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
25 0.0003 0.00028300285339355
SELECT * FROM countryredirects WHERE countrycode = 'US'
26 0.0017 0.0016632080078125
SELECT * FROM categories WHERE pagename = 'chocolats-chauds'
27 0.0011 0.0011069774627686
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
28 0.0004 0.0004119873046875
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
29 0.0003 0.00027298927307129
SELECT id FROM categories WHERE parent_id = '31'
30 0.0009 0.00086688995361328
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 
31 0.0003 0.00028085708618164
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 
32 0.0004 0.00042200088500977
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
33 0.0004 0.00035500526428223
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
34 0.0003 0.00025105476379395
SELECT id FROM categories WHERE parent_id = '31'
35 0.0011 0.0010819435119629
SELECT p.id FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (31) AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
36 0.0003 0.00032711029052734
SELECT * FROM productimages WHERE product_id = '4950' ORDER BY sortorder ASC
37 0.0006 0.00064206123352051
SELECT * FROM categoryimages WHERE category_id = 31
38 0.0003 0.00026988983154297
SELECT * FROM categorygroups WHERE id = '1'
39 0.0008 0.00076699256896973
SELECT MIN(p.price) as minprice, MAX(p.price) as maxprice
		FROM products p, products_categories c
		WHERE p.id = c.product_id
		  AND c.category_id = '31'
		  AND p.offers > 0
		  AND p.hidden = 0
		  AND p.enabled = 1
		  AND p.parent = 0
		  AND p.price > 0
40 0.0003 0.00026202201843262
SELECT parent_id FROM categories WHERE id = '31'
41 0.0002 0.00024104118347168
SELECT parent_id FROM categories WHERE id = '31'
42 0.0002 0.00024199485778809
SELECT * FROM categorygroups ORDER BY sortorder ASC
43 0.0003 0.00027012825012207
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
44 0.0070 0.0069708824157715
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
45 0.0005 0.00049591064453125
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
46 0.0003 0.00029110908508301
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
47 0.0002 0.00023984909057617
SELECT id FROM categories WHERE parent_id = '26'
48 0.0068 0.0067679882049561
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 
49 0.0004 0.0003960132598877
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 
50 0.0004 0.00037407875061035
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
51 0.0004 0.00042605400085449
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
52 0.0004 0.00035810470581055
SELECT * FROM categorygroups WHERE id = '1'
53 0.0047 0.0046718120574951
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
54 0.0003 0.00030994415283203
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
55 0.0003 0.00025796890258789
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
56 0.0002 0.00022101402282715
SELECT id FROM categories WHERE parent_id = '27'
57 0.0047 0.0047159194946289
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 
58 0.0002 0.00024294853210449
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 
59 0.0002 0.00022792816162109
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
60 0.0002 0.0002281665802002
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
61 0.0002 0.00022101402282715
SELECT * FROM categorygroups WHERE id = '1'
62 0.0016 0.0016489028930664
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
63 0.0003 0.00025415420532227
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
64 0.0002 0.00023913383483887
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
65 0.0002 0.00023102760314941
SELECT id FROM categories WHERE parent_id = '28'
66 0.0018 0.0017719268798828
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 
67 0.0003 0.00026392936706543
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 
68 0.0003 0.00031113624572754
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
69 0.0002 0.00024700164794922
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
70 0.0002 0.00022101402282715
SELECT * FROM categorygroups WHERE id = '1'
71 0.0006 0.00060296058654785
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
72 0.0003 0.00026297569274902
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
73 0.0002 0.00024104118347168
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
74 0.0002 0.00021791458129883
SELECT id FROM categories WHERE parent_id = '29'
75 0.0006 0.00061607360839844
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 
76 0.0002 0.00024986267089844
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 
77 0.0002 0.00024104118347168
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
78 0.0002 0.00022101402282715
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
79 0.0002 0.00021600723266602
SELECT * FROM categorygroups WHERE id = '1'
80 0.0006 0.0005638599395752
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
81 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 = 30
82 0.0002 0.00022387504577637
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
83 0.0002 0.00021004676818848
SELECT id FROM categories WHERE parent_id = '30'
84 0.0006 0.00056004524230957
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 
85 0.0002 0.00022006034851074
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 
86 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 (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
87 0.0002 0.00022697448730469
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
88 0.0002 0.00022196769714355
SELECT * FROM categorygroups WHERE id = '1'
89 0.0002 0.0002288818359375
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
90 0.0002 0.0002140998840332
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
91 0.0002 0.00020408630371094
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
92 0.0002 0.00022101402282715
SELECT id FROM categories WHERE parent_id = '31'
93 0.0002 0.0002140998840332
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 
94 0.0002 0.00021004676818848
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 
95 0.0002 0.00021004676818848
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
96 0.0002 0.0002131462097168
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
97 0.0002 0.00022506713867188
SELECT * FROM categorygroups WHERE id = '1'
98 0.0003 0.00025296211242676
SELECT * FROM categories WHERE parent_id = '31'  AND hidden = 0 ORDER BY sortorder ASC
99 0.0002 0.00023913383483887
SELECT * FROM categoryimages WHERE category_id = 31
100 0.0003 0.00026798248291016
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
101 0.0004 0.00039005279541016
SELECT * FROM categories WHERE parent_id = '31'
102 0.0069 0.0069260597229004
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
103 0.0004 0.00040292739868164
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
104 0.0004 0.00038313865661621
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
105 0.0002 0.00022792816162109
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
106 0.0004 0.00039815902709961
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
107 0.0003 0.00025391578674316
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
108 0.0007 0.00069880485534668
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
		WHERE p.id = c.product_id AND parent_id = 0
		AND c.category_id = 31
		AND (c.prod_type = '' OR c.prod_type = 'amz')
		AND hidden = 0
		AND enabled = 1
		
		AND 1 = 1
109 0.0004 0.00040507316589355
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
		WHERE ep.id = c.product_id
		AND c.category_id = 31
		AND c.prod_type = 'ebay'
		AND hide = 0
110 0.0006 0.00055980682373047
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
			WHERE p.id = c.bundle_id AND parent_id = 0
			AND c.category_id = 31
			AND p.disabled = 0
			
			AND 1 = 1
111 0.0004 0.00038695335388184
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
		WHERE cp.id = c.product_id
		AND c.category_id = 31
		AND c.prod_type = 'custom'
		AND hide = 0
112 0.0019 0.0018551349639893
SELECT DISTINCT (p.id), IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank, p.price, p.linktitle, p.pagename, 'product' AS type FROM products p, products_categories c
			WHERE p.id = c.product_id
			AND p.parent_id = 0
			AND c.category_id = 31
			AND hidden = 0
			AND enabled = 1
			
			AND 1 = 1 UNION SELECT DISTINCT (p.id), IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank, p.price, p.linktitle, p.pagename, 'ebay' AS type FROM ebay_products p, products_categories c
		WHERE p.id = c.product_id
		AND c.category_id = 31
		AND c.prod_type = 'ebay'
		AND p.hide = 0 UNION SELECT DISTINCT (p.id), IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank, p.price, p.linktitle, p.pagename, 'custom' AS type FROM custom_products p, products_categories c
		WHERE p.id = c.product_id
		AND c.category_id = 31
		AND c.prod_type = 'custom'
		AND p.hide = 0 UNION SELECT DISTINCT (p.id), IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank, p.price, p.linktitle, p.pagename, 'bundle' AS type FROM bundles p, bundle_categories c
			WHERE p.id = c.bundle_id
			AND c.category_id = 31
			AND disabled = 0
			
			AND 1 = 1 ORDER BY salesrank ASC LIMIT 0, 18
113 0.0005 0.00048494338989258
SELECT * FROM products WHERE id = '4950'
114 0.0003 0.00026202201843262
SELECT * FROM productimages WHERE product_id = '4950' ORDER BY sortorder ASC
115 0.0002 0.00023698806762695
SELECT * FROM product_image_select WHERE product_id = '4950'
116 0.0002 0.00023889541625977
SELECT * FROM productcustomimages WHERE product_id = '4950'
117 0.0011 0.0011169910430908
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4950' AND a.name = n.originalname
118 0.0004 0.00043892860412598
SELECT * FROM productoffers WHERE product_id = '4950' AND merchantid = 'A1X6FK5RDHNB96'
119 0.0005 0.00049495697021484
SELECT * FROM productoffers
                WHERE product_id = '4950' AND price > 0
                ORDER BY price ASC LIMIT 1
120 0.0005 0.00049400329589844
SELECT value FROM productattributes WHERE product_id = '4950' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
121 0.0008 0.00079989433288574
SELECT * FROM products WHERE id = '4953'
122 0.0003 0.0002598762512207
SELECT * FROM productimages WHERE product_id = '4953' ORDER BY sortorder ASC
123 0.0002 0.00023484230041504
SELECT * FROM product_image_select WHERE product_id = '4953'
124 0.0002 0.00023102760314941
SELECT * FROM productcustomimages WHERE product_id = '4953'
125 0.0009 0.00092315673828125
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4953' AND a.name = n.originalname
126 0.0004 0.00042486190795898
SELECT * FROM productoffers WHERE product_id = '4953' AND merchantid = 'A1X6FK5RDHNB96'
127 0.0005 0.00049495697021484
SELECT * FROM productoffers
                WHERE product_id = '4953' AND price > 0
                ORDER BY price ASC LIMIT 1
128 0.0005 0.00046205520629883
SELECT value FROM productattributes WHERE product_id = '4953' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
129 0.0005 0.00051999092102051
SELECT * FROM products WHERE id = '4939'
130 0.0003 0.00025796890258789
SELECT * FROM productimages WHERE product_id = '4939' ORDER BY sortorder ASC
131 0.0002 0.00023388862609863
SELECT * FROM product_image_select WHERE product_id = '4939'
132 0.0003 0.0003049373626709
SELECT * FROM productcustomimages WHERE product_id = '4939'
133 0.0009 0.00092411041259766
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4939' AND a.name = n.originalname
134 0.0005 0.00050497055053711
SELECT * FROM productoffers WHERE product_id = '4939' AND merchantid = 'A1X6FK5RDHNB96'
135 0.0005 0.00046515464782715
SELECT * FROM productoffers
                WHERE product_id = '4939' AND price > 0
                ORDER BY price ASC LIMIT 1
136 0.0005 0.00046110153198242
SELECT value FROM productattributes WHERE product_id = '4939' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
137 0.0012 0.0011651515960693
UPDATE products SET price = '3755' WHERE id = '4939'
138 0.0005 0.00051116943359375
SELECT * FROM products WHERE id = '4948'
139 0.0003 0.00031304359436035
SELECT * FROM productimages WHERE product_id = '4948' ORDER BY sortorder ASC
140 0.0002 0.00023913383483887
SELECT * FROM product_image_select WHERE product_id = '4948'
141 0.0002 0.00023317337036133
SELECT * FROM productcustomimages WHERE product_id = '4948'
142 0.0009 0.00093793869018555
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4948' AND a.name = n.originalname
143 0.0004 0.00040888786315918
SELECT * FROM productoffers WHERE product_id = '4948' AND merchantid = 'A1X6FK5RDHNB96'
144 0.0006 0.00061488151550293
SELECT * FROM productoffers
                WHERE product_id = '4948' AND price > 0
                ORDER BY price ASC LIMIT 1
145 0.0004 0.00044798851013184
SELECT value FROM productattributes WHERE product_id = '4948' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
146 0.0005 0.00049090385437012
SELECT * FROM products WHERE id = '4941'
147 0.0003 0.0003211498260498
SELECT * FROM productimages WHERE product_id = '4941' ORDER BY sortorder ASC
148 0.0003 0.00026297569274902
SELECT * FROM product_image_select WHERE product_id = '4941'
149 0.0002 0.00022101402282715
SELECT * FROM productcustomimages WHERE product_id = '4941'
150 0.0010 0.0009620189666748
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4941' AND a.name = n.originalname
151 0.0005 0.00045084953308105
SELECT * FROM productoffers WHERE product_id = '4941' AND merchantid = 'A1X6FK5RDHNB96'
152 0.0005 0.00051784515380859
SELECT * FROM productoffers
                WHERE product_id = '4941' AND price > 0
                ORDER BY price ASC LIMIT 1
153 0.0005 0.00054121017456055
SELECT value FROM productattributes WHERE product_id = '4941' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
154 0.0005 0.00047707557678223
SELECT * FROM products WHERE id = '4940'
155 0.0003 0.00025296211242676
SELECT * FROM productimages WHERE product_id = '4940' ORDER BY sortorder ASC
156 0.0002 0.00024604797363281
SELECT * FROM product_image_select WHERE product_id = '4940'
157 0.0004 0.00037884712219238
SELECT * FROM productcustomimages WHERE product_id = '4940'
158 0.0021 0.0020849704742432
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4940' AND a.name = n.originalname
159 0.0005 0.00045204162597656
SELECT * FROM productoffers WHERE product_id = '4940' AND merchantid = 'A1X6FK5RDHNB96'
160 0.0005 0.00048995018005371
SELECT * FROM productoffers
                WHERE product_id = '4940' AND price > 0
                ORDER BY price ASC LIMIT 1
161 0.0005 0.0005340576171875
SELECT value FROM productattributes WHERE product_id = '4940' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
162 0.0005 0.00049495697021484
SELECT * FROM products WHERE id = '4952'
163 0.0002 0.00023794174194336
SELECT * FROM productimages WHERE product_id = '4952' ORDER BY sortorder ASC
164 0.0002 0.0002439022064209
SELECT * FROM product_image_select WHERE product_id = '4952'
165 0.0002 0.00022602081298828
SELECT * FROM productcustomimages WHERE product_id = '4952'
166 0.0003 0.00025320053100586
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4952' AND a.name = n.originalname
167 0.0002 0.0002439022064209
SELECT * FROM productoffers WHERE product_id = '4952' AND merchantid = 'A1X6FK5RDHNB96'
168 0.0003 0.00026583671569824
SELECT * FROM productoffers
                WHERE product_id = '4952' AND price > 0
                ORDER BY price ASC LIMIT 1
169 0.0002 0.00021600723266602
SELECT value FROM productattributes WHERE product_id = '4952' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
170 0.0005 0.00046610832214355
SELECT * FROM products WHERE id = '4951'
171 0.0012 0.0011630058288574
SELECT * FROM productimages WHERE product_id = '4951' ORDER BY sortorder ASC
172 0.0004 0.00039005279541016
SELECT * FROM product_image_select WHERE product_id = '4951'
173 0.0005 0.00045514106750488
SELECT * FROM productcustomimages WHERE product_id = '4951'
174 0.0012 0.0011889934539795
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4951' AND a.name = n.originalname
175 0.0006 0.0006110668182373
SELECT * FROM productoffers WHERE product_id = '4951' AND merchantid = 'A1X6FK5RDHNB96'
176 0.0006 0.00060510635375977
SELECT * FROM productoffers
                WHERE product_id = '4951' AND price > 0
                ORDER BY price ASC LIMIT 1
177 0.0006 0.0005791187286377
SELECT * FROM productoffers
                WHERE product_id = 4951
                ORDER BY price ASC LIMIT 1
178 0.0006 0.0005650520324707
SELECT value FROM productattributes
                WHERE product_id = '4951'
                AND name = 'ListPriceAmount'
179 0.0005 0.00054788589477539
SELECT value FROM productattributes WHERE product_id = '4951' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
180 0.0005 0.00049901008605957
SELECT * FROM products WHERE id = '4947'
181 0.0003 0.00033211708068848
SELECT * FROM productimages WHERE product_id = '4947' ORDER BY sortorder ASC
182 0.0004 0.00042891502380371
SELECT * FROM product_image_select WHERE product_id = '4947'
183 0.0004 0.00036811828613281
SELECT * FROM productcustomimages WHERE product_id = '4947'
184 0.0004 0.0004119873046875
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4947' AND a.name = n.originalname
185 0.0004 0.00041699409484863
SELECT * FROM productoffers WHERE product_id = '4947' AND merchantid = 'A1X6FK5RDHNB96'
186 0.0004 0.00042200088500977
SELECT * FROM productoffers
                WHERE product_id = '4947' AND price > 0
                ORDER BY price ASC LIMIT 1
187 0.0004 0.0003809928894043
SELECT value FROM productattributes WHERE product_id = '4947' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
188 0.0007 0.00072503089904785
SELECT * FROM products WHERE id = '4945'
189 0.0004 0.0003821849822998
SELECT * FROM productimages WHERE product_id = '4945' ORDER BY sortorder ASC
190 0.0004 0.00041794776916504
SELECT * FROM product_image_select WHERE product_id = '4945'
191 0.0004 0.00043582916259766
SELECT * FROM productcustomimages WHERE product_id = '4945'
192 0.0013 0.001270055770874
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4945' AND a.name = n.originalname
193 0.0007 0.00074601173400879
SELECT * FROM productoffers WHERE product_id = '4945' AND merchantid = 'A1X6FK5RDHNB96'
194 0.0006 0.00064420700073242
SELECT * FROM productoffers
                WHERE product_id = '4945' AND price > 0
                ORDER BY price ASC LIMIT 1
195 0.0005 0.00052499771118164
SELECT * FROM productoffers
                WHERE product_id = 4945
                ORDER BY price ASC LIMIT 1
196 0.0006 0.0006260871887207
SELECT value FROM productattributes
                WHERE product_id = '4945'
                AND name = 'ListPriceAmount'
197 0.0006 0.00060391426086426
SELECT value FROM productattributes WHERE product_id = '4945' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
198 0.0006 0.00064206123352051
SELECT * FROM products WHERE id = '4946'
199 0.0003 0.0003199577331543
SELECT * FROM productimages WHERE product_id = '4946' ORDER BY sortorder ASC
200 0.0002 0.00024890899658203
SELECT * FROM product_image_select WHERE product_id = '4946'
201 0.0002 0.00024008750915527
SELECT * FROM productcustomimages WHERE product_id = '4946'
202 0.0012 0.0011708736419678
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4946' AND a.name = n.originalname
203 0.0005 0.00054192543029785
SELECT * FROM productoffers WHERE product_id = '4946' AND merchantid = 'A1X6FK5RDHNB96'
204 0.0006 0.0006108283996582
SELECT * FROM productoffers
                WHERE product_id = '4946' AND price > 0
                ORDER BY price ASC LIMIT 1
205 0.0007 0.0007472038269043
SELECT value FROM productattributes WHERE product_id = '4946' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
206 0.0005 0.00052690505981445
SELECT * FROM products WHERE id = '4949'
207 0.0012 0.0011610984802246
SELECT * FROM productimages WHERE product_id = '4949' ORDER BY sortorder ASC
208 0.0005 0.00051593780517578
SELECT * FROM product_image_select WHERE product_id = '4949'
209 0.0005 0.00049805641174316
SELECT * FROM productcustomimages WHERE product_id = '4949'
210 0.0013 0.0013470649719238
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4949' AND a.name = n.originalname
211 0.0005 0.0005040168762207
SELECT * FROM productoffers WHERE product_id = '4949' AND merchantid = 'A1X6FK5RDHNB96'
212 0.0005 0.00050210952758789
SELECT * FROM productoffers
                WHERE product_id = '4949' AND price > 0
                ORDER BY price ASC LIMIT 1
213 0.0004 0.00044798851013184
SELECT * FROM productoffers
                WHERE product_id = 4949
                ORDER BY price ASC LIMIT 1
214 0.0005 0.00054216384887695
SELECT value FROM productattributes
                WHERE product_id = '4949'
                AND name = 'ListPriceAmount'
215 0.0005 0.0005490779876709
SELECT value FROM productattributes WHERE product_id = '4949' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
216 0.0005 0.00048398971557617
SELECT * FROM products WHERE id = '4944'
217 0.0003 0.00033402442932129
SELECT * FROM productimages WHERE product_id = '4944' ORDER BY sortorder ASC
218 0.0002 0.00023698806762695
SELECT * FROM product_image_select WHERE product_id = '4944'
219 0.0004 0.00037789344787598
SELECT * FROM productcustomimages WHERE product_id = '4944'
220 0.0011 0.0011200904846191
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4944' AND a.name = n.originalname
221 0.0004 0.0004270076751709
SELECT * FROM productoffers WHERE product_id = '4944' AND merchantid = 'A1X6FK5RDHNB96'
222 0.0004 0.00041890144348145
SELECT * FROM productoffers
                WHERE product_id = '4944' AND price > 0
                ORDER BY price ASC LIMIT 1
223 0.0005 0.00049901008605957
SELECT * FROM productoffers
                WHERE product_id = 4944
                ORDER BY price ASC LIMIT 1
224 0.0005 0.0004889965057373
SELECT value FROM productattributes
                WHERE product_id = '4944'
                AND name = 'ListPriceAmount'
225 0.0006 0.00057888031005859
SELECT value FROM productattributes WHERE product_id = '4944' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
226 0.0006 0.0005800724029541
SELECT * FROM products WHERE id = '4942'
227 0.0012 0.001248836517334
SELECT * FROM productimages WHERE product_id = '4942' ORDER BY sortorder ASC
228 0.0004 0.0003960132598877
SELECT * FROM product_image_select WHERE product_id = '4942'
229 0.0004 0.00037598609924316
SELECT * FROM productcustomimages WHERE product_id = '4942'
230 0.0010 0.00096797943115234
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4942' AND a.name = n.originalname
231 0.0005 0.00052404403686523
SELECT * FROM productoffers WHERE product_id = '4942' AND merchantid = 'A1X6FK5RDHNB96'
232 0.0007 0.00068783760070801
SELECT * FROM productoffers
                WHERE product_id = '4942' AND price > 0
                ORDER BY price ASC LIMIT 1
233 0.0005 0.00046396255493164
SELECT value FROM productattributes WHERE product_id = '4942' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
234 0.0005 0.00048398971557617
SELECT * FROM products WHERE id = '4943'
235 0.0003 0.00026082992553711
SELECT * FROM productimages WHERE product_id = '4943' ORDER BY sortorder ASC
236 0.0002 0.00023818016052246
SELECT * FROM product_image_select WHERE product_id = '4943'
237 0.0002 0.00024199485778809
SELECT * FROM productcustomimages WHERE product_id = '4943'
238 0.0017 0.0016560554504395
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4943' AND a.name = n.originalname
239 0.0004 0.00042891502380371
SELECT * FROM productoffers WHERE product_id = '4943' AND merchantid = 'A1X6FK5RDHNB96'
240 0.0005 0.00047206878662109
SELECT * FROM productoffers
                WHERE product_id = '4943' AND price > 0
                ORDER BY price ASC LIMIT 1
241 0.0004 0.00040698051452637
SELECT * FROM productoffers
                WHERE product_id = 4943
                ORDER BY price ASC LIMIT 1
242 0.0007 0.00068998336791992
SELECT value FROM productattributes
                WHERE product_id = '4943'
                AND name = 'ListPriceAmount'
243 0.0005 0.00050115585327148
SELECT value FROM productattributes WHERE product_id = '4943' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
244 0.0006 0.00062394142150879
SELECT * FROM products WHERE id = '4938'
245 0.0003 0.00027203559875488
SELECT * FROM productimages WHERE product_id = '4938' ORDER BY sortorder ASC
246 0.0002 0.00022697448730469
SELECT * FROM product_image_select WHERE product_id = '4938'
247 0.0002 0.00022292137145996
SELECT * FROM productcustomimages WHERE product_id = '4938'
248 0.0012 0.0011889934539795
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4938' AND a.name = n.originalname
249 0.0004 0.00038385391235352
SELECT * FROM productoffers WHERE product_id = '4938' AND merchantid = 'A1X6FK5RDHNB96'
250 0.0004 0.00044703483581543
SELECT * FROM productoffers
                WHERE product_id = '4938' AND price > 0
                ORDER BY price ASC LIMIT 1
251 0.0004 0.0004119873046875
SELECT * FROM productoffers
                WHERE product_id = 4938
                ORDER BY price ASC LIMIT 1
252 0.0004 0.00042295455932617
SELECT value FROM productattributes
                WHERE product_id = '4938'
                AND name = 'ListPriceAmount'
253 0.0005 0.00047588348388672
SELECT value FROM productattributes WHERE product_id = '4938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
254 0.0005 0.0005340576171875
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4950' ORDER BY timestamp DESC
255 0.0004 0.00044393539428711
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4953' ORDER BY timestamp DESC
256 0.0004 0.00036883354187012
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4939' ORDER BY timestamp DESC
257 0.0004 0.00042104721069336
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4948' ORDER BY timestamp DESC
258 0.0004 0.0003812313079834
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4941' ORDER BY timestamp DESC
259 0.0004 0.00038719177246094
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4940' ORDER BY timestamp DESC
260 0.0004 0.00040197372436523
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4952' ORDER BY timestamp DESC
261 0.0005 0.00046896934509277
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4951' ORDER BY timestamp DESC
262 0.0003 0.00034189224243164
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4947' ORDER BY timestamp DESC
263 0.0005 0.00045514106750488
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4945' ORDER BY timestamp DESC
264 0.0004 0.0003509521484375
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4946' ORDER BY timestamp DESC
265 0.0004 0.00038599967956543
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4949' ORDER BY timestamp DESC
266 0.0003 0.00034594535827637
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4944' ORDER BY timestamp DESC
267 0.0004 0.00035405158996582
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4942' ORDER BY timestamp DESC
268 0.0003 0.00032687187194824
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4943' ORDER BY timestamp DESC
269 0.0004 0.00041007995605469
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4938' ORDER BY timestamp DESC
270 0.0006 0.00058794021606445
SELECT linktitle,pagename,ep.id,price,buylink,image FROM ebay_products ep, products_categories c
		WHERE ep.id = c.product_id
		AND c.category_id = 31
		AND c.prod_type = 'ebay'
		AND hide = 0
271 0.0003 0.00028800964355469
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
272 0.0004 0.00037717819213867
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
273 0.0004 0.00037693977355957
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
274 0.0002 0.00024795532226562
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
275 0.0004 0.00040698051452637
SELECT * FROM pages WHERE id = 38
276 0.0048 0.0047950744628906
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
277 0.0005 0.00052094459533691
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:1653090956;s:8:\"products\";a:6:{i:0;s:10:\"788|amazon\";i:1;s:10:\"787|amazon\";i:2;s:11:\"1287|amazon\";i:3;s:10:\"780|amazon\";i:4;s:10:\"777|amazon\";i:5;s:10:\"776|amazon\";}}' WHERE id = '160'
278 0.0011 0.0010571479797363
SELECT * FROM products WHERE id = 788
279 0.0010 0.00099587440490723
SELECT * FROM products WHERE id = 787
280 0.0005 0.00053596496582031
SELECT * FROM products WHERE id = 1287
281 0.0005 0.00052881240844727
SELECT * FROM products WHERE id = 780
282 0.0005 0.00051498413085938
SELECT * FROM products WHERE id = 777
283 0.0005 0.0005190372467041
SELECT * FROM products WHERE id = 776
284 0.0005 0.00049090385437012
SELECT * FROM products WHERE id = '788'
285 0.0003 0.0002739429473877
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
286 0.0002 0.0002281665802002
SELECT * FROM product_image_select WHERE product_id = '788'
287 0.0002 0.00024604797363281
SELECT * FROM productcustomimages WHERE product_id = '788'
288 0.0003 0.00026798248291016
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
289 0.0002 0.00024700164794922
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
290 0.0003 0.00027084350585938
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
291 0.0002 0.00022602081298828
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
292 0.0005 0.00046110153198242
SELECT * FROM products WHERE id = '787'
293 0.0002 0.00024890899658203
SELECT * FROM productimages WHERE product_id = '787' ORDER BY sortorder ASC
294 0.0002 0.00022983551025391
SELECT * FROM product_image_select WHERE product_id = '787'
295 0.0002 0.00024104118347168
SELECT * FROM productcustomimages WHERE product_id = '787'
296 0.0003 0.00025200843811035
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '787' AND a.name = n.originalname
297 0.0002 0.00024008750915527
SELECT * FROM productoffers WHERE product_id = '787' AND merchantid = 'A1X6FK5RDHNB96'
298 0.0003 0.00026798248291016
SELECT * FROM productoffers
                WHERE product_id = '787' AND price > 0
                ORDER BY price ASC LIMIT 1
299 0.0002 0.00021696090698242
SELECT value FROM productattributes WHERE product_id = '787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
300 0.0005 0.00049400329589844
SELECT * FROM products WHERE id = '1287'
301 0.0003 0.00033307075500488
SELECT * FROM productimages WHERE product_id = '1287' ORDER BY sortorder ASC
302 0.0002 0.00023102760314941
SELECT * FROM product_image_select WHERE product_id = '1287'
303 0.0002 0.00024580955505371
SELECT * FROM productcustomimages WHERE product_id = '1287'
304 0.0004 0.00038290023803711
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1287' AND a.name = n.originalname
305 0.0004 0.00036787986755371
SELECT * FROM productoffers WHERE product_id = '1287' AND merchantid = 'A1X6FK5RDHNB96'
306 0.0003 0.00033688545227051
SELECT * FROM productoffers
                WHERE product_id = '1287' AND price > 0
                ORDER BY price ASC LIMIT 1
307 0.0002 0.00021886825561523
SELECT value FROM productattributes WHERE product_id = '1287' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
308 0.0005 0.00047397613525391
SELECT * FROM products WHERE id = '780'
309 0.0003 0.00029802322387695
SELECT * FROM productimages WHERE product_id = '780' ORDER BY sortorder ASC
310 0.0002 0.00023412704467773
SELECT * FROM product_image_select WHERE product_id = '780'
311 0.0002 0.00023722648620605
SELECT * FROM productcustomimages WHERE product_id = '780'
312 0.0003 0.00026798248291016
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '780' AND a.name = n.originalname
313 0.0002 0.0002439022064209
SELECT * FROM productoffers WHERE product_id = '780' AND merchantid = 'A1X6FK5RDHNB96'
314 0.0003 0.00026416778564453
SELECT * FROM productoffers
                WHERE product_id = '780' AND price > 0
                ORDER BY price ASC LIMIT 1
315 0.0002 0.0002291202545166
SELECT value FROM productattributes WHERE product_id = '780' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
316 0.0005 0.00049185752868652
SELECT * FROM products WHERE id = '777'
317 0.0003 0.00025200843811035
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
318 0.0002 0.000244140625
SELECT * FROM product_image_select WHERE product_id = '777'
319 0.0002 0.00023007392883301
SELECT * FROM productcustomimages WHERE product_id = '777'
320 0.0004 0.0003809928894043
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
321 0.0004 0.00038003921508789
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
322 0.0003 0.00029802322387695
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
323 0.0002 0.00022411346435547
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
324 0.0005 0.00050687789916992
SELECT * FROM products WHERE id = '776'
325 0.0003 0.00025820732116699
SELECT * FROM productimages WHERE product_id = '776' ORDER BY sortorder ASC
326 0.0002 0.00023984909057617
SELECT * FROM product_image_select WHERE product_id = '776'
327 0.0003 0.0002589225769043
SELECT * FROM productcustomimages WHERE product_id = '776'
328 0.0003 0.00026392936706543
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '776' AND a.name = n.originalname
329 0.0003 0.0002601146697998
SELECT * FROM productoffers WHERE product_id = '776' AND merchantid = 'A1X6FK5RDHNB96'
330 0.0003 0.00025701522827148
SELECT * FROM productoffers
                WHERE product_id = '776' AND price > 0
                ORDER BY price ASC LIMIT 1
331 0.0002 0.00022602081298828
SELECT value FROM productattributes WHERE product_id = '776' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
332 0.0003 0.0003058910369873
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
333 0.0003 0.0003211498260498
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
334 0.0006 0.00061798095703125
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
335 0.0004 0.00035595893859863
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
336 0.0004 0.00036096572875977
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
337 0.0005 0.00045108795166016
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'ICON_RSS_FEED'
338 0.0004 0.00043606758117676
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
339 0.0006 0.00055313110351562
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
340 0.0004 0.00042414665222168
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
341 0.0004 0.00044798851013184
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'