0

Wait! We have a something for you...

Don't leave empty-handed! Simply enter your email below and we will send you a great discount on our products:

We hate spam as much as you do! Your details are never shared and you can unsubscribe at any time.

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
2.9204468727112 363 1.0787 0


No Amazon API Requests Made.


App Debug - Total Time 2.9204468727112 seconds

Number Time From Start Name Description
1 1.7479028701782 Initialise Initialise FSB Function
2 1.753448009491 App Controller Start Start of the App controller (called before the controller of every page)
3 1.7980380058289 Start of getCategoryListByGroup Function Before first category groups query
4 1.79993891716 After initial query Before first category groups query
5 1.7999408245087 Get Category List for Group Before the call to getCategoryList function
6 1.7999458312988 Start of GetCategoryList function Start of the function
7 1.799950838089 Before getting categories Query to get specific category list
8 1.8016178607941 After getting categories Query to get specific category list
9 1.8016200065613 Before getting category custom Before call to function getCategoryCustom
10 1.8381237983704 After getting category custom After call to function getCategoryCustom
11 1.8381278514862 Before getting category custom Before call to function getCategoryCustom
12 1.8519289493561 After getting category custom After call to function getCategoryCustom
13 1.8519330024719 Before getting category custom Before call to function getCategoryCustom
14 1.8586449623108 After getting category custom After call to function getCategoryCustom
15 1.8586490154266 Before getting category custom Before call to function getCategoryCustom
16 1.8639028072357 After getting category custom After call to function getCategoryCustom
17 1.8639078140259 Before getting category custom Before call to function getCategoryCustom
18 1.8689458370209 After getting category custom After call to function getCategoryCustom
19 1.8689498901367 Before getting category custom Before call to function getCategoryCustom
20 1.8742179870605 After getting category custom After call to function getCategoryCustom
21 1.8742208480835 End of GetCategoryList function End of the function
22 1.8742280006409 Get Category List for Group Before the call to getCategoryList function
23 1.8742308616638 Start of GetCategoryList function Start of the function
24 1.8742339611053 Before getting categories Query to get specific category list
25 1.8747668266296 End of getCategoryListByGroup Function Before return()
26 2.4248487949371 App Controller End End of the App controller (called before the controller of every page)
27 2.7010629177094 App_after Controller Start Start of the App_after controller (called after the controller of every page)
28 2.7053368091583 Before Get Options Before the call to getOptions in the tpl class
29 2.839026927948 After Get Options After the call to getOptions in the tpl class
30 2.8390669822693 App_after Controller End End of the App_after controller (called after the controller of every page)
31 2.9204289913177 Finalizing debug Before the debug is output to the page.
32 2.9204449653625 End of App This is the end of the app logging, final timestamp


Query Debug - 363 Database Queries. Total time 1.0787 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0013 0.0012719631195068
SELECT parameter, value FROM parameters
2 0.0056 0.0056037902832031
SELECT * FROM `bad_bots`
3 0.0005 0.00045895576477051
SET time_zone = 'Europe/London'
4 0.0039 0.0038809776306152
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0023 0.0022678375244141
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:12:\"3.145.14.131\";}'
6 0.0018 0.0017971992492676
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1738831602'
7 0.0037 0.0037400722503662
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0006 0.00064992904663086
UPDATE autorun SET lastrun = '2025-02-06 08:46:43' WHERE id = '16'
9 0.0008 0.00079011917114258
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0031 0.0030701160430908
SELECT id FROM pages WHERE pagename = 'search' LIMIT 1
11 0.0006 0.00055909156799316
SELECT * FROM pages WHERE id = 52
12 0.0039 0.0039420127868652
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13 0.0392 0.03923487663269
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14 0.0007 0.00071501731872559
SELECT * FROM pages WHERE pagename = 'search'
15 0.0019 0.0018799304962158
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0016 0.0016410350799561
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0090 0.0090279579162598
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.0019 0.0018799304962158
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.0013 0.001338005065918
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20 0.0015 0.0014948844909668
SELECT id FROM categories WHERE parent_id = '26'
21 0.0148 0.014833927154541
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.0028 0.0028269290924072
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.0024 0.0023539066314697
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.0020 0.0019519329071045
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25 0.0006 0.00059819221496582
SELECT * FROM categorygroups WHERE id = '1'
26 0.0052 0.0052390098571777
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
27 0.0006 0.00057506561279297
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
28 0.0004 0.00044894218444824
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29 0.0006 0.00055408477783203
SELECT id FROM categories WHERE parent_id = '27'
30 0.0045 0.0044951438903809
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.0007 0.00067996978759766
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.0007 0.00065779685974121
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
33 0.0006 0.00059199333190918
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34 0.0004 0.00041604042053223
SELECT * FROM categorygroups WHERE id = '1'
35 0.0014 0.001406192779541
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.00052785873413086
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.00046300888061523
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38 0.0004 0.00044488906860352
SELECT id FROM categories WHERE parent_id = '28'
39 0.0016 0.0015978813171387
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.00054097175598145
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.0006 0.00056719779968262
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.00051403045654297
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43 0.0005 0.00054001808166504
SELECT * FROM categorygroups WHERE id = '1'
44 0.0007 0.00065708160400391
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.00050711631774902
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
46 0.0004 0.00044083595275879
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47 0.0005 0.00047802925109863
SELECT id FROM categories WHERE parent_id = '29'
48 0.0008 0.00080680847167969
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.00053882598876953
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0 
50 0.0006 0.00063800811767578
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.0006 0.00057101249694824
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52 0.0005 0.00049090385437012
SELECT * FROM categorygroups WHERE id = '1'
53 0.0006 0.0005950927734375
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
54 0.0005 0.00051689147949219
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.0005 0.00047898292541504
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56 0.0005 0.00053310394287109
SELECT id FROM categories WHERE parent_id = '30'
57 0.0007 0.00068807601928711
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.0006 0.00056314468383789
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.00053787231445312
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.00052499771118164
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61 0.0005 0.00045990943908691
SELECT * FROM categorygroups WHERE id = '1'
62 0.0006 0.00060105323791504
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
63 0.0005 0.0004880428314209
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.00041699409484863
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65 0.0005 0.00048184394836426
SELECT id FROM categories WHERE parent_id = '31'
66 0.0008 0.00075387954711914
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.0006 0.00058197975158691
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.0008 0.00076103210449219
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.0006 0.00059700012207031
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70 0.0005 0.0004580020904541
SELECT * FROM categorygroups WHERE id = '1'
71 0.0005 0.00052213668823242
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
72 0.0031 0.0031120777130127
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73 0.0016 0.0016219615936279
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74 0.0009 0.00085711479187012
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.0020 0.0019998550415039
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76 0.0016 0.0016038417816162
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77 0.0028 0.0027639865875244
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78 0.5156 0.51564002037048
SELECT * FROM ipgeocountries WHERE INET_ATON('3.145.14.131') >= INET_ATON(ip_start) AND INET_ATON('3.145.14.131') <= INET_ATON(ip_end)
79 0.0023 0.0023291110992432
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80 0.0014 0.0014028549194336
SELECT * FROM countryredirects WHERE countrycode = 'US'
81 0.0027 0.0026619434356689
SELECT * FROM pages WHERE pagename = 'search'
82 0.0156 0.015550851821899
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
83 0.0029 0.0028829574584961
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
84 0.0024 0.0024278163909912
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
85 0.0081 0.0081288814544678
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
86 0.0019 0.0018799304962158
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
87 0.0006 0.00057816505432129
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
88 0.0017 0.0017428398132324
INSERT INTO searches (`keywords`, `timestamp`, `ip`) SELECT '2', NOW(), '3.145.14.131'
89 0.0009 0.00089383125305176
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (title)
    AGAINST ('+2' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (title) AGAINST ('+2' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (title)
        AGAINST ('+2'), 'bundle' AS type FROM bundles b
		WHERE MATCH (title) AGAINST ('+2' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1
90 0.0008 0.00080013275146484
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+2' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary)
        AGAINST ('+2'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1
91 0.0048 0.004763126373291
SELECT DISTINCT (p.id), salesrank, price, linktitle,
          'product' AS type
          FROM products p 
		WHERE ((description LIKE '2') OR (keyfeatures LIKE '2') OR (title LIKE '2'))

		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1
92 0.0006 0.00058293342590332
SELECT DISTINCT (p.id), price, linktitle,
          'ebayproduct' AS type
          FROM ebay_products p 
		WHERE ((description LIKE '2') OR (title LIKE '2'))
		AND hide = 0
93 0.0006 0.00056004524230957
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE '2') OR (title LIKE '2'))
		AND hide = 0
94 0.0006 0.00062799453735352
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+2' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary)
        AGAINST ('+2'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1
95 0.0080 0.0080111026763916
SELECT DISTINCT (p.id), salesrank, price, linktitle,
          'product' AS type
          FROM products p 
		WHERE ((description LIKE '%2%') OR (keyfeatures LIKE '%2%') OR (title LIKE '%2%'))

		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1
96 0.0023 0.0022778511047363
SELECT DISTINCT (p.id), price, linktitle,
          'ebayproduct' AS type
          FROM ebay_products p 
		WHERE ((description LIKE '%2%') OR (title LIKE '%2%'))
		AND hide = 0
97 0.0024 0.0023670196533203
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE '%2%') OR (title LIKE '%2%'))
		AND hide = 0
98 0.0021 0.0020861625671387
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (title)
    AGAINST ('+2' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (title) AGAINST ('+2' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (title)
        AGAINST ('+2'), 'bundle' AS type FROM bundles b
		WHERE MATCH (title) AGAINST ('+2' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
99 0.0018 0.0018320083618164
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+2' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary)
        AGAINST ('+2'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
100 0.0153 0.015297889709473
SELECT DISTINCT (p.id), salesrank, price, linktitle,
          'product' AS type
          FROM products p 
		WHERE ((description LIKE '2') OR (keyfeatures LIKE '2') OR (title LIKE '2'))

		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
101 0.0009 0.00087618827819824
SELECT DISTINCT (p.id), price, linktitle,
          'ebayproduct' AS type
          FROM ebay_products p 
		WHERE ((description LIKE '2') OR (title LIKE '2'))
		AND hide = 0
102 0.0006 0.00060200691223145
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE '2') OR (title LIKE '2'))
		AND hide = 0
103 0.0012 0.0011930465698242
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+2' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary)
        AGAINST ('+2'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
104 0.0150 0.015044212341309
SELECT DISTINCT (p.id), salesrank, price, linktitle,
          'product' AS type
          FROM products p 
		WHERE ((description LIKE '%2%') OR (keyfeatures LIKE '%2%') OR (title LIKE '%2%'))

		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
105 0.0006 0.00057291984558105
SELECT DISTINCT (p.id), price, linktitle,
          'ebayproduct' AS type
          FROM ebay_products p 
		WHERE ((description LIKE '%2%') OR (title LIKE '%2%'))
		AND hide = 0
106 0.0004 0.00044584274291992
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE '%2%') OR (title LIKE '%2%'))
		AND hide = 0
107 0.0006 0.00057792663574219
SELECT * FROM products WHERE id = '1108'
108 0.0031 0.0031318664550781
SELECT * FROM productimages WHERE product_id = '1108' ORDER BY sortorder ASC
109 0.0022 0.0022251605987549
SELECT * FROM product_image_select WHERE product_id = '1108'
110 0.0019 0.0019152164459229
SELECT * FROM productcustomimages WHERE product_id = '1108'
111 0.0034 0.0034139156341553
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1108' AND a.name = n.originalname
112 0.0027 0.0026509761810303
SELECT * FROM productoffers WHERE product_id = '1108' AND merchantid = 'A1X6FK5RDHNB96'
113 0.0006 0.00058889389038086
SELECT * FROM productoffers
                WHERE product_id = '1108' AND price > 0
                ORDER BY price ASC LIMIT 1
114 0.0005 0.00047612190246582
SELECT * FROM productoffers
                WHERE product_id = 1108
                ORDER BY price ASC LIMIT 1
115 0.0006 0.00063681602478027
SELECT value FROM productattributes
                WHERE product_id = '1108'
                AND name = 'ListPriceAmount'
116 0.0005 0.00051999092102051
SELECT value FROM productattributes WHERE product_id = '1108' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
117 0.0007 0.00069499015808105
SELECT * FROM products WHERE id = '1109'
118 0.0005 0.00054311752319336
SELECT * FROM productimages WHERE product_id = '1109' ORDER BY sortorder ASC
119 0.0007 0.00070905685424805
SELECT * FROM product_image_select WHERE product_id = '1109'
120 0.0005 0.00052189826965332
SELECT * FROM productcustomimages WHERE product_id = '1109'
121 0.0010 0.0009920597076416
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1109' AND a.name = n.originalname
122 0.0005 0.00053620338439941
SELECT * FROM productoffers WHERE product_id = '1109' AND merchantid = 'A1X6FK5RDHNB96'
123 0.0005 0.00050806999206543
SELECT * FROM productoffers
                WHERE product_id = '1109' AND price > 0
                ORDER BY price ASC LIMIT 1
124 0.0004 0.00041699409484863
SELECT * FROM productoffers
                WHERE product_id = 1109
                ORDER BY price ASC LIMIT 1
125 0.0005 0.00045394897460938
SELECT value FROM productattributes
                WHERE product_id = '1109'
                AND name = 'ListPriceAmount'
126 0.0005 0.00047802925109863
SELECT value FROM productattributes WHERE product_id = '1109' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
127 0.0006 0.00064611434936523
SELECT * FROM products WHERE id = '1111'
128 0.0006 0.00056600570678711
SELECT * FROM productimages WHERE product_id = '1111' ORDER BY sortorder ASC
129 0.0006 0.0006411075592041
SELECT * FROM product_image_select WHERE product_id = '1111'
130 0.0004 0.00044584274291992
SELECT * FROM productcustomimages WHERE product_id = '1111'
131 0.0014 0.001392126083374
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1111' AND a.name = n.originalname
132 0.0005 0.00052189826965332
SELECT * FROM productoffers WHERE product_id = '1111' AND merchantid = 'A1X6FK5RDHNB96'
133 0.0005 0.00049710273742676
SELECT * FROM productoffers
                WHERE product_id = '1111' AND price > 0
                ORDER BY price ASC LIMIT 1
134 0.0005 0.00048112869262695
SELECT value FROM productattributes WHERE product_id = '1111' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
135 0.0006 0.00062394142150879
SELECT * FROM products WHERE id = '1112'
136 0.0006 0.00060200691223145
SELECT * FROM productimages WHERE product_id = '1112' ORDER BY sortorder ASC
137 0.0007 0.00065994262695312
SELECT * FROM product_image_select WHERE product_id = '1112'
138 0.0004 0.00040793418884277
SELECT * FROM productcustomimages WHERE product_id = '1112'
139 0.0014 0.0013649463653564
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1112' AND a.name = n.originalname
140 0.0006 0.00055193901062012
SELECT * FROM productoffers WHERE product_id = '1112' AND merchantid = 'A1X6FK5RDHNB96'
141 0.0004 0.0004420280456543
SELECT * FROM productoffers
                WHERE product_id = '1112' AND price > 0
                ORDER BY price ASC LIMIT 1
142 0.0005 0.00046014785766602
SELECT * FROM productoffers
                WHERE product_id = 1112
                ORDER BY price ASC LIMIT 1
143 0.0005 0.0005190372467041
SELECT value FROM productattributes
                WHERE product_id = '1112'
                AND name = 'ListPriceAmount'
144 0.0005 0.00048494338989258
SELECT value FROM productattributes WHERE product_id = '1112' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
145 0.0006 0.00061798095703125
SELECT * FROM products WHERE id = '1119'
146 0.0006 0.0005500316619873
SELECT * FROM productimages WHERE product_id = '1119' ORDER BY sortorder ASC
147 0.0007 0.00065803527832031
SELECT * FROM product_image_select WHERE product_id = '1119'
148 0.0005 0.00046300888061523
SELECT * FROM productcustomimages WHERE product_id = '1119'
149 0.0011 0.00105881690979
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1119' AND a.name = n.originalname
150 0.0006 0.00056600570678711
SELECT * FROM productoffers WHERE product_id = '1119' AND merchantid = 'A1X6FK5RDHNB96'
151 0.0005 0.00047707557678223
SELECT * FROM productoffers
                WHERE product_id = '1119' AND price > 0
                ORDER BY price ASC LIMIT 1
152 0.0004 0.00044703483581543
SELECT * FROM productoffers
                WHERE product_id = 1119
                ORDER BY price ASC LIMIT 1
153 0.0005 0.00052094459533691
SELECT value FROM productattributes
                WHERE product_id = '1119'
                AND name = 'ListPriceAmount'
154 0.0005 0.00049805641174316
SELECT value FROM productattributes WHERE product_id = '1119' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
155 0.0010 0.0010249614715576
SELECT * FROM products WHERE id = '1121'
156 0.0011 0.0010521411895752
SELECT * FROM productimages WHERE product_id = '1121' ORDER BY sortorder ASC
157 0.0013 0.0012838840484619
SELECT * FROM product_image_select WHERE product_id = '1121'
158 0.0008 0.00083589553833008
SELECT * FROM productcustomimages WHERE product_id = '1121'
159 0.0034 0.0034210681915283
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1121' AND a.name = n.originalname
160 0.0011 0.0010790824890137
SELECT * FROM productoffers WHERE product_id = '1121' AND merchantid = 'A1X6FK5RDHNB96'
161 0.0008 0.00081300735473633
SELECT * FROM productoffers
                WHERE product_id = '1121' AND price > 0
                ORDER BY price ASC LIMIT 1
162 0.0008 0.0007929801940918
SELECT value FROM productattributes WHERE product_id = '1121' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
163 0.0010 0.00097799301147461
SELECT * FROM products WHERE id = '1124'
164 0.0010 0.0010008811950684
SELECT * FROM productimages WHERE product_id = '1124' ORDER BY sortorder ASC
165 0.0014 0.0013670921325684
SELECT * FROM product_image_select WHERE product_id = '1124'
166 0.0006 0.0005648136138916
SELECT * FROM productcustomimages WHERE product_id = '1124'
167 0.0023 0.0023279190063477
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1124' AND a.name = n.originalname
168 0.0008 0.00078105926513672
SELECT * FROM productoffers WHERE product_id = '1124' AND merchantid = 'A1X6FK5RDHNB96'
169 0.0006 0.00062298774719238
SELECT * FROM productoffers
                WHERE product_id = '1124' AND price > 0
                ORDER BY price ASC LIMIT 1
170 0.0005 0.00052499771118164
SELECT * FROM productoffers
                WHERE product_id = 1124
                ORDER BY price ASC LIMIT 1
171 0.0006 0.00058913230895996
SELECT value FROM productattributes
                WHERE product_id = '1124'
                AND name = 'ListPriceAmount'
172 0.0007 0.00067687034606934
SELECT value FROM productattributes WHERE product_id = '1124' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
173 0.0009 0.0009150505065918
SELECT * FROM products WHERE id = '1127'
174 0.0008 0.00081205368041992
SELECT * FROM productimages WHERE product_id = '1127' ORDER BY sortorder ASC
175 0.0011 0.0010647773742676
SELECT * FROM product_image_select WHERE product_id = '1127'
176 0.0006 0.00060796737670898
SELECT * FROM productcustomimages WHERE product_id = '1127'
177 0.0019 0.00193190574646
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1127' AND a.name = n.originalname
178 0.0008 0.00076413154602051
SELECT * FROM productoffers WHERE product_id = '1127' AND merchantid = 'A1X6FK5RDHNB96'
179 0.0006 0.00061583518981934
SELECT * FROM productoffers
                WHERE product_id = '1127' AND price > 0
                ORDER BY price ASC LIMIT 1
180 0.0007 0.00070309638977051
SELECT value FROM productattributes WHERE product_id = '1127' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
181 0.0009 0.0009009838104248
SELECT * FROM products WHERE id = '1138'
182 0.0011 0.001121997833252
SELECT * FROM productimages WHERE product_id = '1138' ORDER BY sortorder ASC
183 0.0021 0.0020620822906494
SELECT * FROM product_image_select WHERE product_id = '1138'
184 0.0012 0.0012259483337402
SELECT * FROM productcustomimages WHERE product_id = '1138'
185 0.0022 0.0022079944610596
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1138' AND a.name = n.originalname
186 0.0010 0.00098514556884766
SELECT * FROM productoffers WHERE product_id = '1138' AND merchantid = 'A1X6FK5RDHNB96'
187 0.0007 0.00067591667175293
SELECT * FROM productoffers
                WHERE product_id = '1138' AND price > 0
                ORDER BY price ASC LIMIT 1
188 0.0006 0.00059795379638672
SELECT * FROM productoffers
                WHERE product_id = 1138
                ORDER BY price ASC LIMIT 1
189 0.0007 0.00065112113952637
SELECT value FROM productattributes
                WHERE product_id = '1138'
                AND name = 'ListPriceAmount'
190 0.0008 0.00075793266296387
SELECT value FROM productattributes WHERE product_id = '1138' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
191 0.0009 0.00094413757324219
SELECT * FROM products WHERE id = '1144'
192 0.0011 0.0010700225830078
SELECT * FROM productimages WHERE product_id = '1144' ORDER BY sortorder ASC
193 0.0012 0.0011820793151855
SELECT * FROM product_image_select WHERE product_id = '1144'
194 0.0007 0.00067520141601562
SELECT * FROM productcustomimages WHERE product_id = '1144'
195 0.0031 0.0030510425567627
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1144' AND a.name = n.originalname
196 0.0010 0.00096893310546875
SELECT * FROM productoffers WHERE product_id = '1144' AND merchantid = 'A1X6FK5RDHNB96'
197 0.0009 0.00094485282897949
SELECT * FROM productoffers
                WHERE product_id = '1144' AND price > 0
                ORDER BY price ASC LIMIT 1
198 0.0007 0.00072097778320312
SELECT * FROM productoffers
                WHERE product_id = 1144
                ORDER BY price ASC LIMIT 1
199 0.0006 0.00064396858215332
SELECT value FROM productattributes
                WHERE product_id = '1144'
                AND name = 'ListPriceAmount'
200 0.0007 0.0007178783416748
SELECT value FROM productattributes WHERE product_id = '1144' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
201 0.0010 0.00096392631530762
SELECT * FROM products WHERE id = '1151'
202 0.0009 0.00094795227050781
SELECT * FROM productimages WHERE product_id = '1151' ORDER BY sortorder ASC
203 0.0011 0.0011260509490967
SELECT * FROM product_image_select WHERE product_id = '1151'
204 0.0006 0.00056004524230957
SELECT * FROM productcustomimages WHERE product_id = '1151'
205 0.0054 0.0054161548614502
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1151' AND a.name = n.originalname
206 0.0011 0.0011239051818848
SELECT * FROM productoffers WHERE product_id = '1151' AND merchantid = 'A1X6FK5RDHNB96'
207 0.0007 0.0007331371307373
SELECT * FROM productoffers
                WHERE product_id = '1151' AND price > 0
                ORDER BY price ASC LIMIT 1
208 0.0007 0.00065183639526367
SELECT * FROM productoffers
                WHERE product_id = 1151
                ORDER BY price ASC LIMIT 1
209 0.0007 0.00067496299743652
SELECT value FROM productattributes
                WHERE product_id = '1151'
                AND name = 'ListPriceAmount'
210 0.0007 0.00067710876464844
SELECT value FROM productattributes WHERE product_id = '1151' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
211 0.0009 0.0009160041809082
SELECT * FROM products WHERE id = '1165'
212 0.0008 0.00078201293945312
SELECT * FROM productimages WHERE product_id = '1165' ORDER BY sortorder ASC
213 0.0009 0.00088095664978027
SELECT * FROM product_image_select WHERE product_id = '1165'
214 0.0006 0.00063300132751465
SELECT * FROM productcustomimages WHERE product_id = '1165'
215 0.0018 0.0017690658569336
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1165' AND a.name = n.originalname
216 0.0007 0.00071597099304199
SELECT * FROM productoffers WHERE product_id = '1165' AND merchantid = 'A1X6FK5RDHNB96'
217 0.0006 0.00055599212646484
SELECT * FROM productoffers
                WHERE product_id = '1165' AND price > 0
                ORDER BY price ASC LIMIT 1
218 0.0006 0.00056004524230957
SELECT * FROM productoffers
                WHERE product_id = 1165
                ORDER BY price ASC LIMIT 1
219 0.0007 0.00066399574279785
SELECT value FROM productattributes
                WHERE product_id = '1165'
                AND name = 'ListPriceAmount'
220 0.0008 0.00080704689025879
SELECT value FROM productattributes WHERE product_id = '1165' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
221 0.0009 0.0008549690246582
SELECT * FROM products WHERE id = '1199'
222 0.0013 0.0012869834899902
SELECT * FROM productimages WHERE product_id = '1199' ORDER BY sortorder ASC
223 0.0012 0.0012390613555908
SELECT * FROM product_image_select WHERE product_id = '1199'
224 0.0009 0.00088787078857422
SELECT * FROM productcustomimages WHERE product_id = '1199'
225 0.0026 0.0026290416717529
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1199' AND a.name = n.originalname
226 0.0010 0.00095295906066895
SELECT * FROM productoffers WHERE product_id = '1199' AND merchantid = 'A1X6FK5RDHNB96'
227 0.0007 0.00072002410888672
SELECT * FROM productoffers
                WHERE product_id = '1199' AND price > 0
                ORDER BY price ASC LIMIT 1
228 0.0008 0.00083112716674805
SELECT value FROM productattributes WHERE product_id = '1199' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
229 0.0010 0.00097393989562988
SELECT * FROM products WHERE id = '1205'
230 0.0008 0.00077199935913086
SELECT * FROM productimages WHERE product_id = '1205' ORDER BY sortorder ASC
231 0.0009 0.00094103813171387
SELECT * FROM product_image_select WHERE product_id = '1205'
232 0.0006 0.00063705444335938
SELECT * FROM productcustomimages WHERE product_id = '1205'
233 0.0012 0.0012190341949463
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1205' AND a.name = n.originalname
234 0.0007 0.00068092346191406
SELECT * FROM productoffers WHERE product_id = '1205' AND merchantid = 'A1X6FK5RDHNB96'
235 0.0005 0.00052094459533691
SELECT * FROM productoffers
                WHERE product_id = '1205' AND price > 0
                ORDER BY price ASC LIMIT 1
236 0.0005 0.00054693222045898
SELECT * FROM productoffers
                WHERE product_id = 1205
                ORDER BY price ASC LIMIT 1
237 0.0006 0.00063514709472656
SELECT value FROM productattributes
                WHERE product_id = '1205'
                AND name = 'ListPriceAmount'
238 0.0007 0.00073790550231934
SELECT value FROM productattributes WHERE product_id = '1205' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
239 0.0007 0.00073003768920898
SELECT * FROM products WHERE id = '1219'
240 0.0008 0.00076603889465332
SELECT * FROM productimages WHERE product_id = '1219' ORDER BY sortorder ASC
241 0.0009 0.0008690357208252
SELECT * FROM product_image_select WHERE product_id = '1219'
242 0.0005 0.00049710273742676
SELECT * FROM productcustomimages WHERE product_id = '1219'
243 0.0013 0.0012991428375244
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1219' AND a.name = n.originalname
244 0.0005 0.00054311752319336
SELECT * FROM productoffers WHERE product_id = '1219' AND merchantid = 'A1X6FK5RDHNB96'
245 0.0005 0.00049901008605957
SELECT * FROM productoffers
                WHERE product_id = '1219' AND price > 0
                ORDER BY price ASC LIMIT 1
246 0.0005 0.00048398971557617
SELECT * FROM productoffers
                WHERE product_id = 1219
                ORDER BY price ASC LIMIT 1
247 0.0005 0.00053906440734863
SELECT value FROM productattributes
                WHERE product_id = '1219'
                AND name = 'ListPriceAmount'
248 0.0005 0.00051784515380859
SELECT value FROM productattributes WHERE product_id = '1219' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
249 0.0006 0.00064301490783691
SELECT * FROM products WHERE id = '1220'
250 0.0006 0.00056195259094238
SELECT * FROM productimages WHERE product_id = '1220' ORDER BY sortorder ASC
251 0.0007 0.00067996978759766
SELECT * FROM product_image_select WHERE product_id = '1220'
252 0.0005 0.0004570484161377
SELECT * FROM productcustomimages WHERE product_id = '1220'
253 0.0009 0.00092506408691406
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1220' AND a.name = n.originalname
254 0.0006 0.00056314468383789
SELECT * FROM productoffers WHERE product_id = '1220' AND merchantid = 'A1X6FK5RDHNB96'
255 0.0005 0.00048708915710449
SELECT * FROM productoffers
                WHERE product_id = '1220' AND price > 0
                ORDER BY price ASC LIMIT 1
256 0.0004 0.00039792060852051
SELECT * FROM productoffers
                WHERE product_id = 1220
                ORDER BY price ASC LIMIT 1
257 0.0005 0.00048398971557617
SELECT value FROM productattributes
                WHERE product_id = '1220'
                AND name = 'ListPriceAmount'
258 0.0005 0.00052809715270996
SELECT value FROM productattributes WHERE product_id = '1220' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
259 0.0007 0.00065708160400391
SELECT * FROM products WHERE id = '1222'
260 0.0005 0.00052905082702637
SELECT * FROM productimages WHERE product_id = '1222' ORDER BY sortorder ASC
261 0.0007 0.00073814392089844
SELECT * FROM product_image_select WHERE product_id = '1222'
262 0.0005 0.0005030632019043
SELECT * FROM productcustomimages WHERE product_id = '1222'
263 0.0009 0.00091314315795898
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1222' AND a.name = n.originalname
264 0.0007 0.00066900253295898
SELECT * FROM productoffers WHERE product_id = '1222' AND merchantid = 'A1X6FK5RDHNB96'
265 0.0006 0.00055193901062012
SELECT * FROM productoffers
                WHERE product_id = '1222' AND price > 0
                ORDER BY price ASC LIMIT 1
266 0.0005 0.00047397613525391
SELECT * FROM productoffers
                WHERE product_id = 1222
                ORDER BY price ASC LIMIT 1
267 0.0005 0.00050091743469238
SELECT value FROM productattributes
                WHERE product_id = '1222'
                AND name = 'ListPriceAmount'
268 0.0005 0.00047802925109863
SELECT value FROM productattributes WHERE product_id = '1222' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
269 0.0007 0.00072693824768066
SELECT * FROM products WHERE id = '1234'
270 0.0009 0.00091814994812012
SELECT * FROM productimages WHERE product_id = '1234' ORDER BY sortorder ASC
271 0.0007 0.00072693824768066
SELECT * FROM product_image_select WHERE product_id = '1234'
272 0.0005 0.00053095817565918
SELECT * FROM productcustomimages WHERE product_id = '1234'
273 0.0024 0.0023961067199707
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1234' AND a.name = n.originalname
274 0.0008 0.00083398818969727
SELECT * FROM productoffers WHERE product_id = '1234' AND merchantid = 'A1X6FK5RDHNB96'
275 0.0006 0.0005950927734375
SELECT * FROM productoffers
                WHERE product_id = '1234' AND price > 0
                ORDER BY price ASC LIMIT 1
276 0.0005 0.0005340576171875
SELECT * FROM productoffers
                WHERE product_id = 1234
                ORDER BY price ASC LIMIT 1
277 0.0005 0.00046205520629883
SELECT value FROM productattributes
                WHERE product_id = '1234'
                AND name = 'ListPriceAmount'
278 0.0008 0.00082993507385254
SELECT value FROM productattributes WHERE product_id = '1234' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
279 0.0026 0.0026240348815918
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1108' ORDER BY timestamp DESC
280 0.0011 0.0010960102081299
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1109' ORDER BY timestamp DESC
281 0.0011 0.0010979175567627
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1111' ORDER BY timestamp DESC
282 0.0015 0.0015220642089844
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1112' ORDER BY timestamp DESC
283 0.0018 0.0018048286437988
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1119' ORDER BY timestamp DESC
284 0.0013 0.001284122467041
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1121' ORDER BY timestamp DESC
285 0.0006 0.00058484077453613
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1124' ORDER BY timestamp DESC
286 0.0005 0.00050711631774902
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1127' ORDER BY timestamp DESC
287 0.0005 0.0004570484161377
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1138' ORDER BY timestamp DESC
288 0.0005 0.00048303604125977
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1144' ORDER BY timestamp DESC
289 0.0006 0.00057196617126465
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1151' ORDER BY timestamp DESC
290 0.0005 0.0005040168762207
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1165' ORDER BY timestamp DESC
291 0.0005 0.00047993659973145
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1199' ORDER BY timestamp DESC
292 0.0005 0.00047588348388672
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1205' ORDER BY timestamp DESC
293 0.0006 0.00057697296142578
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1219' ORDER BY timestamp DESC
294 0.0004 0.00041890144348145
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1220' ORDER BY timestamp DESC
295 0.0004 0.00042009353637695
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1222' ORDER BY timestamp DESC
296 0.0005 0.00045013427734375
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1234' ORDER BY timestamp DESC
297 0.0032 0.0031609535217285
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
298 0.0029 0.0029489994049072
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
299 0.0012 0.0012328624725342
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
300 0.0374 0.037418127059937
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
301 0.0044 0.0044219493865967
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
302 0.0031 0.0031459331512451
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
303 0.0015 0.001535177230835
SELECT * FROM products WHERE id = 1626
304 0.0010 0.0010159015655518
SELECT * FROM products WHERE id = 4041
305 0.0011 0.0010678768157959
SELECT * FROM products WHERE id = 4312
306 0.0010 0.00097203254699707
SELECT * FROM products WHERE id = 777
307 0.0009 0.000946044921875
SELECT * FROM products WHERE id = 3881
308 0.0008 0.00076794624328613
SELECT * FROM products WHERE id = 4213
309 0.0006 0.0006098747253418
SELECT * FROM products WHERE id = '1626'
310 0.0008 0.00080108642578125
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
311 0.0012 0.00124192237854
SELECT * FROM product_image_select WHERE product_id = '1626'
312 0.0008 0.0008389949798584
SELECT * FROM productcustomimages WHERE product_id = '1626'
313 0.0019 0.0018999576568604
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
314 0.0011 0.0010688304901123
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
315 0.0008 0.00083804130554199
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
316 0.0011 0.0011050701141357
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
317 0.0012 0.0011701583862305
SELECT * FROM products WHERE id = '4041'
318 0.0011 0.0010800361633301
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
319 0.0013 0.0012819766998291
SELECT * FROM product_image_select WHERE product_id = '4041'
320 0.0008 0.00082206726074219
SELECT * FROM productcustomimages WHERE product_id = '4041'
321 0.0033 0.0032670497894287
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
322 0.0009 0.00094199180603027
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
323 0.0007 0.00072598457336426
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
324 0.0009 0.00092697143554688
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
325 0.0010 0.00099086761474609
SELECT * FROM products WHERE id = '4312'
326 0.0008 0.00079107284545898
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
327 0.0010 0.00098800659179688
SELECT * FROM product_image_select WHERE product_id = '4312'
328 0.0008 0.00084495544433594
SELECT * FROM productcustomimages WHERE product_id = '4312'
329 0.0018 0.0017681121826172
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
330 0.0013 0.0013279914855957
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
331 0.0007 0.00069499015808105
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
332 0.0007 0.00069689750671387
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
333 0.0008 0.00079822540283203
SELECT * FROM products WHERE id = '777'
334 0.0007 0.0007319450378418
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
335 0.0009 0.00091791152954102
SELECT * FROM product_image_select WHERE product_id = '777'
336 0.0013 0.0013349056243896
SELECT * FROM productcustomimages WHERE product_id = '777'
337 0.0018 0.0017969608306885
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
338 0.0007 0.00070095062255859
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
339 0.0011 0.0011441707611084
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
340 0.0009 0.00092601776123047
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
341 0.0015 0.0014810562133789
SELECT * FROM products WHERE id = '3881'
342 0.0007 0.00071907043457031
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
343 0.0038 0.0037620067596436
SELECT * FROM product_image_select WHERE product_id = '3881'
344 0.0012 0.0011677742004395
SELECT * FROM productcustomimages WHERE product_id = '3881'
345 0.0041 0.0041170120239258
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
346 0.0012 0.0011589527130127
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
347 0.0009 0.00087499618530273
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
348 0.0011 0.0011470317840576
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
349 0.0011 0.0011107921600342
SELECT * FROM products WHERE id = '4213'
350 0.0010 0.00098896026611328
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
351 0.0012 0.0012040138244629
SELECT * FROM product_image_select WHERE product_id = '4213'
352 0.0008 0.00082111358642578
SELECT * FROM productcustomimages WHERE product_id = '4213'
353 0.0038 0.0038309097290039
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
354 0.0010 0.0010209083557129
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
355 0.0013 0.0013289451599121
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
356 0.0008 0.0007939338684082
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
357 0.0035 0.0034840106964111
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
358 0.0015 0.0015139579772949
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
359 0.0081 0.008051872253418
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
360 0.0048 0.0047872066497803
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
361 0.0012 0.0012381076812744
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
362 0.0008 0.00077605247497559
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
363 0.0008 0.00077199935913086
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'