Sunny jours boîtes Thé Café et sucre

Sunny jours boîtes Thé Café et sucre
Sunny jours boîtes Thé Café et sucre Sunny jours boîtes Thé Café et sucre Sunny jours boîtes Thé Café et sucre Sunny jours boîtes Thé Café et sucre Sunny jours boîtes Thé Café et sucre (cliquez sur les images pour élargir)
Bouton de clic pour le prix
Non Disponible Épuisé
Le prix et la disponibilité du produit sont corrects en date du 2021-09-15 00:38:46 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

Lot de 3 boîtes de rangement thé café et sucre Dimensions?: 11,5 cm x 11,5 cm x 12 cm avec couvercle à charnière Couleurs Pastel «?soleil?» Accessoires assortis disponibles
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
2.0280790328979 235 0.3333 0


No Amazon API Requests Made.

Total time 2.0280790328979 seconds

Number Time From Start Name Description
1 1.5082550048828 Initialise Initialise FSB Function
2 1.5117199420929 App Controller Start Start of the App controller (called before the controller of every page)
3 1.5151660442352 Start of getCategoryListByGroup Function Before first category groups query
4 1.5155739784241 After initial query Before first category groups query
5 1.515576839447 Get Category List for Group Before the call to getCategoryList function
6 1.5155818462372 Start of GetCategoryList function Start of the function
7 1.515585899353 Before getting categories Query to get specific category list
8 1.5160570144653 After getting categories Query to get specific category list
9 1.5160598754883 Before getting category custom Before call to function getCategoryCustom
10 1.5478119850159 After getting category custom After call to function getCategoryCustom
11 1.547816991806 Before getting category custom Before call to function getCategoryCustom
12 1.5847949981689 After getting category custom After call to function getCategoryCustom
13 1.5848000049591 Before getting category custom Before call to function getCategoryCustom
14 1.6175909042358 After getting category custom After call to function getCategoryCustom
15 1.6176009178162 Before getting category custom Before call to function getCategoryCustom
16 1.6390769481659 After getting category custom After call to function getCategoryCustom
17 1.6390819549561 Before getting category custom Before call to function getCategoryCustom
18 1.6599390506744 After getting category custom After call to function getCategoryCustom
19 1.6599450111389 Before getting category custom Before call to function getCategoryCustom
20 1.6667790412903 After getting category custom After call to function getCategoryCustom
21 1.6667850017548 End of GetCategoryList function End of the function
22 1.6667969226837 End of getCategoryListByGroup Function Before return()
23 1.6768078804016 App Controller End End of the App controller (called before the controller of every page)
24 1.6776750087738 Product Start Start of the product info controller
25 1.6879320144653 Cache file not found Starting get product details
26 1.7230460643768 Related products Start getting related products if enabled
27 1.7230489253998 Related Products Start Before the related products are found
28 1.7230508327484 Related Products Keywords Before the related product keywords are found
29 1.7230589389801 Create Keyword List Function Start of function
30 1.7231860160828 Create Keyword List Function After looping provided content - 18 keywords found
31 1.7249848842621 Create Keyword List Function After looping initial keyword list - 17 keywords remaining
32 1.7249948978424 Create Keyword List Function After reducing keyword list
33 1.7250318527222 Create Keyword List Function After selecting by scoring keywords
34 1.7250368595123 Create Keyword List Function After final loop of keywords
35 1.7250399589539 Related Products Keywords After the related product keywords are found
36 1.7628738880157 Related Products End After the related products are found
37 1.7817080020905 Product End End of the product info controller (Product Info)
38 1.7833080291748 App_after Controller Start Start of the App_after controller (called after the controller of every page)
39 1.7846939563751 Before Get Options Before the call to getOptions in the tpl class
40 1.8239469528198 After Get Options After the call to getOptions in the tpl class
41 1.824159860611 App_after Controller End End of the App_after controller (called after the controller of every page)
42 1.8242108821869 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
43 1.8611340522766 Product Info: After Smarty Fetch After the product.tpl template is fetched
44 1.8611440658569 Product Info: Before Template Display Before the template is displayed
45 2.0280208587646 Product Info: After Template Display After the template is displayed
46 2.028048992157 Finalizing debug Before the debug is output to the page.
47 2.0280768871307 End of App This is the end of the app logging, final timestamp


Query Debug - 235 Database Queries. Total time 0.3333 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0104 0.010388851165771
SELECT parameter, value FROM parameters
2 0.0015 0.0014829635620117
SELECT * FROM `bad_bots`
3 0.0004 0.00039196014404297
SET time_zone = 'Europe/London'
4 0.0002 0.00023794174194336
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0103 0.010267972946167
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"3.227.235.216\";}'
6 0.0100 0.010025978088379
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1632225351'
7 0.0024 0.0023620128631592
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0008 0.00076198577880859
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0007 0.0007171630859375
SELECT id FROM pages WHERE pagename = 'sunny-jours-botes-the-cafe-et-sucre' LIMIT 1
10 0.0007 0.00071501731872559
SELECT id FROM products WHERE pagename = 'sunny-jours-botes-the-cafe-et-sucre' AND hidden = 0 LIMIT 1
11 0.0013 0.0012578964233398
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
12 0.0007 0.00071597099304199
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
13 0.0006 0.00062704086303711
SELECT * FROM pages WHERE pagename = 'sunny-jours-botes-the-cafe-et-sucre'
14 0.0004 0.00038003921508789
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0004 0.0004420280456543
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0106 0.010633945465088
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.0004 0.00035309791564941
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.00024008750915527
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0004 0.00037002563476562
SELECT id FROM categories WHERE parent_id = '26'
20 0.0088 0.0087900161743164
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.0025 0.0025029182434082
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.0021 0.0020990371704102
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.0023 0.0023481845855713
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0041 0.0041470527648926
SELECT * FROM categorygroups WHERE id = '1'
25 0.0043 0.0042538642883301
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.0044 0.0043559074401855
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.0037 0.0037400722503662
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0042 0.0042450428009033
SELECT id FROM categories WHERE parent_id = '27'
29 0.0042 0.0042030811309814
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.0041 0.0040700435638428
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.0036 0.0036079883575439
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.0038 0.0038208961486816
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0045 0.0044820308685303
SELECT * FROM categorygroups WHERE id = '1'
34 0.0064 0.0064389705657959
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.0045 0.0045459270477295
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.0046 0.0046470165252686
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0037 0.0037438869476318
SELECT id FROM categories WHERE parent_id = '28'
38 0.0048 0.0048439502716064
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.0018 0.0018270015716553
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.0023 0.0022819042205811
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.0020 0.0020411014556885
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0022 0.0021510124206543
SELECT * FROM categorygroups WHERE id = '1'
43 0.0031 0.0031111240386963
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.0023 0.0022990703582764
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.0020 0.0019798278808594
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0022 0.0022399425506592
SELECT id FROM categories WHERE parent_id = '29'
47 0.0032 0.0031919479370117
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.0021 0.0020651817321777
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.0019 0.0019190311431885
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.0023 0.0022721290588379
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0022 0.0021629333496094
SELECT * FROM categorygroups WHERE id = '1'
52 0.0026 0.002626895904541
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.0024 0.0023980140686035
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.0020 0.0020339488983154
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0025 0.0024750232696533
SELECT id FROM categories WHERE parent_id = '30'
56 0.0027 0.0026609897613525
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.0025 0.0025241374969482
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.0025 0.0024750232696533
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.0029 0.0028688907623291
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0006 0.00058484077453613
SELECT * FROM categorygroups WHERE id = '1'
61 0.0013 0.0012838840484619
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.0006 0.00059700012207031
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.0008 0.00084090232849121
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0007 0.00070095062255859
SELECT id FROM categories WHERE parent_id = '31'
65 0.0014 0.0014309883117676
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.0004 0.00036406517028809
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.0005 0.00053906440734863
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.0004 0.00042104721069336
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0005 0.00045895576477051
SELECT * FROM categorygroups WHERE id = '1'
70 0.0004 0.00042605400085449
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
71 0.0005 0.00053095817565918
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
72 0.0003 0.00034809112548828
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.0003 0.00030422210693359
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
74 0.0008 0.000823974609375
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
75 0.0007 0.0007171630859375
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
76 0.0006 0.0006401538848877
SELECT * FROM ipgeocountries WHERE INET_ATON('3.227.235.216') >= INET_ATON(ip_start) AND INET_ATON('3.227.235.216') <= INET_ATON(ip_end)
77 0.0004 0.0003960132598877
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
78 0.0003 0.00034403800964355
SELECT * FROM countryredirects WHERE countrycode = 'US'
79 0.0009 0.00093603134155273
SELECT * FROM products WHERE pagename = 'sunny-jours-botes-the-cafe-et-sucre'
80 0.0023 0.0022890567779541
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1669
81 0.0007 0.00074410438537598
SELECT * FROM manufacturers WHERE id = '378'
82 0.0009 0.00094509124755859
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '378'
83 0.0005 0.00052499771118164
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '378' LIMIT 1
84 0.0012 0.0011770725250244
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '378' ORDER BY RAND() LIMIT 1
85 0.0003 0.00031208992004395
SELECT * FROM productimages WHERE product_id = '1669' ORDER BY sortorder ASC
86 0.0004 0.00044584274291992
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '378'
87 0.0009 0.00087809562683105
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '378'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
88 0.0011 0.0010910034179688
SELECT * FROM manufacturerimages WHERE manufacturer_id = '378'
89 0.0005 0.00045204162597656
SELECT category_id FROM products_categories WHERE product_id = '1669'
90 0.0005 0.00052404403686523
SELECT * FROM categories WHERE id = '26'
91 0.0077 0.007702112197876
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
92 0.0003 0.00034904479980469
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
93 0.0004 0.00036215782165527
SELECT id FROM categories WHERE parent_id = '26'
94 0.0078 0.0077650547027588
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 
95 0.0006 0.00064587593078613
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 
96 0.0007 0.00069308280944824
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
97 0.0003 0.00034117698669434
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
98 0.0003 0.00029921531677246
SELECT * FROM productimages WHERE product_id = '1669' ORDER BY sortorder ASC
99 0.0003 0.00027298927307129
SELECT * FROM product_image_select WHERE product_id = '1669'
100 0.0004 0.00043797492980957
SELECT * FROM productcustomimages WHERE product_id = '1669'
101 0.0006 0.00064611434936523
SELECT * FROM productfeeds WHERE product_id = '1669' ORDER BY item_date DESC
102 0.0015 0.001471996307373
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '1669' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
103 0.0007 0.00074505805969238
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '1669' AND t.hidden = 0 AND display_product = 1
104 0.0006 0.00061798095703125
SELECT * FROM productamazoncontent WHERE product_id = '1669'
105 0.0015 0.0014538764953613
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1669' AND a.name = n.originalname
106 0.0006 0.00055408477783203
SELECT * FROM productoffers WHERE product_id = '1669' AND merchantid = 'A1X6FK5RDHNB96'
107 0.0006 0.00055813789367676
SELECT * FROM productoffers
                WHERE product_id = '1669' AND price > 0
                ORDER BY price ASC LIMIT 1
108 0.0004 0.00041413307189941
SELECT * FROM productoffers
                WHERE product_id = 1669
                ORDER BY price ASC LIMIT 1
109 0.0007 0.0006868839263916
SELECT value FROM productattributes
                WHERE product_id = '1669'
                AND name = 'ListPriceAmount'
110 0.0006 0.00063395500183105
SELECT value FROM productattributes WHERE product_id = '1669' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
111 0.0003 0.00026607513427734
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.0102 0.010205984115601
SELECT *, MATCH (description, title) AGAINST ('café et sucre' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('café et sucre' IN BOOLEAN MODE) AND 1669 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
113 0.0013 0.0013110637664795
SELECT *, MATCH (description, title) AGAINST ('café et sucre' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('café et sucre' IN BOOLEAN MODE) AND 1669 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
114 0.0010 0.00098109245300293
SELECT *, MATCH (description, title) AGAINST ('café et sucre' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('café et sucre' IN BOOLEAN MODE) AND 1669 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
115 0.0076 0.0075671672821045
SELECT * FROM productimages WHERE product_id = '764' ORDER BY sortorder ASC
116 0.0009 0.00092101097106934
SELECT * FROM product_image_select WHERE product_id = '764'
117 0.0004 0.0003669261932373
SELECT * FROM productcustomimages WHERE product_id = '764'
118 0.0004 0.00040602684020996
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '764' AND a.name = n.originalname
119 0.0004 0.00037884712219238
SELECT * FROM productoffers WHERE product_id = '764' AND merchantid = 'A1X6FK5RDHNB96'
120 0.0004 0.00039792060852051
SELECT * FROM productoffers
                WHERE product_id = '764' AND price > 0
                ORDER BY price ASC LIMIT 1
121 0.0009 0.00092506408691406
SELECT value FROM productattributes WHERE product_id = '764' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
122 0.0004 0.00037980079650879
SELECT * FROM productimages WHERE product_id = '790' ORDER BY sortorder ASC
123 0.0006 0.00060391426086426
SELECT * FROM product_image_select WHERE product_id = '790'
124 0.0003 0.0003349781036377
SELECT * FROM productcustomimages WHERE product_id = '790'
125 0.0008 0.00078797340393066
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '790' AND a.name = n.originalname
126 0.0004 0.00041103363037109
SELECT * FROM productoffers WHERE product_id = '790' AND merchantid = 'A1X6FK5RDHNB96'
127 0.0036 0.0035920143127441
SELECT * FROM productoffers
                WHERE product_id = '790' AND price > 0
                ORDER BY price ASC LIMIT 1
128 0.0005 0.0005030632019043
SELECT value FROM productattributes WHERE product_id = '790' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
129 0.0005 0.0005340576171875
SELECT * FROM productimages WHERE product_id = '810' ORDER BY sortorder ASC
130 0.0006 0.00056004524230957
SELECT * FROM product_image_select WHERE product_id = '810'
131 0.0003 0.00030899047851562
SELECT * FROM productcustomimages WHERE product_id = '810'
132 0.0017 0.0016710758209229
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '810' AND a.name = n.originalname
133 0.0009 0.00091195106506348
SELECT * FROM productoffers WHERE product_id = '810' AND merchantid = 'A1X6FK5RDHNB96'
134 0.0006 0.0006411075592041
SELECT * FROM productoffers
                WHERE product_id = '810' AND price > 0
                ORDER BY price ASC LIMIT 1
135 0.0018 0.0018079280853271
SELECT value FROM productattributes WHERE product_id = '810' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
136 0.0008 0.00077199935913086
SELECT id,asin FROM products WHERE parent_id = 1669
137 0.0004 0.00037407875061035
SELECT category_id FROM products_categories WHERE product_id = '1669'
138 0.0005 0.00049710273742676
SELECT * FROM categories WHERE id = '26'
139 0.0003 0.00028300285339355
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
140 0.0005 0.00049805641174316
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
141 0.0003 0.00032687187194824
SELECT id FROM categories WHERE parent_id = '26'
142 0.0003 0.0002741813659668
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 
143 0.0004 0.00039410591125488
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 
144 0.0003 0.00029206275939941
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
145 0.0002 0.00023007392883301
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
146 0.0004 0.00038290023803711
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1669' AND a.name = n.originalname
147 0.0003 0.00027203559875488
SELECT * FROM productoffers WHERE product_id = '1669' AND merchantid = 'A1X6FK5RDHNB96'
148 0.0005 0.0004880428314209
SELECT * FROM productoffers
                WHERE product_id = '1669' AND price > 0
                ORDER BY price ASC LIMIT 1
149 0.0003 0.00034308433532715
SELECT * FROM productoffers
                WHERE product_id = 1669
                ORDER BY price ASC LIMIT 1
150 0.0002 0.00024294853210449
SELECT value FROM productattributes
                WHERE product_id = '1669'
                AND name = 'ListPriceAmount'
151 0.0012 0.0012431144714355
SELECT * FROM products WHERE id = '1669'
152 0.0004 0.00040602684020996
SELECT value FROM productattributes WHERE product_id = '1669' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
153 0.0006 0.0006098747253418
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1669' AND a.name = n.originalname
154 0.0007 0.00070905685424805
SELECT * FROM productoffers WHERE product_id = '1669' AND merchantid = 'A1X6FK5RDHNB96'
155 0.0007 0.00072884559631348
SELECT * FROM productoffers
                WHERE product_id = '1669' AND price > 0
                ORDER BY price ASC LIMIT 1
156 0.0007 0.00070405006408691
SELECT * FROM productoffers
                WHERE product_id = 1669
                ORDER BY price ASC LIMIT 1
157 0.0007 0.000701904296875
SELECT value FROM productattributes
                WHERE product_id = '1669'
                AND name = 'ListPriceAmount'
158 0.0009 0.00087285041809082
SELECT category_id FROM products_categories WHERE product_id = '1669' AND prod_type = 'amz'
159 0.0006 0.00058388710021973
SELECT parent_id FROM categories WHERE id = '26'
160 0.0006 0.000640869140625
SELECT * FROM categories WHERE id = '26'
161 0.0007 0.00067615509033203
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
162 0.0007 0.00067400932312012
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
163 0.0007 0.00065302848815918
SELECT id FROM categories WHERE parent_id = '26'
164 0.0003 0.0002899169921875
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 
165 0.0005 0.0005190372467041
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 
166 0.0008 0.00075912475585938
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
167 0.0016 0.0016379356384277
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
168 0.0008 0.00082015991210938
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
169 0.0003 0.00029087066650391
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
170 0.0009 0.00094008445739746
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
171 0.0006 0.00057792663574219
SELECT * FROM pages WHERE id = 38
172 0.0056 0.0056290626525879
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
173 0.0006 0.00063705444335938
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:1632225352;s:8:\"products\";a:6:{i:0;s:10:\"790|amazon\";i:1;s:10:\"788|amazon\";i:2;s:10:\"787|amazon\";i:3;s:11:\"1287|amazon\";i:4;s:10:\"779|amazon\";i:5;s:10:\"777|amazon\";}}' WHERE id = '160'
174 0.0005 0.00052499771118164
SELECT * FROM products WHERE id = 790
175 0.0005 0.00054287910461426
SELECT * FROM products WHERE id = 788
176 0.0007 0.00066304206848145
SELECT * FROM products WHERE id = 787
177 0.0006 0.00055599212646484
SELECT * FROM products WHERE id = 1287
178 0.0005 0.00048494338989258
SELECT * FROM products WHERE id = 779
179 0.0004 0.00043392181396484
SELECT * FROM products WHERE id = 777
180 0.0006 0.00062084197998047
SELECT * FROM products WHERE id = '790'
181 0.0003 0.00033116340637207
SELECT * FROM productimages WHERE product_id = '790' ORDER BY sortorder ASC
182 0.0002 0.00024199485778809
SELECT * FROM product_image_select WHERE product_id = '790'
183 0.0003 0.00027298927307129
SELECT * FROM productcustomimages WHERE product_id = '790'
184 0.0003 0.0002748966217041
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '790' AND a.name = n.originalname
185 0.0002 0.00024580955505371
SELECT * FROM productoffers WHERE product_id = '790' AND merchantid = 'A1X6FK5RDHNB96'
186 0.0003 0.00028800964355469
SELECT * FROM productoffers
                WHERE product_id = '790' AND price > 0
                ORDER BY price ASC LIMIT 1
187 0.0002 0.0002281665802002
SELECT value FROM productattributes WHERE product_id = '790' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
188 0.0009 0.00090289115905762
SELECT * FROM products WHERE id = '788'
189 0.0003 0.00030398368835449
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
190 0.0002 0.00022482872009277
SELECT * FROM product_image_select WHERE product_id = '788'
191 0.0002 0.0002291202545166
SELECT * FROM productcustomimages WHERE product_id = '788'
192 0.0003 0.00026917457580566
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
193 0.0004 0.00043606758117676
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
194 0.0005 0.00052309036254883
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
195 0.0003 0.00026702880859375
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
196 0.0005 0.00051403045654297
SELECT * FROM products WHERE id = '787'
197 0.0005 0.00046205520629883
SELECT * FROM productimages WHERE product_id = '787' ORDER BY sortorder ASC
198 0.0003 0.00030684471130371
SELECT * FROM product_image_select WHERE product_id = '787'
199 0.0003 0.00028204917907715
SELECT * FROM productcustomimages WHERE product_id = '787'
200 0.0003 0.00028800964355469
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '787' AND a.name = n.originalname
201 0.0003 0.00026488304138184
SELECT * FROM productoffers WHERE product_id = '787' AND merchantid = 'A1X6FK5RDHNB96'
202 0.0003 0.00028085708618164
SELECT * FROM productoffers
                WHERE product_id = '787' AND price > 0
                ORDER BY price ASC LIMIT 1
203 0.0002 0.00021910667419434
SELECT value FROM productattributes WHERE product_id = '787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
204 0.0005 0.00053191184997559
SELECT * FROM products WHERE id = '1287'
205 0.0009 0.00090503692626953
SELECT * FROM productimages WHERE product_id = '1287' ORDER BY sortorder ASC
206 0.0006 0.00055909156799316
SELECT * FROM product_image_select WHERE product_id = '1287'
207 0.0028 0.0028228759765625
SELECT * FROM productcustomimages WHERE product_id = '1287'
208 0.0007 0.00066089630126953
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1287' AND a.name = n.originalname
209 0.0009 0.00090289115905762
SELECT * FROM productoffers WHERE product_id = '1287' AND merchantid = 'A1X6FK5RDHNB96'
210 0.0005 0.00048208236694336
SELECT * FROM productoffers
                WHERE product_id = '1287' AND price > 0
                ORDER BY price ASC LIMIT 1
211 0.0003 0.0003049373626709
SELECT value FROM productattributes WHERE product_id = '1287' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
212 0.0011 0.001147985458374
SELECT * FROM products WHERE id = '779'
213 0.0004 0.00041508674621582
SELECT * FROM productimages WHERE product_id = '779' ORDER BY sortorder ASC
214 0.0003 0.00033688545227051
SELECT * FROM product_image_select WHERE product_id = '779'
215 0.0004 0.00037407875061035
SELECT * FROM productcustomimages WHERE product_id = '779'
216 0.0003 0.00025486946105957
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '779' AND a.name = n.originalname
217 0.0003 0.00026297569274902
SELECT * FROM productoffers WHERE product_id = '779' AND merchantid = 'A1X6FK5RDHNB96'
218 0.0003 0.00034403800964355
SELECT * FROM productoffers
                WHERE product_id = '779' AND price > 0
                ORDER BY price ASC LIMIT 1
219 0.0002 0.00021791458129883
SELECT value FROM productattributes WHERE product_id = '779' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
220 0.0006 0.00058412551879883
SELECT * FROM products WHERE id = '777'
221 0.0003 0.00029778480529785
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
222 0.0004 0.00038385391235352
SELECT * FROM product_image_select WHERE product_id = '777'
223 0.0003 0.00026702880859375
SELECT * FROM productcustomimages WHERE product_id = '777'
224 0.0003 0.00028705596923828
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
225 0.0003 0.00029206275939941
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
226 0.0005 0.00046205520629883
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
227 0.0002 0.00022506713867188
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
228 0.0007 0.00073909759521484
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
229 0.0005 0.00051617622375488
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
230 0.0007 0.00070691108703613
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
231 0.0004 0.00036096572875977
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
232 0.0003 0.00033807754516602
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
233 0.0037 0.0036730766296387
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
234 0.0043 0.004317045211792
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
235 0.0025 0.0024750232696533
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'