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.4665520191193 336 1.0753 0


No Amazon API Requests Made.


App Debug - Total Time 1.4665520191193 seconds

Number Time From Start Name Description
1 0.35795307159424 Initialise Initialise FSB Function
2 0.36290407180786 App Controller Start Start of the App controller (called before the controller of every page)
3 1.2783849239349 App Controller End End of the App controller (called before the controller of every page)
4 1.2785739898682 Category Start Start of the category controller
5 1.2785749435425 Before Get Category Before getting the category information
6 1.2843389511108 After Get Category After getting the category information
7 1.2843399047852 Before Get Category List Before getting the updated category list
8 1.2845869064331 Start of getCategoryListByGroup Function Before first category groups query
9 1.2848970890045 After initial query Before first category groups query
10 1.2848980426788 Get Category List for Group Before the call to getCategoryList function
11 1.2849009037018 Start of GetCategoryList function Start of the function
12 1.284903049469 Before getting categories Query to get specific category list
13 1.2852540016174 After getting categories Query to get specific category list
14 1.2852549552917 Before getting category custom Before call to function getCategoryCustom
15 1.2970249652863 After getting category custom After call to function getCategoryCustom
16 1.2970271110535 Before getting category custom Before call to function getCategoryCustom
17 1.3056359291077 After getting category custom After call to function getCategoryCustom
18 1.3056390285492 Before getting category custom Before call to function getCategoryCustom
19 1.3103001117706 After getting category custom After call to function getCategoryCustom
20 1.3103010654449 Before getting category custom Before call to function getCategoryCustom
21 1.3135149478912 After getting category custom After call to function getCategoryCustom
22 1.3135159015656 Before getting category custom Before call to function getCategoryCustom
23 1.3180019855499 After getting category custom After call to function getCategoryCustom
24 1.3180029392242 Before getting category custom Before call to function getCategoryCustom
25 1.3211750984192 After getting category custom After call to function getCategoryCustom
26 1.3211770057678 Before getting sub category list Before call to recursive function getCategoryList
27 1.3211789131165 Start of GetCategoryList function Start of the function
28 1.3211801052094 Before getting categories Query to get specific category list
29 1.3215270042419 After getting sub category list After call to recursive function getCategoryList
30 1.3215279579163 End of GetCategoryList function End of the function
31 1.3215339183807 Get Category List for Group Before the call to getCategoryList function
32 1.3215351104736 Start of GetCategoryList function Start of the function
33 1.3215370178223 Before getting categories Query to get specific category list
34 1.3218131065369 End of getCategoryListByGroup Function Before return()
35 1.3218150138855 After Get Category List After getting the updated category list
36 1.3218150138855 Before Category Images Before getting the category images
37 1.3221180438995 After Category Images After getting the category images
38 1.3224940299988 Before Sub Category Check Before checking for sub category or products category
39 1.3227560520172 Before Category Products Controller Before loading the category products controller
40 1.3231139183044 Start Category Products Start of Category Products Controller
41 1.3231301307678 After Pagination Options After pagination options in Category Products Controller
42 1.323518037796 After Cache After Cache checking in Category Products Controller
43 1.3361930847168 After Filter Options After getting filter options and SQL in Category Products Controller
44 1.3370730876923 After Counting Products After counting products in the Category Products Controller
45 1.3374791145325 After Counting Bundles After counting bundles in the Category Products Controller
46 1.3378551006317 After Counting Products After counting products in the Category Products Controller
47 1.3387830257416 After Getting Products After getting products and bundles in the Category Products Controller
48 1.3388140201569 After Pagination Links After getting pagination listing links in the Category Products Controller
49 1.3388149738312 After Getting Bundle Details After getting full details for the bundles in the Category Products Controller
50 1.3909690380096 After Getting Product Details After getting full product details in the Category Products Controller
51 1.3945460319519 After Getting Product/Bundle Reviews After getting full product/bundle customer review in the Category Products Controller
52 1.3958899974823 App_after Controller Start Start of the App_after controller (called after the controller of every page)
53 1.3965101242065 Before Get Options Before the call to getOptions in the tpl class
54 1.4324760437012 After Get Options After the call to getOptions in the tpl class
55 1.4325680732727 App_after Controller End End of the App_after controller (called after the controller of every page)
56 1.4325850009918 Before Smarty Before passing everything over to Smarty in the Category Products Controller
57 1.4665400981903 After Loading sub/product controller After checking for sub category or products category and then loading the relevant controller
58 1.4665429592133 Finalizing debug Before the debug is output to the page.
59 1.4665510654449 End of App This is the end of the app logging, final timestamp


Query Debug - 336 Database Queries. Total time 1.0753 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0015 0.001488208770752
SELECT parameter, value FROM parameters
2 0.0032 0.0031521320343018
SELECT * FROM `bad_bots`
3 0.0003 0.00026202201843262
SET time_zone = 'Europe/London'
4 0.0005 0.00049400329589844
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0005 0.00049805641174316
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"216.73.216.192\";}'
6 0.0004 0.00041604042053223
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1753874352'
7 0.0011 0.0011191368103027
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0003 0.00034880638122559
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0009 0.00085210800170898
SELECT id FROM pages WHERE pagename = 'chocolats-chauds' LIMIT 1
10 0.0009 0.00093293190002441
SELECT id FROM products WHERE pagename = 'chocolats-chauds' AND hidden = 0 LIMIT 1
11 0.0008 0.0007929801940918
SELECT id FROM ebay_products WHERE pagename = 'chocolats-chauds'
12 0.0007 0.00067782402038574
SELECT id FROM custom_products WHERE pagename = 'chocolats-chauds'
13 0.0007 0.00070881843566895
SELECT id FROM categories WHERE pagename = 'chocolats-chauds' LIMIT 1
14 0.0016 0.0015678405761719
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
15 0.0217 0.021682024002075
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
16 0.0004 0.00043511390686035
SELECT * FROM pages WHERE pagename = 'chocolats-chauds'
17 0.0020 0.001971960067749
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
18 0.0009 0.00092291831970215
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
19 0.0004 0.00042104721069336
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.0007 0.00073003768920898
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
21 0.0010 0.0010240077972412
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
22 0.0006 0.00057816505432129
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
23 0.8827 0.88270998001099
SELECT * FROM ipgeocountries WHERE INET_ATON('216.73.216.192') >= INET_ATON(ip_start) AND INET_ATON('216.73.216.192') <= INET_ATON(ip_end)
24 0.0009 0.00092196464538574
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
25 0.0004 0.00035190582275391
SELECT * FROM countryredirects WHERE countrycode = 'US'
26 0.0004 0.00040698051452637
SELECT * FROM categories WHERE pagename = 'chocolats-chauds'
27 0.0005 0.00050806999206543
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.0003 0.0002901554107666
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
29 0.0003 0.00025296211242676
SELECT id FROM categories WHERE parent_id = '31'
30 0.0004 0.00040483474731445
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.0003 0.00034093856811523
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.0004 0.00037097930908203
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.0003 0.00034022331237793
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
34 0.0003 0.0003199577331543
SELECT id FROM categories WHERE parent_id = '31'
35 0.0005 0.00048589706420898
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.0004 0.00037217140197754
SELECT * FROM productimages WHERE product_id = '4953' ORDER BY sortorder ASC
37 0.0003 0.00032806396484375
SELECT * FROM categoryimages WHERE category_id = 31
38 0.0003 0.00034785270690918
SELECT * FROM categorygroups WHERE id = '1'
39 0.0005 0.00046896934509277
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.0003 0.00034880638122559
SELECT parent_id FROM categories WHERE id = '31'
41 0.0002 0.00023984909057617
SELECT parent_id FROM categories WHERE id = '31'
42 0.0003 0.00029802322387695
SELECT * FROM categorygroups ORDER BY sortorder ASC
43 0.0003 0.00033211708068848
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
44 0.0046 0.0046379566192627
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.0004 0.00036287307739258
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
46 0.0003 0.00028514862060547
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
47 0.0003 0.0003199577331543
SELECT id FROM categories WHERE parent_id = '26'
48 0.0046 0.0046210289001465
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.0004 0.00042200088500977
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.0004 0.0003960132598877
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.0003 0.00033211708068848
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
52 0.0003 0.00030398368835449
SELECT * FROM categorygroups WHERE id = '1'
53 0.0030 0.0029990673065186
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.0004 0.00037002563476562
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.0003 0.00032377243041992
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
56 0.0003 0.00029802322387695
SELECT id FROM categories WHERE parent_id = '27'
57 0.0031 0.0031449794769287
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.0004 0.00037312507629395
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.0004 0.00037693977355957
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.0003 0.00034403800964355
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
61 0.0003 0.00030994415283203
SELECT * FROM categorygroups WHERE id = '1'
62 0.0011 0.001133918762207
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.0003 0.00034904479980469
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.0003 0.0002899169921875
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
65 0.0003 0.00030088424682617
SELECT id FROM categories WHERE parent_id = '28'
66 0.0012 0.0011599063873291
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.0003 0.00034809112548828
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.0004 0.00035905838012695
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.0003 0.00034403800964355
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
70 0.0003 0.00031113624572754
SELECT * FROM categorygroups WHERE id = '1'
71 0.0004 0.00040912628173828
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.0003 0.00031399726867676
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.0003 0.00027680397033691
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
74 0.0003 0.00029802322387695
SELECT id FROM categories WHERE parent_id = '29'
75 0.0005 0.00045084953308105
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.0004 0.00039792060852051
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.0004 0.00037980079650879
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.0003 0.00033402442932129
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
79 0.0003 0.0003049373626709
SELECT * FROM categorygroups WHERE id = '1'
80 0.0004 0.00037407875061035
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.0003 0.00031399726867676
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.0003 0.00028300285339355
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
83 0.0015 0.0015430450439453
SELECT id FROM categories WHERE parent_id = '30'
84 0.0005 0.00052499771118164
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.0004 0.00036501884460449
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.0004 0.00037407875061035
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.0003 0.00032997131347656
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
88 0.0003 0.00031399726867676
SELECT * FROM categorygroups WHERE id = '1'
89 0.0004 0.00041604042053223
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.0003 0.00032591819763184
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.0003 0.00028800964355469
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
92 0.0003 0.00030708312988281
SELECT id FROM categories WHERE parent_id = '31'
93 0.0004 0.00043892860412598
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.0003 0.00034904479980469
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.0003 0.00034999847412109
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.0003 0.00034213066101074
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
97 0.0003 0.00029301643371582
SELECT * FROM categorygroups WHERE id = '1'
98 0.0003 0.00034189224243164
SELECT * FROM categories WHERE parent_id = '31'  AND hidden = 0 ORDER BY sortorder ASC
99 0.0003 0.00027108192443848
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
100 0.0003 0.00029706954956055
SELECT * FROM categoryimages WHERE category_id = 31
101 0.0004 0.00035309791564941
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
102 0.0003 0.00025606155395508
SELECT * FROM categories WHERE parent_id = '31'
103 0.0045 0.0045499801635742
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
104 0.0014 0.0014240741729736
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
105 0.0004 0.00042486190795898
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
106 0.0045 0.0044550895690918
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
107 0.0013 0.0012600421905518
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
108 0.0004 0.00036811828613281
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
109 0.0005 0.00050806999206543
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.0004 0.00035285949707031
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.0004 0.0003969669342041
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.0004 0.00036787986755371
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.0009 0.00088882446289062
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.0003 0.00029706954956055
SELECT * FROM products WHERE id = '4950'
115 0.0004 0.00037503242492676
SELECT * FROM productimages WHERE product_id = '4950' ORDER BY sortorder ASC
116 0.0005 0.00046300888061523
SELECT * FROM product_image_select WHERE product_id = '4950'
117 0.0003 0.00030899047851562
SELECT * FROM productcustomimages WHERE product_id = '4950'
118 0.0007 0.00070095062255859
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4950' AND a.name = n.originalname
119 0.0003 0.00034594535827637
SELECT * FROM productoffers WHERE product_id = '4950' AND merchantid = 'A1X6FK5RDHNB96'
120 0.0003 0.00031900405883789
SELECT * FROM productoffers
                WHERE product_id = '4950' AND price > 0
                ORDER BY price ASC LIMIT 1
121 0.0003 0.00032305717468262
SELECT value FROM productattributes WHERE product_id = '4950' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
122 0.0004 0.00037908554077148
SELECT * FROM products WHERE id = '4953'
123 0.0004 0.00036096572875977
SELECT * FROM productimages WHERE product_id = '4953' ORDER BY sortorder ASC
124 0.0005 0.00045204162597656
SELECT * FROM product_image_select WHERE product_id = '4953'
125 0.0003 0.00029301643371582
SELECT * FROM productcustomimages WHERE product_id = '4953'
126 0.0006 0.00063896179199219
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4953' AND a.name = n.originalname
127 0.0003 0.00032997131347656
SELECT * FROM productoffers WHERE product_id = '4953' AND merchantid = 'A1X6FK5RDHNB96'
128 0.0003 0.0002899169921875
SELECT * FROM productoffers
                WHERE product_id = '4953' AND price > 0
                ORDER BY price ASC LIMIT 1
129 0.0003 0.00028204917907715
SELECT value FROM productattributes WHERE product_id = '4953' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
130 0.0004 0.00035786628723145
SELECT * FROM products WHERE id = '4939'
131 0.0004 0.00035190582275391
SELECT * FROM productimages WHERE product_id = '4939' ORDER BY sortorder ASC
132 0.0005 0.00046300888061523
SELECT * FROM product_image_select WHERE product_id = '4939'
133 0.0003 0.00028109550476074
SELECT * FROM productcustomimages WHERE product_id = '4939'
134 0.0007 0.0007319450378418
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4939' AND a.name = n.originalname
135 0.0003 0.00033688545227051
SELECT * FROM productoffers WHERE product_id = '4939' AND merchantid = 'A1X6FK5RDHNB96'
136 0.0003 0.00031805038452148
SELECT * FROM productoffers
                WHERE product_id = '4939' AND price > 0
                ORDER BY price ASC LIMIT 1
137 0.0003 0.00029277801513672
SELECT value FROM productattributes WHERE product_id = '4939' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
138 0.0003 0.00033211708068848
SELECT * FROM products WHERE id = '4940'
139 0.0003 0.00030398368835449
SELECT * FROM productimages WHERE product_id = '4940' ORDER BY sortorder ASC
140 0.0005 0.0004570484161377
SELECT * FROM product_image_select WHERE product_id = '4940'
141 0.0003 0.0002748966217041
SELECT * FROM productcustomimages WHERE product_id = '4940'
142 0.0005 0.00054788589477539
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4940' AND a.name = n.originalname
143 0.0003 0.00033402442932129
SELECT * FROM productoffers WHERE product_id = '4940' AND merchantid = 'A1X6FK5RDHNB96'
144 0.0003 0.00029897689819336
SELECT * FROM productoffers
                WHERE product_id = '4940' AND price > 0
                ORDER BY price ASC LIMIT 1
145 0.0003 0.00029611587524414
SELECT value FROM productattributes WHERE product_id = '4940' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
146 0.0003 0.00034809112548828
SELECT * FROM products WHERE id = '4948'
147 0.0003 0.00033998489379883
SELECT * FROM productimages WHERE product_id = '4948' ORDER BY sortorder ASC
148 0.0005 0.00045490264892578
SELECT * FROM product_image_select WHERE product_id = '4948'
149 0.0003 0.00027799606323242
SELECT * FROM productcustomimages WHERE product_id = '4948'
150 0.0006 0.00060176849365234
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4948' AND a.name = n.originalname
151 0.0004 0.00037789344787598
SELECT * FROM productoffers WHERE product_id = '4948' AND merchantid = 'A1X6FK5RDHNB96'
152 0.0003 0.00029802322387695
SELECT * FROM productoffers
                WHERE product_id = '4948' AND price > 0
                ORDER BY price ASC LIMIT 1
153 0.0003 0.00029611587524414
SELECT value FROM productattributes WHERE product_id = '4948' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
154 0.0004 0.00035595893859863
SELECT * FROM products WHERE id = '4941'
155 0.0003 0.00032687187194824
SELECT * FROM productimages WHERE product_id = '4941' ORDER BY sortorder ASC
156 0.0005 0.00046610832214355
SELECT * FROM product_image_select WHERE product_id = '4941'
157 0.0003 0.00029397010803223
SELECT * FROM productcustomimages WHERE product_id = '4941'
158 0.0007 0.00070905685424805
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4941' AND a.name = n.originalname
159 0.0003 0.00032687187194824
SELECT * FROM productoffers WHERE product_id = '4941' AND merchantid = 'A1X6FK5RDHNB96'
160 0.0003 0.00029492378234863
SELECT * FROM productoffers
                WHERE product_id = '4941' AND price > 0
                ORDER BY price ASC LIMIT 1
161 0.0003 0.00031185150146484
SELECT value FROM productattributes WHERE product_id = '4941' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
162 0.0004 0.00035595893859863
SELECT * FROM products WHERE id = '4952'
163 0.0003 0.00031709671020508
SELECT * FROM productimages WHERE product_id = '4952' ORDER BY sortorder ASC
164 0.0005 0.00045895576477051
SELECT * FROM product_image_select WHERE product_id = '4952'
165 0.0003 0.00028491020202637
SELECT * FROM productcustomimages WHERE product_id = '4952'
166 0.0005 0.00054812431335449
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4952' AND a.name = n.originalname
167 0.0003 0.00034594535827637
SELECT * FROM productoffers WHERE product_id = '4952' AND merchantid = 'A1X6FK5RDHNB96'
168 0.0003 0.00029993057250977
SELECT * FROM productoffers
                WHERE product_id = '4952' AND price > 0
                ORDER BY price ASC LIMIT 1
169 0.0003 0.00031518936157227
SELECT value FROM productattributes WHERE product_id = '4952' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
170 0.0004 0.00042104721069336
SELECT * FROM products WHERE id = '4951'
171 0.0004 0.00040888786315918
SELECT * FROM productimages WHERE product_id = '4951' ORDER BY sortorder ASC
172 0.0005 0.00049018859863281
SELECT * FROM product_image_select WHERE product_id = '4951'
173 0.0003 0.0002739429473877
SELECT * FROM productcustomimages WHERE product_id = '4951'
174 0.0007 0.00065898895263672
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4951' AND a.name = n.originalname
175 0.0003 0.00030398368835449
SELECT * FROM productoffers WHERE product_id = '4951' AND merchantid = 'A1X6FK5RDHNB96'
176 0.0003 0.0002591609954834
SELECT * FROM productoffers
                WHERE product_id = '4951' AND price > 0
                ORDER BY price ASC LIMIT 1
177 0.0003 0.0002598762512207
SELECT * FROM productoffers
                WHERE product_id = 4951
                ORDER BY price ASC LIMIT 1
178 0.0003 0.00031113624572754
SELECT value FROM productattributes
                WHERE product_id = '4951'
                AND name = 'ListPriceAmount'
179 0.0003 0.00030899047851562
SELECT value FROM productattributes WHERE product_id = '4951' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
180 0.0003 0.00034093856811523
SELECT * FROM products WHERE id = '4945'
181 0.0003 0.00034809112548828
SELECT * FROM productimages WHERE product_id = '4945' ORDER BY sortorder ASC
182 0.0005 0.0004570484161377
SELECT * FROM product_image_select WHERE product_id = '4945'
183 0.0003 0.00026607513427734
SELECT * FROM productcustomimages WHERE product_id = '4945'
184 0.0007 0.0007171630859375
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4945' AND a.name = n.originalname
185 0.0003 0.0003049373626709
SELECT * FROM productoffers WHERE product_id = '4945' AND merchantid = 'A1X6FK5RDHNB96'
186 0.0003 0.00025391578674316
SELECT * FROM productoffers
                WHERE product_id = '4945' AND price > 0
                ORDER BY price ASC LIMIT 1
187 0.0002 0.00023794174194336
SELECT * FROM productoffers
                WHERE product_id = 4945
                ORDER BY price ASC LIMIT 1
188 0.0003 0.0002598762512207
SELECT value FROM productattributes
                WHERE product_id = '4945'
                AND name = 'ListPriceAmount'
189 0.0003 0.00029301643371582
SELECT value FROM productattributes WHERE product_id = '4945' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
190 0.0003 0.00034308433532715
SELECT * FROM products WHERE id = '4946'
191 0.0004 0.00035715103149414
SELECT * FROM productimages WHERE product_id = '4946' ORDER BY sortorder ASC
192 0.0004 0.00043821334838867
SELECT * FROM product_image_select WHERE product_id = '4946'
193 0.0003 0.00025606155395508
SELECT * FROM productcustomimages WHERE product_id = '4946'
194 0.0006 0.00056600570678711
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4946' AND a.name = n.originalname
195 0.0003 0.00031495094299316
SELECT * FROM productoffers WHERE product_id = '4946' AND merchantid = 'A1X6FK5RDHNB96'
196 0.0003 0.00028395652770996
SELECT * FROM productoffers
                WHERE product_id = '4946' AND price > 0
                ORDER BY price ASC LIMIT 1
197 0.0003 0.0003199577331543
SELECT value FROM productattributes WHERE product_id = '4946' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
198 0.0003 0.00033688545227051
SELECT * FROM products WHERE id = '4947'
199 0.0004 0.00036382675170898
SELECT * FROM productimages WHERE product_id = '4947' ORDER BY sortorder ASC
200 0.0005 0.00046801567077637
SELECT * FROM product_image_select WHERE product_id = '4947'
201 0.0003 0.00028300285339355
SELECT * FROM productcustomimages WHERE product_id = '4947'
202 0.0006 0.00058293342590332
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4947' AND a.name = n.originalname
203 0.0003 0.00031900405883789
SELECT * FROM productoffers WHERE product_id = '4947' AND merchantid = 'A1X6FK5RDHNB96'
204 0.0003 0.00028586387634277
SELECT * FROM productoffers
                WHERE product_id = '4947' AND price > 0
                ORDER BY price ASC LIMIT 1
205 0.0003 0.00028395652770996
SELECT value FROM productattributes WHERE product_id = '4947' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
206 0.0004 0.0003511905670166
SELECT * FROM products WHERE id = '4949'
207 0.0004 0.0003819465637207
SELECT * FROM productimages WHERE product_id = '4949' ORDER BY sortorder ASC
208 0.0005 0.00048089027404785
SELECT * FROM product_image_select WHERE product_id = '4949'
209 0.0003 0.00030803680419922
SELECT * FROM productcustomimages WHERE product_id = '4949'
210 0.0006 0.00061893463134766
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4949' AND a.name = n.originalname
211 0.0003 0.00034189224243164
SELECT * FROM productoffers WHERE product_id = '4949' AND merchantid = 'A1X6FK5RDHNB96'
212 0.0003 0.00028395652770996
SELECT * FROM productoffers
                WHERE product_id = '4949' AND price > 0
                ORDER BY price ASC LIMIT 1
213 0.0003 0.00033783912658691
SELECT value FROM productattributes WHERE product_id = '4949' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
214 0.0003 0.0003361701965332
SELECT * FROM products WHERE id = '4944'
215 0.0003 0.00033783912658691
SELECT * FROM productimages WHERE product_id = '4944' ORDER BY sortorder ASC
216 0.0005 0.00045299530029297
SELECT * FROM product_image_select WHERE product_id = '4944'
217 0.0003 0.00027894973754883
SELECT * FROM productcustomimages WHERE product_id = '4944'
218 0.0007 0.00071001052856445
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4944' AND a.name = n.originalname
219 0.0003 0.00031495094299316
SELECT * FROM productoffers WHERE product_id = '4944' AND merchantid = 'A1X6FK5RDHNB96'
220 0.0003 0.00026798248291016
SELECT * FROM productoffers
                WHERE product_id = '4944' AND price > 0
                ORDER BY price ASC LIMIT 1
221 0.0002 0.00024914741516113
SELECT * FROM productoffers
                WHERE product_id = 4944
                ORDER BY price ASC LIMIT 1
222 0.0003 0.00026988983154297
SELECT value FROM productattributes
                WHERE product_id = '4944'
                AND name = 'ListPriceAmount'
223 0.0003 0.00029897689819336
SELECT value FROM productattributes WHERE product_id = '4944' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
224 0.0003 0.00034308433532715
SELECT * FROM products WHERE id = '4942'
225 0.0003 0.00032615661621094
SELECT * FROM productimages WHERE product_id = '4942' ORDER BY sortorder ASC
226 0.0005 0.00047087669372559
SELECT * FROM product_image_select WHERE product_id = '4942'
227 0.0003 0.00028419494628906
SELECT * FROM productcustomimages WHERE product_id = '4942'
228 0.0007 0.00070691108703613
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4942' AND a.name = n.originalname
229 0.0003 0.00031805038452148
SELECT * FROM productoffers WHERE product_id = '4942' AND merchantid = 'A1X6FK5RDHNB96'
230 0.0003 0.00027704238891602
SELECT * FROM productoffers
                WHERE product_id = '4942' AND price > 0
                ORDER BY price ASC LIMIT 1
231 0.0003 0.00027990341186523
SELECT value FROM productattributes WHERE product_id = '4942' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
232 0.0003 0.0003361701965332
SELECT * FROM products WHERE id = '4938'
233 0.0003 0.00034689903259277
SELECT * FROM productimages WHERE product_id = '4938' ORDER BY sortorder ASC
234 0.0004 0.00044488906860352
SELECT * FROM product_image_select WHERE product_id = '4938'
235 0.0003 0.0002751350402832
SELECT * FROM productcustomimages WHERE product_id = '4938'
236 0.0007 0.00069093704223633
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4938' AND a.name = n.originalname
237 0.0003 0.00031614303588867
SELECT * FROM productoffers WHERE product_id = '4938' AND merchantid = 'A1X6FK5RDHNB96'
238 0.0003 0.00025105476379395
SELECT * FROM productoffers
                WHERE product_id = '4938' AND price > 0
                ORDER BY price ASC LIMIT 1
239 0.0002 0.00023412704467773
SELECT * FROM productoffers
                WHERE product_id = 4938
                ORDER BY price ASC LIMIT 1
240 0.0003 0.00025200843811035
SELECT value FROM productattributes
                WHERE product_id = '4938'
                AND name = 'ListPriceAmount'
241 0.0003 0.00027203559875488
SELECT value FROM productattributes WHERE product_id = '4938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
242 0.0003 0.00033307075500488
SELECT * FROM products WHERE id = '4943'
243 0.0003 0.00034904479980469
SELECT * FROM productimages WHERE product_id = '4943' ORDER BY sortorder ASC
244 0.0004 0.00044798851013184
SELECT * FROM product_image_select WHERE product_id = '4943'
245 0.0003 0.00027894973754883
SELECT * FROM productcustomimages WHERE product_id = '4943'
246 0.0006 0.00055289268493652
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4943' AND a.name = n.originalname
247 0.0003 0.00030708312988281
SELECT * FROM productoffers WHERE product_id = '4943' AND merchantid = 'A1X6FK5RDHNB96'
248 0.0003 0.00025510787963867
SELECT * FROM productoffers
                WHERE product_id = '4943' AND price > 0
                ORDER BY price ASC LIMIT 1
249 0.0002 0.00023603439331055
SELECT * FROM productoffers
                WHERE product_id = 4943
                ORDER BY price ASC LIMIT 1
250 0.0003 0.00026607513427734
SELECT value FROM productattributes
                WHERE product_id = '4943'
                AND name = 'ListPriceAmount'
251 0.0003 0.00028109550476074
SELECT value FROM productattributes WHERE product_id = '4943' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
252 0.0003 0.00029492378234863
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4950' ORDER BY timestamp DESC
253 0.0002 0.00021910667419434
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4953' ORDER BY timestamp DESC
254 0.0002 0.0002291202545166
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4939' ORDER BY timestamp DESC
255 0.0002 0.00020718574523926
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4940' ORDER BY timestamp DESC
256 0.0002 0.00022196769714355
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4948' ORDER BY timestamp DESC
257 0.0002 0.00024104118347168
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4941' ORDER BY timestamp DESC
258 0.0002 0.00020885467529297
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4952' ORDER BY timestamp DESC
259 0.0002 0.00020790100097656
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4951' ORDER BY timestamp DESC
260 0.0002 0.00021696090698242
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4945' ORDER BY timestamp DESC
261 0.0002 0.00020694732666016
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4946' ORDER BY timestamp DESC
262 0.0002 0.00020694732666016
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4947' ORDER BY timestamp DESC
263 0.0002 0.00020694732666016
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4949' ORDER BY timestamp DESC
264 0.0002 0.00021696090698242
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4944' ORDER BY timestamp DESC
265 0.0002 0.00021195411682129
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4942' ORDER BY timestamp DESC
266 0.0002 0.00021100044250488
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4938' ORDER BY timestamp DESC
267 0.0002 0.00021696090698242
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4943' ORDER BY timestamp DESC
268 0.0004 0.00036096572875977
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.0003 0.00034308433532715
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.0003 0.00034999847412109
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
271 0.0003 0.00032806396484375
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
272 0.0003 0.0002598762512207
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
273 0.0114 0.01138710975647
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.0004 0.00043797492980957
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.0004 0.00038003921508789
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.0003 0.00034093856811523
SELECT * FROM products WHERE id = 1626
277 0.0003 0.00028204917907715
SELECT * FROM products WHERE id = 4041
278 0.0003 0.00025320053100586
SELECT * FROM products WHERE id = 4312
279 0.0003 0.00027012825012207
SELECT * FROM products WHERE id = 777
280 0.0003 0.00030207633972168
SELECT * FROM products WHERE id = 3881
281 0.0003 0.00028419494628906
SELECT * FROM products WHERE id = 4213
282 0.0003 0.00025415420532227
SELECT * FROM products WHERE id = '1626'
283 0.0003 0.00031900405883789
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
284 0.0005 0.00045609474182129
SELECT * FROM product_image_select WHERE product_id = '1626'
285 0.0003 0.00031590461730957
SELECT * FROM productcustomimages WHERE product_id = '1626'
286 0.0006 0.00056791305541992
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
287 0.0003 0.00030994415283203
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
288 0.0003 0.00028109550476074
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
289 0.0003 0.00030303001403809
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
290 0.0003 0.00034093856811523
SELECT * FROM products WHERE id = '4041'
291 0.0004 0.00036287307739258
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
292 0.0005 0.00046300888061523
SELECT * FROM product_image_select WHERE product_id = '4041'
293 0.0003 0.00026202201843262
SELECT * FROM productcustomimages WHERE product_id = '4041'
294 0.0008 0.00075292587280273
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
295 0.0003 0.00030994415283203
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
296 0.0003 0.00029206275939941
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
297 0.0003 0.00027990341186523
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
298 0.0003 0.00034499168395996
SELECT * FROM products WHERE id = '4312'
299 0.0003 0.00030803680419922
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
300 0.0005 0.00045013427734375
SELECT * FROM product_image_select WHERE product_id = '4312'
301 0.0003 0.00025701522827148
SELECT * FROM productcustomimages WHERE product_id = '4312'
302 0.0007 0.00066089630126953
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
303 0.0003 0.00030207633972168
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
304 0.0003 0.00029706954956055
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
305 0.0003 0.00029397010803223
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
306 0.0003 0.00031614303588867
SELECT * FROM products WHERE id = '777'
307 0.0004 0.00037288665771484
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
308 0.0005 0.00046706199645996
SELECT * FROM product_image_select WHERE product_id = '777'
309 0.0003 0.00028014183044434
SELECT * FROM productcustomimages WHERE product_id = '777'
310 0.0006 0.00064992904663086
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
311 0.0003 0.00031900405883789
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
312 0.0003 0.0002751350402832
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
313 0.0003 0.00029397010803223
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
314 0.0003 0.00034594535827637
SELECT * FROM products WHERE id = '3881'
315 0.0004 0.00037002563476562
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
316 0.0005 0.00046300888061523
SELECT * FROM product_image_select WHERE product_id = '3881'
317 0.0003 0.00034117698669434
SELECT * FROM productcustomimages WHERE product_id = '3881'
318 0.0007 0.00073099136352539
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
319 0.0003 0.00032186508178711
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
320 0.0003 0.00029420852661133
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
321 0.0003 0.00029397010803223
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
322 0.0004 0.00036406517028809
SELECT * FROM products WHERE id = '4213'
323 0.0004 0.00038909912109375
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
324 0.0004 0.00044703483581543
SELECT * FROM product_image_select WHERE product_id = '4213'
325 0.0003 0.00027704238891602
SELECT * FROM productcustomimages WHERE product_id = '4213'
326 0.0007 0.00071501731872559
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
327 0.0004 0.00035285949707031
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
328 0.0003 0.0002901554107666
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
329 0.0003 0.00029587745666504
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
330 0.0006 0.00055909156799316
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
331 0.0006 0.0006098747253418
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
332 0.0013 0.0012791156768799
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
333 0.0004 0.00044584274291992
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
334 0.0004 0.00037384033203125
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
335 0.0004 0.00042319297790527
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
336 0.0004 0.00040817260742188
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'