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.4995341300964 345 1.1496 0


No Amazon API Requests Made.


App Debug - Total Time 1.4995341300964 seconds

Number Time From Start Name Description
1 0.26917910575867 Initialise Initialise FSB Function
2 0.27670502662659 App Controller Start Start of the App controller (called before the controller of every page)
3 0.31386518478394 Start of getCategoryListByGroup Function Before first category groups query
4 0.31560301780701 After initial query Before first category groups query
5 0.31560397148132 Get Category List for Group Before the call to getCategoryList function
6 0.31560611724854 Start of GetCategoryList function Start of the function
7 0.31560802459717 Before getting categories Query to get specific category list
8 0.31720018386841 After getting categories Query to get specific category list
9 0.31720113754272 Before getting category custom Before call to function getCategoryCustom
10 0.34000205993652 After getting category custom After call to function getCategoryCustom
11 0.34000396728516 Before getting category custom Before call to function getCategoryCustom
12 0.35058498382568 After getting category custom After call to function getCategoryCustom
13 0.3505871295929 Before getting category custom Before call to function getCategoryCustom
14 0.35639595985413 After getting category custom After call to function getCategoryCustom
15 0.35639810562134 Before getting category custom Before call to function getCategoryCustom
16 0.36092495918274 After getting category custom After call to function getCategoryCustom
17 0.36092710494995 Before getting category custom Before call to function getCategoryCustom
18 0.36515212059021 After getting category custom After call to function getCategoryCustom
19 0.36515307426453 Before getting category custom Before call to function getCategoryCustom
20 0.36939811706543 After getting category custom After call to function getCategoryCustom
21 0.36940002441406 End of GetCategoryList function End of the function
22 0.36940407752991 Get Category List for Group Before the call to getCategoryList function
23 0.36940598487854 Start of GetCategoryList function Start of the function
24 0.36940717697144 Before getting categories Query to get specific category list
25 0.36984515190125 End of getCategoryListByGroup Function Before return()
26 1.1373400688171 App Controller End End of the App controller (called before the controller of every page)
27 1.3327989578247 App_after Controller Start Start of the App_after controller (called after the controller of every page)
28 1.3355910778046 Before Get Options Before the call to getOptions in the tpl class
29 1.403037071228 After Get Options After the call to getOptions in the tpl class
30 1.403076171875 App_after Controller End End of the App_after controller (called after the controller of every page)
31 1.4995241165161 Finalizing debug Before the debug is output to the page.
32 1.4995341300964 End of App This is the end of the app logging, final timestamp


Query Debug - 345 Database Queries. Total time 1.1496 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0022 0.0022130012512207
SELECT parameter, value FROM parameters
2 0.0055 0.0055310726165771
SELECT * FROM `bad_bots`
3 0.0003 0.00031781196594238
SET time_zone = 'Europe/London'
4 0.0057 0.0056688785552979
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0045 0.0045430660247803
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"18.117.162.216\";}'
6 0.0036 0.0035669803619385
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1746966330'
7 0.0034 0.0033988952636719
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0007 0.00066995620727539
UPDATE autorun SET lastrun = '2025-05-11 12:25:30' WHERE id = '13'
9 0.0011 0.0011169910430908
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0050 0.0050160884857178
SELECT id FROM pages WHERE pagename = 'search' LIMIT 1
11 0.0007 0.00068211555480957
SELECT * FROM pages WHERE id = 52
12 0.0069 0.0068950653076172
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13 0.0293 0.029283046722412
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14 0.0006 0.00056815147399902
SELECT * FROM pages WHERE pagename = 'search'
15 0.0017 0.0017309188842773
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0016 0.0015830993652344
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0089 0.0089142322540283
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.0021209716796875
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.0011 0.0011241436004639
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20 0.0004 0.00043797492980957
SELECT id FROM categories WHERE parent_id = '26'
21 0.0055 0.0055170059204102
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.0014 0.0014009475708008
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0 
23 0.0015 0.0014939308166504
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.0013 0.0013101100921631
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25 0.0004 0.00042104721069336
SELECT * FROM categorygroups WHERE id = '1'
26 0.0037 0.0036940574645996
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.0005 0.00047397613525391
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.00037288665771484
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29 0.0004 0.00039911270141602
SELECT id FROM categories WHERE parent_id = '27'
30 0.0035 0.0035231113433838
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.0005 0.00047779083251953
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.0006 0.00055694580078125
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
33 0.0006 0.00057506561279297
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34 0.0004 0.00044798851013184
SELECT * FROM categorygroups WHERE id = '1'
35 0.0014 0.0013890266418457
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.00045013427734375
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.00041413307189941
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38 0.0004 0.0003972053527832
SELECT id FROM categories WHERE parent_id = '28'
39 0.0014 0.0014331340789795
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.00046300888061523
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.0005 0.00046086311340332
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.0004 0.00040602684020996
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43 0.0004 0.00035905838012695
SELECT * FROM categorygroups WHERE id = '1'
44 0.0005 0.00054812431335449
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.0005 0.00045180320739746
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.00035214424133301
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47 0.0004 0.00037407875061035
SELECT id FROM categories WHERE parent_id = '29'
48 0.0006 0.00062394142150879
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.0004 0.00041818618774414
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.0008 0.00081205368041992
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.00048089027404785
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52 0.0004 0.00041699409484863
SELECT * FROM categorygroups WHERE id = '1'
53 0.0005 0.00054597854614258
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.0004 0.00044584274291992
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.00039386749267578
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56 0.0004 0.00042104721069336
SELECT id FROM categories WHERE parent_id = '30'
57 0.0006 0.0006101131439209
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.00045680999755859
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.00048398971557617
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.00044989585876465
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61 0.0004 0.00037598609924316
SELECT * FROM categorygroups WHERE id = '1'
62 0.0006 0.00058507919311523
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
63 0.0004 0.0004119873046875
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.00041413307189941
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65 0.0004 0.00038504600524902
SELECT id FROM categories WHERE parent_id = '31'
66 0.0007 0.00065422058105469
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.00046896934509277
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.00046515464782715
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
69 0.0004 0.00042080879211426
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70 0.0004 0.00040602684020996
SELECT * FROM categorygroups WHERE id = '1'
71 0.0004 0.00043392181396484
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
72 0.0028 0.0028491020202637
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73 0.0016 0.0016279220581055
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74 0.0005 0.00051307678222656
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.0011 0.0010919570922852
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76 0.0013 0.0012969970703125
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77 0.0008 0.00082206726074219
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78 0.7536 0.75356101989746
SELECT * FROM ipgeocountries WHERE INET_ATON('18.117.162.216') >= INET_ATON(ip_start) AND INET_ATON('18.117.162.216') <= INET_ATON(ip_end)
79 0.0026 0.0025780200958252
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80 0.0016 0.0016088485717773
SELECT * FROM countryredirects WHERE countrycode = 'US'
81 0.0010 0.0010318756103516
SELECT * FROM pages WHERE pagename = 'search'
82 0.0056 0.0056388378143311
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
83 0.0019 0.0018649101257324
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
84 0.0027 0.0026719570159912
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
85 0.0056 0.0055539608001709
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
86 0.0017 0.0017409324645996
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
87 0.0009 0.00090599060058594
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
88 0.0049 0.004910945892334
INSERT INTO searches (`keywords`, `timestamp`, `ip`) SELECT '2', NOW(), '18.117.162.216'
89 0.0022 0.0021970272064209
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.0012 0.001244068145752
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.0122 0.012226104736328
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.0007 0.00071096420288086
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.0006 0.00059795379638672
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.0008 0.00082516670227051
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.0108 0.010785102844238
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.0005 0.00046801567077637
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.0005 0.00045490264892578
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.0008 0.00078392028808594
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.0008 0.00078582763671875
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.0049 0.0049328804016113
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.00032901763916016
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.0003 0.00027084350585938
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.0006 0.00062704086303711
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.0052 0.0052101612091064
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.0003359317779541
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.0003 0.0002601146697998
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.0004 0.00037384033203125
SELECT * FROM products WHERE id = '4950'
108 0.0018 0.0018439292907715
SELECT * FROM productimages WHERE product_id = '4950' ORDER BY sortorder ASC
109 0.0013 0.0012860298156738
SELECT * FROM product_image_select WHERE product_id = '4950'
110 0.0011 0.0010800361633301
SELECT * FROM productcustomimages WHERE product_id = '4950'
111 0.0018 0.0017759799957275
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4950' AND a.name = n.originalname
112 0.0012 0.0011940002441406
SELECT * FROM productoffers WHERE product_id = '4950' AND merchantid = 'A1X6FK5RDHNB96'
113 0.0003 0.0003359317779541
SELECT * FROM productoffers
                WHERE product_id = '4950' AND price > 0
                ORDER BY price ASC LIMIT 1
114 0.0005 0.00050497055053711
SELECT value FROM productattributes WHERE product_id = '4950' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
115 0.0005 0.00048398971557617
SELECT * FROM products WHERE id = '4953'
116 0.0005 0.00054001808166504
SELECT * FROM productimages WHERE product_id = '4953' ORDER BY sortorder ASC
117 0.0006 0.00057101249694824
SELECT * FROM product_image_select WHERE product_id = '4953'
118 0.0003 0.00034594535827637
SELECT * FROM productcustomimages WHERE product_id = '4953'
119 0.0008 0.00081801414489746
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4953' AND a.name = n.originalname
120 0.0005 0.00047421455383301
SELECT * FROM productoffers WHERE product_id = '4953' AND merchantid = 'A1X6FK5RDHNB96'
121 0.0004 0.00038003921508789
SELECT * FROM productoffers
                WHERE product_id = '4953' AND price > 0
                ORDER BY price ASC LIMIT 1
122 0.0004 0.00038003921508789
SELECT value FROM productattributes WHERE product_id = '4953' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
123 0.0005 0.00046896934509277
SELECT * FROM products WHERE id = '4926'
124 0.0004 0.00043392181396484
SELECT * FROM productimages WHERE product_id = '4926' ORDER BY sortorder ASC
125 0.0005 0.00050806999206543
SELECT * FROM product_image_select WHERE product_id = '4926'
126 0.0004 0.00036811828613281
SELECT * FROM productcustomimages WHERE product_id = '4926'
127 0.0018 0.0018119812011719
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4926' AND a.name = n.originalname
128 0.0004 0.00040698051452637
SELECT * FROM productoffers WHERE product_id = '4926' AND merchantid = 'A1X6FK5RDHNB96'
129 0.0003 0.00033307075500488
SELECT * FROM productoffers
                WHERE product_id = '4926' AND price > 0
                ORDER BY price ASC LIMIT 1
130 0.0004 0.00042104721069336
SELECT value FROM productattributes WHERE product_id = '4926' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
131 0.0004 0.00044894218444824
SELECT * FROM products WHERE id = '4925'
132 0.0005 0.00052094459533691
SELECT * FROM productimages WHERE product_id = '4925' ORDER BY sortorder ASC
133 0.0006 0.00057792663574219
SELECT * FROM product_image_select WHERE product_id = '4925'
134 0.0004 0.00037598609924316
SELECT * FROM productcustomimages WHERE product_id = '4925'
135 0.0015 0.0014710426330566
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4925' AND a.name = n.originalname
136 0.0006 0.00057697296142578
SELECT * FROM productoffers WHERE product_id = '4925' AND merchantid = 'A1X6FK5RDHNB96'
137 0.0004 0.00038480758666992
SELECT * FROM productoffers
                WHERE product_id = '4925' AND price > 0
                ORDER BY price ASC LIMIT 1
138 0.0007 0.00066399574279785
SELECT value FROM productattributes WHERE product_id = '4925' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
139 0.0007 0.0006859302520752
SELECT * FROM products WHERE id = '4919'
140 0.0007 0.00069689750671387
SELECT * FROM productimages WHERE product_id = '4919' ORDER BY sortorder ASC
141 0.0008 0.00076603889465332
SELECT * FROM product_image_select WHERE product_id = '4919'
142 0.0004 0.00042915344238281
SELECT * FROM productcustomimages WHERE product_id = '4919'
143 0.0025 0.0024969577789307
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4919' AND a.name = n.originalname
144 0.0008 0.00077915191650391
SELECT * FROM productoffers WHERE product_id = '4919' AND merchantid = 'A1X6FK5RDHNB96'
145 0.0004 0.00042605400085449
SELECT * FROM productoffers
                WHERE product_id = '4919' AND price > 0
                ORDER BY price ASC LIMIT 1
146 0.0005 0.00050592422485352
SELECT value FROM productattributes WHERE product_id = '4919' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
147 0.0006 0.00056600570678711
SELECT * FROM products WHERE id = '2029'
148 0.0007 0.00068402290344238
SELECT * FROM productimages WHERE product_id = '2029' ORDER BY sortorder ASC
149 0.0009 0.00085711479187012
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
150 0.0008 0.00084304809570312
SELECT * FROM product_image_select WHERE product_id = '2029'
151 0.0004 0.0004429817199707
SELECT * FROM productcustomimages WHERE product_id = '2029'
152 0.0006 0.00059986114501953
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
153 0.0030 0.0030059814453125
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
154 0.0006 0.0005650520324707
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
155 0.0010 0.0010371208190918
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2029' AND a.name = n.originalname
156 0.0004 0.00036311149597168
SELECT * FROM productoffers WHERE product_id = '2029' AND merchantid = 'A1X6FK5RDHNB96'
157 0.0003 0.00034403800964355
SELECT * FROM productoffers
                WHERE product_id = '2029' AND price > 0
                ORDER BY price ASC LIMIT 1
158 0.0004 0.00040483474731445
SELECT * FROM productoffers
                WHERE product_id = 2029
                ORDER BY price ASC LIMIT 1
159 0.0004 0.00040316581726074
SELECT value FROM productattributes
                WHERE product_id = '2029'
                AND name = 'ListPriceAmount'
160 0.0005 0.00050711631774902
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
161 0.0006 0.00062799453735352
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
162 0.0005 0.00053191184997559
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
163 0.0006 0.00057315826416016
SELECT value FROM productattributes WHERE product_id = '2029' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
164 0.0007 0.00074887275695801
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
165 0.0004 0.0004429817199707
SELECT * FROM products WHERE id = '862'
166 0.0006 0.00060415267944336
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
167 0.0007 0.00074601173400879
SELECT * FROM product_image_select WHERE product_id = '862'
168 0.0006 0.00062084197998047
SELECT * FROM productcustomimages WHERE product_id = '862'
169 0.0016 0.001561164855957
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
170 0.0007 0.00066685676574707
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
171 0.0005 0.00047802925109863
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
172 0.0004 0.00042819976806641
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
173 0.0005 0.00046300888061523
SELECT * FROM products WHERE id = '1011'
174 0.0006 0.00063586235046387
SELECT * FROM productimages WHERE product_id = '1011' ORDER BY sortorder ASC
175 0.0010 0.00096511840820312
SELECT * FROM product_image_select WHERE product_id = '1011'
176 0.0005 0.00051498413085938
SELECT * FROM productcustomimages WHERE product_id = '1011'
177 0.0018 0.0017900466918945
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1011' AND a.name = n.originalname
178 0.0006 0.00062704086303711
SELECT * FROM productoffers WHERE product_id = '1011' AND merchantid = 'A1X6FK5RDHNB96'
179 0.0004 0.00043702125549316
SELECT * FROM productoffers
                WHERE product_id = '1011' AND price > 0
                ORDER BY price ASC LIMIT 1
180 0.0005 0.00046110153198242
SELECT value FROM productattributes WHERE product_id = '1011' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
181 0.0005 0.00051999092102051
SELECT * FROM products WHERE id = '4122'
182 0.0008 0.0008399486541748
SELECT * FROM productimages WHERE product_id = '4122' ORDER BY sortorder ASC
183 0.0006 0.00064516067504883
SELECT * FROM product_image_select WHERE product_id = '4122'
184 0.0005 0.00054597854614258
SELECT * FROM productcustomimages WHERE product_id = '4122'
185 0.0017 0.0016989707946777
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4122' AND a.name = n.originalname
186 0.0005 0.00045299530029297
SELECT * FROM productoffers WHERE product_id = '4122' AND merchantid = 'A1X6FK5RDHNB96'
187 0.0003 0.00034999847412109
SELECT * FROM productoffers
                WHERE product_id = '4122' AND price > 0
                ORDER BY price ASC LIMIT 1
188 0.0005 0.00050091743469238
SELECT value FROM productattributes WHERE product_id = '4122' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
189 0.0005 0.00045895576477051
SELECT * FROM products WHERE id = '1010'
190 0.0005 0.00053906440734863
SELECT * FROM productimages WHERE product_id = '1010' ORDER BY sortorder ASC
191 0.0006 0.00059819221496582
SELECT * FROM product_image_select WHERE product_id = '1010'
192 0.0004 0.00039386749267578
SELECT * FROM productcustomimages WHERE product_id = '1010'
193 0.0013 0.0012509822845459
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1010' AND a.name = n.originalname
194 0.0004 0.00041699409484863
SELECT * FROM productoffers WHERE product_id = '1010' AND merchantid = 'A1X6FK5RDHNB96'
195 0.0004 0.00038003921508789
SELECT * FROM productoffers
                WHERE product_id = '1010' AND price > 0
                ORDER BY price ASC LIMIT 1
196 0.0004 0.00038814544677734
SELECT value FROM productattributes WHERE product_id = '1010' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
197 0.0005 0.0005040168762207
SELECT * FROM products WHERE id = '1140'
198 0.0005 0.0005030632019043
SELECT * FROM productimages WHERE product_id = '1140' ORDER BY sortorder ASC
199 0.0006 0.00057005882263184
SELECT * FROM product_image_select WHERE product_id = '1140'
200 0.0004 0.00038981437683105
SELECT * FROM productcustomimages WHERE product_id = '1140'
201 0.0011 0.001086950302124
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1140' AND a.name = n.originalname
202 0.0006 0.00058197975158691
SELECT * FROM productoffers WHERE product_id = '1140' AND merchantid = 'A1X6FK5RDHNB96'
203 0.0004 0.00037503242492676
SELECT * FROM productoffers
                WHERE product_id = '1140' AND price > 0
                ORDER BY price ASC LIMIT 1
204 0.0004 0.00039005279541016
SELECT value FROM productattributes WHERE product_id = '1140' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
205 0.0006 0.00055289268493652
SELECT * FROM products WHERE id = '1110'
206 0.0007 0.00073695182800293
SELECT * FROM productimages WHERE product_id = '1110' ORDER BY sortorder ASC
207 0.0007 0.00070691108703613
SELECT * FROM product_image_select WHERE product_id = '1110'
208 0.0006 0.00055980682373047
SELECT * FROM productcustomimages WHERE product_id = '1110'
209 0.0013 0.0013289451599121
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1110' AND a.name = n.originalname
210 0.0005 0.00053906440734863
SELECT * FROM productoffers WHERE product_id = '1110' AND merchantid = 'A1X6FK5RDHNB96'
211 0.0006 0.00061702728271484
SELECT * FROM productoffers
                WHERE product_id = '1110' AND price > 0
                ORDER BY price ASC LIMIT 1
212 0.0005 0.00052595138549805
SELECT value FROM productattributes WHERE product_id = '1110' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
213 0.0006 0.00060582160949707
SELECT * FROM products WHERE id = '4930'
214 0.0006 0.00056815147399902
SELECT * FROM productimages WHERE product_id = '4930' ORDER BY sortorder ASC
215 0.0006 0.00062203407287598
SELECT * FROM product_image_select WHERE product_id = '4930'
216 0.0005 0.00049686431884766
SELECT * FROM productcustomimages WHERE product_id = '4930'
217 0.0013 0.0013461112976074
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4930' AND a.name = n.originalname
218 0.0005 0.00049185752868652
SELECT * FROM productoffers WHERE product_id = '4930' AND merchantid = 'A1X6FK5RDHNB96'
219 0.0004 0.00044894218444824
SELECT * FROM productoffers
                WHERE product_id = '4930' AND price > 0
                ORDER BY price ASC LIMIT 1
220 0.0005 0.0005190372467041
SELECT value FROM productattributes WHERE product_id = '4930' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
221 0.0005 0.00048613548278809
SELECT * FROM products WHERE id = '1160'
222 0.0006 0.00057816505432129
SELECT * FROM productimages WHERE product_id = '1160' ORDER BY sortorder ASC
223 0.0007 0.0007021427154541
SELECT * FROM product_image_select WHERE product_id = '1160'
224 0.0005 0.0004889965057373
SELECT * FROM productcustomimages WHERE product_id = '1160'
225 0.0015 0.0015301704406738
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1160' AND a.name = n.originalname
226 0.0004 0.0004279613494873
SELECT * FROM productoffers WHERE product_id = '1160' AND merchantid = 'A1X6FK5RDHNB96'
227 0.0005 0.00049686431884766
SELECT * FROM productoffers
                WHERE product_id = '1160' AND price > 0
                ORDER BY price ASC LIMIT 1
228 0.0005 0.00046396255493164
SELECT value FROM productattributes WHERE product_id = '1160' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
229 0.0005 0.00053191184997559
SELECT * FROM products WHERE id = '4954'
230 0.0004 0.00043392181396484
SELECT * FROM productimages WHERE product_id = '4954' ORDER BY sortorder ASC
231 0.0006 0.00055098533630371
SELECT * FROM product_image_select WHERE product_id = '4954'
232 0.0003 0.00033903121948242
SELECT * FROM productcustomimages WHERE product_id = '4954'
233 0.0012 0.0011940002441406
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4954' AND a.name = n.originalname
234 0.0006 0.00058794021606445
SELECT * FROM productoffers WHERE product_id = '4954' AND merchantid = 'A1X6FK5RDHNB96'
235 0.0004 0.00040388107299805
SELECT * FROM productoffers
                WHERE product_id = '4954' AND price > 0
                ORDER BY price ASC LIMIT 1
236 0.0004 0.00042104721069336
SELECT value FROM productattributes WHERE product_id = '4954' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
237 0.0004 0.00044584274291992
SELECT * FROM products WHERE id = '1055'
238 0.0005 0.00049710273742676
SELECT * FROM productimages WHERE product_id = '1055' ORDER BY sortorder ASC
239 0.0005 0.00054812431335449
SELECT * FROM product_image_select WHERE product_id = '1055'
240 0.0007 0.00066494941711426
SELECT * FROM productcustomimages WHERE product_id = '1055'
241 0.0019 0.0019421577453613
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1055' AND a.name = n.originalname
242 0.0004 0.00042104721069336
SELECT * FROM productoffers WHERE product_id = '1055' AND merchantid = 'A1X6FK5RDHNB96'
243 0.0003 0.00034594535827637
SELECT * FROM productoffers
                WHERE product_id = '1055' AND price > 0
                ORDER BY price ASC LIMIT 1
244 0.0004 0.00037097930908203
SELECT value FROM productattributes WHERE product_id = '1055' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
245 0.0005 0.00050997734069824
SELECT * FROM products WHERE id = '1215'
246 0.0009 0.00093412399291992
SELECT * FROM productimages WHERE product_id = '1215' ORDER BY sortorder ASC
247 0.0010 0.0010151863098145
SELECT * FROM product_image_select WHERE product_id = '1215'
248 0.0007 0.00069189071655273
SELECT * FROM productcustomimages WHERE product_id = '1215'
249 0.0015 0.0014519691467285
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1215' AND a.name = n.originalname
250 0.0005 0.00051116943359375
SELECT * FROM productoffers WHERE product_id = '1215' AND merchantid = 'A1X6FK5RDHNB96'
251 0.0004 0.00037193298339844
SELECT * FROM productoffers
                WHERE product_id = '1215' AND price > 0
                ORDER BY price ASC LIMIT 1
252 0.0005 0.00046205520629883
SELECT value FROM productattributes WHERE product_id = '1215' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
253 0.0005 0.00046515464782715
SELECT * FROM products WHERE id = '770'
254 0.0005 0.00046396255493164
SELECT * FROM productimages WHERE product_id = '770' ORDER BY sortorder ASC
255 0.0013 0.0013480186462402
SELECT * FROM product_image_select WHERE product_id = '770'
256 0.0018 0.001762866973877
SELECT * FROM productcustomimages WHERE product_id = '770'
257 0.0030 0.0029799938201904
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '770' AND a.name = n.originalname
258 0.0019 0.001884937286377
SELECT * FROM productoffers WHERE product_id = '770' AND merchantid = 'A1X6FK5RDHNB96'
259 0.0020 0.0020339488983154
SELECT * FROM productoffers
                WHERE product_id = '770' AND price > 0
                ORDER BY price ASC LIMIT 1
260 0.0005 0.00047111511230469
SELECT value FROM productattributes WHERE product_id = '770' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
261 0.0018 0.0017950534820557
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4950' ORDER BY timestamp DESC
262 0.0004 0.00038409233093262
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4953' ORDER BY timestamp DESC
263 0.0003 0.0002899169921875
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4926' ORDER BY timestamp DESC
264 0.0003 0.00033092498779297
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4925' ORDER BY timestamp DESC
265 0.0003 0.00033712387084961
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4919' ORDER BY timestamp DESC
266 0.0003 0.00028109550476074
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2029' ORDER BY timestamp DESC
267 0.0004 0.00038981437683105
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '862' ORDER BY timestamp DESC
268 0.0004 0.00044107437133789
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1011' ORDER BY timestamp DESC
269 0.0003 0.00030899047851562
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4122' ORDER BY timestamp DESC
270 0.0004 0.00036001205444336
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1010' ORDER BY timestamp DESC
271 0.0003 0.00029802322387695
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1140' ORDER BY timestamp DESC
272 0.0003 0.00030708312988281
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1110' ORDER BY timestamp DESC
273 0.0003 0.00028181076049805
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4930' ORDER BY timestamp DESC
274 0.0003 0.00026106834411621
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1160' ORDER BY timestamp DESC
275 0.0003 0.00033807754516602
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4954' ORDER BY timestamp DESC
276 0.0003 0.00028586387634277
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1055' ORDER BY timestamp DESC
277 0.0004 0.0003659725189209
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1215' ORDER BY timestamp DESC
278 0.0003 0.00026917457580566
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '770' ORDER BY timestamp DESC
279 0.0027 0.002669095993042
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
280 0.0023 0.0023338794708252
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
281 0.0004 0.0004119873046875
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
282 0.0185 0.018532037734985
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
283 0.0016 0.0015828609466553
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
284 0.0005 0.00047016143798828
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
285 0.0005 0.00047397613525391
SELECT * FROM products WHERE id = 1626
286 0.0004 0.00035595893859863
SELECT * FROM products WHERE id = 4041
287 0.0003 0.00030708312988281
SELECT * FROM products WHERE id = 4312
288 0.0003 0.00031781196594238
SELECT * FROM products WHERE id = 777
289 0.0003 0.00034499168395996
SELECT * FROM products WHERE id = 3881
290 0.0003 0.00033283233642578
SELECT * FROM products WHERE id = 4213
291 0.0003 0.00034904479980469
SELECT * FROM products WHERE id = '1626'
292 0.0004 0.00042390823364258
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
293 0.0005 0.00051593780517578
SELECT * FROM product_image_select WHERE product_id = '1626'
294 0.0003 0.00032877922058105
SELECT * FROM productcustomimages WHERE product_id = '1626'
295 0.0008 0.00080490112304688
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
296 0.0005 0.00048494338989258
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
297 0.0005 0.00054812431335449
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
298 0.0012 0.0012290477752686
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
299 0.0009 0.00091385841369629
SELECT * FROM products WHERE id = '4041'
300 0.0005 0.0005180835723877
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
301 0.0008 0.00080704689025879
SELECT * FROM product_image_select WHERE product_id = '4041'
302 0.0004 0.00041890144348145
SELECT * FROM productcustomimages WHERE product_id = '4041'
303 0.0016 0.0015919208526611
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
304 0.0006 0.00058293342590332
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
305 0.0004 0.00041794776916504
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
306 0.0004 0.00044393539428711
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
307 0.0006 0.00060296058654785
SELECT * FROM products WHERE id = '4312'
308 0.0005 0.00049018859863281
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
309 0.0007 0.00065088272094727
SELECT * FROM product_image_select WHERE product_id = '4312'
310 0.0012 0.0011630058288574
SELECT * FROM productcustomimages WHERE product_id = '4312'
311 0.0015 0.0014660358428955
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
312 0.0005 0.0005040168762207
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
313 0.0004 0.00043392181396484
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
314 0.0006 0.0005500316619873
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
315 0.0007 0.00069403648376465
SELECT * FROM products WHERE id = '777'
316 0.0005 0.0004880428314209
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
317 0.0007 0.00068092346191406
SELECT * FROM product_image_select WHERE product_id = '777'
318 0.0004 0.00035905838012695
SELECT * FROM productcustomimages WHERE product_id = '777'
319 0.0014 0.0013980865478516
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
320 0.0005 0.00050806999206543
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
321 0.0004 0.00042009353637695
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
322 0.0004 0.0004429817199707
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
323 0.0005 0.00050902366638184
SELECT * FROM products WHERE id = '3881'
324 0.0005 0.0005180835723877
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
325 0.0007 0.00066089630126953
SELECT * FROM product_image_select WHERE product_id = '3881'
326 0.0007 0.00071287155151367
SELECT * FROM productcustomimages WHERE product_id = '3881'
327 0.0017 0.0017058849334717
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
328 0.0005 0.00053215026855469
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
329 0.0004 0.00044798851013184
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
330 0.0005 0.00049090385437012
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
331 0.0005 0.00053715705871582
SELECT * FROM products WHERE id = '4213'
332 0.0006 0.00060701370239258
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
333 0.0009 0.00091290473937988
SELECT * FROM product_image_select WHERE product_id = '4213'
334 0.0004 0.00038981437683105
SELECT * FROM productcustomimages WHERE product_id = '4213'
335 0.0016 0.0015840530395508
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
336 0.0004 0.0004420280456543
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
337 0.0006 0.00057482719421387
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
338 0.0005 0.00054383277893066
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
339 0.0023 0.0023159980773926
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
340 0.0007 0.0007328987121582
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
341 0.0029 0.0028820037841797
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
342 0.0041 0.0040571689605713
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
343 0.0006 0.00064897537231445
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
344 0.0009 0.00094890594482422
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
345 0.0009 0.0009000301361084
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'