0

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.8082849979401 406 1.2166 0


No Amazon API Requests Made.


App Debug - Total Time 1.8082849979401 seconds

Number Time From Start Name Description
1 0.3861289024353 Initialise Initialise FSB Function
2 0.38962197303772 App Controller Start Start of the App controller (called before the controller of every page)
3 0.43290209770203 Start of getCategoryListByGroup Function Before first category groups query
4 0.43455410003662 After initial query Before first category groups query
5 0.43455505371094 Get Category List for Group Before the call to getCategoryList function
6 0.43455600738525 Start of GetCategoryList function Start of the function
7 0.43455696105957 Before getting categories Query to get specific category list
8 0.43621206283569 After getting categories Query to get specific category list
9 0.43621206283569 Before getting category custom Before call to function getCategoryCustom
10 0.45854902267456 After getting category custom After call to function getCategoryCustom
11 0.45854997634888 Before getting category custom Before call to function getCategoryCustom
12 0.48504495620728 After getting category custom After call to function getCategoryCustom
13 0.4850480556488 Before getting category custom Before call to function getCategoryCustom
14 0.49448299407959 After getting category custom After call to function getCategoryCustom
15 0.49448490142822 Before getting category custom Before call to function getCategoryCustom
16 0.50066208839417 After getting category custom After call to function getCategoryCustom
17 0.5006639957428 Before getting category custom Before call to function getCategoryCustom
18 0.50530004501343 After getting category custom After call to function getCategoryCustom
19 0.50530099868774 Before getting category custom Before call to function getCategoryCustom
20 0.50938200950623 After getting category custom After call to function getCategoryCustom
21 0.50938391685486 End of GetCategoryList function End of the function
22 0.50938892364502 Get Category List for Group Before the call to getCategoryList function
23 0.50939011573792 Start of GetCategoryList function Start of the function
24 0.50939106941223 Before getting categories Query to get specific category list
25 0.50980496406555 End of getCategoryListByGroup Function Before return()
26 1.339968919754 App Controller End End of the App controller (called before the controller of every page)
27 1.5203280448914 App_after Controller Start Start of the App_after controller (called after the controller of every page)
28 1.5220799446106 Before Get Options Before the call to getOptions in the tpl class
29 1.5928399562836 After Get Options After the call to getOptions in the tpl class
30 1.5928740501404 App_after Controller End End of the App_after controller (called after the controller of every page)
31 1.8082759380341 Finalizing debug Before the debug is output to the page.
32 1.8082849979401 End of App This is the end of the app logging, final timestamp


Query Debug - 406 Database Queries. Total time 1.2166 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0022 0.0022439956665039
SELECT parameter, value FROM parameters
2 0.0044 0.0043799877166748
SELECT * FROM `bad_bots`
3 0.0003 0.00030899047851562
SET time_zone = 'Europe/London'
4 0.0021 0.0021040439605713
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0023 0.0023047924041748
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"18.225.234.109\";}'
6 0.0020 0.001967191696167
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1747083702'
7 0.0023 0.0022969245910645
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0004 0.00042891502380371
UPDATE autorun SET lastrun = '2025-05-12 21:01:42' WHERE id = '15'
9 0.0005 0.00053310394287109
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0021 0.0020768642425537
SELECT id FROM pages WHERE pagename = 'search' LIMIT 1
11 0.0004 0.00038313865661621
SELECT * FROM pages WHERE id = 52
12 0.0029 0.0029399394989014
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13 0.0392 0.039153099060059
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14 0.0008 0.00082087516784668
SELECT * FROM pages WHERE pagename = 'search'
15 0.0016 0.0016469955444336
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0016 0.0016469955444336
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0078 0.0078439712524414
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
18 0.0021 0.0020599365234375
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
19 0.0012 0.0012381076812744
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20 0.0004 0.00041294097900391
SELECT id FROM categories WHERE parent_id = '26'
21 0.0056 0.0055990219116211
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 
22 0.0016 0.0016250610351562
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 
23 0.0015 0.0015408992767334
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
24 0.0015 0.0014760494232178
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25 0.0005 0.00047016143798828
SELECT * FROM categorygroups WHERE id = '1'
26 0.0135 0.013524055480957
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
27 0.0018 0.0017518997192383
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
28 0.0009 0.00094985961914062
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29 0.0012 0.0012359619140625
SELECT id FROM categories WHERE parent_id = '27'
30 0.0062 0.0062141418457031
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 
31 0.0008 0.00080394744873047
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 
32 0.0008 0.00081181526184082
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
33 0.0006 0.0006110668182373
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34 0.0005 0.00054001808166504
SELECT * FROM categorygroups WHERE id = '1'
35 0.0030 0.0029621124267578
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
36 0.0008 0.00084495544433594
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
37 0.0006 0.00062704086303711
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38 0.0005 0.00053095817565918
SELECT id FROM categories WHERE parent_id = '28'
39 0.0020 0.0019810199737549
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 
40 0.0006 0.00060105323791504
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 
41 0.0006 0.00061678886413574
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
42 0.0007 0.00065088272094727
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43 0.0006 0.00057387351989746
SELECT * FROM categorygroups WHERE id = '1'
44 0.0009 0.00088882446289062
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
45 0.0006 0.00063204765319824
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
46 0.0006 0.00055193901062012
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47 0.0006 0.00057005882263184
SELECT id FROM categories WHERE parent_id = '29'
48 0.0011 0.0010731220245361
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 
49 0.0007 0.00071001052856445
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 
50 0.0007 0.00070095062255859
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
51 0.0005 0.00054001808166504
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52 0.0005 0.00046801567077637
SELECT * FROM categorygroups WHERE id = '1'
53 0.0007 0.00071310997009277
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
54 0.0005 0.00047802925109863
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
55 0.0004 0.0003960132598877
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56 0.0004 0.00036501884460449
SELECT id FROM categories WHERE parent_id = '30'
57 0.0007 0.00070405006408691
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 
58 0.0005 0.0005180835723877
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 
59 0.0006 0.00055503845214844
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
60 0.0005 0.00049090385437012
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61 0.0004 0.00038599967956543
SELECT * FROM categorygroups WHERE id = '1'
62 0.0006 0.00059795379638672
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
63 0.0004 0.00042891502380371
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
64 0.0004 0.00035786628723145
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65 0.0004 0.00035500526428223
SELECT id FROM categories WHERE parent_id = '31'
66 0.0006 0.00063514709472656
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 
67 0.0004 0.00043010711669922
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 
68 0.0005 0.00046992301940918
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
69 0.0004 0.00041389465332031
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70 0.0004 0.0003659725189209
SELECT * FROM categorygroups WHERE id = '1'
71 0.0004 0.00041007995605469
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
72 0.0030 0.0029828548431396
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73 0.0015 0.0015299320220947
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74 0.0005 0.00052618980407715
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
75 0.0012 0.0011539459228516
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76 0.0011 0.0010569095611572
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77 0.0008 0.00080204010009766
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78 0.8152 0.81523108482361
SELECT * FROM ipgeocountries WHERE INET_ATON('18.225.234.109') >= INET_ATON(ip_start) AND INET_ATON('18.225.234.109') <= INET_ATON(ip_end)
79 0.0032 0.0031840801239014
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80 0.0022 0.0022211074829102
SELECT * FROM countryredirects WHERE countrycode = 'US'
81 0.0006 0.00061511993408203
SELECT * FROM pages WHERE pagename = 'search'
82 0.0063 0.0062570571899414
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
83 0.0037 0.0036659240722656
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
84 0.0036 0.0035791397094727
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
85 0.0063 0.0062978267669678
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
86 0.0016 0.0016179084777832
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
87 0.0005 0.00046014785766602
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
88 0.0018 0.0017948150634766
INSERT INTO searches (`keywords`, `timestamp`, `ip`) SELECT '3', NOW(), '18.225.234.109'
89 0.0007 0.00072884559631348
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (title)
    AGAINST ('+3' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (title) AGAINST ('+3' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (title)
        AGAINST ('+3'), 'bundle' AS type FROM bundles b
		WHERE MATCH (title) AGAINST ('+3' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1
90 0.0005 0.00048685073852539
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+3' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary)
        AGAINST ('+3'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1
91 0.0040 0.004019021987915
SELECT DISTINCT (p.id), salesrank, price, linktitle,
          'product' AS type
          FROM products p 
		WHERE ((description LIKE '3') OR (keyfeatures LIKE '3') OR (title LIKE '3'))

		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1
92 0.0006 0.00056004524230957
SELECT DISTINCT (p.id), price, linktitle,
          'ebayproduct' AS type
          FROM ebay_products p 
		WHERE ((description LIKE '3') OR (title LIKE '3'))
		AND hide = 0
93 0.0005 0.00046801567077637
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE '3') OR (title LIKE '3'))
		AND hide = 0
94 0.0005 0.00052499771118164
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+3' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary)
        AGAINST ('+3'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1
95 0.0046 0.0046310424804688
SELECT DISTINCT (p.id), salesrank, price, linktitle,
          'product' AS type
          FROM products p 
		WHERE ((description LIKE '%3%') OR (keyfeatures LIKE '%3%') OR (title LIKE '%3%'))

		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1
96 0.0003 0.00034093856811523
SELECT DISTINCT (p.id), price, linktitle,
          'ebayproduct' AS type
          FROM ebay_products p 
		WHERE ((description LIKE '%3%') OR (title LIKE '%3%'))
		AND hide = 0
97 0.0003 0.00027990341186523
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE '%3%') OR (title LIKE '%3%'))
		AND hide = 0
98 0.0005 0.00049209594726562
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (title)
    AGAINST ('+3' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (title) AGAINST ('+3' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (title)
        AGAINST ('+3'), 'bundle' AS type FROM bundles b
		WHERE MATCH (title) AGAINST ('+3' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
99 0.0005 0.00046181678771973
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+3' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary)
        AGAINST ('+3'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
100 0.0038 0.0038259029388428
SELECT DISTINCT (p.id), salesrank, price, linktitle,
          'product' AS type
          FROM products p 
		WHERE ((description LIKE '3') OR (keyfeatures LIKE '3') OR (title LIKE '3'))

		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
101 0.0003 0.0003361701965332
SELECT DISTINCT (p.id), price, linktitle,
          'ebayproduct' AS type
          FROM ebay_products p 
		WHERE ((description LIKE '3') OR (title LIKE '3'))
		AND hide = 0
102 0.0003 0.00026702880859375
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE '3') OR (title LIKE '3'))
		AND hide = 0
103 0.0005 0.00048589706420898
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+3' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary)
        AGAINST ('+3'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
104 0.0047 0.0047099590301514
SELECT DISTINCT (p.id), salesrank, price, linktitle,
          'product' AS type
          FROM products p 
		WHERE ((description LIKE '%3%') OR (keyfeatures LIKE '%3%') OR (title LIKE '%3%'))

		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
105 0.0004 0.0003969669342041
SELECT DISTINCT (p.id), price, linktitle,
          'ebayproduct' AS type
          FROM ebay_products p 
		WHERE ((description LIKE '%3%') OR (title LIKE '%3%'))
		AND hide = 0
106 0.0003 0.00034594535827637
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE '%3%') OR (title LIKE '%3%'))
		AND hide = 0
107 0.0004 0.00042390823364258
SELECT * FROM products WHERE id = '2017'
108 0.0017 0.0016779899597168
SELECT * FROM productimages WHERE product_id = '2017' ORDER BY sortorder ASC
109 0.0015 0.0015490055084229
SELECT * FROM product_image_select WHERE product_id = '2017'
110 0.0011 0.0011420249938965
SELECT * FROM productcustomimages WHERE product_id = '2017'
111 0.0017 0.0017199516296387
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2017' AND a.name = n.originalname
112 0.0014 0.0013680458068848
SELECT * FROM productoffers WHERE product_id = '2017' AND merchantid = 'A1X6FK5RDHNB96'
113 0.0004 0.00035977363586426
SELECT * FROM productoffers
                WHERE product_id = '2017' AND price > 0
                ORDER BY price ASC LIMIT 1
114 0.0003 0.00032496452331543
SELECT * FROM productoffers
                WHERE product_id = 2017
                ORDER BY price ASC LIMIT 1
115 0.0005 0.00046014785766602
SELECT value FROM productattributes
                WHERE product_id = '2017'
                AND name = 'ListPriceAmount'
116 0.0004 0.00037002563476562
SELECT value FROM productattributes WHERE product_id = '2017' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
117 0.0005 0.00048685073852539
SELECT * FROM products WHERE id = '2024'
118 0.0004 0.00044679641723633
SELECT * FROM productimages WHERE product_id = '2024' ORDER BY sortorder ASC
119 0.0004 0.00041699409484863
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2024' AND p.id = pi.product_id ORDER BY pi.sortorder
120 0.0005 0.00054287910461426
SELECT * FROM product_image_select WHERE product_id = '2024'
121 0.0004 0.00036096572875977
SELECT * FROM productcustomimages WHERE product_id = '2024'
122 0.0005 0.00048184394836426
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 = '2024'
                GROUP BY o.product_id
123 0.0024 0.0023560523986816
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     = '2024'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
124 0.0005 0.0005488395690918
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2024
125 0.0009 0.00092196464538574
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2024' AND a.name = n.originalname
126 0.0004 0.00040817260742188
SELECT * FROM productoffers WHERE product_id = '2024' AND merchantid = 'A1X6FK5RDHNB96'
127 0.0004 0.00037598609924316
SELECT * FROM productoffers
                WHERE product_id = '2024' AND price > 0
                ORDER BY price ASC LIMIT 1
128 0.0003 0.00030803680419922
SELECT * FROM productoffers
                WHERE product_id = 2024
                ORDER BY price ASC LIMIT 1
129 0.0005 0.00049710273742676
SELECT value FROM productattributes
                WHERE product_id = '2024'
                AND name = 'ListPriceAmount'
130 0.0006 0.00057792663574219
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 = '2024'
                GROUP BY o.product_id
131 0.0006 0.00064301490783691
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     = '2024'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
132 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 = 2024
133 0.0006 0.00061202049255371
SELECT value FROM productattributes WHERE product_id = '2024' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
134 0.0006 0.00055813789367676
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '2024'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Style'
                GROUP BY o.value
                ORDER BY o.value ASC
135 0.0005 0.00046801567077637
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '2024'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
136 0.0004 0.00042414665222168
SELECT * FROM products WHERE parent_id = '2024'
137 0.0006 0.000640869140625
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2846' AND a.name = n.originalname
138 0.0005 0.00051188468933105
SELECT * FROM productoffers WHERE product_id = '2846' AND merchantid = 'A1X6FK5RDHNB96'
139 0.0004 0.00040388107299805
SELECT * FROM productoffers
                WHERE product_id = '2846' AND price > 0
                ORDER BY price ASC LIMIT 1
140 0.0004 0.00043010711669922
SELECT * FROM products WHERE id = '2521'
141 0.0006 0.00057506561279297
SELECT * FROM productimages WHERE product_id = '2521' ORDER BY sortorder ASC
142 0.0006 0.00059103965759277
SELECT * FROM product_image_select WHERE product_id = '2521'
143 0.0004 0.00040793418884277
SELECT * FROM productcustomimages WHERE product_id = '2521'
144 0.0008 0.00077986717224121
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2521' AND a.name = n.originalname
145 0.0005 0.00050497055053711
SELECT * FROM productoffers WHERE product_id = '2521' AND merchantid = 'A1X6FK5RDHNB96'
146 0.0004 0.00037312507629395
SELECT * FROM productoffers
                WHERE product_id = '2521' AND price > 0
                ORDER BY price ASC LIMIT 1
147 0.0004 0.00038599967956543
SELECT value FROM productattributes WHERE product_id = '2521' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
148 0.0007 0.00069713592529297
SELECT * FROM products WHERE id = '2109'
149 0.0005 0.000518798828125
SELECT * FROM productimages WHERE product_id = '2109' ORDER BY sortorder ASC
150 0.0006 0.00056982040405273
SELECT * FROM product_image_select WHERE product_id = '2109'
151 0.0004 0.00037884712219238
SELECT * FROM productcustomimages WHERE product_id = '2109'
152 0.0010 0.0010240077972412
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2109' AND a.name = n.originalname
153 0.0004 0.00042295455932617
SELECT * FROM productoffers WHERE product_id = '2109' AND merchantid = 'A1X6FK5RDHNB96'
154 0.0004 0.00036191940307617
SELECT * FROM productoffers
                WHERE product_id = '2109' AND price > 0
                ORDER BY price ASC LIMIT 1
155 0.0003 0.00032806396484375
SELECT * FROM productoffers
                WHERE product_id = 2109
                ORDER BY price ASC LIMIT 1
156 0.0004 0.00037002563476562
SELECT value FROM productattributes
                WHERE product_id = '2109'
                AND name = 'ListPriceAmount'
157 0.0004 0.00038290023803711
SELECT value FROM productattributes WHERE product_id = '2109' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
158 0.0005 0.0005190372467041
SELECT * FROM products WHERE id = '2116'
159 0.0005 0.00048089027404785
SELECT * FROM productimages WHERE product_id = '2116' ORDER BY sortorder ASC
160 0.0005 0.00052499771118164
SELECT * FROM product_image_select WHERE product_id = '2116'
161 0.0005 0.00046205520629883
SELECT * FROM productcustomimages WHERE product_id = '2116'
162 0.0010 0.0010101795196533
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2116' AND a.name = n.originalname
163 0.0005 0.00049686431884766
SELECT * FROM productoffers WHERE product_id = '2116' AND merchantid = 'A1X6FK5RDHNB96'
164 0.0003 0.00034689903259277
SELECT * FROM productoffers
                WHERE product_id = '2116' AND price > 0
                ORDER BY price ASC LIMIT 1
165 0.0003 0.00031709671020508
SELECT * FROM productoffers
                WHERE product_id = 2116
                ORDER BY price ASC LIMIT 1
166 0.0004 0.00044107437133789
SELECT value FROM productattributes
                WHERE product_id = '2116'
                AND name = 'ListPriceAmount'
167 0.0004 0.0004429817199707
SELECT value FROM productattributes WHERE product_id = '2116' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
168 0.0005 0.00051093101501465
SELECT * FROM products WHERE id = '2132'
169 0.0005 0.00045013427734375
SELECT * FROM productimages WHERE product_id = '2132' ORDER BY sortorder ASC
170 0.0006 0.00062084197998047
SELECT * FROM product_image_select WHERE product_id = '2132'
171 0.0004 0.00037479400634766
SELECT * FROM productcustomimages WHERE product_id = '2132'
172 0.0009 0.00087404251098633
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2132' AND a.name = n.originalname
173 0.0004 0.00043702125549316
SELECT * FROM productoffers WHERE product_id = '2132' AND merchantid = 'A1X6FK5RDHNB96'
174 0.0003 0.00034904479980469
SELECT * FROM productoffers
                WHERE product_id = '2132' AND price > 0
                ORDER BY price ASC LIMIT 1
175 0.0003 0.00033903121948242
SELECT * FROM productoffers
                WHERE product_id = 2132
                ORDER BY price ASC LIMIT 1
176 0.0003 0.00033116340637207
SELECT value FROM productattributes
                WHERE product_id = '2132'
                AND name = 'ListPriceAmount'
177 0.0003 0.0003349781036377
SELECT value FROM productattributes WHERE product_id = '2132' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
178 0.0005 0.00052905082702637
SELECT * FROM products WHERE id = '2133'
179 0.0004 0.00043201446533203
SELECT * FROM productimages WHERE product_id = '2133' ORDER BY sortorder ASC
180 0.0005 0.00054717063903809
SELECT * FROM product_image_select WHERE product_id = '2133'
181 0.0004 0.00039196014404297
SELECT * FROM productcustomimages WHERE product_id = '2133'
182 0.0009 0.00093603134155273
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2133' AND a.name = n.originalname
183 0.0004 0.00042605400085449
SELECT * FROM productoffers WHERE product_id = '2133' AND merchantid = 'A1X6FK5RDHNB96'
184 0.0004 0.00036406517028809
SELECT * FROM productoffers
                WHERE product_id = '2133' AND price > 0
                ORDER BY price ASC LIMIT 1
185 0.0003 0.0003209114074707
SELECT * FROM productoffers
                WHERE product_id = 2133
                ORDER BY price ASC LIMIT 1
186 0.0004 0.00038599967956543
SELECT value FROM productattributes
                WHERE product_id = '2133'
                AND name = 'ListPriceAmount'
187 0.0004 0.00037598609924316
SELECT value FROM productattributes WHERE product_id = '2133' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
188 0.0005 0.00046801567077637
SELECT * FROM products WHERE id = '2136'
189 0.0005 0.00050020217895508
SELECT * FROM productimages WHERE product_id = '2136' ORDER BY sortorder ASC
190 0.0006 0.00058984756469727
SELECT * FROM product_image_select WHERE product_id = '2136'
191 0.0004 0.00038385391235352
SELECT * FROM productcustomimages WHERE product_id = '2136'
192 0.0009 0.0009458065032959
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2136' AND a.name = n.originalname
193 0.0005 0.00051999092102051
SELECT * FROM productoffers WHERE product_id = '2136' AND merchantid = 'A1X6FK5RDHNB96'
194 0.0004 0.00040602684020996
SELECT * FROM productoffers
                WHERE product_id = '2136' AND price > 0
                ORDER BY price ASC LIMIT 1
195 0.0003 0.00033092498779297
SELECT * FROM productoffers
                WHERE product_id = 2136
                ORDER BY price ASC LIMIT 1
196 0.0004 0.00035285949707031
SELECT value FROM productattributes
                WHERE product_id = '2136'
                AND name = 'ListPriceAmount'
197 0.0004 0.00041294097900391
SELECT value FROM productattributes WHERE product_id = '2136' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
198 0.0005 0.00048398971557617
SELECT * FROM products WHERE id = '2518'
199 0.0005 0.00045204162597656
SELECT * FROM productimages WHERE product_id = '2518' ORDER BY sortorder ASC
200 0.0004 0.00040411949157715
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2518' AND p.id = pi.product_id ORDER BY pi.sortorder
201 0.0006 0.0005500316619873
SELECT * FROM product_image_select WHERE product_id = '2518'
202 0.0005 0.00046586990356445
SELECT * FROM productcustomimages WHERE product_id = '2518'
203 0.0005 0.00050091743469238
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 = '2518'
                GROUP BY o.product_id
204 0.0006 0.0005948543548584
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     = '2518'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
205 0.0004 0.00039482116699219
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2518
206 0.0010 0.00095891952514648
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2518' AND a.name = n.originalname
207 0.0004 0.00035810470581055
SELECT * FROM productoffers WHERE product_id = '2518' AND merchantid = 'A1X6FK5RDHNB96'
208 0.0004 0.0003509521484375
SELECT * FROM productoffers
                WHERE product_id = '2518' AND price > 0
                ORDER BY price ASC LIMIT 1
209 0.0003 0.00034594535827637
SELECT * FROM productoffers
                WHERE product_id = 2518
                ORDER BY price ASC LIMIT 1
210 0.0004 0.00035595893859863
SELECT value FROM productattributes
                WHERE product_id = '2518'
                AND name = 'ListPriceAmount'
211 0.0006 0.00056910514831543
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 = '2518'
                GROUP BY o.product_id
212 0.0006 0.00057697296142578
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     = '2518'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
213 0.0004 0.00039100646972656
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2518
214 0.0005 0.00051403045654297
SELECT value FROM productattributes WHERE product_id = '2518' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
215 0.0004 0.00041699409484863
SELECT * FROM products WHERE parent_id = '2518'
216 0.0004 0.00035190582275391
SELECT * FROM products WHERE id = '2164'
217 0.0005 0.00051498413085938
SELECT * FROM productimages WHERE product_id = '2164' ORDER BY sortorder ASC
218 0.0006 0.00056600570678711
SELECT * FROM product_image_select WHERE product_id = '2164'
219 0.0004 0.00042390823364258
SELECT * FROM productcustomimages WHERE product_id = '2164'
220 0.0010 0.00099301338195801
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2164' AND a.name = n.originalname
221 0.0005 0.00048708915710449
SELECT * FROM productoffers WHERE product_id = '2164' AND merchantid = 'A1X6FK5RDHNB96'
222 0.0004 0.00042104721069336
SELECT * FROM productoffers
                WHERE product_id = '2164' AND price > 0
                ORDER BY price ASC LIMIT 1
223 0.0004 0.0003669261932373
SELECT * FROM productoffers
                WHERE product_id = 2164
                ORDER BY price ASC LIMIT 1
224 0.0004 0.00037717819213867
SELECT value FROM productattributes
                WHERE product_id = '2164'
                AND name = 'ListPriceAmount'
225 0.0004 0.00042581558227539
SELECT value FROM productattributes WHERE product_id = '2164' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
226 0.0005 0.0005180835723877
SELECT * FROM products WHERE id = '2183'
227 0.0005 0.00049805641174316
SELECT * FROM productimages WHERE product_id = '2183' ORDER BY sortorder ASC
228 0.0007 0.00069284439086914
SELECT * FROM product_image_select WHERE product_id = '2183'
229 0.0006 0.00058102607727051
SELECT * FROM productcustomimages WHERE product_id = '2183'
230 0.0011 0.0010709762573242
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2183' AND a.name = n.originalname
231 0.0005 0.00053095817565918
SELECT * FROM productoffers WHERE product_id = '2183' AND merchantid = 'A1X6FK5RDHNB96'
232 0.0004 0.00040602684020996
SELECT * FROM productoffers
                WHERE product_id = '2183' AND price > 0
                ORDER BY price ASC LIMIT 1
233 0.0004 0.00037908554077148
SELECT * FROM productoffers
                WHERE product_id = 2183
                ORDER BY price ASC LIMIT 1
234 0.0004 0.0004429817199707
SELECT value FROM productattributes
                WHERE product_id = '2183'
                AND name = 'ListPriceAmount'
235 0.0005 0.00053000450134277
SELECT value FROM productattributes WHERE product_id = '2183' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
236 0.0006 0.00057792663574219
SELECT * FROM products WHERE id = '2212'
237 0.0006 0.00060486793518066
SELECT * FROM productimages WHERE product_id = '2212' ORDER BY sortorder ASC
238 0.0006 0.00057601928710938
SELECT * FROM product_image_select WHERE product_id = '2212'
239 0.0004 0.00042104721069336
SELECT * FROM productcustomimages WHERE product_id = '2212'
240 0.0009 0.00091695785522461
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2212' AND a.name = n.originalname
241 0.0005 0.00049400329589844
SELECT * FROM productoffers WHERE product_id = '2212' AND merchantid = 'A1X6FK5RDHNB96'
242 0.0004 0.00038981437683105
SELECT * FROM productoffers
                WHERE product_id = '2212' AND price > 0
                ORDER BY price ASC LIMIT 1
243 0.0004 0.0003509521484375
SELECT * FROM productoffers
                WHERE product_id = 2212
                ORDER BY price ASC LIMIT 1
244 0.0004 0.00035715103149414
SELECT value FROM productattributes
                WHERE product_id = '2212'
                AND name = 'ListPriceAmount'
245 0.0004 0.00040602684020996
SELECT value FROM productattributes WHERE product_id = '2212' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
246 0.0005 0.00051307678222656
SELECT * FROM products WHERE id = '4232'
247 0.0004 0.00044918060302734
SELECT * FROM productimages WHERE product_id = '4232' ORDER BY sortorder ASC
248 0.0005 0.00054693222045898
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4232' AND p.id = pi.product_id ORDER BY pi.sortorder
249 0.0006 0.00058197975158691
SELECT * FROM product_image_select WHERE product_id = '4232'
250 0.0006 0.00059914588928223
SELECT * FROM productcustomimages WHERE product_id = '4232'
251 0.0006 0.00061511993408203
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 = '4232'
                GROUP BY o.product_id
252 0.0007 0.00066280364990234
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     = '4232'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
253 0.0004 0.00039792060852051
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4232
254 0.0008 0.00077295303344727
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4232' AND a.name = n.originalname
255 0.0003 0.00034999847412109
SELECT * FROM productoffers WHERE product_id = '4232' AND merchantid = 'A1X6FK5RDHNB96'
256 0.0004 0.00039196014404297
SELECT * FROM productoffers
                WHERE product_id = '4232' AND price > 0
                ORDER BY price ASC LIMIT 1
257 0.0003 0.00030922889709473
SELECT * FROM productoffers
                WHERE product_id = 4232
                ORDER BY price ASC LIMIT 1
258 0.0004 0.00035381317138672
SELECT value FROM productattributes
                WHERE product_id = '4232'
                AND name = 'ListPriceAmount'
259 0.0004 0.0004270076751709
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 = '4232'
                GROUP BY o.product_id
260 0.0006 0.00061893463134766
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     = '4232'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
261 0.0004 0.00038790702819824
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4232
262 0.0005 0.00053501129150391
SELECT value FROM productattributes WHERE product_id = '4232' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
263 0.0006 0.00058102607727051
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4232'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
264 0.0004 0.00040316581726074
SELECT * FROM products WHERE id = '2269'
265 0.0004 0.00044703483581543
SELECT * FROM productimages WHERE product_id = '2269' ORDER BY sortorder ASC
266 0.0006 0.00059604644775391
SELECT * FROM product_image_select WHERE product_id = '2269'
267 0.0004 0.0003659725189209
SELECT * FROM productcustomimages WHERE product_id = '2269'
268 0.0008 0.00084805488586426
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2269' AND a.name = n.originalname
269 0.0004 0.00042390823364258
SELECT * FROM productoffers WHERE product_id = '2269' AND merchantid = 'A1X6FK5RDHNB96'
270 0.0003 0.00032901763916016
SELECT * FROM productoffers
                WHERE product_id = '2269' AND price > 0
                ORDER BY price ASC LIMIT 1
271 0.0003 0.00031495094299316
SELECT * FROM productoffers
                WHERE product_id = 2269
                ORDER BY price ASC LIMIT 1
272 0.0003 0.00032901763916016
SELECT value FROM productattributes
                WHERE product_id = '2269'
                AND name = 'ListPriceAmount'
273 0.0004 0.0003659725189209
SELECT value FROM productattributes WHERE product_id = '2269' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
274 0.0005 0.00053691864013672
SELECT * FROM products WHERE id = '2285'
275 0.0004 0.00043988227844238
SELECT * FROM productimages WHERE product_id = '2285' ORDER BY sortorder ASC
276 0.0006 0.00055909156799316
SELECT * FROM product_image_select WHERE product_id = '2285'
277 0.0004 0.00035905838012695
SELECT * FROM productcustomimages WHERE product_id = '2285'
278 0.0010 0.0010490417480469
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2285' AND a.name = n.originalname
279 0.0004 0.00042605400085449
SELECT * FROM productoffers WHERE product_id = '2285' AND merchantid = 'A1X6FK5RDHNB96'
280 0.0004 0.00035715103149414
SELECT * FROM productoffers
                WHERE product_id = '2285' AND price > 0
                ORDER BY price ASC LIMIT 1
281 0.0004 0.00035786628723145
SELECT * FROM productoffers
                WHERE product_id = 2285
                ORDER BY price ASC LIMIT 1
282 0.0004 0.00037407875061035
SELECT value FROM productattributes
                WHERE product_id = '2285'
                AND name = 'ListPriceAmount'
283 0.0004 0.0003819465637207
SELECT value FROM productattributes WHERE product_id = '2285' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
284 0.0005 0.00045895576477051
SELECT * FROM products WHERE id = '2517'
285 0.0004 0.00042200088500977
SELECT * FROM productimages WHERE product_id = '2517' ORDER BY sortorder ASC
286 0.0004 0.00038003921508789
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2517' AND p.id = pi.product_id ORDER BY pi.sortorder
287 0.0006 0.00059604644775391
SELECT * FROM product_image_select WHERE product_id = '2517'
288 0.0004 0.00035715103149414
SELECT * FROM productcustomimages WHERE product_id = '2517'
289 0.0006 0.00055098533630371
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 = '2517'
                GROUP BY o.product_id
290 0.0006 0.00060796737670898
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     = '2517'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
291 0.0004 0.00037884712219238
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2517
292 0.0010 0.00095510482788086
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2517' AND a.name = n.originalname
293 0.0004 0.00036406517028809
SELECT * FROM productoffers WHERE product_id = '2517' AND merchantid = 'A1X6FK5RDHNB96'
294 0.0003 0.00034403800964355
SELECT * FROM productoffers
                WHERE product_id = '2517' AND price > 0
                ORDER BY price ASC LIMIT 1
295 0.0003 0.0003359317779541
SELECT * FROM productoffers
                WHERE product_id = 2517
                ORDER BY price ASC LIMIT 1
296 0.0004 0.00035214424133301
SELECT value FROM productattributes
                WHERE product_id = '2517'
                AND name = 'ListPriceAmount'
297 0.0004 0.0004429817199707
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '2517'
                GROUP BY o.product_id
298 0.0006 0.00060105323791504
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     = '2517'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
299 0.0004 0.00036716461181641
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2517
300 0.0005 0.00051307678222656
SELECT value FROM productattributes WHERE product_id = '2517' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
301 0.0004 0.00036001205444336
SELECT * FROM products WHERE parent_id = '2517'
302 0.0004 0.00039100646972656
SELECT * FROM products WHERE id = '2356'
303 0.0005 0.00047206878662109
SELECT * FROM productimages WHERE product_id = '2356' ORDER BY sortorder ASC
304 0.0006 0.00056910514831543
SELECT * FROM product_image_select WHERE product_id = '2356'
305 0.0004 0.00037193298339844
SELECT * FROM productcustomimages WHERE product_id = '2356'
306 0.0023 0.0023319721221924
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2356' AND a.name = n.originalname
307 0.0009 0.00089383125305176
SELECT * FROM productoffers WHERE product_id = '2356' AND merchantid = 'A1X6FK5RDHNB96'
308 0.0006 0.0006251335144043
SELECT * FROM productoffers
                WHERE product_id = '2356' AND price > 0
                ORDER BY price ASC LIMIT 1
309 0.0005 0.00051498413085938
SELECT * FROM productoffers
                WHERE product_id = 2356
                ORDER BY price ASC LIMIT 1
310 0.0007 0.00074315071105957
SELECT value FROM productattributes
                WHERE product_id = '2356'
                AND name = 'ListPriceAmount'
311 0.0007 0.00071978569030762
SELECT value FROM productattributes WHERE product_id = '2356' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
312 0.0009 0.00092887878417969
SELECT * FROM products WHERE id = '2360'
313 0.0007 0.00071406364440918
SELECT * FROM productimages WHERE product_id = '2360' ORDER BY sortorder ASC
314 0.0011 0.0010871887207031
SELECT * FROM product_image_select WHERE product_id = '2360'
315 0.0006 0.00059795379638672
SELECT * FROM productcustomimages WHERE product_id = '2360'
316 0.0024 0.00242018699646
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2360' AND a.name = n.originalname
317 0.0008 0.00082087516784668
SELECT * FROM productoffers WHERE product_id = '2360' AND merchantid = 'A1X6FK5RDHNB96'
318 0.0005 0.0005340576171875
SELECT * FROM productoffers
                WHERE product_id = '2360' AND price > 0
                ORDER BY price ASC LIMIT 1
319 0.0004 0.00042414665222168
SELECT * FROM productoffers
                WHERE product_id = 2360
                ORDER BY price ASC LIMIT 1
320 0.0006 0.00055193901062012
SELECT value FROM productattributes
                WHERE product_id = '2360'
                AND name = 'ListPriceAmount'
321 0.0007 0.00065302848815918
SELECT value FROM productattributes WHERE product_id = '2360' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
322 0.0029 0.0028800964355469
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2017' ORDER BY timestamp DESC
323 0.0004 0.00039100646972656
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2024' ORDER BY timestamp DESC
324 0.0004 0.00041985511779785
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2521' ORDER BY timestamp DESC
325 0.0004 0.00039887428283691
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2109' ORDER BY timestamp DESC
326 0.0004 0.00038290023803711
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2116' ORDER BY timestamp DESC
327 0.0003 0.0003058910369873
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2132' ORDER BY timestamp DESC
328 0.0003 0.00028085708618164
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2133' ORDER BY timestamp DESC
329 0.0003 0.00027608871459961
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2136' ORDER BY timestamp DESC
330 0.0003 0.00027012825012207
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2518' ORDER BY timestamp DESC
331 0.0003 0.00027012825012207
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2164' ORDER BY timestamp DESC
332 0.0003 0.00032186508178711
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2183' ORDER BY timestamp DESC
333 0.0003 0.00031304359436035
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2212' ORDER BY timestamp DESC
334 0.0003 0.00027585029602051
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4232' ORDER BY timestamp DESC
335 0.0003 0.0002739429473877
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2269' ORDER BY timestamp DESC
336 0.0003 0.0002751350402832
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2285' ORDER BY timestamp DESC
337 0.0003 0.00026488304138184
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2517' ORDER BY timestamp DESC
338 0.0002 0.00024294853210449
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2356' ORDER BY timestamp DESC
339 0.0002 0.00024199485778809
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2360' ORDER BY timestamp DESC
340 0.0017 0.0017299652099609
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
341 0.0014 0.0013840198516846
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
342 0.0003 0.00032591819763184
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
343 0.0191 0.019105911254883
SELECT p.id,p.parent_id, o.price,p.asin FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND hidden = 0 AND offers > 0 AND (SELECT COUNT(pi.id) FROM productimages pi WHERE pi.product_id = p.id) > 1 AND o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price)) ORDER BY p.title DESC LIMIT 6
344 0.0022 0.0022110939025879
SELECT p.id,p.price,p.listingtype FROM ebay_products p WHERE hide = 0 AND (SELECT COUNT(pi.id) FROM ebay_prod_images pi WHERE pi.prodid = p.id) > 1 ORDER BY p.title DESC LIMIT 6
345 0.0005 0.00054287910461426
SELECT p.id,p.price,p.currency FROM custom_products p WHERE hide = 0 AND orginalprice > 0 AND (SELECT COUNT(pi.id) FROM productcustomimages pi WHERE pi.product_id = p.id) > 1 ORDER BY p.title DESC LIMIT 6
346 0.0006 0.00056195259094238
SELECT * FROM products WHERE id = 1626
347 0.0004 0.00041508674621582
SELECT * FROM products WHERE id = 4041
348 0.0004 0.00039982795715332
SELECT * FROM products WHERE id = 4312
349 0.0004 0.00039505958557129
SELECT * FROM products WHERE id = 777
350 0.0004 0.00041580200195312
SELECT * FROM products WHERE id = 3881
351 0.0004 0.00042295455932617
SELECT * FROM products WHERE id = 4213
352 0.0004 0.00037407875061035
SELECT * FROM products WHERE id = '1626'
353 0.0005 0.00047183036804199
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
354 0.0006 0.00055217742919922
SELECT * FROM product_image_select WHERE product_id = '1626'
355 0.0004 0.00037097930908203
SELECT * FROM productcustomimages WHERE product_id = '1626'
356 0.0010 0.0010020732879639
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
357 0.0006 0.00058698654174805
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
358 0.0004 0.00042915344238281
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
359 0.0006 0.00059103965759277
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
360 0.0008 0.00075697898864746
SELECT * FROM products WHERE id = '4041'
361 0.0005 0.00054311752319336
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
362 0.0006 0.00055885314941406
SELECT * FROM product_image_select WHERE product_id = '4041'
363 0.0004 0.00037789344787598
SELECT * FROM productcustomimages WHERE product_id = '4041'
364 0.0011 0.0010879039764404
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
365 0.0007 0.00071406364440918
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
366 0.0004 0.00043797492980957
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
367 0.0005 0.00054788589477539
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
368 0.0006 0.00055098533630371
SELECT * FROM products WHERE id = '4312'
369 0.0007 0.0007469654083252
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
370 0.0009 0.00093984603881836
SELECT * FROM product_image_select WHERE product_id = '4312'
371 0.0004 0.00043106079101562
SELECT * FROM productcustomimages WHERE product_id = '4312'
372 0.0011 0.0010519027709961
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
373 0.0005 0.00047421455383301
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
374 0.0004 0.00038290023803711
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
375 0.0007 0.00065994262695312
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
376 0.0005 0.00049805641174316
SELECT * FROM products WHERE id = '777'
377 0.0005 0.00048398971557617
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
378 0.0005 0.00053906440734863
SELECT * FROM product_image_select WHERE product_id = '777'
379 0.0003 0.00034213066101074
SELECT * FROM productcustomimages WHERE product_id = '777'
380 0.0013 0.0012569427490234
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
381 0.0004 0.00042986869812012
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
382 0.0003 0.00033688545227051
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
383 0.0005 0.0004889965057373
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
384 0.0005 0.00046396255493164
SELECT * FROM products WHERE id = '3881'
385 0.0005 0.00052714347839355
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
386 0.0006 0.00056600570678711
SELECT * FROM product_image_select WHERE product_id = '3881'
387 0.0004 0.0003969669342041
SELECT * FROM productcustomimages WHERE product_id = '3881'
388 0.0011 0.0010550022125244
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
389 0.0005 0.00047588348388672
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
390 0.0003 0.00033378601074219
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
391 0.0004 0.00041413307189941
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
392 0.0005 0.00051093101501465
SELECT * FROM products WHERE id = '4213'
393 0.0005 0.00047111511230469
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
394 0.0006 0.0006251335144043
SELECT * FROM product_image_select WHERE product_id = '4213'
395 0.0004 0.00041794776916504
SELECT * FROM productcustomimages WHERE product_id = '4213'
396 0.0010 0.0010249614715576
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
397 0.0004 0.00043797492980957
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
398 0.0004 0.00039792060852051
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
399 0.0004 0.0003819465637207
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
400 0.0021 0.002147912979126
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
401 0.0007 0.00074195861816406
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
402 0.0074 0.0074419975280762
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
403 0.0041 0.004086971282959
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
404 0.0012 0.0011749267578125
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
405 0.0029 0.0028841495513916
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
406 0.0011 0.0010690689086914
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'