Caotina blanc, Poudre de Cacao avec du Chocolat Blanc Suisse, Chocolat Chaud, Lot de 2, 2 x 500g

Caotina blanc, Poudre de Cacao avec du Chocolat Blanc Suisse, Chocolat Chaud, Lot de 2, 2 x 500g
Caotina blanc, Poudre de Cacao avec du Chocolat Blanc Suisse, Chocolat Chaud, Lot de 2, 2 x 500g Caotina blanc, Poudre de Cacao avec du Chocolat Blanc Suisse, Chocolat Chaud, Lot de 2, 2 x 500g Caotina blanc, Poudre de Cacao avec du Chocolat Blanc Suisse, Chocolat Chaud, Lot de 2, 2 x 500g (cliquez sur les images pour élargir)
€32,72
Le prix et la disponibilité du produit sont corrects en date du 2021-07-21 06:55:05 UTC et sont sujets à changements. Toute informaiton relative au prix ou à la disponibilité affichés pour https://www.amazon.fr/ au moment de la commande sera d'application lors de l'achat de ce produit.

Caractéristiques du Produit

La marque Caotina est synonyme de noix de cacao suisse inégalée. Depuis 1963, il est produit en Suisse par Wander, à Neuenegg. La poudre de cacao de qualité supérieure avec du vrai chocolat suisse a un goût inégalé et corsé dans trois variétés différentes et une qualité unique. À la maison, les canettes Caotina de 200 g ou 500 g sont idéales. Pour le voyage ou pour la gastronomie, les paquets sont composés de bâtons pratiques contenant chacun 15 g de poudre de cacao.
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
1.2826418876648 240 0.0793 0


No Amazon API Requests Made.

Total time 1.2826418876648 seconds

Number Time From Start Name Description
1 0.22309994697571 Initialise Initialise FSB Function
2 0.22512984275818 App Controller Start Start of the App controller (called before the controller of every page)
3 0.2284197807312 Start of getCategoryListByGroup Function Before first category groups query
4 0.22869277000427 After initial query Before first category groups query
5 0.22869491577148 Get Category List for Group Before the call to getCategoryList function
6 0.22869777679443 Start of GetCategoryList function Start of the function
7 0.22870087623596 Before getting categories Query to get specific category list
8 0.22912383079529 After getting categories Query to get specific category list
9 0.2291259765625 Before getting category custom Before call to function getCategoryCustom
10 0.23124194145203 After getting category custom After call to function getCategoryCustom
11 0.23124480247498 Before getting category custom Before call to function getCategoryCustom
12 0.23329591751099 After getting category custom After call to function getCategoryCustom
13 0.23329877853394 Before getting category custom Before call to function getCategoryCustom
14 0.23528790473938 After getting category custom After call to function getCategoryCustom
15 0.23529100418091 Before getting category custom Before call to function getCategoryCustom
16 0.23743796348572 After getting category custom After call to function getCategoryCustom
17 0.23743987083435 Before getting category custom Before call to function getCategoryCustom
18 0.23941779136658 After getting category custom After call to function getCategoryCustom
19 0.23941993713379 Before getting category custom Before call to function getCategoryCustom
20 0.24111080169678 After getting category custom After call to function getCategoryCustom
21 0.24111294746399 End of GetCategoryList function End of the function
22 0.24111890792847 End of getCategoryListByGroup Function Before return()
23 0.25141000747681 App Controller End End of the App controller (called before the controller of every page)
24 0.25190186500549 Product Start Start of the product info controller
25 0.2724437713623 Cache file not found Starting get product details
26 0.28520798683167 Start Remote Request https://svcs.ebay.com/services/search/FindingServi...
27 0.91300892829895 End Remote Request https://svcs.ebay.com/services/search/FindingServi...
28 0.91532778739929 Related products Start getting related products if enabled
29 0.9153299331665 Related Products Start Before the related products are found
30 0.91533088684082 Related Products Keywords Before the related product keywords are found
31 0.91533589363098 Create Keyword List Function Start of function
32 0.91544079780579 Create Keyword List Function After looping provided content - 47 keywords found
33 0.91743493080139 Create Keyword List Function After looping initial keyword list - 38 keywords remaining
34 0.9174439907074 Create Keyword List Function After reducing keyword list
35 0.91769480705261 Create Keyword List Function After selecting by scoring keywords
36 0.91769981384277 Create Keyword List Function After final loop of keywords
37 0.91770195960999 Related Products Keywords After the related product keywords are found
38 0.93196487426758 Related Products End After the related products are found
39 0.9391508102417 Product End End of the product info controller (Product Info)
40 0.93972992897034 App_after Controller Start Start of the App_after controller (called after the controller of every page)
41 0.94017791748047 Before Get Options Before the call to getOptions in the tpl class
42 0.95967698097229 After Get Options After the call to getOptions in the tpl class
43 0.95981979370117 App_after Controller End End of the App_after controller (called after the controller of every page)
44 0.95984387397766 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
45 0.98035788536072 Product Info: After Smarty Fetch After the product.tpl template is fetched
46 0.98036193847656 Product Info: Before Template Display Before the template is displayed
47 1.2826218605042 Product Info: After Template Display After the template is displayed
48 1.2826278209686 Finalizing debug Before the debug is output to the page.
49 1.2826409339905 End of App This is the end of the app logging, final timestamp


Query Debug - 240 Database Queries. Total time 0.0793 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0006 0.00057792663574219
SELECT parameter, value FROM parameters
2 0.0009 0.00094103813171387
SELECT * FROM `bad_bots`
3 0.0004 0.00040984153747559
SET time_zone = 'Europe/London'
4 0.0005 0.00051689147949219
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0026 0.0025749206542969
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"18.207.238.146\";}'
6 0.0012 0.0012099742889404
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1627262197'
7 0.0008 0.000823974609375
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0003 0.00027608871459961
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0005 0.00054287910461426
SELECT id FROM pages WHERE pagename = 'caotina-blanc-poudre-de-cacao-avec-du-chocolat-blanc-suisse-chocolat' LIMIT 1
10 0.0006 0.0006248950958252
SELECT id FROM products WHERE pagename = 'caotina-blanc-poudre-de-cacao-avec-du-chocolat-blanc-suisse-chocolat' AND hidden = 0 LIMIT 1
11 0.0013 0.0013000965118408
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
12 0.0009 0.00092291831970215
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
13 0.0005 0.00049614906311035
SELECT * FROM pages WHERE pagename = 'caotina-blanc-poudre-de-cacao-avec-du-chocolat-blanc-suisse-chocolat'
14 0.0003 0.0002598762512207
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0004 0.00040316581726074
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0002 0.00023984909057617
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.0002 0.00023198127746582
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.0002 0.00021505355834961
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0002 0.0002288818359375
SELECT id FROM categories WHERE parent_id = '26'
20 0.0002 0.0002138614654541
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.00025701522827148
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.0002 0.00020909309387207
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.0002 0.0001981258392334
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0002 0.00020503997802734
SELECT * FROM categorygroups WHERE id = '1'
25 0.0002 0.00020503997802734
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.0002 0.00019502639770508
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.0002 0.00019097328186035
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0003 0.00029921531677246
SELECT id FROM categories WHERE parent_id = '27'
29 0.0002 0.00020289421081543
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.0002 0.00021696090698242
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.0002 0.0002129077911377
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.0002 0.00019502639770508
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0002 0.00023722648620605
SELECT * FROM categorygroups WHERE id = '1'
34 0.0002 0.00021886825561523
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.00026488304138184
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.0002 0.00020790100097656
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0002 0.00019693374633789
SELECT id FROM categories WHERE parent_id = '28'
38 0.0002 0.00021719932556152
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.0002 0.00020599365234375
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.0002 0.00019407272338867
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.00019001960754395
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0002 0.0001990795135498
SELECT * FROM categorygroups WHERE id = '1'
43 0.0002 0.0002138614654541
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.0002 0.00020098686218262
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.0002 0.00020408630371094
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0002 0.00023007392883301
SELECT id FROM categories WHERE parent_id = '29'
47 0.0002 0.00022315979003906
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.0002 0.00020813941955566
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.0002 0.00020909309387207
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.00025510787963867
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0003 0.00031590461730957
SELECT * FROM categorygroups WHERE id = '1'
52 0.0002 0.00021791458129883
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.0002 0.0002439022064209
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.0002 0.00020909309387207
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0002 0.00020408630371094
SELECT id FROM categories WHERE parent_id = '30'
56 0.0002 0.00023698806762695
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.0002 0.00021600723266602
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.0002 0.00019502639770508
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.0002 0.00017905235290527
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0002 0.00017786026000977
SELECT * FROM categorygroups WHERE id = '1'
61 0.0002 0.00016903877258301
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.0002 0.00018596649169922
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.0002 0.00017094612121582
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0002 0.00017786026000977
SELECT id FROM categories WHERE parent_id = '31'
65 0.0002 0.00020503997802734
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.0002 0.00017499923706055
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.0002 0.00017118453979492
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.0002 0.00016498565673828
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0002 0.0001828670501709
SELECT * FROM categorygroups WHERE id = '1'
70 0.0002 0.00020003318786621
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
71 0.0003 0.00027680397033691
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
72 0.0003 0.00026392936706543
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
73 0.0002 0.00020813941955566
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
74 0.0002 0.00023794174194336
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
75 0.0002 0.00018787384033203
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 
76 0.0002 0.00017905235290527
SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
77 0.0007 0.00066614151000977
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78 0.0003 0.0002589225769043
SELECT * FROM ipgeocountries WHERE INET_ATON('18.207.238.146') >= INET_ATON(ip_start) AND INET_ATON('18.207.238.146') <= INET_ATON(ip_end)
79 0.0003 0.00025200843811035
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80 0.0002 0.00022196769714355
SELECT * FROM countryredirects WHERE countrycode = 'US'
81 0.0007 0.00072813034057617
SELECT * FROM products WHERE pagename = 'caotina-blanc-poudre-de-cacao-avec-du-chocolat-blanc-suisse-chocolat'
82 0.0005 0.00054597854614258
SELECT * FROM manufacturers WHERE id = '673'
83 0.0008 0.00081610679626465
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '673'
84 0.0003 0.00034809112548828
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '673' LIMIT 1
85 0.0009 0.00091814994812012
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '673' ORDER BY RAND() LIMIT 1
86 0.0002 0.00024914741516113
SELECT * FROM productimages WHERE product_id = '4952' ORDER BY sortorder ASC
87 0.0003 0.00025010108947754
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '673'
88 0.0006 0.00061297416687012
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '673'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
89 0.0003 0.00033211708068848
SELECT * FROM manufacturerimages WHERE manufacturer_id = '673'
90 0.0004 0.00041294097900391
SELECT category_id FROM products_categories WHERE product_id = '4952'
91 0.0004 0.00037002563476562
SELECT * FROM categories WHERE id = '31'
92 0.0002 0.00020909309387207
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
93 0.0002 0.00020503997802734
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
94 0.0002 0.00022292137145996
SELECT id FROM categories WHERE parent_id = '31'
95 0.0002 0.00020098686218262
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 
96 0.0003 0.00025200843811035
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 
97 0.0002 0.00022292137145996
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
98 0.0002 0.0002138614654541
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
99 0.0002 0.00022101402282715
SELECT * FROM productimages WHERE product_id = '4952' ORDER BY sortorder ASC
100 0.0002 0.00020503997802734
SELECT * FROM product_image_select WHERE product_id = '4952'
101 0.0002 0.00020003318786621
SELECT * FROM productcustomimages WHERE product_id = '4952'
102 0.0003 0.00032711029052734
SELECT * FROM productfeeds WHERE product_id = '4952' ORDER BY item_date DESC
103 0.0005 0.00053787231445312
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '4952' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
104 0.0006 0.0005800724029541
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '4952' AND t.hidden = 0 AND display_product = 1
105 0.0009 0.00085806846618652
SELECT * FROM productamazoncontent WHERE product_id = '4952'
106 0.0003 0.00026798248291016
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4952' AND a.name = n.originalname
107 0.0004 0.00041007995605469
SELECT * FROM productoffers WHERE product_id = '4952' AND merchantid = 'A1X6FK5RDHNB96'
108 0.0004 0.00037312507629395
SELECT * FROM productoffers
                WHERE product_id = '4952' AND price > 0
                ORDER BY price ASC LIMIT 1
109 0.0004 0.00038409233093262
SELECT * FROM productoffers
                WHERE product_id = 4952
                ORDER BY price ASC LIMIT 1
110 0.0002 0.00020384788513184
SELECT value FROM productattributes
                WHERE product_id = '4952'
                AND name = 'ListPriceAmount'
111 0.0002 0.00020194053649902
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
112 0.0002 0.00019097328186035
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
113 0.0002 0.00023913383483887
SELECT * FROM ebay_locale_details WHERE cur_code = 'USD' 
114 0.0002 0.00020289421081543
SELECT * FROM ebay_products_cache WHERE cachekey = '4ee8d429538b2b5d4286b7d39916c82c' 
115 0.0002 0.00022411346435547
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
116 0.0003 0.00028085708618164
SELECT * FROM ebay_products_cache WHERE cachekey = '4ee8d429538b2b5d4286b7d39916c82c' 
117 0.0018 0.0018069744110107
INSERT INTO externalrequestlog (`type`, `wherefrom`, `url`, `parameters`, `successful`, `timetaken`, `appinstance`, `apprequesturi`, `created`) SELECT 'ebay', 'function searchProducts()', 'https://svcs.ebay.com/services/search/FindingService/v1?OPERATION-NAME=findItemsByKeywords&SERVICE-VERSION=1.0.0&GLOBAL-ID=EBAY-US&SECURITY-APPNAME=&RESPONSE-DATA-FORMAT=XML&REST-PAYLOAD&keywords=s&paginationInput.pageNumber=1&paginationInput.entriesPerPage=1&itemFilter(0).name=HideDuplicateItems&itemFilter(0).value=true&affiliate.trackingId=&affiliate.networkId=9', 'a:10:{s:9:\"ebayappid\";s:0:\"\";s:9:\"authtoken\";s:0:\"\";s:13:\"ebaynetworkid\";s:1:\"9\";s:14:\"ebaytrackingid\";s:0:\"\";s:19:\"googlerecaptchatype\";s:1:\"0\";s:15:\"googlesecretkey\";s:0:\"\";s:13:\"googlesitekey\";s:0:\"\";s:12:\"ebayglobalid\";s:7:\"EBAY-US\";s:10:\"ebaysiteid\";s:1:\"0\";s:8:\"currency\";s:3:\"USD\";}', '0', '0.62780809402466', '9264158aeea655c7d2eaa978b483a674', 'http://www.boite-a-the.fr/caotina-blanc-poudre-de-cacao-avec-du-chocolat-blanc-suisse-chocolat/', '2021-07-26 01:16:38'
118 0.0077 0.0077440738677979
SELECT *, MATCH (description, title) AGAINST ('suisse chocolat chaud' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('suisse chocolat chaud' IN BOOLEAN MODE) AND 4952 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
119 0.0005 0.00045108795166016
SELECT *, MATCH (description, title) AGAINST ('suisse chocolat chaud' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('suisse chocolat chaud' IN BOOLEAN MODE) AND 4952 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
120 0.0006 0.00056910514831543
SELECT *, MATCH (description, title) AGAINST ('suisse chocolat chaud' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('suisse chocolat chaud' IN BOOLEAN MODE) AND 4952 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
121 0.0002 0.0001990795135498
SELECT * FROM productimages WHERE product_id = '4942' ORDER BY sortorder ASC
122 0.0002 0.00020503997802734
SELECT * FROM product_image_select WHERE product_id = '4942'
123 0.0002 0.00022006034851074
SELECT * FROM productcustomimages WHERE product_id = '4942'
124 0.0003 0.00026297569274902
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4942' AND a.name = n.originalname
125 0.0002 0.00022006034851074
SELECT * FROM productoffers WHERE product_id = '4942' AND merchantid = 'A1X6FK5RDHNB96'
126 0.0002 0.00019598007202148
SELECT * FROM productoffers
                WHERE product_id = '4942' AND price > 0
                ORDER BY price ASC LIMIT 1
127 0.0002 0.00020503997802734
SELECT value FROM productattributes WHERE product_id = '4942' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
128 0.0002 0.00020813941955566
SELECT * FROM productimages WHERE product_id = '4939' ORDER BY sortorder ASC
129 0.0002 0.00023102760314941
SELECT * FROM product_image_select WHERE product_id = '4939'
130 0.0002 0.00021505355834961
SELECT * FROM productcustomimages WHERE product_id = '4939'
131 0.0002 0.00022792816162109
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4939' AND a.name = n.originalname
132 0.0002 0.00022506713867188
SELECT * FROM productoffers WHERE product_id = '4939' AND merchantid = 'A1X6FK5RDHNB96'
133 0.0002 0.0001990795135498
SELECT * FROM productoffers
                WHERE product_id = '4939' AND price > 0
                ORDER BY price ASC LIMIT 1
134 0.0003 0.00033211708068848
SELECT value FROM productattributes WHERE product_id = '4939' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
135 0.0002 0.00020909309387207
SELECT * FROM productimages WHERE product_id = '3663' ORDER BY sortorder ASC
136 0.0002 0.00024294853210449
SELECT * FROM product_image_select WHERE product_id = '3663'
137 0.0002 0.0001981258392334
SELECT * FROM productcustomimages WHERE product_id = '3663'
138 0.0003 0.00025415420532227
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3663' AND a.name = n.originalname
139 0.0002 0.0002281665802002
SELECT * FROM productoffers WHERE product_id = '3663' AND merchantid = 'A1X6FK5RDHNB96'
140 0.0002 0.00020408630371094
SELECT * FROM productoffers
                WHERE product_id = '3663' AND price > 0
                ORDER BY price ASC LIMIT 1
141 0.0003 0.00031685829162598
SELECT value FROM productattributes WHERE product_id = '3663' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
142 0.0003 0.00029301643371582
SELECT id,asin FROM products WHERE parent_id = 4952
143 0.0002 0.00018191337585449
SELECT category_id FROM products_categories WHERE product_id = '4952'
144 0.0002 0.00024294853210449
SELECT * FROM categories WHERE id = '31'
145 0.0002 0.00017499923706055
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
146 0.0002 0.00018405914306641
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
147 0.0002 0.00020599365234375
SELECT id FROM categories WHERE parent_id = '31'
148 0.0002 0.00023102760314941
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 
149 0.0002 0.00018000602722168
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 
150 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 (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
151 0.0002 0.00018215179443359
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
152 0.0003 0.00026202201843262
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4952' AND a.name = n.originalname
153 0.0002 0.00022387504577637
SELECT * FROM productoffers WHERE product_id = '4952' AND merchantid = 'A1X6FK5RDHNB96'
154 0.0002 0.00020003318786621
SELECT * FROM productoffers
                WHERE product_id = '4952' AND price > 0
                ORDER BY price ASC LIMIT 1
155 0.0002 0.00018906593322754
SELECT * FROM productoffers
                WHERE product_id = 4952
                ORDER BY price ASC LIMIT 1
156 0.0002 0.00021600723266602
SELECT value FROM productattributes
                WHERE product_id = '4952'
                AND name = 'ListPriceAmount'
157 0.0005 0.0005040168762207
SELECT * FROM products WHERE id = '4952'
158 0.0002 0.00019001960754395
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4952' AND a.name = n.originalname
159 0.0002 0.0001988410949707
SELECT * FROM productoffers WHERE product_id = '4952' AND merchantid = 'A1X6FK5RDHNB96'
160 0.0002 0.0002138614654541
SELECT * FROM productoffers
                WHERE product_id = '4952' AND price > 0
                ORDER BY price ASC LIMIT 1
161 0.0002 0.0002138614654541
SELECT * FROM productoffers
                WHERE product_id = 4952
                ORDER BY price ASC LIMIT 1
162 0.0002 0.00019693374633789
SELECT value FROM productattributes
                WHERE product_id = '4952'
                AND name = 'ListPriceAmount'
163 0.0003 0.00032997131347656
SELECT category_id FROM products_categories WHERE product_id = '4952' AND prod_type = 'amz'
164 0.0002 0.0002129077911377
SELECT parent_id FROM categories WHERE id = '31'
165 0.0002 0.00022292137145996
SELECT * FROM categories WHERE id = '31'
166 0.0002 0.00018095970153809
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
167 0.0002 0.00017285346984863
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
168 0.0002 0.00016999244689941
SELECT id FROM categories WHERE parent_id = '31'
169 0.0002 0.00018310546875
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 
170 0.0002 0.00023698806762695
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 
171 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 (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
172 0.0002 0.00015902519226074
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
173 0.0002 0.00023388862609863
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
174 0.0002 0.00017189979553223
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
175 0.0002 0.00018095970153809
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
176 0.0002 0.00024008750915527
SELECT * FROM pages WHERE id = 38
177 0.0004 0.00040698051452637
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
178 0.0004 0.00037384033203125
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:1627262198;s:8:\"products\";a:6:{i:0;s:10:\"808|amazon\";i:1;s:11:\"4939|amazon\";i:2;s:11:\"1727|amazon\";i:3;s:10:\"873|amazon\";i:4;s:10:\"894|amazon\";i:5;s:10:\"881|amazon\";}}' WHERE id = '160'
179 0.0003 0.00033211708068848
SELECT * FROM products WHERE id = 808
180 0.0004 0.00039196014404297
SELECT * FROM products WHERE id = 4939
181 0.0004 0.00042605400085449
SELECT * FROM products WHERE id = 1727
182 0.0004 0.00039005279541016
SELECT * FROM products WHERE id = 873
183 0.0004 0.00039911270141602
SELECT * FROM products WHERE id = 894
184 0.0004 0.00040102005004883
SELECT * FROM products WHERE id = 881
185 0.0004 0.00039100646972656
SELECT * FROM products WHERE id = '808'
186 0.0002 0.00018191337585449
SELECT * FROM productimages WHERE product_id = '808' ORDER BY sortorder ASC
187 0.0002 0.00018095970153809
SELECT * FROM product_image_select WHERE product_id = '808'
188 0.0002 0.00019311904907227
SELECT * FROM productcustomimages WHERE product_id = '808'
189 0.0002 0.00019407272338867
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '808' AND a.name = n.originalname
190 0.0003 0.00025391578674316
SELECT * FROM productoffers WHERE product_id = '808' AND merchantid = 'A1X6FK5RDHNB96'
191 0.0002 0.0001981258392334
SELECT * FROM productoffers
                WHERE product_id = '808' AND price > 0
                ORDER BY price ASC LIMIT 1
192 0.0003 0.00030279159545898
SELECT value FROM productattributes WHERE product_id = '808' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
193 0.0003 0.00030899047851562
SELECT * FROM products WHERE id = '4939'
194 0.0002 0.00019001960754395
SELECT * FROM productimages WHERE product_id = '4939' ORDER BY sortorder ASC
195 0.0002 0.00018000602722168
SELECT * FROM product_image_select WHERE product_id = '4939'
196 0.0002 0.00020503997802734
SELECT * FROM productcustomimages WHERE product_id = '4939'
197 0.0003 0.00025606155395508
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4939' AND a.name = n.originalname
198 0.0002 0.00019598007202148
SELECT * FROM productoffers WHERE product_id = '4939' AND merchantid = 'A1X6FK5RDHNB96'
199 0.0002 0.00019598007202148
SELECT * FROM productoffers
                WHERE product_id = '4939' AND price > 0
                ORDER BY price ASC LIMIT 1
200 0.0003 0.00033020973205566
SELECT value FROM productattributes WHERE product_id = '4939' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
201 0.0003 0.00028085708618164
SELECT * FROM products WHERE id = '1727'
202 0.0002 0.00019097328186035
SELECT * FROM productimages WHERE product_id = '1727' ORDER BY sortorder ASC
203 0.0003 0.00028491020202637
SELECT * FROM product_image_select WHERE product_id = '1727'
204 0.0002 0.00018692016601562
SELECT * FROM productcustomimages WHERE product_id = '1727'
205 0.0002 0.00021100044250488
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1727' AND a.name = n.originalname
206 0.0002 0.00020718574523926
SELECT * FROM productoffers WHERE product_id = '1727' AND merchantid = 'A1X6FK5RDHNB96'
207 0.0002 0.00019288063049316
SELECT * FROM productoffers
                WHERE product_id = '1727' AND price > 0
                ORDER BY price ASC LIMIT 1
208 0.0002 0.00020408630371094
SELECT value FROM productattributes WHERE product_id = '1727' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
209 0.0003 0.00028896331787109
SELECT * FROM products WHERE id = '873'
210 0.0002 0.00020003318786621
SELECT * FROM productimages WHERE product_id = '873' ORDER BY sortorder ASC
211 0.0002 0.00017905235290527
SELECT * FROM product_image_select WHERE product_id = '873'
212 0.0002 0.00017690658569336
SELECT * FROM productcustomimages WHERE product_id = '873'
213 0.0002 0.00021815299987793
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '873' AND a.name = n.originalname
214 0.0002 0.00019311904907227
SELECT * FROM productoffers WHERE product_id = '873' AND merchantid = 'A1X6FK5RDHNB96'
215 0.0002 0.0002131462097168
SELECT * FROM productoffers
                WHERE product_id = '873' AND price > 0
                ORDER BY price ASC LIMIT 1
216 0.0003 0.00029993057250977
SELECT value FROM productattributes WHERE product_id = '873' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
217 0.0003 0.00026798248291016
SELECT * FROM products WHERE id = '894'
218 0.0002 0.00017595291137695
SELECT * FROM productimages WHERE product_id = '894' ORDER BY sortorder ASC
219 0.0002 0.0001828670501709
SELECT * FROM product_image_select WHERE product_id = '894'
220 0.0002 0.0001680850982666
SELECT * FROM productcustomimages WHERE product_id = '894'
221 0.0002 0.00019502639770508
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '894' AND a.name = n.originalname
222 0.0002 0.00018692016601562
SELECT * FROM productoffers WHERE product_id = '894' AND merchantid = 'A1X6FK5RDHNB96'
223 0.0004 0.00037693977355957
SELECT * FROM productoffers
                WHERE product_id = '894' AND price > 0
                ORDER BY price ASC LIMIT 1
224 0.0002 0.00015902519226074
SELECT value FROM productattributes WHERE product_id = '894' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
225 0.0003 0.00025200843811035
SELECT * FROM products WHERE id = '881'
226 0.0002 0.00017094612121582
SELECT * FROM productimages WHERE product_id = '881' ORDER BY sortorder ASC
227 0.0002 0.00018191337585449
SELECT * FROM product_image_select WHERE product_id = '881'
228 0.0002 0.0001678466796875
SELECT * FROM productcustomimages WHERE product_id = '881'
229 0.0002 0.00021100044250488
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '881' AND a.name = n.originalname
230 0.0002 0.00018715858459473
SELECT * FROM productoffers WHERE product_id = '881' AND merchantid = 'A1X6FK5RDHNB96'
231 0.0004 0.00037813186645508
SELECT * FROM productoffers
                WHERE product_id = '881' AND price > 0
                ORDER BY price ASC LIMIT 1
232 0.0002 0.00020408630371094
SELECT value FROM productattributes WHERE product_id = '881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
233 0.0003 0.00025200843811035
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
234 0.0004 0.00043082237243652
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
235 0.0008 0.00077295303344727
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
236 0.0005 0.00050020217895508
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
237 0.0004 0.00041007995605469
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
238 0.0003 0.00034618377685547
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
239 0.0003 0.00030803680419922
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
240 0.0002 0.00022602081298828
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'