0

Wait! We have a something for you...

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

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

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.6338860988617 336 0.8887 0


No Amazon API Requests Made.


App Debug - Total Time 1.6338860988617 seconds

Number Time From Start Name Description
1 0.6650869846344 Initialise Initialise FSB Function
2 0.6726291179657 App Controller Start Start of the App controller (called before the controller of every page)
3 1.267942905426 App Controller End End of the App controller (called before the controller of every page)
4 1.2684218883514 Category Start Start of the category controller
5 1.268424987793 Before Get Category Before getting the category information
6 1.278981924057 After Get Category After getting the category information
7 1.2789831161499 Before Get Category List Before getting the updated category list
8 1.2793879508972 Start of getCategoryListByGroup Function Before first category groups query
9 1.279755115509 After initial query Before first category groups query
10 1.2797570228577 Get Category List for Group Before the call to getCategoryList function
11 1.2797598838806 Start of GetCategoryList function Start of the function
12 1.2797629833221 Before getting categories Query to get specific category list
13 1.2802619934082 After getting categories Query to get specific category list
14 1.2802629470825 Before getting category custom Before call to function getCategoryCustom
15 1.2968969345093 After getting category custom After call to function getCategoryCustom
16 1.2969009876251 Before getting category custom Before call to function getCategoryCustom
17 1.307991027832 After getting category custom After call to function getCategoryCustom
18 1.307993888855 Before getting category custom Before call to function getCategoryCustom
19 1.3147709369659 After getting category custom After call to function getCategoryCustom
20 1.3147730827332 Before getting category custom Before call to function getCategoryCustom
21 1.3195910453796 After getting category custom After call to function getCategoryCustom
22 1.3195929527283 Before getting category custom Before call to function getCategoryCustom
23 1.3243908882141 After getting category custom After call to function getCategoryCustom
24 1.3243930339813 Before getting category custom Before call to function getCategoryCustom
25 1.3298859596252 After getting category custom After call to function getCategoryCustom
26 1.3298890590668 Before getting sub category list Before call to recursive function getCategoryList
27 1.3298919200897 Start of GetCategoryList function Start of the function
28 1.3298950195312 Before getting categories Query to get specific category list
29 1.3309800624847 After getting sub category list After call to recursive function getCategoryList
30 1.3309829235077 End of GetCategoryList function End of the function
31 1.3309919834137 Get Category List for Group Before the call to getCategoryList function
32 1.3309979438782 Start of GetCategoryList function Start of the function
33 1.331001996994 Before getting categories Query to get specific category list
34 1.3317649364471 End of getCategoryListByGroup Function Before return()
35 1.3317680358887 After Get Category List After getting the updated category list
36 1.331768989563 Before Category Images Before getting the category images
37 1.3325400352478 After Category Images After getting the category images
38 1.3336191177368 Before Sub Category Check Before checking for sub category or products category
39 1.3343040943146 Before Category Products Controller Before loading the category products controller
40 1.3349359035492 Start Category Products Start of Category Products Controller
41 1.3349549770355 After Pagination Options After pagination options in Category Products Controller
42 1.3355669975281 After Cache After Cache checking in Category Products Controller
43 1.3657600879669 After Filter Options After getting filter options and SQL in Category Products Controller
44 1.3670980930328 After Counting Products After counting products in the Category Products Controller
45 1.3677139282227 After Counting Bundles After counting bundles in the Category Products Controller
46 1.3683710098267 After Counting Products After counting products in the Category Products Controller
47 1.3703949451447 After Getting Products After getting products and bundles in the Category Products Controller
48 1.3704409599304 After Pagination Links After getting pagination listing links in the Category Products Controller
49 1.3704419136047 After Getting Bundle Details After getting full details for the bundles in the Category Products Controller
50 1.4756450653076 After Getting Product Details After getting full product details in the Category Products Controller
51 1.4843590259552 After Getting Product/Bundle Reviews After getting full product/bundle customer review in the Category Products Controller
52 1.4873631000519 App_after Controller Start Start of the App_after controller (called after the controller of every page)
53 1.4885239601135 Before Get Options Before the call to getOptions in the tpl class
54 1.5533709526062 After Get Options After the call to getOptions in the tpl class
55 1.5535440444946 App_after Controller End End of the App_after controller (called after the controller of every page)
56 1.5535728931427 Before Smarty Before passing everything over to Smarty in the Category Products Controller
57 1.6338639259338 After Loading sub/product controller After checking for sub category or products category and then loading the relevant controller
58 1.6338698863983 Finalizing debug Before the debug is output to the page.
59 1.6338849067688 End of App This is the end of the app logging, final timestamp


Query Debug - 336 Database Queries. Total time 0.8887 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0018 0.00177001953125
SELECT parameter, value FROM parameters
2 0.0063 0.006274938583374
SELECT * FROM `bad_bots`
3 0.0005 0.00046491622924805
SET time_zone = 'Europe/London'
4 0.0011 0.0011081695556641
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0011 0.0011029243469238
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"18.220.239.179\";}'
6 0.0008 0.0008080005645752
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1722079138'
7 0.0013 0.0012631416320801
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0006 0.00064396858215332
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0011 0.0010619163513184
SELECT id FROM pages WHERE pagename = 'chocolats-chauds' LIMIT 1
10 0.0010 0.0010108947753906
SELECT id FROM products WHERE pagename = 'chocolats-chauds' AND hidden = 0 LIMIT 1
11 0.0009 0.00089406967163086
SELECT id FROM ebay_products WHERE pagename = 'chocolats-chauds'
12 0.0008 0.00084185600280762
SELECT id FROM custom_products WHERE pagename = 'chocolats-chauds'
13 0.0009 0.00090789794921875
SELECT id FROM categories WHERE pagename = 'chocolats-chauds' LIMIT 1
14 0.0036 0.0036299228668213
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
15 0.0379 0.037933111190796
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
16 0.0007 0.0006861686706543
SELECT * FROM pages WHERE pagename = 'chocolats-chauds'
17 0.0016 0.0016188621520996
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
18 0.0007 0.00065398216247559
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
19 0.0007 0.0007331371307373
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.0005 0.00050497055053711
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
21 0.0011 0.0011050701141357
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
22 0.0012 0.0011909008026123
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
23 0.5432 0.54315400123596
SELECT * FROM ipgeocountries WHERE INET_ATON('18.220.239.179') >= INET_ATON(ip_start) AND INET_ATON('18.220.239.179') <= INET_ATON(ip_end)
24 0.0012 0.0012412071228027
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
25 0.0005 0.0004889965057373
SELECT * FROM countryredirects WHERE countrycode = 'US'
26 0.0007 0.00068402290344238
SELECT * FROM categories WHERE pagename = 'chocolats-chauds'
27 0.0010 0.00095391273498535
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
28 0.0005 0.00051283836364746
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
29 0.0005 0.00045990943908691
SELECT id FROM categories WHERE parent_id = '31'
30 0.0007 0.00073504447937012
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 
31 0.0006 0.00058913230895996
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 
32 0.0006 0.00062894821166992
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
33 0.0006 0.00061988830566406
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
34 0.0005 0.00045895576477051
SELECT id FROM categories WHERE parent_id = '31'
35 0.0008 0.00077009201049805
SELECT p.id FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (31) 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.0006 0.000640869140625
SELECT * FROM productimages WHERE product_id = '4953' ORDER BY sortorder ASC
37 0.0016 0.0016059875488281
SELECT * FROM categoryimages WHERE category_id = 31
38 0.0005 0.00048494338989258
SELECT * FROM categorygroups WHERE id = '1'
39 0.0008 0.00076389312744141
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 = '31'
		  AND p.offers > 0
		  AND p.hidden = 0
		  AND p.enabled = 1
		  AND p.parent = 0
		  AND p.price > 0
40 0.0005 0.00047111511230469
SELECT parent_id FROM categories WHERE id = '31'
41 0.0004 0.00039196014404297
SELECT parent_id FROM categories WHERE id = '31'
42 0.0004 0.00035715103149414
SELECT * FROM categorygroups ORDER BY sortorder ASC
43 0.0005 0.00047993659973145
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
44 0.0057 0.0057239532470703
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.0006 0.00063776969909668
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.0004 0.00041604042053223
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
47 0.0004 0.00042200088500977
SELECT id FROM categories WHERE parent_id = '26'
48 0.0070 0.0070080757141113
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.00063514709472656
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.0006 0.00060915946960449
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.0006 0.00058102607727051
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
52 0.0005 0.00050497055053711
SELECT * FROM categorygroups WHERE id = '1'
53 0.0035 0.0035409927368164
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.0006 0.00059604644775391
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.00052094459533691
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
56 0.0005 0.00046801567077637
SELECT id FROM categories WHERE parent_id = '27'
57 0.0037 0.0037422180175781
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.0005 0.00054597854614258
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.0006 0.00061607360839844
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.0005 0.00049495697021484
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
61 0.0005 0.00047993659973145
SELECT * FROM categorygroups WHERE id = '1'
62 0.0015 0.0014820098876953
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.00051689147949219
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.00041508674621582
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
65 0.0004 0.00041890144348145
SELECT id FROM categories WHERE parent_id = '28'
66 0.0016 0.0015709400177002
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.0005950927734375
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.0007 0.00069618225097656
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.0005 0.00050210952758789
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
70 0.0005 0.00049781799316406
SELECT * FROM categorygroups WHERE id = '1'
71 0.0006 0.0006411075592041
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
72 0.0005 0.00050210952758789
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
73 0.0004 0.00044107437133789
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
74 0.0004 0.00043106079101562
SELECT id FROM categories WHERE parent_id = '29'
75 0.0007 0.00067806243896484
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 
76 0.0005 0.00051116943359375
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 
77 0.0005 0.00052809715270996
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
78 0.0005 0.00049591064453125
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
79 0.0005 0.00048995018005371
SELECT * FROM categorygroups WHERE id = '1'
80 0.0006 0.0006108283996582
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
81 0.0005 0.00047993659973145
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
82 0.0004 0.00041508674621582
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
83 0.0004 0.00041508674621582
SELECT id FROM categories WHERE parent_id = '30'
84 0.0007 0.00068807601928711
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
85 0.0005 0.00051593780517578
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 
86 0.0005 0.00054407119750977
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
87 0.0006 0.00055384635925293
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
88 0.0005 0.00049901008605957
SELECT * FROM categorygroups WHERE id = '1'
89 0.0006 0.00061607360839844
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
90 0.0005 0.00052285194396973
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
91 0.0004 0.00037407875061035
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
92 0.0004 0.00038909912109375
SELECT id FROM categories WHERE parent_id = '31'
93 0.0008 0.00075387954711914
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
94 0.0005 0.0004730224609375
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 
95 0.0006 0.00057387351989746
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
96 0.0005 0.0005180835723877
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
97 0.0012 0.0011768341064453
SELECT * FROM categorygroups WHERE id = '1'
98 0.0011 0.0010690689086914
SELECT * FROM categories WHERE parent_id = '31'  AND hidden = 0 ORDER BY sortorder ASC
99 0.0008 0.00075006484985352
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
100 0.0008 0.00076007843017578
SELECT * FROM categoryimages WHERE category_id = 31
101 0.0010 0.001039981842041
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
102 0.0007 0.00066900253295898
SELECT * FROM categories WHERE parent_id = '31'
103 0.0141 0.014102935791016
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
104 0.0035 0.0035440921783447
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
105 0.0012 0.0011978149414062
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
106 0.0082 0.0082480907440186
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
107 0.0022 0.0021610260009766
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
108 0.0005 0.00052809715270996
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
109 0.0007 0.00073385238647461
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 = 31
		AND (c.prod_type = '' OR c.prod_type = 'amz')
		AND hidden = 0
		AND enabled = 1
		
		AND 1 = 1
110 0.0006 0.00057601928710938
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
		WHERE ep.id = c.product_id
		AND c.category_id = 31
		AND c.prod_type = 'ebay'
		AND hide = 0
111 0.0006 0.00060415267944336
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 = 31
			AND p.disabled = 0
			
			AND 1 = 1
112 0.0006 0.00064682960510254
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
		WHERE cp.id = c.product_id
		AND c.category_id = 31
		AND c.prod_type = 'custom'
		AND hide = 0
113 0.0020 0.0019700527191162
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 = 31
			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 = 31
		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 = 31
		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 = 31
			AND disabled = 0
			
			AND 1 = 1 ORDER BY salesrank ASC LIMIT 0, 18
114 0.0007 0.00072097778320312
SELECT * FROM products WHERE id = '4950'
115 0.0006 0.00060391426086426
SELECT * FROM productimages WHERE product_id = '4950' ORDER BY sortorder ASC
116 0.0007 0.00068497657775879
SELECT * FROM product_image_select WHERE product_id = '4950'
117 0.0005 0.00049805641174316
SELECT * FROM productcustomimages WHERE product_id = '4950'
118 0.0012 0.0012390613555908
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4950' AND a.name = n.originalname
119 0.0005 0.00050687789916992
SELECT * FROM productoffers WHERE product_id = '4950' AND merchantid = 'A1X6FK5RDHNB96'
120 0.0004 0.00040197372436523
SELECT * FROM productoffers
                WHERE product_id = '4950' AND price > 0
                ORDER BY price ASC LIMIT 1
121 0.0004 0.00044798851013184
SELECT value FROM productattributes WHERE product_id = '4950' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
122 0.0005 0.0005488395690918
SELECT * FROM products WHERE id = '4953'
123 0.0005 0.00052499771118164
SELECT * FROM productimages WHERE product_id = '4953' ORDER BY sortorder ASC
124 0.0006 0.00057697296142578
SELECT * FROM product_image_select WHERE product_id = '4953'
125 0.0004 0.00038814544677734
SELECT * FROM productcustomimages WHERE product_id = '4953'
126 0.0009 0.000946044921875
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4953' AND a.name = n.originalname
127 0.0005 0.00050783157348633
SELECT * FROM productoffers WHERE product_id = '4953' AND merchantid = 'A1X6FK5RDHNB96'
128 0.0005 0.00046801567077637
SELECT * FROM productoffers
                WHERE product_id = '4953' AND price > 0
                ORDER BY price ASC LIMIT 1
129 0.0004 0.00044107437133789
SELECT value FROM productattributes WHERE product_id = '4953' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
130 0.0006 0.00057697296142578
SELECT * FROM products WHERE id = '4939'
131 0.0006 0.00055408477783203
SELECT * FROM productimages WHERE product_id = '4939' ORDER BY sortorder ASC
132 0.0007 0.00066494941711426
SELECT * FROM product_image_select WHERE product_id = '4939'
133 0.0004 0.00044083595275879
SELECT * FROM productcustomimages WHERE product_id = '4939'
134 0.0012 0.0011739730834961
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4939' AND a.name = n.originalname
135 0.0005 0.00051498413085938
SELECT * FROM productoffers WHERE product_id = '4939' AND merchantid = 'A1X6FK5RDHNB96'
136 0.0005 0.00047183036804199
SELECT * FROM productoffers
                WHERE product_id = '4939' AND price > 0
                ORDER BY price ASC LIMIT 1
137 0.0005 0.00047492980957031
SELECT value FROM productattributes WHERE product_id = '4939' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
138 0.0006 0.00057101249694824
SELECT * FROM products WHERE id = '4940'
139 0.0005 0.00051593780517578
SELECT * FROM productimages WHERE product_id = '4940' ORDER BY sortorder ASC
140 0.0007 0.00067806243896484
SELECT * FROM product_image_select WHERE product_id = '4940'
141 0.0005 0.00049114227294922
SELECT * FROM productcustomimages WHERE product_id = '4940'
142 0.0009 0.00088787078857422
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4940' AND a.name = n.originalname
143 0.0006 0.00055289268493652
SELECT * FROM productoffers WHERE product_id = '4940' AND merchantid = 'A1X6FK5RDHNB96'
144 0.0005 0.00048112869262695
SELECT * FROM productoffers
                WHERE product_id = '4940' AND price > 0
                ORDER BY price ASC LIMIT 1
145 0.0005 0.00046992301940918
SELECT value FROM productattributes WHERE product_id = '4940' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
146 0.0006 0.00056910514831543
SELECT * FROM products WHERE id = '4948'
147 0.0005 0.0005040168762207
SELECT * FROM productimages WHERE product_id = '4948' ORDER BY sortorder ASC
148 0.0007 0.0006718635559082
SELECT * FROM product_image_select WHERE product_id = '4948'
149 0.0005 0.00047993659973145
SELECT * FROM productcustomimages WHERE product_id = '4948'
150 0.0010 0.00098490715026855
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4948' AND a.name = n.originalname
151 0.0005 0.00053501129150391
SELECT * FROM productoffers WHERE product_id = '4948' AND merchantid = 'A1X6FK5RDHNB96'
152 0.0005 0.00045990943908691
SELECT * FROM productoffers
                WHERE product_id = '4948' AND price > 0
                ORDER BY price ASC LIMIT 1
153 0.0005 0.00048112869262695
SELECT value FROM productattributes WHERE product_id = '4948' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
154 0.0006 0.00062298774719238
SELECT * FROM products WHERE id = '4941'
155 0.0006 0.00056886672973633
SELECT * FROM productimages WHERE product_id = '4941' ORDER BY sortorder ASC
156 0.0007 0.00068497657775879
SELECT * FROM product_image_select WHERE product_id = '4941'
157 0.0005 0.00045490264892578
SELECT * FROM productcustomimages WHERE product_id = '4941'
158 0.0012 0.0012390613555908
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4941' AND a.name = n.originalname
159 0.0006 0.00059103965759277
SELECT * FROM productoffers WHERE product_id = '4941' AND merchantid = 'A1X6FK5RDHNB96'
160 0.0005 0.00051999092102051
SELECT * FROM productoffers
                WHERE product_id = '4941' AND price > 0
                ORDER BY price ASC LIMIT 1
161 0.0005 0.00047397613525391
SELECT value FROM productattributes WHERE product_id = '4941' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
162 0.0006 0.00060391426086426
SELECT * FROM products WHERE id = '4952'
163 0.0005 0.00053191184997559
SELECT * FROM productimages WHERE product_id = '4952' ORDER BY sortorder ASC
164 0.0007 0.0006568431854248
SELECT * FROM product_image_select WHERE product_id = '4952'
165 0.0004 0.00043582916259766
SELECT * FROM productcustomimages WHERE product_id = '4952'
166 0.0009 0.00088691711425781
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4952' AND a.name = n.originalname
167 0.0005 0.00051784515380859
SELECT * FROM productoffers WHERE product_id = '4952' AND merchantid = 'A1X6FK5RDHNB96'
168 0.0005 0.00052809715270996
SELECT * FROM productoffers
                WHERE product_id = '4952' AND price > 0
                ORDER BY price ASC LIMIT 1
169 0.0005 0.0004730224609375
SELECT value FROM productattributes WHERE product_id = '4952' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
170 0.0006 0.00063586235046387
SELECT * FROM products WHERE id = '4951'
171 0.0008 0.00078105926513672
SELECT * FROM productimages WHERE product_id = '4951' ORDER BY sortorder ASC
172 0.0007 0.0006709098815918
SELECT * FROM product_image_select WHERE product_id = '4951'
173 0.0005 0.00047421455383301
SELECT * FROM productcustomimages WHERE product_id = '4951'
174 0.0012 0.0011961460113525
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4951' AND a.name = n.originalname
175 0.0005 0.00052595138549805
SELECT * FROM productoffers WHERE product_id = '4951' AND merchantid = 'A1X6FK5RDHNB96'
176 0.0004 0.00044012069702148
SELECT * FROM productoffers
                WHERE product_id = '4951' AND price > 0
                ORDER BY price ASC LIMIT 1
177 0.0004 0.00038504600524902
SELECT * FROM productoffers
                WHERE product_id = 4951
                ORDER BY price ASC LIMIT 1
178 0.0005 0.00047183036804199
SELECT value FROM productattributes
                WHERE product_id = '4951'
                AND name = 'ListPriceAmount'
179 0.0005 0.00048613548278809
SELECT value FROM productattributes WHERE product_id = '4951' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
180 0.0006 0.00061202049255371
SELECT * FROM products WHERE id = '4945'
181 0.0005 0.0005040168762207
SELECT * FROM productimages WHERE product_id = '4945' ORDER BY sortorder ASC
182 0.0006 0.00064301490783691
SELECT * FROM product_image_select WHERE product_id = '4945'
183 0.0005 0.00052809715270996
SELECT * FROM productcustomimages WHERE product_id = '4945'
184 0.0014 0.0014410018920898
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4945' AND a.name = n.originalname
185 0.0005 0.0005490779876709
SELECT * FROM productoffers WHERE product_id = '4945' AND merchantid = 'A1X6FK5RDHNB96'
186 0.0004 0.00044798851013184
SELECT * FROM productoffers
                WHERE product_id = '4945' AND price > 0
                ORDER BY price ASC LIMIT 1
187 0.0004 0.00044512748718262
SELECT * FROM productoffers
                WHERE product_id = 4945
                ORDER BY price ASC LIMIT 1
188 0.0005 0.00048398971557617
SELECT value FROM productattributes
                WHERE product_id = '4945'
                AND name = 'ListPriceAmount'
189 0.0010 0.00099492073059082
SELECT value FROM productattributes WHERE product_id = '4945' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
190 0.0007 0.00067710876464844
SELECT * FROM products WHERE id = '4946'
191 0.0005 0.00051593780517578
SELECT * FROM productimages WHERE product_id = '4946' ORDER BY sortorder ASC
192 0.0007 0.00072693824768066
SELECT * FROM product_image_select WHERE product_id = '4946'
193 0.0005 0.00048398971557617
SELECT * FROM productcustomimages WHERE product_id = '4946'
194 0.0010 0.0010249614715576
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4946' AND a.name = n.originalname
195 0.0006 0.00060606002807617
SELECT * FROM productoffers WHERE product_id = '4946' AND merchantid = 'A1X6FK5RDHNB96'
196 0.0005 0.00051379203796387
SELECT * FROM productoffers
                WHERE product_id = '4946' AND price > 0
                ORDER BY price ASC LIMIT 1
197 0.0005 0.00047183036804199
SELECT value FROM productattributes WHERE product_id = '4946' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
198 0.0007 0.00068187713623047
SELECT * FROM products WHERE id = '4947'
199 0.0008 0.00075721740722656
SELECT * FROM productimages WHERE product_id = '4947' ORDER BY sortorder ASC
200 0.0009 0.00093793869018555
SELECT * FROM product_image_select WHERE product_id = '4947'
201 0.0006 0.00059294700622559
SELECT * FROM productcustomimages WHERE product_id = '4947'
202 0.0013 0.0013120174407959
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4947' AND a.name = n.originalname
203 0.0006 0.00062894821166992
SELECT * FROM productoffers WHERE product_id = '4947' AND merchantid = 'A1X6FK5RDHNB96'
204 0.0011 0.001054048538208
SELECT * FROM productoffers
                WHERE product_id = '4947' AND price > 0
                ORDER BY price ASC LIMIT 1
205 0.0006 0.00060510635375977
SELECT value FROM productattributes WHERE product_id = '4947' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
206 0.0007 0.00069403648376465
SELECT * FROM products WHERE id = '4949'
207 0.0006 0.00063490867614746
SELECT * FROM productimages WHERE product_id = '4949' ORDER BY sortorder ASC
208 0.0008 0.00079894065856934
SELECT * FROM product_image_select WHERE product_id = '4949'
209 0.0006 0.00056815147399902
SELECT * FROM productcustomimages WHERE product_id = '4949'
210 0.0018 0.0018050670623779
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4949' AND a.name = n.originalname
211 0.0008 0.00080204010009766
SELECT * FROM productoffers WHERE product_id = '4949' AND merchantid = 'A1X6FK5RDHNB96'
212 0.0006 0.00056219100952148
SELECT * FROM productoffers
                WHERE product_id = '4949' AND price > 0
                ORDER BY price ASC LIMIT 1
213 0.0007 0.00070595741271973
SELECT value FROM productattributes WHERE product_id = '4949' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
214 0.0008 0.00081896781921387
SELECT * FROM products WHERE id = '4944'
215 0.0007 0.00068998336791992
SELECT * FROM productimages WHERE product_id = '4944' ORDER BY sortorder ASC
216 0.0010 0.00097513198852539
SELECT * FROM product_image_select WHERE product_id = '4944'
217 0.0006 0.00064301490783691
SELECT * FROM productcustomimages WHERE product_id = '4944'
218 0.0021 0.0021450519561768
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4944' AND a.name = n.originalname
219 0.0007 0.00071096420288086
SELECT * FROM productoffers WHERE product_id = '4944' AND merchantid = 'A1X6FK5RDHNB96'
220 0.0005 0.00053787231445312
SELECT * FROM productoffers
                WHERE product_id = '4944' AND price > 0
                ORDER BY price ASC LIMIT 1
221 0.0006 0.00061511993408203
SELECT * FROM productoffers
                WHERE product_id = 4944
                ORDER BY price ASC LIMIT 1
222 0.0006 0.00059199333190918
SELECT value FROM productattributes
                WHERE product_id = '4944'
                AND name = 'ListPriceAmount'
223 0.0007 0.00065517425537109
SELECT value FROM productattributes WHERE product_id = '4944' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
224 0.0007 0.00069022178649902
SELECT * FROM products WHERE id = '4942'
225 0.0006 0.00058889389038086
SELECT * FROM productimages WHERE product_id = '4942' ORDER BY sortorder ASC
226 0.0007 0.00073504447937012
SELECT * FROM product_image_select WHERE product_id = '4942'
227 0.0006 0.00062394142150879
SELECT * FROM productcustomimages WHERE product_id = '4942'
228 0.0013 0.001338005065918
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4942' AND a.name = n.originalname
229 0.0006 0.00064706802368164
SELECT * FROM productoffers WHERE product_id = '4942' AND merchantid = 'A1X6FK5RDHNB96'
230 0.0006 0.00056600570678711
SELECT * FROM productoffers
                WHERE product_id = '4942' AND price > 0
                ORDER BY price ASC LIMIT 1
231 0.0008 0.00079679489135742
SELECT value FROM productattributes WHERE product_id = '4942' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
232 0.0008 0.00077700614929199
SELECT * FROM products WHERE id = '4938'
233 0.0007 0.00072908401489258
SELECT * FROM productimages WHERE product_id = '4938' ORDER BY sortorder ASC
234 0.0008 0.00084996223449707
SELECT * FROM product_image_select WHERE product_id = '4938'
235 0.0005 0.00052285194396973
SELECT * FROM productcustomimages WHERE product_id = '4938'
236 0.0012 0.0012118816375732
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4938' AND a.name = n.originalname
237 0.0014 0.001352071762085
SELECT * FROM productoffers WHERE product_id = '4938' AND merchantid = 'A1X6FK5RDHNB96'
238 0.0010 0.0010108947753906
SELECT * FROM productoffers
                WHERE product_id = '4938' AND price > 0
                ORDER BY price ASC LIMIT 1
239 0.0008 0.00076103210449219
SELECT * FROM productoffers
                WHERE product_id = 4938
                ORDER BY price ASC LIMIT 1
240 0.0008 0.00080990791320801
SELECT value FROM productattributes
                WHERE product_id = '4938'
                AND name = 'ListPriceAmount'
241 0.0012 0.0012359619140625
SELECT value FROM productattributes WHERE product_id = '4938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
242 0.0012 0.0011839866638184
SELECT * FROM products WHERE id = '4943'
243 0.0020 0.0020241737365723
SELECT * FROM productimages WHERE product_id = '4943' ORDER BY sortorder ASC
244 0.0019 0.0019350051879883
SELECT * FROM product_image_select WHERE product_id = '4943'
245 0.0010 0.00098705291748047
SELECT * FROM productcustomimages WHERE product_id = '4943'
246 0.0029 0.0029470920562744
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4943' AND a.name = n.originalname
247 0.0015 0.0014879703521729
SELECT * FROM productoffers WHERE product_id = '4943' AND merchantid = 'A1X6FK5RDHNB96'
248 0.0007 0.00073504447937012
SELECT * FROM productoffers
                WHERE product_id = '4943' AND price > 0
                ORDER BY price ASC LIMIT 1
249 0.0005 0.00049901008605957
SELECT * FROM productoffers
                WHERE product_id = 4943
                ORDER BY price ASC LIMIT 1
250 0.0008 0.00083494186401367
SELECT value FROM productattributes
                WHERE product_id = '4943'
                AND name = 'ListPriceAmount'
251 0.0010 0.00096607208251953
SELECT value FROM productattributes WHERE product_id = '4943' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
252 0.0007 0.00074100494384766
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4950' ORDER BY timestamp DESC
253 0.0005 0.00049304962158203
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4953' ORDER BY timestamp DESC
254 0.0006 0.0005950927734375
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4939' ORDER BY timestamp DESC
255 0.0006 0.00057411193847656
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4940' ORDER BY timestamp DESC
256 0.0006 0.00056195259094238
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4948' ORDER BY timestamp DESC
257 0.0005 0.00048398971557617
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4941' ORDER BY timestamp DESC
258 0.0006 0.0005638599395752
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4952' ORDER BY timestamp DESC
259 0.0005 0.00046586990356445
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4951' ORDER BY timestamp DESC
260 0.0006 0.00056195259094238
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4945' ORDER BY timestamp DESC
261 0.0007 0.00066280364990234
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4946' ORDER BY timestamp DESC
262 0.0006 0.00062203407287598
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4947' ORDER BY timestamp DESC
263 0.0005 0.00048494338989258
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4949' ORDER BY timestamp DESC
264 0.0004 0.00042009353637695
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4944' ORDER BY timestamp DESC
265 0.0004 0.00039315223693848
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4942' ORDER BY timestamp DESC
266 0.0004 0.00044894218444824
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4938' ORDER BY timestamp DESC
267 0.0004 0.00042581558227539
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4943' ORDER BY timestamp DESC
268 0.0009 0.00085306167602539
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 = 31
		AND c.prod_type = 'ebay'
		AND hide = 0
269 0.0009 0.000885009765625
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
270 0.0006 0.00060415267944336
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
271 0.0006 0.00059700012207031
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
272 0.0005 0.00048303604125977
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
273 0.0181 0.018111944198608
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
274 0.0011 0.0010509490966797
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
275 0.0008 0.00082993507385254
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
276 0.0006 0.0006260871887207
SELECT * FROM products WHERE id = 1626
277 0.0006 0.00058984756469727
SELECT * FROM products WHERE id = 4041
278 0.0006 0.00057506561279297
SELECT * FROM products WHERE id = 4312
279 0.0008 0.00075411796569824
SELECT * FROM products WHERE id = 777
280 0.0007 0.00065398216247559
SELECT * FROM products WHERE id = 3881
281 0.0007 0.00066184997558594
SELECT * FROM products WHERE id = 4213
282 0.0006 0.00061988830566406
SELECT * FROM products WHERE id = '1626'
283 0.0009 0.00094199180603027
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
284 0.0010 0.00095510482788086
SELECT * FROM product_image_select WHERE product_id = '1626'
285 0.0007 0.0006709098815918
SELECT * FROM productcustomimages WHERE product_id = '1626'
286 0.0012 0.0011980533599854
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
287 0.0006 0.00056600570678711
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
288 0.0004 0.0004420280456543
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
289 0.0005 0.00049901008605957
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
290 0.0006 0.00063800811767578
SELECT * FROM products WHERE id = '4041'
291 0.0006 0.00057196617126465
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
292 0.0007 0.00074100494384766
SELECT * FROM product_image_select WHERE product_id = '4041'
293 0.0006 0.00059604644775391
SELECT * FROM productcustomimages WHERE product_id = '4041'
294 0.0015 0.0014770030975342
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
295 0.0007 0.0007011890411377
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
296 0.0005 0.00054597854614258
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
297 0.0005 0.00046586990356445
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
298 0.0006 0.00060510635375977
SELECT * FROM products WHERE id = '4312'
299 0.0005 0.00051617622375488
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
300 0.0008 0.00078105926513672
SELECT * FROM product_image_select WHERE product_id = '4312'
301 0.0006 0.0005640983581543
SELECT * FROM productcustomimages WHERE product_id = '4312'
302 0.0020 0.0020139217376709
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
303 0.0006 0.00058484077453613
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
304 0.0006 0.00056195259094238
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
305 0.0005 0.00045394897460938
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
306 0.0006 0.00063300132751465
SELECT * FROM products WHERE id = '777'
307 0.0005 0.00048995018005371
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
308 0.0006 0.00063109397888184
SELECT * FROM product_image_select WHERE product_id = '777'
309 0.0004 0.00041508674621582
SELECT * FROM productcustomimages WHERE product_id = '777'
310 0.0012 0.0011889934539795
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
311 0.0006 0.0005948543548584
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
312 0.0005 0.00054097175598145
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
313 0.0005 0.00046610832214355
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
314 0.0006 0.00057506561279297
SELECT * FROM products WHERE id = '3881'
315 0.0007 0.00073099136352539
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
316 0.0006 0.00063705444335938
SELECT * FROM product_image_select WHERE product_id = '3881'
317 0.0005 0.00046181678771973
SELECT * FROM productcustomimages WHERE product_id = '3881'
318 0.0013 0.0013351440429688
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
319 0.0005 0.00054097175598145
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
320 0.0007 0.00067305564880371
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
321 0.0006 0.00064396858215332
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
322 0.0008 0.00076699256896973
SELECT * FROM products WHERE id = '4213'
323 0.0008 0.00084710121154785
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
324 0.0007 0.00071811676025391
SELECT * FROM product_image_select WHERE product_id = '4213'
325 0.0004 0.0003960132598877
SELECT * FROM productcustomimages WHERE product_id = '4213'
326 0.0012 0.0011599063873291
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
327 0.0005 0.00049185752868652
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
328 0.0004 0.00040197372436523
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
329 0.0004 0.00043702125549316
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
330 0.0009 0.00087094306945801
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
331 0.0009 0.00088810920715332
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
332 0.0020 0.0020191669464111
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
333 0.0007 0.00070810317993164
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
334 0.0007 0.00069212913513184
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
335 0.0010 0.00095582008361816
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
336 0.0013 0.0012750625610352
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'