Rooibos Earl Grey Tea

Rooibos Earl Grey Tea
Rooibos Earl Grey Tea Rooibos Earl Grey Tea Rooibos Earl Grey Tea Rooibos Earl Grey Tea Rooibos Earl Grey Tea (cliquez sur les images pour élargir)
€6,59
Le prix et la disponibilité du produit sont corrects en date du 2022-05-13 14:04:11 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.87207794189453 239 0.1765 0


No Amazon API Requests Made.

Total time 0.87207794189453 seconds

Number Time From Start Name Description
1 0.65385103225708 Initialise Initialise FSB Function
2 0.65678286552429 App Controller Start Start of the App controller (called before the controller of every page)
3 0.66061806678772 Start of getCategoryListByGroup Function Before first category groups query
4 0.66159391403198 After initial query Before first category groups query
5 0.66159605979919 Get Category List for Group Before the call to getCategoryList function
6 0.66159892082214 Start of GetCategoryList function Start of the function
7 0.66160202026367 Before getting categories Query to get specific category list
8 0.66228604316711 After getting categories Query to get specific category list
9 0.66228795051575 Before getting category custom Before call to function getCategoryCustom
10 0.68044805526733 After getting category custom After call to function getCategoryCustom
11 0.68045091629028 Before getting category custom Before call to function getCategoryCustom
12 0.69269704818726 After getting category custom After call to function getCategoryCustom
13 0.69269895553589 Before getting category custom Before call to function getCategoryCustom
14 0.69804406166077 After getting category custom After call to function getCategoryCustom
15 0.6980459690094 Before getting category custom Before call to function getCategoryCustom
16 0.70122098922729 After getting category custom After call to function getCategoryCustom
17 0.70122385025024 Before getting category custom Before call to function getCategoryCustom
18 0.70589399337769 After getting category custom After call to function getCategoryCustom
19 0.70589590072632 Before getting category custom Before call to function getCategoryCustom
20 0.70944499969482 After getting category custom After call to function getCategoryCustom
21 0.70944786071777 End of GetCategoryList function End of the function
22 0.70945405960083 End of getCategoryListByGroup Function Before return()
23 0.71542096138 App Controller End End of the App controller (called before the controller of every page)
24 0.71570992469788 Product Start Start of the product info controller
25 0.71885395050049 Cache file not found Starting get product details
26 0.75715494155884 Related products Start getting related products if enabled
27 0.75715684890747 Related Products Start Before the related products are found
28 0.75715804100037 Related Products Keywords Before the related product keywords are found
29 0.75716185569763 Create Keyword List Function Start of function
30 0.75718307495117 Create Keyword List Function After looping provided content - 9 keywords found
31 0.75754904747009 Create Keyword List Function After looping initial keyword list - 8 keywords remaining
32 0.75755405426025 Create Keyword List Function After reducing keyword list
33 0.75756502151489 Create Keyword List Function After selecting by scoring keywords
34 0.75756788253784 Create Keyword List Function After final loop of keywords
35 0.75757002830505 Related Products Keywords After the related product keywords are found
36 0.77561497688293 Related Products End After the related products are found
37 0.78638195991516 Product End End of the product info controller (Product Info)
38 0.78732991218567 App_after Controller Start Start of the App_after controller (called after the controller of every page)
39 0.78830599784851 Before Get Options Before the call to getOptions in the tpl class
40 0.83839702606201 After Get Options After the call to getOptions in the tpl class
41 0.83850193023682 App_after Controller End End of the App_after controller (called after the controller of every page)
42 0.83853101730347 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
43 0.85112595558167 Product Info: After Smarty Fetch After the product.tpl template is fetched
44 0.85113286972046 Product Info: Before Template Display Before the template is displayed
45 0.87205791473389 Product Info: After Template Display After the template is displayed
46 0.87206387519836 Finalizing debug Before the debug is output to the page.
47 0.87207698822021 End of App This is the end of the app logging, final timestamp


Query Debug - 239 Database Queries. Total time 0.1765 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0006 0.00060701370239258
SELECT parameter, value FROM parameters
2 0.0012 0.001194953918457
SELECT * FROM `bad_bots`
3 0.0005 0.00047707557678223
SET time_zone = 'Europe/London'
4 0.0006 0.00057792663574219
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0024 0.0023598670959473
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"3.238.180.255\";}'
6 0.0015 0.0014550685882568
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1653090049'
7 0.0007 0.00066709518432617
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0004 0.00039005279541016
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0010 0.0010290145874023
SELECT id FROM pages WHERE pagename = 'rooibos-earl-grey-tea' LIMIT 1
10 0.0010 0.0010271072387695
SELECT id FROM products WHERE pagename = 'rooibos-earl-grey-tea' AND hidden = 0 LIMIT 1
11 0.0016 0.0016489028930664
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
12 0.0010 0.00099396705627441
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
13 0.0007 0.00074291229248047
SELECT * FROM pages WHERE pagename = 'rooibos-earl-grey-tea'
14 0.0010 0.0009608268737793
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0007 0.00066018104553223
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0081 0.008098840713501
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.00033092498779297
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.0003 0.00032591819763184
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0003 0.00025200843811035
SELECT id FROM categories WHERE parent_id = '26'
20 0.0070 0.0069670677185059
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.0005 0.00050902366638184
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.0005 0.00051617622375488
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.0005 0.00048398971557617
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0005 0.00050997734069824
SELECT * FROM categorygroups WHERE id = '1'
25 0.0048 0.0048339366912842
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.0004279613494873
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.0005 0.00047588348388672
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0005 0.0004570484161377
SELECT id FROM categories WHERE parent_id = '27'
29 0.0048 0.0048019886016846
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.0004 0.0003669261932373
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.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
32 0.0003 0.00025606155395508
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0002 0.00024700164794922
SELECT * FROM categorygroups WHERE id = '1'
34 0.0017 0.0016682147979736
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
35 0.0003 0.00025320053100586
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.0003 0.00025081634521484
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0002 0.00023913383483887
SELECT id FROM categories WHERE parent_id = '28'
38 0.0017 0.0017290115356445
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.00038003921508789
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.00024199485778809
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.00023508071899414
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0002 0.00024294853210449
SELECT * FROM categorygroups WHERE id = '1'
43 0.0006 0.0005958080291748
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.00024914741516113
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.0003 0.00026583671569824
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0002 0.00023508071899414
SELECT id FROM categories WHERE parent_id = '29'
47 0.0006 0.00060105323791504
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.0003 0.00026702880859375
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.00026702880859375
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
50 0.0003 0.00027704238891602
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0003 0.00031208992004395
SELECT * FROM categorygroups WHERE id = '1'
52 0.0008 0.00076103210449219
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.0004 0.00040912628173828
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.0004 0.00042200088500977
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0004 0.00042414665222168
SELECT id FROM categories WHERE parent_id = '30'
56 0.0008 0.00076889991760254
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.0004270076751709
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.0004 0.00039196014404297
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.00047421455383301
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0005 0.00046396255493164
SELECT * FROM categorygroups WHERE id = '1'
61 0.0008 0.00078797340393066
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.00026488304138184
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.0002439022064209
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0002 0.00023794174194336
SELECT id FROM categories WHERE parent_id = '31'
65 0.0007 0.0007169246673584
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.00028204917907715
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.0003058910369873
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.00030899047851562
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0003 0.00027799606323242
SELECT * FROM categorygroups WHERE id = '1'
70 0.0003 0.00031113624572754
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
71 0.0003 0.00034594535827637
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
72 0.0004 0.00040984153747559
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.00042295455932617
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
74 0.0007 0.00065207481384277
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
75 0.0006 0.00060296058654785
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
76 0.0004 0.00035381317138672
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.0004 0.00044012069702148
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
78 0.0005 0.00047087669372559
SELECT * FROM countryredirects WHERE countrycode = 'US'
79 0.0007 0.00069999694824219
SELECT * FROM products WHERE pagename = 'rooibos-earl-grey-tea'
80 0.0015 0.0015411376953125
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1115
81 0.0008 0.00083804130554199
SELECT * FROM manufacturers WHERE id = '291'
82 0.0007 0.00069189071655273
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '291'
83 0.0007 0.0006871223449707
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '291' LIMIT 1
84 0.0011 0.0011298656463623
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '291' ORDER BY RAND() LIMIT 1
85 0.0006 0.00063920021057129
SELECT * FROM productimages WHERE product_id = '1115' ORDER BY sortorder ASC
86 0.0004 0.00042295455932617
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '291'
87 0.0009 0.00087213516235352
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '291'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
88 0.0006 0.00061392784118652
SELECT * FROM manufacturerimages WHERE manufacturer_id = '291'
89 0.0006 0.00056982040405273
SELECT category_id FROM products_categories WHERE product_id = '1115'
90 0.0005 0.00049114227294922
SELECT * FROM categories WHERE id = '27'
91 0.0054 0.0054349899291992
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.0005 0.0005040168762207
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
93 0.0005 0.00052809715270996
SELECT id FROM categories WHERE parent_id = '27'
94 0.0047 0.0046849250793457
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.0006 0.0005958080291748
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.00039410591125488
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.00043892860412598
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
98 0.0003 0.00028610229492188
SELECT * FROM productimages WHERE product_id = '1115' ORDER BY sortorder ASC
99 0.0004 0.00044608116149902
SELECT * FROM product_image_select WHERE product_id = '1115'
100 0.0004 0.0004279613494873
SELECT * FROM productcustomimages WHERE product_id = '1115'
101 0.0006 0.00064301490783691
SELECT * FROM productfeeds WHERE product_id = '1115' ORDER BY item_date DESC
102 0.0008 0.00076794624328613
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '1115' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
103 0.0009 0.00091195106506348
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '1115' AND t.hidden = 0 AND display_product = 1
104 0.0003 0.00028800964355469
SELECT * FROM tags WHERE id = '198'
105 0.0009 0.00094318389892578
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.0008 0.00083208084106445
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.0009 0.00088310241699219
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.0003 0.00032901763916016
SELECT * FROM productimages WHERE product_id = '2029' ORDER BY sortorder ASC
109 0.0004 0.00038814544677734
SELECT * FROM tags WHERE id = '62'
110 0.0020 0.0019831657409668
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '62'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
111 0.0019 0.001884937286377
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '62'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
112 0.0020 0.001986026763916
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '62' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
113 0.0003 0.00031399726867676
SELECT * FROM productimages WHERE product_id = '1215' ORDER BY sortorder ASC
114 0.0006 0.00057005882263184
SELECT * FROM productamazoncontent WHERE product_id = '1115'
115 0.0012 0.001248836517334
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1115' AND a.name = n.originalname
116 0.0008 0.00075602531433105
SELECT * FROM productoffers WHERE product_id = '1115' AND merchantid = 'A1X6FK5RDHNB96'
117 0.0007 0.00071096420288086
SELECT * FROM productoffers
                WHERE product_id = '1115' AND price > 0
                ORDER BY price ASC LIMIT 1
118 0.0008 0.00076389312744141
SELECT value FROM productattributes WHERE product_id = '1115' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
119 0.0005 0.00045490264892578
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
120 0.0085 0.0085420608520508
SELECT *, MATCH (description, title) AGAINST ('rooibos earl grey' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('rooibos earl grey' IN BOOLEAN MODE) AND 1115 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
121 0.0008 0.00082302093505859
SELECT *, MATCH (description, title) AGAINST ('rooibos earl grey' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('rooibos earl grey' IN BOOLEAN MODE) AND 1115 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
122 0.0006 0.00060081481933594
SELECT *, MATCH (description, title) AGAINST ('rooibos earl grey' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('rooibos earl grey' IN BOOLEAN MODE) AND 1115 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
123 0.0003 0.0003199577331543
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
124 0.0003 0.00028491020202637
SELECT * FROM product_image_select WHERE product_id = '858'
125 0.0003 0.00030803680419922
SELECT * FROM productcustomimages WHERE product_id = '858'
126 0.0004 0.00035405158996582
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
127 0.0004 0.00039315223693848
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
128 0.0004 0.0003960132598877
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
129 0.0002 0.00024604797363281
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
130 0.0003 0.00026798248291016
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
131 0.0003 0.0002741813659668
SELECT * FROM product_image_select WHERE product_id = '878'
132 0.0003 0.00027894973754883
SELECT * FROM productcustomimages WHERE product_id = '878'
133 0.0004 0.00038003921508789
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
134 0.0003 0.0003349781036377
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
135 0.0004 0.0004420280456543
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
136 0.0003 0.00025606155395508
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
137 0.0003 0.00033712387084961
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
138 0.0004 0.00038290023803711
SELECT * FROM product_image_select WHERE product_id = '862'
139 0.0004 0.00041890144348145
SELECT * FROM productcustomimages WHERE product_id = '862'
140 0.0004 0.0004420280456543
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
141 0.0003 0.00032520294189453
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
142 0.0004 0.00043702125549316
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
143 0.0004 0.00042080879211426
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
144 0.0005 0.00049304962158203
SELECT id,asin FROM products WHERE parent_id = 1115
145 0.0004 0.00043487548828125
SELECT category_id FROM products_categories WHERE product_id = '1115'
146 0.0006 0.00057291984558105
SELECT * FROM categories WHERE id = '27'
147 0.0005 0.00046801567077637
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
148 0.0003 0.00033211708068848
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
149 0.0002 0.00024008750915527
SELECT id FROM categories WHERE parent_id = '27'
150 0.0003 0.0002591609954834
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 
151 0.0002 0.00024700164794922
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 
152 0.0002 0.00024199485778809
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
153 0.0002 0.00024318695068359
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
154 0.0003 0.00026583671569824
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1115' AND a.name = n.originalname
155 0.0003 0.00030708312988281
SELECT * FROM productoffers WHERE product_id = '1115' AND merchantid = 'A1X6FK5RDHNB96'
156 0.0003 0.00030994415283203
SELECT * FROM productoffers
                WHERE product_id = '1115' AND price > 0
                ORDER BY price ASC LIMIT 1
157 0.0005 0.00049519538879395
SELECT * FROM products WHERE id = '1115'
158 0.0003 0.0003058910369873
SELECT value FROM productattributes WHERE product_id = '1115' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
159 0.0005 0.00046086311340332
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1115' AND a.name = n.originalname
160 0.0005 0.00052404403686523
SELECT * FROM productoffers WHERE product_id = '1115' AND merchantid = 'A1X6FK5RDHNB96'
161 0.0004 0.00042295455932617
SELECT * FROM productoffers
                WHERE product_id = '1115' AND price > 0
                ORDER BY price ASC LIMIT 1
162 0.0006 0.00056099891662598
SELECT category_id FROM products_categories WHERE product_id = '1115' AND prod_type = 'amz'
163 0.0005 0.00047707557678223
SELECT parent_id FROM categories WHERE id = '27'
164 0.0005 0.00052309036254883
SELECT * FROM categories WHERE id = '27'
165 0.0004 0.00036406517028809
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
166 0.0004 0.0003669261932373
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
167 0.0003 0.00030112266540527
SELECT id FROM categories WHERE parent_id = '27'
168 0.0003 0.00028896331787109
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 
169 0.0003 0.00026082992553711
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 
170 0.0003 0.00027298927307129
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
171 0.0003 0.00027298927307129
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
172 0.0006 0.00064301490783691
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
173 0.0004 0.00042009353637695
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
174 0.0005 0.00046992301940918
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
175 0.0004 0.0004119873046875
SELECT * FROM pages WHERE id = 38
176 0.0057 0.0056731700897217
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
177 0.0007 0.00069713592529297
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:1653090049;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'
178 0.0007 0.00071883201599121
SELECT * FROM products WHERE id = 788
179 0.0007 0.00066113471984863
SELECT * FROM products WHERE id = 787
180 0.0007 0.00068211555480957
SELECT * FROM products WHERE id = 1287
181 0.0006 0.00064992904663086
SELECT * FROM products WHERE id = 780
182 0.0007 0.00066995620727539
SELECT * FROM products WHERE id = 777
183 0.0008 0.00077581405639648
SELECT * FROM products WHERE id = 776
184 0.0006 0.00057506561279297
SELECT * FROM products WHERE id = '788'
185 0.0004 0.00037908554077148
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
186 0.0003 0.00032901763916016
SELECT * FROM product_image_select WHERE product_id = '788'
187 0.0004 0.00041890144348145
SELECT * FROM productcustomimages WHERE product_id = '788'
188 0.0006 0.0005500316619873
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
189 0.0005 0.00049901008605957
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
190 0.0005 0.00049614906311035
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
191 0.0004 0.0004429817199707
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
192 0.0009 0.00086402893066406
SELECT * FROM products WHERE id = '787'
193 0.0021 0.0020761489868164
SELECT * FROM productimages WHERE product_id = '787' ORDER BY sortorder ASC
194 0.0005 0.00051212310791016
SELECT * FROM product_image_select WHERE product_id = '787'
195 0.0006 0.00061488151550293
SELECT * FROM productcustomimages WHERE product_id = '787'
196 0.0006 0.0005500316619873
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '787' AND a.name = n.originalname
197 0.0005 0.00045013427734375
SELECT * FROM productoffers WHERE product_id = '787' AND merchantid = 'A1X6FK5RDHNB96'
198 0.0006 0.00056695938110352
SELECT * FROM productoffers
                WHERE product_id = '787' AND price > 0
                ORDER BY price ASC LIMIT 1
199 0.0005 0.00050997734069824
SELECT value FROM productattributes WHERE product_id = '787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
200 0.0009 0.00093889236450195
SELECT * FROM products WHERE id = '1287'
201 0.0005 0.00052094459533691
SELECT * FROM productimages WHERE product_id = '1287' ORDER BY sortorder ASC
202 0.0005 0.00046396255493164
SELECT * FROM product_image_select WHERE product_id = '1287'
203 0.0005 0.00050806999206543
SELECT * FROM productcustomimages WHERE product_id = '1287'
204 0.0005 0.00049614906311035
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1287' AND a.name = n.originalname
205 0.0005 0.00048995018005371
SELECT * FROM productoffers WHERE product_id = '1287' AND merchantid = 'A1X6FK5RDHNB96'
206 0.0006 0.00055098533630371
SELECT * FROM productoffers
                WHERE product_id = '1287' AND price > 0
                ORDER BY price ASC LIMIT 1
207 0.0005 0.00050187110900879
SELECT value FROM productattributes WHERE product_id = '1287' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
208 0.0008 0.00078892707824707
SELECT * FROM products WHERE id = '780'
209 0.0005 0.00046491622924805
SELECT * FROM productimages WHERE product_id = '780' ORDER BY sortorder ASC
210 0.0005 0.0005347728729248
SELECT * FROM product_image_select WHERE product_id = '780'
211 0.0004 0.00042104721069336
SELECT * FROM productcustomimages WHERE product_id = '780'
212 0.0004 0.00043487548828125
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '780' AND a.name = n.originalname
213 0.0005 0.00049686431884766
SELECT * FROM productoffers WHERE product_id = '780' AND merchantid = 'A1X6FK5RDHNB96'
214 0.0005 0.00051283836364746
SELECT * FROM productoffers
                WHERE product_id = '780' AND price > 0
                ORDER BY price ASC LIMIT 1
215 0.0004 0.0003509521484375
SELECT value FROM productattributes WHERE product_id = '780' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
216 0.0008 0.00080609321594238
SELECT * FROM products WHERE id = '777'
217 0.0005 0.00047516822814941
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
218 0.0004 0.00044703483581543
SELECT * FROM product_image_select WHERE product_id = '777'
219 0.0006 0.00056910514831543
SELECT * FROM productcustomimages WHERE product_id = '777'
220 0.0006 0.00060296058654785
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
221 0.0005 0.00051212310791016
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
222 0.0006 0.00059413909912109
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
223 0.0005 0.00051188468933105
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
224 0.0009 0.00094294548034668
SELECT * FROM products WHERE id = '776'
225 0.0006 0.00056290626525879
SELECT * FROM productimages WHERE product_id = '776' ORDER BY sortorder ASC
226 0.0003 0.00034904479980469
SELECT * FROM product_image_select WHERE product_id = '776'
227 0.0005 0.0004580020904541
SELECT * FROM productcustomimages WHERE product_id = '776'
228 0.0005 0.00049495697021484
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '776' AND a.name = n.originalname
229 0.0004 0.00039219856262207
SELECT * FROM productoffers WHERE product_id = '776' AND merchantid = 'A1X6FK5RDHNB96'
230 0.0005 0.00048589706420898
SELECT * FROM productoffers
                WHERE product_id = '776' AND price > 0
                ORDER BY price ASC LIMIT 1
231 0.0004 0.00039005279541016
SELECT value FROM productattributes WHERE product_id = '776' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
232 0.0006 0.00056910514831543
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
233 0.0006 0.00056600570678711
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
234 0.0010 0.0010039806365967
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
235 0.0005 0.00047707557678223
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
236 0.0005 0.0005030632019043
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
237 0.0007 0.00068211555480957
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
238 0.0004 0.00040292739868164
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
239 0.0005 0.00053501129150391
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'