Ethiquable Café Grains Honduras Équitable & Bio 1 kg Paysans Producteurs

Ethiquable Café Grains Honduras Équitable & Bio 1 kg Paysans Producteurs
Ethiquable Café Grains Honduras Équitable & Bio 1 kg Paysans Producteurs (cliquez sur les images pour élargir)
€16,80
Le prix et la disponibilité du produit sont corrects en date du 2021-07-19 21:51:15 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

Café Honduras équitable & bio Arabica moulu d'altitude, intense et parfumé Doux/Corsé : la force du cru Corps : l’épaisseur en bouche Arôme : la richesse de saveurs Fruité : la vivacité du café Une solution à l accès inégal à la terre. La Thaïlande est résolument orientée sur une production intensive du riz, au prix d’une forte dégradation des écosystèmes et des traditions paysannes. Abandonner une parcelle après quelques années d'exploitation et en conquérir une nouvelle sur la forêt amazonienne n'est plus une nécessité pour les producteurs de la coopérative ORO VERDE. I
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.2778930664062 250 0.0879 0


No Amazon API Requests Made.

Total time 1.2778930664062 seconds

Number Time From Start Name Description
1 0.36749601364136 Initialise Initialise FSB Function
2 0.36998605728149 App Controller Start Start of the App controller (called before the controller of every page)
3 0.37255096435547 Start of getCategoryListByGroup Function Before first category groups query
4 0.3729510307312 After initial query Before first category groups query
5 0.37295293807983 Get Category List for Group Before the call to getCategoryList function
6 0.37295603752136 Start of GetCategoryList function Start of the function
7 0.37295794487 Before getting categories Query to get specific category list
8 0.37337398529053 After getting categories Query to get specific category list
9 0.37337613105774 Before getting category custom Before call to function getCategoryCustom
10 0.37566113471985 After getting category custom After call to function getCategoryCustom
11 0.3756639957428 Before getting category custom Before call to function getCategoryCustom
12 0.37794995307922 After getting category custom After call to function getCategoryCustom
13 0.37795209884644 Before getting category custom Before call to function getCategoryCustom
14 0.37989592552185 After getting category custom After call to function getCategoryCustom
15 0.37989807128906 Before getting category custom Before call to function getCategoryCustom
16 0.38290691375732 After getting category custom After call to function getCategoryCustom
17 0.38291001319885 Before getting category custom Before call to function getCategoryCustom
18 0.38496208190918 After getting category custom After call to function getCategoryCustom
19 0.38496589660645 Before getting category custom Before call to function getCategoryCustom
20 0.38764190673828 After getting category custom After call to function getCategoryCustom
21 0.38764500617981 End of GetCategoryList function End of the function
22 0.38765406608582 End of getCategoryListByGroup Function Before return()
23 0.39318990707397 App Controller End End of the App controller (called before the controller of every page)
24 0.39415097236633 Product Start Start of the product info controller
25 0.39621305465698 Cache file not found Starting get product details
26 0.40929698944092 Start Remote Request https://svcs.ebay.com/services/search/FindingServi...
27 1.0956220626831 End Remote Request https://svcs.ebay.com/services/search/FindingServi...
28 1.0972599983215 Related products Start getting related products if enabled
29 1.0972619056702 Related Products Start Before the related products are found
30 1.0972640514374 Related Products Keywords Before the related product keywords are found
31 1.0972700119019 Create Keyword List Function Start of function
32 1.0973119735718 Create Keyword List Function After looping provided content - 30 keywords found
33 1.0987660884857 Create Keyword List Function After looping initial keyword list - 26 keywords remaining
34 1.0987780094147 Create Keyword List Function After reducing keyword list
35 1.0989151000977 Create Keyword List Function After selecting by scoring keywords
36 1.0989210605621 Create Keyword List Function After final loop of keywords
37 1.0989239215851 Related Products Keywords After the related product keywords are found
38 1.1198310852051 Related Products End After the related products are found
39 1.128005027771 Product End End of the product info controller (Product Info)
40 1.1289629936218 App_after Controller Start Start of the App_after controller (called after the controller of every page)
41 1.129576921463 Before Get Options Before the call to getOptions in the tpl class
42 1.1521399021149 After Get Options After the call to getOptions in the tpl class
43 1.1522579193115 App_after Controller End End of the App_after controller (called after the controller of every page)
44 1.152291059494 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
45 1.2382299900055 Product Info: After Smarty Fetch After the product.tpl template is fetched
46 1.23823595047 Product Info: Before Template Display Before the template is displayed
47 1.277862071991 Product Info: After Template Display After the template is displayed
48 1.2778780460358 Finalizing debug Before the debug is output to the page.
49 1.2778921127319 End of App This is the end of the app logging, final timestamp


Query Debug - 250 Database Queries. Total time 0.0879 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0004 0.00040602684020996
SELECT parameter, value FROM parameters
2 0.0009 0.00087690353393555
SELECT * FROM `bad_bots`
3 0.0002 0.00023984909057617
SET time_zone = 'Europe/London'
4 0.0003 0.00025200843811035
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0018 0.0018289089202881
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"18.207.238.146\";}'
6 0.0008 0.00078082084655762
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1627258612'
7 0.0003 0.00034499168395996
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0002 0.00020790100097656
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0006 0.00062179565429688
SELECT id FROM pages WHERE pagename = 'ethiquable-cafe-grains-honduras-Equitable-bio-1-kg-paysans-producteurs' LIMIT 1
10 0.0009 0.00088405609130859
SELECT id FROM products WHERE pagename = 'ethiquable-cafe-grains-honduras-Equitable-bio-1-kg-paysans-producteurs' AND hidden = 0 LIMIT 1
11 0.0009 0.00085711479187012
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
12 0.0008 0.00082516670227051
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
13 0.0004 0.00041413307189941
SELECT * FROM pages WHERE pagename = 'ethiquable-cafe-grains-honduras-Equitable-bio-1-kg-paysans-producteurs'
14 0.0004 0.00038695335388184
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0004 0.0003969669342041
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0003 0.00029206275939941
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.00020813941955566
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.00024914741516113
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0002 0.00023412704467773
SELECT id FROM categories WHERE parent_id = '26'
20 0.0002 0.00024199485778809
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.0002 0.00021100044250488
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.0002140998840332
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.00022602081298828
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0003 0.00028586387634277
SELECT * FROM categorygroups WHERE id = '1'
25 0.0002 0.00020694732666016
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.00025105476379395
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.00031089782714844
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0002 0.00018882751464844
SELECT id FROM categories WHERE parent_id = '27'
29 0.0003 0.00028681755065918
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.00027680397033691
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.00022292137145996
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.00020289421081543
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0002 0.00022101402282715
SELECT * FROM categorygroups WHERE id = '1'
34 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 = 28
35 0.0002 0.00023889541625977
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.00019097328186035
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0002 0.00017499923706055
SELECT id FROM categories WHERE parent_id = '28'
38 0.0002 0.00019192695617676
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.00019311904907227
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.00019693374633789
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.00020098686218262
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0002 0.00023508071899414
SELECT * FROM categorygroups WHERE id = '1'
43 0.0012 0.0011570453643799
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.00029897689819336
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.00020909309387207
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0002 0.00019288063049316
SELECT id FROM categories WHERE parent_id = '29'
47 0.0002 0.0001981258392334
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.00017690658569336
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.00022315979003906
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.0002 0.00017786026000977
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0003 0.0002601146697998
SELECT * FROM categorygroups WHERE id = '1'
52 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 = 30
53 0.0002 0.0002291202545166
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.00020503997802734
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0002 0.00024914741516113
SELECT id FROM categories WHERE parent_id = '30'
56 0.0002 0.00020408630371094
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.0001978874206543
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.00019192695617676
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.00028395652770996
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0002 0.00019407272338867
SELECT * FROM categorygroups WHERE id = '1'
61 0.0002 0.00018501281738281
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.00029993057250977
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.00020003318786621
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0002 0.00020003318786621
SELECT id FROM categories WHERE parent_id = '31'
65 0.0002 0.00020885467529297
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.0008 0.00075602531433105
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.0002899169921875
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.00021100044250488
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0002 0.00019717216491699
SELECT * FROM categorygroups WHERE id = '1'
70 0.0002 0.00022697448730469
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
71 0.0002 0.00024700164794922
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
72 0.0003 0.00027298927307129
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
73 0.0003 0.00026893615722656
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
74 0.0002 0.00018596649169922
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
75 0.0002 0.00019407272338867
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 
76 0.0003 0.00029420852661133
SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
77 0.0008 0.00077509880065918
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78 0.0002 0.00023698806762695
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.0002 0.00022792816162109
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80 0.0002 0.00021696090698242
SELECT * FROM countryredirects WHERE countrycode = 'US'
81 0.0006 0.00058412551879883
SELECT * FROM products WHERE pagename = 'ethiquable-cafe-grains-honduras-Equitable-bio-1-kg-paysans-producteurs'
82 0.0007 0.00067496299743652
SELECT * FROM manufacturers WHERE id = '262'
83 0.0007 0.00074505805969238
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '262'
84 0.0005 0.00048589706420898
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '262' LIMIT 1
85 0.0009 0.00093412399291992
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '262' ORDER BY RAND() LIMIT 1
86 0.0003 0.00028109550476074
SELECT * FROM productimages WHERE product_id = '1219' ORDER BY sortorder ASC
87 0.0003 0.00029206275939941
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '262'
88 0.0005 0.00052595138549805
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '262'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
89 0.0003 0.00029706954956055
SELECT * FROM manufacturerimages WHERE manufacturer_id = '262'
90 0.0004 0.00043892860412598
SELECT category_id FROM products_categories WHERE product_id = '4929'
91 0.0002 0.00022506713867188
SELECT * FROM categories WHERE id = '30'
92 0.0002 0.00020289421081543
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
93 0.0002 0.00018596649169922
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
94 0.0002 0.00018095970153809
SELECT id FROM categories WHERE parent_id = '30'
95 0.0002 0.00019288063049316
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 
96 0.0003 0.00025296211242676
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 
97 0.0003 0.00027704238891602
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
98 0.0003 0.00026297569274902
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
99 0.0002 0.00020790100097656
SELECT * FROM productimages WHERE product_id = '4929' ORDER BY sortorder ASC
100 0.0002 0.00024199485778809
SELECT * FROM product_image_select WHERE product_id = '4929'
101 0.0002 0.00020980834960938
SELECT * FROM productcustomimages WHERE product_id = '4929'
102 0.0004 0.00039505958557129
SELECT * FROM productfeeds WHERE product_id = '4929' ORDER BY item_date DESC
103 0.0006 0.0005650520324707
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '4929' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
104 0.0007 0.00067901611328125
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '4929' AND t.hidden = 0 AND display_product = 1
105 0.0010 0.0010099411010742
SELECT * FROM productamazoncontent WHERE product_id = '4929'
106 0.0002 0.0002288818359375
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4929' AND a.name = n.originalname
107 0.0004 0.00037598609924316
SELECT * FROM productoffers WHERE product_id = '4929' AND merchantid = 'A1X6FK5RDHNB96'
108 0.0002 0.00022292137145996
SELECT * FROM productoffers
                WHERE product_id = '4929' AND price > 0
                ORDER BY price ASC LIMIT 1
109 0.0003 0.00025200843811035
SELECT * FROM productoffers
                WHERE product_id = 4929
                ORDER BY price ASC LIMIT 1
110 0.0002 0.00019502639770508
SELECT value FROM productattributes
                WHERE product_id = '4929'
                AND name = 'ListPriceAmount'
111 0.0003 0.00026512145996094
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.00022602081298828
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.00023603439331055
SELECT * FROM ebay_locale_details WHERE cur_code = 'USD' 
114 0.0002 0.00023484230041504
SELECT * FROM ebay_products_cache WHERE cachekey = '4ee8d429538b2b5d4286b7d39916c82c' 
115 0.0003 0.00027203559875488
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.00027084350585938
SELECT * FROM ebay_products_cache WHERE cachekey = '4ee8d429538b2b5d4286b7d39916c82c' 
117 0.0012 0.0011770725250244
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.68633317947388', '0fa3e9345cb811b7d80521bd431a0417', 'http://www.boite-a-the.fr/ethiquable-cafe-grains-honduras-Equitable-bio-1-kg-paysans-producteurs/', '2021-07-26 00:16:53'
118 0.0077 0.0077419281005859
SELECT *, MATCH (description, title) AGAINST ('ethiquable café grains' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('ethiquable café grains' IN BOOLEAN MODE) AND 4929 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
119 0.0008 0.00075101852416992
SELECT *, MATCH (description, title) AGAINST ('ethiquable café grains' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('ethiquable café grains' IN BOOLEAN MODE) AND 4929 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
120 0.0006 0.00061321258544922
SELECT *, MATCH (description, title) AGAINST ('ethiquable café grains' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('ethiquable café grains' IN BOOLEAN MODE) AND 4929 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
121 0.0004 0.00035715103149414
SELECT * FROM productimages WHERE product_id = '3204' ORDER BY sortorder ASC
122 0.0008 0.00080394744873047
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3204' AND p.id = pi.product_id ORDER BY pi.sortorder
123 0.0003 0.00026202201843262
SELECT * FROM product_image_select WHERE product_id = '3204'
124 0.0002 0.00019502639770508
SELECT * FROM productcustomimages WHERE product_id = '3204'
125 0.0006 0.00064921379089355
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 = '3204'
                GROUP BY o.product_id
126 0.0009 0.00085902214050293
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     = '3204'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
127 0.0006 0.0006101131439209
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3204
128 0.0008 0.00075912475585938
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3204' AND a.name = n.originalname
129 0.0004 0.00044012069702148
SELECT * FROM productoffers WHERE product_id = '3204' AND merchantid = 'A1X6FK5RDHNB96'
130 0.0003 0.00032401084899902
SELECT * FROM productoffers
                WHERE product_id = '3204' AND price > 0
                ORDER BY price ASC LIMIT 1
131 0.0003 0.00029110908508301
SELECT * FROM productoffers
                WHERE product_id = 3204
                ORDER BY price ASC LIMIT 1
132 0.0004 0.00041294097900391
SELECT value FROM productattributes
                WHERE product_id = '3204'
                AND name = 'ListPriceAmount'
133 0.0002 0.00020599365234375
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 = '3204'
                GROUP BY o.product_id
134 0.0003 0.00026202201843262
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     = '3204'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
135 0.0002 0.0001990795135498
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3204
136 0.0004 0.00042080879211426
SELECT value FROM productattributes WHERE product_id = '3204' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
137 0.0006 0.00063419342041016
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3204'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
138 0.0002 0.00020384788513184
SELECT * FROM productimages WHERE product_id = '2671' ORDER BY sortorder ASC
139 0.0002 0.00017309188842773
SELECT * FROM product_image_select WHERE product_id = '2671'
140 0.0002 0.00018215179443359
SELECT * FROM productcustomimages WHERE product_id = '2671'
141 0.0002 0.00020790100097656
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2671' AND a.name = n.originalname
142 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '2671' AND merchantid = 'A1X6FK5RDHNB96'
143 0.0002 0.00021600723266602
SELECT * FROM productoffers
                WHERE product_id = '2671' AND price > 0
                ORDER BY price ASC LIMIT 1
144 0.0002 0.00023221969604492
SELECT value FROM productattributes WHERE product_id = '2671' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
145 0.0003 0.00025606155395508
SELECT * FROM productimages WHERE product_id = '1470' ORDER BY sortorder ASC
146 0.0002 0.0001981258392334
SELECT * FROM product_image_select WHERE product_id = '1470'
147 0.0002 0.00019311904907227
SELECT * FROM productcustomimages WHERE product_id = '1470'
148 0.0003 0.00026392936706543
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1470' AND a.name = n.originalname
149 0.0002 0.00020694732666016
SELECT * FROM productoffers WHERE product_id = '1470' AND merchantid = 'A1X6FK5RDHNB96'
150 0.0004 0.00040984153747559
SELECT * FROM productoffers
                WHERE product_id = '1470' AND price > 0
                ORDER BY price ASC LIMIT 1
151 0.0002 0.00020885467529297
SELECT value FROM productattributes WHERE product_id = '1470' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
152 0.0005 0.00046586990356445
SELECT id,asin FROM products WHERE parent_id = 4929
153 0.0002 0.00015616416931152
SELECT category_id FROM products_categories WHERE product_id = '4929'
154 0.0002 0.00024294853210449
SELECT * FROM categories WHERE id = '30'
155 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 = 30
156 0.0002 0.00017094612121582
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
157 0.0002 0.00018215179443359
SELECT id FROM categories WHERE parent_id = '30'
158 0.0002 0.00018119812011719
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 
159 0.0002 0.00016999244689941
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 
160 0.0002 0.00017499923706055
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
161 0.0003 0.00025200843811035
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
162 0.0002 0.00020885467529297
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4929' AND a.name = n.originalname
163 0.0003 0.00030088424682617
SELECT * FROM productoffers WHERE product_id = '4929' AND merchantid = 'A1X6FK5RDHNB96'
164 0.0002 0.00024008750915527
SELECT * FROM productoffers
                WHERE product_id = '4929' AND price > 0
                ORDER BY price ASC LIMIT 1
165 0.0003 0.00025486946105957
SELECT * FROM productoffers
                WHERE product_id = 4929
                ORDER BY price ASC LIMIT 1
166 0.0002 0.00020885467529297
SELECT value FROM productattributes
                WHERE product_id = '4929'
                AND name = 'ListPriceAmount'
167 0.0004 0.00037884712219238
SELECT * FROM products WHERE id = '4929'
168 0.0002 0.00023198127746582
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4929' AND a.name = n.originalname
169 0.0003 0.00032401084899902
SELECT * FROM productoffers WHERE product_id = '4929' AND merchantid = 'A1X6FK5RDHNB96'
170 0.0003 0.00025200843811035
SELECT * FROM productoffers
                WHERE product_id = '4929' AND price > 0
                ORDER BY price ASC LIMIT 1
171 0.0003 0.00027585029602051
SELECT * FROM productoffers
                WHERE product_id = 4929
                ORDER BY price ASC LIMIT 1
172 0.0002 0.00022292137145996
SELECT value FROM productattributes
                WHERE product_id = '4929'
                AND name = 'ListPriceAmount'
173 0.0004 0.00040197372436523
SELECT category_id FROM products_categories WHERE product_id = '4929' AND prod_type = 'amz'
174 0.0004 0.0003969669342041
SELECT parent_id FROM categories WHERE id = '30'
175 0.0003 0.00026297569274902
SELECT * FROM categories WHERE id = '30'
176 0.0002 0.00019598007202148
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
177 0.0002 0.00018906593322754
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
178 0.0002 0.00019311904907227
SELECT id FROM categories WHERE parent_id = '30'
179 0.0002 0.00019598007202148
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 
180 0.0002 0.00019693374633789
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 
181 0.0002 0.00018906593322754
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
182 0.0003 0.00030398368835449
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
183 0.0003 0.00031280517578125
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
184 0.0002 0.00022506713867188
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
185 0.0003 0.00025701522827148
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
186 0.0003 0.0002589225769043
SELECT * FROM pages WHERE id = 38
187 0.0003 0.00028300285339355
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
188 0.0004 0.00042104721069336
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:1627258613;s:8:\"products\";a:6:{i:0;s:10:\"808|amazon\";i:1;s:11:\"4939|amazon\";i:2;s:10:\"873|amazon\";i:3;s:10:\"894|amazon\";i:4;s:10:\"881|amazon\";i:5;s:10:\"887|amazon\";}}' WHERE id = '160'
189 0.0003 0.00028395652770996
SELECT * FROM products WHERE id = 808
190 0.0004 0.00040888786315918
SELECT * FROM products WHERE id = 4939
191 0.0004 0.00041007995605469
SELECT * FROM products WHERE id = 873
192 0.0005 0.00049591064453125
SELECT * FROM products WHERE id = 894
193 0.0005 0.00046396255493164
SELECT * FROM products WHERE id = 881
194 0.0003 0.0003349781036377
SELECT * FROM products WHERE id = 887
195 0.0005 0.00054502487182617
SELECT * FROM products WHERE id = '808'
196 0.0002 0.00024104118347168
SELECT * FROM productimages WHERE product_id = '808' ORDER BY sortorder ASC
197 0.0002 0.00022315979003906
SELECT * FROM product_image_select WHERE product_id = '808'
198 0.0003 0.00025081634521484
SELECT * FROM productcustomimages WHERE product_id = '808'
199 0.0003 0.00026512145996094
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '808' AND a.name = n.originalname
200 0.0003 0.00028300285339355
SELECT * FROM productoffers WHERE product_id = '808' AND merchantid = 'A1X6FK5RDHNB96'
201 0.0003 0.00025486946105957
SELECT * FROM productoffers
                WHERE product_id = '808' AND price > 0
                ORDER BY price ASC LIMIT 1
202 0.0002 0.00022006034851074
SELECT value FROM productattributes WHERE product_id = '808' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
203 0.0003 0.00029110908508301
SELECT * FROM products WHERE id = '4939'
204 0.0002 0.00021195411682129
SELECT * FROM productimages WHERE product_id = '4939' ORDER BY sortorder ASC
205 0.0003 0.00025296211242676
SELECT * FROM product_image_select WHERE product_id = '4939'
206 0.0002 0.00018405914306641
SELECT * FROM productcustomimages WHERE product_id = '4939'
207 0.0002 0.00024700164794922
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4939' AND a.name = n.originalname
208 0.0002 0.0001978874206543
SELECT * FROM productoffers WHERE product_id = '4939' AND merchantid = 'A1X6FK5RDHNB96'
209 0.0002 0.00022983551025391
SELECT * FROM productoffers
                WHERE product_id = '4939' AND price > 0
                ORDER BY price ASC LIMIT 1
210 0.0003 0.00025510787963867
SELECT value FROM productattributes WHERE product_id = '4939' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
211 0.0003 0.0002739429473877
SELECT * FROM products WHERE id = '873'
212 0.0003 0.00026321411132812
SELECT * FROM productimages WHERE product_id = '873' ORDER BY sortorder ASC
213 0.0002 0.00021910667419434
SELECT * FROM product_image_select WHERE product_id = '873'
214 0.0002 0.00019311904907227
SELECT * FROM productcustomimages WHERE product_id = '873'
215 0.0003 0.00029706954956055
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '873' AND a.name = n.originalname
216 0.0003 0.00029182434082031
SELECT * FROM productoffers WHERE product_id = '873' AND merchantid = 'A1X6FK5RDHNB96'
217 0.0005 0.0005190372467041
SELECT * FROM productoffers
                WHERE product_id = '873' AND price > 0
                ORDER BY price ASC LIMIT 1
218 0.0003 0.00025796890258789
SELECT value FROM productattributes WHERE product_id = '873' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
219 0.0003 0.00028800964355469
SELECT * FROM products WHERE id = '894'
220 0.0003 0.00028896331787109
SELECT * FROM productimages WHERE product_id = '894' ORDER BY sortorder ASC
221 0.0002 0.00023293495178223
SELECT * FROM product_image_select WHERE product_id = '894'
222 0.0002 0.00019192695617676
SELECT * FROM productcustomimages WHERE product_id = '894'
223 0.0002 0.0001990795135498
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '894' AND a.name = n.originalname
224 0.0003 0.00030398368835449
SELECT * FROM productoffers WHERE product_id = '894' AND merchantid = 'A1X6FK5RDHNB96'
225 0.0003 0.00027799606323242
SELECT * FROM productoffers
                WHERE product_id = '894' AND price > 0
                ORDER BY price ASC LIMIT 1
226 0.0003 0.00027298927307129
SELECT value FROM productattributes WHERE product_id = '894' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
227 0.0003 0.0002899169921875
SELECT * FROM products WHERE id = '881'
228 0.0002 0.00019598007202148
SELECT * FROM productimages WHERE product_id = '881' ORDER BY sortorder ASC
229 0.0002 0.00023007392883301
SELECT * FROM product_image_select WHERE product_id = '881'
230 0.0002 0.00019693374633789
SELECT * FROM productcustomimages WHERE product_id = '881'
231 0.0002 0.00022101402282715
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '881' AND a.name = n.originalname
232 0.0002 0.00023102760314941
SELECT * FROM productoffers WHERE product_id = '881' AND merchantid = 'A1X6FK5RDHNB96'
233 0.0003 0.00025177001953125
SELECT * FROM productoffers
                WHERE product_id = '881' AND price > 0
                ORDER BY price ASC LIMIT 1
234 0.0002 0.0001828670501709
SELECT value FROM productattributes WHERE product_id = '881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
235 0.0003 0.00028014183044434
SELECT * FROM products WHERE id = '887'
236 0.0003 0.00032615661621094
SELECT * FROM productimages WHERE product_id = '887' ORDER BY sortorder ASC
237 0.0002 0.00023293495178223
SELECT * FROM product_image_select WHERE product_id = '887'
238 0.0003 0.0003209114074707
SELECT * FROM productcustomimages WHERE product_id = '887'
239 0.0002 0.00022411346435547
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '887' AND a.name = n.originalname
240 0.0003 0.00028705596923828
SELECT * FROM productoffers WHERE product_id = '887' AND merchantid = 'A1X6FK5RDHNB96'
241 0.0002 0.00024580955505371
SELECT * FROM productoffers
                WHERE product_id = '887' AND price > 0
                ORDER BY price ASC LIMIT 1
242 0.0002 0.00016999244689941
SELECT value FROM productattributes WHERE product_id = '887' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
243 0.0004 0.0004119873046875
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
244 0.0003 0.00030684471130371
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
245 0.0008 0.0007779598236084
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
246 0.0005 0.00052285194396973
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
247 0.0004 0.0004279613494873
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
248 0.0004 0.00037193298339844
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
249 0.0003 0.00027084350585938
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
250 0.0003 0.00028300285339355
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'