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.6358659267426 385 1.2517 0


No Amazon API Requests Made.


App Debug - Total Time 1.6358659267426 seconds

Number Time From Start Name Description
1 0.31778812408447 Initialise Initialise FSB Function
2 0.33678507804871 App Controller Start Start of the App controller (called before the controller of every page)
3 1.1457209587097 App Controller End End of the App controller (called before the controller of every page)
4 1.1460599899292 Category Start Start of the category controller
5 1.1460609436035 Before Get Category Before getting the category information
6 1.1782069206238 After Get Category After getting the category information
7 1.1782081127167 Before Get Category List Before getting the updated category list
8 1.1785809993744 Start of getCategoryListByGroup Function Before first category groups query
9 1.1789350509644 After initial query Before first category groups query
10 1.1789360046387 Get Category List for Group Before the call to getCategoryList function
11 1.1789391040802 Start of GetCategoryList function Start of the function
12 1.1789410114288 Before getting categories Query to get specific category list
13 1.179386138916 After getting categories Query to get specific category list
14 1.1793880462646 Before getting category custom Before call to function getCategoryCustom
15 1.1942520141602 After getting category custom After call to function getCategoryCustom
16 1.1942539215088 Before getting sub category list Before call to recursive function getCategoryList
17 1.194256067276 Start of GetCategoryList function Start of the function
18 1.1942579746246 Before getting categories Query to get specific category list
19 1.1947429180145 After getting sub category list After call to recursive function getCategoryList
20 1.1947450637817 Before getting category custom Before call to function getCategoryCustom
21 1.2061400413513 After getting category custom After call to function getCategoryCustom
22 1.2061431407928 Before getting category custom Before call to function getCategoryCustom
23 1.2136449813843 After getting category custom After call to function getCategoryCustom
24 1.2136480808258 Before getting category custom Before call to function getCategoryCustom
25 1.219141960144 After getting category custom After call to function getCategoryCustom
26 1.2191460132599 Before getting category custom Before call to function getCategoryCustom
27 1.2243111133575 After getting category custom After call to function getCategoryCustom
28 1.2243130207062 Before getting category custom Before call to function getCategoryCustom
29 1.2297089099884 After getting category custom After call to function getCategoryCustom
30 1.2297101020813 End of GetCategoryList function End of the function
31 1.2297151088715 Get Category List for Group Before the call to getCategoryList function
32 1.2297170162201 Start of GetCategoryList function Start of the function
33 1.2297179698944 Before getting categories Query to get specific category list
34 1.2302639484406 End of getCategoryListByGroup Function Before return()
35 1.2302651405334 After Get Category List After getting the updated category list
36 1.2302660942078 Before Category Images Before getting the category images
37 1.2306659221649 After Category Images After getting the category images
38 1.23273396492 Before Sub Category Check Before checking for sub category or products category
39 1.2333679199219 Before Category Products Controller Before loading the category products controller
40 1.2338709831238 Start Category Products Start of Category Products Controller
41 1.2338860034943 After Pagination Options After pagination options in Category Products Controller
42 1.263934135437 After Cache After Cache checking in Category Products Controller
43 1.2877860069275 After Filter Options After getting filter options and SQL in Category Products Controller
44 1.3051071166992 After Counting Products After counting products in the Category Products Controller
45 1.3058090209961 After Counting Bundles After counting bundles in the Category Products Controller
46 1.3064639568329 After Counting Products After counting products in the Category Products Controller
47 1.3207199573517 After Getting Products After getting products and bundles in the Category Products Controller
48 1.3207609653473 After Pagination Links After getting pagination listing links in the Category Products Controller
49 1.3207609653473 After Getting Bundle Details After getting full details for the bundles in the Category Products Controller
50 1.4929060935974 After Getting Product Details After getting full product details in the Category Products Controller
51 1.5030040740967 After Getting Product/Bundle Reviews After getting full product/bundle customer review in the Category Products Controller
52 1.5081059932709 App_after Controller Start Start of the App_after controller (called after the controller of every page)
53 1.5127239227295 Before Get Options Before the call to getOptions in the tpl class
54 1.5885019302368 After Get Options After the call to getOptions in the tpl class
55 1.5887470245361 App_after Controller End End of the App_after controller (called after the controller of every page)
56 1.5887761116028 Before Smarty Before passing everything over to Smarty in the Category Products Controller
57 1.6358509063721 After Loading sub/product controller After checking for sub category or products category and then loading the relevant controller
58 1.6358559131622 Finalizing debug Before the debug is output to the page.
59 1.6358659267426 End of App This is the end of the app logging, final timestamp


Query Debug - 385 Database Queries. Total time 1.2517 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0011 0.0011370182037354
SELECT parameter, value FROM parameters
2 0.0050 0.0049941539764404
SELECT * FROM `bad_bots`
3 0.0004 0.00037121772766113
SET time_zone = 'Europe/London'
4 0.0028 0.002824068069458
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0031 0.0030970573425293
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"18.191.236.98\";}'
6 0.0037 0.0036690235137939
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1743502337'
7 0.0032 0.0032429695129395
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0006 0.00061511993408203
UPDATE autorun SET lastrun = '2025-04-01 10:12:17' WHERE id = '16'
9 0.0008 0.00082898139953613
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0034 0.00341796875
SELECT id FROM pages WHERE pagename = 'boites-the' LIMIT 1
11 0.0041 0.0040810108184814
SELECT id FROM products WHERE pagename = 'boites-the' AND hidden = 0 LIMIT 1
12 0.0038 0.0037810802459717
SELECT id FROM ebay_products WHERE pagename = 'boites-the'
13 0.0029 0.0029380321502686
SELECT id FROM custom_products WHERE pagename = 'boites-the'
14 0.0033 0.0032610893249512
SELECT id FROM categories WHERE pagename = 'boites-the' LIMIT 1
15 0.0044 0.0043799877166748
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
16 0.0266 0.026553153991699
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
17 0.0007 0.00074291229248047
SELECT * FROM pages WHERE pagename = 'boites-the'
18 0.0025 0.0025269985198975
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
19 0.0013 0.001338005065918
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
20 0.0006 0.00060606002807617
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.0011 0.0010640621185303
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
22 0.0022 0.0021779537200928
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
23 0.0017 0.001727819442749
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
24 0.7618 0.76177883148193
SELECT * FROM ipgeocountries WHERE INET_ATON('18.191.236.98') >= INET_ATON(ip_start) AND INET_ATON('18.191.236.98') <= INET_ATON(ip_end)
25 0.0024 0.0023930072784424
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
26 0.0014 0.0014159679412842
SELECT * FROM countryredirects WHERE countrycode = 'US'
27 0.0006 0.00057697296142578
SELECT * FROM categories WHERE pagename = 'boites-the'
28 0.0069 0.0069389343261719
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.0014 0.0014240741729736
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
30 0.0005 0.00046396255493164
SELECT id FROM categories WHERE parent_id = '26'
31 0.0066 0.0065629482269287
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.0017 0.001676082611084
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.00054812431335449
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.0017 0.0017309188842773
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
35 0.0005 0.0004570484161377
SELECT id FROM categories WHERE parent_id = '26'
36 0.0007 0.00071501731872559
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.0014 0.0014410018920898
SELECT * FROM productimages WHERE product_id = '4122' ORDER BY sortorder ASC
38 0.0012 0.0012149810791016
SELECT * FROM categoryimages WHERE category_id = 26
39 0.0012 0.0011539459228516
SELECT * FROM categorygroups WHERE id = '1'
40 0.0066 0.0065751075744629
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.00049090385437012
SELECT parent_id FROM categories WHERE id = '26'
42 0.0004 0.00036001205444336
SELECT parent_id FROM categories WHERE id = '26'
43 0.0003 0.00034308433532715
SELECT * FROM categorygroups ORDER BY sortorder ASC
44 0.0004 0.0004270076751709
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
45 0.0054 0.0053849220275879
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.0006 0.00058317184448242
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.00040507316589355
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
48 0.0004 0.00041389465332031
SELECT id FROM categories WHERE parent_id = '26'
49 0.0059 0.0058550834655762
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.0006 0.00064706802368164
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.0005 0.00053000450134277
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.00051498413085938
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
53 0.0004 0.00041508674621582
SELECT * FROM categorygroups WHERE id = '1'
54 0.0005 0.00047588348388672
SELECT * FROM categories WHERE parent_id = '26'  AND hidden = 0 ORDER BY sortorder ASC
55 0.0037 0.0037031173706055
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.0006 0.00057101249694824
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.0004 0.00040698051452637
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
58 0.0004 0.00040817260742188
SELECT id FROM categories WHERE parent_id = '27'
59 0.0042 0.004223108291626
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.0006 0.00055885314941406
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.00052404403686523
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.00048208236694336
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
63 0.0004 0.00043201446533203
SELECT * FROM categorygroups WHERE id = '1'
64 0.0017 0.0016529560089111
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.0007 0.00066113471984863
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.0005 0.00054097175598145
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
67 0.0005 0.00051283836364746
SELECT id FROM categories WHERE parent_id = '28'
68 0.0018 0.0018219947814941
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.00058412551879883
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.00061988830566406
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.0006 0.00055503845214844
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
72 0.0005 0.00047016143798828
SELECT * FROM categorygroups WHERE id = '1'
73 0.0007 0.00072193145751953
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.0005 0.00054812431335449
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.0004 0.00043702125549316
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
76 0.0005 0.00053286552429199
SELECT id FROM categories WHERE parent_id = '29'
77 0.0008 0.00082707405090332
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.0007 0.00065112113952637
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.0006 0.00062990188598633
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.00057220458984375
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
81 0.0005 0.00049090385437012
SELECT * FROM categorygroups WHERE id = '1'
82 0.0007 0.00072002410888672
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.0006 0.00058412551879883
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.0004 0.00044488906860352
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
85 0.0005 0.00050997734069824
SELECT id FROM categories WHERE parent_id = '30'
86 0.0008 0.00079917907714844
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.0005 0.00052499771118164
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.0006 0.00064396858215332
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.0005 0.00046896934509277
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
90 0.0004 0.0004270076751709
SELECT * FROM categorygroups WHERE id = '1'
91 0.0006 0.00064611434936523
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.0006 0.00055098533630371
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.0006 0.00055384635925293
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
94 0.0005 0.0005030632019043
SELECT id FROM categories WHERE parent_id = '31'
95 0.0009 0.00091218948364258
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.00058102607727051
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.00060606002807617
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.0005 0.00053691864013672
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
99 0.0005 0.00048112869262695
SELECT * FROM categorygroups WHERE id = '1'
100 0.0005 0.00054216384887695
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
101 0.0004 0.0003960132598877
SELECT * FROM categoryimages WHERE category_id = 26
102 0.0020 0.0020489692687988
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
103 0.0006 0.00062894821166992
SELECT * FROM categories WHERE parent_id = '26'
104 0.0092 0.0092258453369141
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
105 0.0022 0.0022368431091309
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
106 0.0024 0.0023510456085205
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
107 0.0072 0.0071659088134766
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
108 0.0020 0.0019600391387939
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
109 0.0007 0.00067687034606934
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
110 0.0163 0.016316890716553
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.0010 0.00098609924316406
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.0007 0.00069689750671387
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.0007 0.00065207481384277
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.0142 0.014219999313354
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 0, 18
115 0.0010 0.0009920597076416
SELECT * FROM products WHERE id = '4122'
116 0.0013 0.0013010501861572
SELECT * FROM productimages WHERE product_id = '4122' ORDER BY sortorder ASC
117 0.0056 0.0056319236755371
SELECT * FROM product_image_select WHERE product_id = '4122'
118 0.0087 0.0086770057678223
SELECT * FROM productcustomimages WHERE product_id = '4122'
119 0.0048 0.004763126373291
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4122' AND a.name = n.originalname
120 0.0031 0.0031120777130127
SELECT * FROM productoffers WHERE product_id = '4122' AND merchantid = 'A1X6FK5RDHNB96'
121 0.0007 0.00066304206848145
SELECT * FROM productoffers
                WHERE product_id = '4122' AND price > 0
                ORDER BY price ASC LIMIT 1
122 0.0008 0.00078296661376953
SELECT value FROM productattributes WHERE product_id = '4122' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
123 0.0008 0.00075101852416992
SELECT * FROM products WHERE id = '4287'
124 0.0006 0.00060319900512695
SELECT * FROM productimages WHERE product_id = '4287' ORDER BY sortorder ASC
125 0.0006 0.00063610076904297
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4287' AND p.id = pi.product_id ORDER BY pi.sortorder
126 0.0010 0.0009920597076416
SELECT * FROM product_image_select WHERE product_id = '4287'
127 0.0005 0.00048589706420898
SELECT * FROM productcustomimages WHERE product_id = '4287'
128 0.0007 0.00068998336791992
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 = '4287'
                GROUP BY o.product_id
129 0.0043 0.0043220520019531
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     = '4287'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
130 0.0005 0.00053095817565918
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4287
131 0.0010 0.00096297264099121
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4287' AND a.name = n.originalname
132 0.0004 0.00037598609924316
SELECT * FROM productoffers WHERE product_id = '4287' AND merchantid = 'A1X6FK5RDHNB96'
133 0.0004 0.00039887428283691
SELECT * FROM productoffers
                WHERE product_id = '4287' AND price > 0
                ORDER BY price ASC LIMIT 1
134 0.0004 0.00037479400634766
SELECT * FROM productoffers
                WHERE product_id = 4287
                ORDER BY price ASC LIMIT 1
135 0.0004 0.00036382675170898
SELECT value FROM productattributes
                WHERE product_id = '4287'
                AND name = 'ListPriceAmount'
136 0.0004 0.00042390823364258
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 = '4287'
                GROUP BY o.product_id
137 0.0008 0.00076484680175781
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     = '4287'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
138 0.0004 0.00042200088500977
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4287
139 0.0006 0.00064682960510254
SELECT value FROM productattributes WHERE product_id = '4287' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
140 0.0007 0.00073099136352539
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4287'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
141 0.0004 0.00044918060302734
SELECT * FROM products WHERE id = '2009'
142 0.0006 0.0005648136138916
SELECT * FROM productimages WHERE product_id = '2009' ORDER BY sortorder ASC
143 0.0006 0.00063395500183105
SELECT * FROM product_image_select WHERE product_id = '2009'
144 0.0004 0.00040817260742188
SELECT * FROM productcustomimages WHERE product_id = '2009'
145 0.0013 0.0012729167938232
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2009' AND a.name = n.originalname
146 0.0005 0.00051784515380859
SELECT * FROM productoffers WHERE product_id = '2009' AND merchantid = 'A1X6FK5RDHNB96'
147 0.0004 0.00040292739868164
SELECT * FROM productoffers
                WHERE product_id = '2009' AND price > 0
                ORDER BY price ASC LIMIT 1
148 0.0004 0.00041294097900391
SELECT value FROM productattributes WHERE product_id = '2009' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
149 0.0005 0.00052809715270996
SELECT * FROM products WHERE id = '770'
150 0.0005 0.00053000450134277
SELECT * FROM productimages WHERE product_id = '770' ORDER BY sortorder ASC
151 0.0006 0.00064611434936523
SELECT * FROM product_image_select WHERE product_id = '770'
152 0.0004 0.00041413307189941
SELECT * FROM productcustomimages WHERE product_id = '770'
153 0.0015 0.0014770030975342
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '770' AND a.name = n.originalname
154 0.0005 0.00048708915710449
SELECT * FROM productoffers WHERE product_id = '770' AND merchantid = 'A1X6FK5RDHNB96'
155 0.0004 0.00042295455932617
SELECT * FROM productoffers
                WHERE product_id = '770' AND price > 0
                ORDER BY price ASC LIMIT 1
156 0.0005 0.0004880428314209
SELECT value FROM productattributes WHERE product_id = '770' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
157 0.0006 0.0006101131439209
SELECT * FROM products WHERE id = '3809'
158 0.0005 0.00053000450134277
SELECT * FROM productimages WHERE product_id = '3809' ORDER BY sortorder ASC
159 0.0015 0.0014739036560059
SELECT * FROM product_image_select WHERE product_id = '3809'
160 0.0007 0.00072216987609863
SELECT * FROM productcustomimages WHERE product_id = '3809'
161 0.0025 0.0024669170379639
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3809' AND a.name = n.originalname
162 0.0010 0.00096392631530762
SELECT * FROM productoffers WHERE product_id = '3809' AND merchantid = 'A1X6FK5RDHNB96'
163 0.0007 0.00071310997009277
SELECT * FROM productoffers
                WHERE product_id = '3809' AND price > 0
                ORDER BY price ASC LIMIT 1
164 0.0008 0.00079703330993652
SELECT value FROM productattributes WHERE product_id = '3809' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
165 0.0010 0.0009770393371582
SELECT * FROM products WHERE id = '2698'
166 0.0012 0.0011520385742188
SELECT * FROM productimages WHERE product_id = '2698' ORDER BY sortorder ASC
167 0.0023 0.0022809505462646
SELECT * FROM product_image_select WHERE product_id = '2698'
168 0.0025 0.0024929046630859
SELECT * FROM productcustomimages WHERE product_id = '2698'
169 0.0039 0.0039329528808594
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2698' AND a.name = n.originalname
170 0.0014 0.0013771057128906
SELECT * FROM productoffers WHERE product_id = '2698' AND merchantid = 'A1X6FK5RDHNB96'
171 0.0006 0.00063705444335938
SELECT * FROM productoffers
                WHERE product_id = '2698' AND price > 0
                ORDER BY price ASC LIMIT 1
172 0.0007 0.00072789192199707
SELECT value FROM productattributes WHERE product_id = '2698' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
173 0.0009 0.00089001655578613
SELECT * FROM products WHERE id = '1273'
174 0.0008 0.00079011917114258
SELECT * FROM productimages WHERE product_id = '1273' ORDER BY sortorder ASC
175 0.0012 0.0011608600616455
SELECT * FROM product_image_select WHERE product_id = '1273'
176 0.0007 0.00068902969360352
SELECT * FROM productcustomimages WHERE product_id = '1273'
177 0.0023 0.0022599697113037
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1273' AND a.name = n.originalname
178 0.0008 0.00076198577880859
SELECT * FROM productoffers WHERE product_id = '1273' AND merchantid = 'A1X6FK5RDHNB96'
179 0.0006 0.00060296058654785
SELECT * FROM productoffers
                WHERE product_id = '1273' AND price > 0
                ORDER BY price ASC LIMIT 1
180 0.0005 0.00054597854614258
SELECT * FROM productoffers
                WHERE product_id = 1273
                ORDER BY price ASC LIMIT 1
181 0.0009 0.0008540153503418
SELECT value FROM productattributes
                WHERE product_id = '1273'
                AND name = 'ListPriceAmount'
182 0.0008 0.00077390670776367
SELECT value FROM productattributes WHERE product_id = '1273' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
183 0.0009 0.00088691711425781
SELECT * FROM products WHERE id = '822'
184 0.0010 0.001025915145874
SELECT * FROM productimages WHERE product_id = '822' ORDER BY sortorder ASC
185 0.0008 0.00084090232849121
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '822' AND p.id = pi.product_id ORDER BY pi.sortorder
186 0.0009 0.00093984603881836
SELECT * FROM product_image_select WHERE product_id = '822'
187 0.0005 0.00054693222045898
SELECT * FROM productcustomimages WHERE product_id = '822'
188 0.0008 0.00076985359191895
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 = '822'
                GROUP BY o.product_id
189 0.0010 0.0010340213775635
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     = '822'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
190 0.0006 0.00057101249694824
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 822
191 0.0023 0.0023398399353027
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '822' AND a.name = n.originalname
192 0.0007 0.00065398216247559
SELECT * FROM productoffers WHERE product_id = '822' AND merchantid = 'A1X6FK5RDHNB96'
193 0.0007 0.00066304206848145
SELECT * FROM productoffers
                WHERE product_id = '822' AND price > 0
                ORDER BY price ASC LIMIT 1
194 0.0007 0.00065708160400391
SELECT * FROM productoffers
                WHERE product_id = 822
                ORDER BY price ASC LIMIT 1
195 0.0007 0.00069880485534668
SELECT value FROM productattributes
                WHERE product_id = '822'
                AND name = 'ListPriceAmount'
196 0.0007 0.00068306922912598
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 = '822'
                GROUP BY o.product_id
197 0.0009 0.00091409683227539
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     = '822'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
198 0.0006 0.00057005882263184
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 822
199 0.0007 0.00074005126953125
SELECT value FROM productattributes WHERE product_id = '822' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
200 0.0008 0.00081014633178711
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '822'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
201 0.0005 0.00054788589477539
SELECT * FROM products WHERE id = '836'
202 0.0007 0.00067806243896484
SELECT * FROM productimages WHERE product_id = '836' ORDER BY sortorder ASC
203 0.0008 0.00081515312194824
SELECT * FROM product_image_select WHERE product_id = '836'
204 0.0006 0.00057005882263184
SELECT * FROM productcustomimages WHERE product_id = '836'
205 0.0013 0.0013351440429688
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '836' AND a.name = n.originalname
206 0.0007 0.00069189071655273
SELECT * FROM productoffers WHERE product_id = '836' AND merchantid = 'A1X6FK5RDHNB96'
207 0.0009 0.00088095664978027
SELECT * FROM productoffers
                WHERE product_id = '836' AND price > 0
                ORDER BY price ASC LIMIT 1
208 0.0009 0.00090384483337402
SELECT value FROM productattributes WHERE product_id = '836' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
209 0.0012 0.0012428760528564
SELECT * FROM products WHERE id = '1979'
210 0.0010 0.00099802017211914
SELECT * FROM productimages WHERE product_id = '1979' ORDER BY sortorder ASC
211 0.0014 0.001384973526001
SELECT * FROM product_image_select WHERE product_id = '1979'
212 0.0008 0.00076603889465332
SELECT * FROM productcustomimages WHERE product_id = '1979'
213 0.0019 0.0018761157989502
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1979' AND a.name = n.originalname
214 0.0009 0.00094008445739746
SELECT * FROM productoffers WHERE product_id = '1979' AND merchantid = 'A1X6FK5RDHNB96'
215 0.0008 0.00076413154602051
SELECT * FROM productoffers
                WHERE product_id = '1979' AND price > 0
                ORDER BY price ASC LIMIT 1
216 0.0008 0.00079488754272461
SELECT value FROM productattributes WHERE product_id = '1979' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
217 0.0010 0.00096416473388672
SELECT * FROM products WHERE id = '1274'
218 0.0010 0.0009610652923584
SELECT * FROM productimages WHERE product_id = '1274' ORDER BY sortorder ASC
219 0.0012 0.0012321472167969
SELECT * FROM product_image_select WHERE product_id = '1274'
220 0.0007 0.0006561279296875
SELECT * FROM productcustomimages WHERE product_id = '1274'
221 0.0021 0.0021059513092041
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1274' AND a.name = n.originalname
222 0.0008 0.00083017349243164
SELECT * FROM productoffers WHERE product_id = '1274' AND merchantid = 'A1X6FK5RDHNB96'
223 0.0006 0.00062298774719238
SELECT * FROM productoffers
                WHERE product_id = '1274' AND price > 0
                ORDER BY price ASC LIMIT 1
224 0.0007 0.00074005126953125
SELECT value FROM productattributes WHERE product_id = '1274' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
225 0.0008 0.00083112716674805
SELECT * FROM products WHERE id = '850'
226 0.0009 0.00093698501586914
SELECT * FROM productimages WHERE product_id = '850' ORDER BY sortorder ASC
227 0.0008 0.00083303451538086
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '850' AND p.id = pi.product_id ORDER BY pi.sortorder
228 0.0010 0.0009770393371582
SELECT * FROM product_image_select WHERE product_id = '850'
229 0.0007 0.00065898895263672
SELECT * FROM productcustomimages WHERE product_id = '850'
230 0.0009 0.00089716911315918
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 = '850'
                GROUP BY o.product_id
231 0.0009 0.00092911720275879
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     = '850'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
232 0.0007 0.00071382522583008
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 850
233 0.0014 0.0014240741729736
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '850' AND a.name = n.originalname
234 0.0005 0.00046706199645996
SELECT * FROM productoffers WHERE product_id = '850' AND merchantid = 'A1X6FK5RDHNB96'
235 0.0005 0.00050187110900879
SELECT * FROM productoffers
                WHERE product_id = '850' AND price > 0
                ORDER BY price ASC LIMIT 1
236 0.0004 0.00044107437133789
SELECT * FROM productoffers
                WHERE product_id = 850
                ORDER BY price ASC LIMIT 1
237 0.0005 0.00046896934509277
SELECT value FROM productattributes
                WHERE product_id = '850'
                AND name = 'ListPriceAmount'
238 0.0006 0.00059199333190918
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 = '850'
                GROUP BY o.product_id
239 0.0010 0.0010209083557129
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     = '850'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
240 0.0006 0.00058293342590332
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 850
241 0.0008 0.00075793266296387
SELECT value FROM productattributes WHERE product_id = '850' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
242 0.0008 0.00081396102905273
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '850'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
243 0.0006 0.00056910514831543
SELECT * FROM products WHERE parent_id = '850'
244 0.0007 0.00073480606079102
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4891' AND a.name = n.originalname
245 0.0006 0.00058484077453613
SELECT * FROM productoffers WHERE product_id = '4891' AND merchantid = 'A1X6FK5RDHNB96'
246 0.0005 0.00046896934509277
SELECT * FROM productoffers
                WHERE product_id = '4891' AND price > 0
                ORDER BY price ASC LIMIT 1
247 0.0005 0.0005340576171875
SELECT * FROM products WHERE id = '2204'
248 0.0006 0.00064897537231445
SELECT * FROM productimages WHERE product_id = '2204' ORDER BY sortorder ASC
249 0.0009 0.00085806846618652
SELECT * FROM product_image_select WHERE product_id = '2204'
250 0.0006 0.00059318542480469
SELECT * FROM productcustomimages WHERE product_id = '2204'
251 0.0016 0.0016381740570068
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2204' AND a.name = n.originalname
252 0.0007 0.00065493583679199
SELECT * FROM productoffers WHERE product_id = '2204' AND merchantid = 'A1X6FK5RDHNB96'
253 0.0005 0.00052905082702637
SELECT * FROM productoffers
                WHERE product_id = '2204' AND price > 0
                ORDER BY price ASC LIMIT 1
254 0.0006 0.00060296058654785
SELECT value FROM productattributes WHERE product_id = '2204' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
255 0.0007 0.00071310997009277
SELECT * FROM products WHERE id = '1340'
256 0.0006 0.00064992904663086
SELECT * FROM productimages WHERE product_id = '1340' ORDER BY sortorder ASC
257 0.0009 0.00091004371643066
SELECT * FROM product_image_select WHERE product_id = '1340'
258 0.0006 0.00059080123901367
SELECT * FROM productcustomimages WHERE product_id = '1340'
259 0.0014 0.0014081001281738
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1340' AND a.name = n.originalname
260 0.0006 0.00056290626525879
SELECT * FROM productoffers WHERE product_id = '1340' AND merchantid = 'A1X6FK5RDHNB96'
261 0.0005 0.00046181678771973
SELECT * FROM productoffers
                WHERE product_id = '1340' AND price > 0
                ORDER BY price ASC LIMIT 1
262 0.0006 0.00056099891662598
SELECT value FROM productattributes WHERE product_id = '1340' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
263 0.0006 0.00061702728271484
SELECT * FROM products WHERE id = '1303'
264 0.0007 0.00068092346191406
SELECT * FROM productimages WHERE product_id = '1303' ORDER BY sortorder ASC
265 0.0008 0.00075602531433105
SELECT * FROM product_image_select WHERE product_id = '1303'
266 0.0004 0.00042104721069336
SELECT * FROM productcustomimages WHERE product_id = '1303'
267 0.0012 0.0012040138244629
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1303' AND a.name = n.originalname
268 0.0005 0.00046920776367188
SELECT * FROM productoffers WHERE product_id = '1303' AND merchantid = 'A1X6FK5RDHNB96'
269 0.0004 0.00036883354187012
SELECT * FROM productoffers
                WHERE product_id = '1303' AND price > 0
                ORDER BY price ASC LIMIT 1
270 0.0003 0.00033712387084961
SELECT * FROM productoffers
                WHERE product_id = 1303
                ORDER BY price ASC LIMIT 1
271 0.0004 0.00041890144348145
SELECT value FROM productattributes
                WHERE product_id = '1303'
                AND name = 'ListPriceAmount'
272 0.0005 0.0004580020904541
SELECT value FROM productattributes WHERE product_id = '1303' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
273 0.0005 0.00052213668823242
SELECT * FROM products WHERE id = '1088'
274 0.0004 0.0004429817199707
SELECT * FROM productimages WHERE product_id = '1088' ORDER BY sortorder ASC
275 0.0006 0.00057196617126465
SELECT * FROM product_image_select WHERE product_id = '1088'
276 0.0004 0.0004119873046875
SELECT * FROM productcustomimages WHERE product_id = '1088'
277 0.0010 0.00099611282348633
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1088' AND a.name = n.originalname
278 0.0005 0.00047397613525391
SELECT * FROM productoffers WHERE product_id = '1088' AND merchantid = 'A1X6FK5RDHNB96'
279 0.0004 0.00040292739868164
SELECT * FROM productoffers
                WHERE product_id = '1088' AND price > 0
                ORDER BY price ASC LIMIT 1
280 0.0005 0.00047898292541504
SELECT value FROM productattributes WHERE product_id = '1088' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
281 0.0005 0.00049614906311035
SELECT * FROM products WHERE id = '1470'
282 0.0006 0.00064206123352051
SELECT * FROM productimages WHERE product_id = '1470' ORDER BY sortorder ASC
283 0.0007 0.00070500373840332
SELECT * FROM product_image_select WHERE product_id = '1470'
284 0.0004 0.00044894218444824
SELECT * FROM productcustomimages WHERE product_id = '1470'
285 0.0012 0.0012478828430176
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1470' AND a.name = n.originalname
286 0.0006 0.00057220458984375
SELECT * FROM productoffers WHERE product_id = '1470' AND merchantid = 'A1X6FK5RDHNB96'
287 0.0005 0.00045394897460938
SELECT * FROM productoffers
                WHERE product_id = '1470' AND price > 0
                ORDER BY price ASC LIMIT 1
288 0.0005 0.00049710273742676
SELECT * FROM productoffers
                WHERE product_id = 1470
                ORDER BY price ASC LIMIT 1
289 0.0005 0.00049614906311035
SELECT value FROM productattributes
                WHERE product_id = '1470'
                AND name = 'ListPriceAmount'
290 0.0005 0.00045609474182129
SELECT value FROM productattributes WHERE product_id = '1470' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
291 0.0006 0.00055813789367676
SELECT * FROM products WHERE id = '2156'
292 0.0005 0.00049901008605957
SELECT * FROM productimages WHERE product_id = '2156' ORDER BY sortorder ASC
293 0.0006 0.00061798095703125
SELECT * FROM product_image_select WHERE product_id = '2156'
294 0.0004 0.00039005279541016
SELECT * FROM productcustomimages WHERE product_id = '2156'
295 0.0009 0.00085783004760742
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2156' AND a.name = n.originalname
296 0.0006 0.0005948543548584
SELECT * FROM productoffers WHERE product_id = '2156' AND merchantid = 'A1X6FK5RDHNB96'
297 0.0004 0.00041794776916504
SELECT * FROM productoffers
                WHERE product_id = '2156' AND price > 0
                ORDER BY price ASC LIMIT 1
298 0.0004 0.00044894218444824
SELECT value FROM productattributes WHERE product_id = '2156' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
299 0.0018 0.0017588138580322
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4122' ORDER BY timestamp DESC
300 0.0003 0.00031304359436035
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4287' ORDER BY timestamp DESC
301 0.0003 0.00029397010803223
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2009' ORDER BY timestamp DESC
302 0.0004 0.00043416023254395
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '770' ORDER BY timestamp DESC
303 0.0005 0.00049901008605957
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3809' ORDER BY timestamp DESC
304 0.0004 0.00036716461181641
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2698' ORDER BY timestamp DESC
305 0.0003 0.00033211708068848
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1273' ORDER BY timestamp DESC
306 0.0003 0.00031709671020508
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '822' ORDER BY timestamp DESC
307 0.0007 0.00068020820617676
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '836' ORDER BY timestamp DESC
308 0.0008 0.00082302093505859
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1979' ORDER BY timestamp DESC
309 0.0004 0.00039291381835938
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1274' ORDER BY timestamp DESC
310 0.0004 0.00039005279541016
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '850' ORDER BY timestamp DESC
311 0.0004 0.00036311149597168
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2204' ORDER BY timestamp DESC
312 0.0004 0.00041389465332031
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1340' ORDER BY timestamp DESC
313 0.0004 0.00040602684020996
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1303' ORDER BY timestamp DESC
314 0.0004 0.00037693977355957
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1088' ORDER BY timestamp DESC
315 0.0009 0.0008540153503418
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1470' ORDER BY timestamp DESC
316 0.0010 0.0009760856628418
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2156' ORDER BY timestamp DESC
317 0.0014 0.0014410018920898
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
318 0.0016 0.0015571117401123
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
319 0.0015 0.0015010833740234
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
320 0.0039 0.0038578510284424
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
321 0.0007 0.0006868839263916
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
322 0.0242 0.02422308921814
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
323 0.0020 0.0019979476928711
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
324 0.0008 0.00084614753723145
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
325 0.0006 0.00057196617126465
SELECT * FROM products WHERE id = 1626
326 0.0004 0.00043606758117676
SELECT * FROM products WHERE id = 4041
327 0.0004 0.00043797492980957
SELECT * FROM products WHERE id = 4312
328 0.0005 0.0004889965057373
SELECT * FROM products WHERE id = 777
329 0.0004 0.00044393539428711
SELECT * FROM products WHERE id = 3881
330 0.0004 0.00043106079101562
SELECT * FROM products WHERE id = 4213
331 0.0004 0.00041294097900391
SELECT * FROM products WHERE id = '1626'
332 0.0005 0.00050497055053711
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
333 0.0007 0.00068187713623047
SELECT * FROM product_image_select WHERE product_id = '1626'
334 0.0004 0.00042200088500977
SELECT * FROM productcustomimages WHERE product_id = '1626'
335 0.0009 0.00089406967163086
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
336 0.0005 0.00054502487182617
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
337 0.0005 0.00046896934509277
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
338 0.0005 0.00045394897460938
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
339 0.0005 0.00051522254943848
SELECT * FROM products WHERE id = '4041'
340 0.0005 0.00046300888061523
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
341 0.0008 0.0007631778717041
SELECT * FROM product_image_select WHERE product_id = '4041'
342 0.0007 0.00066709518432617
SELECT * FROM productcustomimages WHERE product_id = '4041'
343 0.0016 0.0015561580657959
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
344 0.0007 0.00066089630126953
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
345 0.0005 0.00051712989807129
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
346 0.0005 0.00052499771118164
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
347 0.0005 0.00054407119750977
SELECT * FROM products WHERE id = '4312'
348 0.0006 0.00057697296142578
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
349 0.0006 0.00059890747070312
SELECT * FROM product_image_select WHERE product_id = '4312'
350 0.0004 0.00044107437133789
SELECT * FROM productcustomimages WHERE product_id = '4312'
351 0.0013 0.0012772083282471
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
352 0.0005 0.00053811073303223
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
353 0.0004 0.00040984153747559
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
354 0.0004 0.00041699409484863
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
355 0.0005 0.0005190372467041
SELECT * FROM products WHERE id = '777'
356 0.0005 0.00050497055053711
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
357 0.0007 0.00065517425537109
SELECT * FROM product_image_select WHERE product_id = '777'
358 0.0004 0.0003809928894043
SELECT * FROM productcustomimages WHERE product_id = '777'
359 0.0011 0.0011069774627686
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
360 0.0005 0.00049304962158203
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
361 0.0005 0.00048494338989258
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
362 0.0005 0.00045490264892578
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
363 0.0005 0.00053811073303223
SELECT * FROM products WHERE id = '3881'
364 0.0006 0.00060415267944336
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
365 0.0006 0.00059199333190918
SELECT * FROM product_image_select WHERE product_id = '3881'
366 0.0004 0.00042891502380371
SELECT * FROM productcustomimages WHERE product_id = '3881'
367 0.0011 0.0011398792266846
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
368 0.0005 0.00051403045654297
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
369 0.0005 0.00047492980957031
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
370 0.0006 0.00059890747070312
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
371 0.0007 0.00070405006408691
SELECT * FROM products WHERE id = '4213'
372 0.0007 0.00066304206848145
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
373 0.0007 0.00066399574279785
SELECT * FROM product_image_select WHERE product_id = '4213'
374 0.0004 0.00040102005004883
SELECT * FROM productcustomimages WHERE product_id = '4213'
375 0.0019 0.0019140243530273
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
376 0.0006 0.00063800811767578
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
377 0.0005 0.00049591064453125
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
378 0.0005 0.00052404403686523
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
379 0.0027 0.0027029514312744
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
380 0.0012 0.0012128353118896
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
381 0.0053 0.0053441524505615
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
382 0.0034 0.00343918800354
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
383 0.0007 0.00067710876464844
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
384 0.0014 0.0014128684997559
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
385 0.0012 0.0011889934539795
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'