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.4355328083038 387 1.0956 0


No Amazon API Requests Made.


App Debug - Total Time 2.4355328083038 seconds

Number Time From Start Name Description
1 1.3194789886475 Initialise Initialise FSB Function
2 1.322408914566 App Controller Start Start of the App controller (called before the controller of every page)
3 1.372829914093 Start of getCategoryListByGroup Function Before first category groups query
4 1.3736658096313 After initial query Before first category groups query
5 1.3736670017242 Get Category List for Group Before the call to getCategoryList function
6 1.3736689090729 Start of GetCategoryList function Start of the function
7 1.3736698627472 Before getting categories Query to get specific category list
8 1.3745088577271 After getting categories Query to get specific category list
9 1.3745088577271 Before getting category custom Before call to function getCategoryCustom
10 1.3889539241791 After getting category custom After call to function getCategoryCustom
11 1.3889558315277 Before getting category custom Before call to function getCategoryCustom
12 1.397255897522 After getting category custom After call to function getCategoryCustom
13 1.3972578048706 Before getting category custom Before call to function getCategoryCustom
14 1.4016079902649 After getting category custom After call to function getCategoryCustom
15 1.4016089439392 Before getting category custom Before call to function getCategoryCustom
16 1.4045820236206 After getting category custom After call to function getCategoryCustom
17 1.4045829772949 Before getting category custom Before call to function getCategoryCustom
18 1.4074728488922 After getting category custom After call to function getCategoryCustom
19 1.4074738025665 Before getting category custom Before call to function getCategoryCustom
20 1.4103820323944 After getting category custom After call to function getCategoryCustom
21 1.410383939743 End of GetCategoryList function End of the function
22 1.4103879928589 Get Category List for Group Before the call to getCategoryList function
23 1.4103889465332 Start of GetCategoryList function Start of the function
24 1.4103899002075 Before getting categories Query to get specific category list
25 1.4107129573822 End of getCategoryListByGroup Function Before return()
26 2.2252509593964 App Controller End End of the App controller (called before the controller of every page)
27 2.3489408493042 App_after Controller Start Start of the App_after controller (called after the controller of every page)
28 2.3499228954315 Before Get Options Before the call to getOptions in the tpl class
29 2.4104080200195 After Get Options After the call to getOptions in the tpl class
30 2.4104559421539 App_after Controller End End of the App_after controller (called after the controller of every page)
31 2.4355218410492 Finalizing debug Before the debug is output to the page.
32 2.4355318546295 End of App This is the end of the app logging, final timestamp


Query Debug - 387 Database Queries. Total time 1.0956 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0016 0.0015718936920166
SELECT parameter, value FROM parameters
2 0.0052 0.0051639080047607
SELECT * FROM `bad_bots`
3 0.0003 0.00030899047851562
SET time_zone = 'Europe/London'
4 0.0013 0.001349925994873
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0013 0.0013089179992676
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"216.73.216.66\";}'
6 0.0013 0.0013208389282227
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1751861664'
7 0.0018 0.0018320083618164
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0005 0.00054287910461426
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0014 0.0013630390167236
SELECT id FROM pages WHERE pagename = 'search' LIMIT 1
10 0.0004 0.00038814544677734
SELECT * FROM pages WHERE id = 52
11 0.0030 0.0030438899993896
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0466 0.046571016311646
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0004 0.00038909912109375
SELECT * FROM pages WHERE pagename = 'search'
14 0.0008 0.00083303451538086
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0008 0.00083017349243164
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0055 0.0055060386657715
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
17 0.0009 0.00087690353393555
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
18 0.0006 0.00060105323791504
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0003 0.00028800964355469
SELECT id FROM categories WHERE parent_id = '26'
20 0.0047 0.004655122756958
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
21 0.0008 0.00075888633728027
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0 
22 0.0008 0.00077700614929199
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
23 0.0007 0.00065183639526367
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0003 0.00028395652770996
SELECT * FROM categorygroups WHERE id = '1'
25 0.0030 0.0030238628387451
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
26 0.0003 0.0003199577331543
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
27 0.0003 0.00026917457580566
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0003 0.00028395652770996
SELECT id FROM categories WHERE parent_id = '27'
29 0.0031 0.0030519962310791
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
30 0.0004 0.0003819465637207
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
31 0.0003 0.00033807754516602
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
32 0.0003 0.00032687187194824
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0003 0.00027704238891602
SELECT * FROM categorygroups WHERE id = '1'
34 0.0011 0.0011470317840576
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
35 0.0003 0.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
36 0.0003 0.00026893615722656
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0003 0.00028300285339355
SELECT id FROM categories WHERE parent_id = '28'
38 0.0011 0.0011129379272461
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
39 0.0003 0.00032210350036621
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0 
40 0.0003 0.00032901763916016
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
41 0.0003 0.00029301643371582
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0003 0.00027203559875488
SELECT * FROM categorygroups WHERE id = '1'
43 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 = 29
44 0.0003 0.0003058910369873
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
45 0.0003 0.0002751350402832
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0003 0.00027799606323242
SELECT id FROM categories WHERE parent_id = '29'
47 0.0004 0.00043392181396484
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
48 0.0003 0.00031089782714844
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0 
49 0.0003 0.00033283233642578
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
50 0.0003 0.00029206275939941
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0003 0.00028419494628906
SELECT * FROM categorygroups WHERE id = '1'
52 0.0004 0.00038695335388184
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
53 0.0003 0.00029397010803223
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
54 0.0003 0.00025701522827148
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0003 0.0002741813659668
SELECT id FROM categories WHERE parent_id = '30'
56 0.0005 0.00045299530029297
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
57 0.0003 0.00031304359436035
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0 
58 0.0003 0.00032520294189453
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
59 0.0003 0.00029802322387695
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0003 0.00027012825012207
SELECT * FROM categorygroups WHERE id = '1'
61 0.0004 0.00038599967956543
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
62 0.0003 0.00028896331787109
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
63 0.0003 0.00025582313537598
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0003 0.0002739429473877
SELECT id FROM categories WHERE parent_id = '31'
65 0.0004 0.00044012069702148
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
66 0.0003 0.00030899047851562
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
67 0.0003 0.00032186508178711
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
68 0.0003 0.00033402442932129
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0003 0.00027894973754883
SELECT * FROM categorygroups WHERE id = '1'
70 0.0003 0.0003199577331543
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0018 0.0017619132995605
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0007 0.00073790550231934
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0004 0.00035691261291504
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
74 0.0006 0.00057196617126465
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0009 0.00087809562683105
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0005 0.00054597854614258
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.8060 0.80599212646484
SELECT * FROM ipgeocountries WHERE INET_ATON('216.73.216.66') >= INET_ATON(ip_start) AND INET_ATON('216.73.216.66') <= INET_ATON(ip_end)
78 0.0014 0.0014328956604004
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0007 0.00069904327392578
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0004 0.00041604042053223
SELECT * FROM pages WHERE pagename = 'search'
81 0.0047 0.0046799182891846
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
82 0.0014 0.0013599395751953
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
83 0.0009 0.00087785720825195
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
84 0.0046 0.0045680999755859
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
85 0.0017 0.0016748905181885
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
86 0.0004 0.00041913986206055
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
87 0.0008 0.0008089542388916
INSERT INTO searches (`keywords`, `timestamp`, `ip`) SELECT 'easehold bote cafe hermetique botes et coffrets the et cafe', NOW(), '216.73.216.66'
88 0.0005 0.00051617622375488
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (title)
    AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (title) AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' 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 ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe'), 'bundle' AS type FROM bundles b
		WHERE MATCH (title) AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1
89 0.0003 0.00033783912658691
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' 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 ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1
90 0.0040 0.0039758682250977
SELECT DISTINCT (p.id), salesrank, price, linktitle,
          'product' AS type
          FROM products p 
		WHERE ((description LIKE 'easehold') OR (keyfeatures LIKE 'easehold') OR (title LIKE 'easehold') OR (description LIKE 'bote') OR (keyfeatures LIKE 'bote') OR (title LIKE 'bote') OR (description LIKE 'cafe') OR (keyfeatures LIKE 'cafe') OR (title LIKE 'cafe') OR (description LIKE 'hermetique') OR (keyfeatures LIKE 'hermetique') OR (title LIKE 'hermetique') OR (description LIKE 'botes') OR (keyfeatures LIKE 'botes') OR (title LIKE 'botes') OR (description LIKE 'et') OR (keyfeatures LIKE 'et') OR (title LIKE 'et') OR (description LIKE 'coffrets') OR (keyfeatures LIKE 'coffrets') OR (title LIKE 'coffrets') OR (description LIKE 'the') OR (keyfeatures LIKE 'the') OR (title LIKE 'the') OR (description LIKE 'et') OR (keyfeatures LIKE 'et') OR (title LIKE 'et') OR (description LIKE 'cafe') OR (keyfeatures LIKE 'cafe') OR (title LIKE 'cafe'))

		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1
91 0.0004 0.00036191940307617
SELECT DISTINCT (p.id), price, linktitle,
          'ebayproduct' AS type
          FROM ebay_products p 
		WHERE ((description LIKE 'easehold') OR (title LIKE 'easehold') OR (description LIKE 'bote') OR (title LIKE 'bote') OR (description LIKE 'cafe') OR (title LIKE 'cafe') OR (description LIKE 'hermetique') OR (title LIKE 'hermetique') OR (description LIKE 'botes') OR (title LIKE 'botes') OR (description LIKE 'et') OR (title LIKE 'et') OR (description LIKE 'coffrets') OR (title LIKE 'coffrets') OR (description LIKE 'the') OR (title LIKE 'the') OR (description LIKE 'et') OR (title LIKE 'et') OR (description LIKE 'cafe') OR (title LIKE 'cafe'))
		AND hide = 0
92 0.0004 0.00035881996154785
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE 'easehold') OR (title LIKE 'easehold') OR (description LIKE 'bote') OR (title LIKE 'bote') OR (description LIKE 'cafe') OR (title LIKE 'cafe') OR (description LIKE 'hermetique') OR (title LIKE 'hermetique') OR (description LIKE 'botes') OR (title LIKE 'botes') OR (description LIKE 'et') OR (title LIKE 'et') OR (description LIKE 'coffrets') OR (title LIKE 'coffrets') OR (description LIKE 'the') OR (title LIKE 'the') OR (description LIKE 'et') OR (title LIKE 'et') OR (description LIKE 'cafe') OR (title LIKE 'cafe'))
		AND hide = 0
93 0.0003 0.00034308433532715
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' 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 ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1
94 0.0067 0.0067050457000732
SELECT DISTINCT (p.id), salesrank, price, linktitle,
          'product' AS type
          FROM products p 
		WHERE ((description LIKE '%easehold%') OR (keyfeatures LIKE '%easehold%') OR (title LIKE '%easehold%') OR (description LIKE '%bote%') OR (keyfeatures LIKE '%bote%') OR (title LIKE '%bote%') OR (description LIKE '%cafe%') OR (keyfeatures LIKE '%cafe%') OR (title LIKE '%cafe%') OR (description LIKE '%hermetique%') OR (keyfeatures LIKE '%hermetique%') OR (title LIKE '%hermetique%') OR (description LIKE '%botes%') OR (keyfeatures LIKE '%botes%') OR (title LIKE '%botes%') OR (description LIKE '%et%') OR (keyfeatures LIKE '%et%') OR (title LIKE '%et%') OR (description LIKE '%coffrets%') OR (keyfeatures LIKE '%coffrets%') OR (title LIKE '%coffrets%') OR (description LIKE '%the%') OR (keyfeatures LIKE '%the%') OR (title LIKE '%the%') OR (description LIKE '%et%') OR (keyfeatures LIKE '%et%') OR (title LIKE '%et%') OR (description LIKE '%cafe%') OR (keyfeatures LIKE '%cafe%') OR (title LIKE '%cafe%'))

		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1
95 0.0003 0.00031518936157227
SELECT DISTINCT (p.id), price, linktitle,
          'ebayproduct' AS type
          FROM ebay_products p 
		WHERE ((description LIKE '%easehold%') OR (title LIKE '%easehold%') OR (description LIKE '%bote%') OR (title LIKE '%bote%') OR (description LIKE '%cafe%') OR (title LIKE '%cafe%') OR (description LIKE '%hermetique%') OR (title LIKE '%hermetique%') OR (description LIKE '%botes%') OR (title LIKE '%botes%') OR (description LIKE '%et%') OR (title LIKE '%et%') OR (description LIKE '%coffrets%') OR (title LIKE '%coffrets%') OR (description LIKE '%the%') OR (title LIKE '%the%') OR (description LIKE '%et%') OR (title LIKE '%et%') OR (description LIKE '%cafe%') OR (title LIKE '%cafe%'))
		AND hide = 0
96 0.0003 0.00025796890258789
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE '%easehold%') OR (title LIKE '%easehold%') OR (description LIKE '%bote%') OR (title LIKE '%bote%') OR (description LIKE '%cafe%') OR (title LIKE '%cafe%') OR (description LIKE '%hermetique%') OR (title LIKE '%hermetique%') OR (description LIKE '%botes%') OR (title LIKE '%botes%') OR (description LIKE '%et%') OR (title LIKE '%et%') OR (description LIKE '%coffrets%') OR (title LIKE '%coffrets%') OR (description LIKE '%the%') OR (title LIKE '%the%') OR (description LIKE '%et%') OR (title LIKE '%et%') OR (description LIKE '%cafe%') OR (title LIKE '%cafe%'))
		AND hide = 0
97 0.0003 0.00034594535827637
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (title)
    AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (title) AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' 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 ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe'), 'bundle' AS type FROM bundles b
		WHERE MATCH (title) AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
98 0.0003 0.00032687187194824
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' 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 ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
99 0.0040 0.0039598941802979
SELECT DISTINCT (p.id), salesrank, price, linktitle,
          'product' AS type
          FROM products p 
		WHERE ((description LIKE 'easehold') OR (keyfeatures LIKE 'easehold') OR (title LIKE 'easehold') OR (description LIKE 'bote') OR (keyfeatures LIKE 'bote') OR (title LIKE 'bote') OR (description LIKE 'cafe') OR (keyfeatures LIKE 'cafe') OR (title LIKE 'cafe') OR (description LIKE 'hermetique') OR (keyfeatures LIKE 'hermetique') OR (title LIKE 'hermetique') OR (description LIKE 'botes') OR (keyfeatures LIKE 'botes') OR (title LIKE 'botes') OR (description LIKE 'et') OR (keyfeatures LIKE 'et') OR (title LIKE 'et') OR (description LIKE 'coffrets') OR (keyfeatures LIKE 'coffrets') OR (title LIKE 'coffrets') OR (description LIKE 'the') OR (keyfeatures LIKE 'the') OR (title LIKE 'the') OR (description LIKE 'et') OR (keyfeatures LIKE 'et') OR (title LIKE 'et') OR (description LIKE 'cafe') OR (keyfeatures LIKE 'cafe') OR (title LIKE 'cafe'))

		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
100 0.0003 0.00025701522827148
SELECT DISTINCT (p.id), price, linktitle,
          'ebayproduct' AS type
          FROM ebay_products p 
		WHERE ((description LIKE 'easehold') OR (title LIKE 'easehold') OR (description LIKE 'bote') OR (title LIKE 'bote') OR (description LIKE 'cafe') OR (title LIKE 'cafe') OR (description LIKE 'hermetique') OR (title LIKE 'hermetique') OR (description LIKE 'botes') OR (title LIKE 'botes') OR (description LIKE 'et') OR (title LIKE 'et') OR (description LIKE 'coffrets') OR (title LIKE 'coffrets') OR (description LIKE 'the') OR (title LIKE 'the') OR (description LIKE 'et') OR (title LIKE 'et') OR (description LIKE 'cafe') OR (title LIKE 'cafe'))
		AND hide = 0
101 0.0003 0.00025486946105957
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE 'easehold') OR (title LIKE 'easehold') OR (description LIKE 'bote') OR (title LIKE 'bote') OR (description LIKE 'cafe') OR (title LIKE 'cafe') OR (description LIKE 'hermetique') OR (title LIKE 'hermetique') OR (description LIKE 'botes') OR (title LIKE 'botes') OR (description LIKE 'et') OR (title LIKE 'et') OR (description LIKE 'coffrets') OR (title LIKE 'coffrets') OR (description LIKE 'the') OR (title LIKE 'the') OR (description LIKE 'et') OR (title LIKE 'et') OR (description LIKE 'cafe') OR (title LIKE 'cafe'))
		AND hide = 0
102 0.0003 0.00032401084899902
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' 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 ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+easehold +bote +cafe +hermetique +bot} +et +coffre} +the +et +cafe' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
103 0.0067 0.0066530704498291
SELECT DISTINCT (p.id), salesrank, price, linktitle,
          'product' AS type
          FROM products p 
		WHERE ((description LIKE '%easehold%') OR (keyfeatures LIKE '%easehold%') OR (title LIKE '%easehold%') OR (description LIKE '%bote%') OR (keyfeatures LIKE '%bote%') OR (title LIKE '%bote%') OR (description LIKE '%cafe%') OR (keyfeatures LIKE '%cafe%') OR (title LIKE '%cafe%') OR (description LIKE '%hermetique%') OR (keyfeatures LIKE '%hermetique%') OR (title LIKE '%hermetique%') OR (description LIKE '%botes%') OR (keyfeatures LIKE '%botes%') OR (title LIKE '%botes%') OR (description LIKE '%et%') OR (keyfeatures LIKE '%et%') OR (title LIKE '%et%') OR (description LIKE '%coffrets%') OR (keyfeatures LIKE '%coffrets%') OR (title LIKE '%coffrets%') OR (description LIKE '%the%') OR (keyfeatures LIKE '%the%') OR (title LIKE '%the%') OR (description LIKE '%et%') OR (keyfeatures LIKE '%et%') OR (title LIKE '%et%') OR (description LIKE '%cafe%') OR (keyfeatures LIKE '%cafe%') OR (title LIKE '%cafe%'))

		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
104 0.0003 0.00027012825012207
SELECT DISTINCT (p.id), price, linktitle,
          'ebayproduct' AS type
          FROM ebay_products p 
		WHERE ((description LIKE '%easehold%') OR (title LIKE '%easehold%') OR (description LIKE '%bote%') OR (title LIKE '%bote%') OR (description LIKE '%cafe%') OR (title LIKE '%cafe%') OR (description LIKE '%hermetique%') OR (title LIKE '%hermetique%') OR (description LIKE '%botes%') OR (title LIKE '%botes%') OR (description LIKE '%et%') OR (title LIKE '%et%') OR (description LIKE '%coffrets%') OR (title LIKE '%coffrets%') OR (description LIKE '%the%') OR (title LIKE '%the%') OR (description LIKE '%et%') OR (title LIKE '%et%') OR (description LIKE '%cafe%') OR (title LIKE '%cafe%'))
		AND hide = 0
105 0.0002 0.00023603439331055
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE '%easehold%') OR (title LIKE '%easehold%') OR (description LIKE '%bote%') OR (title LIKE '%bote%') OR (description LIKE '%cafe%') OR (title LIKE '%cafe%') OR (description LIKE '%hermetique%') OR (title LIKE '%hermetique%') OR (description LIKE '%botes%') OR (title LIKE '%botes%') OR (description LIKE '%et%') OR (title LIKE '%et%') OR (description LIKE '%coffrets%') OR (title LIKE '%coffrets%') OR (description LIKE '%the%') OR (title LIKE '%the%') OR (description LIKE '%et%') OR (title LIKE '%et%') OR (description LIKE '%cafe%') OR (title LIKE '%cafe%'))
		AND hide = 0
106 0.0003 0.00029492378234863
SELECT * FROM products WHERE id = '1056'
107 0.0009 0.0008549690246582
SELECT * FROM productimages WHERE product_id = '1056' ORDER BY sortorder ASC
108 0.0008 0.00078105926513672
SELECT * FROM product_image_select WHERE product_id = '1056'
109 0.0006 0.00062179565429688
SELECT * FROM productcustomimages WHERE product_id = '1056'
110 0.0010 0.0010309219360352
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1056' AND a.name = n.originalname
111 0.0007 0.00071811676025391
SELECT * FROM productoffers WHERE product_id = '1056' AND merchantid = 'A1X6FK5RDHNB96'
112 0.0003 0.00027108192443848
SELECT * FROM productoffers
                WHERE product_id = '1056' AND price > 0
                ORDER BY price ASC LIMIT 1
113 0.0003 0.00033116340637207
SELECT value FROM productattributes WHERE product_id = '1056' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
114 0.0003 0.00032877922058105
SELECT * FROM products WHERE id = '3829'
115 0.0003 0.00030207633972168
SELECT * FROM productimages WHERE product_id = '3829' ORDER BY sortorder ASC
116 0.0004 0.00043296813964844
SELECT * FROM product_image_select WHERE product_id = '3829'
117 0.0003 0.00028610229492188
SELECT * FROM productcustomimages WHERE product_id = '3829'
118 0.0006 0.00056910514831543
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3829' AND a.name = n.originalname
119 0.0003 0.0003058910369873
SELECT * FROM productoffers WHERE product_id = '3829' AND merchantid = 'A1X6FK5RDHNB96'
120 0.0003 0.0002601146697998
SELECT * FROM productoffers
                WHERE product_id = '3829' AND price > 0
                ORDER BY price ASC LIMIT 1
121 0.0002 0.00024008750915527
SELECT * FROM productoffers
                WHERE product_id = 3829
                ORDER BY price ASC LIMIT 1
122 0.0002 0.00024986267089844
SELECT value FROM productattributes
                WHERE product_id = '3829'
                AND name = 'ListPriceAmount'
123 0.0003 0.00028610229492188
SELECT value FROM productattributes WHERE product_id = '3829' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
124 0.0003 0.0003199577331543
SELECT * FROM products WHERE id = '3551'
125 0.0003 0.00030899047851562
SELECT * FROM productimages WHERE product_id = '3551' ORDER BY sortorder ASC
126 0.0003 0.00033116340637207
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3551' AND p.id = pi.product_id ORDER BY pi.sortorder
127 0.0004 0.00043606758117676
SELECT * FROM product_image_select WHERE product_id = '3551'
128 0.0003 0.00029706954956055
SELECT * FROM productcustomimages WHERE product_id = '3551'
129 0.0004 0.00041294097900391
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '3551'
                GROUP BY o.product_id
130 0.0013 0.0012810230255127
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '3551'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
131 0.0003 0.0003359317779541
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3551
132 0.0006 0.0005650520324707
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3551' AND a.name = n.originalname
133 0.0002 0.00024008750915527
SELECT * FROM productoffers WHERE product_id = '3551' AND merchantid = 'A1X6FK5RDHNB96'
134 0.0003 0.00027608871459961
SELECT * FROM productoffers
                WHERE product_id = '3551' AND price > 0
                ORDER BY price ASC LIMIT 1
135 0.0003 0.00029587745666504
SELECT * FROM productoffers
                WHERE product_id = 3551
                ORDER BY price ASC LIMIT 1
136 0.0003 0.00025701522827148
SELECT value FROM productattributes
                WHERE product_id = '3551'
                AND name = 'ListPriceAmount'
137 0.0003 0.00027680397033691
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '3551'
                GROUP BY o.product_id
138 0.0004 0.00043511390686035
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '3551'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
139 0.0003 0.00030207633972168
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3551
140 0.0004 0.00037384033203125
SELECT value FROM productattributes WHERE product_id = '3551' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
141 0.0004 0.00037789344787598
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3551'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
142 0.0003 0.00026488304138184
SELECT * FROM products WHERE id = '1501'
143 0.0003 0.00031208992004395
SELECT * FROM productimages WHERE product_id = '1501' ORDER BY sortorder ASC
144 0.0005 0.00046801567077637
SELECT * FROM product_image_select WHERE product_id = '1501'
145 0.0003 0.00027894973754883
SELECT * FROM productcustomimages WHERE product_id = '1501'
146 0.0007 0.00068807601928711
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1501' AND a.name = n.originalname
147 0.0003 0.00030398368835449
SELECT * FROM productoffers WHERE product_id = '1501' AND merchantid = 'A1X6FK5RDHNB96'
148 0.0003 0.0002589225769043
SELECT * FROM productoffers
                WHERE product_id = '1501' AND price > 0
                ORDER BY price ASC LIMIT 1
149 0.0002 0.00023603439331055
SELECT * FROM productoffers
                WHERE product_id = 1501
                ORDER BY price ASC LIMIT 1
150 0.0003 0.00026512145996094
SELECT value FROM productattributes
                WHERE product_id = '1501'
                AND name = 'ListPriceAmount'
151 0.0003 0.00027084350585938
SELECT value FROM productattributes WHERE product_id = '1501' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
152 0.0003 0.00034499168395996
SELECT * FROM products WHERE id = '3747'
153 0.0004 0.00035881996154785
SELECT * FROM productimages WHERE product_id = '3747' ORDER BY sortorder ASC
154 0.0005 0.00047206878662109
SELECT * FROM product_image_select WHERE product_id = '3747'
155 0.0003 0.0002739429473877
SELECT * FROM productcustomimages WHERE product_id = '3747'
156 0.0005 0.00054597854614258
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3747' AND a.name = n.originalname
157 0.0003 0.00031089782714844
SELECT * FROM productoffers WHERE product_id = '3747' AND merchantid = 'A1X6FK5RDHNB96'
158 0.0003 0.0003058910369873
SELECT * FROM productoffers
                WHERE product_id = '3747' AND price > 0
                ORDER BY price ASC LIMIT 1
159 0.0003 0.00026917457580566
SELECT value FROM productattributes WHERE product_id = '3747' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
160 0.0004 0.00039911270141602
SELECT * FROM products WHERE id = '1070'
161 0.0004 0.00038003921508789
SELECT * FROM productimages WHERE product_id = '1070' ORDER BY sortorder ASC
162 0.0004 0.00043106079101562
SELECT * FROM product_image_select WHERE product_id = '1070'
163 0.0003 0.00028800964355469
SELECT * FROM productcustomimages WHERE product_id = '1070'
164 0.0007 0.00072813034057617
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1070' AND a.name = n.originalname
165 0.0003 0.00034618377685547
SELECT * FROM productoffers WHERE product_id = '1070' AND merchantid = 'A1X6FK5RDHNB96'
166 0.0003 0.00027585029602051
SELECT * FROM productoffers
                WHERE product_id = '1070' AND price > 0
                ORDER BY price ASC LIMIT 1
167 0.0003 0.00029492378234863
SELECT value FROM productattributes WHERE product_id = '1070' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
168 0.0003 0.00032591819763184
SELECT * FROM products WHERE id = '1560'
169 0.0003 0.00031590461730957
SELECT * FROM productimages WHERE product_id = '1560' ORDER BY sortorder ASC
170 0.0005 0.0005030632019043
SELECT * FROM product_image_select WHERE product_id = '1560'
171 0.0003 0.00028610229492188
SELECT * FROM productcustomimages WHERE product_id = '1560'
172 0.0009 0.00090408325195312
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1560' AND a.name = n.originalname
173 0.0004 0.00035309791564941
SELECT * FROM productoffers WHERE product_id = '1560' AND merchantid = 'A1X6FK5RDHNB96'
174 0.0003 0.00029301643371582
SELECT * FROM productoffers
                WHERE product_id = '1560' AND price > 0
                ORDER BY price ASC LIMIT 1
175 0.0003 0.00030708312988281
SELECT value FROM productattributes WHERE product_id = '1560' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
176 0.0004 0.00036811828613281
SELECT * FROM products WHERE id = '3515'
177 0.0003 0.00033903121948242
SELECT * FROM productimages WHERE product_id = '3515' ORDER BY sortorder ASC
178 0.0005 0.00045204162597656
SELECT * FROM product_image_select WHERE product_id = '3515'
179 0.0003 0.0003209114074707
SELECT * FROM productcustomimages WHERE product_id = '3515'
180 0.0006 0.00056195259094238
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3515' AND a.name = n.originalname
181 0.0003 0.00031304359436035
SELECT * FROM productoffers WHERE product_id = '3515' AND merchantid = 'A1X6FK5RDHNB96'
182 0.0002 0.00024914741516113
SELECT * FROM productoffers
                WHERE product_id = '3515' AND price > 0
                ORDER BY price ASC LIMIT 1
183 0.0002 0.00023293495178223
SELECT * FROM productoffers
                WHERE product_id = 3515
                ORDER BY price ASC LIMIT 1
184 0.0002 0.00024819374084473
SELECT value FROM productattributes
                WHERE product_id = '3515'
                AND name = 'ListPriceAmount'
185 0.0003 0.00027608871459961
SELECT value FROM productattributes WHERE product_id = '3515' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
186 0.0003 0.0003349781036377
SELECT * FROM products WHERE id = '4920'
187 0.0003 0.00030899047851562
SELECT * FROM productimages WHERE product_id = '4920' ORDER BY sortorder ASC
188 0.0004 0.00044798851013184
SELECT * FROM product_image_select WHERE product_id = '4920'
189 0.0003 0.00026702880859375
SELECT * FROM productcustomimages WHERE product_id = '4920'
190 0.0008 0.00078296661376953
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4920' AND a.name = n.originalname
191 0.0003 0.00031399726867676
SELECT * FROM productoffers WHERE product_id = '4920' AND merchantid = 'A1X6FK5RDHNB96'
192 0.0003 0.00025105476379395
SELECT * FROM productoffers
                WHERE product_id = '4920' AND price > 0
                ORDER BY price ASC LIMIT 1
193 0.0002 0.00024199485778809
SELECT * FROM productoffers
                WHERE product_id = 4920
                ORDER BY price ASC LIMIT 1
194 0.0003 0.00025200843811035
SELECT value FROM productattributes
                WHERE product_id = '4920'
                AND name = 'ListPriceAmount'
195 0.0003 0.00027704238891602
SELECT value FROM productattributes WHERE product_id = '4920' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
196 0.0003 0.00034093856811523
SELECT * FROM products WHERE id = '2746'
197 0.0004 0.00036215782165527
SELECT * FROM productimages WHERE product_id = '2746' ORDER BY sortorder ASC
198 0.0004 0.00043916702270508
SELECT * FROM product_image_select WHERE product_id = '2746'
199 0.0003 0.00026702880859375
SELECT * FROM productcustomimages WHERE product_id = '2746'
200 0.0007 0.00072002410888672
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2746' AND a.name = n.originalname
201 0.0003 0.00032806396484375
SELECT * FROM productoffers WHERE product_id = '2746' AND merchantid = 'A1X6FK5RDHNB96'
202 0.0003 0.00029587745666504
SELECT * FROM productoffers
                WHERE product_id = '2746' AND price > 0
                ORDER BY price ASC LIMIT 1
203 0.0003 0.00027012825012207
SELECT value FROM productattributes WHERE product_id = '2746' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
204 0.0003 0.0003349781036377
SELECT * FROM products WHERE id = '1486'
205 0.0003 0.00031399726867676
SELECT * FROM productimages WHERE product_id = '1486' ORDER BY sortorder ASC
206 0.0004 0.00044989585876465
SELECT * FROM product_image_select WHERE product_id = '1486'
207 0.0003 0.00027084350585938
SELECT * FROM productcustomimages WHERE product_id = '1486'
208 0.0007 0.0006861686706543
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1486' AND a.name = n.originalname
209 0.0003 0.00030803680419922
SELECT * FROM productoffers WHERE product_id = '1486' AND merchantid = 'A1X6FK5RDHNB96'
210 0.0003 0.00026106834411621
SELECT * FROM productoffers
                WHERE product_id = '1486' AND price > 0
                ORDER BY price ASC LIMIT 1
211 0.0003 0.00026988983154297
SELECT value FROM productattributes WHERE product_id = '1486' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
212 0.0004 0.00035214424133301
SELECT * FROM products WHERE id = '3821'
213 0.0004 0.00043582916259766
SELECT * FROM productimages WHERE product_id = '3821' ORDER BY sortorder ASC
214 0.0003 0.00030994415283203
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3821' AND p.id = pi.product_id ORDER BY pi.sortorder
215 0.0004 0.0004420280456543
SELECT * FROM product_image_select WHERE product_id = '3821'
216 0.0003 0.00026798248291016
SELECT * FROM productcustomimages WHERE product_id = '3821'
217 0.0004 0.0003509521484375
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '3821'
                GROUP BY o.product_id
218 0.0004 0.00040793418884277
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '3821'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
219 0.0003 0.00026583671569824
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3821
220 0.0007 0.00068402290344238
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3821' AND a.name = n.originalname
221 0.0003 0.00026583671569824
SELECT * FROM productoffers WHERE product_id = '3821' AND merchantid = 'A1X6FK5RDHNB96'
222 0.0002 0.00024580955505371
SELECT * FROM productoffers
                WHERE product_id = '3821' AND price > 0
                ORDER BY price ASC LIMIT 1
223 0.0002 0.00023388862609863
SELECT * FROM productoffers
                WHERE product_id = 3821
                ORDER BY price ASC LIMIT 1
224 0.0003 0.00031208992004395
SELECT value FROM productattributes
                WHERE product_id = '3821'
                AND name = 'ListPriceAmount'
225 0.0003 0.00029802322387695
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '3821'
                GROUP BY o.product_id
226 0.0004 0.00042605400085449
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '3821'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
227 0.0003 0.0002901554107666
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3821
228 0.0004 0.00035977363586426
SELECT value FROM productattributes WHERE product_id = '3821' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
229 0.0004 0.00039911270141602
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3821'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
230 0.0003 0.00031518936157227
SELECT * FROM products WHERE id = '4313'
231 0.0004 0.00035715103149414
SELECT * FROM productimages WHERE product_id = '4313' ORDER BY sortorder ASC
232 0.0003 0.00026488304138184
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4313' AND p.id = pi.product_id ORDER BY pi.sortorder
233 0.0005 0.00045609474182129
SELECT * FROM product_image_select WHERE product_id = '4313'
234 0.0003 0.00027799606323242
SELECT * FROM productcustomimages WHERE product_id = '4313'
235 0.0004 0.00038790702819824
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4313'
                GROUP BY o.product_id
236 0.0004 0.00039386749267578
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4313'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
237 0.0003 0.00025796890258789
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4313
238 0.0007 0.00065493583679199
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4313' AND a.name = n.originalname
239 0.0003 0.00025796890258789
SELECT * FROM productoffers WHERE product_id = '4313' AND merchantid = 'A1X6FK5RDHNB96'
240 0.0003 0.00025510787963867
SELECT * FROM productoffers
                WHERE product_id = '4313' AND price > 0
                ORDER BY price ASC LIMIT 1
241 0.0002 0.00024008750915527
SELECT * FROM productoffers
                WHERE product_id = 4313
                ORDER BY price ASC LIMIT 1
242 0.0003 0.00026297569274902
SELECT value FROM productattributes
                WHERE product_id = '4313'
                AND name = 'ListPriceAmount'
243 0.0003 0.00026893615722656
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4313'
                GROUP BY o.product_id
244 0.0004 0.00038599967956543
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4313'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
245 0.0003 0.00025391578674316
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4313
246 0.0003 0.00026798248291016
SELECT * FROM products WHERE parent_id = '4313'
247 0.0003 0.00030708312988281
SELECT * FROM products WHERE id = '922'
248 0.0004 0.00035405158996582
SELECT * FROM productimages WHERE product_id = '922' ORDER BY sortorder ASC
249 0.0006 0.00055503845214844
SELECT * FROM product_image_select WHERE product_id = '922'
250 0.0003 0.00032401084899902
SELECT * FROM productcustomimages WHERE product_id = '922'
251 0.0008 0.00079083442687988
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '922' AND a.name = n.originalname
252 0.0003 0.00032305717468262
SELECT * FROM productoffers WHERE product_id = '922' AND merchantid = 'A1X6FK5RDHNB96'
253 0.0003 0.00027298927307129
SELECT * FROM productoffers
                WHERE product_id = '922' AND price > 0
                ORDER BY price ASC LIMIT 1
254 0.0002 0.00023794174194336
SELECT * FROM productoffers
                WHERE product_id = 922
                ORDER BY price ASC LIMIT 1
255 0.0003 0.00026702880859375
SELECT value FROM productattributes
                WHERE product_id = '922'
                AND name = 'ListPriceAmount'
256 0.0003 0.00028204917907715
SELECT value FROM productattributes WHERE product_id = '922' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
257 0.0004 0.00036883354187012
SELECT * FROM products WHERE id = '1670'
258 0.0004 0.00038909912109375
SELECT * FROM productimages WHERE product_id = '1670' ORDER BY sortorder ASC
259 0.0004 0.00044679641723633
SELECT * FROM product_image_select WHERE product_id = '1670'
260 0.0003 0.00027894973754883
SELECT * FROM productcustomimages WHERE product_id = '1670'
261 0.0006 0.00055217742919922
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1670' AND a.name = n.originalname
262 0.0003 0.00033092498779297
SELECT * FROM productoffers WHERE product_id = '1670' AND merchantid = 'A1X6FK5RDHNB96'
263 0.0003 0.00026392936706543
SELECT * FROM productoffers
                WHERE product_id = '1670' AND price > 0
                ORDER BY price ASC LIMIT 1
264 0.0002 0.00023984909057617
SELECT * FROM productoffers
                WHERE product_id = 1670
                ORDER BY price ASC LIMIT 1
265 0.0003 0.00025105476379395
SELECT value FROM productattributes
                WHERE product_id = '1670'
                AND name = 'ListPriceAmount'
266 0.0003 0.00027799606323242
SELECT value FROM productattributes WHERE product_id = '1670' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
267 0.0003 0.00034594535827637
SELECT * FROM products WHERE id = '936'
268 0.0003 0.00033879280090332
SELECT * FROM productimages WHERE product_id = '936' ORDER BY sortorder ASC
269 0.0005 0.00049591064453125
SELECT * FROM product_image_select WHERE product_id = '936'
270 0.0003 0.00028395652770996
SELECT * FROM productcustomimages WHERE product_id = '936'
271 0.0006 0.00063300132751465
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '936' AND a.name = n.originalname
272 0.0003 0.00031709671020508
SELECT * FROM productoffers WHERE product_id = '936' AND merchantid = 'A1X6FK5RDHNB96'
273 0.0003 0.0002899169921875
SELECT * FROM productoffers
                WHERE product_id = '936' AND price > 0
                ORDER BY price ASC LIMIT 1
274 0.0003 0.00028491020202637
SELECT value FROM productattributes WHERE product_id = '936' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
275 0.0004 0.00035190582275391
SELECT * FROM products WHERE id = '1655'
276 0.0003 0.00031495094299316
SELECT * FROM productimages WHERE product_id = '1655' ORDER BY sortorder ASC
277 0.0005 0.00047111511230469
SELECT * FROM product_image_select WHERE product_id = '1655'
278 0.0003 0.00028491020202637
SELECT * FROM productcustomimages WHERE product_id = '1655'
279 0.0006 0.00064706802368164
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1655' AND a.name = n.originalname
280 0.0003 0.0003349781036377
SELECT * FROM productoffers WHERE product_id = '1655' AND merchantid = 'A1X6FK5RDHNB96'
281 0.0003 0.00026488304138184
SELECT * FROM productoffers
                WHERE product_id = '1655' AND price > 0
                ORDER BY price ASC LIMIT 1
282 0.0003 0.00025510787963867
SELECT * FROM productoffers
                WHERE product_id = 1655
                ORDER BY price ASC LIMIT 1
283 0.0003 0.00027084350585938
SELECT value FROM productattributes
                WHERE product_id = '1655'
                AND name = 'ListPriceAmount'
284 0.0003 0.00029516220092773
SELECT value FROM productattributes WHERE product_id = '1655' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
285 0.0004 0.00040102005004883
SELECT * FROM products WHERE id = '4760'
286 0.0004 0.00037002563476562
SELECT * FROM productimages WHERE product_id = '4760' ORDER BY sortorder ASC
287 0.0003 0.00033116340637207
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4760' AND p.id = pi.product_id ORDER BY pi.sortorder
288 0.0005 0.00046205520629883
SELECT * FROM product_image_select WHERE product_id = '4760'
289 0.0003 0.00028109550476074
SELECT * FROM productcustomimages WHERE product_id = '4760'
290 0.0004 0.00044798851013184
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4760'
                GROUP BY o.product_id
291 0.0005 0.00045108795166016
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4760'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
292 0.0003 0.00029397010803223
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4760
293 0.0006 0.00057387351989746
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4760' AND a.name = n.originalname
294 0.0003 0.00026106834411621
SELECT * FROM productoffers WHERE product_id = '4760' AND merchantid = 'A1X6FK5RDHNB96'
295 0.0003 0.00026297569274902
SELECT * FROM productoffers
                WHERE product_id = '4760' AND price > 0
                ORDER BY price ASC LIMIT 1
296 0.0002 0.00024700164794922
SELECT * FROM productoffers
                WHERE product_id = 4760
                ORDER BY price ASC LIMIT 1
297 0.0003 0.0002601146697998
SELECT value FROM productattributes
                WHERE product_id = '4760'
                AND name = 'ListPriceAmount'
298 0.0003 0.00029993057250977
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4760'
                GROUP BY o.product_id
299 0.0005 0.00045204162597656
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4760'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
300 0.0003 0.00029301643371582
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4760
301 0.0004 0.00042295455932617
SELECT value FROM productattributes WHERE product_id = '4760' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
302 0.0004 0.00041794776916504
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4760'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Style'
                GROUP BY o.value
                ORDER BY o.value ASC
303 0.0009 0.00085687637329102
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1056' ORDER BY timestamp DESC
304 0.0002 0.00024700164794922
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3829' ORDER BY timestamp DESC
305 0.0002 0.00023102760314941
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3551' ORDER BY timestamp DESC
306 0.0002 0.00022411346435547
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1501' ORDER BY timestamp DESC
307 0.0002 0.00021982192993164
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3747' ORDER BY timestamp DESC
308 0.0002 0.00021100044250488
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1070' ORDER BY timestamp DESC
309 0.0002 0.00021004676818848
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1560' ORDER BY timestamp DESC
310 0.0002 0.00021719932556152
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3515' ORDER BY timestamp DESC
311 0.0002 0.00023007392883301
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4920' ORDER BY timestamp DESC
312 0.0002 0.00021791458129883
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2746' ORDER BY timestamp DESC
313 0.0002 0.00022006034851074
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1486' ORDER BY timestamp DESC
314 0.0002 0.00024700164794922
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3821' ORDER BY timestamp DESC
315 0.0002 0.00022482872009277
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4313' ORDER BY timestamp DESC
316 0.0002 0.00023412704467773
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '922' ORDER BY timestamp DESC
317 0.0002 0.00022697448730469
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1670' ORDER BY timestamp DESC
318 0.0002 0.00022411346435547
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '936' ORDER BY timestamp DESC
319 0.0003 0.00027298927307129
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1655' ORDER BY timestamp DESC
320 0.0002 0.00022315979003906
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4760' ORDER BY timestamp DESC
321 0.0008 0.00080609321594238
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
322 0.0006 0.00062990188598633
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
323 0.0003 0.00029301643371582
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
324 0.0122 0.012166976928711
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
325 0.0008 0.00081801414489746
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
326 0.0004 0.00035190582275391
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
327 0.0003 0.00034499168395996
SELECT * FROM products WHERE id = 1626
328 0.0006 0.00055909156799316
SELECT * FROM products WHERE id = 4041
329 0.0007 0.00068187713623047
SELECT * FROM products WHERE id = 4312
330 0.0003 0.00027012825012207
SELECT * FROM products WHERE id = 777
331 0.0004 0.00040102005004883
SELECT * FROM products WHERE id = 3881
332 0.0007 0.00073504447937012
SELECT * FROM products WHERE id = 4213
333 0.0006 0.0005791187286377
SELECT * FROM products WHERE id = '1626'
334 0.0007 0.00065398216247559
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
335 0.0004 0.00044393539428711
SELECT * FROM product_image_select WHERE product_id = '1626'
336 0.0005 0.00049591064453125
SELECT * FROM productcustomimages WHERE product_id = '1626'
337 0.0008 0.0008091926574707
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
338 0.0004 0.0003809928894043
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
339 0.0005 0.00052118301391602
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
340 0.0004 0.00042891502380371
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
341 0.0004 0.00035715103149414
SELECT * FROM products WHERE id = '4041'
342 0.0006 0.00058794021606445
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
343 0.0011 0.0010800361633301
SELECT * FROM product_image_select WHERE product_id = '4041'
344 0.0013 0.0013329982757568
SELECT * FROM productcustomimages WHERE product_id = '4041'
345 0.0017 0.0017108917236328
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
346 0.0006 0.00062990188598633
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
347 0.0005 0.00047898292541504
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
348 0.0005 0.00049901008605957
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
349 0.0007 0.00067615509033203
SELECT * FROM products WHERE id = '4312'
350 0.0006 0.00057101249694824
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
351 0.0009 0.00089788436889648
SELECT * FROM product_image_select WHERE product_id = '4312'
352 0.0005 0.00046992301940918
SELECT * FROM productcustomimages WHERE product_id = '4312'
353 0.0014 0.0014231204986572
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
354 0.0006 0.00063490867614746
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
355 0.0004 0.00044703483581543
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
356 0.0005 0.00047016143798828
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
357 0.0006 0.00057792663574219
SELECT * FROM products WHERE id = '777'
358 0.0006 0.00058412551879883
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
359 0.0009 0.00087499618530273
SELECT * FROM product_image_select WHERE product_id = '777'
360 0.0005 0.00045108795166016
SELECT * FROM productcustomimages WHERE product_id = '777'
361 0.0014 0.0014288425445557
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
362 0.0006 0.00056290626525879
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
363 0.0004 0.00043702125549316
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
364 0.0005 0.00046896934509277
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
365 0.0006 0.00057387351989746
SELECT * FROM products WHERE id = '3881'
366 0.0007 0.00072789192199707
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
367 0.0009 0.00087904930114746
SELECT * FROM product_image_select WHERE product_id = '3881'
368 0.0005 0.00046992301940918
SELECT * FROM productcustomimages WHERE product_id = '3881'
369 0.0014 0.00142502784729
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
370 0.0006 0.0005500316619873
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
371 0.0004 0.00043892860412598
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
372 0.0005 0.00047492980957031
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
373 0.0006 0.00058197975158691
SELECT * FROM products WHERE id = '4213'
374 0.0009 0.00087404251098633
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
375 0.0009 0.00089311599731445
SELECT * FROM product_image_select WHERE product_id = '4213'
376 0.0005 0.0004889965057373
SELECT * FROM productcustomimages WHERE product_id = '4213'
377 0.0015 0.0015320777893066
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
378 0.0006 0.00059008598327637
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
379 0.0005 0.00045490264892578
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
380 0.0005 0.00047492980957031
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
381 0.0024 0.002424955368042
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
382 0.0010 0.00096487998962402
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
383 0.0033 0.0033249855041504
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
384 0.0017 0.0017130374908447
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
385 0.0007 0.00073099136352539
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
386 0.0007 0.00071382522583008
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
387 0.0004 0.00042390823364258
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'