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.5622918605804 376 1.1359 0


No Amazon API Requests Made.


App Debug - Total Time 1.5622918605804 seconds

Number Time From Start Name Description
1 0.34872698783875 Initialise Initialise FSB Function
2 0.35433793067932 App Controller Start Start of the App controller (called before the controller of every page)
3 1.2460658550262 App Controller End End of the App controller (called before the controller of every page)
4 1.2464699745178 Category Start Start of the category controller
5 1.2464728355408 Before Get Category Before getting the category information
6 1.2755680084229 After Get Category After getting the category information
7 1.2755680084229 Before Get Category List Before getting the updated category list
8 1.2758028507233 Start of getCategoryListByGroup Function Before first category groups query
9 1.2760248184204 After initial query Before first category groups query
10 1.2760260105133 Get Category List for Group Before the call to getCategoryList function
11 1.2760279178619 Start of GetCategoryList function Start of the function
12 1.2760298252106 Before getting categories Query to get specific category list
13 1.276330947876 After getting categories Query to get specific category list
14 1.276330947876 Before getting category custom Before call to function getCategoryCustom
15 1.2906808853149 After getting category custom After call to function getCategoryCustom
16 1.2906827926636 Before getting sub category list Before call to recursive function getCategoryList
17 1.2906839847565 Start of GetCategoryList function Start of the function
18 1.2906858921051 Before getting categories Query to get specific category list
19 1.2912139892578 After getting sub category list After call to recursive function getCategoryList
20 1.2912349700928 Before getting category custom Before call to function getCategoryCustom
21 1.3005387783051 After getting category custom After call to function getCategoryCustom
22 1.3005409240723 Before getting category custom Before call to function getCategoryCustom
23 1.3050439357758 After getting category custom After call to function getCategoryCustom
24 1.3050448894501 Before getting category custom Before call to function getCategoryCustom
25 1.3080949783325 After getting category custom After call to function getCategoryCustom
26 1.3080959320068 Before getting category custom Before call to function getCategoryCustom
27 1.3110909461975 After getting category custom After call to function getCategoryCustom
28 1.3110918998718 Before getting category custom Before call to function getCategoryCustom
29 1.3141379356384 After getting category custom After call to function getCategoryCustom
30 1.3141398429871 End of GetCategoryList function End of the function
31 1.3141448497772 Get Category List for Group Before the call to getCategoryList function
32 1.3141469955444 Start of GetCategoryList function Start of the function
33 1.3141469955444 Before getting categories Query to get specific category list
34 1.3145167827606 End of getCategoryListByGroup Function Before return()
35 1.3145189285278 After Get Category List After getting the updated category list
36 1.3145189285278 Before Category Images Before getting the category images
37 1.3148219585419 After Category Images After getting the category images
38 1.3158218860626 Before Sub Category Check Before checking for sub category or products category
39 1.3161399364471 Before Category Products Controller Before loading the category products controller
40 1.3166878223419 Start Category Products Start of Category Products Controller
41 1.3167119026184 After Pagination Options After pagination options in Category Products Controller
42 1.3309879302979 After Cache After Cache checking in Category Products Controller
43 1.3459379673004 After Filter Options After getting filter options and SQL in Category Products Controller
44 1.354612827301 After Counting Products After counting products in the Category Products Controller
45 1.3550798892975 After Counting Bundles After counting bundles in the Category Products Controller
46 1.3555748462677 After Counting Products After counting products in the Category Products Controller
47 1.368243932724 After Getting Products After getting products and bundles in the Category Products Controller
48 1.3682889938354 After Pagination Links After getting pagination listing links in the Category Products Controller
49 1.3682899475098 After Getting Bundle Details After getting full details for the bundles in the Category Products Controller
50 1.4441788196564 After Getting Product Details After getting full product details in the Category Products Controller
51 1.4486238956451 After Getting Product/Bundle Reviews After getting full product/bundle customer review in the Category Products Controller
52 1.4501478672028 App_after Controller Start Start of the App_after controller (called after the controller of every page)
53 1.4513008594513 Before Get Options Before the call to getOptions in the tpl class
54 1.4927699565887 After Get Options After the call to getOptions in the tpl class
55 1.4929399490356 App_after Controller End End of the App_after controller (called after the controller of every page)
56 1.4929628372192 Before Smarty Before passing everything over to Smarty in the Category Products Controller
57 1.5622789859772 After Loading sub/product controller After checking for sub category or products category and then loading the relevant controller
58 1.5622828006744 Finalizing debug Before the debug is output to the page.
59 1.5622909069061 End of App This is the end of the app logging, final timestamp


Query Debug - 376 Database Queries. Total time 1.1359 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0008 0.00077390670776367 
SELECT parameter, value FROM parameters
2 0.0056 0.0056350231170654 
SELECT * FROM `bad_bots`
3 0.0003 0.00031590461730957 
SET time_zone = 'Europe/London'
4 0.0017 0.0017299652099609 
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0013 0.0012609958648682 
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"216.73.216.68\";}'
6 0.0008 0.00078201293945312 
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1750955462'
7 0.0012 0.0011780261993408 
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0004 0.00037717819213867 
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0010 0.00096392631530762 
SELECT id FROM pages WHERE pagename = 'boites-the' LIMIT 1
10 0.0012 0.0011558532714844 
SELECT id FROM products WHERE pagename = 'boites-the' AND hidden = 0 LIMIT 1
11 0.0010 0.00095605850219727 
SELECT id FROM ebay_products WHERE pagename = 'boites-the'
12 0.0011 0.0010528564453125 
SELECT id FROM custom_products WHERE pagename = 'boites-the'
13 0.0008 0.000823974609375 
SELECT id FROM categories WHERE pagename = 'boites-the' LIMIT 1
14 0.0017 0.0016741752624512 
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
15 0.0315 0.03148889541626 
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
16 0.0006 0.00056099891662598 
SELECT * FROM pages WHERE pagename = 'boites-the'
17 0.0025 0.0025198459625244 
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
18 0.0011 0.0010638236999512 
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
19 0.0004 0.00044608116149902 
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
20 0.0007 0.00074601173400879 
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
21 0.0011 0.0010790824890137 
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
22 0.0007 0.0006561279296875 
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
23 0.8482 0.84821200370789 
SELECT * FROM ipgeocountries WHERE INET_ATON('216.73.216.68') >= INET_ATON(ip_start) AND INET_ATON('216.73.216.68') <= INET_ATON(ip_end)
24 0.0014 0.0014379024505615 
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
25 0.0007 0.00065112113952637 
SELECT * FROM countryredirects WHERE countrycode = 'US'
26 0.0004 0.00037193298339844 
SELECT * FROM categories WHERE pagename = 'boites-the'
27 0.0049 0.004889965057373 
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
28 0.0021 0.0021309852600098 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
29 0.0003 0.00034999847412109 
SELECT id FROM categories WHERE parent_id = '26'
30 0.0058 0.0058460235595703 
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
31 0.0020 0.0019910335540771 
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
32 0.0005 0.00045108795166016 
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
33 0.0017 0.0017478466033936 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
34 0.0003 0.00031590461730957 
SELECT id FROM categories WHERE parent_id = '26'
35 0.0016 0.0015649795532227 
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
36 0.0014 0.0014100074768066 
SELECT * FROM productimages WHERE product_id = '4122' ORDER BY sortorder ASC
37 0.0017 0.0017237663269043 
SELECT * FROM categoryimages WHERE category_id = 26
38 0.0006 0.00058507919311523 
SELECT * FROM categorygroups WHERE id = '1'
39 0.0053 0.0052719116210938 
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
40 0.0003 0.00031185150146484 
SELECT parent_id FROM categories WHERE id = '26'
41 0.0002 0.00022006034851074 
SELECT parent_id FROM categories WHERE id = '26'
42 0.0002 0.00021815299987793 
SELECT * FROM categorygroups ORDER BY sortorder ASC
43 0.0003 0.0002901554107666 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
44 0.0044 0.0043628215789795 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
45 0.0005 0.00053596496582031 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
46 0.0003 0.00028705596923828 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
47 0.0003 0.00028777122497559 
SELECT id FROM categories WHERE parent_id = '26'
48 0.0072 0.00718092918396 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
49 0.0004 0.00040316581726074 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0
50 0.0005 0.00054478645324707 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
51 0.0003 0.0003349781036377 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
52 0.0004 0.00035405158996582 
SELECT * FROM categorygroups WHERE id = '1'
53 0.0005 0.00052189826965332 
SELECT * FROM categories WHERE parent_id = '26'  AND hidden = 0 ORDER BY sortorder ASC
54 0.0032 0.0032370090484619 
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.0003 0.0003359317779541 
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.0003 0.00027298927307129 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
57 0.0004 0.00036811828613281 
SELECT id FROM categories WHERE parent_id = '27'
58 0.0037 0.0036599636077881 
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.0004 0.0003809928894043 
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.0004 0.00036287307739258 
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.0003 0.00031399726867676 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
62 0.0003 0.00029110908508301 
SELECT * FROM categorygroups WHERE id = '1'
63 0.0011 0.001121997833252 
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.0003 0.00029993057250977 
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.0003 0.0002589225769043 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
66 0.0003 0.0003049373626709 
SELECT id FROM categories WHERE parent_id = '28'
67 0.0012 0.001215934753418 
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.0003 0.00032496452331543 
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.0003 0.00034403800964355 
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.0003 0.00032377243041992 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
71 0.0003 0.00027704238891602 
SELECT * FROM categorygroups WHERE id = '1'
72 0.0004 0.00037407875061035 
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.0003 0.00030803680419922 
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.0003 0.0002899169921875 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
75 0.0003 0.00027799606323242 
SELECT id FROM categories WHERE parent_id = '29'
76 0.0004 0.0004429817199707 
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.0004 0.0003509521484375 
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.0003 0.00034904479980469 
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.0003 0.00031900405883789 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
80 0.0003 0.00030303001403809 
SELECT * FROM categorygroups WHERE id = '1'
81 0.0004 0.00037002563476562 
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
82 0.0003 0.00029301643371582 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
83 0.0003 0.00026297569274902 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
84 0.0003 0.0002739429473877 
SELECT id FROM categories WHERE parent_id = '30'
85 0.0005 0.00049996376037598 
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
86 0.0004 0.00035595893859863 
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
87 0.0003 0.00032591819763184 
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
88 0.0003 0.00030303001403809 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
89 0.0003 0.00028491020202637 
SELECT * FROM categorygroups WHERE id = '1'
90 0.0004 0.0004119873046875 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
91 0.0003 0.00029897689819336 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
92 0.0003 0.0002591609954834 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
93 0.0003 0.00027799606323242 
SELECT id FROM categories WHERE parent_id = '31'
94 0.0005 0.00047779083251953 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
95 0.0003 0.00032496452331543 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0
96 0.0004 0.00036287307739258 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
97 0.0003 0.00031590461730957 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
98 0.0003 0.00028085708618164 
SELECT * FROM categorygroups WHERE id = '1'
99 0.0004 0.00036001205444336 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
100 0.0003 0.00029897689819336 
SELECT * FROM categoryimages WHERE category_id = 26
101 0.0010 0.00097203254699707 
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
102 0.0003 0.00031208992004395 
SELECT * FROM categories WHERE parent_id = '26'
103 0.0049 0.0049049854278564 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
104 0.0014 0.001378059387207 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
105 0.0010 0.00099587440490723 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
106 0.0051 0.0050640106201172 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
107 0.0021 0.0020699501037598 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
108 0.0004 0.00035405158996582 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
109 0.0082 0.0081541538238525 
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
110 0.0005 0.0005030632019043 
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
111 0.0005 0.00046181678771973 
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
112 0.0005 0.00048995018005371 
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
113 0.0126 0.012626886367798 
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 36, 18
114 0.0003 0.00032901763916016 
SELECT * FROM products WHERE id = '2271'
115 0.0006 0.00055694580078125 
SELECT * FROM productimages WHERE product_id = '2271' ORDER BY sortorder ASC
116 0.0013 0.0013020038604736 
SELECT * FROM product_image_select WHERE product_id = '2271'
117 0.0010 0.0009758472442627 
SELECT * FROM productcustomimages WHERE product_id = '2271'
118 0.0013 0.0012531280517578 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2271' AND a.name = n.originalname
119 0.0008 0.00082802772521973 
SELECT * FROM productoffers WHERE product_id = '2271' AND merchantid = 'A1X6FK5RDHNB96'
120 0.0003 0.00032401084899902 
SELECT * FROM productoffers
                WHERE product_id = '2271' AND price > 0
                ORDER BY price ASC LIMIT 1
121 0.0005 0.00045490264892578 
SELECT value FROM productattributes WHERE product_id = '2271' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
122 0.0004 0.00044584274291992 
SELECT * FROM products WHERE id = '1364'
123 0.0005 0.00047802925109863 
SELECT * FROM productimages WHERE product_id = '1364' ORDER BY sortorder ASC
124 0.0006 0.00055503845214844 
SELECT * FROM product_image_select WHERE product_id = '1364'
125 0.0010 0.00099587440490723 
SELECT * FROM productcustomimages WHERE product_id = '1364'
126 0.0013 0.0013358592987061 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1364' AND a.name = n.originalname
127 0.0003 0.00034379959106445 
SELECT * FROM productoffers WHERE product_id = '1364' AND merchantid = 'A1X6FK5RDHNB96'
128 0.0003 0.00029492378234863 
SELECT * FROM productoffers
                WHERE product_id = '1364' AND price > 0
                ORDER BY price ASC LIMIT 1
129 0.0004 0.00041985511779785 
SELECT value FROM productattributes WHERE product_id = '1364' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
130 0.0004 0.00036811828613281 
SELECT * FROM products WHERE id = '3828'
131 0.0004 0.00040602684020996 
SELECT * FROM productimages WHERE product_id = '3828' ORDER BY sortorder ASC
132 0.0005 0.00046706199645996 
SELECT * FROM product_image_select WHERE product_id = '3828'
133 0.0003 0.00030708312988281 
SELECT * FROM productcustomimages WHERE product_id = '3828'
134 0.0007 0.00073909759521484 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3828' AND a.name = n.originalname
135 0.0003 0.00033187866210938 
SELECT * FROM productoffers WHERE product_id = '3828' AND merchantid = 'A1X6FK5RDHNB96'
136 0.0003 0.00027585029602051 
SELECT * FROM productoffers
                WHERE product_id = '3828' AND price > 0
                ORDER BY price ASC LIMIT 1
137 0.0004 0.00037002563476562 
SELECT value FROM productattributes WHERE product_id = '3828' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
138 0.0004 0.00039100646972656 
SELECT * FROM products WHERE id = '3575'
139 0.0004 0.00039005279541016 
SELECT * FROM productimages WHERE product_id = '3575' ORDER BY sortorder ASC
140 0.0005 0.00045680999755859 
SELECT * FROM product_image_select WHERE product_id = '3575'
141 0.0004 0.00040197372436523 
SELECT * FROM productcustomimages WHERE product_id = '3575'
142 0.0008 0.00082898139953613 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3575' AND a.name = n.originalname
143 0.0003 0.00032401084899902 
SELECT * FROM productoffers WHERE product_id = '3575' AND merchantid = 'A1X6FK5RDHNB96'
144 0.0003 0.00026702880859375 
SELECT * FROM productoffers
                WHERE product_id = '3575' AND price > 0
                ORDER BY price ASC LIMIT 1
145 0.0002 0.0002448558807373 
SELECT * FROM productoffers
                WHERE product_id = 3575
                ORDER BY price ASC LIMIT 1
146 0.0003 0.00027704238891602 
SELECT value FROM productattributes
                WHERE product_id = '3575'
                AND name = 'ListPriceAmount'
147 0.0003 0.00030088424682617 
SELECT value FROM productattributes WHERE product_id = '3575' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
148 0.0004 0.00036978721618652 
SELECT * FROM products WHERE id = '1418'
149 0.0004 0.00036096572875977 
SELECT * FROM productimages WHERE product_id = '1418' ORDER BY sortorder ASC
150 0.0005 0.00045084953308105 
SELECT * FROM product_image_select WHERE product_id = '1418'
151 0.0003 0.00027990341186523 
SELECT * FROM productcustomimages WHERE product_id = '1418'
152 0.0007 0.00074911117553711 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1418' AND a.name = n.originalname
153 0.0003 0.00034284591674805 
SELECT * FROM productoffers WHERE product_id = '1418' AND merchantid = 'A1X6FK5RDHNB96'
154 0.0003 0.00029611587524414 
SELECT * FROM productoffers
                WHERE product_id = '1418' AND price > 0
                ORDER BY price ASC LIMIT 1
155 0.0003 0.00030612945556641 
SELECT value FROM productattributes WHERE product_id = '1418' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
156 0.0003 0.00034284591674805 
SELECT * FROM products WHERE id = '2220'
157 0.0004 0.00044393539428711 
SELECT * FROM productimages WHERE product_id = '2220' ORDER BY sortorder ASC
158 0.0005 0.00046801567077637 
SELECT * FROM product_image_select WHERE product_id = '2220'
159 0.0003 0.00029993057250977 
SELECT * FROM productcustomimages WHERE product_id = '2220'
160 0.0006 0.00057792663574219 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2220' AND a.name = n.originalname
161 0.0003 0.00034904479980469 
SELECT * FROM productoffers WHERE product_id = '2220' AND merchantid = 'A1X6FK5RDHNB96'
162 0.0003 0.00028085708618164 
SELECT * FROM productoffers
                WHERE product_id = '2220' AND price > 0
                ORDER BY price ASC LIMIT 1
163 0.0003 0.00034594535827637 
SELECT value FROM productattributes WHERE product_id = '2220' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
164 0.0004 0.0004279613494873 
SELECT * FROM products WHERE id = '774'
165 0.0004 0.0003819465637207 
SELECT * FROM productimages WHERE product_id = '774' ORDER BY sortorder ASC
166 0.0007 0.00070500373840332 
SELECT * FROM product_image_select WHERE product_id = '774'
167 0.0003 0.00029897689819336 
SELECT * FROM productcustomimages WHERE product_id = '774'
168 0.0006 0.00059199333190918 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '774' AND a.name = n.originalname
169 0.0003 0.00034618377685547 
SELECT * FROM productoffers WHERE product_id = '774' AND merchantid = 'A1X6FK5RDHNB96'
170 0.0003 0.00026297569274902 
SELECT * FROM productoffers
                WHERE product_id = '774' AND price > 0
                ORDER BY price ASC LIMIT 1
171 0.0003 0.00025296211242676 
SELECT * FROM productoffers
                WHERE product_id = 774
                ORDER BY price ASC LIMIT 1
172 0.0003 0.00027799606323242 
SELECT value FROM productattributes
                WHERE product_id = '774'
                AND name = 'ListPriceAmount'
173 0.0003 0.00030899047851562 
SELECT value FROM productattributes WHERE product_id = '774' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
174 0.0004 0.00037097930908203 
SELECT * FROM products WHERE id = '1354'
175 0.0004 0.00042200088500977 
SELECT * FROM productimages WHERE product_id = '1354' ORDER BY sortorder ASC
176 0.0006 0.00061297416687012 
SELECT * FROM product_image_select WHERE product_id = '1354'
177 0.0003 0.00032496452331543 
SELECT * FROM productcustomimages WHERE product_id = '1354'
178 0.0008 0.00077915191650391 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1354' AND a.name = n.originalname
179 0.0004 0.00036096572875977 
SELECT * FROM productoffers WHERE product_id = '1354' AND merchantid = 'A1X6FK5RDHNB96'
180 0.0003 0.00027084350585938 
SELECT * FROM productoffers
                WHERE product_id = '1354' AND price > 0
                ORDER BY price ASC LIMIT 1
181 0.0003 0.00034809112548828 
SELECT value FROM productattributes WHERE product_id = '1354' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
182 0.0004 0.00035500526428223 
SELECT * FROM products WHERE id = '4032'
183 0.0004 0.00041103363037109 
SELECT * FROM productimages WHERE product_id = '4032' ORDER BY sortorder ASC
184 0.0005 0.00052309036254883 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4032' AND p.id = pi.product_id ORDER BY pi.sortorder
185 0.0005 0.00047898292541504 
SELECT * FROM product_image_select WHERE product_id = '4032'
186 0.0003 0.00030612945556641 
SELECT * FROM productcustomimages WHERE product_id = '4032'
187 0.0004 0.0004429817199707 
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 = '4032'
                GROUP BY o.product_id
188 0.0016 0.0015618801116943 
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     = '4032'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
189 0.0003 0.00034689903259277 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4032
190 0.0006 0.00059294700622559 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4032' AND a.name = n.originalname
191 0.0003 0.00025010108947754 
SELECT * FROM productoffers WHERE product_id = '4032' AND merchantid = 'A1X6FK5RDHNB96'
192 0.0002 0.00024509429931641 
SELECT * FROM productoffers
                WHERE product_id = '4032' AND price > 0
                ORDER BY price ASC LIMIT 1
193 0.0002 0.00022602081298828 
SELECT * FROM productoffers
                WHERE product_id = 4032
                ORDER BY price ASC LIMIT 1
194 0.0003 0.00026297569274902 
SELECT value FROM productattributes
                WHERE product_id = '4032'
                AND name = 'ListPriceAmount'
195 0.0003 0.00030112266540527 
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 = '4032'
                GROUP BY o.product_id
196 0.0005 0.00046110153198242 
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     = '4032'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
197 0.0003 0.00027799606323242 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4032
198 0.0003 0.00034499168395996 
SELECT value FROM productattributes WHERE product_id = '4032' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
199 0.0004 0.0004279613494873 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4032'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
200 0.0003 0.00027918815612793 
SELECT * FROM products WHERE id = '3786'
201 0.0004 0.00036883354187012 
SELECT * FROM productimages WHERE product_id = '3786' ORDER BY sortorder ASC
202 0.0003 0.00028896331787109 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3786' AND p.id = pi.product_id ORDER BY pi.sortorder
203 0.0005 0.0005340576171875 
SELECT * FROM product_image_select WHERE product_id = '3786'
204 0.0003 0.00029301643371582 
SELECT * FROM productcustomimages WHERE product_id = '3786'
205 0.0003 0.00034999847412109 
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 = '3786'
                GROUP BY o.product_id
206 0.0004 0.00041890144348145 
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     = '3786'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
207 0.0003 0.00027108192443848 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3786
208 0.0005 0.00054287910461426 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3786' AND a.name = n.originalname
209 0.0002 0.00024509429931641 
SELECT * FROM productoffers WHERE product_id = '3786' AND merchantid = 'A1X6FK5RDHNB96'
210 0.0003 0.0002601146697998 
SELECT * FROM productoffers
                WHERE product_id = '3786' AND price > 0
                ORDER BY price ASC LIMIT 1
211 0.0002 0.00022006034851074 
SELECT * FROM productoffers
                WHERE product_id = 3786
                ORDER BY price ASC LIMIT 1
212 0.0002 0.00023698806762695 
SELECT value FROM productattributes
                WHERE product_id = '3786'
                AND name = 'ListPriceAmount'
213 0.0003 0.00029611587524414 
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 = '3786'
                GROUP BY o.product_id
214 0.0004 0.00040411949157715 
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     = '3786'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
215 0.0003 0.00025391578674316 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3786
216 0.0003 0.00034499168395996 
SELECT value FROM productattributes WHERE product_id = '3786' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
217 0.0004 0.0003969669342041 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3786'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
218 0.0003 0.00027298927307129 
SELECT * FROM products WHERE id = '2851'
219 0.0004 0.00039386749267578 
SELECT * FROM productimages WHERE product_id = '2851' ORDER BY sortorder ASC
220 0.0005 0.00045084953308105 
SELECT * FROM product_image_select WHERE product_id = '2851'
221 0.0003 0.00026798248291016 
SELECT * FROM productcustomimages WHERE product_id = '2851'
222 0.0006 0.00064992904663086 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2851' AND a.name = n.originalname
223 0.0003 0.00031208992004395 
SELECT * FROM productoffers WHERE product_id = '2851' AND merchantid = 'A1X6FK5RDHNB96'
224 0.0003 0.00027012825012207 
SELECT * FROM productoffers
                WHERE product_id = '2851' AND price > 0
                ORDER BY price ASC LIMIT 1
225 0.0003 0.00034093856811523 
SELECT value FROM productattributes WHERE product_id = '2851' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
226 0.0003 0.00033688545227051 
SELECT * FROM products WHERE id = '1348'
227 0.0004 0.0003659725189209 
SELECT * FROM productimages WHERE product_id = '1348' ORDER BY sortorder ASC
228 0.0005 0.00046610832214355 
SELECT * FROM product_image_select WHERE product_id = '1348'
229 0.0003 0.00028896331787109 
SELECT * FROM productcustomimages WHERE product_id = '1348'
230 0.0006 0.00055289268493652 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1348' AND a.name = n.originalname
231 0.0003 0.00034499168395996 
SELECT * FROM productoffers WHERE product_id = '1348' AND merchantid = 'A1X6FK5RDHNB96'
232 0.0012 0.0011539459228516 
SELECT * FROM productoffers
                WHERE product_id = '1348' AND price > 0
                ORDER BY price ASC LIMIT 1
233 0.0004 0.00037193298339844 
SELECT value FROM productattributes WHERE product_id = '1348' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
234 0.0004 0.00040912628173828 
SELECT * FROM products WHERE id = '1339'
235 0.0005 0.0004580020904541 
SELECT * FROM productimages WHERE product_id = '1339' ORDER BY sortorder ASC
236 0.0005 0.00048017501831055 
SELECT * FROM product_image_select WHERE product_id = '1339'
237 0.0003 0.00027894973754883 
SELECT * FROM productcustomimages WHERE product_id = '1339'
238 0.0007 0.00066995620727539 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1339' AND a.name = n.originalname
239 0.0003 0.00033402442932129 
SELECT * FROM productoffers WHERE product_id = '1339' AND merchantid = 'A1X6FK5RDHNB96'
240 0.0002 0.00024080276489258 
SELECT * FROM productoffers
                WHERE product_id = '1339' AND price > 0
                ORDER BY price ASC LIMIT 1
241 0.0002 0.00022792816162109 
SELECT * FROM productoffers
                WHERE product_id = 1339
                ORDER BY price ASC LIMIT 1
242 0.0002 0.00024008750915527 
SELECT value FROM productattributes
                WHERE product_id = '1339'
                AND name = 'ListPriceAmount'
243 0.0003 0.00025701522827148 
SELECT value FROM productattributes WHERE product_id = '1339' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
244 0.0005 0.00047707557678223 
SELECT * FROM products WHERE id = '843'
245 0.0004 0.00039386749267578 
SELECT * FROM productimages WHERE product_id = '843' ORDER BY sortorder ASC
246 0.0005 0.00050711631774902 
SELECT * FROM product_image_select WHERE product_id = '843'
247 0.0004 0.00037002563476562 
SELECT * FROM productcustomimages WHERE product_id = '843'
248 0.0007 0.00071096420288086 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '843' AND a.name = n.originalname
249 0.0004 0.00035309791564941 
SELECT * FROM productoffers WHERE product_id = '843' AND merchantid = 'A1X6FK5RDHNB96'
250 0.0005 0.00046300888061523 
SELECT * FROM productoffers
                WHERE product_id = '843' AND price > 0
                ORDER BY price ASC LIMIT 1
251 0.0004 0.00043416023254395 
SELECT * FROM productoffers
                WHERE product_id = 843
                ORDER BY price ASC LIMIT 1
252 0.0005 0.00050902366638184 
SELECT value FROM productattributes
                WHERE product_id = '843'
                AND name = 'ListPriceAmount'
253 0.0005 0.00045084953308105 
SELECT value FROM productattributes WHERE product_id = '843' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
254 0.0004 0.00037002563476562 
SELECT * FROM products WHERE id = '2671'
255 0.0005 0.00050091743469238 
SELECT * FROM productimages WHERE product_id = '2671' ORDER BY sortorder ASC
256 0.0005 0.00046491622924805 
SELECT * FROM product_image_select WHERE product_id = '2671'
257 0.0003 0.00026082992553711 
SELECT * FROM productcustomimages WHERE product_id = '2671'
258 0.0008 0.00084400177001953 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2671' AND a.name = n.originalname
259 0.0003 0.00028586387634277 
SELECT * FROM productoffers WHERE product_id = '2671' AND merchantid = 'A1X6FK5RDHNB96'
260 0.0002 0.00022983551025391 
SELECT * FROM productoffers
                WHERE product_id = '2671' AND price > 0
                ORDER BY price ASC LIMIT 1
261 0.0008 0.00078701972961426 
SELECT * FROM productoffers
                WHERE product_id = 2671
                ORDER BY price ASC LIMIT 1
262 0.0003 0.00029301643371582 
SELECT value FROM productattributes
                WHERE product_id = '2671'
                AND name = 'ListPriceAmount'
263 0.0003 0.00027298927307129 
SELECT value FROM productattributes WHERE product_id = '2671' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
264 0.0003 0.00033998489379883 
SELECT * FROM products WHERE id = '1131'
265 0.0004 0.00036907196044922 
SELECT * FROM productimages WHERE product_id = '1131' ORDER BY sortorder ASC
266 0.0004 0.00043797492980957 
SELECT * FROM product_image_select WHERE product_id = '1131'
267 0.0003 0.00025391578674316 
SELECT * FROM productcustomimages WHERE product_id = '1131'
268 0.0006 0.00057792663574219 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1131' AND a.name = n.originalname
269 0.0003 0.00029897689819336 
SELECT * FROM productoffers WHERE product_id = '1131' AND merchantid = 'A1X6FK5RDHNB96'
270 0.0002 0.00024795532226562 
SELECT * FROM productoffers
                WHERE product_id = '1131' AND price > 0
                ORDER BY price ASC LIMIT 1
271 0.0003 0.00033092498779297 
SELECT value FROM productattributes WHERE product_id = '1131' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
272 0.0003 0.00030994415283203 
SELECT * FROM products WHERE id = '1534'
273 0.0004 0.0003960132598877 
SELECT * FROM productimages WHERE product_id = '1534' ORDER BY sortorder ASC
274 0.0004 0.00044083595275879 
SELECT * FROM product_image_select WHERE product_id = '1534'
275 0.0003 0.0002598762512207 
SELECT * FROM productcustomimages WHERE product_id = '1534'
276 0.0006 0.00055813789367676 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1534' AND a.name = n.originalname
277 0.0003 0.00030112266540527 
SELECT * FROM productoffers WHERE product_id = '1534' AND merchantid = 'A1X6FK5RDHNB96'
278 0.0003 0.00027799606323242 
SELECT * FROM productoffers
                WHERE product_id = '1534' AND price > 0
                ORDER BY price ASC LIMIT 1
279 0.0004 0.00035309791564941 
SELECT value FROM productattributes WHERE product_id = '1534' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
280 0.0003 0.00031805038452148 
SELECT * FROM products WHERE id = '3826'
281 0.0003 0.00032997131347656 
SELECT * FROM productimages WHERE product_id = '3826' ORDER BY sortorder ASC
282 0.0004 0.0004429817199707 
SELECT * FROM product_image_select WHERE product_id = '3826'
283 0.0003 0.00026702880859375 
SELECT * FROM productcustomimages WHERE product_id = '3826'
284 0.0007 0.00068998336791992 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3826' AND a.name = n.originalname
285 0.0003 0.00032591819763184 
SELECT * FROM productoffers WHERE product_id = '3826' AND merchantid = 'A1X6FK5RDHNB96'
286 0.0002 0.0002439022064209 
SELECT * FROM productoffers
                WHERE product_id = '3826' AND price > 0
                ORDER BY price ASC LIMIT 1
287 0.0002 0.00022077560424805 
SELECT * FROM productoffers
                WHERE product_id = 3826
                ORDER BY price ASC LIMIT 1
288 0.0002 0.0002439022064209 
SELECT value FROM productattributes
                WHERE product_id = '3826'
                AND name = 'ListPriceAmount'
289 0.0003 0.00025796890258789 
SELECT value FROM productattributes WHERE product_id = '3826' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
290 0.0009 0.00092506408691406 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2271' ORDER BY timestamp DESC
291 0.0002 0.00021004676818848 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1364' ORDER BY timestamp DESC
292 0.0002 0.00019407272338867 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3828' ORDER BY timestamp DESC
293 0.0002 0.00019288063049316 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3575' ORDER BY timestamp DESC
294 0.0002 0.0002129077911377 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1418' ORDER BY timestamp DESC
295 0.0002 0.00020408630371094 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2220' ORDER BY timestamp DESC
296 0.0002 0.00019598007202148 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '774' ORDER BY timestamp DESC
297 0.0002 0.00019478797912598 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1354' ORDER BY timestamp DESC
298 0.0002 0.00022602081298828 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4032' ORDER BY timestamp DESC
299 0.0002 0.00022101402282715 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3786' ORDER BY timestamp DESC
300 0.0002 0.0001978874206543 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2851' ORDER BY timestamp DESC
301 0.0002 0.00020813941955566 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1348' ORDER BY timestamp DESC
302 0.0002 0.00019311904907227 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1339' ORDER BY timestamp DESC
303 0.0002 0.00019502639770508 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '843' ORDER BY timestamp DESC
304 0.0002 0.00020098686218262 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2671' ORDER BY timestamp DESC
305 0.0002 0.00019192695617676 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1131' ORDER BY timestamp DESC
306 0.0002 0.0001978874206543 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1534' ORDER BY timestamp DESC
307 0.0002 0.00020003318786621 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3826' ORDER BY timestamp DESC
308 0.0005 0.00050497055053711 
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
309 0.0003 0.00034499168395996 
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
310 0.0003 0.00033712387084961 
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
311 0.0009 0.0008699893951416 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
312 0.0002 0.00024509429931641 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
313 0.0118 0.011751174926758 
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
314 0.0009 0.00087404251098633 
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
315 0.0004 0.00035500526428223 
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
316 0.0004 0.00035405158996582 
SELECT * FROM products WHERE id = 1626
317 0.0003 0.00034117698669434 
SELECT * FROM products WHERE id = 4041
318 0.0003 0.00034618377685547 
SELECT * FROM products WHERE id = 4312
319 0.0003 0.00031614303588867 
SELECT * FROM products WHERE id = 777
320 0.0003 0.00031399726867676 
SELECT * FROM products WHERE id = 3881
321 0.0003 0.00031805038452148 
SELECT * FROM products WHERE id = 4213
322 0.0004 0.00035810470581055 
SELECT * FROM products WHERE id = '1626'
323 0.0005 0.00045895576477051 
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
324 0.0004 0.00044417381286621 
SELECT * FROM product_image_select WHERE product_id = '1626'
325 0.0003 0.00026488304138184 
SELECT * FROM productcustomimages WHERE product_id = '1626'
326 0.0007 0.00066804885864258 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
327 0.0003 0.00033807754516602 
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
328 0.0003 0.0002739429473877 
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
329 0.0006 0.00056195259094238 
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
330 0.0005 0.00046801567077637 
SELECT * FROM products WHERE id = '4041'
331 0.0004 0.0003960132598877 
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
332 0.0005 0.00054502487182617 
SELECT * FROM product_image_select WHERE product_id = '4041'
333 0.0003 0.00029206275939941 
SELECT * FROM productcustomimages WHERE product_id = '4041'
334 0.0008 0.00076603889465332 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
335 0.0003 0.00032711029052734 
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
336 0.0003 0.00026488304138184 
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
337 0.0004 0.00037598609924316 
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
338 0.0004 0.00035786628723145 
SELECT * FROM products WHERE id = '4312'
339 0.0004 0.00037503242492676 
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
340 0.0005 0.00048398971557617 
SELECT * FROM product_image_select WHERE product_id = '4312'
341 0.0003 0.00029778480529785 
SELECT * FROM productcustomimages WHERE product_id = '4312'
342 0.0007 0.00068187713623047 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
343 0.0003 0.00030708312988281 
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
344 0.0003 0.00028491020202637 
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
345 0.0003 0.00031590461730957 
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
346 0.0004 0.00036001205444336 
SELECT * FROM products WHERE id = '777'
347 0.0004 0.00037693977355957 
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
348 0.0004 0.00042581558227539 
SELECT * FROM product_image_select WHERE product_id = '777'
349 0.0003 0.00026988983154297 
SELECT * FROM productcustomimages WHERE product_id = '777'
350 0.0007 0.00067710876464844 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
351 0.0003 0.0003209114074707 
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
352 0.0003 0.0002589225769043 
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
353 0.0004 0.00037097930908203 
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
354 0.0003 0.00034189224243164 
SELECT * FROM products WHERE id = '3881'
355 0.0004 0.00042009353637695 
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
356 0.0005 0.00053811073303223 
SELECT * FROM product_image_select WHERE product_id = '3881'
357 0.0003 0.00026607513427734 
SELECT * FROM productcustomimages WHERE product_id = '3881'
358 0.0007 0.00071287155151367 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
359 0.0003 0.00030303001403809 
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
360 0.0003 0.00029897689819336 
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
361 0.0003 0.00034093856811523 
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
362 0.0004 0.00035500526428223 
SELECT * FROM products WHERE id = '4213'
363 0.0005 0.00046300888061523 
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
364 0.0006 0.0005638599395752 
SELECT * FROM product_image_select WHERE product_id = '4213'
365 0.0003 0.0002589225769043 
SELECT * FROM productcustomimages WHERE product_id = '4213'
366 0.0009 0.00094199180603027 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
367 0.0004 0.0003819465637207 
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
368 0.0003 0.00029206275939941 
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
369 0.0004 0.00038480758666992 
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
370 0.0015 0.0014529228210449 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
371 0.0006 0.0005800724029541 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
372 0.0021 0.002147912979126 
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
373 0.0011 0.0010888576507568 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
374 0.0005 0.0004880428314209 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
375 0.0006 0.00059103965759277 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
376 0.0004 0.00041294097900391 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'