0
  1. My Store
  2. Thés verts

Thés verts

Browse Categories

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.

no thanks

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.6471531391144 318 1.2668 0


No Amazon API Requests Made.


App Debug - Total Time 1.6471531391144 seconds

Number Time From Start Name Description
1 0.26422214508057 Initialise Initialise FSB Function
2 0.27496600151062 App Controller Start Start of the App controller (called before the controller of every page)
3 1.2332971096039 App Controller End End of the App controller (called before the controller of every page)
4 1.2337980270386 Category Start Start of the category controller
5 1.2338011264801 Before Get Category Before getting the category information
6 1.2528059482574 After Get Category After getting the category information
7 1.2528071403503 Before Get Category List Before getting the updated category list
8 1.2530810832977 Start of getCategoryListByGroup Function Before first category groups query
9 1.2533631324768 After initial query Before first category groups query
10 1.2533640861511 Get Category List for Group Before the call to getCategoryList function
11 1.2533659934998 Start of GetCategoryList function Start of the function
12 1.253368139267 Before getting categories Query to get specific category list
13 1.2537331581116 After getting categories Query to get specific category list
14 1.2537341117859 Before getting category custom Before call to function getCategoryCustom
15 1.2680721282959 After getting category custom After call to function getCategoryCustom
16 1.2680749893188 Before getting category custom Before call to function getCategoryCustom
17 1.2824809551239 After getting category custom After call to function getCategoryCustom
18 1.2824950218201 Before getting category custom Before call to function getCategoryCustom
19 1.2904741764069 After getting category custom After call to function getCategoryCustom
20 1.2904760837555 Before getting sub category list Before call to recursive function getCategoryList
21 1.2904779911041 Start of GetCategoryList function Start of the function
22 1.2904789447784 Before getting categories Query to get specific category list
23 1.2909569740295 After getting sub category list After call to recursive function getCategoryList
24 1.2909581661224 Before getting category custom Before call to function getCategoryCustom
25 1.2962989807129 After getting category custom After call to function getCategoryCustom
26 1.2963011264801 Before getting category custom Before call to function getCategoryCustom
27 1.3018431663513 After getting category custom After call to function getCategoryCustom
28 1.3018450737 Before getting category custom Before call to function getCategoryCustom
29 1.3066830635071 After getting category custom After call to function getCategoryCustom
30 1.3066849708557 End of GetCategoryList function End of the function
31 1.3066899776459 Get Category List for Group Before the call to getCategoryList function
32 1.3066911697388 Start of GetCategoryList function Start of the function
33 1.3066921234131 Before getting categories Query to get specific category list
34 1.3072290420532 End of getCategoryListByGroup Function Before return()
35 1.3072309494019 After Get Category List After getting the updated category list
36 1.3072309494019 Before Category Images Before getting the category images
37 1.3076519966125 After Category Images After getting the category images
38 1.3100020885468 Before Sub Category Check Before checking for sub category or products category
39 1.3105020523071 Before Category Products Controller Before loading the category products controller
40 1.3112480640411 Start Category Products Start of Category Products Controller
41 1.3112659454346 After Pagination Options After pagination options in Category Products Controller
42 1.338485956192 After Cache After Cache checking in Category Products Controller
43 1.3621370792389 After Filter Options After getting filter options and SQL in Category Products Controller
44 1.3648610115051 After Counting Products After counting products in the Category Products Controller
45 1.3654460906982 After Counting Bundles After counting bundles in the Category Products Controller
46 1.3660280704498 After Counting Products After counting products in the Category Products Controller
47 1.3691880702972 After Getting Products After getting products and bundles in the Category Products Controller
48 1.3692281246185 After Pagination Links After getting pagination listing links in the Category Products Controller
49 1.3692290782928 After Getting Bundle Details After getting full details for the bundles in the Category Products Controller
50 1.4764170646667 After Getting Product Details After getting full product details in the Category Products Controller
51 1.4827101230621 After Getting Product/Bundle Reviews After getting full product/bundle customer review in the Category Products Controller
52 1.4854860305786 App_after Controller Start Start of the App_after controller (called after the controller of every page)
53 1.4877171516418 Before Get Options Before the call to getOptions in the tpl class
54 1.5510070323944 After Get Options After the call to getOptions in the tpl class
55 1.5511441230774 App_after Controller End End of the App_after controller (called after the controller of every page)
56 1.5511691570282 Before Smarty Before passing everything over to Smarty in the Category Products Controller
57 1.6471390724182 After Loading sub/product controller After checking for sub category or products category and then loading the relevant controller
58 1.6471431255341 Finalizing debug Before the debug is output to the page.
59 1.6471519470215 End of App This is the end of the app logging, final timestamp


Query Debug - 318 Database Queries. Total time 1.2668 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0009 0.00094890594482422 
SELECT parameter, value FROM parameters
2 0.0046 0.004565954208374 
SELECT * FROM `bad_bots`
3 0.0003 0.00030303001403809 
SET time_zone = 'Europe/London'
4 0.0027 0.0026941299438477 
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0022 0.0022330284118652 
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"18.227.111.48\";}'
6 0.0024 0.0023651123046875 
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1743605821'
7 0.0023 0.002255916595459 
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0005 0.0004889965057373 
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0018 0.0018351078033447 
SELECT id FROM pages WHERE pagename = 'thes-verts' LIMIT 1
10 0.0021 0.002100944519043 
SELECT id FROM products WHERE pagename = 'thes-verts' AND hidden = 0 LIMIT 1
11 0.0020 0.0019559860229492 
SELECT id FROM ebay_products WHERE pagename = 'thes-verts'
12 0.0017 0.0016770362854004 
SELECT id FROM custom_products WHERE pagename = 'thes-verts'
13 0.0019 0.0018758773803711 
SELECT id FROM categories WHERE pagename = 'thes-verts' LIMIT 1
14 0.0026 0.0026400089263916 
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
15 0.0270 0.026954889297485 
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
16 0.0006 0.00060009956359863 
SELECT * FROM pages WHERE pagename = 'thes-verts'
17 0.0035 0.0035178661346436 
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
18 0.0019 0.0019271373748779 
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
19 0.0007 0.0006871223449707 
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
20 0.0021 0.0021169185638428 
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
21 0.0013 0.0012619495391846 
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
22 0.0011 0.0010759830474854 
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
23 0.9118 0.91175889968872 
SELECT * FROM ipgeocountries WHERE INET_ATON('18.227.111.48') >= INET_ATON(ip_start) AND INET_ATON('18.227.111.48') <= INET_ATON(ip_end)
24 0.0024 0.0023729801177979 
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
25 0.0013 0.0013430118560791 
SELECT * FROM countryredirects WHERE countrycode = 'US'
26 0.0005 0.00049495697021484 
SELECT * FROM categories WHERE pagename = 'thes-verts'
27 0.0025 0.0024988651275635 
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
28 0.0014 0.0013799667358398 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
29 0.0004 0.00042486190795898 
SELECT id FROM categories WHERE parent_id = '28'
30 0.0016 0.001615047454834 
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
31 0.0018 0.0017588138580322 
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
32 0.0006 0.0005800724029541 
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
33 0.0019 0.0018589496612549 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
34 0.0004 0.00044918060302734 
SELECT id FROM categories WHERE parent_id = '28'
35 0.0017 0.001662015914917 
SELECT p.id FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (28) AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
36 0.0017 0.0016839504241943 
SELECT * FROM productimages WHERE product_id = '868' ORDER BY sortorder ASC
37 0.0012 0.0012362003326416 
SELECT * FROM categoryimages WHERE category_id = 28
38 0.0012 0.0011608600616455 
SELECT * FROM categorygroups WHERE id = '1'
39 0.0016 0.0016279220581055 
SELECT MIN(p.price) as minprice, MAX(p.price) as maxprice
		FROM products p, products_categories c
		WHERE p.id = c.product_id
		  AND c.category_id = '28'
		  AND p.offers > 0
		  AND p.hidden = 0
		  AND p.enabled = 1
		  AND p.parent = 0
		  AND p.price > 0
40 0.0004 0.00039219856262207 
SELECT parent_id FROM categories WHERE id = '28'
41 0.0003 0.00026702880859375 
SELECT parent_id FROM categories WHERE id = '28'
42 0.0003 0.00027608871459961 
SELECT * FROM categorygroups ORDER BY sortorder ASC
43 0.0004 0.0003509521484375 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
44 0.0053 0.0053110122680664 
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
45 0.0005 0.00053715705871582 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
46 0.0003 0.00034499168395996 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
47 0.0004 0.00039792060852051 
SELECT id FROM categories WHERE parent_id = '26'
48 0.0057 0.005702018737793 
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
49 0.0006 0.00059890747070312 
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
50 0.0005 0.00049805641174316 
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
51 0.0004 0.00043797492980957 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
52 0.0004 0.00040483474731445 
SELECT * FROM categorygroups WHERE id = '1'
53 0.0050 0.0050308704376221 
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
54 0.0007 0.00067591667175293 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
55 0.0005 0.00045084953308105 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
56 0.0005 0.00054311752319336 
SELECT id FROM categories WHERE parent_id = '27'
57 0.0052 0.0051641464233398 
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
58 0.0007 0.0006861686706543 
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
59 0.0007 0.00066614151000977 
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
60 0.0007 0.00065779685974121 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
61 0.0004 0.00043916702270508 
SELECT * FROM categorygroups WHERE id = '1'
62 0.0018 0.0018448829650879 
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
63 0.0005 0.00053691864013672 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
64 0.0004 0.00043010711669922 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
65 0.0005 0.00051617622375488 
SELECT id FROM categories WHERE parent_id = '28'
66 0.0022 0.0022139549255371 
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
67 0.0006 0.00063514709472656 
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
68 0.0006 0.00062394142150879 
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
69 0.0006 0.00063014030456543 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
70 0.0005 0.00046205520629883 
SELECT * FROM categorygroups WHERE id = '1'
71 0.0005 0.0004730224609375 
SELECT * FROM categories WHERE parent_id = '28'  AND hidden = 0 ORDER BY sortorder ASC
72 0.0007 0.00074100494384766 
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
73 0.0005 0.00053095817565918 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
74 0.0004 0.00041985511779785 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
75 0.0005 0.00045990943908691 
SELECT id FROM categories WHERE parent_id = '29'
76 0.0010 0.0010080337524414 
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
77 0.0006 0.00056290626525879 
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
78 0.0006 0.00063705444335938 
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
79 0.0005 0.00049185752868652 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
80 0.0004 0.00041818618774414 
SELECT * FROM categorygroups WHERE id = '1'
81 0.0008 0.0007779598236084 
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
82 0.0006 0.0005500316619873 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
83 0.0005 0.00053095817565918 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
84 0.0005 0.0005490779876709 
SELECT id FROM categories WHERE parent_id = '30'
85 0.0009 0.00088906288146973 
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
86 0.0006 0.0006251335144043 
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
87 0.0006 0.00059008598327637 
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
88 0.0005 0.00051593780517578 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
89 0.0004 0.00044393539428711 
SELECT * FROM categorygroups WHERE id = '1'
90 0.0008 0.00077199935913086 
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
91 0.0006 0.00056600570678711 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
92 0.0004 0.00043082237243652 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
93 0.0004 0.00044703483581543 
SELECT id FROM categories WHERE parent_id = '31'
94 0.0008 0.0007929801940918 
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
95 0.0005 0.00046014785766602 
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
96 0.0005 0.00045418739318848 
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
97 0.0005 0.00045108795166016 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
98 0.0004 0.00041699409484863 
SELECT * FROM categorygroups WHERE id = '1'
99 0.0005 0.00053095817565918 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
100 0.0004 0.00041484832763672 
SELECT * FROM categoryimages WHERE category_id = 28
101 0.0023 0.0023128986358643 
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
102 0.0005 0.0004889965057373 
SELECT * FROM categories WHERE parent_id = '28'
103 0.0078 0.0077998638153076 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
104 0.0022 0.0022420883178711 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
105 0.0024 0.002377986907959 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
106 0.0083 0.0082769393920898 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
107 0.0020 0.0019769668579102 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
108 0.0007 0.00072097778320312 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
109 0.0021 0.0020959377288818 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
		WHERE p.id = c.product_id AND parent_id = 0
		AND c.category_id = 28
		AND (c.prod_type = '' OR c.prod_type = 'amz')
		AND hidden = 0
		AND enabled = 1
		
		AND 1 = 1
110 0.0006 0.00060200691223145 
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
		WHERE ep.id = c.product_id
		AND c.category_id = 28
		AND c.prod_type = 'ebay'
		AND hide = 0
111 0.0006 0.00057601928710938 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
			WHERE p.id = c.bundle_id AND parent_id = 0
			AND c.category_id = 28
			AND p.disabled = 0
			
			AND 1 = 1
112 0.0006 0.00057005882263184 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
		WHERE cp.id = c.product_id
		AND c.category_id = 28
		AND c.prod_type = 'custom'
		AND hide = 0
113 0.0031 0.00311279296875 
SELECT DISTINCT (p.id), IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank, p.price, p.linktitle, p.pagename, 'product' AS type FROM products p, products_categories c
			WHERE p.id = c.product_id
			AND p.parent_id = 0
			AND c.category_id = 28
			AND hidden = 0
			AND enabled = 1
			
			AND 1 = 1 UNION SELECT DISTINCT (p.id), IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank, p.price, p.linktitle, p.pagename, 'ebay' AS type FROM ebay_products p, products_categories c
		WHERE p.id = c.product_id
		AND c.category_id = 28
		AND c.prod_type = 'ebay'
		AND p.hide = 0 UNION SELECT DISTINCT (p.id), IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank, p.price, p.linktitle, p.pagename, 'custom' AS type FROM custom_products p, products_categories c
		WHERE p.id = c.product_id
		AND c.category_id = 28
		AND c.prod_type = 'custom'
		AND p.hide = 0 UNION SELECT DISTINCT (p.id), IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank, p.price, p.linktitle, p.pagename, 'bundle' AS type FROM bundles p, bundle_categories c
			WHERE p.id = c.bundle_id
			AND c.category_id = 28
			AND disabled = 0
			
			AND 1 = 1 ORDER BY salesrank ASC LIMIT 54, 18
114 0.0006 0.00056695938110352 
SELECT * FROM products WHERE id = '1112'
115 0.0006 0.00058317184448242 
SELECT * FROM productimages WHERE product_id = '1112' ORDER BY sortorder ASC
116 0.0019 0.0019378662109375 
SELECT * FROM product_image_select WHERE product_id = '1112'
117 0.0017 0.0017318725585938 
SELECT * FROM productcustomimages WHERE product_id = '1112'
118 0.0021 0.0020918846130371 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1112' AND a.name = n.originalname
119 0.0017 0.0016870498657227 
SELECT * FROM productoffers WHERE product_id = '1112' AND merchantid = 'A1X6FK5RDHNB96'
120 0.0005 0.00054788589477539 
SELECT * FROM productoffers
                WHERE product_id = '1112' AND price > 0
                ORDER BY price ASC LIMIT 1
121 0.0004 0.00042104721069336 
SELECT * FROM productoffers
                WHERE product_id = 1112
                ORDER BY price ASC LIMIT 1
122 0.0005 0.00049304962158203 
SELECT value FROM productattributes
                WHERE product_id = '1112'
                AND name = 'ListPriceAmount'
123 0.0006 0.00063705444335938 
SELECT value FROM productattributes WHERE product_id = '1112' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
124 0.0008 0.00077080726623535 
SELECT * FROM products WHERE id = '1138'
125 0.0004 0.00043892860412598 
SELECT * FROM productimages WHERE product_id = '1138' ORDER BY sortorder ASC
126 0.0005 0.00054216384887695 
SELECT * FROM product_image_select WHERE product_id = '1138'
127 0.0004 0.0003960132598877 
SELECT * FROM productcustomimages WHERE product_id = '1138'
128 0.0008 0.00079202651977539 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1138' AND a.name = n.originalname
129 0.0006 0.00055289268493652 
SELECT * FROM productoffers WHERE product_id = '1138' AND merchantid = 'A1X6FK5RDHNB96'
130 0.0005 0.00049901008605957 
SELECT * FROM productoffers
                WHERE product_id = '1138' AND price > 0
                ORDER BY price ASC LIMIT 1
131 0.0004 0.00041604042053223 
SELECT * FROM productoffers
                WHERE product_id = 1138
                ORDER BY price ASC LIMIT 1
132 0.0004 0.00043392181396484 
SELECT value FROM productattributes
                WHERE product_id = '1138'
                AND name = 'ListPriceAmount'
133 0.0005 0.00047612190246582 
SELECT value FROM productattributes WHERE product_id = '1138' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
134 0.0039 0.0038959980010986 
SELECT * FROM products WHERE id = '1227'
135 0.0024 0.0023791790008545 
SELECT * FROM productimages WHERE product_id = '1227' ORDER BY sortorder ASC
136 0.0023 0.0022668838500977 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1227' AND p.id = pi.product_id ORDER BY pi.sortorder
137 0.0015 0.0015420913696289 
SELECT * FROM product_image_select WHERE product_id = '1227'
138 0.0033 0.0033469200134277 
SELECT * FROM productcustomimages WHERE product_id = '1227'
139 0.0009 0.00092601776123047 
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 = '1227'
                GROUP BY o.product_id
140 0.0031 0.0031301975250244 
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     = '1227'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
141 0.0009 0.00091099739074707 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1227
142 0.0010 0.00097393989562988 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1227' AND a.name = n.originalname
143 0.0004 0.00041079521179199 
SELECT * FROM productoffers WHERE product_id = '1227' AND merchantid = 'A1X6FK5RDHNB96'
144 0.0004 0.00041890144348145 
SELECT * FROM productoffers
                WHERE product_id = '1227' AND price > 0
                ORDER BY price ASC LIMIT 1
145 0.0004 0.00039100646972656 
SELECT * FROM productoffers
                WHERE product_id = 1227
                ORDER BY price ASC LIMIT 1
146 0.0004 0.00044488906860352 
SELECT value FROM productattributes
                WHERE product_id = '1227'
                AND name = 'ListPriceAmount'
147 0.0044 0.0044181346893311 
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 = '1227'
                GROUP BY o.product_id
148 0.0007 0.00072503089904785 
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     = '1227'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
149 0.0005 0.0005190372467041 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1227
150 0.0005 0.00052094459533691 
SELECT value FROM productattributes WHERE product_id = '1227' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
151 0.0009 0.00093603134155273 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '1227'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
152 0.0005 0.00047683715820312 
SELECT * FROM products WHERE id = '1218'
153 0.0005 0.00051307678222656 
SELECT * FROM productimages WHERE product_id = '1218' ORDER BY sortorder ASC
154 0.0006 0.00061321258544922 
SELECT * FROM product_image_select WHERE product_id = '1218'
155 0.0005 0.00047802925109863 
SELECT * FROM productcustomimages WHERE product_id = '1218'
156 0.0012 0.0012369155883789 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1218' AND a.name = n.originalname
157 0.0005 0.00046014785766602 
SELECT * FROM productoffers WHERE product_id = '1218' AND merchantid = 'A1X6FK5RDHNB96'
158 0.0005 0.00045609474182129 
SELECT * FROM productoffers
                WHERE product_id = '1218' AND price > 0
                ORDER BY price ASC LIMIT 1
159 0.0005 0.00048708915710449 
SELECT value FROM productattributes WHERE product_id = '1218' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
160 0.0005 0.00046396255493164 
SELECT * FROM products WHERE id = '875'
161 0.0008 0.00076103210449219 
SELECT * FROM productimages WHERE product_id = '875' ORDER BY sortorder ASC
162 0.0006 0.00055098533630371 
SELECT * FROM product_image_select WHERE product_id = '875'
163 0.0004 0.00035500526428223 
SELECT * FROM productcustomimages WHERE product_id = '875'
164 0.0009 0.00085997581481934 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '875' AND a.name = n.originalname
165 0.0005 0.00045204162597656 
SELECT * FROM productoffers WHERE product_id = '875' AND merchantid = 'A1X6FK5RDHNB96'
166 0.0006 0.00061702728271484 
SELECT * FROM productoffers
                WHERE product_id = '875' AND price > 0
                ORDER BY price ASC LIMIT 1
167 0.0004 0.00039911270141602 
SELECT * FROM productoffers
                WHERE product_id = 875
                ORDER BY price ASC LIMIT 1
168 0.0005 0.0004880428314209 
SELECT value FROM productattributes
                WHERE product_id = '875'
                AND name = 'ListPriceAmount'
169 0.0005 0.00050902366638184 
SELECT value FROM productattributes WHERE product_id = '875' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
170 0.0005 0.00045394897460938 
SELECT * FROM products WHERE id = '1213'
171 0.0004 0.00044894218444824 
SELECT * FROM productimages WHERE product_id = '1213' ORDER BY sortorder ASC
172 0.0005 0.00054812431335449 
SELECT * FROM product_image_select WHERE product_id = '1213'
173 0.0005 0.00051283836364746 
SELECT * FROM productcustomimages WHERE product_id = '1213'
174 0.0010 0.0010440349578857 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1213' AND a.name = n.originalname
175 0.0004 0.00042891502380371 
SELECT * FROM productoffers WHERE product_id = '1213' AND merchantid = 'A1X6FK5RDHNB96'
176 0.0004 0.00040602684020996 
SELECT * FROM productoffers
                WHERE product_id = '1213' AND price > 0
                ORDER BY price ASC LIMIT 1
177 0.0004 0.00037407875061035 
SELECT * FROM productoffers
                WHERE product_id = 1213
                ORDER BY price ASC LIMIT 1
178 0.0004 0.00044894218444824 
SELECT value FROM productattributes
                WHERE product_id = '1213'
                AND name = 'ListPriceAmount'
179 0.0005 0.00053286552429199 
SELECT value FROM productattributes WHERE product_id = '1213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
180 0.0005 0.00045609474182129 
SELECT * FROM products WHERE id = '908'
181 0.0004 0.0004420280456543 
SELECT * FROM productimages WHERE product_id = '908' ORDER BY sortorder ASC
182 0.0005 0.00052118301391602 
SELECT * FROM product_image_select WHERE product_id = '908'
183 0.0003 0.00034594535827637 
SELECT * FROM productcustomimages WHERE product_id = '908'
184 0.0013 0.0012741088867188 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '908' AND a.name = n.originalname
185 0.0004 0.00043296813964844 
SELECT * FROM productoffers WHERE product_id = '908' AND merchantid = 'A1X6FK5RDHNB96'
186 0.0005 0.00046086311340332 
SELECT * FROM productoffers
                WHERE product_id = '908' AND price > 0
                ORDER BY price ASC LIMIT 1
187 0.0004 0.00041580200195312 
SELECT * FROM productoffers
                WHERE product_id = 908
                ORDER BY price ASC LIMIT 1
188 0.0005 0.00046992301940918 
SELECT value FROM productattributes
                WHERE product_id = '908'
                AND name = 'ListPriceAmount'
189 0.0006 0.00060200691223145 
SELECT value FROM productattributes WHERE product_id = '908' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
190 0.0005 0.00048708915710449 
SELECT * FROM products WHERE id = '1167'
191 0.0006 0.0006260871887207 
SELECT * FROM productimages WHERE product_id = '1167' ORDER BY sortorder ASC
192 0.0034 0.0033819675445557 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1167' AND p.id = pi.product_id ORDER BY pi.sortorder
193 0.0006 0.00057101249694824 
SELECT * FROM product_image_select WHERE product_id = '1167'
194 0.0004 0.00038003921508789 
SELECT * FROM productcustomimages WHERE product_id = '1167'
195 0.0009 0.00091695785522461 
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 = '1167'
                GROUP BY o.product_id
196 0.0024 0.0023729801177979 
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     = '1167'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
197 0.0009 0.00089693069458008 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1167
198 0.0010 0.0010190010070801 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1167' AND a.name = n.originalname
199 0.0004 0.00041818618774414 
SELECT * FROM productoffers WHERE product_id = '1167' AND merchantid = 'A1X6FK5RDHNB96'
200 0.0004 0.00041913986206055 
SELECT * FROM productoffers
                WHERE product_id = '1167' AND price > 0
                ORDER BY price ASC LIMIT 1
201 0.0004 0.00040793418884277 
SELECT * FROM productoffers
                WHERE product_id = 1167
                ORDER BY price ASC LIMIT 1
202 0.0004 0.00043702125549316 
SELECT value FROM productattributes
                WHERE product_id = '1167'
                AND name = 'ListPriceAmount'
203 0.0008 0.00082683563232422 
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 = '1167'
                GROUP BY o.product_id
204 0.0024 0.0023880004882812 
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     = '1167'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
205 0.0009 0.00086593627929688 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1167
206 0.0006 0.00056695938110352 
SELECT value FROM productattributes WHERE product_id = '1167' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
207 0.0034 0.0034081935882568 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '1167'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
208 0.0019 0.0018608570098877 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '1167'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'FlavorName'
                GROUP BY o.value
                ORDER BY o.value ASC
209 0.0005 0.00053286552429199 
SELECT * FROM products WHERE id = '1165'
210 0.0005 0.00052881240844727 
SELECT * FROM productimages WHERE product_id = '1165' ORDER BY sortorder ASC
211 0.0006 0.00057697296142578 
SELECT * FROM product_image_select WHERE product_id = '1165'
212 0.0004 0.00036287307739258 
SELECT * FROM productcustomimages WHERE product_id = '1165'
213 0.0013 0.0012979507446289 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1165' AND a.name = n.originalname
214 0.0004 0.00042819976806641 
SELECT * FROM productoffers WHERE product_id = '1165' AND merchantid = 'A1X6FK5RDHNB96'
215 0.0004 0.00041699409484863 
SELECT * FROM productoffers
                WHERE product_id = '1165' AND price > 0
                ORDER BY price ASC LIMIT 1
216 0.0004 0.00041007995605469 
SELECT * FROM productoffers
                WHERE product_id = 1165
                ORDER BY price ASC LIMIT 1
217 0.0006 0.00056219100952148 
SELECT value FROM productattributes
                WHERE product_id = '1165'
                AND name = 'ListPriceAmount'
218 0.0009 0.00091004371643066 
SELECT value FROM productattributes WHERE product_id = '1165' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
219 0.0005 0.00049114227294922 
SELECT * FROM products WHERE id = '889'
220 0.0005 0.00046396255493164 
SELECT * FROM productimages WHERE product_id = '889' ORDER BY sortorder ASC
221 0.0005 0.0005490779876709 
SELECT * FROM product_image_select WHERE product_id = '889'
222 0.0004 0.00044012069702148 
SELECT * FROM productcustomimages WHERE product_id = '889'
223 0.0009 0.00093197822570801 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '889' AND a.name = n.originalname
224 0.0005 0.00049996376037598 
SELECT * FROM productoffers WHERE product_id = '889' AND merchantid = 'A1X6FK5RDHNB96'
225 0.0004 0.00041604042053223 
SELECT * FROM productoffers
                WHERE product_id = '889' AND price > 0
                ORDER BY price ASC LIMIT 1
226 0.0004 0.00037384033203125 
SELECT * FROM productoffers
                WHERE product_id = 889
                ORDER BY price ASC LIMIT 1
227 0.0004 0.00044894218444824 
SELECT value FROM productattributes
                WHERE product_id = '889'
                AND name = 'ListPriceAmount'
228 0.0009 0.00087094306945801 
SELECT value FROM productattributes WHERE product_id = '889' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
229 0.0005 0.00053095817565918 
SELECT * FROM products WHERE id = '1144'
230 0.0005 0.00048112869262695 
SELECT * FROM productimages WHERE product_id = '1144' ORDER BY sortorder ASC
231 0.0005 0.00054597854614258 
SELECT * FROM product_image_select WHERE product_id = '1144'
232 0.0004 0.00036907196044922 
SELECT * FROM productcustomimages WHERE product_id = '1144'
233 0.0014 0.0013670921325684 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1144' AND a.name = n.originalname
234 0.0005 0.0004570484161377 
SELECT * FROM productoffers WHERE product_id = '1144' AND merchantid = 'A1X6FK5RDHNB96'
235 0.0004 0.00044608116149902 
SELECT * FROM productoffers
                WHERE product_id = '1144' AND price > 0
                ORDER BY price ASC LIMIT 1
236 0.0004 0.00041389465332031 
SELECT * FROM productoffers
                WHERE product_id = 1144
                ORDER BY price ASC LIMIT 1
237 0.0005 0.00049209594726562 
SELECT value FROM productattributes
                WHERE product_id = '1144'
                AND name = 'ListPriceAmount'
238 0.0005 0.00053906440734863 
SELECT value FROM productattributes WHERE product_id = '1144' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
239 0.0021 0.0020530223846436 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1112' ORDER BY timestamp DESC
240 0.0004 0.00043106079101562 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1138' ORDER BY timestamp DESC
241 0.0004 0.00038886070251465 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1227' ORDER BY timestamp DESC
242 0.0004 0.00041794776916504 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1218' ORDER BY timestamp DESC
243 0.0004 0.00042891502380371 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '875' ORDER BY timestamp DESC
244 0.0004 0.00043892860412598 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1213' ORDER BY timestamp DESC
245 0.0004 0.00041484832763672 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '908' ORDER BY timestamp DESC
246 0.0004 0.00037217140197754 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1167' ORDER BY timestamp DESC
247 0.0004 0.00041294097900391 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1165' ORDER BY timestamp DESC
248 0.0004 0.00038003921508789 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '889' ORDER BY timestamp DESC
249 0.0004 0.00040292739868164 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1144' ORDER BY timestamp DESC
250 0.0009 0.00090909004211426 
SELECT linktitle,pagename,ep.id,price,buylink,image FROM ebay_products ep, products_categories c
		WHERE ep.id = c.product_id
		AND c.category_id = 28
		AND c.prod_type = 'ebay'
		AND hide = 0
251 0.0007 0.00067400932312012 
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
252 0.0005 0.00048208236694336 
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
253 0.0017 0.0017318725585938 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
254 0.0004 0.00042915344238281 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
255 0.0168 0.016774892807007 
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
256 0.0022 0.0021989345550537 
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
257 0.0006 0.00058293342590332 
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
258 0.0005 0.00053501129150391 
SELECT * FROM products WHERE id = 1626
259 0.0008 0.0007631778717041 
SELECT * FROM products WHERE id = 4041
260 0.0005 0.00046205520629883 
SELECT * FROM products WHERE id = 4312
261 0.0006 0.00055909156799316 
SELECT * FROM products WHERE id = 777
262 0.0005 0.00050997734069824 
SELECT * FROM products WHERE id = 3881
263 0.0005 0.00047516822814941 
SELECT * FROM products WHERE id = 4213
264 0.0005 0.00050687789916992 
SELECT * FROM products WHERE id = '1626'
265 0.0005 0.00047802925109863 
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
266 0.0007 0.00068807601928711 
SELECT * FROM product_image_select WHERE product_id = '1626'
267 0.0004 0.00042295455932617 
SELECT * FROM productcustomimages WHERE product_id = '1626'
268 0.0010 0.00096607208251953 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
269 0.0005 0.00049614906311035 
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
270 0.0008 0.00078606605529785 
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
271 0.0006 0.00060796737670898 
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
272 0.0006 0.00055503845214844 
SELECT * FROM products WHERE id = '4041'
273 0.0005 0.00046396255493164 
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
274 0.0006 0.00058889389038086 
SELECT * FROM product_image_select WHERE product_id = '4041'
275 0.0004 0.00042080879211426 
SELECT * FROM productcustomimages WHERE product_id = '4041'
276 0.0016 0.0016379356384277 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
277 0.0006 0.00057387351989746 
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
278 0.0005 0.00051307678222656 
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
279 0.0005 0.00053501129150391 
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
280 0.0005 0.00050902366638184 
SELECT * FROM products WHERE id = '4312'
281 0.0004 0.00044608116149902 
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
282 0.0006 0.00057005882263184 
SELECT * FROM product_image_select WHERE product_id = '4312'
283 0.0006 0.00058603286743164 
SELECT * FROM productcustomimages WHERE product_id = '4312'
284 0.0013 0.0013020038604736 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
285 0.0005 0.00047993659973145 
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
286 0.0005 0.00048613548278809 
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
287 0.0005 0.00051712989807129 
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
288 0.0005 0.00051093101501465 
SELECT * FROM products WHERE id = '777'
289 0.0005 0.00046396255493164 
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
290 0.0008 0.00076198577880859 
SELECT * FROM product_image_select WHERE product_id = '777'
291 0.0003 0.00034189224243164 
SELECT * FROM productcustomimages WHERE product_id = '777'
292 0.0011 0.0010638236999512 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
293 0.0005 0.00054383277893066 
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
294 0.0005 0.00048708915710449 
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
295 0.0005 0.00047898292541504 
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
296 0.0008 0.00075292587280273 
SELECT * FROM products WHERE id = '3881'
297 0.0005 0.00050210952758789 
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
298 0.0005 0.00050806999206543 
SELECT * FROM product_image_select WHERE product_id = '3881'
299 0.0003 0.0003349781036377 
SELECT * FROM productcustomimages WHERE product_id = '3881'
300 0.0012 0.0012309551239014 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
301 0.0004 0.00044918060302734 
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
302 0.0008 0.00075793266296387 
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
303 0.0006 0.00058388710021973 
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
304 0.0005 0.00047612190246582 
SELECT * FROM products WHERE id = '4213'
305 0.0004 0.00044918060302734 
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
306 0.0005 0.00052213668823242 
SELECT * FROM product_image_select WHERE product_id = '4213'
307 0.0004 0.00035786628723145 
SELECT * FROM productcustomimages WHERE product_id = '4213'
308 0.0016 0.0015521049499512 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
309 0.0005 0.00049281120300293 
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
310 0.0005 0.00046396255493164 
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
311 0.0005 0.00049304962158203 
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
312 0.0023 0.0022571086883545 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
313 0.0010 0.0010221004486084 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
314 0.0028 0.0027921199798584 
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
315 0.0019 0.0018501281738281 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
316 0.0009 0.00092196464538574 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
317 0.0013 0.0012879371643066 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
318 0.0016 0.0015718936920166 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'