Thés verts

Matcha Premium 200 gr

à partir de €15,89
Disponible
1 to 18 de 66 produits
1 2 3 4

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
0.97254490852356 360 0.1634 0


No Amazon API Requests Made.

Total time 0.97254490852356 seconds

Number Time From Start Name Description
1 0.764976978302 Initialise Initialise FSB Function
2 0.76917791366577 App Controller Start Start of the App controller (called before the controller of every page)
3 0.77696681022644 App Controller End End of the App controller (called before the controller of every page)
4 0.7773449420929 Category Start Start of the category controller
5 0.77734804153442 Before Get Category Before getting the category information
6 0.78967785835266 After Get Category After getting the category information
7 0.78968000411987 Before Get Category List Before getting the updated category list
8 0.78989100456238 Start of getCategoryListByGroup Function Before first category groups query
9 0.79008388519287 After initial query Before first category groups query
10 0.79008603096008 Get Category List for Group Before the call to getCategoryList function
11 0.79008793830872 Start of GetCategoryList function Start of the function
12 0.79009103775024 Before getting categories Query to get specific category list
13 0.79039692878723 After getting categories Query to get specific category list
14 0.79039883613586 Before getting category custom Before call to function getCategoryCustom
15 0.79211783409119 After getting category custom After call to function getCategoryCustom
16 0.79212093353271 Before getting category custom Before call to function getCategoryCustom
17 0.80242395401001 After getting category custom After call to function getCategoryCustom
18 0.80242681503296 Before getting category custom Before call to function getCategoryCustom
19 0.80413794517517 After getting category custom After call to function getCategoryCustom
20 0.8041398525238 Before getting sub category list Before call to recursive function getCategoryList
21 0.80414199829102 Start of GetCategoryList function Start of the function
22 0.80414390563965 Before getting categories Query to get specific category list
23 0.80434989929199 After getting sub category list After call to recursive function getCategoryList
24 0.8043520450592 Before getting category custom Before call to function getCategoryCustom
25 0.80693483352661 After getting category custom After call to function getCategoryCustom
26 0.80693697929382 Before getting category custom Before call to function getCategoryCustom
27 0.81012797355652 After getting category custom After call to function getCategoryCustom
28 0.81012988090515 Before getting category custom Before call to function getCategoryCustom
29 0.81260681152344 After getting category custom After call to function getCategoryCustom
30 0.81260895729065 End of GetCategoryList function End of the function
31 0.81261396408081 End of getCategoryListByGroup Function Before return()
32 0.81261587142944 After Get Category List After getting the updated category list
33 0.81261682510376 Before Category Images Before getting the category images
34 0.81280589103699 After Category Images After getting the category images
35 0.81306982040405 Before Sub Category Check Before checking for sub category or products category
36 0.81341099739075 Before Category Products Controller Before loading the category products controller
37 0.81400203704834 Start Category Products Start of Category Products Controller
38 0.81401801109314 After Pagination Options After pagination options in Category Products Controller
39 0.8220329284668 After Cache After Cache checking in Category Products Controller
40 0.83068203926086 After Filter Options After getting filter options and SQL in Category Products Controller
41 0.83264994621277 After Counting Products After counting products in the Category Products Controller
42 0.83315181732178 After Counting Bundles After counting bundles in the Category Products Controller
43 0.8335018157959 After Counting Products After counting products in the Category Products Controller
44 0.83757495880127 After Getting Products After getting products and bundles in the Category Products Controller
45 0.83762192726135 After Pagination Links After getting pagination listing links in the Category Products Controller
46 0.83762288093567 After Getting Bundle Details After getting full details for the bundles in the Category Products Controller
47 0.91240286827087 After Getting Product Details After getting full product details in the Category Products Controller
48 0.92094993591309 After Getting Product/Bundle Reviews After getting full product/bundle customer review in the Category Products Controller
49 0.92209982872009 App_after Controller Start Start of the App_after controller (called after the controller of every page)
50 0.92261004447937 Before Get Options Before the call to getOptions in the tpl class
51 0.94331383705139 After Get Options After the call to getOptions in the tpl class
52 0.94354486465454 App_after Controller End End of the App_after controller (called after the controller of every page)
53 0.94356989860535 Before Smarty Before passing everything over to Smarty in the Category Products Controller
54 0.97252702713013 After Loading sub/product controller After checking for sub category or products category and then loading the relevant controller
55 0.9725329875946 Finalizing debug Before the debug is output to the page.
56 0.97254395484924 End of App This is the end of the app logging, final timestamp


Query Debug - 360 Database Queries. Total time 0.1634 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0004 0.00037503242492676
SELECT parameter, value FROM parameters
2 0.0008 0.00082778930664062
SELECT * FROM `bad_bots`
3 0.0002 0.0001990795135498
SET time_zone = 'Europe/London'
4 0.0002 0.00021505355834961
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0015 0.001471996307373
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:10:\"3.80.3.192\";}'
6 0.0009 0.00088095664978027
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1635201140'
7 0.0003 0.00033688545227051
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0002 0.0001978874206543
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0009 0.00091814994812012
SELECT id FROM pages WHERE pagename = 'thes-verts' LIMIT 1
10 0.0008 0.00080013275146484
SELECT id FROM products WHERE pagename = 'thes-verts' AND hidden = 0 LIMIT 1
11 0.0007 0.0007469654083252
SELECT id FROM ebay_products WHERE pagename = 'thes-verts'
12 0.0005 0.00049686431884766
SELECT id FROM custom_products WHERE pagename = 'thes-verts'
13 0.0005 0.00053596496582031
SELECT id FROM categories WHERE pagename = 'thes-verts' LIMIT 1
14 0.0010 0.0010261535644531
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
15 0.0012 0.0011868476867676
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
16 0.0004 0.00036883354187012
SELECT * FROM pages WHERE pagename = 'thes-verts'
17 0.0002 0.00019717216491699
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
18 0.0003 0.00034785270690918
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
19 0.0003 0.00026297569274902
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.0002 0.00016999244689941
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
21 0.0005 0.00051689147949219
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
22 0.0006 0.00055193901062012
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
23 0.0003 0.00027799606323242
SELECT * FROM ipgeocountries WHERE INET_ATON('3.80.3.192') >= INET_ATON(ip_start) AND INET_ATON('3.80.3.192') <= INET_ATON(ip_end)
24 0.0002 0.00020003318786621
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
25 0.0002 0.00018191337585449
SELECT * FROM countryredirects WHERE countrycode = 'US'
26 0.0004 0.0003960132598877
SELECT * FROM categories WHERE pagename = 'thes-verts'
27 0.0020 0.0020251274108887
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
28 0.0003 0.00027799606323242
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
29 0.0002 0.00019097328186035
SELECT id FROM categories WHERE parent_id = '28'
30 0.0016 0.0015530586242676
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
31 0.0002 0.00018692016601562
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0 
32 0.0002 0.00020599365234375
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
33 0.0002 0.00017619132995605
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
34 0.0002 0.00017285346984863
SELECT id FROM categories WHERE parent_id = '28'
35 0.0019 0.0018599033355713
SELECT p.id FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (28) AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
36 0.0017 0.001694917678833
SELECT * FROM productimages WHERE product_id = '4066' ORDER BY sortorder ASC
37 0.0006 0.00063395500183105
SELECT * FROM categoryimages WHERE category_id = 28
38 0.0002 0.00018191337585449
SELECT * FROM categorygroups WHERE id = '1'
39 0.0023 0.0023488998413086
SELECT MIN(p.price) as minprice, MAX(p.price) as maxprice
		FROM products p, products_categories c
		WHERE p.id = c.product_id
		  AND c.category_id = '28'
		  AND p.offers > 0
		  AND p.hidden = 0
		  AND p.enabled = 1
		  AND p.parent = 0
		  AND p.price > 0
40 0.0002 0.00020098686218262
SELECT parent_id FROM categories WHERE id = '28'
41 0.0002 0.00018596649169922
SELECT parent_id FROM categories WHERE id = '28'
42 0.0002 0.00018191337585449
SELECT * FROM categorygroups ORDER BY sortorder ASC
43 0.0003 0.00028491020202637
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
44 0.0002 0.00019097328186035
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.0002 0.00017499923706055
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.0002 0.00022196769714355
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
47 0.0002 0.00019192695617676
SELECT id FROM categories WHERE parent_id = '26'
48 0.0002 0.00015592575073242
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.0002 0.00018596649169922
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.0002 0.00017905235290527
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.0002 0.00016283988952637
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
52 0.0002 0.00015783309936523
SELECT * FROM categorygroups WHERE id = '1'
53 0.0047 0.0046701431274414
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.0002 0.00017404556274414
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.0002 0.00015997886657715
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
56 0.0002 0.00017309188842773
SELECT id FROM categories WHERE parent_id = '27'
57 0.0043 0.004317045211792
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.0002 0.00018787384033203
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.0002 0.00017595291137695
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.0002 0.00017094612121582
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
61 0.0002 0.00016999244689941
SELECT * FROM categorygroups WHERE id = '1'
62 0.0002 0.00018405914306641
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.0002 0.00015497207641602
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.0001 0.00014591217041016
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
65 0.0002 0.00020790100097656
SELECT id FROM categories WHERE parent_id = '28'
66 0.0002 0.00018000602722168
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.0002 0.00018906593322754
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.0002 0.00015902519226074
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.0002 0.00020003318786621
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
70 0.0002 0.00018405914306641
SELECT * FROM categorygroups WHERE id = '1'
71 0.0002 0.00019407272338867
SELECT * FROM categories WHERE parent_id = '28'  AND hidden = 0 ORDER BY sortorder ASC
72 0.0006 0.00055503845214844
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.0003 0.0002591609954834
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.0002 0.00017404556274414
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
75 0.0002 0.00018405914306641
SELECT id FROM categories WHERE parent_id = '29'
76 0.0005 0.0005190372467041
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.0002 0.00021505355834961
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.0002 0.00019621849060059
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.0002 0.00018501281738281
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
80 0.0002 0.00019311904907227
SELECT * FROM categorygroups WHERE id = '1'
81 0.0005 0.00048494338989258
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.0005 0.0004570484161377
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.0003 0.00033807754516602
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
84 0.0003 0.00030612945556641
SELECT id FROM categories WHERE parent_id = '30'
85 0.0007 0.0006709098815918
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.0002 0.0002288818359375
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.0002 0.00021100044250488
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.0002 0.00020813941955566
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
89 0.0002 0.00018000602722168
SELECT * FROM categorygroups WHERE id = '1'
90 0.0006 0.00059795379638672
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.0002 0.00018787384033203
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.0002 0.00018715858459473
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
93 0.0002 0.00021791458129883
SELECT id FROM categories WHERE parent_id = '31'
94 0.0005 0.00050592422485352
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.0002 0.00018310546875
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.0002 0.00016283988952637
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.0002 0.0001678466796875
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
98 0.0002 0.00016999244689941
SELECT * FROM categorygroups WHERE id = '1'
99 0.0002 0.00018000602722168
SELECT * FROM categoryimages WHERE category_id = 28
100 0.0002 0.00023508071899414
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
101 0.0003 0.00032901763916016
SELECT * FROM categories WHERE parent_id = '28'
102 0.0072 0.0072019100189209
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
103 0.0003 0.00028896331787109
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
104 0.0002 0.00020694732666016
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
105 0.0002 0.00017619132995605
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
106 0.0002 0.00023388862609863
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
107 0.0002 0.00019598007202148
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
108 0.0016 0.0016179084777832
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
		WHERE p.id = c.product_id AND parent_id = 0
		AND c.category_id = 28
		AND (c.prod_type = '' OR c.prod_type = 'amz')
		AND hidden = 0
		AND enabled = 1
		
		AND 1 = 1
109 0.0003 0.00032210350036621
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
		WHERE ep.id = c.product_id
		AND c.category_id = 28
		AND c.prod_type = 'ebay'
		AND hide = 0
110 0.0005 0.00048398971557617
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
			WHERE p.id = c.bundle_id AND parent_id = 0
			AND c.category_id = 28
			AND p.disabled = 0
			
			AND 1 = 1
111 0.0003 0.00033307075500488
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
		WHERE cp.id = c.product_id
		AND c.category_id = 28
		AND c.prod_type = 'custom'
		AND hide = 0
112 0.0040 0.004019021987915
SELECT DISTINCT (p.id), IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank, p.price, p.linktitle, p.pagename, 'product' AS type FROM products p, products_categories c
			WHERE p.id = c.product_id
			AND p.parent_id = 0
			AND c.category_id = 28
			AND hidden = 0
			AND enabled = 1
			
			AND 1 = 1 UNION SELECT DISTINCT (p.id), IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank, p.price, p.linktitle, p.pagename, 'ebay' AS type FROM ebay_products p, products_categories c
		WHERE p.id = c.product_id
		AND c.category_id = 28
		AND c.prod_type = 'ebay'
		AND p.hide = 0 UNION SELECT DISTINCT (p.id), IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank, p.price, p.linktitle, p.pagename, 'custom' AS type FROM custom_products p, products_categories c
		WHERE p.id = c.product_id
		AND c.category_id = 28
		AND c.prod_type = 'custom'
		AND p.hide = 0 UNION SELECT DISTINCT (p.id), IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank, p.price, p.linktitle, p.pagename, 'bundle' AS type FROM bundles p, bundle_categories c
			WHERE p.id = c.bundle_id
			AND c.category_id = 28
			AND disabled = 0
			
			AND 1 = 1 ORDER BY salesrank ASC LIMIT 0, 18
113 0.0006 0.00058698654174805
SELECT * FROM products WHERE id = '2029'
114 0.0005 0.00045490264892578
SELECT * FROM productimages WHERE product_id = '2029' ORDER BY sortorder ASC
115 0.0008 0.00081801414489746
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2029' AND p.id = pi.product_id ORDER BY pi.sortorder
116 0.0003 0.00031709671020508
SELECT * FROM product_image_select WHERE product_id = '2029'
117 0.0002 0.00021195411682129
SELECT * FROM productcustomimages WHERE product_id = '2029'
118 0.0008 0.00083589553833008
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 = '2029'
                GROUP BY o.product_id
119 0.0007 0.00068402290344238
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     = '2029'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
120 0.0003 0.00034809112548828
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2029
121 0.0009 0.00094985961914062
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2029' AND a.name = n.originalname
122 0.0003 0.00033807754516602
SELECT * FROM productoffers WHERE product_id = '2029' AND merchantid = 'A1X6FK5RDHNB96'
123 0.0005 0.00051403045654297
SELECT * FROM productoffers
                WHERE product_id = '2029' AND price > 0
                ORDER BY price ASC LIMIT 1
124 0.0007 0.0007319450378418
SELECT * FROM productoffers
                WHERE product_id = 2029
                ORDER BY price ASC LIMIT 1
125 0.0004 0.00036501884460449
SELECT value FROM productattributes
                WHERE product_id = '2029'
                AND name = 'ListPriceAmount'
126 0.0002 0.0002288818359375
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 = '2029'
                GROUP BY o.product_id
127 0.0002 0.0001828670501709
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     = '2029'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
128 0.0002 0.00019407272338867
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2029
129 0.0003 0.00034904479980469
SELECT value FROM productattributes WHERE product_id = '2029' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
130 0.0006 0.00059103965759277
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '2029'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
131 0.0012 0.0011641979217529
SELECT * FROM products WHERE id = '1287'
132 0.0004 0.00039982795715332
SELECT * FROM productimages WHERE product_id = '1287' ORDER BY sortorder ASC
133 0.0002 0.00021910667419434
SELECT * FROM product_image_select WHERE product_id = '1287'
134 0.0002 0.00018310546875
SELECT * FROM productcustomimages WHERE product_id = '1287'
135 0.0003 0.00026178359985352
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1287' AND a.name = n.originalname
136 0.0002 0.00020098686218262
SELECT * FROM productoffers WHERE product_id = '1287' AND merchantid = 'A1X6FK5RDHNB96'
137 0.0002 0.00020194053649902
SELECT * FROM productoffers
                WHERE product_id = '1287' AND price > 0
                ORDER BY price ASC LIMIT 1
138 0.0002 0.00021600723266602
SELECT value FROM productattributes WHERE product_id = '1287' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
139 0.0004 0.0004270076751709
SELECT * FROM products WHERE id = '1110'
140 0.0004 0.00042200088500977
SELECT * FROM productimages WHERE product_id = '1110' ORDER BY sortorder ASC
141 0.0002 0.00021696090698242
SELECT * FROM product_image_select WHERE product_id = '1110'
142 0.0002 0.00020194053649902
SELECT * FROM productcustomimages WHERE product_id = '1110'
143 0.0009 0.0009150505065918
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1110' AND a.name = n.originalname
144 0.0003 0.00031614303588867
SELECT * FROM productoffers WHERE product_id = '1110' AND merchantid = 'A1X6FK5RDHNB96'
145 0.0005 0.00053119659423828
SELECT * FROM productoffers
                WHERE product_id = '1110' AND price > 0
                ORDER BY price ASC LIMIT 1
146 0.0005 0.00046300888061523
SELECT value FROM productattributes WHERE product_id = '1110' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
147 0.0005 0.00045895576477051
SELECT * FROM products WHERE id = '4906'
148 0.0004 0.00042295455932617
SELECT * FROM productimages WHERE product_id = '4906' ORDER BY sortorder ASC
149 0.0002 0.0001978874206543
SELECT * FROM product_image_select WHERE product_id = '4906'
150 0.0002 0.00019288063049316
SELECT * FROM productcustomimages WHERE product_id = '4906'
151 0.0009 0.00086712837219238
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4906' AND a.name = n.originalname
152 0.0005 0.0004570484161377
SELECT * FROM productoffers WHERE product_id = '4906' AND merchantid = 'A1X6FK5RDHNB96'
153 0.0005 0.00052094459533691
SELECT * FROM productoffers
                WHERE product_id = '4906' AND price > 0
                ORDER BY price ASC LIMIT 1
154 0.0004 0.00041007995605469
SELECT value FROM productattributes WHERE product_id = '4906' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
155 0.0004 0.0004420280456543
SELECT * FROM products WHERE id = '1217'
156 0.0005 0.00045680999755859
SELECT * FROM productimages WHERE product_id = '1217' ORDER BY sortorder ASC
157 0.0003 0.00029182434082031
SELECT * FROM product_image_select WHERE product_id = '1217'
158 0.0002 0.00018906593322754
SELECT * FROM productcustomimages WHERE product_id = '1217'
159 0.0009 0.00092601776123047
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1217' AND a.name = n.originalname
160 0.0004 0.00042891502380371
SELECT * FROM productoffers WHERE product_id = '1217' AND merchantid = 'A1X6FK5RDHNB96'
161 0.0005 0.00045609474182129
SELECT * FROM productoffers
                WHERE product_id = '1217' AND price > 0
                ORDER BY price ASC LIMIT 1
162 0.0004 0.00041508674621582
SELECT value FROM productattributes WHERE product_id = '1217' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
163 0.0005 0.00051188468933105
SELECT * FROM products WHERE id = '970'
164 0.0004 0.00043606758117676
SELECT * FROM productimages WHERE product_id = '970' ORDER BY sortorder ASC
165 0.0002 0.00020503997802734
SELECT * FROM product_image_select WHERE product_id = '970'
166 0.0002 0.00020217895507812
SELECT * FROM productcustomimages WHERE product_id = '970'
167 0.0008 0.00084710121154785
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '970' AND a.name = n.originalname
168 0.0005 0.00048494338989258
SELECT * FROM productoffers WHERE product_id = '970' AND merchantid = 'A1X6FK5RDHNB96'
169 0.0005 0.00050020217895508
SELECT * FROM productoffers
                WHERE product_id = '970' AND price > 0
                ORDER BY price ASC LIMIT 1
170 0.0004 0.00035881996154785
SELECT value FROM productattributes WHERE product_id = '970' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
171 0.0005 0.00047183036804199
SELECT * FROM products WHERE id = '4904'
172 0.0004 0.00041413307189941
SELECT * FROM productimages WHERE product_id = '4904' ORDER BY sortorder ASC
173 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '4904'
174 0.0002 0.0001978874206543
SELECT * FROM productcustomimages WHERE product_id = '4904'
175 0.0010 0.00095391273498535
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4904' AND a.name = n.originalname
176 0.0003 0.00034904479980469
SELECT * FROM productoffers WHERE product_id = '4904' AND merchantid = 'A1X6FK5RDHNB96'
177 0.0005 0.00046515464782715
SELECT * FROM productoffers
                WHERE product_id = '4904' AND price > 0
                ORDER BY price ASC LIMIT 1
178 0.0004 0.0004279613494873
SELECT value FROM productattributes WHERE product_id = '4904' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
179 0.0004 0.00042891502380371
SELECT * FROM products WHERE id = '868'
180 0.0004 0.00040078163146973
SELECT * FROM productimages WHERE product_id = '868' ORDER BY sortorder ASC
181 0.0003 0.00032496452331543
SELECT * FROM product_image_select WHERE product_id = '868'
182 0.0002 0.00022387504577637
SELECT * FROM productcustomimages WHERE product_id = '868'
183 0.0002 0.00024104118347168
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '868' AND a.name = n.originalname
184 0.0003 0.0003201961517334
SELECT * FROM productoffers WHERE product_id = '868' AND merchantid = 'A1X6FK5RDHNB96'
185 0.0004 0.00037598609924316
SELECT * FROM productoffers
                WHERE product_id = '868' AND price > 0
                ORDER BY price ASC LIMIT 1
186 0.0003 0.00031399726867676
SELECT value FROM productattributes WHERE product_id = '868' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
187 0.0005 0.00046181678771973
SELECT * FROM products WHERE id = '1160'
188 0.0004 0.00044488906860352
SELECT * FROM productimages WHERE product_id = '1160' ORDER BY sortorder ASC
189 0.0002 0.00022697448730469
SELECT * FROM product_image_select WHERE product_id = '1160'
190 0.0002 0.00019097328186035
SELECT * FROM productcustomimages WHERE product_id = '1160'
191 0.0009 0.00089001655578613
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1160' AND a.name = n.originalname
192 0.0004 0.00037002563476562
SELECT * FROM productoffers WHERE product_id = '1160' AND merchantid = 'A1X6FK5RDHNB96'
193 0.0004 0.00036716461181641
SELECT * FROM productoffers
                WHERE product_id = '1160' AND price > 0
                ORDER BY price ASC LIMIT 1
194 0.0004 0.00040602684020996
SELECT value FROM productattributes WHERE product_id = '1160' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
195 0.0004 0.00044012069702148
SELECT * FROM products WHERE id = '4905'
196 0.0002 0.00019979476928711
SELECT * FROM productimages WHERE product_id = '4905' ORDER BY sortorder ASC
197 0.0002 0.00018000602722168
SELECT * FROM product_image_select WHERE product_id = '4905'
198 0.0002 0.00017595291137695
SELECT * FROM productcustomimages WHERE product_id = '4905'
199 0.0002 0.0001828670501709
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4905' AND a.name = n.originalname
200 0.0003 0.00030088424682617
SELECT * FROM productoffers WHERE product_id = '4905' AND merchantid = 'A1X6FK5RDHNB96'
201 0.0004 0.00035905838012695
SELECT * FROM productoffers
                WHERE product_id = '4905' AND price > 0
                ORDER BY price ASC LIMIT 1
202 0.0003 0.00032877922058105
SELECT value FROM productattributes WHERE product_id = '4905' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
203 0.0004 0.0003969669342041
SELECT * FROM products WHERE id = '4909'
204 0.0016 0.0015799999237061
SELECT * FROM productimages WHERE product_id = '4909' ORDER BY sortorder ASC
205 0.0005 0.00054502487182617
SELECT * FROM product_image_select WHERE product_id = '4909'
206 0.0004 0.00035691261291504
SELECT * FROM productcustomimages WHERE product_id = '4909'
207 0.0009 0.00092911720275879
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4909' AND a.name = n.originalname
208 0.0003 0.00034689903259277
SELECT * FROM productoffers WHERE product_id = '4909' AND merchantid = 'A1X6FK5RDHNB96'
209 0.0004 0.00039982795715332
SELECT * FROM productoffers
                WHERE product_id = '4909' AND price > 0
                ORDER BY price ASC LIMIT 1
210 0.0004 0.00038313865661621
SELECT value FROM productattributes WHERE product_id = '4909' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
211 0.0005 0.00046014785766602
SELECT * FROM products WHERE id = '1201'
212 0.0002 0.00021791458129883
SELECT * FROM productimages WHERE product_id = '1201' ORDER BY sortorder ASC
213 0.0002 0.00020599365234375
SELECT * FROM product_image_select WHERE product_id = '1201'
214 0.0002 0.00021910667419434
SELECT * FROM productcustomimages WHERE product_id = '1201'
215 0.0008 0.00080108642578125
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1201' AND a.name = n.originalname
216 0.0004 0.00035810470581055
SELECT * FROM productoffers WHERE product_id = '1201' AND merchantid = 'A1X6FK5RDHNB96'
217 0.0004 0.0003969669342041
SELECT * FROM productoffers
                WHERE product_id = '1201' AND price > 0
                ORDER BY price ASC LIMIT 1
218 0.0004 0.00036811828613281
SELECT value FROM productattributes WHERE product_id = '1201' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
219 0.0004 0.00041604042053223
SELECT * FROM products WHERE id = '1145'
220 0.0002 0.00021910667419434
SELECT * FROM productimages WHERE product_id = '1145' ORDER BY sortorder ASC
221 0.0002 0.0001990795135498
SELECT * FROM product_image_select WHERE product_id = '1145'
222 0.0002 0.0001838207244873
SELECT * FROM productcustomimages WHERE product_id = '1145'
223 0.0007 0.00073003768920898
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1145' AND a.name = n.originalname
224 0.0003 0.0003199577331543
SELECT * FROM productoffers WHERE product_id = '1145' AND merchantid = 'A1X6FK5RDHNB96'
225 0.0004 0.00037908554077148
SELECT * FROM productoffers
                WHERE product_id = '1145' AND price > 0
                ORDER BY price ASC LIMIT 1
226 0.0004 0.00035691261291504
SELECT value FROM productattributes WHERE product_id = '1145' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
227 0.0004 0.00041604042053223
SELECT * FROM products WHERE id = '4910'
228 0.0002 0.0001978874206543
SELECT * FROM productimages WHERE product_id = '4910' ORDER BY sortorder ASC
229 0.0002 0.00017595291137695
SELECT * FROM product_image_select WHERE product_id = '4910'
230 0.0002 0.00019717216491699
SELECT * FROM productcustomimages WHERE product_id = '4910'
231 0.0002 0.00018191337585449
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4910' AND a.name = n.originalname
232 0.0003 0.00030708312988281
SELECT * FROM productoffers WHERE product_id = '4910' AND merchantid = 'A1X6FK5RDHNB96'
233 0.0004 0.00038409233093262
SELECT * FROM productoffers
                WHERE product_id = '4910' AND price > 0
                ORDER BY price ASC LIMIT 1
234 0.0002 0.00020408630371094
SELECT value FROM productattributes WHERE product_id = '4910' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
235 0.0004 0.00040411949157715
SELECT * FROM products WHERE id = '1152'
236 0.0004 0.00038695335388184
SELECT * FROM productimages WHERE product_id = '1152' ORDER BY sortorder ASC
237 0.0002 0.00018596649169922
SELECT * FROM product_image_select WHERE product_id = '1152'
238 0.0002 0.00018405914306641
SELECT * FROM productcustomimages WHERE product_id = '1152'
239 0.0007 0.0006558895111084
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1152' AND a.name = n.originalname
240 0.0003 0.00029921531677246
SELECT * FROM productoffers WHERE product_id = '1152' AND merchantid = 'A1X6FK5RDHNB96'
241 0.0003 0.00034999847412109
SELECT * FROM productoffers
                WHERE product_id = '1152' AND price > 0
                ORDER BY price ASC LIMIT 1
242 0.0004 0.00037384033203125
SELECT value FROM productattributes WHERE product_id = '1152' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
243 0.0004 0.00041794776916504
SELECT * FROM products WHERE id = '866'
244 0.0002 0.00024700164794922
SELECT * FROM productimages WHERE product_id = '866' ORDER BY sortorder ASC
245 0.0002 0.00020790100097656
SELECT * FROM product_image_select WHERE product_id = '866'
246 0.0002 0.00017690658569336
SELECT * FROM productcustomimages WHERE product_id = '866'
247 0.0002 0.00020408630371094
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '866' AND a.name = n.originalname
248 0.0003 0.00031304359436035
SELECT * FROM productoffers WHERE product_id = '866' AND merchantid = 'A1X6FK5RDHNB96'
249 0.0003 0.00033879280090332
SELECT * FROM productoffers
                WHERE product_id = '866' AND price > 0
                ORDER BY price ASC LIMIT 1
250 0.0003 0.0003349781036377
SELECT value FROM productattributes WHERE product_id = '866' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
251 0.0005 0.00047898292541504
SELECT * FROM products WHERE id = '1090'
252 0.0018 0.0018160343170166
SELECT * FROM productimages WHERE product_id = '1090' ORDER BY sortorder ASC
253 0.0004 0.00036787986755371
SELECT * FROM product_image_select WHERE product_id = '1090'
254 0.0005 0.00046396255493164
SELECT * FROM productcustomimages WHERE product_id = '1090'
255 0.0007 0.00067591667175293
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1090' AND a.name = n.originalname
256 0.0008 0.0007941722869873
SELECT * FROM productoffers WHERE product_id = '1090' AND merchantid = 'A1X6FK5RDHNB96'
257 0.0009 0.00090813636779785
SELECT * FROM productoffers
                WHERE product_id = '1090' AND price > 0
                ORDER BY price ASC LIMIT 1
258 0.0005 0.0005040168762207
SELECT * FROM productoffers
                WHERE product_id = 1090
                ORDER BY price ASC LIMIT 1
259 0.0003 0.00034093856811523
SELECT value FROM productattributes
                WHERE product_id = '1090'
                AND name = 'ListPriceAmount'
260 0.0004 0.00036096572875977
SELECT value FROM productattributes WHERE product_id = '1090' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
261 0.0014 0.0013530254364014
SELECT * FROM products WHERE id = '853'
262 0.0022 0.0022079944610596
SELECT * FROM productimages WHERE product_id = '853' ORDER BY sortorder ASC
263 0.0003 0.0003211498260498
SELECT * FROM product_image_select WHERE product_id = '853'
264 0.0003 0.0003349781036377
SELECT * FROM productcustomimages WHERE product_id = '853'
265 0.0008 0.00075197219848633
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '853' AND a.name = n.originalname
266 0.0004 0.00039291381835938
SELECT * FROM productoffers WHERE product_id = '853' AND merchantid = 'A1X6FK5RDHNB96'
267 0.0006 0.00057291984558105
SELECT * FROM productoffers
                WHERE product_id = '853' AND price > 0
                ORDER BY price ASC LIMIT 1
268 0.0003 0.00032806396484375
SELECT * FROM productoffers
                WHERE product_id = 853
                ORDER BY price ASC LIMIT 1
269 0.0012 0.0012190341949463
SELECT value FROM productattributes
                WHERE product_id = '853'
                AND name = 'ListPriceAmount'
270 0.0007 0.00070500373840332
SELECT value FROM productattributes WHERE product_id = '853' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
271 0.0023 0.0022969245910645
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2029' ORDER BY timestamp DESC
272 0.0005 0.00052309036254883
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1287' ORDER BY timestamp DESC
273 0.0003 0.00029683113098145
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1110' ORDER BY timestamp DESC
274 0.0003 0.00030112266540527
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4906' ORDER BY timestamp DESC
275 0.0003 0.00028300285339355
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1217' ORDER BY timestamp DESC
276 0.0003 0.00028586387634277
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '970' ORDER BY timestamp DESC
277 0.0003 0.00029182434082031
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4904' ORDER BY timestamp DESC
278 0.0003 0.00027894973754883
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '868' ORDER BY timestamp DESC
279 0.0003 0.00026607513427734
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1160' ORDER BY timestamp DESC
280 0.0003 0.00028085708618164
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4905' ORDER BY timestamp DESC
281 0.0003 0.00029397010803223
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4909' ORDER BY timestamp DESC
282 0.0004 0.00035691261291504
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1201' ORDER BY timestamp DESC
283 0.0003 0.00027298927307129
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1145' ORDER BY timestamp DESC
284 0.0004 0.00039196014404297
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4910' ORDER BY timestamp DESC
285 0.0003 0.00027203559875488
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1152' ORDER BY timestamp DESC
286 0.0008 0.00082302093505859
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '866' ORDER BY timestamp DESC
287 0.0003 0.00031399726867676
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1090' ORDER BY timestamp DESC
288 0.0004 0.00038290023803711
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '853' ORDER BY timestamp DESC
289 0.0004 0.00036191940307617
SELECT linktitle,pagename,ep.id,price,buylink,image FROM ebay_products ep, products_categories c
		WHERE ep.id = c.product_id
		AND c.category_id = 28
		AND c.prod_type = 'ebay'
		AND hide = 0
290 0.0002 0.00019192695617676
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
291 0.0003 0.00026702880859375
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
292 0.0002 0.00022101402282715
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
293 0.0002 0.00019097328186035
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
294 0.0003 0.00028800964355469
SELECT * FROM pages WHERE id = 38
295 0.0002 0.00023007392883301
SELECT DISTINCT p.id FROM products p, productoffers o
            WHERE p.id IN (SELECT product_id FROM productoffers WHERE 1 ) OR p.parent_id IN (SELECT product_id FROM productoffers WHERE 1 ) AND p.parent_id = 0 LIMIT 6
296 0.0006 0.00058579444885254
UPDATE template_options SET value = 'a:10:{s:14:\"populationtype\";s:9:\"automatic\";s:12:\"productcount\";s:1:\"6\";s:12:\"maxsalesrank\";s:0:\"\";s:8:\"minprice\";s:1:\"0\";s:8:\"maxprice\";s:1:\"0\";s:9:\"minimages\";s:0:\"\";s:10:\"updatetime\";s:1:\"0\";s:13:\"selectiontype\";s:6:\"random\";s:11:\"lastupdated\";i:1635201141;s:8:\"products\";a:6:{i:0;s:10:\"790|amazon\";i:1;s:10:\"788|amazon\";i:2;s:10:\"787|amazon\";i:3;s:11:\"1287|amazon\";i:4;s:10:\"780|amazon\";i:5;s:10:\"779|amazon\";}}' WHERE id = '160'
297 0.0004 0.00040197372436523
SELECT * FROM products WHERE id = 790
298 0.0005 0.00050210952758789
SELECT * FROM products WHERE id = 788
299 0.0005 0.00047087669372559
SELECT * FROM products WHERE id = 787
300 0.0004 0.0004429817199707
SELECT * FROM products WHERE id = 1287
301 0.0004 0.00042390823364258
SELECT * FROM products WHERE id = 780
302 0.0004 0.00042295455932617
SELECT * FROM products WHERE id = 779
303 0.0004 0.00042915344238281
SELECT * FROM products WHERE id = '790'
304 0.0007 0.00067806243896484
SELECT * FROM productimages WHERE product_id = '790' ORDER BY sortorder ASC
305 0.0002 0.00022196769714355
SELECT * FROM product_image_select WHERE product_id = '790'
306 0.0002 0.00016999244689941
SELECT * FROM productcustomimages WHERE product_id = '790'
307 0.0002 0.00024104118347168
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '790' AND a.name = n.originalname
308 0.0003 0.00028085708618164
SELECT * FROM productoffers WHERE product_id = '790' AND merchantid = 'A1X6FK5RDHNB96'
309 0.0002 0.00019407272338867
SELECT * FROM productoffers
                WHERE product_id = '790' AND price > 0
                ORDER BY price ASC LIMIT 1
310 0.0003 0.00034499168395996
SELECT value FROM productattributes WHERE product_id = '790' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
311 0.0003 0.00031900405883789
SELECT * FROM products WHERE id = '788'
312 0.0003 0.00026106834411621
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
313 0.0003 0.00025200843811035
SELECT * FROM product_image_select WHERE product_id = '788'
314 0.0002 0.00019598007202148
SELECT * FROM productcustomimages WHERE product_id = '788'
315 0.0002 0.00019311904907227
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
316 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
317 0.0002 0.00022292137145996
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
318 0.0002 0.00023102760314941
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
319 0.0003 0.00026893615722656
SELECT * FROM products WHERE id = '787'
320 0.0002 0.00022006034851074
SELECT * FROM productimages WHERE product_id = '787' ORDER BY sortorder ASC
321 0.0002 0.00022006034851074
SELECT * FROM product_image_select WHERE product_id = '787'
322 0.0002 0.0002140998840332
SELECT * FROM productcustomimages WHERE product_id = '787'
323 0.0002 0.00020980834960938
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '787' AND a.name = n.originalname
324 0.0002 0.00022196769714355
SELECT * FROM productoffers WHERE product_id = '787' AND merchantid = 'A1X6FK5RDHNB96'
325 0.0002 0.00019598007202148
SELECT * FROM productoffers
                WHERE product_id = '787' AND price > 0
                ORDER BY price ASC LIMIT 1
326 0.0002 0.00020289421081543
SELECT value FROM productattributes WHERE product_id = '787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
327 0.0003 0.00028610229492188
SELECT * FROM products WHERE id = '1287'
328 0.0004 0.00039196014404297
SELECT * FROM productimages WHERE product_id = '1287' ORDER BY sortorder ASC
329 0.0002 0.00016999244689941
SELECT * FROM product_image_select WHERE product_id = '1287'
330 0.0002 0.00021600723266602
SELECT * FROM productcustomimages WHERE product_id = '1287'
331 0.0003 0.00026106834411621
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1287' AND a.name = n.originalname
332 0.0002 0.00022697448730469
SELECT * FROM productoffers WHERE product_id = '1287' AND merchantid = 'A1X6FK5RDHNB96'
333 0.0002 0.0001978874206543
SELECT * FROM productoffers
                WHERE product_id = '1287' AND price > 0
                ORDER BY price ASC LIMIT 1
334 0.0003 0.0002598762512207
SELECT value FROM productattributes WHERE product_id = '1287' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
335 0.0003 0.00028800964355469
SELECT * FROM products WHERE id = '780'
336 0.0002 0.00020599365234375
SELECT * FROM productimages WHERE product_id = '780' ORDER BY sortorder ASC
337 0.0002 0.00017309188842773
SELECT * FROM product_image_select WHERE product_id = '780'
338 0.0002 0.00021505355834961
SELECT * FROM productcustomimages WHERE product_id = '780'
339 0.0003 0.0002741813659668
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '780' AND a.name = n.originalname
340 0.0002 0.0002288818359375
SELECT * FROM productoffers WHERE product_id = '780' AND merchantid = 'A1X6FK5RDHNB96'
341 0.0002 0.00019407272338867
SELECT * FROM productoffers
                WHERE product_id = '780' AND price > 0
                ORDER BY price ASC LIMIT 1
342 0.0002 0.00023484230041504
SELECT value FROM productattributes WHERE product_id = '780' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
343 0.0003 0.00027894973754883
SELECT * FROM products WHERE id = '779'
344 0.0002 0.00022196769714355
SELECT * FROM productimages WHERE product_id = '779' ORDER BY sortorder ASC
345 0.0002 0.00017809867858887
SELECT * FROM product_image_select WHERE product_id = '779'
346 0.0002 0.0001981258392334
SELECT * FROM productcustomimages WHERE product_id = '779'
347 0.0002 0.00019717216491699
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '779' AND a.name = n.originalname
348 0.0002 0.00020694732666016
SELECT * FROM productoffers WHERE product_id = '779' AND merchantid = 'A1X6FK5RDHNB96'
349 0.0002 0.00021004676818848
SELECT * FROM productoffers
                WHERE product_id = '779' AND price > 0
                ORDER BY price ASC LIMIT 1
350 0.0002 0.00020289421081543
SELECT value FROM productattributes WHERE product_id = '779' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
351 0.0003 0.00027298927307129
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
352 0.0005 0.00052714347839355
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
353 0.0008 0.00083398818969727
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
354 0.0005 0.00047612190246582
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
355 0.0005 0.00045585632324219
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
356 0.0005 0.00053119659423828
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'ICON_RSS_FEED'
357 0.0005 0.00051379203796387
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
358 0.0005 0.0004889965057373
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
359 0.0005 0.00046491622924805
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
360 0.0003 0.00027894973754883
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'