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
2.4186151027679 344 0.9742 0


No Amazon API Requests Made.


App Debug - Total Time 2.4186151027679 seconds

Number Time From Start Name Description
1 1.4300811290741 Initialise Initialise FSB Function
2 1.432168006897 App Controller Start Start of the App controller (called before the controller of every page)
3 1.4562971591949 Start of getCategoryListByGroup Function Before first category groups query
4 1.4572701454163 After initial query Before first category groups query
5 1.4572710990906 Get Category List for Group Before the call to getCategoryList function
6 1.4572720527649 Start of GetCategoryList function Start of the function
7 1.4572730064392 Before getting categories Query to get specific category list
8 1.4581520557404 After getting categories Query to get specific category list
9 1.4581520557404 Before getting category custom Before call to function getCategoryCustom
10 1.4724249839783 After getting category custom After call to function getCategoryCustom
11 1.4724271297455 Before getting category custom Before call to function getCategoryCustom
12 1.4804689884186 After getting category custom After call to function getCategoryCustom
13 1.4804701805115 Before getting category custom Before call to function getCategoryCustom
14 1.4847841262817 After getting category custom After call to function getCategoryCustom
15 1.4847841262817 Before getting category custom Before call to function getCategoryCustom
16 1.4878280162811 After getting category custom After call to function getCategoryCustom
17 1.4878289699554 Before getting category custom Before call to function getCategoryCustom
18 1.4907610416412 After getting category custom After call to function getCategoryCustom
19 1.4907619953156 Before getting category custom Before call to function getCategoryCustom
20 1.4945139884949 After getting category custom After call to function getCategoryCustom
21 1.4945151805878 End of GetCategoryList function End of the function
22 1.4945180416107 Get Category List for Group Before the call to getCategoryList function
23 1.4945180416107 Start of GetCategoryList function Start of the function
24 1.494518995285 Before getting categories Query to get specific category list
25 1.4948329925537 End of getCategoryListByGroup Function Before return()
26 2.2500140666962 App Controller End End of the App controller (called before the controller of every page)
27 2.3596889972687 App_after Controller Start Start of the App_after controller (called after the controller of every page)
28 2.3605971336365 Before Get Options Before the call to getOptions in the tpl class
29 2.3976311683655 After Get Options After the call to getOptions in the tpl class
30 2.3976581096649 App_after Controller End End of the App_after controller (called after the controller of every page)
31 2.4186079502106 Finalizing debug Before the debug is output to the page.
32 2.4186151027679 End of App This is the end of the app logging, final timestamp


Query Debug - 344 Database Queries. Total time 0.9742 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0010 0.00097084045410156
SELECT parameter, value FROM parameters
2 0.0050 0.0050210952758789
SELECT * FROM `bad_bots`
3 0.0007 0.00073099136352539
SET time_zone = 'Europe/London'
4 0.0015 0.0014638900756836
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0022 0.0021929740905762
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:11:\"18.97.14.87\";}'
6 0.0020 0.0020210742950439
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1748127736'
7 0.0014 0.0013909339904785
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0004 0.00037193298339844
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0009 0.00086498260498047
SELECT id FROM pages WHERE pagename = 'search' LIMIT 1
10 0.0003 0.00025701522827148
SELECT * FROM pages WHERE id = 52
11 0.0015 0.0014798641204834
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0219 0.021891117095947
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0006 0.00057196617126465
SELECT * FROM pages WHERE pagename = 'search'
14 0.0010 0.00096893310546875
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0009 0.00087118148803711
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0055 0.00547194480896
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
17 0.0008 0.00080990791320801
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
18 0.0006 0.00059890747070312
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0003 0.00029683113098145
SELECT id FROM categories WHERE parent_id = '26'
20 0.0046 0.0045750141143799
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 
21 0.0008 0.00076985359191895
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 
22 0.0008 0.00078105926513672
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
23 0.0007 0.00066113471984863
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0003 0.0002751350402832
SELECT * FROM categorygroups WHERE id = '1'
25 0.0029 0.002932071685791
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
26 0.0003 0.00034713745117188
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
27 0.0003 0.00026798248291016
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0003 0.00028395652770996
SELECT id FROM categories WHERE parent_id = '27'
29 0.0029 0.0029451847076416
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 
30 0.0003 0.00033307075500488
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 
31 0.0003 0.00034499168395996
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
32 0.0003 0.00029683113098145
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0003 0.00027298927307129
SELECT * FROM categorygroups WHERE id = '1'
34 0.0011 0.0010747909545898
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
35 0.0003 0.0003209114074707
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
36 0.0003 0.0002598762512207
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0003 0.00027918815612793
SELECT id FROM categories WHERE parent_id = '28'
38 0.0011 0.0011138916015625
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 
39 0.0003 0.0003199577331543
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 
40 0.0003 0.00032806396484375
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
41 0.0003 0.00030207633972168
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0003 0.00029802322387695
SELECT * FROM categorygroups WHERE id = '1'
43 0.0004 0.00042104721069336
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
44 0.0003 0.00029301643371582
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
45 0.0003 0.00027203559875488
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0003 0.00031900405883789
SELECT id FROM categories WHERE parent_id = '29'
47 0.0004 0.00042510032653809
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 
48 0.0003 0.00032711029052734
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 
49 0.0004 0.00035500526428223
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
50 0.0003 0.00031685829162598
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0003 0.00029993057250977
SELECT * FROM categorygroups WHERE id = '1'
52 0.0004 0.00037693977355957
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
53 0.0003 0.00028610229492188
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
54 0.0003 0.0002901554107666
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0003 0.00029087066650391
SELECT id FROM categories WHERE parent_id = '30'
56 0.0004 0.0004270076751709
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 
57 0.0003 0.00030994415283203
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 
58 0.0004 0.00036001205444336
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
59 0.0003 0.00030088424682617
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0003 0.00027203559875488
SELECT * FROM categorygroups WHERE id = '1'
61 0.0004 0.00039815902709961
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
62 0.0007 0.00067496299743652
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
63 0.0004 0.00040602684020996
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0004 0.00037503242492676
SELECT id FROM categories WHERE parent_id = '31'
65 0.0005 0.00051689147949219
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 
66 0.0003 0.00032687187194824
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 
67 0.0004 0.00039815902709961
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
68 0.0003 0.00029611587524414
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0003 0.00034403800964355
SELECT * FROM categorygroups WHERE id = '1'
70 0.0003 0.00031089782714844
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0018 0.0018198490142822
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0008 0.00075602531433105
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0005 0.00047206878662109
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
74 0.0007 0.00069308280944824
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0009 0.0009000301361084
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0006 0.00062799453735352
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.7466 0.74662208557129
SELECT * FROM ipgeocountries WHERE INET_ATON('18.97.14.87') >= INET_ATON(ip_start) AND INET_ATON('18.97.14.87') <= INET_ATON(ip_end)
78 0.0014 0.0013928413391113
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0006 0.00060009956359863
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0004 0.00035285949707031
SELECT * FROM pages WHERE pagename = 'search'
81 0.0050 0.0050439834594727
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
82 0.0013 0.0013270378112793
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
83 0.0009 0.00086212158203125
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
84 0.0045 0.0045211315155029
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
85 0.0013 0.0013060569763184
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
86 0.0003 0.00034403800964355
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
87 0.0007 0.00070810317993164
INSERT INTO searches (`keywords`, `timestamp`, `ip`) SELECT '', NOW(), '18.97.14.87'
88 0.0005 0.00046801567077637
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (title)
    AGAINST ('+' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (title) AGAINST ('+' 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 ('+'), 'bundle' AS type FROM bundles b
		WHERE MATCH (title) AGAINST ('+' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1
89 0.0003 0.00030684471130371
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+' 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 ('+'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1
90 0.0040 0.0039501190185547
SELECT DISTINCT (p.id), salesrank, price, linktitle,
          'product' AS type
          FROM products p 
		WHERE ((description LIKE '') OR (keyfeatures LIKE '') OR (title LIKE ''))

		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1
91 0.0003 0.00030398368835449
SELECT DISTINCT (p.id), price, linktitle,
          'ebayproduct' AS type
          FROM ebay_products p 
		WHERE ((description LIKE '') OR (title LIKE ''))
		AND hide = 0
92 0.0003 0.00033688545227051
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE '') OR (title LIKE ''))
		AND hide = 0
93 0.0003 0.0003209114074707
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+' 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 ('+'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1
94 0.0039 0.0039260387420654
SELECT DISTINCT (p.id), salesrank, price, linktitle,
          'product' AS type
          FROM products p 
		WHERE ((description LIKE '%%') OR (keyfeatures LIKE '%%') OR (title LIKE '%%'))

		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1
95 0.0003 0.00031280517578125
SELECT DISTINCT (p.id), price, linktitle,
          'ebayproduct' AS type
          FROM ebay_products p 
		WHERE ((description LIKE '%%') OR (title LIKE '%%'))
		AND hide = 0
96 0.0002 0.0002129077911377
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE '%%') OR (title LIKE '%%'))
		AND hide = 0
97 0.0003 0.00030612945556641
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (title)
    AGAINST ('+' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (title) AGAINST ('+' 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 ('+'), 'bundle' AS type FROM bundles b
		WHERE MATCH (title) AGAINST ('+' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
98 0.0004 0.0003809928894043
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+' 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 ('+'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
99 0.0040 0.0040390491485596
SELECT DISTINCT (p.id), salesrank, price, linktitle,
          'product' AS type
          FROM products p 
		WHERE ((description LIKE '') OR (keyfeatures LIKE '') OR (title LIKE ''))

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

		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
104 0.0003 0.00026607513427734
SELECT DISTINCT (p.id), price, linktitle,
          'ebayproduct' AS type
          FROM ebay_products p 
		WHERE ((description LIKE '%%') OR (title LIKE '%%'))
		AND hide = 0
105 0.0002 0.0002140998840332
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE '%%') OR (title LIKE '%%'))
		AND hide = 0
106 0.0003 0.00027990341186523
SELECT * FROM products WHERE id = '4950'
107 0.0012 0.0011889934539795
SELECT * FROM productimages WHERE product_id = '4950' ORDER BY sortorder ASC
108 0.0008 0.0007779598236084
SELECT * FROM product_image_select WHERE product_id = '4950'
109 0.0006 0.0005800724029541
SELECT * FROM productcustomimages WHERE product_id = '4950'
110 0.0010 0.0010061264038086
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4950' AND a.name = n.originalname
111 0.0009 0.00086188316345215
SELECT * FROM productoffers WHERE product_id = '4950' AND merchantid = 'A1X6FK5RDHNB96'
112 0.0003 0.00027203559875488
SELECT * FROM productoffers
                WHERE product_id = '4950' AND price > 0
                ORDER BY price ASC LIMIT 1
113 0.0004 0.00036001205444336
SELECT value FROM productattributes WHERE product_id = '4950' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
114 0.0005 0.00047779083251953
SELECT * FROM products WHERE id = '4953'
115 0.0003 0.00032997131347656
SELECT * FROM productimages WHERE product_id = '4953' ORDER BY sortorder ASC
116 0.0004 0.00042414665222168
SELECT * FROM product_image_select WHERE product_id = '4953'
117 0.0003 0.00026607513427734
SELECT * FROM productcustomimages WHERE product_id = '4953'
118 0.0006 0.00059103965759277
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4953' AND a.name = n.originalname
119 0.0003 0.00031495094299316
SELECT * FROM productoffers WHERE product_id = '4953' AND merchantid = 'A1X6FK5RDHNB96'
120 0.0003 0.0002591609954834
SELECT * FROM productoffers
                WHERE product_id = '4953' AND price > 0
                ORDER BY price ASC LIMIT 1
121 0.0004 0.00038599967956543
SELECT value FROM productattributes WHERE product_id = '4953' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
122 0.0004 0.00039792060852051
SELECT * FROM products WHERE id = '4933'
123 0.0007 0.00067901611328125
SELECT * FROM productimages WHERE product_id = '4933' ORDER BY sortorder ASC
124 0.0006 0.00057101249694824
SELECT * FROM product_image_select WHERE product_id = '4933'
125 0.0003 0.0002739429473877
SELECT * FROM productcustomimages WHERE product_id = '4933'
126 0.0008 0.00082516670227051
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4933' AND a.name = n.originalname
127 0.0010 0.0010459423065186
SELECT * FROM productoffers WHERE product_id = '4933' AND merchantid = 'A1X6FK5RDHNB96'
128 0.0003 0.00026679039001465
SELECT * FROM productoffers
                WHERE product_id = '4933' AND price > 0
                ORDER BY price ASC LIMIT 1
129 0.0005 0.00046706199645996
SELECT value FROM productattributes WHERE product_id = '4933' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
130 0.0005 0.00045204162597656
SELECT * FROM products WHERE id = '4926'
131 0.0005 0.00050711631774902
SELECT * FROM productimages WHERE product_id = '4926' ORDER BY sortorder ASC
132 0.0008 0.00075602531433105
SELECT * FROM product_image_select WHERE product_id = '4926'
133 0.0003 0.00034499168395996
SELECT * FROM productcustomimages WHERE product_id = '4926'
134 0.0015 0.0014829635620117
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4926' AND a.name = n.originalname
135 0.0005 0.00047588348388672
SELECT * FROM productoffers WHERE product_id = '4926' AND merchantid = 'A1X6FK5RDHNB96'
136 0.0003 0.00028395652770996
SELECT * FROM productoffers
                WHERE product_id = '4926' AND price > 0
                ORDER BY price ASC LIMIT 1
137 0.0003 0.00033307075500488
SELECT value FROM productattributes WHERE product_id = '4926' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
138 0.0003 0.00032496452331543
SELECT * FROM products WHERE id = '4925'
139 0.0004 0.00037598609924316
SELECT * FROM productimages WHERE product_id = '4925' ORDER BY sortorder ASC
140 0.0007 0.00071811676025391
SELECT * FROM product_image_select WHERE product_id = '4925'
141 0.0004 0.00036120414733887
SELECT * FROM productcustomimages WHERE product_id = '4925'
142 0.0007 0.00069689750671387
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4925' AND a.name = n.originalname
143 0.0003 0.00029587745666504
SELECT * FROM productoffers WHERE product_id = '4925' AND merchantid = 'A1X6FK5RDHNB96'
144 0.0003 0.00026202201843262
SELECT * FROM productoffers
                WHERE product_id = '4925' AND price > 0
                ORDER BY price ASC LIMIT 1
145 0.0003 0.00026893615722656
SELECT value FROM productattributes WHERE product_id = '4925' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
146 0.0003 0.00032806396484375
SELECT * FROM products WHERE id = '868'
147 0.0003 0.00034499168395996
SELECT * FROM productimages WHERE product_id = '868' ORDER BY sortorder ASC
148 0.0004 0.00042915344238281
SELECT * FROM product_image_select WHERE product_id = '868'
149 0.0003 0.00025796890258789
SELECT * FROM productcustomimages WHERE product_id = '868'
150 0.0006 0.00058102607727051
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '868' AND a.name = n.originalname
151 0.0004 0.00043082237243652
SELECT * FROM productoffers WHERE product_id = '868' AND merchantid = 'A1X6FK5RDHNB96'
152 0.0003 0.0002601146697998
SELECT * FROM productoffers
                WHERE product_id = '868' AND price > 0
                ORDER BY price ASC LIMIT 1
153 0.0003 0.00027298927307129
SELECT value FROM productattributes WHERE product_id = '868' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
154 0.0004 0.00035285949707031
SELECT * FROM products WHERE id = '4919'
155 0.0004 0.00035595893859863
SELECT * FROM productimages WHERE product_id = '4919' ORDER BY sortorder ASC
156 0.0004 0.0004429817199707
SELECT * FROM product_image_select WHERE product_id = '4919'
157 0.0003 0.00026202201843262
SELECT * FROM productcustomimages WHERE product_id = '4919'
158 0.0008 0.00083303451538086
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4919' AND a.name = n.originalname
159 0.0003 0.00032305717468262
SELECT * FROM productoffers WHERE product_id = '4919' AND merchantid = 'A1X6FK5RDHNB96'
160 0.0003 0.0002589225769043
SELECT * FROM productoffers
                WHERE product_id = '4919' AND price > 0
                ORDER BY price ASC LIMIT 1
161 0.0003 0.00027084350585938
SELECT value FROM productattributes WHERE product_id = '4919' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
162 0.0003 0.00032806396484375
SELECT * FROM products WHERE id = '2029'
163 0.0004 0.00037217140197754
SELECT * FROM productimages WHERE product_id = '2029' ORDER BY sortorder ASC
164 0.0004 0.00044703483581543
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2029' AND p.id = pi.product_id ORDER BY pi.sortorder
165 0.0004 0.00042390823364258
SELECT * FROM product_image_select WHERE product_id = '2029'
166 0.0003 0.00028085708618164
SELECT * FROM productcustomimages WHERE product_id = '2029'
167 0.0004 0.0003659725189209
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 = '2029'
                GROUP BY o.product_id
168 0.0012 0.0011699199676514
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     = '2029'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
169 0.0003 0.00033283233642578
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2029
170 0.0006 0.00057506561279297
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2029' AND a.name = n.originalname
171 0.0002 0.00023388862609863
SELECT * FROM productoffers WHERE product_id = '2029' AND merchantid = 'A1X6FK5RDHNB96'
172 0.0002 0.00023412704467773
SELECT * FROM productoffers
                WHERE product_id = '2029' AND price > 0
                ORDER BY price ASC LIMIT 1
173 0.0002 0.00022411346435547
SELECT * FROM productoffers
                WHERE product_id = 2029
                ORDER BY price ASC LIMIT 1
174 0.0002 0.00023484230041504
SELECT value FROM productattributes
                WHERE product_id = '2029'
                AND name = 'ListPriceAmount'
175 0.0003 0.00027585029602051
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 = '2029'
                GROUP BY o.product_id
176 0.0004 0.00044989585876465
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     = '2029'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
177 0.0003 0.00026297569274902
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2029
178 0.0003 0.00033712387084961
SELECT value FROM productattributes WHERE product_id = '2029' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
179 0.0005 0.00053906440734863
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '2029'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
180 0.0003 0.00026202201843262
SELECT * FROM products WHERE id = '862'
181 0.0004 0.00040483474731445
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
182 0.0004 0.00043797492980957
SELECT * FROM product_image_select WHERE product_id = '862'
183 0.0003 0.00030612945556641
SELECT * FROM productcustomimages WHERE product_id = '862'
184 0.0006 0.0006411075592041
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
185 0.0003 0.00029397010803223
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
186 0.0003 0.00030803680419922
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
187 0.0003 0.00029110908508301
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
188 0.0003 0.0003199577331543
SELECT * FROM products WHERE id = '1011'
189 0.0004 0.0003509521484375
SELECT * FROM productimages WHERE product_id = '1011' ORDER BY sortorder ASC
190 0.0006 0.00062990188598633
SELECT * FROM product_image_select WHERE product_id = '1011'
191 0.0004 0.00037598609924316
SELECT * FROM productcustomimages WHERE product_id = '1011'
192 0.0007 0.00066208839416504
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1011' AND a.name = n.originalname
193 0.0003 0.00030112266540527
SELECT * FROM productoffers WHERE product_id = '1011' AND merchantid = 'A1X6FK5RDHNB96'
194 0.0003 0.00026202201843262
SELECT * FROM productoffers
                WHERE product_id = '1011' AND price > 0
                ORDER BY price ASC LIMIT 1
195 0.0003 0.0002598762512207
SELECT value FROM productattributes WHERE product_id = '1011' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
196 0.0004 0.00036907196044922
SELECT * FROM products WHERE id = '4122'
197 0.0007 0.00071191787719727
SELECT * FROM productimages WHERE product_id = '4122' ORDER BY sortorder ASC
198 0.0005 0.00052285194396973
SELECT * FROM product_image_select WHERE product_id = '4122'
199 0.0003 0.00027585029602051
SELECT * FROM productcustomimages WHERE product_id = '4122'
200 0.0011 0.0010981559753418
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4122' AND a.name = n.originalname
201 0.0003 0.00030708312988281
SELECT * FROM productoffers WHERE product_id = '4122' AND merchantid = 'A1X6FK5RDHNB96'
202 0.0003 0.00026822090148926
SELECT * FROM productoffers
                WHERE product_id = '4122' AND price > 0
                ORDER BY price ASC LIMIT 1
203 0.0003 0.00025320053100586
SELECT value FROM productattributes WHERE product_id = '4122' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
204 0.0004 0.00038599967956543
SELECT * FROM products WHERE id = '1010'
205 0.0004 0.00037503242492676
SELECT * FROM productimages WHERE product_id = '1010' ORDER BY sortorder ASC
206 0.0004 0.0004279613494873
SELECT * FROM product_image_select WHERE product_id = '1010'
207 0.0003 0.00029802322387695
SELECT * FROM productcustomimages WHERE product_id = '1010'
208 0.0008 0.00082683563232422
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1010' AND a.name = n.originalname
209 0.0003 0.00030899047851562
SELECT * FROM productoffers WHERE product_id = '1010' AND merchantid = 'A1X6FK5RDHNB96'
210 0.0003 0.00025415420532227
SELECT * FROM productoffers
                WHERE product_id = '1010' AND price > 0
                ORDER BY price ASC LIMIT 1
211 0.0003 0.00026202201843262
SELECT value FROM productattributes WHERE product_id = '1010' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
212 0.0003 0.00031495094299316
SELECT * FROM products WHERE id = '1140'
213 0.0004 0.00037789344787598
SELECT * FROM productimages WHERE product_id = '1140' ORDER BY sortorder ASC
214 0.0005 0.00046181678771973
SELECT * FROM product_image_select WHERE product_id = '1140'
215 0.0003 0.00026488304138184
SELECT * FROM productcustomimages WHERE product_id = '1140'
216 0.0007 0.00066304206848145
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1140' AND a.name = n.originalname
217 0.0003 0.00030398368835449
SELECT * FROM productoffers WHERE product_id = '1140' AND merchantid = 'A1X6FK5RDHNB96'
218 0.0003 0.00025796890258789
SELECT * FROM productoffers
                WHERE product_id = '1140' AND price > 0
                ORDER BY price ASC LIMIT 1
219 0.0003 0.00029301643371582
SELECT value FROM productattributes WHERE product_id = '1140' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
220 0.0003 0.00034999847412109
SELECT * FROM products WHERE id = '1061'
221 0.0004 0.00038599967956543
SELECT * FROM productimages WHERE product_id = '1061' ORDER BY sortorder ASC
222 0.0005 0.00048995018005371
SELECT * FROM product_image_select WHERE product_id = '1061'
223 0.0003 0.00029802322387695
SELECT * FROM productcustomimages WHERE product_id = '1061'
224 0.0007 0.0007331371307373
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1061' AND a.name = n.originalname
225 0.0003 0.00031709671020508
SELECT * FROM productoffers WHERE product_id = '1061' AND merchantid = 'A1X6FK5RDHNB96'
226 0.0003 0.00027203559875488
SELECT * FROM productoffers
                WHERE product_id = '1061' AND price > 0
                ORDER BY price ASC LIMIT 1
227 0.0003 0.00026607513427734
SELECT value FROM productattributes WHERE product_id = '1061' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
228 0.0003 0.00032210350036621
SELECT * FROM products WHERE id = '2165'
229 0.0004 0.00035810470581055
SELECT * FROM productimages WHERE product_id = '2165' ORDER BY sortorder ASC
230 0.0007 0.0007469654083252
SELECT * FROM product_image_select WHERE product_id = '2165'
231 0.0003 0.00033402442932129
SELECT * FROM productcustomimages WHERE product_id = '2165'
232 0.0006 0.00060009956359863
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2165' AND a.name = n.originalname
233 0.0003 0.00030303001403809
SELECT * FROM productoffers WHERE product_id = '2165' AND merchantid = 'A1X6FK5RDHNB96'
234 0.0003 0.00025391578674316
SELECT * FROM productoffers
                WHERE product_id = '2165' AND price > 0
                ORDER BY price ASC LIMIT 1
235 0.0003 0.00025391578674316
SELECT value FROM productattributes WHERE product_id = '2165' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
236 0.0003 0.00031304359436035
SELECT * FROM products WHERE id = '4939'
237 0.0003 0.00032782554626465
SELECT * FROM productimages WHERE product_id = '4939' ORDER BY sortorder ASC
238 0.0004 0.00042510032653809
SELECT * FROM product_image_select WHERE product_id = '4939'
239 0.0003 0.00025796890258789
SELECT * FROM productcustomimages WHERE product_id = '4939'
240 0.0007 0.0006871223449707
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4939' AND a.name = n.originalname
241 0.0003 0.0003349781036377
SELECT * FROM productoffers WHERE product_id = '4939' AND merchantid = 'A1X6FK5RDHNB96'
242 0.0003 0.00028491020202637
SELECT * FROM productoffers
                WHERE product_id = '4939' AND price > 0
                ORDER BY price ASC LIMIT 1
243 0.0003 0.00025296211242676
SELECT value FROM productattributes WHERE product_id = '4939' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
244 0.0003 0.00032711029052734
SELECT * FROM products WHERE id = '1110'
245 0.0004 0.00035786628723145
SELECT * FROM productimages WHERE product_id = '1110' ORDER BY sortorder ASC
246 0.0005 0.00046515464782715
SELECT * FROM product_image_select WHERE product_id = '1110'
247 0.0003 0.00025796890258789
SELECT * FROM productcustomimages WHERE product_id = '1110'
248 0.0007 0.00067687034606934
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1110' AND a.name = n.originalname
249 0.0003 0.00029802322387695
SELECT * FROM productoffers WHERE product_id = '1110' AND merchantid = 'A1X6FK5RDHNB96'
250 0.0003 0.0002601146697998
SELECT * FROM productoffers
                WHERE product_id = '1110' AND price > 0
                ORDER BY price ASC LIMIT 1
251 0.0003 0.00028014183044434
SELECT value FROM productattributes WHERE product_id = '1110' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
252 0.0003 0.00033402442932129
SELECT * FROM products WHERE id = '4930'
253 0.0004 0.00036787986755371
SELECT * FROM productimages WHERE product_id = '4930' ORDER BY sortorder ASC
254 0.0004 0.0004270076751709
SELECT * FROM product_image_select WHERE product_id = '4930'
255 0.0003 0.00026583671569824
SELECT * FROM productcustomimages WHERE product_id = '4930'
256 0.0007 0.00072002410888672
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4930' AND a.name = n.originalname
257 0.0003 0.00030398368835449
SELECT * FROM productoffers WHERE product_id = '4930' AND merchantid = 'A1X6FK5RDHNB96'
258 0.0003 0.0002589225769043
SELECT * FROM productoffers
                WHERE product_id = '4930' AND price > 0
                ORDER BY price ASC LIMIT 1
259 0.0003 0.00025486946105957
SELECT value FROM productattributes WHERE product_id = '4930' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
260 0.0008 0.00075411796569824
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4950' ORDER BY timestamp DESC
261 0.0002 0.00022387504577637
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4953' ORDER BY timestamp DESC
262 0.0002 0.00020194053649902
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4933' ORDER BY timestamp DESC
263 0.0002 0.00020980834960938
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4926' ORDER BY timestamp DESC
264 0.0002 0.00021195411682129
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4925' ORDER BY timestamp DESC
265 0.0002 0.00019502639770508
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '868' ORDER BY timestamp DESC
266 0.0002 0.00019097328186035
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4919' ORDER BY timestamp DESC
267 0.0002 0.00022602081298828
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2029' ORDER BY timestamp DESC
268 0.0002 0.00020599365234375
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '862' ORDER BY timestamp DESC
269 0.0002 0.0001981258392334
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1011' ORDER BY timestamp DESC
270 0.0002 0.00022196769714355
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4122' ORDER BY timestamp DESC
271 0.0002 0.00021696090698242
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1010' ORDER BY timestamp DESC
272 0.0002 0.0001981258392334
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1140' ORDER BY timestamp DESC
273 0.0002 0.00020813941955566
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1061' ORDER BY timestamp DESC
274 0.0002 0.00024890899658203
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2165' ORDER BY timestamp DESC
275 0.0002 0.00020503997802734
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4939' ORDER BY timestamp DESC
276 0.0002 0.00019216537475586
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1110' ORDER BY timestamp DESC
277 0.0002 0.00019097328186035
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4930' ORDER BY timestamp DESC
278 0.0008 0.00075793266296387
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
279 0.0006 0.0006401538848877
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
280 0.0002 0.00023913383483887
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
281 0.0116 0.011631011962891
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
282 0.0008 0.00078392028808594
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
283 0.0003 0.00034880638122559
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
284 0.0003 0.00034594535827637
SELECT * FROM products WHERE id = 1626
285 0.0003 0.00028514862060547
SELECT * FROM products WHERE id = 4041
286 0.0002 0.00024914741516113
SELECT * FROM products WHERE id = 4312
287 0.0003 0.00025606155395508
SELECT * FROM products WHERE id = 777
288 0.0003 0.00029587745666504
SELECT * FROM products WHERE id = 3881
289 0.0003 0.00025510787963867
SELECT * FROM products WHERE id = 4213
290 0.0003 0.00028586387634277
SELECT * FROM products WHERE id = '1626'
291 0.0004 0.00036311149597168
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
292 0.0005 0.0004730224609375
SELECT * FROM product_image_select WHERE product_id = '1626'
293 0.0003 0.00028800964355469
SELECT * FROM productcustomimages WHERE product_id = '1626'
294 0.0006 0.0005650520324707
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
295 0.0003 0.00032210350036621
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
296 0.0003 0.00026297569274902
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
297 0.0003 0.00026512145996094
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
298 0.0003 0.00031900405883789
SELECT * FROM products WHERE id = '4041'
299 0.0003 0.0002899169921875
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
300 0.0004 0.00042486190795898
SELECT * FROM product_image_select WHERE product_id = '4041'
301 0.0003 0.00026988983154297
SELECT * FROM productcustomimages WHERE product_id = '4041'
302 0.0007 0.00067400932312012
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
303 0.0003 0.00029706954956055
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
304 0.0003 0.00026082992553711
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
305 0.0003 0.00027012825012207
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
306 0.0003 0.00034189224243164
SELECT * FROM products WHERE id = '4312'
307 0.0003 0.00029301643371582
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
308 0.0004 0.00042176246643066
SELECT * FROM product_image_select WHERE product_id = '4312'
309 0.0003 0.00025701522827148
SELECT * FROM productcustomimages WHERE product_id = '4312'
310 0.0006 0.00063395500183105
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
311 0.0003 0.00030112266540527
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
312 0.0003 0.00026392936706543
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
313 0.0003 0.00025796890258789
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
314 0.0003 0.00034904479980469
SELECT * FROM products WHERE id = '777'
315 0.0003 0.00031805038452148
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
316 0.0005 0.00046586990356445
SELECT * FROM product_image_select WHERE product_id = '777'
317 0.0003 0.0002591609954834
SELECT * FROM productcustomimages WHERE product_id = '777'
318 0.0006 0.00063991546630859
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
319 0.0003 0.00030398368835449
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
320 0.0003 0.00026798248291016
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
321 0.0003 0.00025606155395508
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
322 0.0003 0.00034499168395996
SELECT * FROM products WHERE id = '3881'
323 0.0004 0.00037097930908203
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
324 0.0005 0.00045490264892578
SELECT * FROM product_image_select WHERE product_id = '3881'
325 0.0003 0.00026106834411621
SELECT * FROM productcustomimages WHERE product_id = '3881'
326 0.0007 0.00066518783569336
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
327 0.0003 0.00030994415283203
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
328 0.0003 0.00026893615722656
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
329 0.0003 0.00027990341186523
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
330 0.0003 0.00032401084899902
SELECT * FROM products WHERE id = '4213'
331 0.0004 0.00037717819213867
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
332 0.0005 0.00045895576477051
SELECT * FROM product_image_select WHERE product_id = '4213'
333 0.0003 0.00025391578674316
SELECT * FROM productcustomimages WHERE product_id = '4213'
334 0.0007 0.00071310997009277
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
335 0.0003 0.00030517578125
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
336 0.0003 0.00026106834411621
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
337 0.0003 0.00030112266540527
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
338 0.0010 0.00096583366394043
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
339 0.0005 0.00050091743469238
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
340 0.0015 0.0015449523925781
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
341 0.0008 0.00083208084106445
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
342 0.0004 0.00035405158996582
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
343 0.0004 0.00041007995605469
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
344 0.0004 0.00038790702819824
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'