Portal Cool Graines rares/Plantes * Rooibos - Aspalathus Linearis * théiers * 3 graines fraîches

Portal Cool Graines rares/Plantes * Rooibos - Aspalathus Linearis * théiers * 3 graines fraîches
Portal Cool Graines rares/Plantes * Rooibos - Aspalathus Linearis * théiers * 3 graines fraîches Portal Cool Graines rares/Plantes * Rooibos - Aspalathus Linearis * théiers * 3 graines fraîches (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-01-10 22:13:07 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.
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.92650294303894 235 0.1354 0


No Amazon API Requests Made.

Total time 0.92650294303894 seconds

Number Time From Start Name Description
1 0.68668580055237 Initialise Initialise FSB Function
2 0.6889979839325 App Controller Start Start of the App controller (called before the controller of every page)
3 0.69180989265442 Start of getCategoryListByGroup Function Before first category groups query
4 0.69209289550781 After initial query Before first category groups query
5 0.69209480285645 Get Category List for Group Before the call to getCategoryList function
6 0.69209790229797 Start of GetCategoryList function Start of the function
7 0.6921010017395 Before getting categories Query to get specific category list
8 0.69253301620483 After getting categories Query to get specific category list
9 0.69253492355347 Before getting category custom Before call to function getCategoryCustom
10 0.70893287658691 After getting category custom After call to function getCategoryCustom
11 0.70893597602844 Before getting category custom Before call to function getCategoryCustom
12 0.71968984603882 After getting category custom After call to function getCategoryCustom
13 0.71969199180603 Before getting category custom Before call to function getCategoryCustom
14 0.72478079795837 After getting category custom After call to function getCategoryCustom
15 0.7247838973999 Before getting category custom Before call to function getCategoryCustom
16 0.72791194915771 After getting category custom After call to function getCategoryCustom
17 0.72791385650635 Before getting category custom Before call to function getCategoryCustom
18 0.73083901405334 After getting category custom After call to function getCategoryCustom
19 0.73084092140198 Before getting category custom Before call to function getCategoryCustom
20 0.73354291915894 After getting category custom After call to function getCategoryCustom
21 0.73354482650757 End of GetCategoryList function End of the function
22 0.73355102539062 End of getCategoryListByGroup Function Before return()
23 0.74475193023682 App Controller End End of the App controller (called before the controller of every page)
24 0.7453498840332 Product Start Start of the product info controller
25 0.77718281745911 Cache file not found Starting get product details
26 0.80081582069397 Related products Start getting related products if enabled
27 0.80081701278687 Related Products Start Before the related products are found
28 0.8008189201355 Related Products Keywords Before the related product keywords are found
29 0.80082297325134 Create Keyword List Function Start of function
30 0.80086088180542 Create Keyword List Function After looping provided content - 29 keywords found
31 0.8020339012146 Create Keyword List Function After looping initial keyword list - 28 keywords remaining
32 0.80204081535339 Create Keyword List Function After reducing keyword list
33 0.80213785171509 Create Keyword List Function After selecting by scoring keywords
34 0.80214190483093 Create Keyword List Function After final loop of keywords
35 0.80214381217957 Related Products Keywords After the related product keywords are found
36 0.82137680053711 Related Products End After the related products are found
37 0.82965397834778 Product End End of the product info controller (Product Info)
38 0.8305389881134 App_after Controller Start Start of the App_after controller (called after the controller of every page)
39 0.83112192153931 Before Get Options Before the call to getOptions in the tpl class
40 0.86251902580261 After Get Options After the call to getOptions in the tpl class
41 0.86259984970093 App_after Controller End End of the App_after controller (called after the controller of every page)
42 0.86262798309326 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
43 0.89946699142456 Product Info: After Smarty Fetch After the product.tpl template is fetched
44 0.89947199821472 Product Info: Before Template Display Before the template is displayed
45 0.92647695541382 Product Info: After Template Display After the template is displayed
46 0.92648887634277 Finalizing debug Before the debug is output to the page.
47 0.92650198936462 End of App This is the end of the app logging, final timestamp


Query Debug - 235 Database Queries. Total time 0.1354 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0007 0.00066494941711426
SELECT parameter, value FROM parameters
2 0.0009 0.00085306167602539
SELECT * FROM `bad_bots`
3 0.0003 0.00028204917907715
SET time_zone = 'Europe/London'
4 0.0004 0.00035595893859863
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0021 0.0021262168884277
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:12:\"54.161.2.204\";}'
6 0.0014 0.0014200210571289
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1642588495'
7 0.0005 0.00048708915710449
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0003 0.00032687187194824
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0006 0.00057578086853027
SELECT id FROM pages WHERE pagename = 'portal-cool-graines-raresplantes-rooibos-aspalathus-linearis-thiers-3' LIMIT 1
10 0.0007 0.0007328987121582
SELECT id FROM products WHERE pagename = 'portal-cool-graines-raresplantes-rooibos-aspalathus-linearis-thiers-3' AND hidden = 0 LIMIT 1
11 0.0011 0.0011389255523682
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
12 0.0007 0.00068902969360352
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
13 0.0006 0.00058221817016602
SELECT * FROM pages WHERE pagename = 'portal-cool-graines-raresplantes-rooibos-aspalathus-linearis-thiers-3'
14 0.0003 0.00027108192443848
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0004 0.00041294097900391
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0080 0.0080289840698242
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
17 0.0003 0.00025701522827148
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.00022697448730469
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0002 0.00022006034851074
SELECT id FROM categories WHERE parent_id = '26'
20 0.0066 0.0065848827362061
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
21 0.0003 0.00025081634521484
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.00020289421081543
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.00027799606323242
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0002 0.00021696090698242
SELECT * FROM categorygroups WHERE id = '1'
25 0.0042 0.0042431354522705
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.0004 0.00044703483581543
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.00027608871459961
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0004 0.00039196014404297
SELECT id FROM categories WHERE parent_id = '27'
29 0.0043 0.004345178604126
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.00025796890258789
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.00022006034851074
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.00021004676818848
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0003 0.00025105476379395
SELECT * FROM categorygroups WHERE id = '1'
34 0.0017 0.0016629695892334
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.0002291202545166
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
36 0.0002 0.00020790100097656
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0002 0.00021600723266602
SELECT id FROM categories WHERE parent_id = '28'
38 0.0017 0.001666784286499
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.00036787986755371
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.00021910667419434
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.00020003318786621
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0002 0.0002140998840332
SELECT * FROM categorygroups WHERE id = '1'
43 0.0007 0.00065898895263672
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
44 0.0002 0.00022220611572266
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.00021505355834961
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0004 0.00040411949157715
SELECT id FROM categories WHERE parent_id = '29'
47 0.0006 0.0006110668182373
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.00021100044250488
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.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 (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
50 0.0002 0.00024294853210449
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0002 0.00021219253540039
SELECT * FROM categorygroups WHERE id = '1'
52 0.0006 0.00057601928710938
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
53 0.0003 0.00025582313537598
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.00025701522827148
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0002 0.00023603439331055
SELECT id FROM categories WHERE parent_id = '30'
56 0.0005 0.00052809715270996
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.0003 0.00027203559875488
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.00023388862609863
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.0002739429473877
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0002 0.00020599365234375
SELECT * FROM categorygroups WHERE id = '1'
61 0.0005 0.0005340576171875
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
62 0.0002 0.00021100044250488
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.0001978874206543
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0002 0.00020217895507812
SELECT id FROM categories WHERE parent_id = '31'
65 0.0006 0.00060391426086426
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
66 0.0002 0.00022315979003906
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
67 0.0002 0.00021791458129883
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.0001988410949707
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0002 0.00021219253540039
SELECT * FROM categorygroups WHERE id = '1'
70 0.0002 0.00022411346435547
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
71 0.0002 0.0002448558807373
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
72 0.0003 0.00028085708618164
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.0004 0.00036501884460449
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
74 0.0007 0.00071001052856445
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
75 0.0004 0.00041699409484863
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
76 0.0003 0.00028705596923828
SELECT * FROM ipgeocountries WHERE INET_ATON('54.161.2.204') >= INET_ATON(ip_start) AND INET_ATON('54.161.2.204') <= INET_ATON(ip_end)
77 0.0003 0.00028896331787109
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
78 0.0004 0.00035691261291504
SELECT * FROM countryredirects WHERE countrycode = 'US'
79 0.0006 0.00061511993408203
SELECT * FROM products WHERE pagename = 'portal-cool-graines-raresplantes-rooibos-aspalathus-linearis-thiers-3'
80 0.0006 0.0005500316619873
UPDATE products SET viewcount = viewcount + 1 WHERE id = 3171
81 0.0005 0.0005490779876709
SELECT * FROM manufacturers WHERE id = '578'
82 0.0007 0.00069594383239746
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '578'
83 0.0004 0.00043797492980957
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '578' LIMIT 1
84 0.0010 0.0010340213775635
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '578' ORDER BY RAND() LIMIT 1
85 0.0016 0.0015690326690674
SELECT * FROM productimages WHERE product_id = '3171' ORDER BY sortorder ASC
86 0.0002 0.00023317337036133
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '578'
87 0.0006 0.00063610076904297
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '578'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
88 0.0008 0.00075006484985352
SELECT * FROM manufacturerimages WHERE manufacturer_id = '578'
89 0.0005 0.00053095817565918
SELECT category_id FROM products_categories WHERE product_id = '3171'
90 0.0003 0.00030803680419922
SELECT * FROM categories WHERE id = '27'
91 0.0050 0.0050158500671387
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.0003 0.00027012825012207
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
93 0.0002 0.00022411346435547
SELECT id FROM categories WHERE parent_id = '27'
94 0.0042 0.0041670799255371
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.0002 0.00022315979003906
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.0002 0.00022101402282715
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.0002 0.00023603439331055
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
98 0.0002 0.00024509429931641
SELECT * FROM productimages WHERE product_id = '3171' ORDER BY sortorder ASC
99 0.0005 0.00046706199645996
SELECT * FROM product_image_select WHERE product_id = '3171'
100 0.0004 0.0004279613494873
SELECT * FROM productcustomimages WHERE product_id = '3171'
101 0.0003 0.00032520294189453
SELECT * FROM productfeeds WHERE product_id = '3171' ORDER BY item_date DESC
102 0.0005 0.00047516822814941
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '3171' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
103 0.0005 0.00048303604125977
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '3171' AND t.hidden = 0 AND display_product = 1
104 0.0004 0.00041007995605469
SELECT * FROM productamazoncontent WHERE product_id = '3171'
105 0.0008 0.0007779598236084
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3171' AND a.name = n.originalname
106 0.0004 0.0003960132598877
SELECT * FROM productoffers WHERE product_id = '3171' AND merchantid = 'A1X6FK5RDHNB96'
107 0.0004 0.00038814544677734
SELECT * FROM productoffers
                WHERE product_id = '3171' AND price > 0
                ORDER BY price ASC LIMIT 1
108 0.0004 0.00035309791564941
SELECT * FROM productoffers
                WHERE product_id = 3171
                ORDER BY price ASC LIMIT 1
109 0.0004 0.00036287307739258
SELECT value FROM productattributes
                WHERE product_id = '3171'
                AND name = 'ListPriceAmount'
110 0.0004 0.0004429817199707
SELECT value FROM productattributes WHERE product_id = '3171' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
111 0.0002 0.00023293495178223
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.0080 0.0080108642578125
SELECT *, MATCH (description, title) AGAINST ('raresplantes rooibos aspalathus' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('raresplantes rooibos aspalathus' IN BOOLEAN MODE) AND 3171 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
113 0.0006 0.00058603286743164
SELECT *, MATCH (description, title) AGAINST ('raresplantes rooibos aspalathus' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('raresplantes rooibos aspalathus' IN BOOLEAN MODE) AND 3171 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
114 0.0005 0.00051307678222656
SELECT *, MATCH (description, title) AGAINST ('raresplantes rooibos aspalathus' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('raresplantes rooibos aspalathus' IN BOOLEAN MODE) AND 3171 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
115 0.0003 0.00027298927307129
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
116 0.0003 0.0002739429473877
SELECT * FROM product_image_select WHERE product_id = '878'
117 0.0002 0.00022697448730469
SELECT * FROM productcustomimages WHERE product_id = '878'
118 0.0010 0.0009610652923584
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
119 0.0006 0.00056314468383789
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
120 0.0006 0.00056099891662598
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
121 0.0005 0.00052213668823242
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
122 0.0003 0.00031805038452148
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
123 0.0003 0.00034093856811523
SELECT * FROM product_image_select WHERE product_id = '862'
124 0.0003 0.00028491020202637
SELECT * FROM productcustomimages WHERE product_id = '862'
125 0.0004 0.00038981437683105
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
126 0.0004 0.00038909912109375
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
127 0.0003 0.00032210350036621
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
128 0.0002 0.00024580955505371
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
129 0.0003 0.00032901763916016
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
130 0.0004 0.00041007995605469
SELECT * FROM product_image_select WHERE product_id = '858'
131 0.0003 0.00027203559875488
SELECT * FROM productcustomimages WHERE product_id = '858'
132 0.0011 0.0011141300201416
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
133 0.0004 0.00041913986206055
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
134 0.0006 0.00057506561279297
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
135 0.0006 0.00060105323791504
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
136 0.0004 0.00044894218444824
SELECT id,asin FROM products WHERE parent_id = 3171
137 0.0003 0.00025796890258789
SELECT category_id FROM products_categories WHERE product_id = '3171'
138 0.0003 0.00028586387634277
SELECT * FROM categories WHERE id = '27'
139 0.0003 0.00025010108947754
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
140 0.0002 0.00021600723266602
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
141 0.0002 0.00021100044250488
SELECT id FROM categories WHERE parent_id = '27'
142 0.0002 0.00024318695068359
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 
143 0.0003 0.0002591609954834
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 
144 0.0002 0.0002129077911377
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
145 0.0002 0.00021100044250488
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
146 0.0003 0.00025200843811035
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3171' AND a.name = n.originalname
147 0.0003 0.00025701522827148
SELECT * FROM productoffers WHERE product_id = '3171' AND merchantid = 'A1X6FK5RDHNB96'
148 0.0002 0.00024104118347168
SELECT * FROM productoffers
                WHERE product_id = '3171' AND price > 0
                ORDER BY price ASC LIMIT 1
149 0.0003 0.00025606155395508
SELECT * FROM productoffers
                WHERE product_id = 3171
                ORDER BY price ASC LIMIT 1
150 0.0002 0.00020098686218262
SELECT value FROM productattributes
                WHERE product_id = '3171'
                AND name = 'ListPriceAmount'
151 0.0004 0.00041985511779785
SELECT * FROM products WHERE id = '3171'
152 0.0002 0.00020790100097656
SELECT value FROM productattributes WHERE product_id = '3171' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
153 0.0002 0.00021100044250488
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3171' AND a.name = n.originalname
154 0.0002 0.00021910667419434
SELECT * FROM productoffers WHERE product_id = '3171' AND merchantid = 'A1X6FK5RDHNB96'
155 0.0002 0.00023412704467773
SELECT * FROM productoffers
                WHERE product_id = '3171' AND price > 0
                ORDER BY price ASC LIMIT 1
156 0.0002 0.0002439022064209
SELECT * FROM productoffers
                WHERE product_id = 3171
                ORDER BY price ASC LIMIT 1
157 0.0003 0.00026392936706543
SELECT value FROM productattributes
                WHERE product_id = '3171'
                AND name = 'ListPriceAmount'
158 0.0003 0.00033307075500488
SELECT category_id FROM products_categories WHERE product_id = '3171' AND prod_type = 'amz'
159 0.0002 0.0002129077911377
SELECT parent_id FROM categories WHERE id = '27'
160 0.0002 0.00024008750915527
SELECT * FROM categories WHERE id = '27'
161 0.0002 0.00023102760314941
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
162 0.0002 0.00020503997802734
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
163 0.0002 0.00023603439331055
SELECT id FROM categories WHERE parent_id = '27'
164 0.0002 0.00021791458129883
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 
165 0.0002 0.00020289421081543
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 
166 0.0002 0.00020885467529297
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
167 0.0002 0.00022506713867188
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
168 0.0003 0.00029683113098145
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
169 0.0003 0.00025010108947754
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
170 0.0003 0.00026893615722656
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
171 0.0043 0.0043118000030518
SELECT * FROM pages WHERE id = 38
172 0.0050 0.0050048828125
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.0005 0.00046992301940918
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:1642588496;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:\"780|amazon\";i:5;s:10:\"779|amazon\";}}' WHERE id = '160'
174 0.0005 0.00052309036254883
SELECT * FROM products WHERE id = 790
175 0.0006 0.0006251335144043
SELECT * FROM products WHERE id = 788
176 0.0005 0.00050592422485352
SELECT * FROM products WHERE id = 787
177 0.0005 0.0004880428314209
SELECT * FROM products WHERE id = 1287
178 0.0007 0.00066184997558594
SELECT * FROM products WHERE id = 780
179 0.0005 0.00046396255493164
SELECT * FROM products WHERE id = 779
180 0.0006 0.00058698654174805
SELECT * FROM products WHERE id = '790'
181 0.0004 0.00035309791564941
SELECT * FROM productimages WHERE product_id = '790' ORDER BY sortorder ASC
182 0.0003 0.00026488304138184
SELECT * FROM product_image_select WHERE product_id = '790'
183 0.0002 0.00022602081298828
SELECT * FROM productcustomimages WHERE product_id = '790'
184 0.0002 0.00023388862609863
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.00024104118347168
SELECT * FROM productoffers WHERE product_id = '790' AND merchantid = 'A1X6FK5RDHNB96'
186 0.0003 0.00025391578674316
SELECT * FROM productoffers
                WHERE product_id = '790' AND price > 0
                ORDER BY price ASC LIMIT 1
187 0.0002 0.00019598007202148
SELECT value FROM productattributes WHERE product_id = '790' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
188 0.0004 0.00040102005004883
SELECT * FROM products WHERE id = '788'
189 0.0002 0.00024604797363281
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
190 0.0002 0.00022315979003906
SELECT * FROM product_image_select WHERE product_id = '788'
191 0.0003 0.00028204917907715
SELECT * FROM productcustomimages WHERE product_id = '788'
192 0.0003 0.00026798248291016
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
193 0.0002 0.00022506713867188
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
194 0.0002 0.0002448558807373
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
195 0.0002 0.00020408630371094
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
196 0.0004 0.00041985511779785
SELECT * FROM products WHERE id = '787'
197 0.0002 0.00022196769714355
SELECT * FROM productimages WHERE product_id = '787' ORDER BY sortorder ASC
198 0.0002 0.00021505355834961
SELECT * FROM product_image_select WHERE product_id = '787'
199 0.0002 0.00020694732666016
SELECT * FROM productcustomimages WHERE product_id = '787'
200 0.0003 0.00031399726867676
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.00026416778564453
SELECT * FROM productoffers WHERE product_id = '787' AND merchantid = 'A1X6FK5RDHNB96'
202 0.0003 0.00025105476379395
SELECT * FROM productoffers
                WHERE product_id = '787' AND price > 0
                ORDER BY price ASC LIMIT 1
203 0.0002 0.00020289421081543
SELECT value FROM productattributes WHERE product_id = '787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
204 0.0004 0.00043892860412598
SELECT * FROM products WHERE id = '1287'
205 0.0003 0.00030899047851562
SELECT * FROM productimages WHERE product_id = '1287' ORDER BY sortorder ASC
206 0.0002 0.00024104118347168
SELECT * FROM product_image_select WHERE product_id = '1287'
207 0.0002 0.00023412704467773
SELECT * FROM productcustomimages WHERE product_id = '1287'
208 0.0003 0.00028896331787109
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1287' AND a.name = n.originalname
209 0.0002 0.00023388862609863
SELECT * FROM productoffers WHERE product_id = '1287' AND merchantid = 'A1X6FK5RDHNB96'
210 0.0002 0.00024604797363281
SELECT * FROM productoffers
                WHERE product_id = '1287' AND price > 0
                ORDER BY price ASC LIMIT 1
211 0.0002 0.00021600723266602
SELECT value FROM productattributes WHERE product_id = '1287' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
212 0.0004 0.00044703483581543
SELECT * FROM products WHERE id = '780'
213 0.0003 0.00026583671569824
SELECT * FROM productimages WHERE product_id = '780' ORDER BY sortorder ASC
214 0.0002 0.00022602081298828
SELECT * FROM product_image_select WHERE product_id = '780'
215 0.0002 0.00023722648620605
SELECT * FROM productcustomimages WHERE product_id = '780'
216 0.0006 0.0005948543548584
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '780' AND a.name = n.originalname
217 0.0003 0.00029397010803223
SELECT * FROM productoffers WHERE product_id = '780' AND merchantid = 'A1X6FK5RDHNB96'
218 0.0003 0.0002591609954834
SELECT * FROM productoffers
                WHERE product_id = '780' AND price > 0
                ORDER BY price ASC LIMIT 1
219 0.0002 0.00022196769714355
SELECT value FROM productattributes WHERE product_id = '780' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
220 0.0005 0.00054502487182617
SELECT * FROM products WHERE id = '779'
221 0.0003 0.00030303001403809
SELECT * FROM productimages WHERE product_id = '779' ORDER BY sortorder ASC
222 0.0002 0.00022697448730469
SELECT * FROM product_image_select WHERE product_id = '779'
223 0.0003 0.00026893615722656
SELECT * FROM productcustomimages WHERE product_id = '779'
224 0.0002 0.00024199485778809
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '779' AND a.name = n.originalname
225 0.0003 0.00026702880859375
SELECT * FROM productoffers WHERE product_id = '779' AND merchantid = 'A1X6FK5RDHNB96'
226 0.0002 0.00023102760314941
SELECT * FROM productoffers
                WHERE product_id = '779' AND price > 0
                ORDER BY price ASC LIMIT 1
227 0.0002 0.0001978874206543
SELECT value FROM productattributes WHERE product_id = '779' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
228 0.0003 0.00028300285339355
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
229 0.0004 0.00037097930908203
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
230 0.0006 0.0005800724029541
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
231 0.0004 0.00039386749267578
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
232 0.0004 0.00035500526428223
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
233 0.0004 0.00041389465332031
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
234 0.0003 0.00030899047851562
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
235 0.0003 0.00026392936706543
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'