Matcha Premium 200 gr

Matcha Premium 200 gr
Matcha Premium 200 gr Matcha Premium 200 gr Matcha Premium 200 gr Matcha Premium 200 gr Matcha Premium 200 gr (cliquez sur les images pour élargir)
Le prix et la disponibilité du produit sont corrects en date du et sont sujets à changements. Toute informaiton relative au prix ou à la disponibilité affichés pour au moment de la commande sera d'application lors de l'achat de ce produit.
CERTAINS ÉLÉMENTS DE CONTENU QUI APPARAISSENT SUR CE SITE PROVIENNENT DE AMAZON SERVICES LLC. CE CONTENU EST FOURNI TEL QUEL ET EST SUJET À CHANGEMENTS OU RETRAIT À TOUT MOMENT.

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
0.81437397003174 256 0.1370 0


No Amazon API Requests Made.

Total time 0.81437397003174 seconds

Number Time From Start Name Description
1 0.62115097045898 Initialise Initialise FSB Function
2 0.62305998802185 App Controller Start Start of the App controller (called before the controller of every page)
3 0.62562990188599 Start of getCategoryListByGroup Function Before first category groups query
4 0.62610602378845 After initial query Before first category groups query
5 0.62610793113708 Get Category List for Group Before the call to getCategoryList function
6 0.62611198425293 Start of GetCategoryList function Start of the function
7 0.62611484527588 Before getting categories Query to get specific category list
8 0.62652802467346 After getting categories Query to get specific category list
9 0.62652993202209 Before getting category custom Before call to function getCategoryCustom
10 0.63031601905823 After getting category custom After call to function getCategoryCustom
11 0.63031888008118 Before getting category custom Before call to function getCategoryCustom
12 0.63326382637024 After getting category custom After call to function getCategoryCustom
13 0.63326692581177 Before getting category custom Before call to function getCategoryCustom
14 0.63600587844849 After getting category custom After call to function getCategoryCustom
15 0.63600897789001 Before getting category custom Before call to function getCategoryCustom
16 0.63887691497803 After getting category custom After call to function getCategoryCustom
17 0.63887882232666 Before getting category custom Before call to function getCategoryCustom
18 0.64404392242432 After getting category custom After call to function getCategoryCustom
19 0.64404702186584 Before getting category custom Before call to function getCategoryCustom
20 0.64706492424011 After getting category custom After call to function getCategoryCustom
21 0.64706802368164 End of GetCategoryList function End of the function
22 0.64707589149475 End of getCategoryListByGroup Function Before return()
23 0.65307188034058 App Controller End End of the App controller (called before the controller of every page)
24 0.65368700027466 Product Start Start of the product info controller
25 0.65728902816772 Cache file not found Starting get product details
26 0.68441486358643 Related products Start getting related products if enabled
27 0.68441700935364 Related Products Start Before the related products are found
28 0.68441796302795 Related Products Keywords Before the related product keywords are found
29 0.6844379901886 Create Keyword List Function Start of function
30 0.68450093269348 Create Keyword List Function After looping provided content - 9 keywords found
31 0.68495202064514 Create Keyword List Function After looping initial keyword list - 7 keywords remaining
32 0.68495798110962 Create Keyword List Function After reducing keyword list
33 0.68496990203857 Create Keyword List Function After selecting by scoring keywords
34 0.6849730014801 Create Keyword List Function After final loop of keywords
35 0.68497490882874 Related Products Keywords After the related product keywords are found
36 0.70825099945068 Related Products End After the related products are found
37 0.72487282752991 Product End End of the product info controller (Product Info)
38 0.72626996040344 App_after Controller Start Start of the App_after controller (called after the controller of every page)
39 0.72700881958008 Before Get Options Before the call to getOptions in the tpl class
40 0.76306700706482 After Get Options After the call to getOptions in the tpl class
41 0.76321387290955 App_after Controller End End of the App_after controller (called after the controller of every page)
42 0.76326084136963 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
43 0.78354001045227 Product Info: After Smarty Fetch After the product.tpl template is fetched
44 0.78354692459106 Product Info: Before Template Display Before the template is displayed
45 0.81434392929077 Product Info: After Template Display After the template is displayed
46 0.81435894966125 Finalizing debug Before the debug is output to the page.
47 0.81437182426453 End of App This is the end of the app logging, final timestamp


Query Debug - 256 Database Queries. Total time 0.1370 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0004 0.00044584274291992
SELECT parameter, value FROM parameters
2 0.0008 0.00082302093505859
SELECT * FROM `bad_bots`
3 0.0004 0.00040411949157715
SET time_zone = 'Europe/London'
4 0.0004 0.00040316581726074
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0019 0.0019350051879883
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"34.231.247.88\";}'
6 0.0012 0.0011880397796631
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1653304562'
7 0.0006 0.00061297416687012
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0004 0.0003669261932373
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0004 0.00037503242492676
SELECT id FROM pages WHERE pagename = 'matcha-premium-200-gr' LIMIT 1
10 0.0008 0.00080609321594238
SELECT id FROM products WHERE pagename = 'matcha-premium-200-gr' AND hidden = 0 LIMIT 1
11 0.0009 0.00086808204650879
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
12 0.0008 0.00077700614929199
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
13 0.0005 0.0005190372467041
SELECT * FROM pages WHERE pagename = 'matcha-premium-200-gr'
14 0.0005 0.00046420097351074
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0004 0.00038909912109375
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0003 0.00026106834411621
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
17 0.0003 0.00026202201843262
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
18 0.0003 0.00026607513427734
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0012 0.0011579990386963
SELECT id FROM categories WHERE parent_id = '26'
20 0.0005 0.00048184394836426
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 
21 0.0003 0.00034809112548828
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0 
22 0.0003 0.00029516220092773
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
23 0.0003 0.00029897689819336
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0003 0.0002748966217041
SELECT * FROM categorygroups WHERE id = '1'
25 0.0003 0.00026297569274902
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
26 0.0003 0.00029206275939941
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
27 0.0003 0.00032997131347656
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0003 0.00026583671569824
SELECT id FROM categories WHERE parent_id = '27'
29 0.0003 0.00025320053100586
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 
30 0.0003 0.00026917457580566
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 
31 0.0003 0.00033211708068848
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
32 0.0005 0.00046706199645996
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0004 0.00036501884460449
SELECT * FROM categorygroups WHERE id = '1'
34 0.0003 0.00029110908508301
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
35 0.0003 0.00026512145996094
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
36 0.0003 0.0002748966217041
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0003 0.00027203559875488
SELECT id FROM categories WHERE parent_id = '28'
38 0.0003 0.00027203559875488
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 
39 0.0003 0.00029087066650391
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 
40 0.0003 0.00026798248291016
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
41 0.0002 0.00024795532226562
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0005 0.00045895576477051
SELECT * FROM categorygroups WHERE id = '1'
43 0.0003 0.00030016899108887
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
44 0.0003 0.00027704238891602
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
45 0.0003 0.00026583671569824
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0003 0.00028109550476074
SELECT id FROM categories WHERE parent_id = '29'
47 0.0003 0.00029087066650391
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 
48 0.0003 0.0003058910369873
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 
49 0.0004 0.00040316581726074
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
50 0.0003 0.00033307075500488
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0003 0.00030303001403809
SELECT * FROM categorygroups WHERE id = '1'
52 0.0004 0.0004270076751709
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
53 0.0003 0.00032997131347656
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
54 0.0014 0.0014021396636963
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0012 0.0011970996856689
SELECT id FROM categories WHERE parent_id = '30'
56 0.0004 0.00040888786315918
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 
57 0.0004 0.00038790702819824
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 
58 0.0003 0.00028204917907715
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
59 0.0003 0.00029683113098145
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0003 0.00029397010803223
SELECT * FROM categorygroups WHERE id = '1'
61 0.0004 0.00036811828613281
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
62 0.0003 0.0002739429473877
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
63 0.0003 0.00025296211242676
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0003 0.00028896331787109
SELECT id FROM categories WHERE parent_id = '31'
65 0.0003 0.0002748966217041
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 
66 0.0003 0.00026202201843262
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 
67 0.0003 0.00025701522827148
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
68 0.0003 0.00025510787963867
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0007 0.00065708160400391
SELECT * FROM categorygroups WHERE id = '1'
70 0.0004 0.00039196014404297
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
71 0.0004 0.00037598609924316
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
72 0.0013 0.0013411045074463
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
73 0.0007 0.0006709098815918
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
74 0.0003 0.00032901763916016
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
75 0.0005 0.00047993659973145
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
76 0.0003 0.00033092498779297
SELECT * FROM ipgeocountries WHERE INET_ATON('34.231.247.88') >= INET_ATON(ip_start) AND INET_ATON('34.231.247.88') <= INET_ATON(ip_end)
77 0.0003 0.00029110908508301
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
78 0.0003 0.00034189224243164
SELECT * FROM countryredirects WHERE countrycode = 'US'
79 0.0009 0.00089287757873535
SELECT * FROM products WHERE pagename = 'matcha-premium-200-gr'
80 0.0016 0.0016300678253174
UPDATE products SET viewcount = viewcount + 1 WHERE id = 2029
81 0.0005 0.00048613548278809
SELECT * FROM manufacturers WHERE id = '185'
82 0.0010 0.0010209083557129
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '185'
83 0.0004 0.00035285949707031
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '185' LIMIT 1
84 0.0013 0.0013480186462402
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '185' ORDER BY RAND() LIMIT 1
85 0.0023 0.0022671222686768
SELECT * FROM productimages WHERE product_id = '3774' ORDER BY sortorder ASC
86 0.0003 0.00032496452331543
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '185'
87 0.0007 0.00065016746520996
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '185'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
88 0.0004 0.00036501884460449
SELECT * FROM manufacturerimages WHERE manufacturer_id = '185'
89 0.0004 0.00037288665771484
SELECT category_id FROM products_categories WHERE product_id = '2029'
90 0.0003 0.00032997131347656
SELECT * FROM categories WHERE id = '28'
91 0.0019 0.001863956451416
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
92 0.0004 0.00037598609924316
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
93 0.0006 0.00061893463134766
SELECT id FROM categories WHERE parent_id = '28'
94 0.0021 0.0020918846130371
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 
95 0.0005 0.00051283836364746
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 
96 0.0005 0.00049710273742676
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
97 0.0004 0.00039577484130859
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
98 0.0004 0.00043797492980957
SELECT * FROM productimages WHERE product_id = '2029' ORDER BY sortorder ASC
99 0.0011 0.0011141300201416
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
100 0.0003 0.00034809112548828
SELECT * FROM product_image_select WHERE product_id = '2029'
101 0.0003 0.00032901763916016
SELECT * FROM productcustomimages WHERE product_id = '2029'
102 0.0005 0.00045204162597656
SELECT * FROM productfeeds WHERE product_id = '2029' ORDER BY item_date DESC
103 0.0006 0.00055813789367676
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '2029' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
104 0.0003 0.00033307075500488
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '2029' AND t.hidden = 0 AND display_product = 1
105 0.0005 0.00045299530029297
SELECT * FROM productamazoncontent WHERE product_id = '2029'
106 0.0011 0.0010740756988525
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
107 0.0010 0.0010058879852295
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
108 0.0007 0.00072002410888672
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
109 0.0004 0.00044417381286621
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2029' AND a.name = n.originalname
110 0.0006 0.00055599212646484
SELECT * FROM productoffers WHERE product_id = '2029' AND merchantid = 'A1X6FK5RDHNB96'
111 0.0006 0.00060701370239258
SELECT * FROM productoffers
                WHERE product_id = '2029' AND price > 0
                ORDER BY price ASC LIMIT 1
112 0.0005 0.00053715705871582
SELECT * FROM productoffers
                WHERE product_id = 2029
                ORDER BY price ASC LIMIT 1
113 0.0004 0.0003960132598877
SELECT value FROM productattributes
                WHERE product_id = '2029'
                AND name = 'ListPriceAmount'
114 0.0003 0.0003211498260498
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
115 0.0005 0.00046992301940918
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
116 0.0004 0.0003960132598877
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
117 0.0004 0.00039386749267578
SELECT value FROM productattributes WHERE product_id = '2029' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
118 0.0008 0.00075602531433105
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
119 0.0005 0.00052189826965332
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
120 0.0088 0.0087909698486328
SELECT *, MATCH (description, title) AGAINST ('matcha premium 200' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('matcha premium 200' IN BOOLEAN MODE) AND 2029 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
121 0.0005 0.00052285194396973
SELECT *, MATCH (description, title) AGAINST ('matcha premium 200' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('matcha premium 200' IN BOOLEAN MODE) AND 2029 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
122 0.0004 0.00043106079101562
SELECT *, MATCH (description, title) AGAINST ('matcha premium 200' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('matcha premium 200' IN BOOLEAN MODE) AND 2029 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
123 0.0005 0.00045108795166016
SELECT * FROM productimages WHERE product_id = '1262' ORDER BY sortorder ASC
124 0.0005 0.00046992301940918
SELECT * FROM product_image_select WHERE product_id = '1262'
125 0.0004 0.00038790702819824
SELECT * FROM productcustomimages WHERE product_id = '1262'
126 0.0010 0.001032829284668
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1262' AND a.name = n.originalname
127 0.0012 0.0012190341949463
SELECT * FROM productoffers WHERE product_id = '1262' AND merchantid = 'A1X6FK5RDHNB96'
128 0.0006 0.00057196617126465
SELECT * FROM productoffers
                WHERE product_id = '1262' AND price > 0
                ORDER BY price ASC LIMIT 1
129 0.0006 0.00062894821166992
SELECT value FROM productattributes WHERE product_id = '1262' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
130 0.0003 0.00033688545227051
SELECT * FROM productimages WHERE product_id = '4904' ORDER BY sortorder ASC
131 0.0004 0.0003969669342041
SELECT * FROM product_image_select WHERE product_id = '4904'
132 0.0003 0.00029802322387695
SELECT * FROM productcustomimages WHERE product_id = '4904'
133 0.0004 0.00036787986755371
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4904' AND a.name = n.originalname
134 0.0005 0.00054287910461426
SELECT * FROM productoffers WHERE product_id = '4904' AND merchantid = 'A1X6FK5RDHNB96'
135 0.0007 0.00065207481384277
SELECT * FROM productoffers
                WHERE product_id = '4904' AND price > 0
                ORDER BY price ASC LIMIT 1
136 0.0003 0.0003349781036377
SELECT value FROM productattributes WHERE product_id = '4904' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
137 0.0004 0.00037288665771484
SELECT * FROM productimages WHERE product_id = '1727' ORDER BY sortorder ASC
138 0.0005 0.00046992301940918
SELECT * FROM product_image_select WHERE product_id = '1727'
139 0.0004 0.0003819465637207
SELECT * FROM productcustomimages WHERE product_id = '1727'
140 0.0020 0.0020480155944824
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1727' AND a.name = n.originalname
141 0.0006 0.00058889389038086
SELECT * FROM productoffers WHERE product_id = '1727' AND merchantid = 'A1X6FK5RDHNB96'
142 0.0006 0.00060796737670898
SELECT * FROM productoffers
                WHERE product_id = '1727' AND price > 0
                ORDER BY price ASC LIMIT 1
143 0.0005 0.00054097175598145
SELECT value FROM productattributes WHERE product_id = '1727' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
144 0.0005 0.00045108795166016
SELECT id,asin FROM products WHERE parent_id = 2029
145 0.0003 0.00028014183044434
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 1287
146 0.0005 0.00052785873413086
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 1287
147 0.0004 0.00038695335388184
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4020
148 0.0003 0.0002741813659668
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4020
149 0.0003 0.00029110908508301
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4066
150 0.0003 0.00026488304138184
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4066
151 0.0003 0.00027298927307129
SELECT category_id FROM products_categories WHERE product_id = '2029'
152 0.0004 0.0004119873046875
SELECT * FROM categories WHERE id = '28'
153 0.0004 0.00043916702270508
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
154 0.0003 0.0003209114074707
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
155 0.0003 0.00028204917907715
SELECT id FROM categories WHERE parent_id = '28'
156 0.0003 0.00025296211242676
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 
157 0.0003 0.00025391578674316
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 
158 0.0003 0.00028204917907715
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
159 0.0003 0.00026106834411621
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
160 0.0003 0.00028204917907715
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2029' AND a.name = n.originalname
161 0.0003 0.00031709671020508
SELECT * FROM productoffers WHERE product_id = '2029' AND merchantid = 'A1X6FK5RDHNB96'
162 0.0003 0.00028109550476074
SELECT * FROM productoffers
                WHERE product_id = '2029' AND price > 0
                ORDER BY price ASC LIMIT 1
163 0.0009 0.00091004371643066
SELECT * FROM productoffers
                WHERE product_id = 2029
                ORDER BY price ASC LIMIT 1
164 0.0002 0.00024890899658203
SELECT value FROM productattributes
                WHERE product_id = '2029'
                AND name = 'ListPriceAmount'
165 0.0005 0.00052714347839355
SELECT * FROM products WHERE id = '2029'
166 0.0003 0.00027203559875488
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
167 0.0003 0.00027084350585938
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
168 0.0003 0.00026297569274902
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
169 0.0003 0.00028014183044434
SELECT value FROM productattributes WHERE product_id = '2029' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
170 0.0003 0.0002739429473877
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2029' AND a.name = n.originalname
171 0.0003 0.00028705596923828
SELECT * FROM productoffers WHERE product_id = '2029' AND merchantid = 'A1X6FK5RDHNB96'
172 0.0003 0.00028419494628906
SELECT * FROM productoffers
                WHERE product_id = '2029' AND price > 0
                ORDER BY price ASC LIMIT 1
173 0.0003 0.00026798248291016
SELECT * FROM productoffers
                WHERE product_id = 2029
                ORDER BY price ASC LIMIT 1
174 0.0002 0.00024986267089844
SELECT value FROM productattributes
                WHERE product_id = '2029'
                AND name = 'ListPriceAmount'
175 0.0003 0.00025796890258789
SELECT DISTINCT (name) FROM productoptions
176 0.0008 0.00078701972961426
SELECT * FROM productoptions WHERE product_id IN (SELECT product_id FROM productoffers WHERE product_id IN (SELECT id from products WHERE parent_id = 2029))
177 0.0008 0.00077986717224121
SELECT	o.value, o.name
			FROM	products			p,
					productoptions		o
			WHERE	p.parent_id		= 2029
			  AND	p.id			= o.product_id 
			GROUP BY o.value ORDER BY o.value ASC
178 0.0003 0.00033187866210938
SELECT * FROM translationsfilter
179 0.0003 0.0002748966217041
SELECT category_id FROM products_categories WHERE product_id = '2029' AND prod_type = 'amz'
180 0.0003 0.00025415420532227
SELECT parent_id FROM categories WHERE id = '28'
181 0.0003 0.00031399726867676
SELECT * FROM categories WHERE id = '28'
182 0.0002 0.00024986267089844
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
183 0.0003 0.0002589225769043
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
184 0.0003 0.00028204917907715
SELECT id FROM categories WHERE parent_id = '28'
185 0.0003 0.00026297569274902
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 
186 0.0003 0.00025606155395508
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 
187 0.0010 0.00096487998962402
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
188 0.0003 0.00029397010803223
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
189 0.0004 0.00041890144348145
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
190 0.0004 0.00036191940307617
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
191 0.0003 0.00029397010803223
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
192 0.0006 0.00061297416687012
SELECT * FROM pages WHERE id = 38
193 0.0050 0.0049591064453125
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
194 0.0007 0.00067877769470215
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:1653304563;s:8:\"products\";a:6:{i:0;s:10:\"788|amazon\";i:1;s:10:\"787|amazon\";i:2;s:11:\"1287|amazon\";i:3;s:10:\"780|amazon\";i:4;s:10:\"777|amazon\";i:5;s:10:\"776|amazon\";}}' WHERE id = '160'
195 0.0005 0.00052809715270996
SELECT * FROM products WHERE id = 788
196 0.0006 0.00055599212646484
SELECT * FROM products WHERE id = 787
197 0.0007 0.00066900253295898
SELECT * FROM products WHERE id = 1287
198 0.0006 0.00055289268493652
SELECT * FROM products WHERE id = 780
199 0.0012 0.00124192237854
SELECT * FROM products WHERE id = 777
200 0.0006 0.00063586235046387
SELECT * FROM products WHERE id = 776
201 0.0007 0.00066304206848145
SELECT * FROM products WHERE id = '788'
202 0.0003 0.00033402442932129
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
203 0.0003 0.00025200843811035
SELECT * FROM product_image_select WHERE product_id = '788'
204 0.0003 0.00034379959106445
SELECT * FROM productcustomimages WHERE product_id = '788'
205 0.0003 0.00033402442932129
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
206 0.0004 0.0003819465637207
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
207 0.0004 0.00039482116699219
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
208 0.0003 0.00030994415283203
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
209 0.0005 0.00050997734069824
SELECT * FROM products WHERE id = '787'
210 0.0012 0.0012121200561523
SELECT * FROM productimages WHERE product_id = '787' ORDER BY sortorder ASC
211 0.0011 0.0010931491851807
SELECT * FROM product_image_select WHERE product_id = '787'
212 0.0003 0.00034499168395996
SELECT * FROM productcustomimages WHERE product_id = '787'
213 0.0004 0.0004119873046875
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '787' AND a.name = n.originalname
214 0.0003 0.00029492378234863
SELECT * FROM productoffers WHERE product_id = '787' AND merchantid = 'A1X6FK5RDHNB96'
215 0.0003 0.00031304359436035
SELECT * FROM productoffers
                WHERE product_id = '787' AND price > 0
                ORDER BY price ASC LIMIT 1
216 0.0003 0.00029897689819336
SELECT value FROM productattributes WHERE product_id = '787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
217 0.0006 0.00058794021606445
SELECT * FROM products WHERE id = '1287'
218 0.0004 0.00036215782165527
SELECT * FROM productimages WHERE product_id = '1287' ORDER BY sortorder ASC
219 0.0003 0.00028014183044434
SELECT * FROM product_image_select WHERE product_id = '1287'
220 0.0003 0.00027084350585938
SELECT * FROM productcustomimages WHERE product_id = '1287'
221 0.0003 0.00033998489379883
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1287' AND a.name = n.originalname
222 0.0003 0.00026512145996094
SELECT * FROM productoffers WHERE product_id = '1287' AND merchantid = 'A1X6FK5RDHNB96'
223 0.0004 0.00044894218444824
SELECT * FROM productoffers
                WHERE product_id = '1287' AND price > 0
                ORDER BY price ASC LIMIT 1
224 0.0003 0.00029897689819336
SELECT value FROM productattributes WHERE product_id = '1287' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
225 0.0005 0.00054407119750977
SELECT * FROM products WHERE id = '780'
226 0.0004 0.00038385391235352
SELECT * FROM productimages WHERE product_id = '780' ORDER BY sortorder ASC
227 0.0005 0.00045204162597656
SELECT * FROM product_image_select WHERE product_id = '780'
228 0.0004 0.00036001205444336
SELECT * FROM productcustomimages WHERE product_id = '780'
229 0.0003 0.00031208992004395
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '780' AND a.name = n.originalname
230 0.0003 0.00031685829162598
SELECT * FROM productoffers WHERE product_id = '780' AND merchantid = 'A1X6FK5RDHNB96'
231 0.0006 0.000579833984375
SELECT * FROM productoffers
                WHERE product_id = '780' AND price > 0
                ORDER BY price ASC LIMIT 1
232 0.0003 0.00027298927307129
SELECT value FROM productattributes WHERE product_id = '780' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
233 0.0005 0.00052404403686523
SELECT * FROM products WHERE id = '777'
234 0.0003 0.00033187866210938
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
235 0.0003 0.00028300285339355
SELECT * FROM product_image_select WHERE product_id = '777'
236 0.0004 0.00041007995605469
SELECT * FROM productcustomimages WHERE product_id = '777'
237 0.0003 0.00034809112548828
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
238 0.0003 0.00027990341186523
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
239 0.0003 0.00030183792114258
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
240 0.0003 0.00029301643371582
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
241 0.0005 0.00049090385437012
SELECT * FROM products WHERE id = '776'
242 0.0003 0.00031495094299316
SELECT * FROM productimages WHERE product_id = '776' ORDER BY sortorder ASC
243 0.0002 0.00023889541625977
SELECT * FROM product_image_select WHERE product_id = '776'
244 0.0003 0.00028300285339355
SELECT * FROM productcustomimages WHERE product_id = '776'
245 0.0003 0.0002899169921875
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '776' AND a.name = n.originalname
246 0.0003 0.00026798248291016
SELECT * FROM productoffers WHERE product_id = '776' AND merchantid = 'A1X6FK5RDHNB96'
247 0.0003 0.00030803680419922
SELECT * FROM productoffers
                WHERE product_id = '776' AND price > 0
                ORDER BY price ASC LIMIT 1
248 0.0003 0.00025296211242676
SELECT value FROM productattributes WHERE product_id = '776' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
249 0.0005 0.00046110153198242
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
250 0.0006 0.0006260871887207
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
251 0.0007 0.00068902969360352
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
252 0.0011 0.0010700225830078
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
253 0.0004 0.00043606758117676
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
254 0.0006 0.00056982040405273
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
255 0.0007 0.00067305564880371
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
256 0.0005 0.00052499771118164
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'