0
  1. My Store
  2. Infusions

Infusions

Browse Categories

Wait! We have a something for you...

Don't leave empty-handed! Simply enter your email below and we will send you a great discount on our products:

We hate spam as much as you do! Your details are never shared and you can unsubscribe at any time.

no thanks

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
3.9658970832825 313 1.5642 0


No Amazon API Requests Made.


App Debug - Total Time 3.9658970832825 seconds

Number Time From Start Name Description
1 2.2703950405121 Initialise Initialise FSB Function
2 2.2893559932709 App Controller Start Start of the App controller (called before the controller of every page)
3 2.9779779911041 App Controller End End of the App controller (called before the controller of every page)
4 2.9798130989075 Category Start Start of the category controller
5 2.9798169136047 Before Get Category Before getting the category information
6 3.0198700428009 After Get Category After getting the category information
7 3.0198719501495 Before Get Category List Before getting the updated category list
8 3.0210349559784 Start of getCategoryListByGroup Function Before first category groups query
9 3.022775888443 After initial query Before first category groups query
10 3.0227789878845 Get Category List for Group Before the call to getCategoryList function
11 3.0227830410004 Start of GetCategoryList function Start of the function
12 3.0227870941162 Before getting categories Query to get specific category list
13 3.0249478816986 After getting categories Query to get specific category list
14 3.0249509811401 Before getting category custom Before call to function getCategoryCustom
15 3.0697391033173 After getting category custom After call to function getCategoryCustom
16 3.0697441101074 Before getting category custom Before call to function getCategoryCustom
17 3.1027820110321 After getting category custom After call to function getCategoryCustom
18 3.1027879714966 Before getting category custom Before call to function getCategoryCustom
19 3.1324090957642 After getting category custom After call to function getCategoryCustom
20 3.1324141025543 Before getting category custom Before call to function getCategoryCustom
21 3.1653409004211 After getting category custom After call to function getCategoryCustom
22 3.1653470993042 Before getting sub category list Before call to recursive function getCategoryList
23 3.1653521060944 Start of GetCategoryList function Start of the function
24 3.1653559207916 Before getting categories Query to get specific category list
25 3.1676120758057 After getting sub category list After call to recursive function getCategoryList
26 3.1676149368286 Before getting category custom Before call to function getCategoryCustom
27 3.187863111496 After getting category custom After call to function getCategoryCustom
28 3.1878678798676 Before getting category custom Before call to function getCategoryCustom
29 3.2034111022949 After getting category custom After call to function getCategoryCustom
30 3.2034161090851 End of GetCategoryList function End of the function
31 3.2034258842468 Get Category List for Group Before the call to getCategoryList function
32 3.203428030014 Start of GetCategoryList function Start of the function
33 3.203430891037 Before getting categories Query to get specific category list
34 3.2054159641266 End of getCategoryListByGroup Function Before return()
35 3.2054200172424 After Get Category List After getting the updated category list
36 3.2054209709167 Before Category Images Before getting the category images
37 3.2076659202576 After Category Images After getting the category images
38 3.2115969657898 Before Sub Category Check Before checking for sub category or products category
39 3.2138199806213 Before Category Products Controller Before loading the category products controller
40 3.2155570983887 Start Category Products Start of Category Products Controller
41 3.2155869007111 After Pagination Options After pagination options in Category Products Controller
42 3.2222108840942 After Cache After Cache checking in Category Products Controller
43 3.2609069347382 After Filter Options After getting filter options and SQL in Category Products Controller
44 3.2654049396515 After Counting Products After counting products in the Category Products Controller
45 3.2676389217377 After Counting Bundles After counting bundles in the Category Products Controller
46 3.2699220180511 After Counting Products After counting products in the Category Products Controller
47 3.2734889984131 After Getting Products After getting products and bundles in the Category Products Controller
48 3.2735440731049 After Pagination Links After getting pagination listing links in the Category Products Controller
49 3.2735450267792 After Getting Bundle Details After getting full details for the bundles in the Category Products Controller
50 3.5883328914642 After Getting Product Details After getting full product details in the Category Products Controller
51 3.613765001297 After Getting Product/Bundle Reviews After getting full product/bundle customer review in the Category Products Controller
52 3.6224160194397 App_after Controller Start Start of the App_after controller (called after the controller of every page)
53 3.6292169094086 Before Get Options Before the call to getOptions in the tpl class
54 3.8343698978424 After Get Options After the call to getOptions in the tpl class
55 3.8346879482269 App_after Controller End End of the App_after controller (called after the controller of every page)
56 3.8347361087799 Before Smarty Before passing everything over to Smarty in the Category Products Controller
57 3.9658589363098 After Loading sub/product controller After checking for sub category or products category and then loading the relevant controller
58 3.9658699035645 Finalizing debug Before the debug is output to the page.
59 3.9658949375153 End of App This is the end of the app logging, final timestamp


Query Debug - 313 Database Queries. Total time 1.5642 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0021 0.0020651817321777 
SELECT parameter, value FROM parameters
2 0.0084 0.0084068775177002 
SELECT * FROM `bad_bots`
3 0.0006 0.00055789947509766 
SET time_zone = 'Europe/London'
4 0.0037 0.0036969184875488 
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0036 0.0036220550537109 
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:12:\"3.145.76.159\";}'
6 0.0033 0.0033290386199951 
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1733349332'
7 0.0043 0.0043067932128906 
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0008 0.00078606605529785 
UPDATE autorun SET lastrun = '2024-12-04 21:55:32' WHERE id = '9'
9 0.0012 0.001162052154541 
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0037 0.003741979598999 
SELECT id FROM pages WHERE pagename = 'infusions' LIMIT 1
11 0.0042 0.0042479038238525 
SELECT id FROM products WHERE pagename = 'infusions' AND hidden = 0 LIMIT 1
12 0.0034 0.0033769607543945 
SELECT id FROM ebay_products WHERE pagename = 'infusions'
13 0.0030 0.0030310153961182 
SELECT id FROM custom_products WHERE pagename = 'infusions'
14 0.0024 0.0024211406707764 
SELECT id FROM categories WHERE pagename = 'infusions' LIMIT 1
15 0.0037 0.0036709308624268 
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
16 0.0290 0.029023885726929 
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
17 0.0007 0.00066208839416504 
SELECT * FROM pages WHERE pagename = 'infusions'
18 0.0031 0.0030598640441895 
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
19 0.0015 0.0015289783477783 
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
20 0.0006 0.0006110668182373 
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
21 0.0014 0.0013799667358398 
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
22 0.0011 0.0011320114135742 
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
23 0.0011 0.0010881423950195 
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
24 0.6371 0.63710498809814 
SELECT * FROM ipgeocountries WHERE INET_ATON('3.145.76.159') >= INET_ATON(ip_start) AND INET_ATON('3.145.76.159') <= INET_ATON(ip_end)
25 0.0033 0.0033359527587891 
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
26 0.0026 0.0025579929351807 
SELECT * FROM countryredirects WHERE countrycode = 'US'
27 0.0016 0.0016288757324219 
SELECT * FROM categories WHERE pagename = 'infusions'
28 0.0029 0.0029499530792236 
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
29 0.0031 0.0031049251556396 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
30 0.0013 0.0013418197631836 
SELECT id FROM categories WHERE parent_id = '29'
31 0.0022 0.0022420883178711 
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
32 0.0034 0.0033900737762451 
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
33 0.0022 0.0022461414337158 
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
34 0.0037 0.0036759376525879 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
35 0.0021 0.0020852088928223 
SELECT id FROM categories WHERE parent_id = '29'
36 0.0024 0.0024240016937256 
SELECT p.id FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (29) AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
37 0.0034 0.0033729076385498 
SELECT * FROM productimages WHERE product_id = '4925' ORDER BY sortorder ASC
38 0.0034 0.0033628940582275 
SELECT * FROM categoryimages WHERE category_id = 29
39 0.0034 0.0033879280090332 
SELECT * FROM categorygroups WHERE id = '1'
40 0.0022 0.0022311210632324 
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 = '29'
		  AND p.offers > 0
		  AND p.hidden = 0
		  AND p.enabled = 1
		  AND p.parent = 0
		  AND p.price > 0
41 0.0023 0.0022621154785156 
SELECT parent_id FROM categories WHERE id = '29'
42 0.0011 0.0011460781097412 
SELECT parent_id FROM categories WHERE id = '29'
43 0.0017 0.0017271041870117 
SELECT * FROM categorygroups ORDER BY sortorder ASC
44 0.0021 0.002129077911377 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
45 0.0175 0.017522096633911 
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
46 0.0022 0.0021870136260986 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
47 0.0015 0.0014870166778564 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
48 0.0019 0.0018579959869385 
SELECT id FROM categories WHERE parent_id = '26'
49 0.0125 0.012547016143799 
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
50 0.0022 0.0022039413452148 
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
51 0.0022 0.0022351741790771 
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
52 0.0022 0.0022048950195312 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
53 0.0023 0.0022811889648438 
SELECT * FROM categorygroups WHERE id = '1'
54 0.0080 0.0079891681671143 
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
55 0.0022 0.002187967300415 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
56 0.0024 0.0023629665374756 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
57 0.0023 0.0023250579833984 
SELECT id FROM categories WHERE parent_id = '27'
58 0.0090 0.0090210437774658 
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
59 0.0022 0.0022261142730713 
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
60 0.0022 0.0022380352020264 
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
61 0.0022 0.0022149085998535 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
62 0.0022 0.0021839141845703 
SELECT * FROM categorygroups WHERE id = '1'
63 0.0045 0.0044870376586914 
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
64 0.0022 0.002223014831543 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
65 0.0023 0.0023000240325928 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
66 0.0022 0.0022239685058594 
SELECT id FROM categories WHERE parent_id = '28'
67 0.0061 0.0060920715332031 
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
68 0.0026 0.002622127532959 
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
69 0.0037 0.00370192527771 
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
70 0.0031 0.0030598640441895 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
71 0.0026 0.0026159286499023 
SELECT * FROM categorygroups WHERE id = '1'
72 0.0040 0.0039730072021484 
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
73 0.0038 0.0038118362426758 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
74 0.0038 0.0037710666656494 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
75 0.0031 0.0031390190124512 
SELECT id FROM categories WHERE parent_id = '29'
76 0.0037 0.0037188529968262 
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
77 0.0031 0.0030519962310791 
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
78 0.0044 0.0044419765472412 
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
79 0.0047 0.0046589374542236 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
80 0.0022 0.0021569728851318 
SELECT * FROM categorygroups WHERE id = '1'
81 0.0022 0.0022380352020264 
SELECT * FROM categories WHERE parent_id = '29'  AND hidden = 0 ORDER BY sortorder ASC
82 0.0022 0.0022470951080322 
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
83 0.0023 0.002269983291626 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
84 0.0023 0.0022528171539307 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
85 0.0022 0.0022459030151367 
SELECT id FROM categories WHERE parent_id = '30'
86 0.0023 0.0022530555725098 
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
87 0.0022 0.0022470951080322 
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
88 0.0022 0.002234935760498 
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
89 0.0024 0.0023801326751709 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
90 0.0020 0.001964807510376 
SELECT * FROM categorygroups WHERE id = '1'
91 0.0018 0.001784086227417 
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
92 0.0016 0.0016498565673828 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
93 0.0016 0.0016169548034668 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
94 0.0013 0.0012550354003906 
SELECT id FROM categories WHERE parent_id = '31'
95 0.0021 0.0020990371704102 
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
96 0.0022 0.0022459030151367 
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
97 0.0015 0.0014560222625732 
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
98 0.0019 0.0018930435180664 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
99 0.0014 0.0013909339904785 
SELECT * FROM categorygroups WHERE id = '1'
100 0.0020 0.0019640922546387 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
101 0.0022 0.002230167388916 
SELECT * FROM categoryimages WHERE category_id = 29
102 0.0039 0.0038559436798096 
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
103 0.0022 0.002190113067627 
SELECT * FROM categories WHERE parent_id = '29'
104 0.0158 0.015846967697144 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
105 0.0043 0.0042729377746582 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
106 0.0033 0.0032839775085449 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
107 0.0089 0.0089499950408936 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
108 0.0033 0.0033090114593506 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
109 0.0023 0.0022859573364258 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
110 0.0022 0.0021770000457764 
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 = 29
		AND (c.prod_type = '' OR c.prod_type = 'amz')
		AND hidden = 0
		AND enabled = 1
		
		AND 1 = 1
111 0.0022 0.0022318363189697 
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
		WHERE ep.id = c.product_id
		AND c.category_id = 29
		AND c.prod_type = 'ebay'
		AND hide = 0
112 0.0022 0.0022029876708984 
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 = 29
			AND p.disabled = 0
			
			AND 1 = 1
113 0.0022 0.0022358894348145 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
		WHERE cp.id = c.product_id
		AND c.category_id = 29
		AND c.prod_type = 'custom'
		AND hide = 0
114 0.0035 0.0034759044647217 
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 = 29
			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 = 29
		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 = 29
		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 = 29
			AND disabled = 0
			
			AND 1 = 1 ORDER BY salesrank ASC LIMIT 0, 18
115 0.0022 0.0021500587463379 
SELECT * FROM products WHERE id = '4925'
116 0.0022 0.0021820068359375 
SELECT * FROM productimages WHERE product_id = '4925' ORDER BY sortorder ASC
117 0.0040 0.0040130615234375 
SELECT * FROM product_image_select WHERE product_id = '4925'
118 0.0027 0.0026688575744629 
SELECT * FROM productcustomimages WHERE product_id = '4925'
119 0.0023 0.0022580623626709 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4925' AND a.name = n.originalname
120 0.0023 0.0023400783538818 
SELECT * FROM productoffers WHERE product_id = '4925' AND merchantid = 'A1X6FK5RDHNB96'
121 0.0022 0.0021569728851318 
SELECT * FROM productoffers
                WHERE product_id = '4925' AND price > 0
                ORDER BY price ASC LIMIT 1
122 0.0022 0.0021591186523438 
SELECT value FROM productattributes WHERE product_id = '4925' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
123 0.0022 0.002249002456665 
SELECT * FROM products WHERE id = '4919'
124 0.0022 0.0022180080413818 
SELECT * FROM productimages WHERE product_id = '4919' ORDER BY sortorder ASC
125 0.0025 0.002500057220459 
SELECT * FROM product_image_select WHERE product_id = '4919'
126 0.0029 0.0029220581054688 
SELECT * FROM productcustomimages WHERE product_id = '4919'
127 0.0029 0.0029199123382568 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4919' AND a.name = n.originalname
128 0.0029 0.0029489994049072 
SELECT * FROM productoffers WHERE product_id = '4919' AND merchantid = 'A1X6FK5RDHNB96'
129 0.0045 0.0044829845428467 
SELECT * FROM productoffers
                WHERE product_id = '4919' AND price > 0
                ORDER BY price ASC LIMIT 1
130 0.0039 0.0039188861846924 
SELECT value FROM productattributes WHERE product_id = '4919' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
131 0.0043 0.0043280124664307 
SELECT * FROM products WHERE id = '4924'
132 0.0039 0.0038621425628662 
SELECT * FROM productimages WHERE product_id = '4924' ORDER BY sortorder ASC
133 0.0044 0.0043549537658691 
SELECT * FROM product_image_select WHERE product_id = '4924'
134 0.0023 0.0022609233856201 
SELECT * FROM productcustomimages WHERE product_id = '4924'
135 0.0032 0.0032379627227783 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4924' AND a.name = n.originalname
136 0.0059 0.005875825881958 
SELECT * FROM productoffers WHERE product_id = '4924' AND merchantid = 'A1X6FK5RDHNB96'
137 0.0023 0.002255916595459 
SELECT * FROM productoffers
                WHERE product_id = '4924' AND price > 0
                ORDER BY price ASC LIMIT 1
138 0.0021 0.0021450519561768 
SELECT value FROM productattributes WHERE product_id = '4924' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
139 0.0023 0.002310037612915 
SELECT * FROM products WHERE id = '4918'
140 0.0023 0.0022900104522705 
SELECT * FROM productimages WHERE product_id = '4918' ORDER BY sortorder ASC
141 0.0022 0.0021598339080811 
SELECT * FROM product_image_select WHERE product_id = '4918'
142 0.0022 0.0022420883178711 
SELECT * FROM productcustomimages WHERE product_id = '4918'
143 0.0032 0.0032229423522949 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4918' AND a.name = n.originalname
144 0.0022 0.0022168159484863 
SELECT * FROM productoffers WHERE product_id = '4918' AND merchantid = 'A1X6FK5RDHNB96'
145 0.0024 0.0024449825286865 
SELECT * FROM productoffers
                WHERE product_id = '4918' AND price > 0
                ORDER BY price ASC LIMIT 1
146 0.0021 0.0021140575408936 
SELECT * FROM productoffers
                WHERE product_id = 4918
                ORDER BY price ASC LIMIT 1
147 0.0023 0.0023250579833984 
SELECT value FROM productattributes
                WHERE product_id = '4918'
                AND name = 'ListPriceAmount'
148 0.0022 0.0022249221801758 
SELECT value FROM productattributes WHERE product_id = '4918' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
149 0.0023 0.0023190975189209 
SELECT * FROM products WHERE id = '4917'
150 0.0022 0.002161979675293 
SELECT * FROM productimages WHERE product_id = '4917' ORDER BY sortorder ASC
151 0.0022 0.0022051334381104 
SELECT * FROM product_image_select WHERE product_id = '4917'
152 0.0019 0.0018701553344727 
SELECT * FROM productcustomimages WHERE product_id = '4917'
153 0.0070 0.0070021152496338 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4917' AND a.name = n.originalname
154 0.0022 0.0021750926971436 
SELECT * FROM productoffers WHERE product_id = '4917' AND merchantid = 'A1X6FK5RDHNB96'
155 0.0023 0.0022861957550049 
SELECT * FROM productoffers
                WHERE product_id = '4917' AND price > 0
                ORDER BY price ASC LIMIT 1
156 0.0021 0.0021448135375977 
SELECT value FROM productattributes WHERE product_id = '4917' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
157 0.0023 0.0023000240325928 
SELECT * FROM products WHERE id = '4915'
158 0.0022 0.0022151470184326 
SELECT * FROM productimages WHERE product_id = '4915' ORDER BY sortorder ASC
159 0.0022 0.0021610260009766 
SELECT * FROM product_image_select WHERE product_id = '4915'
160 0.0018 0.001798152923584 
SELECT * FROM productcustomimages WHERE product_id = '4915'
161 0.0026 0.0026381015777588 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4915' AND a.name = n.originalname
162 0.0022 0.0022280216217041 
SELECT * FROM productoffers WHERE product_id = '4915' AND merchantid = 'A1X6FK5RDHNB96'
163 0.0022 0.002249002456665 
SELECT * FROM productoffers
                WHERE product_id = '4915' AND price > 0
                ORDER BY price ASC LIMIT 1
164 0.0023 0.0022621154785156 
SELECT * FROM productoffers
                WHERE product_id = 4915
                ORDER BY price ASC LIMIT 1
165 0.0011 0.0011129379272461 
SELECT value FROM productattributes
                WHERE product_id = '4915'
                AND name = 'ListPriceAmount'
166 0.0022 0.0022311210632324 
SELECT value FROM productattributes WHERE product_id = '4915' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
167 0.0023 0.0022928714752197 
SELECT * FROM products WHERE id = '4914'
168 0.0022 0.0021820068359375 
SELECT * FROM productimages WHERE product_id = '4914' ORDER BY sortorder ASC
169 0.0022 0.002230167388916 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4914' AND p.id = pi.product_id ORDER BY pi.sortorder
170 0.0023 0.0022621154785156 
SELECT * FROM product_image_select WHERE product_id = '4914'
171 0.0023 0.0022749900817871 
SELECT * FROM productcustomimages WHERE product_id = '4914'
172 0.0021 0.0021069049835205 
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 = '4914'
                GROUP BY o.product_id
173 0.0080 0.0079758167266846 
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     = '4914'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
174 0.0053 0.0052971839904785 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4914
175 0.0036 0.0036330223083496 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4914' AND a.name = n.originalname
176 0.0022 0.0022068023681641 
SELECT * FROM productoffers WHERE product_id = '4914' AND merchantid = 'A1X6FK5RDHNB96'
177 0.0023 0.0023088455200195 
SELECT * FROM productoffers
                WHERE product_id = '4914' AND price > 0
                ORDER BY price ASC LIMIT 1
178 0.0022 0.0021958351135254 
SELECT * FROM productoffers
                WHERE product_id = 4914
                ORDER BY price ASC LIMIT 1
179 0.0022 0.0022289752960205 
SELECT value FROM productattributes
                WHERE product_id = '4914'
                AND name = 'ListPriceAmount'
180 0.0022 0.0022070407867432 
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 = '4914'
                GROUP BY o.product_id
181 0.0022 0.0022430419921875 
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     = '4914'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
182 0.0022 0.0022420883178711 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4914
183 0.0022 0.0022289752960205 
SELECT value FROM productattributes WHERE product_id = '4914' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
184 0.0023 0.002310037612915 
SELECT * FROM products WHERE parent_id = '4914'
185 0.0023 0.002269983291626 
SELECT * FROM products WHERE id = '4916'
186 0.0023 0.0022830963134766 
SELECT * FROM productimages WHERE product_id = '4916' ORDER BY sortorder ASC
187 0.0022 0.0021688938140869 
SELECT * FROM product_image_select WHERE product_id = '4916'
188 0.0023 0.0022509098052979 
SELECT * FROM productcustomimages WHERE product_id = '4916'
189 0.0044 0.0044300556182861 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4916' AND a.name = n.originalname
190 0.0021 0.0021438598632812 
SELECT * FROM productoffers WHERE product_id = '4916' AND merchantid = 'A1X6FK5RDHNB96'
191 0.0023 0.0022540092468262 
SELECT * FROM productoffers
                WHERE product_id = '4916' AND price > 0
                ORDER BY price ASC LIMIT 1
192 0.0022 0.0021920204162598 
SELECT * FROM productoffers
                WHERE product_id = 4916
                ORDER BY price ASC LIMIT 1
193 0.0022 0.0022079944610596 
SELECT value FROM productattributes
                WHERE product_id = '4916'
                AND name = 'ListPriceAmount'
194 0.0023 0.002302885055542 
SELECT value FROM productattributes WHERE product_id = '4916' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
195 0.0022 0.0022389888763428 
SELECT * FROM products WHERE id = '4920'
196 0.0022 0.0021729469299316 
SELECT * FROM productimages WHERE product_id = '4920' ORDER BY sortorder ASC
197 0.0028 0.0027778148651123 
SELECT * FROM product_image_select WHERE product_id = '4920'
198 0.0022 0.0022330284118652 
SELECT * FROM productcustomimages WHERE product_id = '4920'
199 0.0044 0.0043749809265137 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4920' AND a.name = n.originalname
200 0.0022 0.0021800994873047 
SELECT * FROM productoffers WHERE product_id = '4920' AND merchantid = 'A1X6FK5RDHNB96'
201 0.0023 0.0022609233856201 
SELECT * FROM productoffers
                WHERE product_id = '4920' AND price > 0
                ORDER BY price ASC LIMIT 1
202 0.0022 0.0022399425506592 
SELECT * FROM productoffers
                WHERE product_id = 4920
                ORDER BY price ASC LIMIT 1
203 0.0022 0.0022170543670654 
SELECT value FROM productattributes
                WHERE product_id = '4920'
                AND name = 'ListPriceAmount'
204 0.0022 0.0022199153900146 
SELECT value FROM productattributes WHERE product_id = '4920' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
205 0.0023 0.0022931098937988 
SELECT * FROM products WHERE id = '4923'
206 0.0022 0.002194881439209 
SELECT * FROM productimages WHERE product_id = '4923' ORDER BY sortorder ASC
207 0.0022 0.0021800994873047 
SELECT * FROM product_image_select WHERE product_id = '4923'
208 0.0023 0.0022649765014648 
SELECT * FROM productcustomimages WHERE product_id = '4923'
209 0.0038 0.0038290023803711 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4923' AND a.name = n.originalname
210 0.0016 0.0016191005706787 
SELECT * FROM productoffers WHERE product_id = '4923' AND merchantid = 'A1X6FK5RDHNB96'
211 0.0023 0.0022609233856201 
SELECT * FROM productoffers
                WHERE product_id = '4923' AND price > 0
                ORDER BY price ASC LIMIT 1
212 0.0014 0.0014019012451172 
SELECT * FROM productoffers
                WHERE product_id = 4923
                ORDER BY price ASC LIMIT 1
213 0.0020 0.0019631385803223 
SELECT value FROM productattributes
                WHERE product_id = '4923'
                AND name = 'ListPriceAmount'
214 0.0011 0.0010840892791748 
SELECT value FROM productattributes WHERE product_id = '4923' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
215 0.0023 0.0023128986358643 
SELECT * FROM products WHERE id = '4922'
216 0.0022 0.0021741390228271 
SELECT * FROM productimages WHERE product_id = '4922' ORDER BY sortorder ASC
217 0.0022 0.002241849899292 
SELECT * FROM product_image_select WHERE product_id = '4922'
218 0.0022 0.0022339820861816 
SELECT * FROM productcustomimages WHERE product_id = '4922'
219 0.0042 0.0042328834533691 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4922' AND a.name = n.originalname
220 0.0023 0.0023319721221924 
SELECT * FROM productoffers WHERE product_id = '4922' AND merchantid = 'A1X6FK5RDHNB96'
221 0.0023 0.0022778511047363 
SELECT * FROM productoffers
                WHERE product_id = '4922' AND price > 0
                ORDER BY price ASC LIMIT 1
222 0.0022 0.0022261142730713 
SELECT * FROM productoffers
                WHERE product_id = 4922
                ORDER BY price ASC LIMIT 1
223 0.0022 0.0022180080413818 
SELECT value FROM productattributes
                WHERE product_id = '4922'
                AND name = 'ListPriceAmount'
224 0.0022 0.0022239685058594 
SELECT value FROM productattributes WHERE product_id = '4922' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
225 0.0023 0.0023231506347656 
SELECT * FROM products WHERE id = '4921'
226 0.0022 0.00217604637146 
SELECT * FROM productimages WHERE product_id = '4921' ORDER BY sortorder ASC
227 0.0022 0.002194881439209 
SELECT * FROM product_image_select WHERE product_id = '4921'
228 0.0024 0.0023939609527588 
SELECT * FROM productcustomimages WHERE product_id = '4921'
229 0.0057 0.0057339668273926 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4921' AND a.name = n.originalname
230 0.0032 0.0032470226287842 
SELECT * FROM productoffers WHERE product_id = '4921' AND merchantid = 'A1X6FK5RDHNB96'
231 0.0031 0.0030930042266846 
SELECT * FROM productoffers
                WHERE product_id = '4921' AND price > 0
                ORDER BY price ASC LIMIT 1
232 0.0023 0.002324104309082 
SELECT value FROM productattributes WHERE product_id = '4921' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
233 0.0046 0.0045530796051025 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4925' ORDER BY timestamp DESC
234 0.0021 0.0021159648895264 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4919' ORDER BY timestamp DESC
235 0.0022 0.0021898746490479 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4924' ORDER BY timestamp DESC
236 0.0019 0.0019030570983887 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4918' ORDER BY timestamp DESC
237 0.0015 0.0015239715576172 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4917' ORDER BY timestamp DESC
238 0.0016 0.0016059875488281 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4915' ORDER BY timestamp DESC
239 0.0017 0.00173020362854 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4914' ORDER BY timestamp DESC
240 0.0022 0.0022451877593994 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4916' ORDER BY timestamp DESC
241 0.0018 0.0017731189727783 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4920' ORDER BY timestamp DESC
242 0.0016 0.0016131401062012 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4923' ORDER BY timestamp DESC
243 0.0022 0.0022108554840088 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4922' ORDER BY timestamp DESC
244 0.0015 0.0015308856964111 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4921' ORDER BY timestamp DESC
245 0.0029 0.0029010772705078 
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 = 29
		AND c.prod_type = 'ebay'
		AND hide = 0
246 0.0022 0.0022449493408203 
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
247 0.0017 0.0017290115356445 
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
248 0.0044 0.0044341087341309 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
249 0.0022 0.0022199153900146 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
250 0.0358 0.035786151885986 
SELECT p.id,p.parent_id, o.price,p.asin FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND hidden = 0 AND offers > 0 AND (SELECT COUNT(pi.id) FROM productimages pi WHERE pi.product_id = p.id) > 1 AND o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price)) ORDER BY p.title DESC LIMIT 6
251 0.0033 0.0032870769500732 
SELECT p.id,p.price,p.listingtype FROM ebay_products p WHERE hide = 0 AND (SELECT COUNT(pi.id) FROM ebay_prod_images pi WHERE pi.prodid = p.id) > 1 ORDER BY p.title DESC LIMIT 6
252 0.0022 0.0022258758544922 
SELECT p.id,p.price,p.currency FROM custom_products p WHERE hide = 0 AND orginalprice > 0 AND (SELECT COUNT(pi.id) FROM productcustomimages pi WHERE pi.product_id = p.id) > 1 ORDER BY p.title DESC LIMIT 6
253 0.0023 0.0022909641265869 
SELECT * FROM products WHERE id = 1626
254 0.0016 0.001633882522583 
SELECT * FROM products WHERE id = 4041
255 0.0019 0.0018789768218994 
SELECT * FROM products WHERE id = 4312
256 0.0022 0.002194881439209 
SELECT * FROM products WHERE id = 777
257 0.0022 0.0021500587463379 
SELECT * FROM products WHERE id = 3881
258 0.0024 0.0023880004882812 
SELECT * FROM products WHERE id = 4213
259 0.0020 0.0019969940185547 
SELECT * FROM products WHERE id = '1626'
260 0.0025 0.0024650096893311 
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
261 0.0022 0.0022401809692383 
SELECT * FROM product_image_select WHERE product_id = '1626'
262 0.0022 0.0022430419921875 
SELECT * FROM productcustomimages WHERE product_id = '1626'
263 0.0026 0.0025589466094971 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
264 0.0019 0.0018501281738281 
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
265 0.0022 0.0022280216217041 
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
266 0.0022 0.0021908283233643 
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
267 0.0035 0.0034959316253662 
SELECT * FROM products WHERE id = '4041'
268 0.0021 0.0021419525146484 
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
269 0.0034 0.0033609867095947 
SELECT * FROM product_image_select WHERE product_id = '4041'
270 0.0034 0.0034010410308838 
SELECT * FROM productcustomimages WHERE product_id = '4041'
271 0.0066 0.0066161155700684 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
272 0.0022 0.0021920204162598 
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
273 0.0045 0.0045459270477295 
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
274 0.0021 0.002147912979126 
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
275 0.0023 0.0022990703582764 
SELECT * FROM products WHERE id = '4312'
276 0.0022 0.0021870136260986 
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
277 0.0022 0.0022280216217041 
SELECT * FROM product_image_select WHERE product_id = '4312'
278 0.0019 0.0019130706787109 
SELECT * FROM productcustomimages WHERE product_id = '4312'
279 0.0030 0.0030248165130615 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
280 0.0017 0.0016658306121826 
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
281 0.0023 0.0022671222686768 
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
282 0.0022 0.0021910667419434 
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
283 0.0023 0.002312183380127 
SELECT * FROM products WHERE id = '777'
284 0.0022 0.0022339820861816 
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
285 0.0022 0.002223014831543 
SELECT * FROM product_image_select WHERE product_id = '777'
286 0.0022 0.0022058486938477 
SELECT * FROM productcustomimages WHERE product_id = '777'
287 0.0033 0.0032780170440674 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
288 0.0022 0.0022361278533936 
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
289 0.0022 0.0022139549255371 
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
290 0.0019 0.0019099712371826 
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
291 0.0023 0.0022938251495361 
SELECT * FROM products WHERE id = '3881'
292 0.0022 0.0022430419921875 
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
293 0.0022 0.002194881439209 
SELECT * FROM product_image_select WHERE product_id = '3881'
294 0.0024 0.0023961067199707 
SELECT * FROM productcustomimages WHERE product_id = '3881'
295 0.0032 0.00323486328125 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
296 0.0022 0.0022430419921875 
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
297 0.0023 0.0022640228271484 
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
298 0.0022 0.0021939277648926 
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
299 0.0023 0.0023090839385986 
SELECT * FROM products WHERE id = '4213'
300 0.0023 0.0022530555725098 
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
301 0.0025 0.0024809837341309 
SELECT * FROM product_image_select WHERE product_id = '4213'
302 0.0019 0.0019469261169434 
SELECT * FROM productcustomimages WHERE product_id = '4213'
303 0.0037 0.0036921501159668 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
304 0.0021 0.0020911693572998 
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
305 0.0023 0.0023021697998047 
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
306 0.0022 0.0021679401397705 
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
307 0.0056 0.0055809020996094 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
308 0.0023 0.0022749900817871 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
309 0.0093 0.0093080997467041 
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
310 0.0052 0.0052320957183838 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
311 0.0021 0.0020530223846436 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
312 0.0045 0.0044968128204346 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
313 0.0021 0.0021450519561768 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'