0
  1. My Store
  2. Boîtes à thé

Boîtes à thé

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
1.1472709178925 406 0.2966 0


No Amazon API Requests Made.


App Debug - Total Time 1.1472709178925 seconds

Number Time From Start Name Description
1 0.80483603477478 Initialise Initialise FSB Function
2 0.80712699890137 App Controller Start Start of the App controller (called before the controller of every page)
3 0.8967969417572 App Controller End End of the App controller (called before the controller of every page)
4 0.89704298973083 Category Start Start of the category controller
5 0.89705109596252 Before Get Category Before getting the category information
6 0.90153789520264 After Get Category After getting the category information
7 0.90154004096985 Before Get Category List Before getting the updated category list
8 0.90180492401123 Start of getCategoryListByGroup Function Before first category groups query
9 0.90208697319031 After initial query Before first category groups query
10 0.90209007263184 Get Category List for Group Before the call to getCategoryList function
11 0.90209293365479 Start of GetCategoryList function Start of the function
12 0.90209603309631 Before getting categories Query to get specific category list
13 0.90240502357483 After getting categories Query to get specific category list
14 0.90240693092346 Before getting category custom Before call to function getCategoryCustom
15 0.90476298332214 After getting category custom After call to function getCategoryCustom
16 0.90476608276367 Before getting sub category list Before call to recursive function getCategoryList
17 0.9047679901123 Start of GetCategoryList function Start of the function
18 0.90477204322815 Before getting categories Query to get specific category list
19 0.9050440788269 After getting sub category list After call to recursive function getCategoryList
20 0.90504598617554 Before getting category custom Before call to function getCategoryCustom
21 0.90736889839172 After getting category custom After call to function getCategoryCustom
22 0.90737295150757 Before getting category custom Before call to function getCategoryCustom
23 0.90979099273682 After getting category custom After call to function getCategoryCustom
24 0.90979504585266 Before getting category custom Before call to function getCategoryCustom
25 0.91221499443054 After getting category custom After call to function getCategoryCustom
26 0.91221809387207 Before getting category custom Before call to function getCategoryCustom
27 0.91462087631226 After getting category custom After call to function getCategoryCustom
28 0.91462397575378 Before getting category custom Before call to function getCategoryCustom
29 0.91699290275574 After getting category custom After call to function getCategoryCustom
30 0.91699504852295 End of GetCategoryList function End of the function
31 0.91700196266174 Get Category List for Group Before the call to getCategoryList function
32 0.91700387001038 Start of GetCategoryList function Start of the function
33 0.91700601577759 Before getting categories Query to get specific category list
34 0.91728401184082 End of getCategoryListByGroup Function Before return()
35 0.91728806495667 After Get Category List After getting the updated category list
36 0.9172899723053 Before Category Images Before getting the category images
37 0.91753792762756 After Category Images After getting the category images
38 0.91791796684265 Before Sub Category Check Before checking for sub category or products category
39 0.91820597648621 Before Category Products Controller Before loading the category products controller
40 0.91858601570129 Start Category Products Start of Category Products Controller
41 0.91860604286194 After Pagination Options After pagination options in Category Products Controller
42 0.91900491714478 After Cache After Cache checking in Category Products Controller
43 0.92094993591309 After Filter Options After getting filter options and SQL in Category Products Controller
44 0.92158794403076 After Counting Products After counting products in the Category Products Controller
45 0.92184591293335 After Counting Bundles After counting bundles in the Category Products Controller
46 0.9222149848938 After Counting Products After counting products in the Category Products Controller
47 0.94149088859558 After Getting Products After getting products and bundles in the Category Products Controller
48 0.94158291816711 After Pagination Links After getting pagination listing links in the Category Products Controller
49 0.94158601760864 After Getting Bundle Details After getting full details for the bundles in the Category Products Controller
50 1.0735280513763 After Getting Product Details After getting full product details in the Category Products Controller
51 1.0808079242706 After Getting Product/Bundle Reviews After getting full product/bundle customer review in the Category Products Controller
52 1.0822138786316 App_after Controller Start Start of the App_after controller (called after the controller of every page)
53 1.0828399658203 Before Get Options Before the call to getOptions in the tpl class
54 1.1061589717865 After Get Options After the call to getOptions in the tpl class
55 1.1063199043274 App_after Controller End End of the App_after controller (called after the controller of every page)
56 1.1063520908356 Before Smarty Before passing everything over to Smarty in the Category Products Controller
57 1.147234916687 After Loading sub/product controller After checking for sub category or products category and then loading the relevant controller
58 1.1472449302673 Finalizing debug Before the debug is output to the page.
59 1.1472690105438 End of App This is the end of the app logging, final timestamp


Query Debug - 406 Database Queries. Total time 0.2966 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0006 0.00060915946960449 
SELECT parameter, value FROM parameters
2 0.0015 0.0015168190002441 
SELECT * FROM `bad_bots`
3 0.0005 0.0004889965057373 
SET time_zone = 'Europe/London'
4 0.0004 0.00041985511779785 
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0010 0.0010280609130859 
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"18.189.22.136\";}'
6 0.0007 0.00066995620727539 
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1714370418'
7 0.0010 0.0010440349578857 
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0006 0.00056195259094238 
UPDATE autorun SET lastrun = '2024-04-29 06:00:18' WHERE id = '13'
9 0.0004 0.00036287307739258 
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0003 0.00030303001403809 
SELECT id FROM pages WHERE pagename = 'boites-the' LIMIT 1
11 0.0003 0.00029492378234863 
SELECT id FROM products WHERE pagename = 'boites-the' AND hidden = 0 LIMIT 1
12 0.0003 0.00028800964355469 
SELECT id FROM ebay_products WHERE pagename = 'boites-the'
13 0.0003 0.00032401084899902 
SELECT id FROM custom_products WHERE pagename = 'boites-the'
14 0.0004 0.00037097930908203 
SELECT id FROM categories WHERE pagename = 'boites-the' LIMIT 1
15 0.0007 0.00068902969360352 
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
16 0.0008 0.00080704689025879 
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
17 0.0004 0.00039291381835938 
SELECT * FROM pages WHERE pagename = 'boites-the'
18 0.0004 0.00036311149597168 
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
19 0.0005 0.00047683715820312 
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
20 0.0003 0.0003199577331543 
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.0003 0.00029683113098145 
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
22 0.0003 0.00033807754516602 
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
23 0.0007 0.00074386596679688 
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
24 0.0832 0.083176136016846 
SELECT * FROM ipgeocountries WHERE INET_ATON('18.189.22.136') >= INET_ATON(ip_start) AND INET_ATON('18.189.22.136') <= INET_ATON(ip_end)
25 0.0004 0.00035405158996582 
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
26 0.0003 0.00030612945556641 
SELECT * FROM countryredirects WHERE countrycode = 'US'
27 0.0003 0.00034999847412109 
SELECT * FROM categories WHERE pagename = 'boites-the'
28 0.0003 0.00027203559875488 
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
29 0.0003 0.00028800964355469 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
30 0.0003 0.00028109550476074 
SELECT id FROM categories WHERE parent_id = '26'
31 0.0003 0.00027608871459961 
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
32 0.0003 0.00031399726867676 
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
33 0.0003 0.00032711029052734 
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
34 0.0003 0.00026798248291016 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
35 0.0003 0.00029492378234863 
SELECT id FROM categories WHERE parent_id = '26'
36 0.0003 0.00026106834411621 
SELECT p.id FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (26) 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.0003 0.00031113624572754 
SELECT * FROM productimages WHERE product_id = '4122' ORDER BY sortorder ASC
38 0.0003 0.00027108192443848 
SELECT * FROM categoryimages WHERE category_id = 26
39 0.0003 0.00025796890258789 
SELECT * FROM categorygroups WHERE id = '1'
40 0.0002 0.00024008750915527 
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 = '26'
		  AND p.offers > 0
		  AND p.hidden = 0
		  AND p.enabled = 1
		  AND p.parent = 0
		  AND p.price > 0
41 0.0003 0.00026702880859375 
SELECT parent_id FROM categories WHERE id = '26'
42 0.0003 0.00025200843811035 
SELECT parent_id FROM categories WHERE id = '26'
43 0.0003 0.00027108192443848 
SELECT * FROM categorygroups ORDER BY sortorder ASC
44 0.0003 0.00028800964355469 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
45 0.0003 0.00031304359436035 
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.0003 0.00028800964355469 
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.0003 0.00027108192443848 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
48 0.0002 0.00022506713867188 
SELECT id FROM categories WHERE parent_id = '26'
49 0.0002 0.00022721290588379 
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.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
51 0.0002 0.00021004676818848 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
52 0.0002 0.0002281665802002 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
53 0.0002 0.00022387504577637 
SELECT * FROM categorygroups WHERE id = '1'
54 0.0003 0.0002589225769043 
SELECT * FROM categories WHERE parent_id = '26'  AND hidden = 0 ORDER BY sortorder ASC
55 0.0002 0.00023698806762695 
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
56 0.0003 0.00025200843811035 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
57 0.0002 0.00023913383483887 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
58 0.0002 0.00024890899658203 
SELECT id FROM categories WHERE parent_id = '27'
59 0.0002 0.00024604797363281 
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
60 0.0002 0.00023698806762695 
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
61 0.0003 0.00025296211242676 
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
62 0.0003 0.00025701522827148 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
63 0.0002 0.00023603439331055 
SELECT * FROM categorygroups WHERE id = '1'
64 0.0003 0.00025200843811035 
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
65 0.0002 0.00024580955505371 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
66 0.0003 0.00026297569274902 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
67 0.0002 0.00023603439331055 
SELECT id FROM categories WHERE parent_id = '28'
68 0.0003 0.00027704238891602 
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
69 0.0003 0.00025105476379395 
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
70 0.0003 0.00027894973754883 
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
71 0.0002 0.00023603439331055 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
72 0.0003 0.00025391578674316 
SELECT * FROM categorygroups WHERE id = '1'
73 0.0002 0.00024604797363281 
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
74 0.0002 0.00022101402282715 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
75 0.0003 0.00025486946105957 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
76 0.0003 0.00028300285339355 
SELECT id FROM categories WHERE parent_id = '29'
77 0.0003 0.00026321411132812 
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
78 0.0002 0.00023388862609863 
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
79 0.0003 0.00025081634521484 
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
80 0.0002 0.0002439022064209 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
81 0.0003 0.00029993057250977 
SELECT * FROM categorygroups WHERE id = '1'
82 0.0002 0.00023412704467773 
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.0003 0.00028109550476074 
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.0002 0.0002439022064209 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
85 0.0003 0.00025296211242676 
SELECT id FROM categories WHERE parent_id = '30'
86 0.0003 0.00025701522827148 
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.0003 0.00026512145996094 
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.0002 0.00024104118347168 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
89 0.0002 0.00023698806762695 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
90 0.0003 0.00026917457580566 
SELECT * FROM categorygroups WHERE id = '1'
91 0.0003 0.00025796890258789 
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.0003 0.00025510787963867 
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.0002 0.00024294853210449 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
94 0.0002 0.00023198127746582 
SELECT id FROM categories WHERE parent_id = '31'
95 0.0003 0.00027894973754883 
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.0002 0.00022506713867188 
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.0003 0.00026512145996094 
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.0002 0.00023698806762695 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
99 0.0003 0.00025510787963867 
SELECT * FROM categorygroups WHERE id = '1'
100 0.0003 0.00026202201843262 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
101 0.0002 0.00023698806762695 
SELECT * FROM categoryimages WHERE category_id = 26
102 0.0003 0.00034189224243164 
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
103 0.0003 0.00027084350585938 
SELECT * FROM categories WHERE parent_id = '26'
104 0.0003 0.0002741813659668 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
105 0.0003 0.0002901554107666 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
106 0.0002 0.00024914741516113 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
107 0.0003 0.00026893615722656 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
108 0.0003 0.00030899047851562 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
109 0.0003 0.00031185150146484 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
110 0.0003 0.00030899047851562 
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 = 26
		AND (c.prod_type = '' OR c.prod_type = 'amz')
		AND hidden = 0
		AND enabled = 1
		
		AND 1 = 1
111 0.0003 0.00030684471130371 
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
		WHERE ep.id = c.product_id
		AND c.category_id = 26
		AND c.prod_type = 'ebay'
		AND hide = 0
112 0.0002 0.00024700164794922 
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 = 26
			AND p.disabled = 0
			
			AND 1 = 1
113 0.0004 0.00035786628723145 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
		WHERE cp.id = c.product_id
		AND c.category_id = 26
		AND c.prod_type = 'custom'
		AND hide = 0
114 0.0192 0.019211053848267 
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 = 26
			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 = 26
		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 = 26
		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 = 26
			AND disabled = 0
			
			AND 1 = 1 ORDER BY salesrank ASC LIMIT 162, 18
115 0.0006 0.00062704086303711 
SELECT * FROM products WHERE id = '2896'
116 0.0005 0.00048494338989258 
SELECT * FROM productimages WHERE product_id = '2896' ORDER BY sortorder ASC
117 0.0004 0.00041007995605469 
SELECT * FROM product_image_select WHERE product_id = '2896'
118 0.0004 0.00037217140197754 
SELECT * FROM productcustomimages WHERE product_id = '2896'
119 0.0013 0.0013258457183838 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2896' AND a.name = n.originalname
120 0.0005 0.00047898292541504 
SELECT * FROM productoffers WHERE product_id = '2896' AND merchantid = 'A1X6FK5RDHNB96'
121 0.0004 0.00039887428283691 
SELECT * FROM productoffers
                WHERE product_id = '2896' AND price > 0
                ORDER BY price ASC LIMIT 1
122 0.0004 0.00036191940307617 
SELECT * FROM productoffers
                WHERE product_id = 2896
                ORDER BY price ASC LIMIT 1
123 0.0004 0.00040984153747559 
SELECT value FROM productattributes
                WHERE product_id = '2896'
                AND name = 'ListPriceAmount'
124 0.0005 0.00045204162597656 
SELECT value FROM productattributes WHERE product_id = '2896' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
125 0.0006 0.00061392784118652 
SELECT * FROM products WHERE id = '1599'
126 0.0004 0.00044512748718262 
SELECT * FROM productimages WHERE product_id = '1599' ORDER BY sortorder ASC
127 0.0003 0.00031089782714844 
SELECT * FROM product_image_select WHERE product_id = '1599'
128 0.0002 0.00023388862609863 
SELECT * FROM productcustomimages WHERE product_id = '1599'
129 0.0002 0.00024700164794922 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1599' AND a.name = n.originalname
130 0.0003 0.00025296211242676 
SELECT * FROM productoffers WHERE product_id = '1599' AND merchantid = 'A1X6FK5RDHNB96'
131 0.0003 0.00029277801513672 
SELECT * FROM productoffers
                WHERE product_id = '1599' AND price > 0
                ORDER BY price ASC LIMIT 1
132 0.0002 0.00023102760314941 
SELECT value FROM productattributes WHERE product_id = '1599' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
133 0.0005 0.00046610832214355 
SELECT * FROM products WHERE id = '2182'
134 0.0005 0.00052714347839355 
SELECT * FROM productimages WHERE product_id = '2182' ORDER BY sortorder ASC
135 0.0007 0.00068187713623047 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2182' AND p.id = pi.product_id ORDER BY pi.sortorder
136 0.0006 0.00059914588928223 
SELECT * FROM product_image_select WHERE product_id = '2182'
137 0.0004 0.00039482116699219 
SELECT * FROM productcustomimages WHERE product_id = '2182'
138 0.0005 0.00046896934509277 
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 = '2182'
                GROUP BY o.product_id
139 0.0012 0.0012209415435791 
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     = '2182'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
140 0.0010 0.0009610652923584 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2182
141 0.0012 0.0012009143829346 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2182' AND a.name = n.originalname
142 0.0006 0.00062990188598633 
SELECT * FROM productoffers WHERE product_id = '2182' AND merchantid = 'A1X6FK5RDHNB96'
143 0.0009 0.00090312957763672 
SELECT * FROM productoffers
                WHERE product_id = '2182' AND price > 0
                ORDER BY price ASC LIMIT 1
144 0.0004 0.00036001205444336 
SELECT * FROM productoffers
                WHERE product_id = 2182
                ORDER BY price ASC LIMIT 1
145 0.0004 0.0003960132598877 
SELECT value FROM productattributes
                WHERE product_id = '2182'
                AND name = 'ListPriceAmount'
146 0.0003 0.0002741813659668 
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 = '2182'
                GROUP BY o.product_id
147 0.0003 0.00026893615722656 
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     = '2182'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
148 0.0003 0.00025796890258789 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2182
149 0.0006 0.00060701370239258 
SELECT value FROM productattributes WHERE product_id = '2182' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
150 0.0005 0.00047898292541504 
SELECT * FROM products WHERE parent_id = '2182'
151 0.0006 0.00062990188598633 
SELECT * FROM products WHERE id = '827'
152 0.0006 0.00057411193847656 
SELECT * FROM productimages WHERE product_id = '827' ORDER BY sortorder ASC
153 0.0004 0.00044989585876465 
SELECT * FROM product_image_select WHERE product_id = '827'
154 0.0004 0.00039911270141602 
SELECT * FROM productcustomimages WHERE product_id = '827'
155 0.0013 0.0013120174407959 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '827' AND a.name = n.originalname
156 0.0005 0.0004580020904541 
SELECT * FROM productoffers WHERE product_id = '827' AND merchantid = 'A1X6FK5RDHNB96'
157 0.0004 0.00041389465332031 
SELECT * FROM productoffers
                WHERE product_id = '827' AND price > 0
                ORDER BY price ASC LIMIT 1
158 0.0004 0.0003662109375 
SELECT * FROM productoffers
                WHERE product_id = 827
                ORDER BY price ASC LIMIT 1
159 0.0004 0.0004270076751709 
SELECT value FROM productattributes
                WHERE product_id = '827'
                AND name = 'ListPriceAmount'
160 0.0005 0.00050520896911621 
SELECT value FROM productattributes WHERE product_id = '827' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
161 0.0006 0.00059294700622559 
SELECT * FROM products WHERE id = '1832'
162 0.0005 0.00051593780517578 
SELECT * FROM productimages WHERE product_id = '1832' ORDER BY sortorder ASC
163 0.0005 0.00048398971557617 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1832' AND p.id = pi.product_id ORDER BY pi.sortorder
164 0.0004 0.00044012069702148 
SELECT * FROM product_image_select WHERE product_id = '1832'
165 0.0004 0.00036501884460449 
SELECT * FROM productcustomimages WHERE product_id = '1832'
166 0.0006 0.00056004524230957 
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 = '1832'
                GROUP BY o.product_id
167 0.0007 0.00073099136352539 
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     = '1832'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
168 0.0005 0.00045204162597656 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1832
169 0.0007 0.00072193145751953 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1832' AND a.name = n.originalname
170 0.0004 0.00044822692871094 
SELECT * FROM productoffers WHERE product_id = '1832' AND merchantid = 'A1X6FK5RDHNB96'
171 0.0005 0.00046586990356445 
SELECT * FROM productoffers
                WHERE product_id = '1832' AND price > 0
                ORDER BY price ASC LIMIT 1
172 0.0004 0.00040578842163086 
SELECT * FROM productoffers
                WHERE product_id = 1832
                ORDER BY price ASC LIMIT 1
173 0.0004 0.00043606758117676 
SELECT value FROM productattributes
                WHERE product_id = '1832'
                AND name = 'ListPriceAmount'
174 0.0002 0.00024008750915527 
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 = '1832'
                GROUP BY o.product_id
175 0.0004 0.00038290023803711 
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     = '1832'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
176 0.0003 0.00025796890258789 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1832
177 0.0006 0.00055384635925293 
SELECT value FROM productattributes WHERE product_id = '1832' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
178 0.0005 0.00048685073852539 
SELECT * FROM products WHERE parent_id = '1832'
179 0.0006 0.00060796737670898 
SELECT * FROM products WHERE id = '813'
180 0.0007 0.00067591667175293 
SELECT * FROM productimages WHERE product_id = '813' ORDER BY sortorder ASC
181 0.0007 0.0006561279296875 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '813' AND p.id = pi.product_id ORDER BY pi.sortorder
182 0.0010 0.0010190010070801 
SELECT * FROM product_image_select WHERE product_id = '813'
183 0.0009 0.00092601776123047 
SELECT * FROM productcustomimages WHERE product_id = '813'
184 0.0012 0.0011889934539795 
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 = '813'
                GROUP BY o.product_id
185 0.0015 0.0015048980712891 
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     = '813'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
186 0.0011 0.0011250972747803 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 813
187 0.0015 0.0015149116516113 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '813' AND a.name = n.originalname
188 0.0011 0.00111985206604 
SELECT * FROM productoffers WHERE product_id = '813' AND merchantid = 'A1X6FK5RDHNB96'
189 0.0017 0.0017130374908447 
SELECT * FROM productoffers
                WHERE product_id = '813' AND price > 0
                ORDER BY price ASC LIMIT 1
190 0.0013 0.0013210773468018 
SELECT * FROM productoffers
                WHERE product_id = 813
                ORDER BY price ASC LIMIT 1
191 0.0013 0.0013189315795898 
SELECT value FROM productattributes
                WHERE product_id = '813'
                AND name = 'ListPriceAmount'
192 0.0004 0.00035691261291504 
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 = '813'
                GROUP BY o.product_id
193 0.0003 0.00028896331787109 
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     = '813'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
194 0.0003 0.00026392936706543 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 813
195 0.0007 0.00074005126953125 
SELECT value FROM productattributes WHERE product_id = '813' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
196 0.0011 0.0011022090911865 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '813'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
197 0.0007 0.00071001052856445 
SELECT * FROM products WHERE id = '1240'
198 0.0008 0.00084495544433594 
SELECT * FROM productimages WHERE product_id = '1240' ORDER BY sortorder ASC
199 0.0006 0.00056910514831543 
SELECT * FROM product_image_select WHERE product_id = '1240'
200 0.0006 0.00064587593078613 
SELECT * FROM productcustomimages WHERE product_id = '1240'
201 0.0026 0.0026419162750244 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1240' AND a.name = n.originalname
202 0.0007 0.00073909759521484 
SELECT * FROM productoffers WHERE product_id = '1240' AND merchantid = 'A1X6FK5RDHNB96'
203 0.0007 0.00071287155151367 
SELECT * FROM productoffers
                WHERE product_id = '1240' AND price > 0
                ORDER BY price ASC LIMIT 1
204 0.0008 0.00075292587280273 
SELECT value FROM productattributes WHERE product_id = '1240' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
205 0.0008 0.00078105926513672 
SELECT * FROM products WHERE id = '776'
206 0.0003 0.00034904479980469 
SELECT * FROM productimages WHERE product_id = '776' ORDER BY sortorder ASC
207 0.0003 0.00034999847412109 
SELECT * FROM product_image_select WHERE product_id = '776'
208 0.0003 0.00028610229492188 
SELECT * FROM productcustomimages WHERE product_id = '776'
209 0.0003 0.00030183792114258 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '776' AND a.name = n.originalname
210 0.0003 0.00028896331787109 
SELECT * FROM productoffers WHERE product_id = '776' AND merchantid = 'A1X6FK5RDHNB96'
211 0.0004 0.0004279613494873 
SELECT * FROM productoffers
                WHERE product_id = '776' AND price > 0
                ORDER BY price ASC LIMIT 1
212 0.0003 0.00026202201843262 
SELECT value FROM productattributes WHERE product_id = '776' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
213 0.0006 0.00057697296142578 
SELECT * FROM products WHERE id = '2358'
214 0.0006 0.00063085556030273 
SELECT * FROM productimages WHERE product_id = '2358' ORDER BY sortorder ASC
215 0.0009 0.00089287757873535 
SELECT * FROM product_image_select WHERE product_id = '2358'
216 0.0005 0.00053787231445312 
SELECT * FROM productcustomimages WHERE product_id = '2358'
217 0.0011 0.0010590553283691 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2358' AND a.name = n.originalname
218 0.0007 0.00072097778320312 
SELECT * FROM productoffers WHERE product_id = '2358' AND merchantid = 'A1X6FK5RDHNB96'
219 0.0006 0.00062799453735352 
SELECT * FROM productoffers
                WHERE product_id = '2358' AND price > 0
                ORDER BY price ASC LIMIT 1
220 0.0007 0.00072908401489258 
SELECT value FROM productattributes WHERE product_id = '2358' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
221 0.0008 0.00078201293945312 
SELECT * FROM products WHERE id = '1462'
222 0.0006 0.00064611434936523 
SELECT * FROM productimages WHERE product_id = '1462' ORDER BY sortorder ASC
223 0.0006 0.00059294700622559 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1462' AND p.id = pi.product_id ORDER BY pi.sortorder
224 0.0006 0.00057196617126465 
SELECT * FROM product_image_select WHERE product_id = '1462'
225 0.0005 0.00049710273742676 
SELECT * FROM productcustomimages WHERE product_id = '1462'
226 0.0008 0.00080204010009766 
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 = '1462'
                GROUP BY o.product_id
227 0.0008 0.00084710121154785 
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     = '1462'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
228 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 = 1462
229 0.0022 0.0022008419036865 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1462' AND a.name = n.originalname
230 0.0006 0.00063800811767578 
SELECT * FROM productoffers WHERE product_id = '1462' AND merchantid = 'A1X6FK5RDHNB96'
231 0.0006 0.00064802169799805 
SELECT * FROM productoffers
                WHERE product_id = '1462' AND price > 0
                ORDER BY price ASC LIMIT 1
232 0.0005 0.00046491622924805 
SELECT * FROM productoffers
                WHERE product_id = 1462
                ORDER BY price ASC LIMIT 1
233 0.0005 0.00054383277893066 
SELECT value FROM productattributes
                WHERE product_id = '1462'
                AND name = 'ListPriceAmount'
234 0.0003 0.00029206275939941 
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 = '1462'
                GROUP BY o.product_id
235 0.0003 0.00026512145996094 
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     = '1462'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
236 0.0003 0.00029301643371582 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1462
237 0.0006 0.00056195259094238 
SELECT * FROM products WHERE parent_id = '1462'
238 0.0006 0.00057411193847656 
SELECT * FROM products WHERE id = '846'
239 0.0009 0.0008549690246582 
SELECT * FROM productimages WHERE product_id = '846' ORDER BY sortorder ASC
240 0.0009 0.00092291831970215 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '846' AND p.id = pi.product_id ORDER BY pi.sortorder
241 0.0006 0.00057792663574219 
SELECT * FROM product_image_select WHERE product_id = '846'
242 0.0005 0.00045108795166016 
SELECT * FROM productcustomimages WHERE product_id = '846'
243 0.0007 0.00072598457336426 
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 = '846'
                GROUP BY o.product_id
244 0.0009 0.00089311599731445 
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     = '846'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
245 0.0005 0.00051784515380859 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 846
246 0.0009 0.00086498260498047 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '846' AND a.name = n.originalname
247 0.0005 0.0004880428314209 
SELECT * FROM productoffers WHERE product_id = '846' AND merchantid = 'A1X6FK5RDHNB96'
248 0.0005 0.00045514106750488 
SELECT * FROM productoffers
                WHERE product_id = '846' AND price > 0
                ORDER BY price ASC LIMIT 1
249 0.0004 0.00040292739868164 
SELECT * FROM productoffers
                WHERE product_id = 846
                ORDER BY price ASC LIMIT 1
250 0.0005 0.00053787231445312 
SELECT value FROM productattributes
                WHERE product_id = '846'
                AND name = 'ListPriceAmount'
251 0.0003 0.00027799606323242 
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 = '846'
                GROUP BY o.product_id
252 0.0003 0.00034713745117188 
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     = '846'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
253 0.0003 0.00028491020202637 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 846
254 0.0006 0.00056219100952148 
SELECT value FROM productattributes WHERE product_id = '846' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
255 0.0009 0.00093817710876465 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '846'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
256 0.0006 0.00062990188598633 
SELECT * FROM products WHERE id = '1669'
257 0.0006 0.00063300132751465 
SELECT * FROM productimages WHERE product_id = '1669' ORDER BY sortorder ASC
258 0.0006 0.00056982040405273 
SELECT * FROM product_image_select WHERE product_id = '1669'
259 0.0005 0.00049209594726562 
SELECT * FROM productcustomimages WHERE product_id = '1669'
260 0.0016 0.0016179084777832 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1669' AND a.name = n.originalname
261 0.0006 0.0006110668182373 
SELECT * FROM productoffers WHERE product_id = '1669' AND merchantid = 'A1X6FK5RDHNB96'
262 0.0006 0.00055480003356934 
SELECT * FROM productoffers
                WHERE product_id = '1669' AND price > 0
                ORDER BY price ASC LIMIT 1
263 0.0005 0.00051307678222656 
SELECT * FROM productoffers
                WHERE product_id = 1669
                ORDER BY price ASC LIMIT 1
264 0.0005 0.00051498413085938 
SELECT value FROM productattributes
                WHERE product_id = '1669'
                AND name = 'ListPriceAmount'
265 0.0006 0.00060296058654785 
SELECT value FROM productattributes WHERE product_id = '1669' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
266 0.0007 0.00069999694824219 
SELECT * FROM products WHERE id = '2633'
267 0.0007 0.00073409080505371 
SELECT * FROM productimages WHERE product_id = '2633' ORDER BY sortorder ASC
268 0.0005 0.00046205520629883 
SELECT * FROM product_image_select WHERE product_id = '2633'
269 0.0006 0.0006110668182373 
SELECT * FROM productcustomimages WHERE product_id = '2633'
270 0.0019 0.0018711090087891 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2633' AND a.name = n.originalname
271 0.0005 0.00053691864013672 
SELECT * FROM productoffers WHERE product_id = '2633' AND merchantid = 'A1X6FK5RDHNB96'
272 0.0005 0.00053596496582031 
SELECT * FROM productoffers
                WHERE product_id = '2633' AND price > 0
                ORDER BY price ASC LIMIT 1
273 0.0005 0.0005190372467041 
SELECT value FROM productattributes WHERE product_id = '2633' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
274 0.0006 0.00063490867614746 
SELECT * FROM products WHERE id = '1286'
275 0.0006 0.00055480003356934 
SELECT * FROM productimages WHERE product_id = '1286' ORDER BY sortorder ASC
276 0.0006 0.00062203407287598 
SELECT * FROM product_image_select WHERE product_id = '1286'
277 0.0005 0.00045490264892578 
SELECT * FROM productcustomimages WHERE product_id = '1286'
278 0.0014 0.0013937950134277 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1286' AND a.name = n.originalname
279 0.0005 0.00052189826965332 
SELECT * FROM productoffers WHERE product_id = '1286' AND merchantid = 'A1X6FK5RDHNB96'
280 0.0006 0.00062990188598633 
SELECT * FROM productoffers
                WHERE product_id = '1286' AND price > 0
                ORDER BY price ASC LIMIT 1
281 0.0005 0.00049495697021484 
SELECT value FROM productattributes WHERE product_id = '1286' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
282 0.0006 0.00061798095703125 
SELECT * FROM products WHERE id = '1629'
283 0.0008 0.00081610679626465 
SELECT * FROM productimages WHERE product_id = '1629' ORDER BY sortorder ASC
284 0.0005 0.00053119659423828 
SELECT * FROM product_image_select WHERE product_id = '1629'
285 0.0006 0.00060606002807617 
SELECT * FROM productcustomimages WHERE product_id = '1629'
286 0.0003 0.00028014183044434 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1629' AND a.name = n.originalname
287 0.0003 0.00027990341186523 
SELECT * FROM productoffers WHERE product_id = '1629' AND merchantid = 'A1X6FK5RDHNB96'
288 0.0003 0.00026583671569824 
SELECT * FROM productoffers
                WHERE product_id = '1629' AND price > 0
                ORDER BY price ASC LIMIT 1
289 0.0003 0.00025391578674316 
SELECT * FROM productoffers
                WHERE product_id = 1629
                ORDER BY price ASC LIMIT 1
290 0.0002 0.00023794174194336 
SELECT value FROM productattributes
                WHERE product_id = '1629'
                AND name = 'ListPriceAmount'
291 0.0003 0.0002589225769043 
SELECT value FROM productattributes WHERE product_id = '1629' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
292 0.0005 0.00048685073852539 
SELECT * FROM products WHERE id = '1562'
293 0.0005 0.00054407119750977 
SELECT * FROM productimages WHERE product_id = '1562' ORDER BY sortorder ASC
294 0.0010 0.0010280609130859 
SELECT * FROM product_image_select WHERE product_id = '1562'
295 0.0011 0.0011119842529297 
SELECT * FROM productcustomimages WHERE product_id = '1562'
296 0.0006 0.00059199333190918 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1562' AND a.name = n.originalname
297 0.0003 0.00027799606323242 
SELECT * FROM productoffers WHERE product_id = '1562' AND merchantid = 'A1X6FK5RDHNB96'
298 0.0003 0.0002739429473877 
SELECT * FROM productoffers
                WHERE product_id = '1562' AND price > 0
                ORDER BY price ASC LIMIT 1
299 0.0003 0.00029182434082031 
SELECT * FROM productoffers
                WHERE product_id = 1562
                ORDER BY price ASC LIMIT 1
300 0.0003 0.00025701522827148 
SELECT value FROM productattributes
                WHERE product_id = '1562'
                AND name = 'ListPriceAmount'
301 0.0003 0.0002892017364502 
SELECT value FROM productattributes WHERE product_id = '1562' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
302 0.0007 0.00067496299743652 
SELECT * FROM products WHERE id = '2602'
303 0.0006 0.00058794021606445 
SELECT * FROM productimages WHERE product_id = '2602' ORDER BY sortorder ASC
304 0.0005 0.00047397613525391 
SELECT * FROM product_image_select WHERE product_id = '2602'
305 0.0004 0.00039196014404297 
SELECT * FROM productcustomimages WHERE product_id = '2602'
306 0.0013 0.0013010501861572 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2602' AND a.name = n.originalname
307 0.0005 0.00049090385437012 
SELECT * FROM productoffers WHERE product_id = '2602' AND merchantid = 'A1X6FK5RDHNB96'
308 0.0004 0.00044822692871094 
SELECT * FROM productoffers
                WHERE product_id = '2602' AND price > 0
                ORDER BY price ASC LIMIT 1
309 0.0004 0.0004429817199707 
SELECT * FROM productoffers
                WHERE product_id = 2602
                ORDER BY price ASC LIMIT 1
310 0.0005 0.00049018859863281 
SELECT value FROM productattributes
                WHERE product_id = '2602'
                AND name = 'ListPriceAmount'
311 0.0005 0.00050616264343262 
SELECT value FROM productattributes WHERE product_id = '2602' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
312 0.0006 0.00063610076904297 
SELECT * FROM products WHERE id = '1849'
313 0.0006 0.00056290626525879 
SELECT * FROM productimages WHERE product_id = '1849' ORDER BY sortorder ASC
314 0.0004 0.00043392181396484 
SELECT * FROM product_image_select WHERE product_id = '1849'
315 0.0005 0.00046205520629883 
SELECT * FROM productcustomimages WHERE product_id = '1849'
316 0.0015 0.0015499591827393 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1849' AND a.name = n.originalname
317 0.0006 0.0006101131439209 
SELECT * FROM productoffers WHERE product_id = '1849' AND merchantid = 'A1X6FK5RDHNB96'
318 0.0006 0.00057291984558105 
SELECT * FROM productoffers
                WHERE product_id = '1849' AND price > 0
                ORDER BY price ASC LIMIT 1
319 0.0006 0.00058317184448242 
SELECT value FROM productattributes WHERE product_id = '1849' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
320 0.0005 0.00051617622375488 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2896' ORDER BY timestamp DESC
321 0.0003 0.00028491020202637 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1599' ORDER BY timestamp DESC
322 0.0004 0.00043177604675293 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2182' ORDER BY timestamp DESC
323 0.0004 0.00038385391235352 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '827' ORDER BY timestamp DESC
324 0.0004 0.00036883354187012 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1832' ORDER BY timestamp DESC
325 0.0004 0.0003669261932373 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '813' ORDER BY timestamp DESC
326 0.0004 0.00040698051452637 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1240' ORDER BY timestamp DESC
327 0.0004 0.0004119873046875 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '776' ORDER BY timestamp DESC
328 0.0004 0.00037407875061035 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2358' ORDER BY timestamp DESC
329 0.0004 0.00039100646972656 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1462' ORDER BY timestamp DESC
330 0.0004 0.00038504600524902 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '846' ORDER BY timestamp DESC
331 0.0004 0.00037097930908203 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1669' ORDER BY timestamp DESC
332 0.0004 0.00044417381286621 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2633' ORDER BY timestamp DESC
333 0.0004 0.00041699409484863 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1286' ORDER BY timestamp DESC
334 0.0003 0.0003349781036377 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1629' ORDER BY timestamp DESC
335 0.0003 0.0002739429473877 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1562' ORDER BY timestamp DESC
336 0.0005 0.00045609474182129 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2602' ORDER BY timestamp DESC
337 0.0004 0.00041913986206055 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1849' ORDER BY timestamp DESC
338 0.0003 0.00034499168395996 
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 = 26
		AND c.prod_type = 'ebay'
		AND hide = 0
339 0.0003 0.00028610229492188 
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
340 0.0003 0.00031399726867676 
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
341 0.0002 0.00023698806762695 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
342 0.0003 0.00031399726867676 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
343 0.0003 0.00031590461730957 
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
344 0.0003 0.00027108192443848 
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
345 0.0003 0.00028109550476074 
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
346 0.0004 0.00035214424133301 
SELECT * FROM products WHERE id = 1626
347 0.0004 0.00037789344787598 
SELECT * FROM products WHERE id = 4041
348 0.0004 0.00041699409484863 
SELECT * FROM products WHERE id = 4312
349 0.0003 0.00034809112548828 
SELECT * FROM products WHERE id = 777
350 0.0003 0.00034093856811523 
SELECT * FROM products WHERE id = 3881
351 0.0004 0.00040316581726074 
SELECT * FROM products WHERE id = 4213
352 0.0003 0.00031900405883789 
SELECT * FROM products WHERE id = '1626'
353 0.0003 0.0002892017364502 
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
354 0.0003 0.00034999847412109 
SELECT * FROM product_image_select WHERE product_id = '1626'
355 0.0003 0.00031685829162598 
SELECT * FROM productcustomimages WHERE product_id = '1626'
356 0.0003 0.00027918815612793 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
357 0.0003 0.00026702880859375 
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
358 0.0005 0.00052690505981445 
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
359 0.0003 0.00026106834411621 
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
360 0.0004 0.00036096572875977 
SELECT * FROM products WHERE id = '4041'
361 0.0003 0.00029397010803223 
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
362 0.0003 0.00028896331787109 
SELECT * FROM product_image_select WHERE product_id = '4041'
363 0.0003 0.00034999847412109 
SELECT * FROM productcustomimages WHERE product_id = '4041'
364 0.0004 0.00036501884460449 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
365 0.0004 0.00036096572875977 
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
366 0.0003 0.00033688545227051 
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
367 0.0003 0.00028181076049805 
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
368 0.0004 0.00039219856262207 
SELECT * FROM products WHERE id = '4312'
369 0.0003 0.00029397010803223 
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
370 0.0003 0.00030708312988281 
SELECT * FROM product_image_select WHERE product_id = '4312'
371 0.0003 0.00030207633972168 
SELECT * FROM productcustomimages WHERE product_id = '4312'
372 0.0003 0.00031495094299316 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
373 0.0003 0.00031185150146484 
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
374 0.0003 0.00032615661621094 
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
375 0.0003 0.00031590461730957 
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
376 0.0004 0.00042200088500977 
SELECT * FROM products WHERE id = '777'
377 0.0003 0.00032305717468262 
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
378 0.0004 0.00036406517028809 
SELECT * FROM product_image_select WHERE product_id = '777'
379 0.0003 0.00031781196594238 
SELECT * FROM productcustomimages WHERE product_id = '777'
380 0.0003 0.00031900405883789 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
381 0.0003 0.00031805038452148 
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
382 0.0003 0.0003209114074707 
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
383 0.0003 0.00030803680419922 
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
384 0.0004 0.00040292739868164 
SELECT * FROM products WHERE id = '3881'
385 0.0005 0.00047898292541504 
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
386 0.0004 0.00035595893859863 
SELECT * FROM product_image_select WHERE product_id = '3881'
387 0.0003 0.00030899047851562 
SELECT * FROM productcustomimages WHERE product_id = '3881'
388 0.0003 0.00031781196594238 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
389 0.0004 0.00035214424133301 
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
390 0.0003 0.0003049373626709 
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
391 0.0003 0.00028181076049805 
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
392 0.0004 0.00040578842163086 
SELECT * FROM products WHERE id = '4213'
393 0.0005 0.00050616264343262 
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
394 0.0003 0.00032186508178711 
SELECT * FROM product_image_select WHERE product_id = '4213'
395 0.0003 0.00032901763916016 
SELECT * FROM productcustomimages WHERE product_id = '4213'
396 0.0003 0.00032687187194824 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
397 0.0004 0.00035500526428223 
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
398 0.0003 0.00033783912658691 
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
399 0.0003 0.00029993057250977 
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
400 0.0004 0.00040292739868164 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
401 0.0005 0.00051403045654297 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
402 0.0005 0.00046515464782715 
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
403 0.0005 0.00048995018005371 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
404 0.0004 0.00038790702819824 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
405 0.0004 0.00041604042053223 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
406 0.0004 0.00041985511779785 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'