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.2949059009552 369 1.0034 0


No Amazon API Requests Made.


App Debug - Total Time 1.2949059009552 seconds

Number Time From Start Name Description
1 0.25847601890564 Initialise Initialise FSB Function
2 0.2617781162262 App Controller Start Start of the App controller (called before the controller of every page)
3 0.28708791732788 Start of getCategoryListByGroup Function Before first category groups query
4 0.28755903244019 After initial query Before first category groups query
5 0.28756093978882 Get Category List for Group Before the call to getCategoryList function
6 0.28756499290466 Start of GetCategoryList function Start of the function
7 0.28756904602051 Before getting categories Query to get specific category list
8 0.28838109970093 After getting categories Query to get specific category list
9 0.28838300704956 Before getting category custom Before call to function getCategoryCustom
10 0.30776500701904 After getting category custom After call to function getCategoryCustom
11 0.30776906013489 Before getting category custom Before call to function getCategoryCustom
12 0.31870698928833 After getting category custom After call to function getCategoryCustom
13 0.31870913505554 Before getting category custom Before call to function getCategoryCustom
14 0.32533407211304 After getting category custom After call to function getCategoryCustom
15 0.32533597946167 Before getting category custom Before call to function getCategoryCustom
16 0.33015894889832 After getting category custom After call to function getCategoryCustom
17 0.33016109466553 Before getting category custom Before call to function getCategoryCustom
18 0.33478808403015 After getting category custom After call to function getCategoryCustom
19 0.33478999137878 Before getting category custom Before call to function getCategoryCustom
20 0.33906292915344 After getting category custom After call to function getCategoryCustom
21 0.33906507492065 End of GetCategoryList function End of the function
22 0.33907103538513 Get Category List for Group Before the call to getCategoryList function
23 0.33907413482666 Start of GetCategoryList function Start of the function
24 0.33907699584961 Before getting categories Query to get specific category list
25 0.33958292007446 End of getCategoryListByGroup Function Before return()
26 0.90860390663147 App Controller End End of the App controller (called before the controller of every page)
27 1.1579089164734 App_after Controller Start Start of the App_after controller (called after the controller of every page)
28 1.1592049598694 Before Get Options Before the call to getOptions in the tpl class
29 1.2700800895691 After Get Options After the call to getOptions in the tpl class
30 1.2701120376587 App_after Controller End End of the App_after controller (called after the controller of every page)
31 1.2948911190033 Finalizing debug Before the debug is output to the page.
32 1.2949039936066 End of App This is the end of the app logging, final timestamp


Query Debug - 369 Database Queries. Total time 1.0034 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0024 0.0023670196533203
SELECT parameter, value FROM parameters
2 0.0036 0.0036141872406006
SELECT * FROM `bad_bots`
3 0.0004 0.00038790702819824
SET time_zone = 'Europe/London'
4 0.0007 0.0007331371307373
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0008 0.00080394744873047
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"3.145.182.183\";}'
6 0.0006 0.00064897537231445
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1738817760'
7 0.0016 0.0016410350799561
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0012 0.0011739730834961
UPDATE autorun SET lastrun = '2025-02-06 04:56:00' WHERE id = '13'
9 0.0009 0.00093793869018555
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0012 0.0011789798736572
SELECT id FROM pages WHERE pagename = 'search' LIMIT 1
11 0.0009 0.0008549690246582
SELECT * FROM pages WHERE id = 52
12 0.0015 0.00146484375
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13 0.0228 0.022847175598145
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14 0.0005 0.00048995018005371
SELECT * FROM pages WHERE pagename = 'search'
15 0.0005 0.00045990943908691
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0008 0.00079512596130371
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0059 0.0058989524841309
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.0005 0.00048613548278809
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.0004 0.00041103363037109
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20 0.0004 0.00041818618774414
SELECT id FROM categories WHERE parent_id = '26'
21 0.0084 0.0083818435668945
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.0022 0.0021982192993164
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.0006 0.00058102607727051
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.0005 0.00049591064453125
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25 0.0004 0.0003972053527832
SELECT * FROM categorygroups WHERE id = '1'
26 0.0038 0.0038130283355713
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.0006 0.00058102607727051
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29 0.0005 0.00045514106750488
SELECT id FROM categories WHERE parent_id = '27'
30 0.0036 0.0036091804504395
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.00052714347839355
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
32 0.0005 0.00048518180847168
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
33 0.0005 0.00050616264343262
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34 0.0004 0.00039887428283691
SELECT * FROM categorygroups WHERE id = '1'
35 0.0014 0.0013580322265625
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.00049018859863281
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.0005 0.00047397613525391
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38 0.0007 0.00066494941711426
SELECT id FROM categories WHERE parent_id = '28'
39 0.0015 0.0015161037445068
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.00047993659973145
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.00051116943359375
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
42 0.0005 0.00049018859863281
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43 0.0006 0.00056314468383789
SELECT * FROM categorygroups WHERE id = '1'
44 0.0006 0.00056791305541992
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.00053310394287109
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.0005 0.00049495697021484
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47 0.0005 0.00051188468933105
SELECT id FROM categories WHERE parent_id = '29'
48 0.0007 0.00069999694824219
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
49 0.0005 0.00052309036254883
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.0005 0.00049209594726562
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.00047993659973145
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52 0.0004 0.0004279613494873
SELECT * FROM categorygroups WHERE id = '1'
53 0.0009 0.00085997581481934
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.00042104721069336
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.0003969669342041
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56 0.0004 0.0003969669342041
SELECT id FROM categories WHERE parent_id = '30'
57 0.0006 0.00061297416687012
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.00049805641174316
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.00051522254943848
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
60 0.0005 0.00045204162597656
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61 0.0004 0.0003969669342041
SELECT * FROM categorygroups WHERE id = '1'
62 0.0006 0.00059914588928223
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.00041818618774414
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.00037002563476562
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65 0.0004 0.00039291381835938
SELECT id FROM categories WHERE parent_id = '31'
66 0.0006 0.00064992904663086
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
67 0.0004 0.00044608116149902
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.00045609474182129
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
69 0.0005 0.00047087669372559
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70 0.0004 0.00039410591125488
SELECT * FROM categorygroups WHERE id = '1'
71 0.0005 0.00049519538879395
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
72 0.0015 0.0015010833740234
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73 0.0007 0.000701904296875
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74 0.0007 0.00071501731872559
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.0005 0.00046300888061523
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76 0.0017 0.0017290115356445
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77 0.0012 0.0011739730834961
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78 0.5602 0.56017398834229
SELECT * FROM ipgeocountries WHERE INET_ATON('3.145.182.183') >= INET_ATON(ip_start) AND INET_ATON('3.145.182.183') <= INET_ATON(ip_end)
79 0.0010 0.0010480880737305
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80 0.0004 0.00043201446533203
SELECT * FROM countryredirects WHERE countrycode = 'US'
81 0.0009 0.00088596343994141
SELECT * FROM pages WHERE pagename = 'search'
82 0.0075 0.007451057434082
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
83 0.0023 0.0023128986358643
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
84 0.0008 0.00077390670776367
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
85 0.0066 0.0066030025482178
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
86 0.0020 0.0019700527191162
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
87 0.0005 0.00053310394287109
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
88 0.0020 0.0020232200622559
INSERT INTO searches (`keywords`, `timestamp`, `ip`) SELECT '4', NOW(), '3.145.182.183'
89 0.0007 0.00074100494384766
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (title)
    AGAINST ('+4' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (title) AGAINST ('+4' 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 ('+4'), 'bundle' AS type FROM bundles b
		WHERE MATCH (title) AGAINST ('+4' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1
90 0.0006 0.0005791187286377
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+4' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+4' 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 ('+4'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+4' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1
91 0.0038 0.0037949085235596
SELECT DISTINCT (p.id), salesrank, price, linktitle,
          'product' AS type
          FROM products p 
		WHERE ((description LIKE '4') OR (keyfeatures LIKE '4') OR (title LIKE '4'))

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

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

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

		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
105 0.0005 0.00046896934509277
SELECT DISTINCT (p.id), price, linktitle,
          'ebayproduct' AS type
          FROM ebay_products p 
		WHERE ((description LIKE '%4%') OR (title LIKE '%4%'))
		AND hide = 0
106 0.0004 0.00041389465332031
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE '%4%') OR (title LIKE '%4%'))
		AND hide = 0
107 0.0006 0.00055599212646484
SELECT * FROM products WHERE id = '1066'
108 0.0006 0.00058102607727051
SELECT * FROM productimages WHERE product_id = '1066' ORDER BY sortorder ASC
109 0.0007 0.00068211555480957
SELECT * FROM product_image_select WHERE product_id = '1066'
110 0.0006 0.00064301490783691
SELECT * FROM productcustomimages WHERE product_id = '1066'
111 0.0012 0.0011589527130127
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1066' AND a.name = n.originalname
112 0.0005 0.0005488395690918
SELECT * FROM productoffers WHERE product_id = '1066' AND merchantid = 'A1X6FK5RDHNB96'
113 0.0009 0.00087690353393555
SELECT * FROM productoffers
                WHERE product_id = '1066' AND price > 0
                ORDER BY price ASC LIMIT 1
114 0.0006 0.000640869140625
SELECT * FROM productoffers
                WHERE product_id = 1066
                ORDER BY price ASC LIMIT 1
115 0.0009 0.00086784362792969
SELECT value FROM productattributes
                WHERE product_id = '1066'
                AND name = 'ListPriceAmount'
116 0.0009 0.00087594985961914
SELECT value FROM productattributes WHERE product_id = '1066' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
117 0.0010 0.00098419189453125
SELECT * FROM products WHERE id = '1072'
118 0.0009 0.00091814994812012
SELECT * FROM productimages WHERE product_id = '1072' ORDER BY sortorder ASC
119 0.0014 0.0013718605041504
SELECT * FROM product_image_select WHERE product_id = '1072'
120 0.0007 0.0007169246673584
SELECT * FROM productcustomimages WHERE product_id = '1072'
121 0.0021 0.0021347999572754
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1072' AND a.name = n.originalname
122 0.0015 0.001521110534668
SELECT * FROM productoffers WHERE product_id = '1072' AND merchantid = 'A1X6FK5RDHNB96'
123 0.0007 0.00067901611328125
SELECT * FROM productoffers
                WHERE product_id = '1072' AND price > 0
                ORDER BY price ASC LIMIT 1
124 0.0007 0.00071978569030762
SELECT * FROM productoffers
                WHERE product_id = 1072
                ORDER BY price ASC LIMIT 1
125 0.0007 0.00068783760070801
SELECT value FROM productattributes
                WHERE product_id = '1072'
                AND name = 'ListPriceAmount'
126 0.0008 0.0007939338684082
SELECT value FROM productattributes WHERE product_id = '1072' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
127 0.0009 0.00089788436889648
SELECT * FROM products WHERE id = '1081'
128 0.0007 0.00072407722473145
SELECT * FROM productimages WHERE product_id = '1081' ORDER BY sortorder ASC
129 0.0011 0.0011370182037354
SELECT * FROM product_image_select WHERE product_id = '1081'
130 0.0006 0.00063490867614746
SELECT * FROM productcustomimages WHERE product_id = '1081'
131 0.0023 0.0022962093353271
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1081' AND a.name = n.originalname
132 0.0009 0.0008549690246582
SELECT * FROM productoffers WHERE product_id = '1081' AND merchantid = 'A1X6FK5RDHNB96'
133 0.0005 0.00052309036254883
SELECT * FROM productoffers
                WHERE product_id = '1081' AND price > 0
                ORDER BY price ASC LIMIT 1
134 0.0004 0.00039410591125488
SELECT * FROM productoffers
                WHERE product_id = 1081
                ORDER BY price ASC LIMIT 1
135 0.0005 0.00051212310791016
SELECT value FROM productattributes
                WHERE product_id = '1081'
                AND name = 'ListPriceAmount'
136 0.0006 0.00061607360839844
SELECT value FROM productattributes WHERE product_id = '1081' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
137 0.0007 0.0006568431854248
SELECT * FROM products WHERE id = '1112'
138 0.0008 0.00080704689025879
SELECT * FROM productimages WHERE product_id = '1112' ORDER BY sortorder ASC
139 0.0008 0.00084710121154785
SELECT * FROM product_image_select WHERE product_id = '1112'
140 0.0005 0.0005030632019043
SELECT * FROM productcustomimages WHERE product_id = '1112'
141 0.0017 0.0017220973968506
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1112' AND a.name = n.originalname
142 0.0007 0.00067305564880371
SELECT * FROM productoffers WHERE product_id = '1112' AND merchantid = 'A1X6FK5RDHNB96'
143 0.0005 0.00046491622924805
SELECT * FROM productoffers
                WHERE product_id = '1112' AND price > 0
                ORDER BY price ASC LIMIT 1
144 0.0005 0.00050711631774902
SELECT * FROM productoffers
                WHERE product_id = 1112
                ORDER BY price ASC LIMIT 1
145 0.0005 0.00050806999206543
SELECT value FROM productattributes
                WHERE product_id = '1112'
                AND name = 'ListPriceAmount'
146 0.0006 0.0005650520324707
SELECT value FROM productattributes WHERE product_id = '1112' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
147 0.0012 0.0012280941009521
SELECT * FROM products WHERE id = '1119'
148 0.0009 0.00088286399841309
SELECT * FROM productimages WHERE product_id = '1119' ORDER BY sortorder ASC
149 0.0013 0.001338005065918
SELECT * FROM product_image_select WHERE product_id = '1119'
150 0.0009 0.00089907646179199
SELECT * FROM productcustomimages WHERE product_id = '1119'
151 0.0018 0.0018279552459717
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1119' AND a.name = n.originalname
152 0.0010 0.0010271072387695
SELECT * FROM productoffers WHERE product_id = '1119' AND merchantid = 'A1X6FK5RDHNB96'
153 0.0007 0.0007469654083252
SELECT * FROM productoffers
                WHERE product_id = '1119' AND price > 0
                ORDER BY price ASC LIMIT 1
154 0.0007 0.00070095062255859
SELECT * FROM productoffers
                WHERE product_id = 1119
                ORDER BY price ASC LIMIT 1
155 0.0007 0.00074505805969238
SELECT value FROM productattributes
                WHERE product_id = '1119'
                AND name = 'ListPriceAmount'
156 0.0009 0.00088000297546387
SELECT value FROM productattributes WHERE product_id = '1119' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
157 0.0011 0.001107931137085
SELECT * FROM products WHERE id = '1124'
158 0.0011 0.0011200904846191
SELECT * FROM productimages WHERE product_id = '1124' ORDER BY sortorder ASC
159 0.0011 0.0011250972747803
SELECT * FROM product_image_select WHERE product_id = '1124'
160 0.0006 0.00063991546630859
SELECT * FROM productcustomimages WHERE product_id = '1124'
161 0.0024 0.0023758411407471
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1124' AND a.name = n.originalname
162 0.0010 0.00095510482788086
SELECT * FROM productoffers WHERE product_id = '1124' AND merchantid = 'A1X6FK5RDHNB96'
163 0.0007 0.00067687034606934
SELECT * FROM productoffers
                WHERE product_id = '1124' AND price > 0
                ORDER BY price ASC LIMIT 1
164 0.0006 0.00061607360839844
SELECT * FROM productoffers
                WHERE product_id = 1124
                ORDER BY price ASC LIMIT 1
165 0.0007 0.0007319450378418
SELECT value FROM productattributes
                WHERE product_id = '1124'
                AND name = 'ListPriceAmount'
166 0.0007 0.00073385238647461
SELECT value FROM productattributes WHERE product_id = '1124' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
167 0.0008 0.00079917907714844
SELECT * FROM products WHERE id = '1138'
168 0.0009 0.00087785720825195
SELECT * FROM productimages WHERE product_id = '1138' ORDER BY sortorder ASC
169 0.0012 0.0011568069458008
SELECT * FROM product_image_select WHERE product_id = '1138'
170 0.0007 0.00068998336791992
SELECT * FROM productcustomimages WHERE product_id = '1138'
171 0.0016 0.0016131401062012
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1138' AND a.name = n.originalname
172 0.0008 0.00084710121154785
SELECT * FROM productoffers WHERE product_id = '1138' AND merchantid = 'A1X6FK5RDHNB96'
173 0.0006 0.00061893463134766
SELECT * FROM productoffers
                WHERE product_id = '1138' AND price > 0
                ORDER BY price ASC LIMIT 1
174 0.0006 0.00058507919311523
SELECT * FROM productoffers
                WHERE product_id = 1138
                ORDER BY price ASC LIMIT 1
175 0.0007 0.00070095062255859
SELECT value FROM productattributes
                WHERE product_id = '1138'
                AND name = 'ListPriceAmount'
176 0.0008 0.00078010559082031
SELECT value FROM productattributes WHERE product_id = '1138' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
177 0.0007 0.00074887275695801
SELECT * FROM products WHERE id = '1143'
178 0.0008 0.00083303451538086
SELECT * FROM productimages WHERE product_id = '1143' ORDER BY sortorder ASC
179 0.0010 0.00098896026611328
SELECT * FROM product_image_select WHERE product_id = '1143'
180 0.0006 0.00059914588928223
SELECT * FROM productcustomimages WHERE product_id = '1143'
181 0.0017 0.0017111301422119
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1143' AND a.name = n.originalname
182 0.0007 0.00073790550231934
SELECT * FROM productoffers WHERE product_id = '1143' AND merchantid = 'A1X6FK5RDHNB96'
183 0.0006 0.00055480003356934
SELECT * FROM productoffers
                WHERE product_id = '1143' AND price > 0
                ORDER BY price ASC LIMIT 1
184 0.0005 0.00046992301940918
SELECT * FROM productoffers
                WHERE product_id = 1143
                ORDER BY price ASC LIMIT 1
185 0.0006 0.00063991546630859
SELECT value FROM productattributes
                WHERE product_id = '1143'
                AND name = 'ListPriceAmount'
186 0.0006 0.00062108039855957
SELECT value FROM productattributes WHERE product_id = '1143' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
187 0.0007 0.00074505805969238
SELECT * FROM products WHERE id = '1144'
188 0.0008 0.00080418586730957
SELECT * FROM productimages WHERE product_id = '1144' ORDER BY sortorder ASC
189 0.0009 0.00092101097106934
SELECT * FROM product_image_select WHERE product_id = '1144'
190 0.0005 0.00051403045654297
SELECT * FROM productcustomimages WHERE product_id = '1144'
191 0.0015 0.0015480518341064
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1144' AND a.name = n.originalname
192 0.0006 0.00063681602478027
SELECT * FROM productoffers WHERE product_id = '1144' AND merchantid = 'A1X6FK5RDHNB96'
193 0.0005 0.00049901008605957
SELECT * FROM productoffers
                WHERE product_id = '1144' AND price > 0
                ORDER BY price ASC LIMIT 1
194 0.0005 0.00047898292541504
SELECT * FROM productoffers
                WHERE product_id = 1144
                ORDER BY price ASC LIMIT 1
195 0.0005 0.00051999092102051
SELECT value FROM productattributes
                WHERE product_id = '1144'
                AND name = 'ListPriceAmount'
196 0.0006 0.0006248950958252
SELECT value FROM productattributes WHERE product_id = '1144' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
197 0.0007 0.00069117546081543
SELECT * FROM products WHERE id = '1203'
198 0.0012 0.0011811256408691
SELECT * FROM productimages WHERE product_id = '1203' ORDER BY sortorder ASC
199 0.0014 0.001384973526001
SELECT * FROM product_image_select WHERE product_id = '1203'
200 0.0007 0.00074601173400879
SELECT * FROM productcustomimages WHERE product_id = '1203'
201 0.0030 0.0030128955841064
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1203' AND a.name = n.originalname
202 0.0011 0.0010859966278076
SELECT * FROM productoffers WHERE product_id = '1203' AND merchantid = 'A1X6FK5RDHNB96'
203 0.0007 0.00072407722473145
SELECT * FROM productoffers
                WHERE product_id = '1203' AND price > 0
                ORDER BY price ASC LIMIT 1
204 0.0007 0.00066399574279785
SELECT * FROM productoffers
                WHERE product_id = 1203
                ORDER BY price ASC LIMIT 1
205 0.0009 0.00088906288146973
SELECT value FROM productattributes
                WHERE product_id = '1203'
                AND name = 'ListPriceAmount'
206 0.0009 0.00086188316345215
SELECT value FROM productattributes WHERE product_id = '1203' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
207 0.0012 0.0012121200561523
SELECT * FROM products WHERE id = '1213'
208 0.0011 0.0010659694671631
SELECT * FROM productimages WHERE product_id = '1213' ORDER BY sortorder ASC
209 0.0014 0.0013511180877686
SELECT * FROM product_image_select WHERE product_id = '1213'
210 0.0009 0.00088405609130859
SELECT * FROM productcustomimages WHERE product_id = '1213'
211 0.0026 0.0026009082794189
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1213' AND a.name = n.originalname
212 0.0009 0.00092697143554688
SELECT * FROM productoffers WHERE product_id = '1213' AND merchantid = 'A1X6FK5RDHNB96'
213 0.0007 0.00070691108703613
SELECT * FROM productoffers
                WHERE product_id = '1213' AND price > 0
                ORDER BY price ASC LIMIT 1
214 0.0006 0.00060296058654785
SELECT * FROM productoffers
                WHERE product_id = 1213
                ORDER BY price ASC LIMIT 1
215 0.0006 0.00064992904663086
SELECT value FROM productattributes
                WHERE product_id = '1213'
                AND name = 'ListPriceAmount'
216 0.0008 0.00084304809570312
SELECT value FROM productattributes WHERE product_id = '1213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
217 0.0009 0.0009150505065918
SELECT * FROM products WHERE id = '1218'
218 0.0010 0.0010161399841309
SELECT * FROM productimages WHERE product_id = '1218' ORDER BY sortorder ASC
219 0.0012 0.0011930465698242
SELECT * FROM product_image_select WHERE product_id = '1218'
220 0.0006 0.00062704086303711
SELECT * FROM productcustomimages WHERE product_id = '1218'
221 0.0018 0.0018398761749268
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1218' AND a.name = n.originalname
222 0.0008 0.00076508522033691
SELECT * FROM productoffers WHERE product_id = '1218' AND merchantid = 'A1X6FK5RDHNB96'
223 0.0006 0.00062298774719238
SELECT * FROM productoffers
                WHERE product_id = '1218' AND price > 0
                ORDER BY price ASC LIMIT 1
224 0.0008 0.00084114074707031
SELECT value FROM productattributes WHERE product_id = '1218' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
225 0.0010 0.00095605850219727
SELECT * FROM products WHERE id = '1219'
226 0.0009 0.00093221664428711
SELECT * FROM productimages WHERE product_id = '1219' ORDER BY sortorder ASC
227 0.0011 0.0010800361633301
SELECT * FROM product_image_select WHERE product_id = '1219'
228 0.0007 0.00065398216247559
SELECT * FROM productcustomimages WHERE product_id = '1219'
229 0.0019 0.0018720626831055
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1219' AND a.name = n.originalname
230 0.0008 0.00081300735473633
SELECT * FROM productoffers WHERE product_id = '1219' AND merchantid = 'A1X6FK5RDHNB96'
231 0.0007 0.00069618225097656
SELECT * FROM productoffers
                WHERE product_id = '1219' AND price > 0
                ORDER BY price ASC LIMIT 1
232 0.0005 0.00047588348388672
SELECT * FROM productoffers
                WHERE product_id = 1219
                ORDER BY price ASC LIMIT 1
233 0.0006 0.00059390068054199
SELECT value FROM productattributes
                WHERE product_id = '1219'
                AND name = 'ListPriceAmount'
234 0.0006 0.00060200691223145
SELECT value FROM productattributes WHERE product_id = '1219' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
235 0.0008 0.0008389949798584
SELECT * FROM products WHERE id = '1220'
236 0.0007 0.00068807601928711
SELECT * FROM productimages WHERE product_id = '1220' ORDER BY sortorder ASC
237 0.0010 0.00096893310546875
SELECT * FROM product_image_select WHERE product_id = '1220'
238 0.0007 0.0007169246673584
SELECT * FROM productcustomimages WHERE product_id = '1220'
239 0.0013 0.0013439655303955
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1220' AND a.name = n.originalname
240 0.0007 0.0007319450378418
SELECT * FROM productoffers WHERE product_id = '1220' AND merchantid = 'A1X6FK5RDHNB96'
241 0.0006 0.00063180923461914
SELECT * FROM productoffers
                WHERE product_id = '1220' AND price > 0
                ORDER BY price ASC LIMIT 1
242 0.0005 0.00051093101501465
SELECT * FROM productoffers
                WHERE product_id = 1220
                ORDER BY price ASC LIMIT 1
243 0.0006 0.00055408477783203
SELECT value FROM productattributes
                WHERE product_id = '1220'
                AND name = 'ListPriceAmount'
244 0.0006 0.00055694580078125
SELECT value FROM productattributes WHERE product_id = '1220' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
245 0.0007 0.0006871223449707
SELECT * FROM products WHERE id = '1231'
246 0.0007 0.00070095062255859
SELECT * FROM productimages WHERE product_id = '1231' ORDER BY sortorder ASC
247 0.0008 0.00083112716674805
SELECT * FROM product_image_select WHERE product_id = '1231'
248 0.0006 0.00063705444335938
SELECT * FROM productcustomimages WHERE product_id = '1231'
249 0.0018 0.0017979145050049
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1231' AND a.name = n.originalname
250 0.0007 0.00074505805969238
SELECT * FROM productoffers WHERE product_id = '1231' AND merchantid = 'A1X6FK5RDHNB96'
251 0.0005 0.0004889965057373
SELECT * FROM productoffers
                WHERE product_id = '1231' AND price > 0
                ORDER BY price ASC LIMIT 1
252 0.0004 0.0004119873046875
SELECT * FROM productoffers
                WHERE product_id = 1231
                ORDER BY price ASC LIMIT 1
253 0.0006 0.00055503845214844
SELECT value FROM productattributes
                WHERE product_id = '1231'
                AND name = 'ListPriceAmount'
254 0.0007 0.00072693824768066
SELECT value FROM productattributes WHERE product_id = '1231' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
255 0.0035 0.00347900390625
SELECT * FROM products WHERE id = '1234'
256 0.0007 0.00073909759521484
SELECT * FROM productimages WHERE product_id = '1234' ORDER BY sortorder ASC
257 0.0009 0.0009310245513916
SELECT * FROM product_image_select WHERE product_id = '1234'
258 0.0012 0.0012102127075195
SELECT * FROM productcustomimages WHERE product_id = '1234'
259 0.0064 0.0064349174499512
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1234' AND a.name = n.originalname
260 0.0011 0.0011332035064697
SELECT * FROM productoffers WHERE product_id = '1234' AND merchantid = 'A1X6FK5RDHNB96'
261 0.0009 0.0008699893951416
SELECT * FROM productoffers
                WHERE product_id = '1234' AND price > 0
                ORDER BY price ASC LIMIT 1
262 0.0007 0.00073480606079102
SELECT * FROM productoffers
                WHERE product_id = 1234
                ORDER BY price ASC LIMIT 1
263 0.0009 0.0009160041809082
SELECT value FROM productattributes
                WHERE product_id = '1234'
                AND name = 'ListPriceAmount'
264 0.0010 0.0010209083557129
SELECT value FROM productattributes WHERE product_id = '1234' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
265 0.0015 0.0014550685882568
SELECT * FROM products WHERE id = '1259'
266 0.0012 0.0012080669403076
SELECT * FROM productimages WHERE product_id = '1259' ORDER BY sortorder ASC
267 0.0016 0.0015850067138672
SELECT * FROM product_image_select WHERE product_id = '1259'
268 0.0007 0.00071382522583008
SELECT * FROM productcustomimages WHERE product_id = '1259'
269 0.0018 0.0018279552459717
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1259' AND a.name = n.originalname
270 0.0009 0.00094699859619141
SELECT * FROM productoffers WHERE product_id = '1259' AND merchantid = 'A1X6FK5RDHNB96'
271 0.0007 0.00069594383239746
SELECT * FROM productoffers
                WHERE product_id = '1259' AND price > 0
                ORDER BY price ASC LIMIT 1
272 0.0006 0.00055599212646484
SELECT * FROM productoffers
                WHERE product_id = 1259
                ORDER BY price ASC LIMIT 1
273 0.0008 0.00082492828369141
SELECT value FROM productattributes
                WHERE product_id = '1259'
                AND name = 'ListPriceAmount'
274 0.0008 0.00077986717224121
SELECT value FROM productattributes WHERE product_id = '1259' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
275 0.0010 0.0010139942169189
SELECT * FROM products WHERE id = '1272'
276 0.0008 0.00083684921264648
SELECT * FROM productimages WHERE product_id = '1272' ORDER BY sortorder ASC
277 0.0010 0.0010209083557129
SELECT * FROM product_image_select WHERE product_id = '1272'
278 0.0006 0.00059986114501953
SELECT * FROM productcustomimages WHERE product_id = '1272'
279 0.0017 0.0016539096832275
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1272' AND a.name = n.originalname
280 0.0010 0.0010430812835693
SELECT * FROM productoffers WHERE product_id = '1272' AND merchantid = 'A1X6FK5RDHNB96'
281 0.0006 0.00059819221496582
SELECT * FROM productoffers
                WHERE product_id = '1272' AND price > 0
                ORDER BY price ASC LIMIT 1
282 0.0005 0.00049901008605957
SELECT * FROM productoffers
                WHERE product_id = 1272
                ORDER BY price ASC LIMIT 1
283 0.0008 0.00082802772521973
SELECT value FROM productattributes
                WHERE product_id = '1272'
                AND name = 'ListPriceAmount'
284 0.0007 0.00072789192199707
SELECT value FROM productattributes WHERE product_id = '1272' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
285 0.0006 0.00062799453735352
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1066' ORDER BY timestamp DESC
286 0.0004 0.0004420280456543
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1072' ORDER BY timestamp DESC
287 0.0005 0.00047087669372559
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1081' ORDER BY timestamp DESC
288 0.0009 0.00085997581481934
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1112' ORDER BY timestamp DESC
289 0.0006 0.00055789947509766
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1119' ORDER BY timestamp DESC
290 0.0031 0.0031440258026123
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1124' ORDER BY timestamp DESC
291 0.0007 0.0006871223449707
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1138' ORDER BY timestamp DESC
292 0.0006 0.00055694580078125
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1143' ORDER BY timestamp DESC
293 0.0032 0.00319504737854
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1144' ORDER BY timestamp DESC
294 0.0007 0.0006718635559082
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1203' ORDER BY timestamp DESC
295 0.0010 0.0010311603546143
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1213' ORDER BY timestamp DESC
296 0.0006 0.00060200691223145
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1218' ORDER BY timestamp DESC
297 0.0006 0.00058794021606445
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1219' ORDER BY timestamp DESC
298 0.0007 0.00065302848815918
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1220' ORDER BY timestamp DESC
299 0.0005 0.00049304962158203
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1231' ORDER BY timestamp DESC
300 0.0005 0.00046610832214355
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1234' ORDER BY timestamp DESC
301 0.0005 0.00048589706420898
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1259' ORDER BY timestamp DESC
302 0.0004 0.00044107437133789
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1272' ORDER BY timestamp DESC
303 0.0008 0.00077295303344727
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
304 0.0008 0.00077009201049805
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
305 0.0005 0.00045895576477051
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
306 0.0204 0.020359039306641
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
307 0.0008 0.00075912475585938
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
308 0.0006 0.00056219100952148
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
309 0.0005 0.00054001808166504
SELECT * FROM products WHERE id = 1626
310 0.0004 0.00042295455932617
SELECT * FROM products WHERE id = 4041
311 0.0007 0.00066399574279785
SELECT * FROM products WHERE id = 4312
312 0.0006 0.00059008598327637
SELECT * FROM products WHERE id = 777
313 0.0005 0.00049519538879395
SELECT * FROM products WHERE id = 3881
314 0.0006 0.00063705444335938
SELECT * FROM products WHERE id = 4213
315 0.0008 0.00076103210449219
SELECT * FROM products WHERE id = '1626'
316 0.0010 0.00097799301147461
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
317 0.0011 0.0011091232299805
SELECT * FROM product_image_select WHERE product_id = '1626'
318 0.0006 0.0006101131439209
SELECT * FROM productcustomimages WHERE product_id = '1626'
319 0.0017 0.0016579627990723
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
320 0.0011 0.0010578632354736
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
321 0.0007 0.00066089630126953
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
322 0.0011 0.0011029243469238
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
323 0.0010 0.0010490417480469
SELECT * FROM products WHERE id = '4041'
324 0.0011 0.0010919570922852
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
325 0.0019 0.0018880367279053
SELECT * FROM product_image_select WHERE product_id = '4041'
326 0.0008 0.00082278251647949
SELECT * FROM productcustomimages WHERE product_id = '4041'
327 0.0040 0.0040440559387207
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
328 0.0150 0.014955043792725
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
329 0.0014 0.0013749599456787
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
330 0.0019 0.0019240379333496
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
331 0.0020 0.0019729137420654
SELECT * FROM products WHERE id = '4312'
332 0.0018 0.0017879009246826
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
333 0.0027 0.0027129650115967
SELECT * FROM product_image_select WHERE product_id = '4312'
334 0.0016 0.0016191005706787
SELECT * FROM productcustomimages WHERE product_id = '4312'
335 0.0039 0.0038819313049316
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
336 0.0026 0.0026118755340576
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
337 0.0009 0.00091195106506348
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
338 0.0009 0.00087308883666992
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
339 0.0010 0.00099396705627441
SELECT * FROM products WHERE id = '777'
340 0.0010 0.0010418891906738
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
341 0.0015 0.0014951229095459
SELECT * FROM product_image_select WHERE product_id = '777'
342 0.0007 0.00068902969360352
SELECT * FROM productcustomimages WHERE product_id = '777'
343 0.0035 0.0034699440002441
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
344 0.0011 0.0010550022125244
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
345 0.0007 0.0006711483001709
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
346 0.0008 0.000762939453125
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
347 0.0009 0.00088810920715332
SELECT * FROM products WHERE id = '3881'
348 0.0011 0.0010988712310791
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
349 0.0011 0.0010740756988525
SELECT * FROM product_image_select WHERE product_id = '3881'
350 0.0006 0.0006101131439209
SELECT * FROM productcustomimages WHERE product_id = '3881'
351 0.0021 0.0020811557769775
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
352 0.0007 0.00073790550231934
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
353 0.0006 0.00059294700622559
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
354 0.0007 0.00073599815368652
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
355 0.0009 0.00093698501586914
SELECT * FROM products WHERE id = '4213'
356 0.0009 0.00089287757873535
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
357 0.0014 0.0013711452484131
SELECT * FROM product_image_select WHERE product_id = '4213'
358 0.0007 0.00074100494384766
SELECT * FROM productcustomimages WHERE product_id = '4213'
359 0.0023 0.0023298263549805
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
360 0.0011 0.0010569095611572
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
361 0.0007 0.00065302848815918
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
362 0.0007 0.00072717666625977
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
363 0.0012 0.0011739730834961
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
364 0.0011 0.0010890960693359
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
365 0.0018 0.0018408298492432
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
366 0.0009 0.00085806846618652
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
367 0.0006 0.00064396858215332
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
368 0.0008 0.0007929801940918
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
369 0.0008 0.00078415870666504
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'