La Route Des Comptoirs - Rooïbos Tropical Lot De 2 - BIO

La Route Des Comptoirs - Rooïbos Tropical Lot De 2 - BIO
La Route Des Comptoirs - Rooïbos Tropical Lot De 2 - BIO La Route Des Comptoirs - Rooïbos Tropical Lot De 2 - BIO La Route Des Comptoirs - Rooïbos Tropical Lot De 2 - BIO (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 2022-05-10 23:48:28 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

Rooïbos aromatisé Lot de 2 x 100g
CERTAINS ÉLÉMENTS DE CONTENU QUI APPARAISSENT SUR CE SITE PROVIENNENT DE AMAZON SERVICES LLC. CE CONTENU EST FOURNI TEL QUEL ET EST SUJET À CHANGEMENTS OU RETRAIT À TOUT MOMENT.

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
0.87485098838806 240 0.1743 0


No Amazon API Requests Made.

Total time 0.87485098838806 seconds

Number Time From Start Name Description
1 0.65114903450012 Initialise Initialise FSB Function
2 0.65382099151611 App Controller Start Start of the App controller (called before the controller of every page)
3 0.65754508972168 Start of getCategoryListByGroup Function Before first category groups query
4 0.6581449508667 After initial query Before first category groups query
5 0.65814685821533 Get Category List for Group Before the call to getCategoryList function
6 0.65814995765686 Start of GetCategoryList function Start of the function
7 0.65815305709839 Before getting categories Query to get specific category list
8 0.65861487388611 After getting categories Query to get specific category list
9 0.65861701965332 Before getting category custom Before call to function getCategoryCustom
10 0.67874097824097 After getting category custom After call to function getCategoryCustom
11 0.6787440776825 Before getting category custom Before call to function getCategoryCustom
12 0.69129204750061 After getting category custom After call to function getCategoryCustom
13 0.69129395484924 Before getting category custom Before call to function getCategoryCustom
14 0.69775891304016 After getting category custom After call to function getCategoryCustom
15 0.69776105880737 Before getting category custom Before call to function getCategoryCustom
16 0.70265102386475 After getting category custom After call to function getCategoryCustom
17 0.70265293121338 Before getting category custom Before call to function getCategoryCustom
18 0.70756697654724 After getting category custom After call to function getCategoryCustom
19 0.70757007598877 Before getting category custom Before call to function getCategoryCustom
20 0.71217703819275 After getting category custom After call to function getCategoryCustom
21 0.7121798992157 End of GetCategoryList function End of the function
22 0.71218395233154 End of getCategoryListByGroup Function Before return()
23 0.717689037323 App Controller End End of the App controller (called before the controller of every page)
24 0.71795296669006 Product Start Start of the product info controller
25 0.73013186454773 Cache file not found Starting get product details
26 0.7667498588562 Related products Start getting related products if enabled
27 0.76675200462341 Related Products Start Before the related products are found
28 0.76675295829773 Related Products Keywords Before the related product keywords are found
29 0.76675605773926 Create Keyword List Function Start of function
30 0.76678395271301 Create Keyword List Function After looping provided content - 27 keywords found
31 0.76770186424255 Create Keyword List Function After looping initial keyword list - 20 keywords remaining
32 0.76770901679993 Create Keyword List Function After reducing keyword list
33 0.76775503158569 Create Keyword List Function After selecting by scoring keywords
34 0.76775789260864 Create Keyword List Function After final loop of keywords
35 0.76775908470154 Related Products Keywords After the related product keywords are found
36 0.79046487808228 Related Products End After the related products are found
37 0.80027794837952 Product End End of the product info controller (Product Info)
38 0.80106687545776 App_after Controller Start Start of the App_after controller (called after the controller of every page)
39 0.80207705497742 Before Get Options Before the call to getOptions in the tpl class
40 0.83815908432007 After Get Options After the call to getOptions in the tpl class
41 0.83823800086975 App_after Controller End End of the App_after controller (called after the controller of every page)
42 0.83826088905334 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
43 0.85050392150879 Product Info: After Smarty Fetch After the product.tpl template is fetched
44 0.85050892829895 Product Info: Before Template Display Before the template is displayed
45 0.87483096122742 Product Info: After Template Display After the template is displayed
46 0.87483501434326 Finalizing debug Before the debug is output to the page.
47 0.87485003471375 End of App This is the end of the app logging, final timestamp


Query Debug - 240 Database Queries. Total time 0.1743 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0008 0.00075101852416992
SELECT parameter, value FROM parameters
2 0.0011 0.0011389255523682
SELECT * FROM `bad_bots`
3 0.0005 0.00053691864013672
SET time_zone = 'Europe/London'
4 0.0004 0.00043296813964844
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0019 0.0019209384918213
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"3.238.180.255\";}'
6 0.0012 0.0011811256408691
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1653089112'
7 0.0009 0.00092196464538574
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0005 0.00046801567077637
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0008 0.00078511238098145
SELECT id FROM pages WHERE pagename = 'la-route-des-comptoirs-roobos-tropical-lot-de-2-bio' LIMIT 1
10 0.0009 0.00093293190002441
SELECT id FROM products WHERE pagename = 'la-route-des-comptoirs-roobos-tropical-lot-de-2-bio' AND hidden = 0 LIMIT 1
11 0.0014 0.0014181137084961
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
12 0.0010 0.0010418891906738
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
13 0.0009 0.0008540153503418
SELECT * FROM pages WHERE pagename = 'la-route-des-comptoirs-roobos-tropical-lot-de-2-bio'
14 0.0006 0.00058698654174805
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0004 0.00043892860412598
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0100 0.01003885269165
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.0006 0.00055909156799316
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.0004 0.0003509521484375
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0005 0.00046777725219727
SELECT id FROM categories WHERE parent_id = '26'
20 0.0071 0.0070769786834717
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.0004 0.00043487548828125
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0 
22 0.0003 0.00030708312988281
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
23 0.0003 0.00033998489379883
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0004 0.00040411949157715
SELECT * FROM categorygroups WHERE id = '1'
25 0.0046 0.0045840740203857
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.0006 0.00064396858215332
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.0002601146697998
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0003 0.00032997131347656
SELECT id FROM categories WHERE parent_id = '27'
29 0.0048 0.0047998428344727
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.0005 0.00051403045654297
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.0005 0.00049495697021484
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.0003 0.00026679039001465
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0005 0.00053000450134277
SELECT * FROM categorygroups WHERE id = '1'
34 0.0018 0.0018308162689209
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.0004 0.00044894218444824
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.0005 0.00045204162597656
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0003 0.00027799606323242
SELECT id FROM categories WHERE parent_id = '28'
38 0.0019 0.0019278526306152
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.0004 0.00040507316589355
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.0005 0.0004730224609375
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.0003 0.00026392936706543
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0002 0.00024604797363281
SELECT * FROM categorygroups WHERE id = '1'
43 0.0007 0.00070714950561523
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.0004 0.0004270076751709
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.0005 0.00049090385437012
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0005 0.00048112869262695
SELECT id FROM categories WHERE parent_id = '29'
47 0.0010 0.00095295906066895
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.0005 0.00050091743469238
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0 
49 0.0004 0.0004429817199707
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.0004 0.00039410591125488
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0004 0.00036406517028809
SELECT * FROM categorygroups WHERE id = '1'
52 0.0008 0.00080990791320801
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.0006 0.00057601928710938
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.0003 0.00034093856811523
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0004 0.00039482116699219
SELECT id FROM categories WHERE parent_id = '30'
56 0.0010 0.0009911060333252
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
57 0.0004 0.00039792060852051
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0 
58 0.0003 0.00033688545227051
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.0005 0.00051999092102051
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0004 0.00042390823364258
SELECT * FROM categorygroups WHERE id = '1'
61 0.0011 0.0010581016540527
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.0003211498260498
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.0004 0.0004270076751709
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0003 0.00034594535827637
SELECT id FROM categories WHERE parent_id = '31'
65 0.0010 0.00097990036010742
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
66 0.0003 0.00034594535827637
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.00025391578674316
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
68 0.0003 0.00032901763916016
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0004 0.00043010711669922
SELECT * FROM categorygroups WHERE id = '1'
70 0.0003 0.00034308433532715
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
71 0.0004 0.00043201446533203
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
72 0.0005 0.00045895576477051
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.00027704238891602
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
74 0.0006 0.00058603286743164
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
75 0.0006 0.00055217742919922
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
76 0.0004 0.00044012069702148
SELECT * FROM ipgeocountries WHERE INET_ATON('3.238.180.255') >= INET_ATON(ip_start) AND INET_ATON('3.238.180.255') <= INET_ATON(ip_end)
77 0.0003 0.00026392936706543
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
78 0.0004 0.00038385391235352
SELECT * FROM countryredirects WHERE countrycode = 'US'
79 0.0006 0.0006401538848877
SELECT * FROM products WHERE pagename = 'la-route-des-comptoirs-roobos-tropical-lot-de-2-bio'
80 0.0007 0.00074005126953125
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1109
81 0.0006 0.00059890747070312
SELECT * FROM manufacturers WHERE id = '183'
82 0.0009 0.00092196464538574
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '183'
83 0.0005 0.00049114227294922
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '183' 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 = '183' ORDER BY RAND() LIMIT 1
85 0.0006 0.00055503845214844
SELECT * FROM productimages WHERE product_id = '1098' ORDER BY sortorder ASC
86 0.0006 0.0005648136138916
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '183'
87 0.0010 0.00098013877868652
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '183'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
88 0.0005 0.00051093101501465
SELECT * FROM manufacturerimages WHERE manufacturer_id = '183'
89 0.0007 0.0007169246673584
SELECT category_id FROM products_categories WHERE product_id = '1109'
90 0.0005 0.00049710273742676
SELECT * FROM categories WHERE id = '27'
91 0.0066 0.006615161895752
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
92 0.0004 0.00036096572875977
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
93 0.0004 0.00036001205444336
SELECT id FROM categories WHERE parent_id = '27'
94 0.0046 0.0046470165252686
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 
95 0.0003 0.00034809112548828
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
96 0.0004 0.00042605400085449
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
97 0.0004 0.00036311149597168
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
98 0.0005 0.00053691864013672
SELECT * FROM productimages WHERE product_id = '1109' ORDER BY sortorder ASC
99 0.0005 0.00054311752319336
SELECT * FROM product_image_select WHERE product_id = '1109'
100 0.0004 0.00043702125549316
SELECT * FROM productcustomimages WHERE product_id = '1109'
101 0.0006 0.0006101131439209
SELECT * FROM productfeeds WHERE product_id = '1109' ORDER BY item_date DESC
102 0.0023 0.0022640228271484
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '1109' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
103 0.0011 0.0010919570922852
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '1109' AND t.hidden = 0 AND display_product = 1
104 0.0006 0.00057387351989746
SELECT * FROM tags WHERE id = '198'
105 0.0011 0.0010581016540527
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '198'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
106 0.0011 0.0011129379272461
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '198'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
107 0.0010 0.001046895980835
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '198' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
108 0.0005 0.00046014785766602
SELECT * FROM productimages WHERE product_id = '2029' ORDER BY sortorder ASC
109 0.0006 0.00055193901062012
SELECT * FROM productamazoncontent WHERE product_id = '1109'
110 0.0015 0.0015189647674561
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1109' AND a.name = n.originalname
111 0.0008 0.0007789134979248
SELECT * FROM productoffers WHERE product_id = '1109' AND merchantid = 'A1X6FK5RDHNB96'
112 0.0006 0.00064992904663086
SELECT * FROM productoffers
                WHERE product_id = '1109' AND price > 0
                ORDER BY price ASC LIMIT 1
113 0.0006 0.00058507919311523
SELECT * FROM productoffers
                WHERE product_id = 1109
                ORDER BY price ASC LIMIT 1
114 0.0006 0.00055313110351562
SELECT value FROM productattributes
                WHERE product_id = '1109'
                AND name = 'ListPriceAmount'
115 0.0008 0.00077199935913086
SELECT value FROM productattributes WHERE product_id = '1109' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
116 0.0006 0.00055885314941406
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
117 0.0082 0.0081861019134521
SELECT *, MATCH (description, title) AGAINST ('comptoirs roobos tropical' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('comptoirs roobos tropical' IN BOOLEAN MODE) AND 1109 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
118 0.0007 0.00069594383239746
SELECT *, MATCH (description, title) AGAINST ('comptoirs roobos tropical' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('comptoirs roobos tropical' IN BOOLEAN MODE) AND 1109 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
119 0.0006 0.00060296058654785
SELECT *, MATCH (description, title) AGAINST ('comptoirs roobos tropical' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('comptoirs roobos tropical' IN BOOLEAN MODE) AND 1109 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
120 0.0004 0.00044584274291992
SELECT * FROM productimages WHERE product_id = '1093' ORDER BY sortorder ASC
121 0.0003 0.00031805038452148
SELECT * FROM product_image_select WHERE product_id = '1093'
122 0.0003 0.00025510787963867
SELECT * FROM productcustomimages WHERE product_id = '1093'
123 0.0015 0.0015079975128174
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1093' AND a.name = n.originalname
124 0.0007 0.00072002410888672
SELECT * FROM productoffers WHERE product_id = '1093' AND merchantid = 'A1X6FK5RDHNB96'
125 0.0007 0.00073909759521484
SELECT * FROM productoffers
                WHERE product_id = '1093' AND price > 0
                ORDER BY price ASC LIMIT 1
126 0.0006 0.00060820579528809
SELECT value FROM productattributes WHERE product_id = '1093' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
127 0.0005 0.00046801567077637
SELECT * FROM productimages WHERE product_id = '4905' ORDER BY sortorder ASC
128 0.0003 0.00033211708068848
SELECT * FROM product_image_select WHERE product_id = '4905'
129 0.0004 0.00038003921508789
SELECT * FROM productcustomimages WHERE product_id = '4905'
130 0.0011 0.0010781288146973
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4905' AND a.name = n.originalname
131 0.0006 0.00055384635925293
SELECT * FROM productoffers WHERE product_id = '4905' AND merchantid = 'A1X6FK5RDHNB96'
132 0.0006 0.00060486793518066
SELECT * FROM productoffers
                WHERE product_id = '4905' AND price > 0
                ORDER BY price ASC LIMIT 1
133 0.0005 0.0004880428314209
SELECT value FROM productattributes WHERE product_id = '4905' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
134 0.0002 0.00023913383483887
SELECT * FROM productimages WHERE product_id = '1278' ORDER BY sortorder ASC
135 0.0003 0.00032281875610352
SELECT * FROM product_image_select WHERE product_id = '1278'
136 0.0003 0.00034093856811523
SELECT * FROM productcustomimages WHERE product_id = '1278'
137 0.0015 0.0015029907226562
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1278' AND a.name = n.originalname
138 0.0004 0.00044012069702148
SELECT * FROM productoffers WHERE product_id = '1278' AND merchantid = 'A1X6FK5RDHNB96'
139 0.0005 0.00054478645324707
SELECT * FROM productoffers
                WHERE product_id = '1278' AND price > 0
                ORDER BY price ASC LIMIT 1
140 0.0006 0.0005791187286377
SELECT value FROM productattributes WHERE product_id = '1278' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
141 0.0006 0.00055193901062012
SELECT id,asin FROM products WHERE parent_id = 1109
142 0.0002 0.0002288818359375
SELECT category_id FROM products_categories WHERE product_id = '1109'
143 0.0003 0.00027179718017578
SELECT * FROM categories WHERE id = '27'
144 0.0004 0.00044417381286621
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
145 0.0002 0.00023007392883301
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
146 0.0003 0.00026702880859375
SELECT id FROM categories WHERE parent_id = '27'
147 0.0002 0.00024008750915527
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 
148 0.0002 0.00023198127746582
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 
149 0.0003 0.00025701522827148
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
150 0.0003 0.00025391578674316
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
151 0.0003 0.00025820732116699
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1109' AND a.name = n.originalname
152 0.0003 0.00031304359436035
SELECT * FROM productoffers WHERE product_id = '1109' AND merchantid = 'A1X6FK5RDHNB96'
153 0.0002 0.00024914741516113
SELECT * FROM productoffers
                WHERE product_id = '1109' AND price > 0
                ORDER BY price ASC LIMIT 1
154 0.0003 0.00025510787963867
SELECT * FROM productoffers
                WHERE product_id = 1109
                ORDER BY price ASC LIMIT 1
155 0.0002 0.00022292137145996
SELECT value FROM productattributes
                WHERE product_id = '1109'
                AND name = 'ListPriceAmount'
156 0.0005 0.00051116943359375
SELECT * FROM products WHERE id = '1109'
157 0.0004 0.00036191940307617
SELECT value FROM productattributes WHERE product_id = '1109' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
158 0.0002 0.00022387504577637
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1109' AND a.name = n.originalname
159 0.0003 0.00031208992004395
SELECT * FROM productoffers WHERE product_id = '1109' AND merchantid = 'A1X6FK5RDHNB96'
160 0.0003 0.00025010108947754
SELECT * FROM productoffers
                WHERE product_id = '1109' AND price > 0
                ORDER BY price ASC LIMIT 1
161 0.0003 0.00027894973754883
SELECT * FROM productoffers
                WHERE product_id = 1109
                ORDER BY price ASC LIMIT 1
162 0.0002 0.00024580955505371
SELECT value FROM productattributes
                WHERE product_id = '1109'
                AND name = 'ListPriceAmount'
163 0.0004 0.00041890144348145
SELECT category_id FROM products_categories WHERE product_id = '1109' AND prod_type = 'amz'
164 0.0003 0.00032305717468262
SELECT parent_id FROM categories WHERE id = '27'
165 0.0003 0.00026392936706543
SELECT * FROM categories WHERE id = '27'
166 0.0003 0.00032210350036621
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
167 0.0003 0.00034284591674805
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
168 0.0002 0.00022006034851074
SELECT id FROM categories WHERE parent_id = '27'
169 0.0002 0.00022196769714355
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 
170 0.0002 0.00023198127746582
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 
171 0.0002 0.00023412704467773
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
172 0.0003 0.00032305717468262
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
173 0.0005 0.00045490264892578
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
174 0.0004 0.00039911270141602
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
175 0.0005 0.00049519538879395
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
176 0.0004 0.00040507316589355
SELECT * FROM pages WHERE id = 38
177 0.0046 0.0045750141143799
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.0006 0.00059294700622559
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:1653089113;s:8:\"products\";a:6:{i:0;s:10:\"788|amazon\";i:1;s:10:\"787|amazon\";i:2;s:11:\"1287|amazon\";i:3;s:10:\"780|amazon\";i:4;s:10:\"777|amazon\";i:5;s:10:\"776|amazon\";}}' WHERE id = '160'
179 0.0007 0.00065994262695312
SELECT * FROM products WHERE id = 788
180 0.0006 0.00063014030456543
SELECT * FROM products WHERE id = 787
181 0.0007 0.00065994262695312
SELECT * FROM products WHERE id = 1287
182 0.0006 0.0006260871887207
SELECT * FROM products WHERE id = 780
183 0.0006 0.00063204765319824
SELECT * FROM products WHERE id = 777
184 0.0005 0.00054788589477539
SELECT * FROM products WHERE id = 776
185 0.0005 0.00049400329589844
SELECT * FROM products WHERE id = '788'
186 0.0003 0.00028586387634277
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
187 0.0004 0.00038003921508789
SELECT * FROM product_image_select WHERE product_id = '788'
188 0.0004 0.00037217140197754
SELECT * FROM productcustomimages WHERE product_id = '788'
189 0.0004 0.00043988227844238
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
190 0.0006 0.00059008598327637
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
191 0.0006 0.00064396858215332
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
192 0.0004 0.00039792060852051
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
193 0.0005 0.00053596496582031
SELECT * FROM products WHERE id = '787'
194 0.0003 0.0002739429473877
SELECT * FROM productimages WHERE product_id = '787' ORDER BY sortorder ASC
195 0.0002 0.00023484230041504
SELECT * FROM product_image_select WHERE product_id = '787'
196 0.0002 0.00023198127746582
SELECT * FROM productcustomimages WHERE product_id = '787'
197 0.0002 0.00023293495178223
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '787' AND a.name = n.originalname
198 0.0004 0.0004119873046875
SELECT * FROM productoffers WHERE product_id = '787' AND merchantid = 'A1X6FK5RDHNB96'
199 0.0006 0.0005800724029541
SELECT * FROM productoffers
                WHERE product_id = '787' AND price > 0
                ORDER BY price ASC LIMIT 1
200 0.0005 0.00046205520629883
SELECT value FROM productattributes WHERE product_id = '787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
201 0.0007 0.00067901611328125
SELECT * FROM products WHERE id = '1287'
202 0.0004 0.00042486190795898
SELECT * FROM productimages WHERE product_id = '1287' ORDER BY sortorder ASC
203 0.0003 0.00032615661621094
SELECT * FROM product_image_select WHERE product_id = '1287'
204 0.0002 0.00024008750915527
SELECT * FROM productcustomimages WHERE product_id = '1287'
205 0.0004 0.00039815902709961
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1287' AND a.name = n.originalname
206 0.0004 0.00043392181396484
SELECT * FROM productoffers WHERE product_id = '1287' AND merchantid = 'A1X6FK5RDHNB96'
207 0.0006 0.00058794021606445
SELECT * FROM productoffers
                WHERE product_id = '1287' AND price > 0
                ORDER BY price ASC LIMIT 1
208 0.0003 0.00029492378234863
SELECT value FROM productattributes WHERE product_id = '1287' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
209 0.0005 0.00050687789916992
SELECT * FROM products WHERE id = '780'
210 0.0004 0.00041508674621582
SELECT * FROM productimages WHERE product_id = '780' ORDER BY sortorder ASC
211 0.0004 0.00040912628173828
SELECT * FROM product_image_select WHERE product_id = '780'
212 0.0004 0.00041389465332031
SELECT * FROM productcustomimages WHERE product_id = '780'
213 0.0003 0.00030708312988281
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '780' AND a.name = n.originalname
214 0.0007 0.00069618225097656
SELECT * FROM productoffers WHERE product_id = '780' AND merchantid = 'A1X6FK5RDHNB96'
215 0.0007 0.00072693824768066
SELECT * FROM productoffers
                WHERE product_id = '780' AND price > 0
                ORDER BY price ASC LIMIT 1
216 0.0004 0.0003969669342041
SELECT value FROM productattributes WHERE product_id = '780' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
217 0.0007 0.00066184997558594
SELECT * FROM products WHERE id = '777'
218 0.0004 0.00040388107299805
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
219 0.0003 0.00027799606323242
SELECT * FROM product_image_select WHERE product_id = '777'
220 0.0003 0.00028300285339355
SELECT * FROM productcustomimages WHERE product_id = '777'
221 0.0004 0.00040507316589355
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
222 0.0005 0.00054383277893066
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
223 0.0006 0.0005638599395752
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
224 0.0003 0.00031208992004395
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
225 0.0006 0.0006110668182373
SELECT * FROM products WHERE id = '776'
226 0.0004 0.00041389465332031
SELECT * FROM productimages WHERE product_id = '776' ORDER BY sortorder ASC
227 0.0004 0.00042486190795898
SELECT * FROM product_image_select WHERE product_id = '776'
228 0.0003 0.0002899169921875
SELECT * FROM productcustomimages WHERE product_id = '776'
229 0.0005 0.00051307678222656
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '776' AND a.name = n.originalname
230 0.0006 0.0006101131439209
SELECT * FROM productoffers WHERE product_id = '776' AND merchantid = 'A1X6FK5RDHNB96'
231 0.0008 0.00077486038208008
SELECT * FROM productoffers
                WHERE product_id = '776' AND price > 0
                ORDER BY price ASC LIMIT 1
232 0.0004 0.00040411949157715
SELECT value FROM productattributes WHERE product_id = '776' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
233 0.0005 0.00046801567077637
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
234 0.0004 0.00039410591125488
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
235 0.0007 0.00068116188049316
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
236 0.0004 0.0003960132598877
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
237 0.0004 0.00044798851013184
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
238 0.0005 0.00047898292541504
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
239 0.0004 0.00043416023254395
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
240 0.0006 0.00057697296142578
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'