Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
0.63133096694946 317 0.1588 0


No Amazon API Requests Made.

Total time 0.63133096694946 seconds

Number Time From Start Name Description
1 0.42654490470886 Initialise Initialise FSB Function
2 0.43043303489685 App Controller Start Start of the App controller (called before the controller of every page)
3 0.44074296951294 App Controller End End of the App controller (called before the controller of every page)
4 0.44149684906006 Category Start Start of the category controller
5 0.44149994850159 Before Get Category Before getting the category information
6 0.44959783554077 After Get Category After getting the category information
7 0.4496009349823 Before Get Category List Before getting the updated category list
8 0.4499728679657 Start of getCategoryListByGroup Function Before first category groups query
9 0.45025300979614 After initial query Before first category groups query
10 0.45025491714478 Get Category List for Group Before the call to getCategoryList function
11 0.45025897026062 Start of GetCategoryList function Start of the function
12 0.45026183128357 Before getting categories Query to get specific category list
13 0.45063185691833 After getting categories Query to get specific category list
14 0.45063400268555 Before getting category custom Before call to function getCategoryCustom
15 0.45382690429688 After getting category custom After call to function getCategoryCustom
16 0.4538300037384 Before getting category custom Before call to function getCategoryCustom
17 0.46487092971802 After getting category custom After call to function getCategoryCustom
18 0.46487593650818 Before getting category custom Before call to function getCategoryCustom
19 0.47070789337158 After getting category custom After call to function getCategoryCustom
20 0.47071099281311 Before getting category custom Before call to function getCategoryCustom
21 0.47434687614441 After getting category custom After call to function getCategoryCustom
22 0.47434997558594 Before getting category custom Before call to function getCategoryCustom
23 0.47714495658875 After getting category custom After call to function getCategoryCustom
24 0.47714686393738 Before getting sub category list Before call to recursive function getCategoryList
25 0.47714996337891 Start of GetCategoryList function Start of the function
26 0.47715306282043 Before getting categories Query to get specific category list
27 0.47744703292847 After getting sub category list After call to recursive function getCategoryList
28 0.4774489402771 Before getting category custom Before call to function getCategoryCustom
29 0.48093199729919 After getting category custom After call to function getCategoryCustom
30 0.48093390464783 End of GetCategoryList function End of the function
31 0.48094201087952 End of getCategoryListByGroup Function Before return()
32 0.48094391822815 After Get Category List After getting the updated category list
33 0.48094487190247 Before Category Images Before getting the category images
34 0.48131084442139 After Category Images After getting the category images
35 0.48165702819824 Before Sub Category Check Before checking for sub category or products category
36 0.48189902305603 Before Category Products Controller Before loading the category products controller
37 0.48316597938538 Start Category Products Start of Category Products Controller
38 0.4831850528717 After Pagination Options After pagination options in Category Products Controller
39 0.48375391960144 After Cache After Cache checking in Category Products Controller
40 0.48792195320129 After Filter Options After getting filter options and SQL in Category Products Controller
41 0.4888129234314 After Counting Products After counting products in the Category Products Controller
42 0.48913598060608 After Counting Bundles After counting bundles in the Category Products Controller
43 0.48951387405396 After Counting Products After counting products in the Category Products Controller
44 0.49161005020142 After Getting Products After getting products and bundles in the Category Products Controller
45 0.49165296554565 After Pagination Links After getting pagination listing links in the Category Products Controller
46 0.49165487289429 After Getting Bundle Details After getting full details for the bundles in the Category Products Controller
47 0.5575258731842 After Getting Product Details After getting full product details in the Category Products Controller
48 0.56137704849243 After Getting Product/Bundle Reviews After getting full product/bundle customer review in the Category Products Controller
49 0.5637948513031 App_after Controller Start Start of the App_after controller (called after the controller of every page)
50 0.56442594528198 Before Get Options Before the call to getOptions in the tpl class
51 0.59164094924927 After Get Options After the call to getOptions in the tpl class
52 0.59184789657593 App_after Controller End End of the App_after controller (called after the controller of every page)
53 0.59188485145569 Before Smarty Before passing everything over to Smarty in the Category Products Controller
54 0.63129901885986 After Loading sub/product controller After checking for sub category or products category and then loading the relevant controller
55 0.63131093978882 Finalizing debug Before the debug is output to the page.
56 0.63132905960083 End of App This is the end of the app logging, final timestamp


Query Debug - 317 Database Queries. Total time 0.1588 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0006 0.00061988830566406
SELECT parameter, value FROM parameters
2 0.0009 0.00091004371643066
SELECT * FROM `bad_bots`
3 0.0004 0.00039505958557129
SET time_zone = 'Europe/London'
4 0.0004 0.00039577484130859
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0023 0.0023419857025146
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"3.236.110.106\";}'
6 0.0015 0.0014519691467285
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1627540824'
7 0.0006 0.00059294700622559
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0003 0.00029182434082031
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0006 0.00061583518981934
SELECT id FROM pages WHERE pagename = 'cafes' LIMIT 1
10 0.0008 0.00080990791320801
SELECT id FROM products WHERE pagename = 'cafes' AND hidden = 0 LIMIT 1
11 0.0006 0.00062203407287598
SELECT id FROM ebay_products WHERE pagename = 'cafes'
12 0.0004 0.0003659725189209
SELECT id FROM custom_products WHERE pagename = 'cafes'
13 0.0002 0.00024318695068359
SELECT id FROM categories WHERE pagename = 'cafes' LIMIT 1
14 0.0016 0.0016329288482666
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
15 0.0010 0.0010101795196533
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
16 0.0005 0.00047707557678223
SELECT * FROM pages WHERE pagename = 'cafes'
17 0.0003 0.00032591819763184
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
18 0.0004 0.00044393539428711
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
19 0.0004 0.00042295455932617
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.0004 0.00036883354187012
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
21 0.0008 0.00080013275146484
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
22 0.0008 0.00075697898864746
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
23 0.0004 0.00035405158996582
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)
24 0.0003 0.00034189224243164
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
25 0.0003 0.00034308433532715
SELECT * FROM countryredirects WHERE countrycode = 'US'
26 0.0004 0.00039291381835938
SELECT * FROM categories WHERE pagename = 'cafes'
27 0.0012 0.0011799335479736
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
28 0.0004 0.00042819976806641
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
29 0.0004 0.00038599967956543
SELECT id FROM categories WHERE parent_id = '30'
30 0.0012 0.0011920928955078
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 
31 0.0004 0.0004279613494873
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 
32 0.0003 0.00034618377685547
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
33 0.0002 0.00023889541625977
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
34 0.0002 0.00023984909057617
SELECT id FROM categories WHERE parent_id = '30'
35 0.0013 0.001305103302002
SELECT p.id FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (30) 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.00032997131347656
SELECT * FROM productimages WHERE product_id = '4926' ORDER BY sortorder ASC
37 0.0003 0.00033092498779297
SELECT * FROM categoryimages WHERE category_id = 30
38 0.0002 0.00024580955505371
SELECT * FROM categorygroups WHERE id = '1'
39 0.0005 0.0005490779876709
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 = '30'
		  AND p.offers > 0
		  AND p.hidden = 0
		  AND p.enabled = 1
		  AND p.parent = 0
		  AND p.price > 0
40 0.0003 0.00028610229492188
SELECT parent_id FROM categories WHERE id = '30'
41 0.0004 0.00035285949707031
SELECT parent_id FROM categories WHERE id = '30'
42 0.0003 0.00026702880859375
SELECT * FROM categorygroups ORDER BY sortorder ASC
43 0.0003 0.00034904479980469
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
44 0.0004 0.0004119873046875
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.0004 0.00039100646972656
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.0004 0.00036191940307617
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
47 0.0003 0.00034213066101074
SELECT id FROM categories WHERE parent_id = '26'
48 0.0002 0.00021004676818848
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.0003 0.00027012825012207
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.0005 0.00050592422485352
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.0003 0.00034093856811523
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
52 0.0002 0.00021600723266602
SELECT * FROM categorygroups WHERE id = '1'
53 0.0046 0.0046350955963135
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.0002 0.00023508071899414
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.00025701522827148
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
56 0.0002 0.00021100044250488
SELECT id FROM categories WHERE parent_id = '27'
57 0.0044 0.0044071674346924
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.0003 0.00026607513427734
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.00022411346435547
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.0004 0.00037980079650879
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
61 0.0003 0.00027799606323242
SELECT * FROM categorygroups WHERE id = '1'
62 0.0018 0.0017719268798828
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.00027585029602051
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.00020313262939453
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
65 0.0002 0.00020194053649902
SELECT id FROM categories WHERE parent_id = '28'
66 0.0020 0.00201416015625
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.00034904479980469
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.00025415420532227
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.00020790100097656
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
70 0.0004 0.00040721893310547
SELECT * FROM categorygroups WHERE id = '1'
71 0.0007 0.00072097778320312
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.00032401084899902
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.0003 0.00030612945556641
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
74 0.0004 0.0003659725189209
SELECT id FROM categories WHERE parent_id = '29'
75 0.0006 0.00064492225646973
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.00021815299987793
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.0003 0.00029897689819336
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.0004 0.00035691261291504
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
79 0.0003 0.00027084350585938
SELECT * FROM categorygroups WHERE id = '1'
80 0.0005 0.0005190372467041
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.0003 0.00034809112548828
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
83 0.0002 0.00024795532226562
SELECT id FROM categories WHERE parent_id = '30'
84 0.0002 0.00022697448730469
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.00018620491027832
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.0001988410949707
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.0004 0.00036883354187012
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
88 0.0004 0.00037097930908203
SELECT * FROM categorygroups WHERE id = '1'
89 0.0003 0.00028109550476074
SELECT * FROM categories WHERE parent_id = '30'  AND hidden = 0 ORDER BY sortorder ASC
90 0.0007 0.00067496299743652
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
91 0.0004 0.00036811828613281
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
92 0.0003 0.00025391578674316
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
93 0.0003 0.00025391578674316
SELECT id FROM categories WHERE parent_id = '31'
94 0.0006 0.00063490867614746
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 
95 0.0003 0.00026893615722656
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 
96 0.0002 0.00024700164794922
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
97 0.0002 0.00022697448730469
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
98 0.0005 0.00045299530029297
SELECT * FROM categorygroups WHERE id = '1'
99 0.0004 0.00035500526428223
SELECT * FROM categoryimages WHERE category_id = 30
100 0.0003 0.00030994415283203
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
101 0.0002 0.00023007392883301
SELECT * FROM categories WHERE parent_id = '30'
102 0.0021 0.0020649433135986
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
103 0.0005 0.00051498413085938
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
104 0.0003 0.00031709671020508
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
105 0.0003 0.00029706954956055
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
106 0.0003 0.00029802322387695
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
107 0.0003 0.00032520294189453
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
108 0.0006 0.00064682960510254
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 = 30
		AND (c.prod_type = '' OR c.prod_type = 'amz')
		AND hidden = 0
		AND enabled = 1
		
		AND 1 = 1
109 0.0002 0.00021195411682129
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
		WHERE ep.id = c.product_id
		AND c.category_id = 30
		AND c.prod_type = 'ebay'
		AND hide = 0
110 0.0003 0.00030612945556641
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 = 30
			AND p.disabled = 0
			
			AND 1 = 1
111 0.0004 0.00036501884460449
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
		WHERE cp.id = c.product_id
		AND c.category_id = 30
		AND c.prod_type = 'custom'
		AND hide = 0
112 0.0020 0.0020499229431152
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 = 30
			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 = 30
		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 = 30
		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 = 30
			AND disabled = 0
			
			AND 1 = 1 ORDER BY salesrank ASC LIMIT 0, 18
113 0.0011 0.0011022090911865
SELECT * FROM products WHERE id = '4926'
114 0.0003 0.00028491020202637
SELECT * FROM productimages WHERE product_id = '4926' ORDER BY sortorder ASC
115 0.0006 0.00062012672424316
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4926' AND p.id = pi.product_id ORDER BY pi.sortorder
116 0.0003 0.00025796890258789
SELECT * FROM product_image_select WHERE product_id = '4926'
117 0.0002 0.00020408630371094
SELECT * FROM productcustomimages WHERE product_id = '4926'
118 0.0007 0.00065898895263672
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4926'
                GROUP BY o.product_id
119 0.0007 0.00069189071655273
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4926'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
120 0.0005 0.00046491622924805
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4926
121 0.0014 0.0013570785522461
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4926' AND a.name = n.originalname
122 0.0005 0.00045895576477051
SELECT * FROM productoffers WHERE product_id = '4926' AND merchantid = 'A1X6FK5RDHNB96'
123 0.0007 0.00068807601928711
SELECT * FROM productoffers
                WHERE product_id = '4926' AND price > 0
                ORDER BY price ASC LIMIT 1
124 0.0005 0.00053691864013672
SELECT * FROM productoffers
                WHERE product_id = 4926
                ORDER BY price ASC LIMIT 1
125 0.0004 0.00044393539428711
SELECT value FROM productattributes
                WHERE product_id = '4926'
                AND name = 'ListPriceAmount'
126 0.0002 0.00023818016052246
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4926'
                GROUP BY o.product_id
127 0.0003 0.00033688545227051
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4926'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
128 0.0002 0.00022292137145996
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4926
129 0.0010 0.0010008811950684
SELECT * FROM products WHERE parent_id = '4926'
130 0.0005 0.00052189826965332
SELECT * FROM products WHERE id = '4933'
131 0.0003 0.00034189224243164
SELECT * FROM productimages WHERE product_id = '4933' ORDER BY sortorder ASC
132 0.0005 0.00047612190246582
SELECT * FROM product_image_select WHERE product_id = '4933'
133 0.0004 0.0003511905670166
SELECT * FROM productcustomimages WHERE product_id = '4933'
134 0.0011 0.0011417865753174
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4933' AND a.name = n.originalname
135 0.0005 0.00051212310791016
SELECT * FROM productoffers WHERE product_id = '4933' AND merchantid = 'A1X6FK5RDHNB96'
136 0.0007 0.00068211555480957
SELECT * FROM productoffers
                WHERE product_id = '4933' AND price > 0
                ORDER BY price ASC LIMIT 1
137 0.0006 0.00057816505432129
SELECT value FROM productattributes WHERE product_id = '4933' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
138 0.0005 0.00050997734069824
SELECT * FROM products WHERE id = '4954'
139 0.0003 0.00034594535827637
SELECT * FROM productimages WHERE product_id = '4954' ORDER BY sortorder ASC
140 0.0004 0.00041294097900391
SELECT * FROM product_image_select WHERE product_id = '4954'
141 0.0003 0.0003359317779541
SELECT * FROM productcustomimages WHERE product_id = '4954'
142 0.0007 0.00069499015808105
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4954' AND a.name = n.originalname
143 0.0006 0.00061202049255371
SELECT * FROM productoffers WHERE product_id = '4954' AND merchantid = 'A1X6FK5RDHNB96'
144 0.0005 0.00045013427734375
SELECT value FROM productattributes WHERE product_id = '4954' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
145 0.0005 0.0004730224609375
SELECT * FROM products WHERE id = '4929'
146 0.0004 0.00038480758666992
SELECT * FROM productimages WHERE product_id = '4929' ORDER BY sortorder ASC
147 0.0004 0.00035405158996582
SELECT * FROM product_image_select WHERE product_id = '4929'
148 0.0003 0.00032496452331543
SELECT * FROM productcustomimages WHERE product_id = '4929'
149 0.0002 0.00024795532226562
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4929' AND a.name = n.originalname
150 0.0004 0.00039005279541016
SELECT * FROM productoffers WHERE product_id = '4929' AND merchantid = 'A1X6FK5RDHNB96'
151 0.0003 0.00033903121948242
SELECT * FROM productoffers
                WHERE product_id = '4929' AND price > 0
                ORDER BY price ASC LIMIT 1
152 0.0003 0.00025510787963867
SELECT value FROM productattributes WHERE product_id = '4929' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
153 0.0005 0.00049090385437012
SELECT * FROM products WHERE id = '4937'
154 0.0003 0.00033783912658691
SELECT * FROM productimages WHERE product_id = '4937' ORDER BY sortorder ASC
155 0.0003 0.00026798248291016
SELECT * FROM product_image_select WHERE product_id = '4937'
156 0.0003 0.00026202201843262
SELECT * FROM productcustomimages WHERE product_id = '4937'
157 0.0011 0.0010800361633301
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4937' AND a.name = n.originalname
158 0.0004 0.00041604042053223
SELECT * FROM productoffers WHERE product_id = '4937' AND merchantid = 'A1X6FK5RDHNB96'
159 0.0004 0.00043487548828125
SELECT * FROM productoffers
                WHERE product_id = '4937' AND price > 0
                ORDER BY price ASC LIMIT 1
160 0.0005 0.00051593780517578
SELECT * FROM productoffers
                WHERE product_id = 4937
                ORDER BY price ASC LIMIT 1
161 0.0006 0.00056886672973633
SELECT value FROM productattributes
                WHERE product_id = '4937'
                AND name = 'ListPriceAmount'
162 0.0005 0.00047206878662109
SELECT * FROM products WHERE id = '4932'
163 0.0003 0.00034093856811523
SELECT * FROM productimages WHERE product_id = '4932' ORDER BY sortorder ASC
164 0.0004 0.00039315223693848
SELECT * FROM product_image_select WHERE product_id = '4932'
165 0.0003 0.0003209114074707
SELECT * FROM productcustomimages WHERE product_id = '4932'
166 0.0012 0.0011730194091797
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4932' AND a.name = n.originalname
167 0.0004 0.00044608116149902
SELECT * FROM productoffers WHERE product_id = '4932' AND merchantid = 'A1X6FK5RDHNB96'
168 0.0005 0.00048708915710449
SELECT * FROM productoffers
                WHERE product_id = '4932' AND price > 0
                ORDER BY price ASC LIMIT 1
169 0.0005 0.0005340576171875
SELECT * FROM productoffers
                WHERE product_id = 4932
                ORDER BY price ASC LIMIT 1
170 0.0005 0.00047087669372559
SELECT value FROM productattributes
                WHERE product_id = '4932'
                AND name = 'ListPriceAmount'
171 0.0008 0.00078988075256348
SELECT * FROM products WHERE id = '4934'
172 0.0003 0.00028800964355469
SELECT * FROM productimages WHERE product_id = '4934' ORDER BY sortorder ASC
173 0.0004 0.00036001205444336
SELECT * FROM product_image_select WHERE product_id = '4934'
174 0.0005 0.00049805641174316
SELECT * FROM productcustomimages WHERE product_id = '4934'
175 0.0015 0.0014510154724121
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4934' AND a.name = n.originalname
176 0.0005 0.00053882598876953
SELECT * FROM productoffers WHERE product_id = '4934' AND merchantid = 'A1X6FK5RDHNB96'
177 0.0004 0.00042200088500977
SELECT * FROM productoffers
                WHERE product_id = '4934' AND price > 0
                ORDER BY price ASC LIMIT 1
178 0.0005 0.00054001808166504
SELECT * FROM productoffers
                WHERE product_id = 4934
                ORDER BY price ASC LIMIT 1
179 0.0005 0.00045418739318848
SELECT value FROM productattributes
                WHERE product_id = '4934'
                AND name = 'ListPriceAmount'
180 0.0005 0.00046300888061523
SELECT value FROM productattributes WHERE product_id = '4934' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
181 0.0004 0.00044798851013184
SELECT * FROM products WHERE id = '4928'
182 0.0003 0.00029587745666504
SELECT * FROM productimages WHERE product_id = '4928' ORDER BY sortorder ASC
183 0.0003 0.00027203559875488
SELECT * FROM product_image_select WHERE product_id = '4928'
184 0.0003 0.00033116340637207
SELECT * FROM productcustomimages WHERE product_id = '4928'
185 0.0011 0.001082181930542
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4928' AND a.name = n.originalname
186 0.0004 0.00043296813964844
SELECT * FROM productoffers WHERE product_id = '4928' AND merchantid = 'A1X6FK5RDHNB96'
187 0.0004 0.00037312507629395
SELECT * FROM productoffers
                WHERE product_id = '4928' AND price > 0
                ORDER BY price ASC LIMIT 1
188 0.0005 0.00048708915710449
SELECT * FROM productoffers
                WHERE product_id = 4928
                ORDER BY price ASC LIMIT 1
189 0.0005 0.00046706199645996
SELECT value FROM productattributes
                WHERE product_id = '4928'
                AND name = 'ListPriceAmount'
190 0.0004 0.00044798851013184
SELECT value FROM productattributes WHERE product_id = '4928' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
191 0.0005 0.00046181678771973
SELECT * FROM products WHERE id = '4930'
192 0.0003 0.00029110908508301
SELECT * FROM productimages WHERE product_id = '4930' ORDER BY sortorder ASC
193 0.0005 0.00049591064453125
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4930' AND p.id = pi.product_id ORDER BY pi.sortorder
194 0.0002 0.000244140625
SELECT * FROM product_image_select WHERE product_id = '4930'
195 0.0002 0.00021886825561523
SELECT * FROM productcustomimages WHERE product_id = '4930'
196 0.0006 0.0005500316619873
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4930'
                GROUP BY o.product_id
197 0.0005 0.00052285194396973
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4930'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
198 0.0004 0.00041103363037109
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4930
199 0.0002 0.00021696090698242
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4930' AND a.name = n.originalname
200 0.0004 0.0003960132598877
SELECT * FROM productoffers WHERE product_id = '4930' AND merchantid = 'A1X6FK5RDHNB96'
201 0.0005 0.00051593780517578
SELECT * FROM productoffers
                WHERE product_id = '4930' AND price > 0
                ORDER BY price ASC LIMIT 1
202 0.0004 0.00041699409484863
SELECT * FROM productoffers
                WHERE product_id = 4930
                ORDER BY price ASC LIMIT 1
203 0.0007 0.00067591667175293
SELECT value FROM productattributes
                WHERE product_id = '4930'
                AND name = 'ListPriceAmount'
204 0.0004 0.00035285949707031
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4930'
                GROUP BY o.product_id
205 0.0004 0.00036787986755371
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4930'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
206 0.0003 0.00027608871459961
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4930
207 0.0004 0.00043201446533203
SELECT * FROM products WHERE parent_id = '4930'
208 0.0006 0.00055408477783203
SELECT * FROM products WHERE id = '4936'
209 0.0004 0.00037789344787598
SELECT * FROM productimages WHERE product_id = '4936' ORDER BY sortorder ASC
210 0.0004 0.00043797492980957
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4936' AND p.id = pi.product_id ORDER BY pi.sortorder
211 0.0003 0.00032806396484375
SELECT * FROM product_image_select WHERE product_id = '4936'
212 0.0004 0.00037407875061035
SELECT * FROM productcustomimages WHERE product_id = '4936'
213 0.0004 0.0004420280456543
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4936'
                GROUP BY o.product_id
214 0.0017 0.001655101776123
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4936'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
215 0.0005 0.00051403045654297
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4936
216 0.0012 0.0012080669403076
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4936' AND a.name = n.originalname
217 0.0005 0.00045585632324219
SELECT * FROM productoffers WHERE product_id = '4936' AND merchantid = 'A1X6FK5RDHNB96'
218 0.0005 0.00050187110900879
SELECT * FROM productoffers
                WHERE product_id = '4936' AND price > 0
                ORDER BY price ASC LIMIT 1
219 0.0006 0.00055408477783203
SELECT * FROM productoffers
                WHERE product_id = 4936
                ORDER BY price ASC LIMIT 1
220 0.0005 0.00054693222045898
SELECT value FROM productattributes
                WHERE product_id = '4936'
                AND name = 'ListPriceAmount'
221 0.0002 0.00022482872009277
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4936'
                GROUP BY o.product_id
222 0.0002 0.00021004676818848
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4936'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
223 0.0002 0.00020599365234375
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4936
224 0.0005 0.00054097175598145
SELECT * FROM products WHERE parent_id = '4936'
225 0.0005 0.0005190372467041
SELECT * FROM products WHERE id = '4935'
226 0.0005 0.00049901008605957
SELECT * FROM productimages WHERE product_id = '4935' ORDER BY sortorder ASC
227 0.0003 0.00030112266540527
SELECT * FROM product_image_select WHERE product_id = '4935'
228 0.0003 0.00034904479980469
SELECT * FROM productcustomimages WHERE product_id = '4935'
229 0.0013 0.001284122467041
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4935' AND a.name = n.originalname
230 0.0013 0.0013229846954346
SELECT * FROM productoffers WHERE product_id = '4935' AND merchantid = 'A1X6FK5RDHNB96'
231 0.0006 0.00058102607727051
SELECT * FROM productoffers
                WHERE product_id = '4935' AND price > 0
                ORDER BY price ASC LIMIT 1
232 0.0007 0.0007169246673584
SELECT * FROM productoffers
                WHERE product_id = 4935
                ORDER BY price ASC LIMIT 1
233 0.0006 0.00063109397888184
SELECT value FROM productattributes
                WHERE product_id = '4935'
                AND name = 'ListPriceAmount'
234 0.0005 0.00047492980957031
SELECT value FROM productattributes WHERE product_id = '4935' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
235 0.0002 0.00023412704467773
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4926' ORDER BY timestamp DESC
236 0.0003 0.00028395652770996
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4933' ORDER BY timestamp DESC
237 0.0003 0.00028204917907715
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4954' ORDER BY timestamp DESC
238 0.0004 0.00043606758117676
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4929' ORDER BY timestamp DESC
239 0.0002 0.00021815299987793
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4937' ORDER BY timestamp DESC
240 0.0002 0.00021910667419434
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4932' ORDER BY timestamp DESC
241 0.0003 0.00029397010803223
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4934' ORDER BY timestamp DESC
242 0.0005 0.00046014785766602
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4928' ORDER BY timestamp DESC
243 0.0005 0.00050783157348633
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4930' ORDER BY timestamp DESC
244 0.0003 0.00034117698669434
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4936' ORDER BY timestamp DESC
245 0.0004 0.00037384033203125
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4935' ORDER BY timestamp DESC
246 0.0006 0.00062322616577148
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 = 30
		AND c.prod_type = 'ebay'
		AND hide = 0
247 0.0003 0.00025510787963867
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
248 0.0007 0.0006718635559082
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
249 0.0003 0.00032711029052734
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
250 0.0002 0.00021910667419434
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
251 0.0003 0.00033402442932129
SELECT * FROM pages WHERE id = 38
252 0.0004 0.00043296813964844
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
253 0.0008 0.00080204010009766
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:1627540824;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'
254 0.0004 0.00039291381835938
SELECT * FROM products WHERE id = 790
255 0.0006 0.00064182281494141
SELECT * FROM products WHERE id = 788
256 0.0004 0.00038504600524902
SELECT * FROM products WHERE id = 787
257 0.0005 0.00049400329589844
SELECT * FROM products WHERE id = 808
258 0.0004 0.0004279613494873
SELECT * FROM products WHERE id = 810
259 0.0006 0.00057196617126465
SELECT * FROM products WHERE id = 4947
260 0.0005 0.0005030632019043
SELECT * FROM products WHERE id = '790'
261 0.0008 0.00078511238098145
SELECT * FROM productimages WHERE product_id = '790' ORDER BY sortorder ASC
262 0.0003 0.00033283233642578
SELECT * FROM product_image_select WHERE product_id = '790'
263 0.0003 0.00025200843811035
SELECT * FROM productcustomimages WHERE product_id = '790'
264 0.0004 0.00043201446533203
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '790' AND a.name = n.originalname
265 0.0003 0.00028204917907715
SELECT * FROM productoffers WHERE product_id = '790' AND merchantid = 'A1X6FK5RDHNB96'
266 0.0003 0.00026988983154297
SELECT * FROM productoffers
                WHERE product_id = '790' AND price > 0
                ORDER BY price ASC LIMIT 1
267 0.0003 0.00029897689819336
SELECT value FROM productattributes WHERE product_id = '790' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
268 0.0003 0.00031900405883789
SELECT * FROM products WHERE id = '788'
269 0.0004 0.00035595893859863
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
270 0.0004 0.00035905838012695
SELECT * FROM product_image_select WHERE product_id = '788'
271 0.0004 0.00036287307739258
SELECT * FROM productcustomimages WHERE product_id = '788'
272 0.0003 0.00029301643371582
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
273 0.0003 0.00029897689819336
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
274 0.0003 0.00026702880859375
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
275 0.0004 0.0003960132598877
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
276 0.0005 0.00048708915710449
SELECT * FROM products WHERE id = '787'
277 0.0004 0.00036311149597168
SELECT * FROM productimages WHERE product_id = '787' ORDER BY sortorder ASC
278 0.0003 0.00032401084899902
SELECT * FROM product_image_select WHERE product_id = '787'
279 0.0003 0.00025391578674316
SELECT * FROM productcustomimages WHERE product_id = '787'
280 0.0003 0.00031304359436035
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '787' AND a.name = n.originalname
281 0.0004 0.00037288665771484
SELECT * FROM productoffers WHERE product_id = '787' AND merchantid = 'A1X6FK5RDHNB96'
282 0.0005 0.00051498413085938
SELECT * FROM productoffers
                WHERE product_id = '787' AND price > 0
                ORDER BY price ASC LIMIT 1
283 0.0004 0.00044798851013184
SELECT value FROM productattributes WHERE product_id = '787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
284 0.0004 0.00038886070251465
SELECT * FROM products WHERE id = '808'
285 0.0003 0.00030088424682617
SELECT * FROM productimages WHERE product_id = '808' ORDER BY sortorder ASC
286 0.0003 0.00027894973754883
SELECT * FROM product_image_select WHERE product_id = '808'
287 0.0002 0.00022482872009277
SELECT * FROM productcustomimages WHERE product_id = '808'
288 0.0002 0.0002448558807373
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '808' AND a.name = n.originalname
289 0.0004 0.00035905838012695
SELECT * FROM productoffers WHERE product_id = '808' AND merchantid = 'A1X6FK5RDHNB96'
290 0.0003 0.00028491020202637
SELECT * FROM productoffers
                WHERE product_id = '808' AND price > 0
                ORDER BY price ASC LIMIT 1
291 0.0003 0.00025796890258789
SELECT value FROM productattributes WHERE product_id = '808' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
292 0.0004 0.00037002563476562
SELECT * FROM products WHERE id = '810'
293 0.0004 0.00038504600524902
SELECT * FROM productimages WHERE product_id = '810' ORDER BY sortorder ASC
294 0.0004 0.00035691261291504
SELECT * FROM product_image_select WHERE product_id = '810'
295 0.0002 0.00024700164794922
SELECT * FROM productcustomimages WHERE product_id = '810'
296 0.0003 0.0003361701965332
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '810' AND a.name = n.originalname
297 0.0004 0.00042104721069336
SELECT * FROM productoffers WHERE product_id = '810' AND merchantid = 'A1X6FK5RDHNB96'
298 0.0004 0.00040411949157715
SELECT * FROM productoffers
                WHERE product_id = '810' AND price > 0
                ORDER BY price ASC LIMIT 1
299 0.0003 0.00033879280090332
SELECT value FROM productattributes WHERE product_id = '810' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
300 0.0003 0.00032305717468262
SELECT * FROM products WHERE id = '4947'
301 0.0003 0.00032496452331543
SELECT * FROM productimages WHERE product_id = '4947' ORDER BY sortorder ASC
302 0.0004 0.00037813186645508
SELECT * FROM product_image_select WHERE product_id = '4947'
303 0.0004 0.00035309791564941
SELECT * FROM productcustomimages WHERE product_id = '4947'
304 0.0003 0.00027918815612793
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4947' AND a.name = n.originalname
305 0.0004 0.00041294097900391
SELECT * FROM productoffers WHERE product_id = '4947' AND merchantid = 'A1X6FK5RDHNB96'
306 0.0005 0.00049018859863281
SELECT * FROM productoffers
                WHERE product_id = '4947' AND price > 0
                ORDER BY price ASC LIMIT 1
307 0.0004 0.00035810470581055
SELECT value FROM productattributes WHERE product_id = '4947' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
308 0.0004 0.00042605400085449
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
309 0.0004 0.00041604042053223
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
310 0.0006 0.00061178207397461
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
311 0.0006 0.00061583518981934
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
312 0.0004 0.0003819465637207
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
313 0.0014 0.0013599395751953
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'ICON_RSS_FEED'
314 0.0004 0.00036501884460449
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
315 0.0003 0.0003349781036377
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
316 0.0004 0.00041413307189941
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
317 0.0006 0.00061607360839844
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'