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.3090171813965 358 1.0385 0


No Amazon API Requests Made.


App Debug - Total Time 1.3090171813965 seconds

Number Time From Start Name Description
1 0.26669502258301 Initialise Initialise FSB Function
2 0.27291417121887 App Controller Start Start of the App controller (called before the controller of every page)
3 0.31271505355835 Start of getCategoryListByGroup Function Before first category groups query
4 0.31464314460754 After initial query Before first category groups query
5 0.31464409828186 Get Category List for Group Before the call to getCategoryList function
6 0.31464600563049 Start of GetCategoryList function Start of the function
7 0.31464815139771 Before getting categories Query to get specific category list
8 0.31627821922302 After getting categories Query to get specific category list
9 0.31627917289734 Before getting category custom Before call to function getCategoryCustom
10 0.34165811538696 After getting category custom After call to function getCategoryCustom
11 0.3416600227356 Before getting category custom Before call to function getCategoryCustom
12 0.35402417182922 After getting category custom After call to function getCategoryCustom
13 0.35402512550354 Before getting category custom Before call to function getCategoryCustom
14 0.36063504219055 After getting category custom After call to function getCategoryCustom
15 0.36063623428345 Before getting category custom Before call to function getCategoryCustom
16 0.36507606506348 After getting category custom After call to function getCategoryCustom
17 0.36507606506348 Before getting category custom Before call to function getCategoryCustom
18 0.36942601203918 After getting category custom After call to function getCategoryCustom
19 0.36942720413208 Before getting category custom Before call to function getCategoryCustom
20 0.37396502494812 After getting category custom After call to function getCategoryCustom
21 0.37396717071533 End of GetCategoryList function End of the function
22 0.37397313117981 Get Category List for Group Before the call to getCategoryList function
23 0.37397503852844 Start of GetCategoryList function Start of the function
24 0.37397623062134 Before getting categories Query to get specific category list
25 0.37442111968994 End of getCategoryListByGroup Function Before return()
26 1.1079490184784 App Controller End End of the App controller (called before the controller of every page)
27 1.2336242198944 App_after Controller Start Start of the App_after controller (called after the controller of every page)
28 1.2353191375732 Before Get Options Before the call to getOptions in the tpl class
29 1.2860321998596 After Get Options After the call to getOptions in the tpl class
30 1.2860701084137 App_after Controller End End of the App_after controller (called after the controller of every page)
31 1.3090031147003 Finalizing debug Before the debug is output to the page.
32 1.3090162277222 End of App This is the end of the app logging, final timestamp


Query Debug - 358 Database Queries. Total time 1.0385 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0013 0.0013279914855957
SELECT parameter, value FROM parameters
2 0.0092 0.0091540813446045
SELECT * FROM `bad_bots`
3 0.0005 0.0004580020904541
SET time_zone = 'Europe/London'
4 0.0030 0.0030200481414795
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0037 0.0037100315093994
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:12:\"52.15.66.233\";}'
6 0.0036 0.0035638809204102
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1746856535'
7 0.0045 0.004464864730835
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0008 0.00077605247497559
UPDATE autorun SET lastrun = '2025-05-10 05:55:35' WHERE id = '16'
9 0.0009 0.00089406967163086
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0041 0.0040509700775146
SELECT id FROM pages WHERE pagename = 'search' LIMIT 1
11 0.0007 0.00069022178649902
SELECT * FROM pages WHERE id = 52
12 0.0054 0.0054388046264648
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13 0.0331 0.033111095428467
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14 0.0008 0.00079894065856934
SELECT * FROM pages WHERE pagename = 'search'
15 0.0019 0.0019190311431885
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0016 0.0016210079193115
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0082 0.0081939697265625
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.0021238327026367
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.0014 0.0013859272003174
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20 0.0005 0.0005028247833252
SELECT id FROM categories WHERE parent_id = '26'
21 0.0067 0.0066919326782227
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.0024 0.0024030208587646
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.0019 0.0019381046295166
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.0016 0.0015950202941895
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25 0.0005 0.00045418739318848
SELECT * FROM categorygroups WHERE id = '1'
26 0.0043 0.0042548179626465
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.0006 0.00059199333190918
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.0004 0.00041294097900391
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29 0.0005 0.00048279762268066
SELECT id FROM categories WHERE parent_id = '27'
30 0.0044 0.0044229030609131
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.0006 0.00059604644775391
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.0005 0.00054407119750977
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.0005 0.00054192543029785
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34 0.0005 0.00046205520629883
SELECT * FROM categorygroups WHERE id = '1'
35 0.0015 0.0015311241149902
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.0005 0.00048303604125977
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.0004 0.00044584274291992
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38 0.0004 0.00042080879211426
SELECT id FROM categories WHERE parent_id = '28'
39 0.0016 0.001554012298584
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.0005 0.00050997734069824
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.0007 0.00069785118103027
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.0005 0.00051093101501465
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43 0.0004 0.00043296813964844
SELECT * FROM categorygroups WHERE id = '1'
44 0.0006 0.00057101249694824
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.0004 0.00044989585876465
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.0004 0.00038790702819824
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47 0.0004 0.00040102005004883
SELECT id FROM categories WHERE parent_id = '29'
48 0.0007 0.0006558895111084
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.0005 0.00050783157348633
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.0006 0.00058388710021973
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.00048279762268066
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52 0.0004 0.00037908554077148
SELECT * FROM categorygroups WHERE id = '1'
53 0.0006 0.00057721138000488
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.00046992301940918
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.00037193298339844
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56 0.0004 0.00041007995605469
SELECT id FROM categories WHERE parent_id = '30'
57 0.0007 0.00066590309143066
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.00045990943908691
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.0005 0.00049400329589844
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.0004 0.00042486190795898
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61 0.0005 0.00045990943908691
SELECT * FROM categorygroups WHERE id = '1'
62 0.0006 0.00064992904663086
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.0005 0.00045394897460938
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.00039792060852051
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65 0.0004 0.00039887428283691
SELECT id FROM categories WHERE parent_id = '31'
66 0.0007 0.00069904327392578
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.0005 0.00050091743469238
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.00054597854614258
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.0005 0.00046420097351074
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70 0.0004 0.00037789344787598
SELECT * FROM categorygroups WHERE id = '1'
71 0.0004 0.00044083595275879
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
72 0.0030 0.0029568672180176
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73 0.0016 0.0015900135040283
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74 0.0005 0.00051999092102051
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.0011501312255859
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76 0.0011 0.0010888576507568
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77 0.0008 0.00083518028259277
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78 0.7208 0.72077703475952
SELECT * FROM ipgeocountries WHERE INET_ATON('52.15.66.233') >= INET_ATON(ip_start) AND INET_ATON('52.15.66.233') <= INET_ATON(ip_end)
79 0.0020 0.0019810199737549
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80 0.0011 0.0010960102081299
SELECT * FROM countryredirects WHERE countrycode = 'US'
81 0.0004 0.00044608116149902
SELECT * FROM pages WHERE pagename = 'search'
82 0.0051 0.0050959587097168
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
83 0.0016 0.0015709400177002
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
84 0.0015 0.0015168190002441
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
85 0.0050 0.0050368309020996
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
86 0.0015 0.0014550685882568
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
87 0.0004 0.00042295455932617
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
88 0.0013 0.0013117790222168
INSERT INTO searches (`keywords`, `timestamp`, `ip`) SELECT '2', NOW(), '52.15.66.233'
89 0.0006 0.00064396858215332
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (title)
    AGAINST ('+2' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (title) AGAINST ('+2' 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 ('+2'), 'bundle' AS type FROM bundles b
		WHERE MATCH (title) AGAINST ('+2' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1
90 0.0004 0.00043392181396484
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+2' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' 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 ('+2'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1
91 0.0035 0.0035018920898438
SELECT DISTINCT (p.id), salesrank, price, linktitle,
          'product' AS type
          FROM products p 
		WHERE ((description LIKE '2') OR (keyfeatures LIKE '2') OR (title LIKE '2'))

		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1
92 0.0005 0.00045108795166016
SELECT DISTINCT (p.id), price, linktitle,
          'ebayproduct' AS type
          FROM ebay_products p 
		WHERE ((description LIKE '2') OR (title LIKE '2'))
		AND hide = 0
93 0.0004 0.00036907196044922
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE '2') OR (title LIKE '2'))
		AND hide = 0
94 0.0004 0.00043010711669922
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+2' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' 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 ('+2'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1
95 0.0044 0.0044369697570801
SELECT DISTINCT (p.id), salesrank, price, linktitle,
          'product' AS type
          FROM products p 
		WHERE ((description LIKE '%2%') OR (keyfeatures LIKE '%2%') OR (title LIKE '%2%'))

		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1
96 0.0003 0.00028610229492188
SELECT DISTINCT (p.id), price, linktitle,
          'ebayproduct' AS type
          FROM ebay_products p 
		WHERE ((description LIKE '%2%') OR (title LIKE '%2%'))
		AND hide = 0
97 0.0003 0.00034713745117188
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE '%2%') OR (title LIKE '%2%'))
		AND hide = 0
98 0.0005 0.00048708915710449
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (title)
    AGAINST ('+2' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (title) AGAINST ('+2' 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 ('+2'), 'bundle' AS type FROM bundles b
		WHERE MATCH (title) AGAINST ('+2' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
99 0.0005 0.00045990943908691
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+2' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' 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 ('+2'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
100 0.0034 0.0034139156341553
SELECT DISTINCT (p.id), salesrank, price, linktitle,
          'product' AS type
          FROM products p 
		WHERE ((description LIKE '2') OR (keyfeatures LIKE '2') OR (title LIKE '2'))

		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
101 0.0003 0.00027894973754883
SELECT DISTINCT (p.id), price, linktitle,
          'ebayproduct' AS type
          FROM ebay_products p 
		WHERE ((description LIKE '2') OR (title LIKE '2'))
		AND hide = 0
102 0.0002 0.00024795532226562
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE '2') OR (title LIKE '2'))
		AND hide = 0
103 0.0004 0.0004429817199707
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+2' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' 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 ('+2'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
104 0.0046 0.0045709609985352
SELECT DISTINCT (p.id), salesrank, price, linktitle,
          'product' AS type
          FROM products p 
		WHERE ((description LIKE '%2%') OR (keyfeatures LIKE '%2%') OR (title LIKE '%2%'))

		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
105 0.0003 0.00027680397033691
SELECT DISTINCT (p.id), price, linktitle,
          'ebayproduct' AS type
          FROM ebay_products p 
		WHERE ((description LIKE '%2%') OR (title LIKE '%2%'))
		AND hide = 0
106 0.0002 0.00024795532226562
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE '%2%') OR (title LIKE '%2%'))
		AND hide = 0
107 0.0003 0.00031590461730957
SELECT * FROM products WHERE id = '4936'
108 0.0014 0.0014162063598633
SELECT * FROM productimages WHERE product_id = '4936' ORDER BY sortorder ASC
109 0.0012 0.0012209415435791
SELECT * FROM product_image_select WHERE product_id = '4936'
110 0.0010 0.0010049343109131
SELECT * FROM productcustomimages WHERE product_id = '4936'
111 0.0019 0.0018649101257324
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4936' AND a.name = n.originalname
112 0.0012 0.0012021064758301
SELECT * FROM productoffers WHERE product_id = '4936' AND merchantid = 'A1X6FK5RDHNB96'
113 0.0003 0.00032997131347656
SELECT * FROM productoffers
                WHERE product_id = '4936' AND price > 0
                ORDER BY price ASC LIMIT 1
114 0.0005 0.00046086311340332
SELECT value FROM productattributes WHERE product_id = '4936' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
115 0.0004 0.00041985511779785
SELECT * FROM products WHERE id = '1557'
116 0.0005 0.0004880428314209
SELECT * FROM productimages WHERE product_id = '1557' ORDER BY sortorder ASC
117 0.0005 0.00051617622375488
SELECT * FROM product_image_select WHERE product_id = '1557'
118 0.0003 0.00031208992004395
SELECT * FROM productcustomimages WHERE product_id = '1557'
119 0.0011 0.0010530948638916
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1557' AND a.name = n.originalname
120 0.0004 0.00042295455932617
SELECT * FROM productoffers WHERE product_id = '1557' AND merchantid = 'A1X6FK5RDHNB96'
121 0.0003 0.00032615661621094
SELECT * FROM productoffers
                WHERE product_id = '1557' AND price > 0
                ORDER BY price ASC LIMIT 1
122 0.0004 0.00035190582275391
SELECT value FROM productattributes WHERE product_id = '1557' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
123 0.0004 0.00039887428283691
SELECT * FROM products WHERE id = '1056'
124 0.0004 0.00040984153747559
SELECT * FROM productimages WHERE product_id = '1056' ORDER BY sortorder ASC
125 0.0005 0.00049400329589844
SELECT * FROM product_image_select WHERE product_id = '1056'
126 0.0003 0.0003199577331543
SELECT * FROM productcustomimages WHERE product_id = '1056'
127 0.0008 0.00082015991210938
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1056' AND a.name = n.originalname
128 0.0004 0.00040411949157715
SELECT * FROM productoffers WHERE product_id = '1056' AND merchantid = 'A1X6FK5RDHNB96'
129 0.0003 0.00030612945556641
SELECT * FROM productoffers
                WHERE product_id = '1056' AND price > 0
                ORDER BY price ASC LIMIT 1
130 0.0003 0.00032401084899902
SELECT value FROM productattributes WHERE product_id = '1056' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
131 0.0004 0.00038981437683105
SELECT * FROM products WHERE id = '3829'
132 0.0004 0.00036001205444336
SELECT * FROM productimages WHERE product_id = '3829' ORDER BY sortorder ASC
133 0.0005 0.00046396255493164
SELECT * FROM product_image_select WHERE product_id = '3829'
134 0.0003 0.00030207633972168
SELECT * FROM productcustomimages WHERE product_id = '3829'
135 0.0007 0.00071310997009277
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3829' AND a.name = n.originalname
136 0.0004 0.00035905838012695
SELECT * FROM productoffers WHERE product_id = '3829' AND merchantid = 'A1X6FK5RDHNB96'
137 0.0003 0.00027203559875488
SELECT * FROM productoffers
                WHERE product_id = '3829' AND price > 0
                ORDER BY price ASC LIMIT 1
138 0.0003 0.00026893615722656
SELECT * FROM productoffers
                WHERE product_id = 3829
                ORDER BY price ASC LIMIT 1
139 0.0003 0.00030398368835449
SELECT value FROM productattributes
                WHERE product_id = '3829'
                AND name = 'ListPriceAmount'
140 0.0003 0.00031208992004395
SELECT value FROM productattributes WHERE product_id = '3829' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
141 0.0004 0.00038790702819824
SELECT * FROM products WHERE id = '1501'
142 0.0003 0.00034403800964355
SELECT * FROM productimages WHERE product_id = '1501' ORDER BY sortorder ASC
143 0.0005 0.00045585632324219
SELECT * FROM product_image_select WHERE product_id = '1501'
144 0.0003 0.00032186508178711
SELECT * FROM productcustomimages WHERE product_id = '1501'
145 0.0010 0.0010201930999756
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1501' AND a.name = n.originalname
146 0.0004 0.00038290023803711
SELECT * FROM productoffers WHERE product_id = '1501' AND merchantid = 'A1X6FK5RDHNB96'
147 0.0003 0.00034880638122559
SELECT * FROM productoffers
                WHERE product_id = '1501' AND price > 0
                ORDER BY price ASC LIMIT 1
148 0.0003 0.00031280517578125
SELECT * FROM productoffers
                WHERE product_id = 1501
                ORDER BY price ASC LIMIT 1
149 0.0003 0.00030994415283203
SELECT value FROM productattributes
                WHERE product_id = '1501'
                AND name = 'ListPriceAmount'
150 0.0003 0.00033998489379883
SELECT value FROM productattributes WHERE product_id = '1501' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
151 0.0004 0.00040698051452637
SELECT * FROM products WHERE id = '3747'
152 0.0004 0.00042486190795898
SELECT * FROM productimages WHERE product_id = '3747' ORDER BY sortorder ASC
153 0.0005 0.00049209594726562
SELECT * FROM product_image_select WHERE product_id = '3747'
154 0.0003 0.00029897689819336
SELECT * FROM productcustomimages WHERE product_id = '3747'
155 0.0007 0.00067996978759766
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3747' AND a.name = n.originalname
156 0.0004 0.00042986869812012
SELECT * FROM productoffers WHERE product_id = '3747' AND merchantid = 'A1X6FK5RDHNB96'
157 0.0003 0.00030994415283203
SELECT * FROM productoffers
                WHERE product_id = '3747' AND price > 0
                ORDER BY price ASC LIMIT 1
158 0.0003 0.00033211708068848
SELECT value FROM productattributes WHERE product_id = '3747' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
159 0.0004 0.00042104721069336
SELECT * FROM products WHERE id = '1070'
160 0.0005 0.00046491622924805
SELECT * FROM productimages WHERE product_id = '1070' ORDER BY sortorder ASC
161 0.0005 0.00048184394836426
SELECT * FROM product_image_select WHERE product_id = '1070'
162 0.0003 0.00031805038452148
SELECT * FROM productcustomimages WHERE product_id = '1070'
163 0.0010 0.0010449886322021
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1070' AND a.name = n.originalname
164 0.0004 0.00039410591125488
SELECT * FROM productoffers WHERE product_id = '1070' AND merchantid = 'A1X6FK5RDHNB96'
165 0.0003 0.00032305717468262
SELECT * FROM productoffers
                WHERE product_id = '1070' AND price > 0
                ORDER BY price ASC LIMIT 1
166 0.0004 0.00035190582275391
SELECT value FROM productattributes WHERE product_id = '1070' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
167 0.0004 0.00043702125549316
SELECT * FROM products WHERE id = '1560'
168 0.0004 0.00037217140197754
SELECT * FROM productimages WHERE product_id = '1560' ORDER BY sortorder ASC
169 0.0005 0.00047707557678223
SELECT * FROM product_image_select WHERE product_id = '1560'
170 0.0003 0.00030112266540527
SELECT * FROM productcustomimages WHERE product_id = '1560'
171 0.0011 0.0010550022125244
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1560' AND a.name = n.originalname
172 0.0004 0.0003809928894043
SELECT * FROM productoffers WHERE product_id = '1560' AND merchantid = 'A1X6FK5RDHNB96'
173 0.0003 0.00032305717468262
SELECT * FROM productoffers
                WHERE product_id = '1560' AND price > 0
                ORDER BY price ASC LIMIT 1
174 0.0003 0.00034093856811523
SELECT value FROM productattributes WHERE product_id = '1560' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
175 0.0004 0.00041794776916504
SELECT * FROM products WHERE id = '3515'
176 0.0004 0.00036191940307617
SELECT * FROM productimages WHERE product_id = '3515' ORDER BY sortorder ASC
177 0.0005 0.00048303604125977
SELECT * FROM product_image_select WHERE product_id = '3515'
178 0.0003 0.00029206275939941
SELECT * FROM productcustomimages WHERE product_id = '3515'
179 0.0007 0.00072407722473145
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3515' AND a.name = n.originalname
180 0.0004 0.0003662109375
SELECT * FROM productoffers WHERE product_id = '3515' AND merchantid = 'A1X6FK5RDHNB96'
181 0.0003 0.00029802322387695
SELECT * FROM productoffers
                WHERE product_id = '3515' AND price > 0
                ORDER BY price ASC LIMIT 1
182 0.0003 0.00027203559875488
SELECT * FROM productoffers
                WHERE product_id = 3515
                ORDER BY price ASC LIMIT 1
183 0.0003 0.00030207633972168
SELECT value FROM productattributes
                WHERE product_id = '3515'
                AND name = 'ListPriceAmount'
184 0.0003 0.00031614303588867
SELECT value FROM productattributes WHERE product_id = '3515' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
185 0.0004 0.00040006637573242
SELECT * FROM products WHERE id = '4920'
186 0.0004 0.0003509521484375
SELECT * FROM productimages WHERE product_id = '4920' ORDER BY sortorder ASC
187 0.0005 0.00047111511230469
SELECT * FROM product_image_select WHERE product_id = '4920'
188 0.0003 0.00029301643371582
SELECT * FROM productcustomimages WHERE product_id = '4920'
189 0.0011 0.0010747909545898
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4920' AND a.name = n.originalname
190 0.0004 0.00041103363037109
SELECT * FROM productoffers WHERE product_id = '4920' AND merchantid = 'A1X6FK5RDHNB96'
191 0.0003 0.00029397010803223
SELECT * FROM productoffers
                WHERE product_id = '4920' AND price > 0
                ORDER BY price ASC LIMIT 1
192 0.0002 0.00024604797363281
SELECT * FROM productoffers
                WHERE product_id = 4920
                ORDER BY price ASC LIMIT 1
193 0.0003 0.00029182434082031
SELECT value FROM productattributes
                WHERE product_id = '4920'
                AND name = 'ListPriceAmount'
194 0.0003 0.00034499168395996
SELECT value FROM productattributes WHERE product_id = '4920' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
195 0.0004 0.00041699409484863
SELECT * FROM products WHERE id = '2746'
196 0.0004 0.00042891502380371
SELECT * FROM productimages WHERE product_id = '2746' ORDER BY sortorder ASC
197 0.0005 0.00045108795166016
SELECT * FROM product_image_select WHERE product_id = '2746'
198 0.0003 0.00030708312988281
SELECT * FROM productcustomimages WHERE product_id = '2746'
199 0.0010 0.00097799301147461
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2746' AND a.name = n.originalname
200 0.0004 0.00040197372436523
SELECT * FROM productoffers WHERE product_id = '2746' AND merchantid = 'A1X6FK5RDHNB96'
201 0.0003 0.00032997131347656
SELECT * FROM productoffers
                WHERE product_id = '2746' AND price > 0
                ORDER BY price ASC LIMIT 1
202 0.0003 0.00034713745117188
SELECT value FROM productattributes WHERE product_id = '2746' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
203 0.0004 0.00041913986206055
SELECT * FROM products WHERE id = '1486'
204 0.0004 0.00036191940307617
SELECT * FROM productimages WHERE product_id = '1486' ORDER BY sortorder ASC
205 0.0005 0.00048184394836426
SELECT * FROM product_image_select WHERE product_id = '1486'
206 0.0003 0.00030303001403809
SELECT * FROM productcustomimages WHERE product_id = '1486'
207 0.0010 0.00096702575683594
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1486' AND a.name = n.originalname
208 0.0004 0.00039291381835938
SELECT * FROM productoffers WHERE product_id = '1486' AND merchantid = 'A1X6FK5RDHNB96'
209 0.0003 0.00030183792114258
SELECT * FROM productoffers
                WHERE product_id = '1486' AND price > 0
                ORDER BY price ASC LIMIT 1
210 0.0003 0.00033211708068848
SELECT value FROM productattributes WHERE product_id = '1486' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
211 0.0004 0.00040292739868164
SELECT * FROM products WHERE id = '4313'
212 0.0004 0.00040912628173828
SELECT * FROM productimages WHERE product_id = '4313' ORDER BY sortorder ASC
213 0.0003 0.00030183792114258
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4313' AND p.id = pi.product_id ORDER BY pi.sortorder
214 0.0005 0.00046706199645996
SELECT * FROM product_image_select WHERE product_id = '4313'
215 0.0003 0.00029206275939941
SELECT * FROM productcustomimages WHERE product_id = '4313'
216 0.0004 0.00042319297790527
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 = '4313'
                GROUP BY o.product_id
217 0.0024 0.0023961067199707
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     = '4313'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
218 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 = 4313
219 0.0009 0.00091981887817383
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4313' AND a.name = n.originalname
220 0.0003 0.00030183792114258
SELECT * FROM productoffers WHERE product_id = '4313' AND merchantid = 'A1X6FK5RDHNB96'
221 0.0003 0.00028586387634277
SELECT * FROM productoffers
                WHERE product_id = '4313' AND price > 0
                ORDER BY price ASC LIMIT 1
222 0.0003 0.00027203559875488
SELECT * FROM productoffers
                WHERE product_id = 4313
                ORDER BY price ASC LIMIT 1
223 0.0003 0.00030112266540527
SELECT value FROM productattributes
                WHERE product_id = '4313'
                AND name = 'ListPriceAmount'
224 0.0003 0.00032210350036621
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 = '4313'
                GROUP BY o.product_id
225 0.0005 0.0004889965057373
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     = '4313'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
226 0.0003 0.00028800964355469
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4313
227 0.0003 0.00029516220092773
SELECT * FROM products WHERE parent_id = '4313'
228 0.0003 0.00031900405883789
SELECT * FROM products WHERE id = '922'
229 0.0003 0.00034499168395996
SELECT * FROM productimages WHERE product_id = '922' ORDER BY sortorder ASC
230 0.0005 0.00048112869262695
SELECT * FROM product_image_select WHERE product_id = '922'
231 0.0003 0.00030112266540527
SELECT * FROM productcustomimages WHERE product_id = '922'
232 0.0008 0.00084900856018066
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '922' AND a.name = n.originalname
233 0.0004 0.00039315223693848
SELECT * FROM productoffers WHERE product_id = '922' AND merchantid = 'A1X6FK5RDHNB96'
234 0.0003 0.00031900405883789
SELECT * FROM productoffers
                WHERE product_id = '922' AND price > 0
                ORDER BY price ASC LIMIT 1
235 0.0003 0.00028109550476074
SELECT * FROM productoffers
                WHERE product_id = 922
                ORDER BY price ASC LIMIT 1
236 0.0003 0.00030088424682617
SELECT value FROM productattributes
                WHERE product_id = '922'
                AND name = 'ListPriceAmount'
237 0.0003 0.00032711029052734
SELECT value FROM productattributes WHERE product_id = '922' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
238 0.0004 0.00044107437133789
SELECT * FROM products WHERE id = '1670'
239 0.0004 0.00041794776916504
SELECT * FROM productimages WHERE product_id = '1670' ORDER BY sortorder ASC
240 0.0005 0.00048184394836426
SELECT * FROM product_image_select WHERE product_id = '1670'
241 0.0003 0.00031900405883789
SELECT * FROM productcustomimages WHERE product_id = '1670'
242 0.0007 0.00067901611328125
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1670' AND a.name = n.originalname
243 0.0004 0.00037693977355957
SELECT * FROM productoffers WHERE product_id = '1670' AND merchantid = 'A1X6FK5RDHNB96'
244 0.0003 0.00031018257141113
SELECT * FROM productoffers
                WHERE product_id = '1670' AND price > 0
                ORDER BY price ASC LIMIT 1
245 0.0003 0.00027298927307129
SELECT * FROM productoffers
                WHERE product_id = 1670
                ORDER BY price ASC LIMIT 1
246 0.0003 0.00028109550476074
SELECT value FROM productattributes
                WHERE product_id = '1670'
                AND name = 'ListPriceAmount'
247 0.0003 0.00031900405883789
SELECT value FROM productattributes WHERE product_id = '1670' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
248 0.0004 0.00040006637573242
SELECT * FROM products WHERE id = '1245'
249 0.0004 0.00037002563476562
SELECT * FROM productimages WHERE product_id = '1245' ORDER BY sortorder ASC
250 0.0005 0.00047588348388672
SELECT * FROM product_image_select WHERE product_id = '1245'
251 0.0003 0.00029492378234863
SELECT * FROM productcustomimages WHERE product_id = '1245'
252 0.0010 0.001025915145874
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1245' AND a.name = n.originalname
253 0.0004 0.00037693977355957
SELECT * FROM productoffers WHERE product_id = '1245' AND merchantid = 'A1X6FK5RDHNB96'
254 0.0003 0.00030088424682617
SELECT * FROM productoffers
                WHERE product_id = '1245' AND price > 0
                ORDER BY price ASC LIMIT 1
255 0.0003 0.0003349781036377
SELECT value FROM productattributes WHERE product_id = '1245' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
256 0.0004 0.00042295455932617
SELECT * FROM products WHERE id = '3258'
257 0.0004 0.0004270076751709
SELECT * FROM productimages WHERE product_id = '3258' ORDER BY sortorder ASC
258 0.0005 0.00047898292541504
SELECT * FROM product_image_select WHERE product_id = '3258'
259 0.0003 0.00029516220092773
SELECT * FROM productcustomimages WHERE product_id = '3258'
260 0.0009 0.0009160041809082
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3258' AND a.name = n.originalname
261 0.0004 0.00040602684020996
SELECT * FROM productoffers WHERE product_id = '3258' AND merchantid = 'A1X6FK5RDHNB96'
262 0.0003 0.00034189224243164
SELECT * FROM productoffers
                WHERE product_id = '3258' AND price > 0
                ORDER BY price ASC LIMIT 1
263 0.0003 0.00034403800964355
SELECT value FROM productattributes WHERE product_id = '3258' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
264 0.0004 0.0003969669342041
SELECT * FROM products WHERE id = '2210'
265 0.0004 0.00036406517028809
SELECT * FROM productimages WHERE product_id = '2210' ORDER BY sortorder ASC
266 0.0005 0.00050687789916992
SELECT * FROM product_image_select WHERE product_id = '2210'
267 0.0003 0.0002899169921875
SELECT * FROM productcustomimages WHERE product_id = '2210'
268 0.0007 0.0006871223449707
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2210' AND a.name = n.originalname
269 0.0004 0.00037097930908203
SELECT * FROM productoffers WHERE product_id = '2210' AND merchantid = 'A1X6FK5RDHNB96'
270 0.0003 0.00032591819763184
SELECT * FROM productoffers
                WHERE product_id = '2210' AND price > 0
                ORDER BY price ASC LIMIT 1
271 0.0003 0.00027704238891602
SELECT * FROM productoffers
                WHERE product_id = 2210
                ORDER BY price ASC LIMIT 1
272 0.0003 0.00028681755065918
SELECT value FROM productattributes
                WHERE product_id = '2210'
                AND name = 'ListPriceAmount'
273 0.0003 0.00030517578125
SELECT value FROM productattributes WHERE product_id = '2210' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
274 0.0014 0.0014259815216064
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4936' ORDER BY timestamp DESC
275 0.0003 0.0002601146697998
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1557' ORDER BY timestamp DESC
276 0.0002 0.00022101402282715
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1056' ORDER BY timestamp DESC
277 0.0002 0.00022411346435547
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3829' ORDER BY timestamp DESC
278 0.0002 0.00024008750915527
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1501' ORDER BY timestamp DESC
279 0.0002 0.0002129077911377
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3747' ORDER BY timestamp DESC
280 0.0002 0.00021195411682129
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1070' ORDER BY timestamp DESC
281 0.0002 0.00021791458129883
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1560' ORDER BY timestamp DESC
282 0.0002 0.00021696090698242
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3515' ORDER BY timestamp DESC
283 0.0002 0.00023198127746582
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4920' ORDER BY timestamp DESC
284 0.0003 0.00025486946105957
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2746' ORDER BY timestamp DESC
285 0.0002 0.00020909309387207
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1486' ORDER BY timestamp DESC
286 0.0002 0.00021886825561523
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4313' ORDER BY timestamp DESC
287 0.0003 0.00031399726867676
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '922' ORDER BY timestamp DESC
288 0.0003 0.00033807754516602
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1670' ORDER BY timestamp DESC
289 0.0002 0.00022315979003906
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1245' ORDER BY timestamp DESC
290 0.0002 0.00023603439331055
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3258' ORDER BY timestamp DESC
291 0.0003 0.0002751350402832
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2210' ORDER BY timestamp DESC
292 0.0015 0.0015089511871338
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
293 0.0013 0.0013420581817627
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
294 0.0003 0.00030899047851562
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
295 0.0124 0.012426137924194
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
296 0.0016 0.0015890598297119
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
297 0.0005 0.0005490779876709
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
298 0.0005 0.0005488395690918
SELECT * FROM products WHERE id = 1626
299 0.0004 0.00035190582275391
SELECT * FROM products WHERE id = 4041
300 0.0003 0.0003349781036377
SELECT * FROM products WHERE id = 4312
301 0.0004 0.00037002563476562
SELECT * FROM products WHERE id = 777
302 0.0004 0.00038909912109375
SELECT * FROM products WHERE id = 3881
303 0.0004 0.00036406517028809
SELECT * FROM products WHERE id = 4213
304 0.0003 0.00034189224243164
SELECT * FROM products WHERE id = '1626'
305 0.0005 0.00051379203796387
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
306 0.0006 0.00061392784118652
SELECT * FROM product_image_select WHERE product_id = '1626'
307 0.0004 0.00040316581726074
SELECT * FROM productcustomimages WHERE product_id = '1626'
308 0.0008 0.00078701972961426
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
309 0.0005 0.00049495697021484
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
310 0.0004 0.00040102005004883
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
311 0.0004 0.00042986869812012
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
312 0.0004 0.00042510032653809
SELECT * FROM products WHERE id = '4041'
313 0.0005 0.00046706199645996
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
314 0.0005 0.00054693222045898
SELECT * FROM product_image_select WHERE product_id = '4041'
315 0.0004 0.00037407875061035
SELECT * FROM productcustomimages WHERE product_id = '4041'
316 0.0010 0.001025915145874
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
317 0.0004 0.00043106079101562
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
318 0.0004 0.00042510032653809
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
319 0.0004 0.00044107437133789
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
320 0.0005 0.00048208236694336
SELECT * FROM products WHERE id = '4312'
321 0.0004 0.00044894218444824
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
322 0.0006 0.00060606002807617
SELECT * FROM product_image_select WHERE product_id = '4312'
323 0.0005 0.00049400329589844
SELECT * FROM productcustomimages WHERE product_id = '4312'
324 0.0010 0.0010240077972412
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
325 0.0005 0.00054097175598145
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
326 0.0004 0.00041794776916504
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
327 0.0005 0.00049400329589844
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
328 0.0005 0.00051188468933105
SELECT * FROM products WHERE id = '777'
329 0.0005 0.00052523612976074
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
330 0.0006 0.00061392784118652
SELECT * FROM product_image_select WHERE product_id = '777'
331 0.0004 0.00040411949157715
SELECT * FROM productcustomimages WHERE product_id = '777'
332 0.0010 0.0010340213775635
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
333 0.0004 0.00042080879211426
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
334 0.0004 0.00037908554077148
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
335 0.0004 0.00037503242492676
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
336 0.0005 0.00047111511230469
SELECT * FROM products WHERE id = '3881'
337 0.0004 0.00044417381286621
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
338 0.0006 0.00057005882263184
SELECT * FROM product_image_select WHERE product_id = '3881'
339 0.0003 0.0003209114074707
SELECT * FROM productcustomimages WHERE product_id = '3881'
340 0.0010 0.0010130405426025
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
341 0.0005 0.00051712989807129
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
342 0.0004 0.00038003921508789
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
343 0.0004 0.00041794776916504
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
344 0.0005 0.00047111511230469
SELECT * FROM products WHERE id = '4213'
345 0.0005 0.0005040168762207
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
346 0.0006 0.00060009956359863
SELECT * FROM product_image_select WHERE product_id = '4213'
347 0.0005 0.00045895576477051
SELECT * FROM productcustomimages WHERE product_id = '4213'
348 0.0011 0.0010650157928467
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
349 0.0004 0.00039815902709961
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
350 0.0004 0.00038814544677734
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
351 0.0004 0.00042605400085449
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
352 0.0019 0.001917839050293
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
353 0.0006 0.00057506561279297
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
354 0.0022 0.002161979675293
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
355 0.0015 0.001521110534668
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
356 0.0005 0.00053787231445312
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
357 0.0006 0.00059103965759277
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
358 0.0005 0.00052094459533691
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'