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.5400807857513 367 1.1320 0


No Amazon API Requests Made.


App Debug - Total Time 1.5400807857513 seconds

Number Time From Start Name Description
1 0.35940980911255 Initialise Initialise FSB Function
2 0.36242294311523 App Controller Start Start of the App controller (called before the controller of every page)
3 0.40591192245483 Start of getCategoryListByGroup Function Before first category groups query
4 0.40678882598877 After initial query Before first category groups query
5 0.40678977966309 Get Category List for Group Before the call to getCategoryList function
6 0.4067919254303 Start of GetCategoryList function Start of the function
7 0.40679287910461 Before getting categories Query to get specific category list
8 0.40760087966919 After getting categories Query to get specific category list
9 0.40760087966919 Before getting category custom Before call to function getCategoryCustom
10 0.42337584495544 After getting category custom After call to function getCategoryCustom
11 0.42337799072266 Before getting category custom Before call to function getCategoryCustom
12 0.43170380592346 After getting category custom After call to function getCategoryCustom
13 0.43170595169067 Before getting category custom Before call to function getCategoryCustom
14 0.43628191947937 After getting category custom After call to function getCategoryCustom
15 0.43628287315369 Before getting category custom Before call to function getCategoryCustom
16 0.43922877311707 After getting category custom After call to function getCategoryCustom
17 0.43922996520996 Before getting category custom Before call to function getCategoryCustom
18 0.44242191314697 After getting category custom After call to function getCategoryCustom
19 0.44242286682129 Before getting category custom Before call to function getCategoryCustom
20 0.44555687904358 After getting category custom After call to function getCategoryCustom
21 0.44555878639221 End of GetCategoryList function End of the function
22 0.44556593894958 Get Category List for Group Before the call to getCategoryList function
23 0.4455668926239 Start of GetCategoryList function Start of the function
24 0.44556879997253 Before getting categories Query to get specific category list
25 0.44590783119202 End of getCategoryListByGroup Function Before return()
26 1.250373840332 App Controller End End of the App controller (called before the controller of every page)
27 1.4443979263306 App_after Controller Start Start of the App_after controller (called after the controller of every page)
28 1.4454438686371 Before Get Options Before the call to getOptions in the tpl class
29 1.4848518371582 After Get Options After the call to getOptions in the tpl class
30 1.4848849773407 App_after Controller End End of the App_after controller (called after the controller of every page)
31 1.5400729179382 Finalizing debug Before the debug is output to the page.
32 1.540079832077 End of App This is the end of the app logging, final timestamp


Query Debug - 367 Database Queries. Total time 1.1320 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0015 0.0015139579772949
SELECT parameter, value FROM parameters
2 0.0053 0.0052928924560547
SELECT * FROM `bad_bots`
3 0.0003 0.00030994415283203
SET time_zone = 'Europe/London'
4 0.0014 0.0014300346374512
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0015 0.001471996307373
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"216.73.216.249\";}'
6 0.0013 0.0013358592987061
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1751315858'
7 0.0018 0.0017769336700439
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0005 0.00047397613525391
UPDATE autorun SET lastrun = '2025-06-30 20:37:38' WHERE id = '13'
9 0.0005 0.00053310394287109
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0015 0.0014791488647461
SELECT id FROM pages WHERE pagename = 'search' LIMIT 1
11 0.0004 0.00038981437683105
SELECT * FROM pages WHERE id = 52
12 0.0032 0.0031571388244629
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13 0.0395 0.03950309753418
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14 0.0004 0.00043010711669922
SELECT * FROM pages WHERE pagename = 'search'
15 0.0009 0.00087189674377441
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0008 0.00079607963562012
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0059 0.0059030055999756
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.0010 0.0010039806365967
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.0007 0.00072002410888672
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20 0.0003 0.00032901763916016
SELECT id FROM categories WHERE parent_id = '26'
21 0.0049 0.0049209594726562
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.0009 0.0009160041809082
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.0009 0.00085902214050293
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.0008 0.00076699256896973
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25 0.0003 0.00029897689819336
SELECT * FROM categorygroups WHERE id = '1'
26 0.0030 0.0029840469360352
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.0003 0.00032687187194824
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.0003 0.00027084350585938
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29 0.0003 0.00032997131347656
SELECT id FROM categories WHERE parent_id = '27'
30 0.0031 0.0030500888824463
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.0004 0.0003509521484375
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.0003 0.00034213066101074
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.0003 0.00034713745117188
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34 0.0003 0.00029516220092773
SELECT * FROM categorygroups WHERE id = '1'
35 0.0011 0.0011489391326904
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.0003 0.00029993057250977
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.0003 0.00031018257141113
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38 0.0003 0.00030994415283203
SELECT id FROM categories WHERE parent_id = '28'
39 0.0011 0.0011470317840576
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.0004 0.00036191940307617
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.0004 0.00038504600524902
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.0003 0.00030994415283203
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43 0.0003 0.00027894973754883
SELECT * FROM categorygroups WHERE id = '1'
44 0.0004 0.00038003921508789
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.0003 0.00030207633972168
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.0003 0.00026297569274902
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47 0.0003 0.00028300285339355
SELECT id FROM categories WHERE parent_id = '29'
48 0.0004 0.00043487548828125
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.0003 0.00031518936157227
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.0003 0.00032806396484375
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
51 0.0003 0.00030708312988281
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52 0.0003 0.00030612945556641
SELECT * FROM categorygroups WHERE id = '1'
53 0.0004 0.00042200088500977
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.00037193298339844
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.0003 0.00027894973754883
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56 0.0003 0.00028204917907715
SELECT id FROM categories WHERE parent_id = '30'
57 0.0005 0.00047397613525391
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.0003 0.00033688545227051
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.0003 0.00033998489379883
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.0003 0.00033712387084961
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61 0.0003 0.0002751350402832
SELECT * FROM categorygroups WHERE id = '1'
62 0.0004 0.00043296813964844
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.0003 0.00032591819763184
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.0003 0.00027585029602051
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65 0.0003 0.00028705596923828
SELECT id FROM categories WHERE parent_id = '31'
66 0.0005 0.00048208236694336
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.0003 0.00033187866210938
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.0003 0.00034403800964355
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.0003 0.00031590461730957
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70 0.0003 0.00028085708618164
SELECT * FROM categorygroups WHERE id = '1'
71 0.0003 0.00033092498779297
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
72 0.0020 0.001986026763916
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73 0.0009 0.00089502334594727
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74 0.0004 0.00040197372436523
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.0007 0.00072979927062988
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76 0.0009 0.00091695785522461
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77 0.0006 0.00059103965759277
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78 0.7950 0.79498696327209
SELECT * FROM ipgeocountries WHERE INET_ATON('216.73.216.249') >= INET_ATON(ip_start) AND INET_ATON('216.73.216.249') <= INET_ATON(ip_end)
79 0.0015 0.0015120506286621
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80 0.0007 0.00070405006408691
SELECT * FROM countryredirects WHERE countrycode = 'US'
81 0.0005 0.00051999092102051
SELECT * FROM pages WHERE pagename = 'search'
82 0.0091 0.009058952331543
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
83 0.0025 0.0025110244750977
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
84 0.0020 0.0020251274108887
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
85 0.0087 0.0087301731109619
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
86 0.0025 0.0025060176849365
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
87 0.0007 0.00069212913513184
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
88 0.0026 0.0025858879089355
INSERT INTO searches (`keywords`, `timestamp`, `ip`) SELECT '4', NOW(), '216.73.216.249'
89 0.0012 0.0012140274047852
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.0005 0.00051689147949219
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.0059 0.0058560371398926
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.0006 0.00055503845214844
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.0005340576171875
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.0007 0.00066399574279785
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.0074 0.0074219703674316
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.00035619735717773
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.0002 0.000244140625
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.0005 0.00051188468933105
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.0004880428314209
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.0064 0.0063900947570801
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.00028419494628906
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.0002 0.00024914741516113
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.0005 0.00049901008605957
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.0073 0.0072929859161377
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.0003 0.00025510787963867
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.0002 0.00023412704467773
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.00063300132751465
SELECT * FROM products WHERE id = '1435'
108 0.0023 0.0023248195648193
SELECT * FROM productimages WHERE product_id = '1435' ORDER BY sortorder ASC
109 0.0017 0.0016958713531494
SELECT * FROM product_image_select WHERE product_id = '1435'
110 0.0013 0.0012660026550293
SELECT * FROM productcustomimages WHERE product_id = '1435'
111 0.0023 0.0022709369659424
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1435' AND a.name = n.originalname
112 0.0021 0.0020670890808105
SELECT * FROM productoffers WHERE product_id = '1435' AND merchantid = 'A1X6FK5RDHNB96'
113 0.0003 0.00030994415283203
SELECT * FROM productoffers
                WHERE product_id = '1435' AND price > 0
                ORDER BY price ASC LIMIT 1
114 0.0006 0.00059390068054199
SELECT value FROM productattributes WHERE product_id = '1435' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
115 0.0005 0.00049400329589844
SELECT * FROM products WHERE id = '1437'
116 0.0006 0.00057387351989746
SELECT * FROM productimages WHERE product_id = '1437' ORDER BY sortorder ASC
117 0.0008 0.00082302093505859
SELECT * FROM product_image_select WHERE product_id = '1437'
118 0.0004 0.00042915344238281
SELECT * FROM productcustomimages WHERE product_id = '1437'
119 0.0013 0.0013048648834229
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1437' AND a.name = n.originalname
120 0.0005 0.00046801567077637
SELECT * FROM productoffers WHERE product_id = '1437' AND merchantid = 'A1X6FK5RDHNB96'
121 0.0003 0.00034093856811523
SELECT * FROM productoffers
                WHERE product_id = '1437' AND price > 0
                ORDER BY price ASC LIMIT 1
122 0.0003 0.00027084350585938
SELECT * FROM productoffers
                WHERE product_id = 1437
                ORDER BY price ASC LIMIT 1
123 0.0003 0.00027704238891602
SELECT value FROM productattributes
                WHERE product_id = '1437'
                AND name = 'ListPriceAmount'
124 0.0005 0.00050091743469238
SELECT value FROM productattributes WHERE product_id = '1437' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
125 0.0006 0.00057697296142578
SELECT * FROM products WHERE id = '1438'
126 0.0006 0.00055289268493652
SELECT * FROM productimages WHERE product_id = '1438' ORDER BY sortorder ASC
127 0.0007 0.00074195861816406
SELECT * FROM product_image_select WHERE product_id = '1438'
128 0.0004 0.00036406517028809
SELECT * FROM productcustomimages WHERE product_id = '1438'
129 0.0019 0.0019040107727051
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1438' AND a.name = n.originalname
130 0.0007 0.00074195861816406
SELECT * FROM productoffers WHERE product_id = '1438' AND merchantid = 'A1X6FK5RDHNB96'
131 0.0003 0.00030994415283203
SELECT * FROM productoffers
                WHERE product_id = '1438' AND price > 0
                ORDER BY price ASC LIMIT 1
132 0.0003 0.00034904479980469
SELECT * FROM productoffers
                WHERE product_id = 1438
                ORDER BY price ASC LIMIT 1
133 0.0003 0.00033807754516602
SELECT value FROM productattributes
                WHERE product_id = '1438'
                AND name = 'ListPriceAmount'
134 0.0003 0.00030899047851562
SELECT value FROM productattributes WHERE product_id = '1438' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
135 0.0004 0.00038504600524902
SELECT * FROM products WHERE id = '1441'
136 0.0005 0.00054001808166504
SELECT * FROM productimages WHERE product_id = '1441' ORDER BY sortorder ASC
137 0.0007 0.00065803527832031
SELECT * FROM product_image_select WHERE product_id = '1441'
138 0.0003 0.00033187866210938
SELECT * FROM productcustomimages WHERE product_id = '1441'
139 0.0011 0.0011241436004639
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1441' AND a.name = n.originalname
140 0.0003 0.00033092498779297
SELECT * FROM productoffers WHERE product_id = '1441' AND merchantid = 'A1X6FK5RDHNB96'
141 0.0002 0.00024986267089844
SELECT * FROM productoffers
                WHERE product_id = '1441' AND price > 0
                ORDER BY price ASC LIMIT 1
142 0.0002 0.00024795532226562
SELECT * FROM productoffers
                WHERE product_id = 1441
                ORDER BY price ASC LIMIT 1
143 0.0003 0.00031900405883789
SELECT value FROM productattributes
                WHERE product_id = '1441'
                AND name = 'ListPriceAmount'
144 0.0003 0.00034403800964355
SELECT value FROM productattributes WHERE product_id = '1441' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
145 0.0005 0.00049304962158203
SELECT * FROM products WHERE id = '1442'
146 0.0006 0.00062704086303711
SELECT * FROM productimages WHERE product_id = '1442' ORDER BY sortorder ASC
147 0.0008 0.00081896781921387
SELECT * FROM product_image_select WHERE product_id = '1442'
148 0.0004 0.00040411949157715
SELECT * FROM productcustomimages WHERE product_id = '1442'
149 0.0012 0.0012390613555908
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1442' AND a.name = n.originalname
150 0.0005 0.00054192543029785
SELECT * FROM productoffers WHERE product_id = '1442' AND merchantid = 'A1X6FK5RDHNB96'
151 0.0003 0.00034618377685547
SELECT * FROM productoffers
                WHERE product_id = '1442' AND price > 0
                ORDER BY price ASC LIMIT 1
152 0.0003 0.00027799606323242
SELECT * FROM productoffers
                WHERE product_id = 1442
                ORDER BY price ASC LIMIT 1
153 0.0003 0.00027298927307129
SELECT value FROM productattributes
                WHERE product_id = '1442'
                AND name = 'ListPriceAmount'
154 0.0003 0.00028085708618164
SELECT value FROM productattributes WHERE product_id = '1442' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
155 0.0005 0.00049114227294922
SELECT * FROM products WHERE id = '1443'
156 0.0005 0.00054383277893066
SELECT * FROM productimages WHERE product_id = '1443' ORDER BY sortorder ASC
157 0.0007 0.00073790550231934
SELECT * FROM product_image_select WHERE product_id = '1443'
158 0.0019 0.001884937286377
SELECT * FROM productcustomimages WHERE product_id = '1443'
159 0.0019 0.0019428730010986
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1443' AND a.name = n.originalname
160 0.0007 0.00067591667175293
SELECT * FROM productoffers WHERE product_id = '1443' AND merchantid = 'A1X6FK5RDHNB96'
161 0.0005 0.00048422813415527
SELECT * FROM productoffers
                WHERE product_id = '1443' AND price > 0
                ORDER BY price ASC LIMIT 1
162 0.0006 0.00064802169799805
SELECT value FROM productattributes WHERE product_id = '1443' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
163 0.0006 0.00061416625976562
SELECT * FROM products WHERE id = '1448'
164 0.0006 0.00063300132751465
SELECT * FROM productimages WHERE product_id = '1448' ORDER BY sortorder ASC
165 0.0010 0.00098705291748047
SELECT * FROM product_image_select WHERE product_id = '1448'
166 0.0005 0.0004580020904541
SELECT * FROM productcustomimages WHERE product_id = '1448'
167 0.0025 0.0024788379669189
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1448' AND a.name = n.originalname
168 0.0006 0.00064301490783691
SELECT * FROM productoffers WHERE product_id = '1448' AND merchantid = 'A1X6FK5RDHNB96'
169 0.0005 0.00054097175598145
SELECT * FROM productoffers
                WHERE product_id = '1448' AND price > 0
                ORDER BY price ASC LIMIT 1
170 0.0005 0.00048494338989258
SELECT * FROM productoffers
                WHERE product_id = 1448
                ORDER BY price ASC LIMIT 1
171 0.0005 0.00049805641174316
SELECT value FROM productattributes
                WHERE product_id = '1448'
                AND name = 'ListPriceAmount'
172 0.0006 0.00058102607727051
SELECT value FROM productattributes WHERE product_id = '1448' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
173 0.0008 0.00075101852416992
SELECT * FROM products WHERE id = '1460'
174 0.0010 0.0010280609130859
SELECT * FROM productimages WHERE product_id = '1460' ORDER BY sortorder ASC
175 0.0022 0.0021917819976807
SELECT * FROM product_image_select WHERE product_id = '1460'
176 0.0005 0.00050592422485352
SELECT * FROM productcustomimages WHERE product_id = '1460'
177 0.0022 0.0021629333496094
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1460' AND a.name = n.originalname
178 0.0006 0.00057387351989746
SELECT * FROM productoffers WHERE product_id = '1460' AND merchantid = 'A1X6FK5RDHNB96'
179 0.0005 0.00049614906311035
SELECT * FROM productoffers
                WHERE product_id = '1460' AND price > 0
                ORDER BY price ASC LIMIT 1
180 0.0004 0.00039410591125488
SELECT * FROM productoffers
                WHERE product_id = 1460
                ORDER BY price ASC LIMIT 1
181 0.0005 0.0004889965057373
SELECT value FROM productattributes
                WHERE product_id = '1460'
                AND name = 'ListPriceAmount'
182 0.0005 0.00046801567077637
SELECT value FROM productattributes WHERE product_id = '1460' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
183 0.0010 0.00095200538635254
SELECT * FROM products WHERE id = '1461'
184 0.0011 0.0010809898376465
SELECT * FROM productimages WHERE product_id = '1461' ORDER BY sortorder ASC
185 0.0013 0.0012660026550293
SELECT * FROM product_image_select WHERE product_id = '1461'
186 0.0007 0.0007319450378418
SELECT * FROM productcustomimages WHERE product_id = '1461'
187 0.0015 0.0015292167663574
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1461' AND a.name = n.originalname
188 0.0006 0.00059604644775391
SELECT * FROM productoffers WHERE product_id = '1461' AND merchantid = 'A1X6FK5RDHNB96'
189 0.0004 0.00044107437133789
SELECT * FROM productoffers
                WHERE product_id = '1461' AND price > 0
                ORDER BY price ASC LIMIT 1
190 0.0004 0.00036215782165527
SELECT * FROM productoffers
                WHERE product_id = 1461
                ORDER BY price ASC LIMIT 1
191 0.0005 0.00047588348388672
SELECT value FROM productattributes
                WHERE product_id = '1461'
                AND name = 'ListPriceAmount'
192 0.0005 0.00046706199645996
SELECT value FROM productattributes WHERE product_id = '1461' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
193 0.0006 0.00060200691223145
SELECT * FROM products WHERE id = '1466'
194 0.0007 0.00074005126953125
SELECT * FROM productimages WHERE product_id = '1466' ORDER BY sortorder ASC
195 0.0010 0.0009758472442627
SELECT * FROM product_image_select WHERE product_id = '1466'
196 0.0005 0.00048184394836426
SELECT * FROM productcustomimages WHERE product_id = '1466'
197 0.0016 0.0015971660614014
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1466' AND a.name = n.originalname
198 0.0006 0.00057387351989746
SELECT * FROM productoffers WHERE product_id = '1466' AND merchantid = 'A1X6FK5RDHNB96'
199 0.0004 0.0003969669342041
SELECT * FROM productoffers
                WHERE product_id = '1466' AND price > 0
                ORDER BY price ASC LIMIT 1
200 0.0004 0.00036001205444336
SELECT * FROM productoffers
                WHERE product_id = 1466
                ORDER BY price ASC LIMIT 1
201 0.0004 0.00042891502380371
SELECT value FROM productattributes
                WHERE product_id = '1466'
                AND name = 'ListPriceAmount'
202 0.0005 0.00046086311340332
SELECT value FROM productattributes WHERE product_id = '1466' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
203 0.0006 0.00056290626525879
SELECT * FROM products WHERE id = '1476'
204 0.0007 0.00070095062255859
SELECT * FROM productimages WHERE product_id = '1476' ORDER BY sortorder ASC
205 0.0010 0.00095915794372559
SELECT * FROM product_image_select WHERE product_id = '1476'
206 0.0004 0.00044989585876465
SELECT * FROM productcustomimages WHERE product_id = '1476'
207 0.0015 0.0014970302581787
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1476' AND a.name = n.originalname
208 0.0006 0.00059103965759277
SELECT * FROM productoffers WHERE product_id = '1476' AND merchantid = 'A1X6FK5RDHNB96'
209 0.0004 0.00039792060852051
SELECT * FROM productoffers
                WHERE product_id = '1476' AND price > 0
                ORDER BY price ASC LIMIT 1
210 0.0004 0.00042009353637695
SELECT * FROM productoffers
                WHERE product_id = 1476
                ORDER BY price ASC LIMIT 1
211 0.0004 0.00043010711669922
SELECT value FROM productattributes
                WHERE product_id = '1476'
                AND name = 'ListPriceAmount'
212 0.0005 0.00048995018005371
SELECT value FROM productattributes WHERE product_id = '1476' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
213 0.0006 0.00056886672973633
SELECT * FROM products WHERE id = '1473'
214 0.0006 0.00058889389038086
SELECT * FROM productimages WHERE product_id = '1473' ORDER BY sortorder ASC
215 0.0009 0.00090909004211426
SELECT * FROM product_image_select WHERE product_id = '1473'
216 0.0005 0.00053215026855469
SELECT * FROM productcustomimages WHERE product_id = '1473'
217 0.0016 0.0015652179718018
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1473' AND a.name = n.originalname
218 0.0006 0.00055289268493652
SELECT * FROM productoffers WHERE product_id = '1473' AND merchantid = 'A1X6FK5RDHNB96'
219 0.0004 0.0004420280456543
SELECT * FROM productoffers
                WHERE product_id = '1473' AND price > 0
                ORDER BY price ASC LIMIT 1
220 0.0004 0.00038790702819824
SELECT * FROM productoffers
                WHERE product_id = 1473
                ORDER BY price ASC LIMIT 1
221 0.0004 0.00040221214294434
SELECT value FROM productattributes
                WHERE product_id = '1473'
                AND name = 'ListPriceAmount'
222 0.0005 0.00054717063903809
SELECT value FROM productattributes WHERE product_id = '1473' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
223 0.0006 0.00056314468383789
SELECT * FROM products WHERE id = '1493'
224 0.0006 0.00064706802368164
SELECT * FROM productimages WHERE product_id = '1493' ORDER BY sortorder ASC
225 0.0009 0.0009000301361084
SELECT * FROM product_image_select WHERE product_id = '1493'
226 0.0005 0.00045013427734375
SELECT * FROM productcustomimages WHERE product_id = '1493'
227 0.0021 0.0021131038665771
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1493' AND a.name = n.originalname
228 0.0007 0.00065207481384277
SELECT * FROM productoffers WHERE product_id = '1493' AND merchantid = 'A1X6FK5RDHNB96'
229 0.0005 0.0005030632019043
SELECT * FROM productoffers
                WHERE product_id = '1493' AND price > 0
                ORDER BY price ASC LIMIT 1
230 0.0004 0.00038290023803711
SELECT * FROM productoffers
                WHERE product_id = 1493
                ORDER BY price ASC LIMIT 1
231 0.0005 0.00048208236694336
SELECT value FROM productattributes
                WHERE product_id = '1493'
                AND name = 'ListPriceAmount'
232 0.0006 0.0006110668182373
SELECT value FROM productattributes WHERE product_id = '1493' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
233 0.0006 0.00063490867614746
SELECT * FROM products WHERE id = '1499'
234 0.0009 0.00087499618530273
SELECT * FROM productimages WHERE product_id = '1499' ORDER BY sortorder ASC
235 0.0011 0.0010919570922852
SELECT * FROM product_image_select WHERE product_id = '1499'
236 0.0006 0.0005648136138916
SELECT * FROM productcustomimages WHERE product_id = '1499'
237 0.0017 0.0016729831695557
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1499' AND a.name = n.originalname
238 0.0005 0.00054407119750977
SELECT * FROM productoffers WHERE product_id = '1499' AND merchantid = 'A1X6FK5RDHNB96'
239 0.0004 0.00039196014404297
SELECT * FROM productoffers
                WHERE product_id = '1499' AND price > 0
                ORDER BY price ASC LIMIT 1
240 0.0004 0.00037479400634766
SELECT * FROM productoffers
                WHERE product_id = 1499
                ORDER BY price ASC LIMIT 1
241 0.0004 0.00039792060852051
SELECT value FROM productattributes
                WHERE product_id = '1499'
                AND name = 'ListPriceAmount'
242 0.0004 0.00044798851013184
SELECT value FROM productattributes WHERE product_id = '1499' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
243 0.0006 0.00057697296142578
SELECT * FROM products WHERE id = '1513'
244 0.0006 0.00063705444335938
SELECT * FROM productimages WHERE product_id = '1513' ORDER BY sortorder ASC
245 0.0009 0.0008699893951416
SELECT * FROM product_image_select WHERE product_id = '1513'
246 0.0004 0.0004420280456543
SELECT * FROM productcustomimages WHERE product_id = '1513'
247 0.0013 0.0013449192047119
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1513' AND a.name = n.originalname
248 0.0005 0.00052213668823242
SELECT * FROM productoffers WHERE product_id = '1513' AND merchantid = 'A1X6FK5RDHNB96'
249 0.0004 0.00039505958557129
SELECT * FROM productoffers
                WHERE product_id = '1513' AND price > 0
                ORDER BY price ASC LIMIT 1
250 0.0004 0.00036191940307617
SELECT * FROM productoffers
                WHERE product_id = 1513
                ORDER BY price ASC LIMIT 1
251 0.0004 0.00041103363037109
SELECT value FROM productattributes
                WHERE product_id = '1513'
                AND name = 'ListPriceAmount'
252 0.0004 0.00044798851013184
SELECT value FROM productattributes WHERE product_id = '1513' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
253 0.0006 0.00055098533630371
SELECT * FROM products WHERE id = '1572'
254 0.0007 0.00067710876464844
SELECT * FROM productimages WHERE product_id = '1572' ORDER BY sortorder ASC
255 0.0009 0.00093579292297363
SELECT * FROM product_image_select WHERE product_id = '1572'
256 0.0005 0.00046896934509277
SELECT * FROM productcustomimages WHERE product_id = '1572'
257 0.0016 0.0016160011291504
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1572' AND a.name = n.originalname
258 0.0006 0.00055599212646484
SELECT * FROM productoffers WHERE product_id = '1572' AND merchantid = 'A1X6FK5RDHNB96'
259 0.0004 0.00039482116699219
SELECT * FROM productoffers
                WHERE product_id = '1572' AND price > 0
                ORDER BY price ASC LIMIT 1
260 0.0004 0.00035285949707031
SELECT * FROM productoffers
                WHERE product_id = 1572
                ORDER BY price ASC LIMIT 1
261 0.0004 0.00042581558227539
SELECT value FROM productattributes
                WHERE product_id = '1572'
                AND name = 'ListPriceAmount'
262 0.0005 0.00049114227294922
SELECT value FROM productattributes WHERE product_id = '1572' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
263 0.0006 0.00058484077453613
SELECT * FROM products WHERE id = '1544'
264 0.0005 0.00053906440734863
SELECT * FROM productimages WHERE product_id = '1544' ORDER BY sortorder ASC
265 0.0007 0.00073003768920898
SELECT * FROM product_image_select WHERE product_id = '1544'
266 0.0004 0.0003819465637207
SELECT * FROM productcustomimages WHERE product_id = '1544'
267 0.0012 0.001194953918457
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1544' AND a.name = n.originalname
268 0.0005 0.0004889965057373
SELECT * FROM productoffers WHERE product_id = '1544' AND merchantid = 'A1X6FK5RDHNB96'
269 0.0003 0.00034999847412109
SELECT * FROM productoffers
                WHERE product_id = '1544' AND price > 0
                ORDER BY price ASC LIMIT 1
270 0.0003 0.00032210350036621
SELECT * FROM productoffers
                WHERE product_id = 1544
                ORDER BY price ASC LIMIT 1
271 0.0003 0.00034308433532715
SELECT value FROM productattributes
                WHERE product_id = '1544'
                AND name = 'ListPriceAmount'
272 0.0004 0.00037908554077148
SELECT value FROM productattributes WHERE product_id = '1544' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
273 0.0005 0.00050997734069824
SELECT * FROM products WHERE id = '1547'
274 0.0006 0.0006110668182373
SELECT * FROM productimages WHERE product_id = '1547' ORDER BY sortorder ASC
275 0.0008 0.00080084800720215
SELECT * FROM product_image_select WHERE product_id = '1547'
276 0.0004 0.00037598609924316
SELECT * FROM productcustomimages WHERE product_id = '1547'
277 0.0013 0.0013079643249512
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1547' AND a.name = n.originalname
278 0.0005 0.00046706199645996
SELECT * FROM productoffers WHERE product_id = '1547' AND merchantid = 'A1X6FK5RDHNB96'
279 0.0004 0.00038695335388184
SELECT * FROM productoffers
                WHERE product_id = '1547' AND price > 0
                ORDER BY price ASC LIMIT 1
280 0.0003 0.00032687187194824
SELECT * FROM productoffers
                WHERE product_id = 1547
                ORDER BY price ASC LIMIT 1
281 0.0004 0.00041294097900391
SELECT value FROM productattributes
                WHERE product_id = '1547'
                AND name = 'ListPriceAmount'
282 0.0004 0.00038695335388184
SELECT value FROM productattributes WHERE product_id = '1547' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
283 0.0014 0.0014450550079346
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1435' ORDER BY timestamp DESC
284 0.0003 0.00029587745666504
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1437' ORDER BY timestamp DESC
285 0.0002 0.0001981258392334
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1438' ORDER BY timestamp DESC
286 0.0003 0.0002601146697998
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1441' ORDER BY timestamp DESC
287 0.0002 0.00019502639770508
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1442' ORDER BY timestamp DESC
288 0.0002 0.0001988410949707
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1443' ORDER BY timestamp DESC
289 0.0002 0.00021004676818848
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1448' ORDER BY timestamp DESC
290 0.0002 0.0001990795135498
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1460' ORDER BY timestamp DESC
291 0.0002 0.00019383430480957
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1461' ORDER BY timestamp DESC
292 0.0002 0.00019693374633789
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1466' ORDER BY timestamp DESC
293 0.0002 0.00020384788513184
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1476' ORDER BY timestamp DESC
294 0.0002 0.00020098686218262
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1473' ORDER BY timestamp DESC
295 0.0002 0.00019502639770508
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1493' ORDER BY timestamp DESC
296 0.0002 0.00020098686218262
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1499' ORDER BY timestamp DESC
297 0.0002 0.0002138614654541
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1513' ORDER BY timestamp DESC
298 0.0002 0.00019192695617676
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1572' ORDER BY timestamp DESC
299 0.0002 0.00022482872009277
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1544' ORDER BY timestamp DESC
300 0.0002 0.00020194053649902
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1547' ORDER BY timestamp DESC
301 0.0008 0.00078701972961426
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
302 0.0008 0.00076913833618164
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
303 0.0002 0.00024008750915527
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
304 0.0117 0.011719942092896
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
305 0.0009 0.00088310241699219
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
306 0.0004 0.00039100646972656
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
307 0.0004 0.00035786628723145
SELECT * FROM products WHERE id = 1626
308 0.0003 0.00033211708068848
SELECT * FROM products WHERE id = 4041
309 0.0004 0.00035786628723145
SELECT * FROM products WHERE id = 4312
310 0.0003 0.00030088424682617
SELECT * FROM products WHERE id = 777
311 0.0003 0.00031304359436035
SELECT * FROM products WHERE id = 3881
312 0.0003 0.00032210350036621
SELECT * FROM products WHERE id = 4213
313 0.0003 0.00032186508178711
SELECT * FROM products WHERE id = '1626'
314 0.0004 0.00039410591125488
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
315 0.0005 0.00046992301940918
SELECT * FROM product_image_select WHERE product_id = '1626'
316 0.0003 0.00030708312988281
SELECT * FROM productcustomimages WHERE product_id = '1626'
317 0.0006 0.00058603286743164
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
318 0.0003 0.00032901763916016
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
319 0.0003 0.00028300285339355
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
320 0.0004 0.00036883354187012
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
321 0.0004 0.00035905838012695
SELECT * FROM products WHERE id = '4041'
322 0.0004 0.00038719177246094
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
323 0.0005 0.00047898292541504
SELECT * FROM product_image_select WHERE product_id = '4041'
324 0.0003 0.00027990341186523
SELECT * FROM productcustomimages WHERE product_id = '4041'
325 0.0007 0.00069499015808105
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
326 0.0003 0.00032401084899902
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
327 0.0003 0.00026702880859375
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
328 0.0004 0.00035500526428223
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
329 0.0003 0.00033307075500488
SELECT * FROM products WHERE id = '4312'
330 0.0004 0.00038003921508789
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
331 0.0005 0.00045895576477051
SELECT * FROM product_image_select WHERE product_id = '4312'
332 0.0003 0.00028800964355469
SELECT * FROM productcustomimages WHERE product_id = '4312'
333 0.0007 0.00065207481384277
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
334 0.0003 0.0003049373626709
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
335 0.0003 0.00027680397033691
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
336 0.0003 0.00033116340637207
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
337 0.0003 0.00034093856811523
SELECT * FROM products WHERE id = '777'
338 0.0004 0.00037908554077148
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
339 0.0004 0.0004420280456543
SELECT * FROM product_image_select WHERE product_id = '777'
340 0.0003 0.00027799606323242
SELECT * FROM productcustomimages WHERE product_id = '777'
341 0.0007 0.00065994262695312
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
342 0.0003 0.00034999847412109
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
343 0.0003 0.00028109550476074
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
344 0.0003 0.00033903121948242
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
345 0.0004 0.0003509521484375
SELECT * FROM products WHERE id = '3881'
346 0.0004 0.00041890144348145
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
347 0.0005 0.00051379203796387
SELECT * FROM product_image_select WHERE product_id = '3881'
348 0.0003 0.00027298927307129
SELECT * FROM productcustomimages WHERE product_id = '3881'
349 0.0007 0.00067710876464844
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
350 0.0003 0.00031805038452148
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
351 0.0003 0.00026082992553711
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
352 0.0003 0.00034189224243164
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
353 0.0003 0.00033116340637207
SELECT * FROM products WHERE id = '4213'
354 0.0004 0.00041389465332031
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
355 0.0005 0.00051188468933105
SELECT * FROM product_image_select WHERE product_id = '4213'
356 0.0003 0.00029683113098145
SELECT * FROM productcustomimages WHERE product_id = '4213'
357 0.0007 0.00069212913513184
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
358 0.0003 0.00030708312988281
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
359 0.0003 0.00030994415283203
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
360 0.0003 0.00033903121948242
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
361 0.0011 0.0011181831359863
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
362 0.0005 0.00048279762268066
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
363 0.0016 0.0015850067138672
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
364 0.0009 0.00092697143554688
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
365 0.0004 0.00035810470581055
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
366 0.0007 0.00070905685424805
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
367 0.0004 0.00043106079101562
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'