0

Boîtes à thé

Wait! We have a something for you...

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

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

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
2.7883460521698 384 1.1264 0


No Amazon API Requests Made.


App Debug - Total Time 2.7883460521698 seconds

Number Time From Start Name Description
1 1.5903689861298 Initialise Initialise FSB Function
2 1.6026630401611 App Controller Start Start of the App controller (called before the controller of every page)
3 2.3740119934082 App Controller End End of the App controller (called before the controller of every page)
4 2.374321937561 Category Start Start of the category controller
5 2.3743228912354 Before Get Category Before getting the category information
6 2.4095900058746 After Get Category After getting the category information
7 2.4095919132233 Before Get Category List Before getting the updated category list
8 2.4099960327148 Start of getCategoryListByGroup Function Before first category groups query
9 2.4103419780731 After initial query Before first category groups query
10 2.4103429317474 Get Category List for Group Before the call to getCategoryList function
11 2.410346031189 Start of GetCategoryList function Start of the function
12 2.4103479385376 Before getting categories Query to get specific category list
13 2.4108009338379 After getting categories Query to get specific category list
14 2.4108018875122 Before getting category custom Before call to function getCategoryCustom
15 2.4252648353577 After getting category custom After call to function getCategoryCustom
16 2.4252669811249 Before getting sub category list Before call to recursive function getCategoryList
17 2.4252688884735 Start of GetCategoryList function Start of the function
18 2.4252710342407 Before getting categories Query to get specific category list
19 2.4258878231049 After getting sub category list After call to recursive function getCategoryList
20 2.4258899688721 Before getting category custom Before call to function getCategoryCustom
21 2.4372780323029 After getting category custom After call to function getCategoryCustom
22 2.4372808933258 Before getting category custom Before call to function getCategoryCustom
23 2.4435329437256 After getting category custom After call to function getCategoryCustom
24 2.4435348510742 Before getting category custom Before call to function getCategoryCustom
25 2.4478719234467 After getting category custom After call to function getCategoryCustom
26 2.4478750228882 Before getting category custom Before call to function getCategoryCustom
27 2.4523038864136 After getting category custom After call to function getCategoryCustom
28 2.4523060321808 Before getting category custom Before call to function getCategoryCustom
29 2.457267999649 After getting category custom After call to function getCategoryCustom
30 2.4572699069977 End of GetCategoryList function End of the function
31 2.4572768211365 Get Category List for Group Before the call to getCategoryList function
32 2.4572789669037 Start of GetCategoryList function Start of the function
33 2.4572808742523 Before getting categories Query to get specific category list
34 2.4578738212585 End of getCategoryListByGroup Function Before return()
35 2.4578769207001 After Get Category List After getting the updated category list
36 2.4578769207001 Before Category Images Before getting the category images
37 2.4584729671478 After Category Images After getting the category images
38 2.4602868556976 Before Sub Category Check Before checking for sub category or products category
39 2.4608278274536 Before Category Products Controller Before loading the category products controller
40 2.4613800048828 Start Category Products Start of Category Products Controller
41 2.4613959789276 After Pagination Options After pagination options in Category Products Controller
42 2.467887878418 After Cache After Cache checking in Category Products Controller
43 2.4865958690643 After Filter Options After getting filter options and SQL in Category Products Controller
44 2.493038892746 After Counting Products After counting products in the Category Products Controller
45 2.4935259819031 After Counting Bundles After counting bundles in the Category Products Controller
46 2.4941148757935 After Counting Products After counting products in the Category Products Controller
47 2.5066049098969 After Getting Products After getting products and bundles in the Category Products Controller
48 2.5066459178925 After Pagination Links After getting pagination listing links in the Category Products Controller
49 2.5066468715668 After Getting Bundle Details After getting full details for the bundles in the Category Products Controller
50 2.6460809707642 After Getting Product Details After getting full product details in the Category Products Controller
51 2.6531519889832 After Getting Product/Bundle Reviews After getting full product/bundle customer review in the Category Products Controller
52 2.655200958252 App_after Controller Start Start of the App_after controller (called after the controller of every page)
53 2.6569349765778 Before Get Options Before the call to getOptions in the tpl class
54 2.709007024765 After Get Options After the call to getOptions in the tpl class
55 2.7091279029846 App_after Controller End End of the App_after controller (called after the controller of every page)
56 2.7091488838196 Before Smarty Before passing everything over to Smarty in the Category Products Controller
57 2.7883348464966 After Loading sub/product controller After checking for sub category or products category and then loading the relevant controller
58 2.7883388996124 Finalizing debug Before the debug is output to the page.
59 2.7883460521698 End of App This is the end of the app logging, final timestamp


Query Debug - 384 Database Queries. Total time 1.1264 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0022 0.0022249221801758
SELECT parameter, value FROM parameters
2 0.0078 0.0078310966491699
SELECT * FROM `bad_bots`
3 0.0003 0.00034189224243164
SET time_zone = 'Europe/London'
4 0.0024 0.0024168491363525
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0023 0.0023391246795654
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:11:\"18.97.14.80\";}'
6 0.0023 0.0023088455200195
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1742302695'
7 0.0028 0.002791166305542
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0010 0.0010120868682861
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0024 0.0023849010467529
SELECT id FROM pages WHERE pagename = 'boites-the' LIMIT 1
10 0.0030 0.0030269622802734
SELECT id FROM products WHERE pagename = 'boites-the' AND hidden = 0 LIMIT 1
11 0.0020 0.0020451545715332
SELECT id FROM ebay_products WHERE pagename = 'boites-the'
12 0.0014 0.001439094543457
SELECT id FROM custom_products WHERE pagename = 'boites-the'
13 0.0019 0.0018579959869385
SELECT id FROM categories WHERE pagename = 'boites-the' LIMIT 1
14 0.0025 0.0024600028991699
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
15 0.0305 0.030534982681274
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
16 0.0006 0.00060391426086426
SELECT * FROM pages WHERE pagename = 'boites-the'
17 0.0035 0.003460168838501
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
18 0.0017 0.0016610622406006
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
19 0.0006 0.00061702728271484
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.0015 0.0014729499816895
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
21 0.0011 0.0010738372802734
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
22 0.0008 0.0008399486541748
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
23 0.7223 0.72228407859802
SELECT * FROM ipgeocountries WHERE INET_ATON('18.97.14.80') >= INET_ATON(ip_start) AND INET_ATON('18.97.14.80') <= INET_ATON(ip_end)
24 0.0029 0.0028810501098633
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
25 0.0016 0.0016090869903564
SELECT * FROM countryredirects WHERE countrycode = 'US'
26 0.0005 0.00053095817565918
SELECT * FROM categories WHERE pagename = 'boites-the'
27 0.0070 0.0069880485534668
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
28 0.0015 0.001535177230835
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
29 0.0005 0.00047612190246582
SELECT id FROM categories WHERE parent_id = '26'
30 0.0076 0.007580041885376
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 
31 0.0029 0.0028650760650635
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 
32 0.0009 0.00087308883666992
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
33 0.0019 0.0019259452819824
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
34 0.0005 0.0005190372467041
SELECT id FROM categories WHERE parent_id = '26'
35 0.0009 0.00087594985961914
SELECT p.id FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (26) AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
36 0.0017 0.0016939640045166
SELECT * FROM productimages WHERE product_id = '4122' ORDER BY sortorder ASC
37 0.0012 0.0011541843414307
SELECT * FROM categoryimages WHERE category_id = 26
38 0.0013 0.0012500286102295
SELECT * FROM categorygroups WHERE id = '1'
39 0.0063 0.0063090324401855
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 = '26'
		  AND p.offers > 0
		  AND p.hidden = 0
		  AND p.enabled = 1
		  AND p.parent = 0
		  AND p.price > 0
40 0.0005 0.00049901008605957
SELECT parent_id FROM categories WHERE id = '26'
41 0.0004 0.00039196014404297
SELECT parent_id FROM categories WHERE id = '26'
42 0.0003 0.0003359317779541
SELECT * FROM categorygroups ORDER BY sortorder ASC
43 0.0004 0.00043511390686035
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
44 0.0051 0.005141019821167
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.00056791305541992
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.00043988227844238
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
47 0.0005 0.00049495697021484
SELECT id FROM categories WHERE parent_id = '26'
48 0.0056 0.0055921077728271
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.00056099891662598
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.00058317184448242
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.0005 0.00052404403686523
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
52 0.0005 0.0004580020904541
SELECT * FROM categorygroups WHERE id = '1'
53 0.0006 0.0006098747253418
SELECT * FROM categories WHERE parent_id = '26'  AND hidden = 0 ORDER BY sortorder ASC
54 0.0038 0.0038089752197266
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
55 0.0005 0.0005490779876709
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
56 0.0004 0.00039196014404297
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
57 0.0005 0.00046610832214355
SELECT id FROM categories WHERE parent_id = '27'
58 0.0040 0.0039999485015869
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
59 0.0006 0.00060391426086426
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
60 0.0005 0.00052499771118164
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
61 0.0005 0.00050592422485352
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
62 0.0004 0.00043916702270508
SELECT * FROM categorygroups WHERE id = '1'
63 0.0015 0.0014798641204834
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
64 0.0006 0.00057315826416016
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
65 0.0004 0.00040507316589355
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
66 0.0004 0.0003960132598877
SELECT id FROM categories WHERE parent_id = '28'
67 0.0015 0.0014588832855225
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
68 0.0005 0.00050091743469238
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0 
69 0.0005 0.00048089027404785
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
70 0.0005 0.00046300888061523
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
71 0.0004 0.00041389465332031
SELECT * FROM categorygroups WHERE id = '1'
72 0.0006 0.00060296058654785
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
73 0.0004 0.00043106079101562
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
74 0.0004 0.00035309791564941
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
75 0.0004 0.00038814544677734
SELECT id FROM categories WHERE parent_id = '29'
76 0.0007 0.0006558895111084
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
77 0.0005 0.00046491622924805
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0 
78 0.0005 0.00048398971557617
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
79 0.0005 0.00051617622375488
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
80 0.0004 0.00037503242492676
SELECT * FROM categorygroups WHERE id = '1'
81 0.0005 0.00050711631774902
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
82 0.0004 0.00041007995605469
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
83 0.0004 0.00042891502380371
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
84 0.0005 0.00052189826965332
SELECT id FROM categories WHERE parent_id = '30'
85 0.0007 0.00069308280944824
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
86 0.0004 0.00043010711669922
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0 
87 0.0005 0.00049686431884766
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
88 0.0005 0.00046992301940918
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
89 0.0004 0.0003969669342041
SELECT * FROM categorygroups WHERE id = '1'
90 0.0006 0.00058913230895996
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
91 0.0005 0.00046014785766602
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
92 0.0004 0.00042295455932617
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
93 0.0004 0.00043296813964844
SELECT id FROM categories WHERE parent_id = '31'
94 0.0007 0.00067305564880371
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
95 0.0005 0.00052189826965332
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
96 0.0008 0.00075387954711914
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
97 0.0006 0.00057411193847656
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
98 0.0005 0.00046110153198242
SELECT * FROM categorygroups WHERE id = '1'
99 0.0006 0.00058388710021973
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
100 0.0006 0.00058722496032715
SELECT * FROM categoryimages WHERE category_id = 26
101 0.0018 0.0017871856689453
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
102 0.0005 0.00053501129150391
SELECT * FROM categories WHERE parent_id = '26'
103 0.0061 0.0061321258544922
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
104 0.0021 0.0020968914031982
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
105 0.0021 0.002140998840332
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
106 0.0060 0.0060160160064697
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
107 0.0016 0.0015859603881836
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
108 0.0005 0.00053501129150391
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
109 0.0059 0.0058939456939697
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 = 26
		AND (c.prod_type = '' OR c.prod_type = 'amz')
		AND hidden = 0
		AND enabled = 1
		
		AND 1 = 1
110 0.0005 0.00052618980407715
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
		WHERE ep.id = c.product_id
		AND c.category_id = 26
		AND c.prod_type = 'ebay'
		AND hide = 0
111 0.0005 0.00047588348388672
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 = 26
			AND p.disabled = 0
			
			AND 1 = 1
112 0.0006 0.00058388710021973
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
		WHERE cp.id = c.product_id
		AND c.category_id = 26
		AND c.prod_type = 'custom'
		AND hide = 0
113 0.0124 0.012448072433472
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 = 26
			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 = 26
		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 = 26
		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 = 26
			AND disabled = 0
			
			AND 1 = 1 ORDER BY salesrank ASC LIMIT 0, 18
114 0.0009 0.00086808204650879
SELECT * FROM products WHERE id = '4122'
115 0.0018 0.0017518997192383
SELECT * FROM productimages WHERE product_id = '4122' ORDER BY sortorder ASC
116 0.0038 0.0038270950317383
SELECT * FROM product_image_select WHERE product_id = '4122'
117 0.0029 0.0028610229492188
SELECT * FROM productcustomimages WHERE product_id = '4122'
118 0.0058 0.0058448314666748
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4122' AND a.name = n.originalname
119 0.0027 0.0027170181274414
SELECT * FROM productoffers WHERE product_id = '4122' AND merchantid = 'A1X6FK5RDHNB96'
120 0.0006 0.00064206123352051
SELECT * FROM productoffers
                WHERE product_id = '4122' AND price > 0
                ORDER BY price ASC LIMIT 1
121 0.0010 0.0009760856628418
SELECT value FROM productattributes WHERE product_id = '4122' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
122 0.0008 0.00077390670776367
SELECT * FROM products WHERE id = '4287'
123 0.0009 0.00086402893066406
SELECT * FROM productimages WHERE product_id = '4287' ORDER BY sortorder ASC
124 0.0009 0.00093793869018555
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4287' AND p.id = pi.product_id ORDER BY pi.sortorder
125 0.0011 0.0010740756988525
SELECT * FROM product_image_select WHERE product_id = '4287'
126 0.0006 0.00055909156799316
SELECT * FROM productcustomimages WHERE product_id = '4287'
127 0.0009 0.00088191032409668
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4287'
                GROUP BY o.product_id
128 0.0039 0.0038838386535645
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4287'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
129 0.0007 0.00069403648376465
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4287
130 0.0012 0.0011911392211914
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4287' AND a.name = n.originalname
131 0.0006 0.00059103965759277
SELECT * FROM productoffers WHERE product_id = '4287' AND merchantid = 'A1X6FK5RDHNB96'
132 0.0005 0.00046610832214355
SELECT * FROM productoffers
                WHERE product_id = '4287' AND price > 0
                ORDER BY price ASC LIMIT 1
133 0.0005 0.00046801567077637
SELECT * FROM productoffers
                WHERE product_id = 4287
                ORDER BY price ASC LIMIT 1
134 0.0005 0.0005488395690918
SELECT value FROM productattributes
                WHERE product_id = '4287'
                AND name = 'ListPriceAmount'
135 0.0006 0.00061297416687012
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4287'
                GROUP BY o.product_id
136 0.0008 0.00083303451538086
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4287'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
137 0.0005 0.00049281120300293
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4287
138 0.0007 0.00073695182800293
SELECT value FROM productattributes WHERE product_id = '4287' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
139 0.0008 0.00079703330993652
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4287'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
140 0.0005 0.00046396255493164
SELECT * FROM products WHERE id = '2009'
141 0.0007 0.00065302848815918
SELECT * FROM productimages WHERE product_id = '2009' ORDER BY sortorder ASC
142 0.0008 0.00075197219848633
SELECT * FROM product_image_select WHERE product_id = '2009'
143 0.0005 0.00046992301940918
SELECT * FROM productcustomimages WHERE product_id = '2009'
144 0.0014 0.0013790130615234
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2009' AND a.name = n.originalname
145 0.0006 0.00064682960510254
SELECT * FROM productoffers WHERE product_id = '2009' AND merchantid = 'A1X6FK5RDHNB96'
146 0.0005 0.00050497055053711
SELECT * FROM productoffers
                WHERE product_id = '2009' AND price > 0
                ORDER BY price ASC LIMIT 1
147 0.0006 0.00056099891662598
SELECT value FROM productattributes WHERE product_id = '2009' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
148 0.0006 0.0006411075592041
SELECT * FROM products WHERE id = '770'
149 0.0006 0.00057220458984375
SELECT * FROM productimages WHERE product_id = '770' ORDER BY sortorder ASC
150 0.0007 0.00073695182800293
SELECT * FROM product_image_select WHERE product_id = '770'
151 0.0005 0.00045204162597656
SELECT * FROM productcustomimages WHERE product_id = '770'
152 0.0011 0.0011489391326904
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '770' AND a.name = n.originalname
153 0.0005 0.00054001808166504
SELECT * FROM productoffers WHERE product_id = '770' AND merchantid = 'A1X6FK5RDHNB96'
154 0.0004 0.0004270076751709
SELECT * FROM productoffers
                WHERE product_id = '770' AND price > 0
                ORDER BY price ASC LIMIT 1
155 0.0005 0.00053310394287109
SELECT value FROM productattributes WHERE product_id = '770' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
156 0.0006 0.00058317184448242
SELECT * FROM products WHERE id = '3809'
157 0.0006 0.0005500316619873
SELECT * FROM productimages WHERE product_id = '3809' ORDER BY sortorder ASC
158 0.0007 0.00066304206848145
SELECT * FROM product_image_select WHERE product_id = '3809'
159 0.0005 0.00054287910461426
SELECT * FROM productcustomimages WHERE product_id = '3809'
160 0.0011 0.0011270046234131
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3809' AND a.name = n.originalname
161 0.0006 0.00059700012207031
SELECT * FROM productoffers WHERE product_id = '3809' AND merchantid = 'A1X6FK5RDHNB96'
162 0.0005 0.00047492980957031
SELECT * FROM productoffers
                WHERE product_id = '3809' AND price > 0
                ORDER BY price ASC LIMIT 1
163 0.0005 0.00050997734069824
SELECT value FROM productattributes WHERE product_id = '3809' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
164 0.0006 0.00055193901062012
SELECT * FROM products WHERE id = '2698'
165 0.0006 0.00058197975158691
SELECT * FROM productimages WHERE product_id = '2698' ORDER BY sortorder ASC
166 0.0005 0.00053906440734863
SELECT * FROM product_image_select WHERE product_id = '2698'
167 0.0004 0.00039911270141602
SELECT * FROM productcustomimages WHERE product_id = '2698'
168 0.0012 0.0011858940124512
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2698' AND a.name = n.originalname
169 0.0005 0.00048398971557617
SELECT * FROM productoffers WHERE product_id = '2698' AND merchantid = 'A1X6FK5RDHNB96'
170 0.0004 0.00041699409484863
SELECT * FROM productoffers
                WHERE product_id = '2698' AND price > 0
                ORDER BY price ASC LIMIT 1
171 0.0004 0.00043296813964844
SELECT value FROM productattributes WHERE product_id = '2698' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
172 0.0005 0.00052189826965332
SELECT * FROM products WHERE id = '1273'
173 0.0005 0.00045299530029297
SELECT * FROM productimages WHERE product_id = '1273' ORDER BY sortorder ASC
174 0.0006 0.00060009956359863
SELECT * FROM product_image_select WHERE product_id = '1273'
175 0.0004 0.00039386749267578
SELECT * FROM productcustomimages WHERE product_id = '1273'
176 0.0010 0.0010249614715576
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1273' AND a.name = n.originalname
177 0.0005 0.00047492980957031
SELECT * FROM productoffers WHERE product_id = '1273' AND merchantid = 'A1X6FK5RDHNB96'
178 0.0004 0.00037813186645508
SELECT * FROM productoffers
                WHERE product_id = '1273' AND price > 0
                ORDER BY price ASC LIMIT 1
179 0.0004 0.00039291381835938
SELECT * FROM productoffers
                WHERE product_id = 1273
                ORDER BY price ASC LIMIT 1
180 0.0004 0.00041103363037109
SELECT value FROM productattributes
                WHERE product_id = '1273'
                AND name = 'ListPriceAmount'
181 0.0004 0.00043988227844238
SELECT value FROM productattributes WHERE product_id = '1273' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
182 0.0005 0.00052404403686523
SELECT * FROM products WHERE id = '822'
183 0.0005 0.00053501129150391
SELECT * FROM productimages WHERE product_id = '822' ORDER BY sortorder ASC
184 0.0005 0.00049090385437012
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '822' AND p.id = pi.product_id ORDER BY pi.sortorder
185 0.0006 0.00056290626525879
SELECT * FROM product_image_select WHERE product_id = '822'
186 0.0004 0.00036907196044922
SELECT * FROM productcustomimages WHERE product_id = '822'
187 0.0005 0.00052213668823242
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '822'
                GROUP BY o.product_id
188 0.0009 0.00089311599731445
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '822'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
189 0.0004 0.00041604042053223
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 822
190 0.0009 0.00092887878417969
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '822' AND a.name = n.originalname
191 0.0003 0.00034809112548828
SELECT * FROM productoffers WHERE product_id = '822' AND merchantid = 'A1X6FK5RDHNB96'
192 0.0003 0.00034999847412109
SELECT * FROM productoffers
                WHERE product_id = '822' AND price > 0
                ORDER BY price ASC LIMIT 1
193 0.0003 0.00031018257141113
SELECT * FROM productoffers
                WHERE product_id = 822
                ORDER BY price ASC LIMIT 1
194 0.0003 0.00034403800964355
SELECT value FROM productattributes
                WHERE product_id = '822'
                AND name = 'ListPriceAmount'
195 0.0004 0.00044679641723633
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '822'
                GROUP BY o.product_id
196 0.0006 0.00060892105102539
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '822'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
197 0.0007 0.00067496299743652
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 822
198 0.0024 0.0024089813232422
SELECT value FROM productattributes WHERE product_id = '822' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
199 0.0026 0.0026228427886963
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '822'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
200 0.0025 0.0025241374969482
SELECT * FROM products WHERE id = '836'
201 0.0023 0.0023491382598877
SELECT * FROM productimages WHERE product_id = '836' ORDER BY sortorder ASC
202 0.0007 0.00065803527832031
SELECT * FROM product_image_select WHERE product_id = '836'
203 0.0004 0.00043892860412598
SELECT * FROM productcustomimages WHERE product_id = '836'
204 0.0009 0.00091409683227539
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '836' AND a.name = n.originalname
205 0.0006 0.00064301490783691
SELECT * FROM productoffers WHERE product_id = '836' AND merchantid = 'A1X6FK5RDHNB96'
206 0.0004 0.00043702125549316
SELECT * FROM productoffers
                WHERE product_id = '836' AND price > 0
                ORDER BY price ASC LIMIT 1
207 0.0004 0.00040507316589355
SELECT value FROM productattributes WHERE product_id = '836' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
208 0.0005 0.0005180835723877
SELECT * FROM products WHERE id = '1979'
209 0.0005 0.00049591064453125
SELECT * FROM productimages WHERE product_id = '1979' ORDER BY sortorder ASC
210 0.0006 0.00064587593078613
SELECT * FROM product_image_select WHERE product_id = '1979'
211 0.0004 0.0004429817199707
SELECT * FROM productcustomimages WHERE product_id = '1979'
212 0.0011 0.0010859966278076
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1979' AND a.name = n.originalname
213 0.0006 0.00057101249694824
SELECT * FROM productoffers WHERE product_id = '1979' AND merchantid = 'A1X6FK5RDHNB96'
214 0.0004 0.00044083595275879
SELECT * FROM productoffers
                WHERE product_id = '1979' AND price > 0
                ORDER BY price ASC LIMIT 1
215 0.0005 0.00050711631774902
SELECT value FROM productattributes WHERE product_id = '1979' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
216 0.0006 0.00058722496032715
SELECT * FROM products WHERE id = '1274'
217 0.0006 0.00059008598327637
SELECT * FROM productimages WHERE product_id = '1274' ORDER BY sortorder ASC
218 0.0008 0.000823974609375
SELECT * FROM product_image_select WHERE product_id = '1274'
219 0.0005 0.00052189826965332
SELECT * FROM productcustomimages WHERE product_id = '1274'
220 0.0014 0.0014119148254395
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1274' AND a.name = n.originalname
221 0.0006 0.00061511993408203
SELECT * FROM productoffers WHERE product_id = '1274' AND merchantid = 'A1X6FK5RDHNB96'
222 0.0005 0.00046706199645996
SELECT * FROM productoffers
                WHERE product_id = '1274' AND price > 0
                ORDER BY price ASC LIMIT 1
223 0.0005 0.00053501129150391
SELECT value FROM productattributes WHERE product_id = '1274' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
224 0.0006 0.00057411193847656
SELECT * FROM products WHERE id = '850'
225 0.0007 0.00071406364440918
SELECT * FROM productimages WHERE product_id = '850' ORDER BY sortorder ASC
226 0.0005 0.00049114227294922
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '850' AND p.id = pi.product_id ORDER BY pi.sortorder
227 0.0006 0.00063705444335938
SELECT * FROM product_image_select WHERE product_id = '850'
228 0.0004 0.00040292739868164
SELECT * FROM productcustomimages WHERE product_id = '850'
229 0.0006 0.00057291984558105
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '850'
                GROUP BY o.product_id
230 0.0007 0.00065708160400391
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '850'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
231 0.0004 0.00043988227844238
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 850
232 0.0011 0.0010600090026855
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '850' AND a.name = n.originalname
233 0.0004 0.00039100646972656
SELECT * FROM productoffers WHERE product_id = '850' AND merchantid = 'A1X6FK5RDHNB96'
234 0.0004 0.00036311149597168
SELECT * FROM productoffers
                WHERE product_id = '850' AND price > 0
                ORDER BY price ASC LIMIT 1
235 0.0003 0.00033402442932129
SELECT * FROM productoffers
                WHERE product_id = 850
                ORDER BY price ASC LIMIT 1
236 0.0004 0.0004429817199707
SELECT value FROM productattributes
                WHERE product_id = '850'
                AND name = 'ListPriceAmount'
237 0.0005 0.00046586990356445
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '850'
                GROUP BY o.product_id
238 0.0006 0.00064396858215332
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '850'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
239 0.0005 0.00049185752868652
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 850
240 0.0006 0.0006260871887207
SELECT value FROM productattributes WHERE product_id = '850' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
241 0.0007 0.00072717666625977
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '850'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
242 0.0006 0.00061511993408203
SELECT * FROM products WHERE parent_id = '850'
243 0.0008 0.00082898139953613
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4891' AND a.name = n.originalname
244 0.0007 0.00069713592529297
SELECT * FROM productoffers WHERE product_id = '4891' AND merchantid = 'A1X6FK5RDHNB96'
245 0.0007 0.00065398216247559
SELECT * FROM productoffers
                WHERE product_id = '4891' AND price > 0
                ORDER BY price ASC LIMIT 1
246 0.0005 0.00051617622375488
SELECT * FROM products WHERE id = '2204'
247 0.0007 0.00070095062255859
SELECT * FROM productimages WHERE product_id = '2204' ORDER BY sortorder ASC
248 0.0009 0.00089287757873535
SELECT * FROM product_image_select WHERE product_id = '2204'
249 0.0006 0.00057482719421387
SELECT * FROM productcustomimages WHERE product_id = '2204'
250 0.0021 0.0020699501037598
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2204' AND a.name = n.originalname
251 0.0006 0.00056791305541992
SELECT * FROM productoffers WHERE product_id = '2204' AND merchantid = 'A1X6FK5RDHNB96'
252 0.0005 0.00051689147949219
SELECT * FROM productoffers
                WHERE product_id = '2204' AND price > 0
                ORDER BY price ASC LIMIT 1
253 0.0005 0.00052499771118164
SELECT value FROM productattributes WHERE product_id = '2204' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
254 0.0006 0.00063300132751465
SELECT * FROM products WHERE id = '1340'
255 0.0006 0.00062298774719238
SELECT * FROM productimages WHERE product_id = '1340' ORDER BY sortorder ASC
256 0.0008 0.0007941722869873
SELECT * FROM product_image_select WHERE product_id = '1340'
257 0.0004 0.00040102005004883
SELECT * FROM productcustomimages WHERE product_id = '1340'
258 0.0013 0.0013139247894287
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1340' AND a.name = n.originalname
259 0.0005 0.00052618980407715
SELECT * FROM productoffers WHERE product_id = '1340' AND merchantid = 'A1X6FK5RDHNB96'
260 0.0004 0.00041294097900391
SELECT * FROM productoffers
                WHERE product_id = '1340' AND price > 0
                ORDER BY price ASC LIMIT 1
261 0.0007 0.00074195861816406
SELECT value FROM productattributes WHERE product_id = '1340' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
262 0.0006 0.00064492225646973
SELECT * FROM products WHERE id = '1303'
263 0.0005 0.00054788589477539
SELECT * FROM productimages WHERE product_id = '1303' ORDER BY sortorder ASC
264 0.0007 0.00071096420288086
SELECT * FROM product_image_select WHERE product_id = '1303'
265 0.0004 0.00041508674621582
SELECT * FROM productcustomimages WHERE product_id = '1303'
266 0.0016 0.001643180847168
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1303' AND a.name = n.originalname
267 0.0005 0.00051307678222656
SELECT * FROM productoffers WHERE product_id = '1303' AND merchantid = 'A1X6FK5RDHNB96'
268 0.0004 0.00043511390686035
SELECT * FROM productoffers
                WHERE product_id = '1303' AND price > 0
                ORDER BY price ASC LIMIT 1
269 0.0004 0.00038003921508789
SELECT * FROM productoffers
                WHERE product_id = 1303
                ORDER BY price ASC LIMIT 1
270 0.0005 0.00045514106750488
SELECT value FROM productattributes
                WHERE product_id = '1303'
                AND name = 'ListPriceAmount'
271 0.0005 0.0004889965057373
SELECT value FROM productattributes WHERE product_id = '1303' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
272 0.0005 0.00048089027404785
SELECT * FROM products WHERE id = '1088'
273 0.0004 0.0004279613494873
SELECT * FROM productimages WHERE product_id = '1088' ORDER BY sortorder ASC
274 0.0006 0.00055789947509766
SELECT * FROM product_image_select WHERE product_id = '1088'
275 0.0003 0.0003349781036377
SELECT * FROM productcustomimages WHERE product_id = '1088'
276 0.0010 0.00095200538635254
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1088' AND a.name = n.originalname
277 0.0004 0.0004279613494873
SELECT * FROM productoffers WHERE product_id = '1088' AND merchantid = 'A1X6FK5RDHNB96'
278 0.0004 0.00035214424133301
SELECT * FROM productoffers
                WHERE product_id = '1088' AND price > 0
                ORDER BY price ASC LIMIT 1
279 0.0004 0.00037193298339844
SELECT value FROM productattributes WHERE product_id = '1088' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
280 0.0005 0.00045180320739746
SELECT * FROM products WHERE id = '1470'
281 0.0005 0.00047802925109863
SELECT * FROM productimages WHERE product_id = '1470' ORDER BY sortorder ASC
282 0.0006 0.00063204765319824
SELECT * FROM product_image_select WHERE product_id = '1470'
283 0.0004 0.00039196014404297
SELECT * FROM productcustomimages WHERE product_id = '1470'
284 0.0011 0.0010919570922852
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1470' AND a.name = n.originalname
285 0.0005 0.0005490779876709
SELECT * FROM productoffers WHERE product_id = '1470' AND merchantid = 'A1X6FK5RDHNB96'
286 0.0003 0.00034308433532715
SELECT * FROM productoffers
                WHERE product_id = '1470' AND price > 0
                ORDER BY price ASC LIMIT 1
287 0.0004 0.00035595893859863
SELECT * FROM productoffers
                WHERE product_id = 1470
                ORDER BY price ASC LIMIT 1
288 0.0004 0.00036215782165527
SELECT value FROM productattributes
                WHERE product_id = '1470'
                AND name = 'ListPriceAmount'
289 0.0004 0.00043296813964844
SELECT value FROM productattributes WHERE product_id = '1470' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
290 0.0006 0.00055909156799316
SELECT * FROM products WHERE id = '2156'
291 0.0004 0.00042915344238281
SELECT * FROM productimages WHERE product_id = '2156' ORDER BY sortorder ASC
292 0.0006 0.00060892105102539
SELECT * FROM product_image_select WHERE product_id = '2156'
293 0.0004 0.00035810470581055
SELECT * FROM productcustomimages WHERE product_id = '2156'
294 0.0008 0.00082111358642578
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2156' AND a.name = n.originalname
295 0.0005 0.00049710273742676
SELECT * FROM productoffers WHERE product_id = '2156' AND merchantid = 'A1X6FK5RDHNB96'
296 0.0004 0.00042819976806641
SELECT * FROM productoffers
                WHERE product_id = '2156' AND price > 0
                ORDER BY price ASC LIMIT 1
297 0.0005 0.00049805641174316
SELECT value FROM productattributes WHERE product_id = '2156' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
298 0.0016 0.0016250610351562
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4122' ORDER BY timestamp DESC
299 0.0004 0.00038695335388184
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4287' ORDER BY timestamp DESC
300 0.0003 0.00027608871459961
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2009' ORDER BY timestamp DESC
301 0.0004 0.00036501884460449
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '770' ORDER BY timestamp DESC
302 0.0003 0.00032806396484375
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3809' ORDER BY timestamp DESC
303 0.0003 0.00034809112548828
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2698' ORDER BY timestamp DESC
304 0.0004 0.00040292739868164
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1273' ORDER BY timestamp DESC
305 0.0003 0.00034999847412109
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '822' ORDER BY timestamp DESC
306 0.0003 0.00027799606323242
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '836' ORDER BY timestamp DESC
307 0.0003 0.00030398368835449
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1979' ORDER BY timestamp DESC
308 0.0003 0.00034499168395996
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1274' ORDER BY timestamp DESC
309 0.0004 0.00035500526428223
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '850' ORDER BY timestamp DESC
310 0.0003 0.00027084350585938
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2204' ORDER BY timestamp DESC
311 0.0003 0.00027799606323242
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1340' ORDER BY timestamp DESC
312 0.0003 0.00029087066650391
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1303' ORDER BY timestamp DESC
313 0.0003 0.00025701522827148
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1088' ORDER BY timestamp DESC
314 0.0003 0.0002601146697998
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1470' ORDER BY timestamp DESC
315 0.0003 0.00025796890258789
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2156' ORDER BY timestamp DESC
316 0.0005 0.0005180835723877
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 = 26
		AND c.prod_type = 'ebay'
		AND hide = 0
317 0.0005 0.00052499771118164
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
318 0.0005 0.00047993659973145
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
319 0.0013 0.0013101100921631
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
320 0.0004 0.00038719177246094
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
321 0.0133 0.013283967971802
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
322 0.0016 0.0016210079193115
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
323 0.0005 0.00053811073303223
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
324 0.0005 0.00052618980407715
SELECT * FROM products WHERE id = 1626
325 0.0004 0.00035595893859863
SELECT * FROM products WHERE id = 4041
326 0.0004 0.00037193298339844
SELECT * FROM products WHERE id = 4312
327 0.0004 0.00039196014404297
SELECT * FROM products WHERE id = 777
328 0.0004 0.00036311149597168
SELECT * FROM products WHERE id = 3881
329 0.0003 0.00034499168395996
SELECT * FROM products WHERE id = 4213
330 0.0003 0.0003349781036377
SELECT * FROM products WHERE id = '1626'
331 0.0004 0.00042295455932617
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
332 0.0006 0.00059914588928223
SELECT * FROM product_image_select WHERE product_id = '1626'
333 0.0004 0.0003809928894043
SELECT * FROM productcustomimages WHERE product_id = '1626'
334 0.0008 0.0007941722869873
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
335 0.0005 0.00051999092102051
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
336 0.0004 0.00041103363037109
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
337 0.0004 0.00042986869812012
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
338 0.0005 0.0005030632019043
SELECT * FROM products WHERE id = '4041'
339 0.0005 0.0004580020904541
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
340 0.0006 0.00061488151550293
SELECT * FROM product_image_select WHERE product_id = '4041'
341 0.0004 0.00042295455932617
SELECT * FROM productcustomimages WHERE product_id = '4041'
342 0.0012 0.0011940002441406
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
343 0.0005 0.00049400329589844
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
344 0.0004 0.00040221214294434
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
345 0.0004 0.00039291381835938
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
346 0.0005 0.00048303604125977
SELECT * FROM products WHERE id = '4312'
347 0.0005 0.00046896934509277
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
348 0.0006 0.00057601928710938
SELECT * FROM product_image_select WHERE product_id = '4312'
349 0.0004 0.00039291381835938
SELECT * FROM productcustomimages WHERE product_id = '4312'
350 0.0011 0.0010690689086914
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
351 0.0005 0.0004730224609375
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
352 0.0004 0.00043392181396484
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
353 0.0004 0.00041389465332031
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
354 0.0005 0.0005190372467041
SELECT * FROM products WHERE id = '777'
355 0.0005 0.00053191184997559
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
356 0.0006 0.00055694580078125
SELECT * FROM product_image_select WHERE product_id = '777'
357 0.0005 0.00046420097351074
SELECT * FROM productcustomimages WHERE product_id = '777'
358 0.0011 0.0011110305786133
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
359 0.0005 0.0005030632019043
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
360 0.0004 0.00043487548828125
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
361 0.0004 0.0004429817199707
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
362 0.0005 0.00050592422485352
SELECT * FROM products WHERE id = '3881'
363 0.0005 0.00045895576477051
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
364 0.0006 0.00062990188598633
SELECT * FROM product_image_select WHERE product_id = '3881'
365 0.0004 0.00038385391235352
SELECT * FROM productcustomimages WHERE product_id = '3881'
366 0.0011 0.0010981559753418
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
367 0.0005 0.00045609474182129
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
368 0.0004 0.00037407875061035
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
369 0.0005 0.00045895576477051
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
370 0.0005 0.00049686431884766
SELECT * FROM products WHERE id = '4213'
371 0.0005 0.00049710273742676
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
372 0.0006 0.00058507919311523
SELECT * FROM product_image_select WHERE product_id = '4213'
373 0.0004 0.00038385391235352
SELECT * FROM productcustomimages WHERE product_id = '4213'
374 0.0010 0.0010480880737305
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
375 0.0005 0.00047397613525391
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
376 0.0004 0.00036883354187012
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
377 0.0004 0.00043487548828125
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
378 0.0019 0.0019469261169434
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
379 0.0006 0.00064301490783691
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
380 0.0023 0.0023248195648193
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
381 0.0016 0.0015521049499512
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
382 0.0005 0.00046706199645996
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
383 0.0014 0.0013978481292725
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
384 0.0014 0.0013840198516846
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'