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.4807510375977 319 1.1919 0


No Amazon API Requests Made.


App Debug - Total Time 1.4807510375977 seconds

Number Time From Start Name Description
1 0.25175499916077 Initialise Initialise FSB Function
2 0.26746392250061 App Controller Start Start of the App controller (called before the controller of every page)
3 1.1093499660492 App Controller End End of the App controller (called before the controller of every page)
4 1.1097099781036 Category Start Start of the category controller
5 1.1097140312195 Before Get Category Before getting the category information
6 1.1570520401001 After Get Category After getting the category information
7 1.1570529937744 Before Get Category List Before getting the updated category list
8 1.1573700904846 Start of getCategoryListByGroup Function Before first category groups query
9 1.157723903656 After initial query Before first category groups query
10 1.1577250957489 Get Category List for Group Before the call to getCategoryList function
11 1.1577270030975 Start of GetCategoryList function Start of the function
12 1.1577279567719 Before getting categories Query to get specific category list
13 1.1581530570984 After getting categories Query to get specific category list
14 1.1581530570984 Before getting category custom Before call to function getCategoryCustom
15 1.1746261119843 After getting category custom After call to function getCategoryCustom
16 1.1746270656586 Before getting category custom Before call to function getCategoryCustom
17 1.1849949359894 After getting category custom After call to function getCategoryCustom
18 1.1850049495697 Before getting category custom Before call to function getCategoryCustom
19 1.1912400722504 After getting category custom After call to function getCategoryCustom
20 1.1912410259247 Before getting sub category list Before call to recursive function getCategoryList
21 1.191241979599 Start of GetCategoryList function Start of the function
22 1.1912429332733 Before getting categories Query to get specific category list
23 1.1916930675507 After getting sub category list After call to recursive function getCategoryList
24 1.191694021225 Before getting category custom Before call to function getCategoryCustom
25 1.1957330703735 After getting category custom After call to function getCategoryCustom
26 1.1957349777222 Before getting category custom Before call to function getCategoryCustom
27 1.2000370025635 After getting category custom After call to function getCategoryCustom
28 1.2000389099121 Before getting category custom Before call to function getCategoryCustom
29 1.2043809890747 After getting category custom After call to function getCategoryCustom
30 1.204381942749 End of GetCategoryList function End of the function
31 1.2043869495392 Get Category List for Group Before the call to getCategoryList function
32 1.2043879032135 Start of GetCategoryList function Start of the function
33 1.2043890953064 Before getting categories Query to get specific category list
34 1.204822063446 End of getCategoryListByGroup Function Before return()
35 1.2048230171204 After Get Category List After getting the updated category list
36 1.2048239707947 Before Category Images Before getting the category images
37 1.2051689624786 After Category Images After getting the category images
38 1.2067770957947 Before Sub Category Check Before checking for sub category or products category
39 1.2072110176086 Before Category Products Controller Before loading the category products controller
40 1.2077729701996 Start Category Products Start of Category Products Controller
41 1.2077848911285 After Pagination Options After pagination options in Category Products Controller
42 1.2293260097504 After Cache After Cache checking in Category Products Controller
43 1.2568199634552 After Filter Options After getting filter options and SQL in Category Products Controller
44 1.25887799263 After Counting Products After counting products in the Category Products Controller
45 1.2593688964844 After Counting Bundles After counting bundles in the Category Products Controller
46 1.259859085083 After Counting Products After counting products in the Category Products Controller
47 1.2622079849243 After Getting Products After getting products and bundles in the Category Products Controller
48 1.2622311115265 After Pagination Links After getting pagination listing links in the Category Products Controller
49 1.2622320652008 After Getting Bundle Details After getting full details for the bundles in the Category Products Controller
50 1.3667418956757 After Getting Product Details After getting full product details in the Category Products Controller
51 1.3717329502106 After Getting Product/Bundle Reviews After getting full product/bundle customer review in the Category Products Controller
52 1.3741619586945 App_after Controller Start Start of the App_after controller (called after the controller of every page)
53 1.3764510154724 Before Get Options Before the call to getOptions in the tpl class
54 1.4507400989532 After Get Options After the call to getOptions in the tpl class
55 1.4508450031281 App_after Controller End End of the App_after controller (called after the controller of every page)
56 1.450865983963 Before Smarty Before passing everything over to Smarty in the Category Products Controller
57 1.4807379245758 After Loading sub/product controller After checking for sub category or products category and then loading the relevant controller
58 1.4807419776917 Finalizing debug Before the debug is output to the page.
59 1.4807510375977 End of App This is the end of the app logging, final timestamp


Query Debug - 319 Database Queries. Total time 1.1919 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0026 0.0026190280914307 
SELECT parameter, value FROM parameters
2 0.0089 0.0089111328125 
SELECT * FROM `bad_bots`
3 0.0004 0.00037813186645508 
SET time_zone = 'Europe/London'
4 0.0023 0.002349853515625 
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0017 0.0016570091247559 
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"3.137.155.109\";}'
6 0.0015 0.0014660358428955 
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1745998158'
7 0.0033 0.0032868385314941 
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0007 0.00068998336791992 
UPDATE autorun SET lastrun = '2025-04-30 07:29:18' WHERE id = '16'
9 0.0007 0.00073599815368652 
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0029 0.002875804901123 
SELECT id FROM pages WHERE pagename = 'thes-verts' LIMIT 1
11 0.0034 0.0033800601959229 
SELECT id FROM products WHERE pagename = 'thes-verts' AND hidden = 0 LIMIT 1
12 0.0028 0.0028281211853027 
SELECT id FROM ebay_products WHERE pagename = 'thes-verts'
13 0.0027 0.0027329921722412 
SELECT id FROM custom_products WHERE pagename = 'thes-verts'
14 0.0026 0.0025629997253418 
SELECT id FROM categories WHERE pagename = 'thes-verts' LIMIT 1
15 0.0032 0.0031740665435791 
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
16 0.0275 0.027522087097168 
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
17 0.0006 0.00058698654174805 
SELECT * FROM pages WHERE pagename = 'thes-verts'
18 0.0027 0.0026569366455078 
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
19 0.0014 0.0014231204986572 
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
20 0.0005 0.00051403045654297 
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
21 0.0011 0.0011348724365234 
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
22 0.0011 0.0011000633239746 
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
23 0.0007 0.00074100494384766 
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
24 0.7952 0.79521203041077 
SELECT * FROM ipgeocountries WHERE INET_ATON('3.137.155.109') >= INET_ATON(ip_start) AND INET_ATON('3.137.155.109') <= INET_ATON(ip_end)
25 0.0020 0.0020351409912109 
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
26 0.0037 0.0037248134613037 
SELECT * FROM countryredirects WHERE countrycode = 'US'
27 0.0030 0.0029609203338623 
SELECT * FROM categories WHERE pagename = 'thes-verts'
28 0.0055 0.0055010318756104 
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
29 0.0045 0.0045320987701416 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
30 0.0037 0.0037479400634766 
SELECT id FROM categories WHERE parent_id = '28'
31 0.0057 0.0057401657104492 
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
32 0.0065 0.0065181255340576 
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
33 0.0019 0.0018539428710938 
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
34 0.0032 0.00323486328125 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
35 0.0007 0.00067996978759766 
SELECT id FROM categories WHERE parent_id = '28'
36 0.0032 0.0032320022583008 
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
37 0.0026 0.0026471614837646 
SELECT * FROM productimages WHERE product_id = '868' ORDER BY sortorder ASC
38 0.0021 0.0020599365234375 
SELECT * FROM categoryimages WHERE category_id = 28
39 0.0017 0.0017220973968506 
SELECT * FROM categorygroups WHERE id = '1'
40 0.0023 0.0023148059844971 
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
41 0.0005 0.00046586990356445 
SELECT parent_id FROM categories WHERE id = '28'
42 0.0003 0.00031113624572754 
SELECT parent_id FROM categories WHERE id = '28'
43 0.0004 0.0003509521484375 
SELECT * FROM categorygroups ORDER BY sortorder ASC
44 0.0004 0.00041508674621582 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
45 0.0073 0.007282018661499 
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
46 0.0005 0.00053000450134277 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
47 0.0004 0.00037598609924316 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
48 0.0004 0.00040793418884277 
SELECT id FROM categories WHERE parent_id = '26'
49 0.0059 0.0058829784393311 
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
50 0.0006 0.00060391426086426 
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
51 0.0005 0.00050091743469238 
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
52 0.0004 0.00042605400085449 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
53 0.0004 0.0004119873046875 
SELECT * FROM categorygroups WHERE id = '1'
54 0.0036 0.0035591125488281 
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
55 0.0005 0.00050187110900879 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
56 0.0004 0.00041699409484863 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
57 0.0004 0.0003669261932373 
SELECT id FROM categories WHERE parent_id = '27'
58 0.0037 0.0036568641662598 
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
59 0.0005 0.00050783157348633 
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
60 0.0005 0.00053691864013672 
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
61 0.0004 0.0004119873046875 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
62 0.0004 0.00036716461181641 
SELECT * FROM categorygroups WHERE id = '1'
63 0.0015 0.001460075378418 
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
64 0.0004 0.00043082237243652 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
65 0.0003 0.00033998489379883 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
66 0.0004 0.00038790702819824 
SELECT id FROM categories WHERE parent_id = '28'
67 0.0016 0.0015590190887451 
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
68 0.0005 0.00045609474182129 
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
69 0.0006 0.00058102607727051 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
70 0.0005 0.00054001808166504 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
71 0.0005 0.00045299530029297 
SELECT * FROM categorygroups WHERE id = '1'
72 0.0004 0.00044512748718262 
SELECT * FROM categories WHERE parent_id = '28'  AND hidden = 0 ORDER BY sortorder ASC
73 0.0006 0.00059700012207031 
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
74 0.0004 0.00040507316589355 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
75 0.0003 0.00032210350036621 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
76 0.0004 0.0003509521484375 
SELECT id FROM categories WHERE parent_id = '29'
77 0.0006 0.00059890747070312 
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
78 0.0004 0.00042891502380371 
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
79 0.0005 0.00046396255493164 
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
80 0.0004 0.00043892860412598 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
81 0.0004 0.00039196014404297 
SELECT * FROM categorygroups WHERE id = '1'
82 0.0006 0.00058102607727051 
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
83 0.0005 0.00051784515380859 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
84 0.0004 0.00038599967956543 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
85 0.0004 0.00038599967956543 
SELECT id FROM categories WHERE parent_id = '30'
86 0.0006 0.00064611434936523 
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
87 0.0005 0.00047111511230469 
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
88 0.0005 0.00047516822814941 
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
89 0.0004 0.00043106079101562 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
90 0.0004 0.00037312507629395 
SELECT * FROM categorygroups WHERE id = '1'
91 0.0006 0.00059294700622559 
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
92 0.0004 0.00041794776916504 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
93 0.0003 0.00033307075500488 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
94 0.0004 0.00038886070251465 
SELECT id FROM categories WHERE parent_id = '31'
95 0.0008 0.00075221061706543 
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
96 0.0005 0.00050806999206543 
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
97 0.0005 0.00046992301940918 
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
98 0.0004 0.00043487548828125 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
99 0.0004 0.00038909912109375 
SELECT * FROM categorygroups WHERE id = '1'
100 0.0004 0.00042891502380371 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
101 0.0003 0.00034403800964355 
SELECT * FROM categoryimages WHERE category_id = 28
102 0.0016 0.0015850067138672 
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
103 0.0004 0.0004279613494873 
SELECT * FROM categories WHERE parent_id = '28'
104 0.0119 0.011875867843628 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
105 0.0031 0.003093957901001 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
106 0.0023 0.0022680759429932 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
107 0.0079 0.0079309940338135 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
108 0.0017 0.0016639232635498 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
109 0.0005 0.00049901008605957 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
110 0.0015 0.0015459060668945 
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
111 0.0005 0.00050187110900879 
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
112 0.0005 0.0004880428314209 
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
113 0.0005 0.00048685073852539 
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
114 0.0023 0.0023269653320312 
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
115 0.0005 0.00046396255493164 
SELECT * FROM products WHERE id = '1112'
116 0.0004 0.00042104721069336 
SELECT * FROM productimages WHERE product_id = '1112' ORDER BY sortorder ASC
117 0.0016 0.0016109943389893 
SELECT * FROM product_image_select WHERE product_id = '1112'
118 0.0011 0.0011379718780518 
SELECT * FROM productcustomimages WHERE product_id = '1112'
119 0.0019 0.0018551349639893 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1112' AND a.name = n.originalname
120 0.0013 0.0013339519500732 
SELECT * FROM productoffers WHERE product_id = '1112' AND merchantid = 'A1X6FK5RDHNB96'
121 0.0004 0.0004119873046875 
SELECT * FROM productoffers
                WHERE product_id = '1112' AND price > 0
                ORDER BY price ASC LIMIT 1
122 0.0004 0.00035691261291504 
SELECT * FROM productoffers
                WHERE product_id = 1112
                ORDER BY price ASC LIMIT 1
123 0.0005 0.00049018859863281 
SELECT value FROM productattributes
                WHERE product_id = '1112'
                AND name = 'ListPriceAmount'
124 0.0004 0.00043296813964844 
SELECT value FROM productattributes WHERE product_id = '1112' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
125 0.0005 0.00050187110900879 
SELECT * FROM products WHERE id = '1138'
126 0.0005 0.00051712989807129 
SELECT * FROM productimages WHERE product_id = '1138' ORDER BY sortorder ASC
127 0.0007 0.00066399574279785 
SELECT * FROM product_image_select WHERE product_id = '1138'
128 0.0004 0.00038790702819824 
SELECT * FROM productcustomimages WHERE product_id = '1138'
129 0.0008 0.00082612037658691 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1138' AND a.name = n.originalname
130 0.0005 0.0004580020904541 
SELECT * FROM productoffers WHERE product_id = '1138' AND merchantid = 'A1X6FK5RDHNB96'
131 0.0004 0.00040602684020996 
SELECT * FROM productoffers
                WHERE product_id = '1138' AND price > 0
                ORDER BY price ASC LIMIT 1
132 0.0004 0.00038003921508789 
SELECT * FROM productoffers
                WHERE product_id = 1138
                ORDER BY price ASC LIMIT 1
133 0.0004 0.00038814544677734 
SELECT value FROM productattributes
                WHERE product_id = '1138'
                AND name = 'ListPriceAmount'
134 0.0005 0.00046420097351074 
SELECT value FROM productattributes WHERE product_id = '1138' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
135 0.0006 0.00062394142150879 
SELECT * FROM products WHERE id = '1227'
136 0.0004 0.00044679641723633 
SELECT * FROM productimages WHERE product_id = '1227' ORDER BY sortorder ASC
137 0.0005 0.00047993659973145 
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
138 0.0006 0.00058317184448242 
SELECT * FROM product_image_select WHERE product_id = '1227'
139 0.0004 0.0003669261932373 
SELECT * FROM productcustomimages WHERE product_id = '1227'
140 0.0005 0.00054502487182617 
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
141 0.0049 0.0049381256103516 
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
142 0.0011 0.0011091232299805 
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
143 0.0027 0.0027449131011963 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1227' AND a.name = n.originalname
144 0.0007 0.00073695182800293 
SELECT * FROM productoffers WHERE product_id = '1227' AND merchantid = 'A1X6FK5RDHNB96'
145 0.0007 0.00069785118103027 
SELECT * FROM productoffers
                WHERE product_id = '1227' AND price > 0
                ORDER BY price ASC LIMIT 1
146 0.0005 0.00054812431335449 
SELECT * FROM productoffers
                WHERE product_id = 1227
                ORDER BY price ASC LIMIT 1
147 0.0007 0.00067019462585449 
SELECT value FROM productattributes
                WHERE product_id = '1227'
                AND name = 'ListPriceAmount'
148 0.0008 0.00083708763122559 
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
149 0.0017 0.0016539096832275 
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
150 0.0009 0.00085616111755371 
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
151 0.0011 0.001068115234375 
SELECT value FROM productattributes WHERE product_id = '1227' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
152 0.0009 0.00092792510986328 
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
153 0.0004 0.00044989585876465 
SELECT * FROM products WHERE id = '1218'
154 0.0007 0.00065898895263672 
SELECT * FROM productimages WHERE product_id = '1218' ORDER BY sortorder ASC
155 0.0008 0.00078201293945312 
SELECT * FROM product_image_select WHERE product_id = '1218'
156 0.0005 0.0004580020904541 
SELECT * FROM productcustomimages WHERE product_id = '1218'
157 0.0016 0.0016138553619385 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1218' AND a.name = n.originalname
158 0.0006 0.00061202049255371 
SELECT * FROM productoffers WHERE product_id = '1218' AND merchantid = 'A1X6FK5RDHNB96'
159 0.0005 0.00047922134399414 
SELECT * FROM productoffers
                WHERE product_id = '1218' AND price > 0
                ORDER BY price ASC LIMIT 1
160 0.0006 0.00057601928710938 
SELECT value FROM productattributes WHERE product_id = '1218' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
161 0.0007 0.00065493583679199 
SELECT * FROM products WHERE id = '875'
162 0.0007 0.00074505805969238 
SELECT * FROM productimages WHERE product_id = '875' ORDER BY sortorder ASC
163 0.0009 0.00091004371643066 
SELECT * FROM product_image_select WHERE product_id = '875'
164 0.0005 0.0005340576171875 
SELECT * FROM productcustomimages WHERE product_id = '875'
165 0.0011 0.0010831356048584 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '875' AND a.name = n.originalname
166 0.0005 0.00054502487182617 
SELECT * FROM productoffers WHERE product_id = '875' AND merchantid = 'A1X6FK5RDHNB96'
167 0.0004 0.00040793418884277 
SELECT * FROM productoffers
                WHERE product_id = '875' AND price > 0
                ORDER BY price ASC LIMIT 1
168 0.0004 0.00038814544677734 
SELECT * FROM productoffers
                WHERE product_id = 875
                ORDER BY price ASC LIMIT 1
169 0.0004 0.00040102005004883 
SELECT value FROM productattributes
                WHERE product_id = '875'
                AND name = 'ListPriceAmount'
170 0.0006 0.00055503845214844 
SELECT value FROM productattributes WHERE product_id = '875' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
171 0.0006 0.00059223175048828 
SELECT * FROM products WHERE id = '1213'
172 0.0005 0.00053691864013672 
SELECT * FROM productimages WHERE product_id = '1213' ORDER BY sortorder ASC
173 0.0006 0.000640869140625 
SELECT * FROM product_image_select WHERE product_id = '1213'
174 0.0004 0.00038504600524902 
SELECT * FROM productcustomimages WHERE product_id = '1213'
175 0.0013 0.0013489723205566 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1213' AND a.name = n.originalname
176 0.0005 0.00046801567077637 
SELECT * FROM productoffers WHERE product_id = '1213' AND merchantid = 'A1X6FK5RDHNB96'
177 0.0005 0.00048303604125977 
SELECT * FROM productoffers
                WHERE product_id = '1213' AND price > 0
                ORDER BY price ASC LIMIT 1
178 0.0004 0.00036215782165527 
SELECT * FROM productoffers
                WHERE product_id = 1213
                ORDER BY price ASC LIMIT 1
179 0.0004 0.00039482116699219 
SELECT value FROM productattributes
                WHERE product_id = '1213'
                AND name = 'ListPriceAmount'
180 0.0004 0.00044107437133789 
SELECT value FROM productattributes WHERE product_id = '1213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
181 0.0005 0.00052499771118164 
SELECT * FROM products WHERE id = '908'
182 0.0006 0.00064182281494141 
SELECT * FROM productimages WHERE product_id = '908' ORDER BY sortorder ASC
183 0.0006 0.00063586235046387 
SELECT * FROM product_image_select WHERE product_id = '908'
184 0.0004 0.00043296813964844 
SELECT * FROM productcustomimages WHERE product_id = '908'
185 0.0009 0.00086712837219238 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '908' AND a.name = n.originalname
186 0.0005 0.00049209594726562 
SELECT * FROM productoffers WHERE product_id = '908' AND merchantid = 'A1X6FK5RDHNB96'
187 0.0004 0.00036501884460449 
SELECT * FROM productoffers
                WHERE product_id = '908' AND price > 0
                ORDER BY price ASC LIMIT 1
188 0.0003 0.00031900405883789 
SELECT * FROM productoffers
                WHERE product_id = 908
                ORDER BY price ASC LIMIT 1
189 0.0004 0.00040221214294434 
SELECT value FROM productattributes
                WHERE product_id = '908'
                AND name = 'ListPriceAmount'
190 0.0004 0.00043487548828125 
SELECT value FROM productattributes WHERE product_id = '908' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
191 0.0006 0.00056719779968262 
SELECT * FROM products WHERE id = '1167'
192 0.0005 0.0004880428314209 
SELECT * FROM productimages WHERE product_id = '1167' ORDER BY sortorder ASC
193 0.0039 0.003931999206543 
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
194 0.0008 0.00081896781921387 
SELECT * FROM product_image_select WHERE product_id = '1167'
195 0.0007 0.00066614151000977 
SELECT * FROM productcustomimages WHERE product_id = '1167'
196 0.0011 0.0011439323425293 
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
197 0.0031 0.0030639171600342 
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
198 0.0013 0.0013120174407959 
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
199 0.0015 0.00146484375 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1167' AND a.name = n.originalname
200 0.0004 0.00037407875061035 
SELECT * FROM productoffers WHERE product_id = '1167' AND merchantid = 'A1X6FK5RDHNB96'
201 0.0003 0.00029993057250977 
SELECT * FROM productoffers
                WHERE product_id = '1167' AND price > 0
                ORDER BY price ASC LIMIT 1
202 0.0003 0.0003209114074707 
SELECT * FROM productoffers
                WHERE product_id = 1167
                ORDER BY price ASC LIMIT 1
203 0.0005 0.00049805641174316 
SELECT value FROM productattributes
                WHERE product_id = '1167'
                AND name = 'ListPriceAmount'
204 0.0015 0.0015270709991455 
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
205 0.0033 0.0033071041107178 
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
206 0.0012 0.0012059211730957 
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
207 0.0007 0.00069808959960938 
SELECT value FROM productattributes WHERE product_id = '1167' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
208 0.0051 0.0050909519195557 
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
209 0.0019 0.0019218921661377 
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
210 0.0005 0.00048184394836426 
SELECT * FROM products WHERE id = '1165'
211 0.0007 0.00073599815368652 
SELECT * FROM productimages WHERE product_id = '1165' ORDER BY sortorder ASC
212 0.0007 0.00070810317993164 
SELECT * FROM product_image_select WHERE product_id = '1165'
213 0.0005 0.00047397613525391 
SELECT * FROM productcustomimages WHERE product_id = '1165'
214 0.0014 0.0013940334320068 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1165' AND a.name = n.originalname
215 0.0005 0.00049519538879395 
SELECT * FROM productoffers WHERE product_id = '1165' AND merchantid = 'A1X6FK5RDHNB96'
216 0.0004 0.00041103363037109 
SELECT * FROM productoffers
                WHERE product_id = '1165' AND price > 0
                ORDER BY price ASC LIMIT 1
217 0.0004 0.00037908554077148 
SELECT * FROM productoffers
                WHERE product_id = 1165
                ORDER BY price ASC LIMIT 1
218 0.0007 0.00065898895263672 
SELECT value FROM productattributes
                WHERE product_id = '1165'
                AND name = 'ListPriceAmount'
219 0.0005 0.00052094459533691 
SELECT value FROM productattributes WHERE product_id = '1165' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
220 0.0009 0.00088906288146973 
SELECT * FROM products WHERE id = '889'
221 0.0005 0.00048708915710449 
SELECT * FROM productimages WHERE product_id = '889' ORDER BY sortorder ASC
222 0.0006 0.00064206123352051 
SELECT * FROM product_image_select WHERE product_id = '889'
223 0.0004 0.00044798851013184 
SELECT * FROM productcustomimages WHERE product_id = '889'
224 0.0010 0.0009911060333252 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '889' AND a.name = n.originalname
225 0.0006 0.00056695938110352 
SELECT * FROM productoffers WHERE product_id = '889' AND merchantid = 'A1X6FK5RDHNB96'
226 0.0004 0.00040793418884277 
SELECT * FROM productoffers
                WHERE product_id = '889' AND price > 0
                ORDER BY price ASC LIMIT 1
227 0.0004 0.00044107437133789 
SELECT * FROM productoffers
                WHERE product_id = 889
                ORDER BY price ASC LIMIT 1
228 0.0004 0.00043201446533203 
SELECT value FROM productattributes
                WHERE product_id = '889'
                AND name = 'ListPriceAmount'
229 0.0006 0.00057196617126465 
SELECT value FROM productattributes WHERE product_id = '889' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
230 0.0006 0.00055599212646484 
SELECT * FROM products WHERE id = '1144'
231 0.0006 0.00057792663574219 
SELECT * FROM productimages WHERE product_id = '1144' ORDER BY sortorder ASC
232 0.0006 0.00061392784118652 
SELECT * FROM product_image_select WHERE product_id = '1144'
233 0.0004 0.00041890144348145 
SELECT * FROM productcustomimages WHERE product_id = '1144'
234 0.0015 0.0015180110931396 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1144' AND a.name = n.originalname
235 0.0005 0.00047397613525391 
SELECT * FROM productoffers WHERE product_id = '1144' AND merchantid = 'A1X6FK5RDHNB96'
236 0.0004 0.00042200088500977 
SELECT * FROM productoffers
                WHERE product_id = '1144' AND price > 0
                ORDER BY price ASC LIMIT 1
237 0.0004 0.0003659725189209 
SELECT * FROM productoffers
                WHERE product_id = 1144
                ORDER BY price ASC LIMIT 1
238 0.0004 0.00043416023254395 
SELECT value FROM productattributes
                WHERE product_id = '1144'
                AND name = 'ListPriceAmount'
239 0.0005 0.0004889965057373 
SELECT value FROM productattributes WHERE product_id = '1144' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
240 0.0018 0.0017910003662109 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1112' ORDER BY timestamp DESC
241 0.0003 0.00028705596923828 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1138' ORDER BY timestamp DESC
242 0.0003 0.00032186508178711 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1227' ORDER BY timestamp DESC
243 0.0003 0.00033998489379883 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1218' ORDER BY timestamp DESC
244 0.0003 0.00028800964355469 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '875' ORDER BY timestamp DESC
245 0.0003 0.00030994415283203 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1213' ORDER BY timestamp DESC
246 0.0003 0.00032591819763184 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '908' ORDER BY timestamp DESC
247 0.0003 0.00034904479980469 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1167' ORDER BY timestamp DESC
248 0.0003 0.00031495094299316 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1165' ORDER BY timestamp DESC
249 0.0003 0.00027799606323242 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '889' ORDER BY timestamp DESC
250 0.0003 0.00032782554626465 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1144' ORDER BY timestamp DESC
251 0.0006 0.00062179565429688 
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
252 0.0005 0.00052404403686523 
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
253 0.0006 0.00059890747070312 
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
254 0.0019 0.0018999576568604 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
255 0.0003 0.00034618377685547 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
256 0.0165 0.016496896743774 
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
257 0.0023 0.0022830963134766 
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
258 0.0006 0.00063109397888184 
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
259 0.0005 0.00054502487182617 
SELECT * FROM products WHERE id = 1626
260 0.0004 0.00044703483581543 
SELECT * FROM products WHERE id = 4041
261 0.0004 0.00042390823364258 
SELECT * FROM products WHERE id = 4312
262 0.0004 0.00042295455932617 
SELECT * FROM products WHERE id = 777
263 0.0004 0.00042605400085449 
SELECT * FROM products WHERE id = 3881
264 0.0005 0.00050592422485352 
SELECT * FROM products WHERE id = 4213
265 0.0004 0.0004279613494873 
SELECT * FROM products WHERE id = '1626'
266 0.0005 0.00052094459533691 
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
267 0.0006 0.0006411075592041 
SELECT * FROM product_image_select WHERE product_id = '1626'
268 0.0004 0.00039887428283691 
SELECT * FROM productcustomimages WHERE product_id = '1626'
269 0.0010 0.00097894668579102 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
270 0.0005 0.00053191184997559 
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
271 0.0005 0.00045299530029297 
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
272 0.0006 0.00058794021606445 
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
273 0.0007 0.00066399574279785 
SELECT * FROM products WHERE id = '4041'
274 0.0005 0.00052618980407715 
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
275 0.0008 0.00080013275146484 
SELECT * FROM product_image_select WHERE product_id = '4041'
276 0.0005 0.00045204162597656 
SELECT * FROM productcustomimages WHERE product_id = '4041'
277 0.0014 0.0014369487762451 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
278 0.0006 0.00060701370239258 
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
279 0.0005 0.0005190372467041 
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
280 0.0005 0.00050187110900879 
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
281 0.0007 0.00067496299743652 
SELECT * FROM products WHERE id = '4312'
282 0.0006 0.00055694580078125 
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
283 0.0007 0.0006568431854248 
SELECT * FROM product_image_select WHERE product_id = '4312'
284 0.0004 0.00040984153747559 
SELECT * FROM productcustomimages WHERE product_id = '4312'
285 0.0012 0.0011789798736572 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
286 0.0005 0.0005030632019043 
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
287 0.0004 0.00040888786315918 
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
288 0.0004 0.00043392181396484 
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
289 0.0006 0.00062680244445801 
SELECT * FROM products WHERE id = '777'
290 0.0006 0.00055789947509766 
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
291 0.0007 0.00066280364990234 
SELECT * FROM product_image_select WHERE product_id = '777'
292 0.0005 0.00049591064453125 
SELECT * FROM productcustomimages WHERE product_id = '777'
293 0.0013 0.0013048648834229 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
294 0.0012 0.0011589527130127 
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
295 0.0007 0.00074505805969238 
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
296 0.0010 0.0009610652923584 
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
297 0.0011 0.0010871887207031 
SELECT * FROM products WHERE id = '3881'
298 0.0011 0.0010941028594971 
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
299 0.0015 0.0014679431915283 
SELECT * FROM product_image_select WHERE product_id = '3881'
300 0.0007 0.00069189071655273 
SELECT * FROM productcustomimages WHERE product_id = '3881'
301 0.0031 0.0030670166015625 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
302 0.0009 0.00092887878417969 
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
303 0.0008 0.00075507164001465 
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
304 0.0010 0.0009620189666748 
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
305 0.0012 0.0012149810791016 
SELECT * FROM products WHERE id = '4213'
306 0.0011 0.0011398792266846 
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
307 0.0014 0.0013878345489502 
SELECT * FROM product_image_select WHERE product_id = '4213'
308 0.0008 0.00076985359191895 
SELECT * FROM productcustomimages WHERE product_id = '4213'
309 0.0023 0.002302885055542 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
310 0.0007 0.00069403648376465 
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
311 0.0006 0.00058507919311523 
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
312 0.0006 0.00062203407287598 
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
313 0.0033 0.0033268928527832 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
314 0.0011 0.001086950302124 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
315 0.0034 0.0034000873565674 
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
316 0.0021 0.002100944519043 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
317 0.0006 0.00056219100952148 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
318 0.0007 0.00073695182800293 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
319 0.0007 0.00074005126953125 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'