0

Boîtes à thé

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.

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.5207509994507 377 1.0891 0


No Amazon API Requests Made.


App Debug - Total Time 1.5207509994507 seconds

Number Time From Start Name Description
1 0.40125513076782 Initialise Initialise FSB Function
2 0.41858816146851 App Controller Start Start of the App controller (called before the controller of every page)
3 1.1841061115265 App Controller End End of the App controller (called before the controller of every page)
4 1.184424161911 Category Start Start of the category controller
5 1.184427022934 Before Get Category Before getting the category information
6 1.2177519798279 After Get Category After getting the category information
7 1.2177541255951 Before Get Category List Before getting the updated category list
8 1.2180199623108 Start of getCategoryListByGroup Function Before first category groups query
9 1.2183229923248 After initial query Before first category groups query
10 1.2183239459991 Get Category List for Group Before the call to getCategoryList function
11 1.2183260917664 Start of GetCategoryList function Start of the function
12 1.2183270454407 Before getting categories Query to get specific category list
13 1.218729019165 After getting categories Query to get specific category list
14 1.218729019165 Before getting category custom Before call to function getCategoryCustom
15 1.2352681159973 After getting category custom After call to function getCategoryCustom
16 1.2352690696716 Before getting sub category list Before call to recursive function getCategoryList
17 1.2352709770203 Start of GetCategoryList function Start of the function
18 1.2352721691132 Before getting categories Query to get specific category list
19 1.2357821464539 After getting sub category list After call to recursive function getCategoryList
20 1.2357840538025 Before getting category custom Before call to function getCategoryCustom
21 1.2468481063843 After getting category custom After call to function getCategoryCustom
22 1.2468500137329 Before getting category custom Before call to function getCategoryCustom
23 1.2532441616058 After getting category custom After call to function getCategoryCustom
24 1.2532460689545 Before getting category custom Before call to function getCategoryCustom
25 1.2625651359558 After getting category custom After call to function getCategoryCustom
26 1.2625679969788 Before getting category custom Before call to function getCategoryCustom
27 1.2696490287781 After getting category custom After call to function getCategoryCustom
28 1.2696511745453 Before getting category custom Before call to function getCategoryCustom
29 1.2750680446625 After getting category custom After call to function getCategoryCustom
30 1.2750689983368 End of GetCategoryList function End of the function
31 1.2750749588013 Get Category List for Group Before the call to getCategoryList function
32 1.2750761508942 Start of GetCategoryList function Start of the function
33 1.2750771045685 Before getting categories Query to get specific category list
34 1.275621175766 End of getCategoryListByGroup Function Before return()
35 1.2756230831146 After Get Category List After getting the updated category list
36 1.2756230831146 Before Category Images Before getting the category images
37 1.276113986969 After Category Images After getting the category images
38 1.2783210277557 Before Sub Category Check Before checking for sub category or products category
39 1.2788550853729 Before Category Products Controller Before loading the category products controller
40 1.2793390750885 Start Category Products Start of Category Products Controller
41 1.279354095459 After Pagination Options After pagination options in Category Products Controller
42 1.2798581123352 After Cache After Cache checking in Category Products Controller
43 1.2982449531555 After Filter Options After getting filter options and SQL in Category Products Controller
44 1.304701089859 After Counting Products After counting products in the Category Products Controller
45 1.3051979541779 After Counting Bundles After counting bundles in the Category Products Controller
46 1.3056721687317 After Counting Products After counting products in the Category Products Controller
47 1.3154680728912 After Getting Products After getting products and bundles in the Category Products Controller
48 1.3155131340027 After Pagination Links After getting pagination listing links in the Category Products Controller
49 1.315514087677 After Getting Bundle Details After getting full details for the bundles in the Category Products Controller
50 1.4117591381073 After Getting Product Details After getting full product details in the Category Products Controller
51 1.4186799526215 After Getting Product/Bundle Reviews After getting full product/bundle customer review in the Category Products Controller
52 1.4208610057831 App_after Controller Start Start of the App_after controller (called after the controller of every page)
53 1.4227459430695 Before Get Options Before the call to getOptions in the tpl class
54 1.4751119613647 After Get Options After the call to getOptions in the tpl class
55 1.4752550125122 App_after Controller End End of the App_after controller (called after the controller of every page)
56 1.4752781391144 Before Smarty Before passing everything over to Smarty in the Category Products Controller
57 1.5207331180573 After Loading sub/product controller After checking for sub category or products category and then loading the relevant controller
58 1.5207381248474 Finalizing debug Before the debug is output to the page.
59 1.5207500457764 End of App This is the end of the app logging, final timestamp


Query Debug - 377 Database Queries. Total time 1.0891 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0013 0.0012691020965576
SELECT parameter, value FROM parameters
2 0.0080 0.0079519748687744
SELECT * FROM `bad_bots`
3 0.0004 0.00040793418884277
SET time_zone = 'Europe/London'
4 0.0037 0.0037059783935547
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0038 0.0037579536437988
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:11:\"3.14.153.55\";}'
6 0.0032 0.0032169818878174
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1744481481'
7 0.0026 0.0025789737701416
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0004 0.00041985511779785
UPDATE autorun SET lastrun = '2025-04-12 18:11:21' WHERE id = '16'
9 0.0005 0.00052714347839355
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0032 0.0032250881195068
SELECT id FROM pages WHERE pagename = 'boites-the' LIMIT 1
11 0.0032 0.0031850337982178
SELECT id FROM products WHERE pagename = 'boites-the' AND hidden = 0 LIMIT 1
12 0.0030 0.0029921531677246
SELECT id FROM ebay_products WHERE pagename = 'boites-the'
13 0.0054 0.005424976348877
SELECT id FROM custom_products WHERE pagename = 'boites-the'
14 0.0015 0.0014708042144775
SELECT id FROM categories WHERE pagename = 'boites-the' LIMIT 1
15 0.0023 0.0023469924926758
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
16 0.0396 0.039585113525391
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
17 0.0006 0.00057792663574219
SELECT * FROM pages WHERE pagename = 'boites-the'
18 0.0030 0.00295090675354
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
19 0.0016 0.0016050338745117
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
20 0.0005 0.00052285194396973
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.0015 0.0014948844909668
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
22 0.0012 0.00124192237854
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
23 0.0008 0.00082898139953613
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
24 0.7091 0.70907115936279
SELECT * FROM ipgeocountries WHERE INET_ATON('3.14.153.55') >= INET_ATON(ip_start) AND INET_ATON('3.14.153.55') <= INET_ATON(ip_end)
25 0.0021 0.0021181106567383
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
26 0.0013 0.0012969970703125
SELECT * FROM countryredirects WHERE countrycode = 'US'
27 0.0005 0.00048398971557617
SELECT * FROM categories WHERE pagename = 'boites-the'
28 0.0067 0.0066637992858887
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.0015 0.0015430450439453
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
30 0.0004 0.00041007995605469
SELECT id FROM categories WHERE parent_id = '26'
31 0.0067 0.0067300796508789
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.0019 0.001945972442627
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.0005 0.00048518180847168
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.0015 0.0015029907226562
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
35 0.0004 0.00041604042053223
SELECT id FROM categories WHERE parent_id = '26'
36 0.0006 0.00064897537231445
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.0017 0.0017168521881104
SELECT * FROM productimages WHERE product_id = '4122' ORDER BY sortorder ASC
38 0.0014 0.0014021396636963
SELECT * FROM categoryimages WHERE category_id = 26
39 0.0014 0.0014181137084961
SELECT * FROM categorygroups WHERE id = '1'
40 0.0074 0.0073521137237549
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.0005 0.0005040168762207
SELECT parent_id FROM categories WHERE id = '26'
42 0.0003 0.0002601146697998
SELECT parent_id FROM categories WHERE id = '26'
43 0.0003 0.00030016899108887
SELECT * FROM categorygroups ORDER BY sortorder ASC
44 0.0004 0.00039100646972656
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
45 0.0076 0.0075860023498535
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.0005 0.00049805641174316
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.0004 0.0003809928894043
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
48 0.0004 0.00039410591125488
SELECT id FROM categories WHERE parent_id = '26'
49 0.0058 0.0057640075683594
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.0005 0.00047802925109863
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.0006 0.00057792663574219
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.0005 0.00046300888061523
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
53 0.0003 0.00034999847412109
SELECT * FROM categorygroups WHERE id = '1'
54 0.0005 0.00050783157348633
SELECT * FROM categories WHERE parent_id = '26'  AND hidden = 0 ORDER BY sortorder ASC
55 0.0038 0.0037910938262939
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.0005 0.00052690505981445
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.0005 0.00045514106750488
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
58 0.0005 0.00047397613525391
SELECT id FROM categories WHERE parent_id = '27'
59 0.0040 0.0039830207824707
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.0005 0.00048208236694336
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.0005 0.00049591064453125
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.0005 0.00045299530029297
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
63 0.0004 0.00037384033203125
SELECT * FROM categorygroups WHERE id = '1'
64 0.0015 0.0015261173248291
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.0004 0.00043702125549316
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.00033688545227051
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
67 0.0004 0.00039005279541016
SELECT id FROM categories WHERE parent_id = '28'
68 0.0016 0.0016229152679443
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.0006 0.00056099891662598
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.0006 0.0005958080291748
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.0005 0.00046706199645996
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
72 0.0004 0.00040006637573242
SELECT * FROM categorygroups WHERE id = '1'
73 0.0010 0.00095319747924805
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.0009 0.0009009838104248
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.0019 0.001896858215332
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
76 0.0010 0.0010199546813965
SELECT id FROM categories WHERE parent_id = '29'
77 0.0015 0.001539945602417
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.0008 0.00079083442687988
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.0008 0.00083613395690918
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.0006 0.00064992904663086
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
81 0.0006 0.00064802169799805
SELECT * FROM categorygroups WHERE id = '1'
82 0.0011 0.0011129379272461
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.0009 0.00087904930114746
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.0007 0.00070500373840332
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
85 0.0006 0.00059604644775391
SELECT id FROM categories WHERE parent_id = '30'
86 0.0012 0.0011599063873291
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.0007 0.00068306922912598
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.0008 0.00084400177001953
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.0006 0.00058889389038086
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
90 0.0004 0.0004420280456543
SELECT * FROM categorygroups WHERE id = '1'
91 0.0008 0.00082802772521973
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.0005 0.00052809715270996
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.0004 0.00039887428283691
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
94 0.0005 0.00052881240844727
SELECT id FROM categories WHERE parent_id = '31'
95 0.0009 0.00093293190002441
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.0006 0.00059199333190918
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.0006 0.00056695938110352
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.0006 0.00057411193847656
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
99 0.0004 0.00043797492980957
SELECT * FROM categorygroups WHERE id = '1'
100 0.0005 0.00054097175598145
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
101 0.0005 0.0004880428314209
SELECT * FROM categoryimages WHERE category_id = 26
102 0.0022 0.0021860599517822
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
103 0.0005 0.00052976608276367
SELECT * FROM categories WHERE parent_id = '26'
104 0.0072 0.0071680545806885
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
105 0.0019 0.0018889904022217
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
106 0.0019 0.0019209384918213
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
107 0.0052 0.0052258968353271
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
108 0.0015 0.0015389919281006
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
109 0.0004 0.00044083595275879
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
110 0.0059 0.0059049129486084
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.0005 0.00053191184997559
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.0005 0.00049304962158203
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.0005 0.00046586990356445
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.0098 0.0097570419311523
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
115 0.0005 0.00046181678771973
SELECT * FROM products WHERE id = '2271'
116 0.0005 0.00052595138549805
SELECT * FROM productimages WHERE product_id = '2271' ORDER BY sortorder ASC
117 0.0017 0.0016829967498779
SELECT * FROM product_image_select WHERE product_id = '2271'
118 0.0013 0.0012738704681396
SELECT * FROM productcustomimages WHERE product_id = '2271'
119 0.0017 0.0017030239105225
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2271' AND a.name = n.originalname
120 0.0014 0.0013999938964844
SELECT * FROM productoffers WHERE product_id = '2271' AND merchantid = 'A1X6FK5RDHNB96'
121 0.0004 0.0003960132598877
SELECT * FROM productoffers
                WHERE product_id = '2271' AND price > 0
                ORDER BY price ASC LIMIT 1
122 0.0005 0.00050616264343262
SELECT value FROM productattributes WHERE product_id = '2271' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
123 0.0005 0.00052309036254883
SELECT * FROM products WHERE id = '1364'
124 0.0005 0.0004730224609375
SELECT * FROM productimages WHERE product_id = '1364' ORDER BY sortorder ASC
125 0.0006 0.00060296058654785
SELECT * FROM product_image_select WHERE product_id = '1364'
126 0.0004 0.00035500526428223
SELECT * FROM productcustomimages WHERE product_id = '1364'
127 0.0008 0.00081300735473633
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1364' AND a.name = n.originalname
128 0.0004 0.00041913986206055
SELECT * FROM productoffers WHERE product_id = '1364' AND merchantid = 'A1X6FK5RDHNB96'
129 0.0003 0.00034785270690918
SELECT * FROM productoffers
                WHERE product_id = '1364' AND price > 0
                ORDER BY price ASC LIMIT 1
130 0.0005 0.0005180835723877
SELECT value FROM productattributes WHERE product_id = '1364' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
131 0.0005 0.00046896934509277
SELECT * FROM products WHERE id = '3828'
132 0.0005 0.00045490264892578
SELECT * FROM productimages WHERE product_id = '3828' ORDER BY sortorder ASC
133 0.0006 0.00059294700622559
SELECT * FROM product_image_select WHERE product_id = '3828'
134 0.0004 0.00044608116149902
SELECT * FROM productcustomimages WHERE product_id = '3828'
135 0.0012 0.0011510848999023
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3828' AND a.name = n.originalname
136 0.0005 0.00049018859863281
SELECT * FROM productoffers WHERE product_id = '3828' AND merchantid = 'A1X6FK5RDHNB96'
137 0.0004 0.00040602684020996
SELECT * FROM productoffers
                WHERE product_id = '3828' AND price > 0
                ORDER BY price ASC LIMIT 1
138 0.0004 0.00037503242492676
SELECT value FROM productattributes WHERE product_id = '3828' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
139 0.0004 0.00044989585876465
SELECT * FROM products WHERE id = '3575'
140 0.0005 0.00047802925109863
SELECT * FROM productimages WHERE product_id = '3575' ORDER BY sortorder ASC
141 0.0006 0.00056600570678711
SELECT * FROM product_image_select WHERE product_id = '3575'
142 0.0004 0.00038695335388184
SELECT * FROM productcustomimages WHERE product_id = '3575'
143 0.0012 0.0011699199676514
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3575' AND a.name = n.originalname
144 0.0005 0.00049686431884766
SELECT * FROM productoffers WHERE product_id = '3575' AND merchantid = 'A1X6FK5RDHNB96'
145 0.0004 0.00035500526428223
SELECT * FROM productoffers
                WHERE product_id = '3575' AND price > 0
                ORDER BY price ASC LIMIT 1
146 0.0003 0.00032305717468262
SELECT * FROM productoffers
                WHERE product_id = 3575
                ORDER BY price ASC LIMIT 1
147 0.0004 0.00041913986206055
SELECT value FROM productattributes
                WHERE product_id = '3575'
                AND name = 'ListPriceAmount'
148 0.0004 0.0004119873046875
SELECT value FROM productattributes WHERE product_id = '3575' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
149 0.0004 0.00043106079101562
SELECT * FROM products WHERE id = '1418'
150 0.0004 0.00039982795715332
SELECT * FROM productimages WHERE product_id = '1418' ORDER BY sortorder ASC
151 0.0005 0.00050902366638184
SELECT * FROM product_image_select WHERE product_id = '1418'
152 0.0003 0.00034785270690918
SELECT * FROM productcustomimages WHERE product_id = '1418'
153 0.0010 0.0010499954223633
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1418' AND a.name = n.originalname
154 0.0005 0.00046586990356445
SELECT * FROM productoffers WHERE product_id = '1418' AND merchantid = 'A1X6FK5RDHNB96'
155 0.0004 0.00039815902709961
SELECT * FROM productoffers
                WHERE product_id = '1418' AND price > 0
                ORDER BY price ASC LIMIT 1
156 0.0004 0.00037002563476562
SELECT value FROM productattributes WHERE product_id = '1418' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
157 0.0005 0.0004570484161377
SELECT * FROM products WHERE id = '2220'
158 0.0004 0.0003972053527832
SELECT * FROM productimages WHERE product_id = '2220' ORDER BY sortorder ASC
159 0.0005 0.0005030632019043
SELECT * FROM product_image_select WHERE product_id = '2220'
160 0.0003 0.0003361701965332
SELECT * FROM productcustomimages WHERE product_id = '2220'
161 0.0007 0.00072598457336426
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2220' AND a.name = n.originalname
162 0.0004 0.00039792060852051
SELECT * FROM productoffers WHERE product_id = '2220' AND merchantid = 'A1X6FK5RDHNB96'
163 0.0003 0.00031089782714844
SELECT * FROM productoffers
                WHERE product_id = '2220' AND price > 0
                ORDER BY price ASC LIMIT 1
164 0.0004 0.0003960132598877
SELECT value FROM productattributes WHERE product_id = '2220' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
165 0.0004 0.00043988227844238
SELECT * FROM products WHERE id = '774'
166 0.0004 0.00039291381835938
SELECT * FROM productimages WHERE product_id = '774' ORDER BY sortorder ASC
167 0.0005 0.00054812431335449
SELECT * FROM product_image_select WHERE product_id = '774'
168 0.0004 0.00037312507629395
SELECT * FROM productcustomimages WHERE product_id = '774'
169 0.0008 0.00075483322143555
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '774' AND a.name = n.originalname
170 0.0004 0.00043988227844238
SELECT * FROM productoffers WHERE product_id = '774' AND merchantid = 'A1X6FK5RDHNB96'
171 0.0003 0.00034499168395996
SELECT * FROM productoffers
                WHERE product_id = '774' AND price > 0
                ORDER BY price ASC LIMIT 1
172 0.0003 0.00030899047851562
SELECT * FROM productoffers
                WHERE product_id = 774
                ORDER BY price ASC LIMIT 1
173 0.0004 0.0003659725189209
SELECT value FROM productattributes
                WHERE product_id = '774'
                AND name = 'ListPriceAmount'
174 0.0004 0.00042986869812012
SELECT value FROM productattributes WHERE product_id = '774' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
175 0.0005 0.00053095817565918
SELECT * FROM products WHERE id = '1354'
176 0.0006 0.00055193901062012
SELECT * FROM productimages WHERE product_id = '1354' ORDER BY sortorder ASC
177 0.0007 0.00067305564880371
SELECT * FROM product_image_select WHERE product_id = '1354'
178 0.0004 0.00041103363037109
SELECT * FROM productcustomimages WHERE product_id = '1354'
179 0.0011 0.0010509490966797
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1354' AND a.name = n.originalname
180 0.0004 0.00041890144348145
SELECT * FROM productoffers WHERE product_id = '1354' AND merchantid = 'A1X6FK5RDHNB96'
181 0.0004 0.00038695335388184
SELECT * FROM productoffers
                WHERE product_id = '1354' AND price > 0
                ORDER BY price ASC LIMIT 1
182 0.0004 0.00038003921508789
SELECT value FROM productattributes WHERE product_id = '1354' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
183 0.0004 0.0004429817199707
SELECT * FROM products WHERE id = '4032'
184 0.0005 0.00050997734069824
SELECT * FROM productimages WHERE product_id = '4032' ORDER BY sortorder ASC
185 0.0006 0.00061297416687012
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
186 0.0008 0.00076413154602051
SELECT * FROM product_image_select WHERE product_id = '4032'
187 0.0004 0.0004119873046875
SELECT * FROM productcustomimages WHERE product_id = '4032'
188 0.0005 0.00053596496582031
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
189 0.0025 0.0025229454040527
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
190 0.0005 0.00050497055053711
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
191 0.0007 0.00070691108703613
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4032' AND a.name = n.originalname
192 0.0003 0.0003359317779541
SELECT * FROM productoffers WHERE product_id = '4032' AND merchantid = 'A1X6FK5RDHNB96'
193 0.0003 0.00030207633972168
SELECT * FROM productoffers
                WHERE product_id = '4032' AND price > 0
                ORDER BY price ASC LIMIT 1
194 0.0003 0.00030207633972168
SELECT * FROM productoffers
                WHERE product_id = 4032
                ORDER BY price ASC LIMIT 1
195 0.0004 0.00036287307739258
SELECT value FROM productattributes
                WHERE product_id = '4032'
                AND name = 'ListPriceAmount'
196 0.0004 0.00036001205444336
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
197 0.0006 0.00061798095703125
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
198 0.0004 0.00035500526428223
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
199 0.0005 0.00050520896911621
SELECT value FROM productattributes WHERE product_id = '4032' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
200 0.0006 0.00057697296142578
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
201 0.0003 0.00032210350036621
SELECT * FROM products WHERE id = '3786'
202 0.0005 0.00046801567077637
SELECT * FROM productimages WHERE product_id = '3786' ORDER BY sortorder ASC
203 0.0009 0.00087213516235352
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
204 0.0005 0.00053501129150391
SELECT * FROM product_image_select WHERE product_id = '3786'
205 0.0003 0.00034999847412109
SELECT * FROM productcustomimages WHERE product_id = '3786'
206 0.0005 0.00048708915710449
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
207 0.0006 0.00055384635925293
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
208 0.0004 0.00036287307739258
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
209 0.0007 0.00074315071105957
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3786' AND a.name = n.originalname
210 0.0003 0.00032401084899902
SELECT * FROM productoffers WHERE product_id = '3786' AND merchantid = 'A1X6FK5RDHNB96'
211 0.0003 0.00034499168395996
SELECT * FROM productoffers
                WHERE product_id = '3786' AND price > 0
                ORDER BY price ASC LIMIT 1
212 0.0003 0.00029110908508301
SELECT * FROM productoffers
                WHERE product_id = 3786
                ORDER BY price ASC LIMIT 1
213 0.0003 0.00032782554626465
SELECT value FROM productattributes
                WHERE product_id = '3786'
                AND name = 'ListPriceAmount'
214 0.0003 0.00034403800964355
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
215 0.0006 0.00061202049255371
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
216 0.0003 0.0003359317779541
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
217 0.0005 0.00052213668823242
SELECT value FROM productattributes WHERE product_id = '3786' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
218 0.0006 0.00055098533630371
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
219 0.0004 0.00037193298339844
SELECT * FROM products WHERE id = '2851'
220 0.0004 0.00041294097900391
SELECT * FROM productimages WHERE product_id = '2851' ORDER BY sortorder ASC
221 0.0005 0.00053787231445312
SELECT * FROM product_image_select WHERE product_id = '2851'
222 0.0003 0.00030612945556641
SELECT * FROM productcustomimages WHERE product_id = '2851'
223 0.0009 0.00089883804321289
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2851' AND a.name = n.originalname
224 0.0004 0.00041508674621582
SELECT * FROM productoffers WHERE product_id = '2851' AND merchantid = 'A1X6FK5RDHNB96'
225 0.0004 0.00035500526428223
SELECT * FROM productoffers
                WHERE product_id = '2851' AND price > 0
                ORDER BY price ASC LIMIT 1
226 0.0004 0.00036215782165527
SELECT value FROM productattributes WHERE product_id = '2851' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
227 0.0004 0.0004429817199707
SELECT * FROM products WHERE id = '1348'
228 0.0004 0.0004119873046875
SELECT * FROM productimages WHERE product_id = '1348' ORDER BY sortorder ASC
229 0.0006 0.0005950927734375
SELECT * FROM product_image_select WHERE product_id = '1348'
230 0.0004 0.0003659725189209
SELECT * FROM productcustomimages WHERE product_id = '1348'
231 0.0010 0.00098991394042969
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1348' AND a.name = n.originalname
232 0.0005 0.00051403045654297
SELECT * FROM productoffers WHERE product_id = '1348' AND merchantid = 'A1X6FK5RDHNB96'
233 0.0004 0.0003969669342041
SELECT * FROM productoffers
                WHERE product_id = '1348' AND price > 0
                ORDER BY price ASC LIMIT 1
234 0.0004 0.00043892860412598
SELECT value FROM productattributes WHERE product_id = '1348' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
235 0.0005 0.00053596496582031
SELECT * FROM products WHERE id = '1339'
236 0.0005 0.00048112869262695
SELECT * FROM productimages WHERE product_id = '1339' ORDER BY sortorder ASC
237 0.0006 0.00060319900512695
SELECT * FROM product_image_select WHERE product_id = '1339'
238 0.0004 0.00039887428283691
SELECT * FROM productcustomimages WHERE product_id = '1339'
239 0.0010 0.0010240077972412
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1339' AND a.name = n.originalname
240 0.0005 0.00045585632324219
SELECT * FROM productoffers WHERE product_id = '1339' AND merchantid = 'A1X6FK5RDHNB96'
241 0.0003 0.00033402442932129
SELECT * FROM productoffers
                WHERE product_id = '1339' AND price > 0
                ORDER BY price ASC LIMIT 1
242 0.0003 0.0003049373626709
SELECT * FROM productoffers
                WHERE product_id = 1339
                ORDER BY price ASC LIMIT 1
243 0.0004 0.00036096572875977
SELECT value FROM productattributes
                WHERE product_id = '1339'
                AND name = 'ListPriceAmount'
244 0.0004 0.00036501884460449
SELECT value FROM productattributes WHERE product_id = '1339' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
245 0.0004 0.00044703483581543
SELECT * FROM products WHERE id = '843'
246 0.0004 0.00037908554077148
SELECT * FROM productimages WHERE product_id = '843' ORDER BY sortorder ASC
247 0.0005 0.00052499771118164
SELECT * FROM product_image_select WHERE product_id = '843'
248 0.0003 0.00032997131347656
SELECT * FROM productcustomimages WHERE product_id = '843'
249 0.0010 0.00098705291748047
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '843' AND a.name = n.originalname
250 0.0005 0.00053310394287109
SELECT * FROM productoffers WHERE product_id = '843' AND merchantid = 'A1X6FK5RDHNB96'
251 0.0004 0.00039386749267578
SELECT * FROM productoffers
                WHERE product_id = '843' AND price > 0
                ORDER BY price ASC LIMIT 1
252 0.0004 0.00040006637573242
SELECT * FROM productoffers
                WHERE product_id = 843
                ORDER BY price ASC LIMIT 1
253 0.0004 0.00039887428283691
SELECT value FROM productattributes
                WHERE product_id = '843'
                AND name = 'ListPriceAmount'
254 0.0004 0.00040316581726074
SELECT value FROM productattributes WHERE product_id = '843' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
255 0.0005 0.00050592422485352
SELECT * FROM products WHERE id = '2671'
256 0.0004 0.00042486190795898
SELECT * FROM productimages WHERE product_id = '2671' ORDER BY sortorder ASC
257 0.0006 0.00060701370239258
SELECT * FROM product_image_select WHERE product_id = '2671'
258 0.0004 0.00037312507629395
SELECT * FROM productcustomimages WHERE product_id = '2671'
259 0.0010 0.0010190010070801
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2671' AND a.name = n.originalname
260 0.0005 0.00045299530029297
SELECT * FROM productoffers WHERE product_id = '2671' AND merchantid = 'A1X6FK5RDHNB96'
261 0.0004 0.00037908554077148
SELECT * FROM productoffers
                WHERE product_id = '2671' AND price > 0
                ORDER BY price ASC LIMIT 1
262 0.0004 0.00036215782165527
SELECT * FROM productoffers
                WHERE product_id = 2671
                ORDER BY price ASC LIMIT 1
263 0.0003 0.00033378601074219
SELECT value FROM productattributes
                WHERE product_id = '2671'
                AND name = 'ListPriceAmount'
264 0.0004 0.00042605400085449
SELECT value FROM productattributes WHERE product_id = '2671' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
265 0.0004 0.00044798851013184
SELECT * FROM products WHERE id = '1131'
266 0.0004 0.0004279613494873
SELECT * FROM productimages WHERE product_id = '1131' ORDER BY sortorder ASC
267 0.0006 0.00057792663574219
SELECT * FROM product_image_select WHERE product_id = '1131'
268 0.0004 0.00040817260742188
SELECT * FROM productcustomimages WHERE product_id = '1131'
269 0.0008 0.0007779598236084
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1131' AND a.name = n.originalname
270 0.0005 0.00047397613525391
SELECT * FROM productoffers WHERE product_id = '1131' AND merchantid = 'A1X6FK5RDHNB96'
271 0.0005 0.0004580020904541
SELECT * FROM productoffers
                WHERE product_id = '1131' AND price > 0
                ORDER BY price ASC LIMIT 1
272 0.0004 0.00040102005004883
SELECT value FROM productattributes WHERE product_id = '1131' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
273 0.0006 0.00061202049255371
SELECT * FROM products WHERE id = '1534'
274 0.0005 0.00048303604125977
SELECT * FROM productimages WHERE product_id = '1534' ORDER BY sortorder ASC
275 0.0008 0.00075292587280273
SELECT * FROM product_image_select WHERE product_id = '1534'
276 0.0004 0.00043988227844238
SELECT * FROM productcustomimages WHERE product_id = '1534'
277 0.0011 0.0010600090026855
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1534' AND a.name = n.originalname
278 0.0005 0.00047087669372559
SELECT * FROM productoffers WHERE product_id = '1534' AND merchantid = 'A1X6FK5RDHNB96'
279 0.0005 0.00049710273742676
SELECT * FROM productoffers
                WHERE product_id = '1534' AND price > 0
                ORDER BY price ASC LIMIT 1
280 0.0005 0.00045609474182129
SELECT value FROM productattributes WHERE product_id = '1534' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
281 0.0006 0.00059986114501953
SELECT * FROM products WHERE id = '3826'
282 0.0004 0.00043797492980957
SELECT * FROM productimages WHERE product_id = '3826' ORDER BY sortorder ASC
283 0.0006 0.0006248950958252
SELECT * FROM product_image_select WHERE product_id = '3826'
284 0.0005 0.00045895576477051
SELECT * FROM productcustomimages WHERE product_id = '3826'
285 0.0011 0.0011410713195801
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3826' AND a.name = n.originalname
286 0.0005 0.00054788589477539
SELECT * FROM productoffers WHERE product_id = '3826' AND merchantid = 'A1X6FK5RDHNB96'
287 0.0004 0.00037717819213867
SELECT * FROM productoffers
                WHERE product_id = '3826' AND price > 0
                ORDER BY price ASC LIMIT 1
288 0.0008 0.00079107284545898
SELECT * FROM productoffers
                WHERE product_id = 3826
                ORDER BY price ASC LIMIT 1
289 0.0004 0.00038695335388184
SELECT value FROM productattributes
                WHERE product_id = '3826'
                AND name = 'ListPriceAmount'
290 0.0004 0.00041604042053223
SELECT value FROM productattributes WHERE product_id = '3826' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
291 0.0017 0.0017030239105225
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2271' ORDER BY timestamp DESC
292 0.0003 0.00033903121948242
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1364' ORDER BY timestamp DESC
293 0.0003 0.00028395652770996
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3828' ORDER BY timestamp DESC
294 0.0004 0.0003509521484375
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3575' ORDER BY timestamp DESC
295 0.0003 0.0003349781036377
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1418' ORDER BY timestamp DESC
296 0.0003 0.00031089782714844
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2220' ORDER BY timestamp DESC
297 0.0003 0.00028800964355469
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '774' ORDER BY timestamp DESC
298 0.0003 0.00032687187194824
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1354' ORDER BY timestamp DESC
299 0.0003 0.00027203559875488
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4032' ORDER BY timestamp DESC
300 0.0003 0.00026106834411621
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3786' ORDER BY timestamp DESC
301 0.0003 0.00031304359436035
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2851' ORDER BY timestamp DESC
302 0.0003 0.00032711029052734
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1348' ORDER BY timestamp DESC
303 0.0003 0.0002751350402832
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1339' ORDER BY timestamp DESC
304 0.0003 0.00027203559875488
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '843' ORDER BY timestamp DESC
305 0.0003 0.00027298927307129
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2671' ORDER BY timestamp DESC
306 0.0003 0.00029301643371582
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1131' ORDER BY timestamp DESC
307 0.0003 0.0002601146697998
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1534' ORDER BY timestamp DESC
308 0.0003 0.00028109550476074
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3826' ORDER BY timestamp DESC
309 0.0006 0.00064492225646973
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
310 0.0005 0.00049591064453125
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
311 0.0005 0.00049185752868652
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
312 0.0015 0.0014910697937012
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
313 0.0003 0.00032711029052734
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
314 0.0135 0.01350998878479
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
315 0.0018 0.0018408298492432
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
316 0.0005 0.00051712989807129
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
317 0.0005 0.00047898292541504
SELECT * FROM products WHERE id = 1626
318 0.0003 0.00034403800964355
SELECT * FROM products WHERE id = 4041
319 0.0004 0.00041890144348145
SELECT * FROM products WHERE id = 4312
320 0.0004 0.00043201446533203
SELECT * FROM products WHERE id = 777
321 0.0004 0.00037217140197754
SELECT * FROM products WHERE id = 3881
322 0.0004 0.00036287307739258
SELECT * FROM products WHERE id = 4213
323 0.0003 0.00028705596923828
SELECT * FROM products WHERE id = '1626'
324 0.0005 0.00045299530029297
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
325 0.0005 0.00053715705871582
SELECT * FROM product_image_select WHERE product_id = '1626'
326 0.0022 0.0022029876708984
SELECT * FROM productcustomimages WHERE product_id = '1626'
327 0.0009 0.00089716911315918
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
328 0.0004 0.00044012069702148
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
329 0.0003 0.00033807754516602
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
330 0.0004 0.00044608116149902
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
331 0.0004 0.00044703483581543
SELECT * FROM products WHERE id = '4041'
332 0.0005 0.00047707557678223
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
333 0.0005 0.00050806999206543
SELECT * FROM product_image_select WHERE product_id = '4041'
334 0.0003 0.00034785270690918
SELECT * FROM productcustomimages WHERE product_id = '4041'
335 0.0010 0.0009920597076416
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
336 0.0004 0.00042295455932617
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
337 0.0003 0.00032281875610352
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
338 0.0003 0.00033807754516602
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
339 0.0004 0.00041508674621582
SELECT * FROM products WHERE id = '4312'
340 0.0004 0.00036501884460449
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
341 0.0005 0.00049901008605957
SELECT * FROM product_image_select WHERE product_id = '4312'
342 0.0003 0.00030684471130371
SELECT * FROM productcustomimages WHERE product_id = '4312'
343 0.0009 0.00091791152954102
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
344 0.0004 0.0004279613494873
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
345 0.0003 0.0003349781036377
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
346 0.0003 0.00033783912658691
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
347 0.0004 0.00040102005004883
SELECT * FROM products WHERE id = '777'
348 0.0004 0.00039196014404297
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
349 0.0005 0.00052905082702637
SELECT * FROM product_image_select WHERE product_id = '777'
350 0.0003 0.00030899047851562
SELECT * FROM productcustomimages WHERE product_id = '777'
351 0.0010 0.00098109245300293
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
352 0.0004 0.00042915344238281
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
353 0.0004 0.00035810470581055
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
354 0.0004 0.0004429817199707
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
355 0.0005 0.0004880428314209
SELECT * FROM products WHERE id = '3881'
356 0.0006 0.00055384635925293
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
357 0.0007 0.00068497657775879
SELECT * FROM product_image_select WHERE product_id = '3881'
358 0.0003 0.00034999847412109
SELECT * FROM productcustomimages WHERE product_id = '3881'
359 0.0013 0.0013360977172852
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
360 0.0004 0.00044608116149902
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
361 0.0003 0.00033402442932129
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
362 0.0004 0.00038599967956543
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
363 0.0004 0.0004429817199707
SELECT * FROM products WHERE id = '4213'
364 0.0005 0.0004889965057373
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
365 0.0005 0.00053095817565918
SELECT * FROM product_image_select WHERE product_id = '4213'
366 0.0003 0.00034880638122559
SELECT * FROM productcustomimages WHERE product_id = '4213'
367 0.0010 0.001025915145874
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
368 0.0004 0.00043797492980957
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
369 0.0003 0.00033187866210938
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
370 0.0004 0.00035691261291504
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
371 0.0020 0.0019679069519043
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
372 0.0006 0.00063395500183105
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
373 0.0025 0.0024759769439697
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
374 0.0015 0.0015430450439453
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
375 0.0005 0.00049281120300293
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
376 0.0007 0.00066089630126953
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
377 0.0007 0.00068116188049316
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'