Ocun Eternal Pants Men Rooibos Tea| S

Ocun Eternal Pants Men Rooibos Tea| S
Ocun Eternal Pants Men Rooibos Tea| S Ocun Eternal Pants Men Rooibos Tea| S Ocun Eternal Pants Men Rooibos Tea| S Ocun Eternal Pants Men Rooibos Tea| S Ocun Eternal Pants Men Rooibos Tea| S (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-19 18:05:06 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

Ocun eternal pants men rooibos tea| s
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.91786098480225 243 0.1936 0


No Amazon API Requests Made.

Total time 0.91786098480225 seconds

Number Time From Start Name Description
1 0.66498994827271 Initialise Initialise FSB Function
2 0.6678900718689 App Controller Start Start of the App controller (called before the controller of every page)
3 0.671875 Start of getCategoryListByGroup Function Before first category groups query
4 0.67231416702271 After initial query Before first category groups query
5 0.67231607437134 Get Category List for Group Before the call to getCategoryList function
6 0.67232012748718 Start of GetCategoryList function Start of the function
7 0.67232298851013 Before getting categories Query to get specific category list
8 0.67300009727478 After getting categories Query to get specific category list
9 0.67300200462341 Before getting category custom Before call to function getCategoryCustom
10 0.69233703613281 After getting category custom After call to function getCategoryCustom
11 0.69234108924866 Before getting category custom Before call to function getCategoryCustom
12 0.70453500747681 After getting category custom After call to function getCategoryCustom
13 0.70453715324402 Before getting category custom Before call to function getCategoryCustom
14 0.71172904968262 After getting category custom After call to function getCategoryCustom
15 0.71173501014709 Before getting category custom Before call to function getCategoryCustom
16 0.71662616729736 After getting category custom After call to function getCategoryCustom
17 0.71662902832031 Before getting category custom Before call to function getCategoryCustom
18 0.72117304801941 After getting category custom After call to function getCategoryCustom
19 0.72117495536804 Before getting category custom Before call to function getCategoryCustom
20 0.72581195831299 After getting category custom After call to function getCategoryCustom
21 0.72581505775452 End of GetCategoryList function End of the function
22 0.72582316398621 End of getCategoryListByGroup Function Before return()
23 0.73261594772339 App Controller End End of the App controller (called before the controller of every page)
24 0.73354196548462 Product Start Start of the product info controller
25 0.73680305480957 Cache file not found Starting get product details
26 0.76622605323792 Related products Start getting related products if enabled
27 0.76622915267944 Related Products Start Before the related products are found
28 0.76623106002808 Related Products Keywords Before the related product keywords are found
29 0.76623916625977 Create Keyword List Function Start of function
30 0.76628708839417 Create Keyword List Function After looping provided content - 18 keywords found
31 0.7671160697937 Create Keyword List Function After looping initial keyword list - 15 keywords remaining
32 0.76712512969971 Create Keyword List Function After reducing keyword list
33 0.76715707778931 Create Keyword List Function After selecting by scoring keywords
34 0.76716113090515 Create Keyword List Function After final loop of keywords
35 0.7671639919281 Related Products Keywords After the related product keywords are found
36 0.81356000900269 Related Products End After the related products are found
37 0.82885193824768 Product End End of the product info controller (Product Info)
38 0.83026814460754 App_after Controller Start Start of the App_after controller (called after the controller of every page)
39 0.8311550617218 Before Get Options Before the call to getOptions in the tpl class
40 0.86706399917603 After Get Options After the call to getOptions in the tpl class
41 0.86714601516724 App_after Controller End End of the App_after controller (called after the controller of every page)
42 0.86718797683716 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
43 0.88716316223145 Product Info: After Smarty Fetch After the product.tpl template is fetched
44 0.88716912269592 Product Info: Before Template Display Before the template is displayed
45 0.91782808303833 Product Info: After Template Display After the template is displayed
46 0.91784596443176 Finalizing debug Before the debug is output to the page.
47 0.91786003112793 End of App This is the end of the app logging, final timestamp


Query Debug - 243 Database Queries. Total time 0.1936 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0008 0.00076413154602051
SELECT parameter, value FROM parameters
2 0.0012 0.0011539459228516
SELECT * FROM `bad_bots`
3 0.0004 0.00040316581726074
SET time_zone = 'Europe/London'
4 0.0004 0.00043392181396484
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0027 0.0026760101318359
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"34.231.247.88\";}'
6 0.0015 0.0014908313751221
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1653304763'
7 0.0005 0.00051283836364746
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0004 0.00039792060852051
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0008 0.00078487396240234
SELECT id FROM pages WHERE pagename = 'ocun-eternal-pants-men-rooibos-tea-s' LIMIT 1
10 0.0007 0.00073003768920898
SELECT id FROM products WHERE pagename = 'ocun-eternal-pants-men-rooibos-tea-s' AND hidden = 0 LIMIT 1
11 0.0014 0.0014030933380127
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
12 0.0011 0.0011360645294189
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
13 0.0007 0.00067687034606934
SELECT * FROM pages WHERE pagename = 'ocun-eternal-pants-men-rooibos-tea-s'
14 0.0004 0.00042486190795898
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0006 0.00064802169799805
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0093 0.0093472003936768
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.00034308433532715
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.00026607513427734
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0003 0.00027799606323242
SELECT id FROM categories WHERE parent_id = '26'
20 0.0075 0.0074851512908936
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.00034809112548828
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.0004 0.00041508674621582
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.00033879280090332
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0003 0.00034403800964355
SELECT * FROM categorygroups WHERE id = '1'
25 0.0048 0.0047979354858398
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.0005 0.0005040168762207
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.0004 0.00036191940307617
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0003 0.00030398368835449
SELECT id FROM categories WHERE parent_id = '27'
29 0.0046 0.0046300888061523
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.00049304962158203
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.00027990341186523
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.0003349781036377
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0003 0.00034713745117188
SELECT * FROM categorygroups WHERE id = '1'
34 0.0021 0.0020849704742432
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.00037288665771484
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.00032901763916016
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0004 0.00040984153747559
SELECT id FROM categories WHERE parent_id = '28'
38 0.0019 0.0019431114196777
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.0005 0.00052809715270996
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.00049996376037598
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.0004 0.00044798851013184
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0004 0.00043511390686035
SELECT * FROM categorygroups WHERE id = '1'
43 0.0008 0.00083804130554199
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.00042486190795898
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.00046896934509277
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0005 0.00046515464782715
SELECT id FROM categories WHERE parent_id = '29'
47 0.0008 0.0007779598236084
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.0004 0.00041413307189941
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.00043988227844238
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.0005 0.00045299530029297
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0005 0.00047016143798828
SELECT * FROM categorygroups WHERE id = '1'
52 0.0008 0.0008089542388916
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.00041484832763672
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.00039196014404297
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0003 0.00033283233642578
SELECT id FROM categories WHERE parent_id = '30'
56 0.0009 0.00094199180603027
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.00033283233642578
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.00039219856262207
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.0004 0.00036716461181641
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0004 0.00042819976806641
SELECT * FROM categorygroups WHERE id = '1'
61 0.0009 0.0008549690246582
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.0004 0.0003969669342041
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.00036501884460449
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0004 0.0004119873046875
SELECT id FROM categories WHERE parent_id = '31'
65 0.0009 0.00085997581481934
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
66 0.0004 0.00044083595275879
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.0004 0.00041007995605469
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
68 0.0004 0.00038886070251465
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0004 0.00038695335388184
SELECT * FROM categorygroups WHERE id = '1'
70 0.0004 0.00039887428283691
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
71 0.0004 0.00037503242492676
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
72 0.0005 0.00045394897460938
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.0005 0.00050091743469238
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
74 0.0008 0.00078010559082031
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
75 0.0006 0.00064611434936523
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
76 0.0003 0.00034904479980469
SELECT * FROM ipgeocountries WHERE INET_ATON('34.231.247.88') >= INET_ATON(ip_start) AND INET_ATON('34.231.247.88') <= INET_ATON(ip_end)
77 0.0004 0.00036406517028809
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
78 0.0004 0.00036811828613281
SELECT * FROM countryredirects WHERE countrycode = 'US'
79 0.0008 0.00076985359191895
SELECT * FROM products WHERE pagename = 'ocun-eternal-pants-men-rooibos-tea-s'
80 0.0014 0.0014438629150391
UPDATE products SET viewcount = viewcount + 1 WHERE id = 3744
81 0.0006 0.00064206123352051
SELECT * FROM manufacturers WHERE id = '438'
82 0.0008 0.000762939453125
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '438'
83 0.0004 0.00043201446533203
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '438' LIMIT 1
84 0.0012 0.0012381076812744
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '438' ORDER BY RAND() LIMIT 1
85 0.0023 0.002331018447876
SELECT * FROM productimages WHERE product_id = '3434' ORDER BY sortorder ASC
86 0.0004 0.00039100646972656
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '438'
87 0.0009 0.00089192390441895
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '438'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
88 0.0004 0.00043606758117676
SELECT * FROM manufacturerimages WHERE manufacturer_id = '438'
89 0.0004 0.00037097930908203
SELECT category_id FROM products_categories WHERE product_id = '3744'
90 0.0004 0.00035190582275391
SELECT * FROM categories WHERE id = '27'
91 0.0046 0.0045821666717529
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.0004730224609375
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
93 0.0004 0.00044679641723633
SELECT id FROM categories WHERE parent_id = '27'
94 0.0045 0.0045149326324463
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.0005 0.0004880428314209
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.00036883354187012
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.00040316581726074
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
98 0.0013 0.0013399124145508
SELECT * FROM productimages WHERE product_id = '3744' ORDER BY sortorder ASC
99 0.0009 0.00086808204650879
SELECT * FROM product_image_select WHERE product_id = '3744'
100 0.0007 0.00067019462585449
SELECT * FROM productcustomimages WHERE product_id = '3744'
101 0.0005 0.00054597854614258
SELECT * FROM productfeeds WHERE product_id = '3744' ORDER BY item_date DESC
102 0.0006 0.00057005882263184
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '3744' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
103 0.0005 0.0004878044128418
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '3744' AND t.hidden = 0 AND display_product = 1
104 0.0004 0.00044703483581543
SELECT * FROM productamazoncontent WHERE product_id = '3744'
105 0.0010 0.0009911060333252
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3744' AND a.name = n.originalname
106 0.0006 0.00059914588928223
SELECT * FROM productoffers WHERE product_id = '3744' AND merchantid = 'A1X6FK5RDHNB96'
107 0.0006 0.00058603286743164
SELECT * FROM productoffers
                WHERE product_id = '3744' AND price > 0
                ORDER BY price ASC LIMIT 1
108 0.0006 0.00057888031005859
SELECT * FROM productoffers
                WHERE product_id = 3744
                ORDER BY price ASC LIMIT 1
109 0.0006 0.00062799453735352
SELECT value FROM productattributes
                WHERE product_id = '3744'
                AND name = 'ListPriceAmount'
110 0.0006 0.00062108039855957
SELECT value FROM productattributes WHERE product_id = '3744' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
111 0.0005 0.00051403045654297
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.0092 0.0092160701751709
SELECT *, MATCH (description, title) AGAINST ('ocun eternal pants' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('ocun eternal pants' IN BOOLEAN MODE) AND 3744 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
113 0.0007 0.00065898895263672
SELECT *, MATCH (description, title) AGAINST ('ocun eternal pants' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('ocun eternal pants' IN BOOLEAN MODE) AND 3744 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
114 0.0005 0.00054001808166504
SELECT *, MATCH (description, title) AGAINST ('ocun eternal pants' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('ocun eternal pants' IN BOOLEAN MODE) AND 3744 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
115 0.0018 0.0017521381378174
SELECT categories.id, COUNT(*) as productcount FROM products_categories, categories WHERE categories.id IN (SELECT category_id FROM products_categories WHERE product_id = '3744') AND products_categories.category_id = categories.id GROUP BY categories.id ORDER BY productcount ASC
116 0.0130 0.013047933578491
SELECT p.* FROM products p, products_categories pc WHERE p.parent_id = 0 AND p.id = pc.product_id AND pc.category_id = '27' AND pc.prod_type = 'amz'  AND p.id <> '3744' ORDER BY RAND()
117 0.0005 0.00053215026855469
SELECT p.* FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND pc.category_id = '27' AND pc.prod_type = 'ebay' AND p.id <> '3744' ORDER BY RAND()
118 0.0005 0.00047492980957031
SELECT p.* FROM custom_products p, products_categories pc WHERE p.id = pc.product_id AND pc.category_id = '27' AND pc.prod_type = 'custom' AND p.id <> '3744' ORDER BY RAND()
119 0.0011 0.001086950302124
SELECT * FROM productimages WHERE product_id = '1296' ORDER BY sortorder ASC
120 0.0004 0.00041103363037109
SELECT * FROM product_image_select WHERE product_id = '1296'
121 0.0005 0.00047802925109863
SELECT * FROM productcustomimages WHERE product_id = '1296'
122 0.0014 0.0014369487762451
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1296' AND a.name = n.originalname
123 0.0005 0.0005190372467041
SELECT * FROM productoffers WHERE product_id = '1296' AND merchantid = 'A1X6FK5RDHNB96'
124 0.0004 0.0004279613494873
SELECT * FROM productoffers
                WHERE product_id = '1296' AND price > 0
                ORDER BY price ASC LIMIT 1
125 0.0005 0.00050687789916992
SELECT * FROM productoffers
                WHERE product_id = 1296
                ORDER BY price ASC LIMIT 1
126 0.0006 0.00057005882263184
SELECT value FROM productattributes
                WHERE product_id = '1296'
                AND name = 'ListPriceAmount'
127 0.0005 0.00051188468933105
SELECT value FROM productattributes WHERE product_id = '1296' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
128 0.0009 0.00093293190002441
SELECT * FROM productimages WHERE product_id = '901' ORDER BY sortorder ASC
129 0.0004 0.00038290023803711
SELECT * FROM product_image_select WHERE product_id = '901'
130 0.0003 0.00029301643371582
SELECT * FROM productcustomimages WHERE product_id = '901'
131 0.0012 0.0012171268463135
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '901' AND a.name = n.originalname
132 0.0006 0.00062990188598633
SELECT * FROM productoffers WHERE product_id = '901' AND merchantid = 'A1X6FK5RDHNB96'
133 0.0006 0.00057101249694824
SELECT * FROM productoffers
                WHERE product_id = '901' AND price > 0
                ORDER BY price ASC LIMIT 1
134 0.0006 0.000579833984375
SELECT * FROM productoffers
                WHERE product_id = 901
                ORDER BY price ASC LIMIT 1
135 0.0007 0.0007469654083252
SELECT value FROM productattributes
                WHERE product_id = '901'
                AND name = 'ListPriceAmount'
136 0.0005 0.00052905082702637
SELECT value FROM productattributes WHERE product_id = '901' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
137 0.0010 0.0010139942169189
SELECT * FROM productimages WHERE product_id = '1513' ORDER BY sortorder ASC
138 0.0006 0.00058603286743164
SELECT * FROM product_image_select WHERE product_id = '1513'
139 0.0005 0.00047588348388672
SELECT * FROM productcustomimages WHERE product_id = '1513'
140 0.0014 0.0013809204101562
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1513' AND a.name = n.originalname
141 0.0006 0.00063705444335938
SELECT * FROM productoffers WHERE product_id = '1513' AND merchantid = 'A1X6FK5RDHNB96'
142 0.0006 0.00064897537231445
SELECT * FROM productoffers
                WHERE product_id = '1513' AND price > 0
                ORDER BY price ASC LIMIT 1
143 0.0005 0.00053191184997559
SELECT value FROM productattributes WHERE product_id = '1513' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
144 0.0006 0.00062799453735352
SELECT id,asin FROM products WHERE parent_id = 3744
145 0.0003 0.00032305717468262
SELECT category_id FROM products_categories WHERE product_id = '3744'
146 0.0003 0.00032305717468262
SELECT * FROM categories WHERE id = '27'
147 0.0004 0.00040411949157715
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.0005 0.00046491622924805
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
149 0.0004 0.00043511390686035
SELECT id FROM categories WHERE parent_id = '27'
150 0.0004 0.00042390823364258
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.0005 0.00046896934509277
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.0005 0.00048708915710449
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.0004 0.00040698051452637
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
154 0.0005 0.00045180320739746
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3744' AND a.name = n.originalname
155 0.0005 0.00051712989807129
SELECT * FROM productoffers WHERE product_id = '3744' AND merchantid = 'A1X6FK5RDHNB96'
156 0.0003 0.00028681755065918
SELECT * FROM productoffers
                WHERE product_id = '3744' AND price > 0
                ORDER BY price ASC LIMIT 1
157 0.0003 0.0002598762512207
SELECT * FROM productoffers
                WHERE product_id = 3744
                ORDER BY price ASC LIMIT 1
158 0.0005 0.00052309036254883
SELECT value FROM productattributes
                WHERE product_id = '3744'
                AND name = 'ListPriceAmount'
159 0.0008 0.00076007843017578
SELECT * FROM products WHERE id = '3744'
160 0.0004 0.00042510032653809
SELECT value FROM productattributes WHERE product_id = '3744' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
161 0.0004 0.0004270076751709
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3744' AND a.name = n.originalname
162 0.0005 0.00048112869262695
SELECT * FROM productoffers WHERE product_id = '3744' AND merchantid = 'A1X6FK5RDHNB96'
163 0.0005 0.00052499771118164
SELECT * FROM productoffers
                WHERE product_id = '3744' AND price > 0
                ORDER BY price ASC LIMIT 1
164 0.0004 0.00041508674621582
SELECT * FROM productoffers
                WHERE product_id = 3744
                ORDER BY price ASC LIMIT 1
165 0.0005 0.00049185752868652
SELECT value FROM productattributes
                WHERE product_id = '3744'
                AND name = 'ListPriceAmount'
166 0.0006 0.00063610076904297
SELECT category_id FROM products_categories WHERE product_id = '3744' AND prod_type = 'amz'
167 0.0004 0.00042510032653809
SELECT parent_id FROM categories WHERE id = '27'
168 0.0005 0.00051999092102051
SELECT * FROM categories WHERE id = '27'
169 0.0004 0.00039792060852051
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
170 0.0004 0.00042605400085449
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
171 0.0004 0.00038695335388184
SELECT id FROM categories WHERE parent_id = '27'
172 0.0004 0.00040578842163086
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 
173 0.0004 0.00040602684020996
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 
174 0.0005 0.0004570484161377
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
175 0.0004 0.00036382675170898
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
176 0.0005 0.00054097175598145
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
177 0.0004 0.0003960132598877
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
178 0.0004 0.00040197372436523
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
179 0.0006 0.00055909156799316
SELECT * FROM pages WHERE id = 38
180 0.0057 0.0056509971618652
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
181 0.0007 0.00072789192199707
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:1653304763;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'
182 0.0007 0.0007171630859375
SELECT * FROM products WHERE id = 788
183 0.0008 0.00077986717224121
SELECT * FROM products WHERE id = 787
184 0.0006 0.00063800811767578
SELECT * FROM products WHERE id = 1287
185 0.0006 0.00063705444335938
SELECT * FROM products WHERE id = 780
186 0.0006 0.00064396858215332
SELECT * FROM products WHERE id = 777
187 0.0006 0.00055503845214844
SELECT * FROM products WHERE id = 776
188 0.0006 0.00062394142150879
SELECT * FROM products WHERE id = '788'
189 0.0004 0.00037097930908203
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
190 0.0003 0.00027108192443848
SELECT * FROM product_image_select WHERE product_id = '788'
191 0.0002 0.00024199485778809
SELECT * FROM productcustomimages WHERE product_id = '788'
192 0.0004 0.00036287307739258
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
193 0.0004 0.00039196014404297
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
194 0.0005 0.00049090385437012
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
195 0.0004 0.00037384033203125
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
196 0.0005 0.00052213668823242
SELECT * FROM products WHERE id = '787'
197 0.0003 0.00033688545227051
SELECT * FROM productimages WHERE product_id = '787' ORDER BY sortorder ASC
198 0.0004 0.00044798851013184
SELECT * FROM product_image_select WHERE product_id = '787'
199 0.0004 0.00037097930908203
SELECT * FROM productcustomimages WHERE product_id = '787'
200 0.0005 0.00045990943908691
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '787' AND a.name = n.originalname
201 0.0005 0.00051307678222656
SELECT * FROM productoffers WHERE product_id = '787' AND merchantid = 'A1X6FK5RDHNB96'
202 0.0004 0.00041913986206055
SELECT * FROM productoffers
                WHERE product_id = '787' AND price > 0
                ORDER BY price ASC LIMIT 1
203 0.0003 0.00034308433532715
SELECT value FROM productattributes WHERE product_id = '787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
204 0.0006 0.00063800811767578
SELECT * FROM products WHERE id = '1287'
205 0.0004 0.00040793418884277
SELECT * FROM productimages WHERE product_id = '1287' ORDER BY sortorder ASC
206 0.0003 0.00033092498779297
SELECT * FROM product_image_select WHERE product_id = '1287'
207 0.0003 0.00026893615722656
SELECT * FROM productcustomimages WHERE product_id = '1287'
208 0.0003 0.00034689903259277
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1287' AND a.name = n.originalname
209 0.0003 0.00030899047851562
SELECT * FROM productoffers WHERE product_id = '1287' AND merchantid = 'A1X6FK5RDHNB96'
210 0.0004 0.00037598609924316
SELECT * FROM productoffers
                WHERE product_id = '1287' AND price > 0
                ORDER BY price ASC LIMIT 1
211 0.0004 0.00039076805114746
SELECT value FROM productattributes WHERE product_id = '1287' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
212 0.0007 0.00070810317993164
SELECT * FROM products WHERE id = '780'
213 0.0004 0.00041294097900391
SELECT * FROM productimages WHERE product_id = '780' ORDER BY sortorder ASC
214 0.0004 0.00044798851013184
SELECT * FROM product_image_select WHERE product_id = '780'
215 0.0004 0.00040102005004883
SELECT * FROM productcustomimages WHERE product_id = '780'
216 0.0004 0.00044822692871094
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '780' AND a.name = n.originalname
217 0.0004 0.0003809928894043
SELECT * FROM productoffers WHERE product_id = '780' AND merchantid = 'A1X6FK5RDHNB96'
218 0.0004 0.0003819465637207
SELECT * FROM productoffers
                WHERE product_id = '780' AND price > 0
                ORDER BY price ASC LIMIT 1
219 0.0004 0.0003509521484375
SELECT value FROM productattributes WHERE product_id = '780' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
220 0.0006 0.00059795379638672
SELECT * FROM products WHERE id = '777'
221 0.0004 0.0003819465637207
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
222 0.0004 0.0004429817199707
SELECT * FROM product_image_select WHERE product_id = '777'
223 0.0003 0.00026106834411621
SELECT * FROM productcustomimages WHERE product_id = '777'
224 0.0004 0.00037288665771484
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
225 0.0003 0.00034117698669434
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
226 0.0003 0.00028109550476074
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
227 0.0002 0.00024604797363281
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
228 0.0005 0.00049996376037598
SELECT * FROM products WHERE id = '776'
229 0.0005 0.00045990943908691
SELECT * FROM productimages WHERE product_id = '776' ORDER BY sortorder ASC
230 0.0005 0.00048208236694336
SELECT * FROM product_image_select WHERE product_id = '776'
231 0.0004 0.00041794776916504
SELECT * FROM productcustomimages WHERE product_id = '776'
232 0.0004 0.00040721893310547
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '776' AND a.name = n.originalname
233 0.0003 0.00034594535827637
SELECT * FROM productoffers WHERE product_id = '776' AND merchantid = 'A1X6FK5RDHNB96'
234 0.0005 0.00047492980957031
SELECT * FROM productoffers
                WHERE product_id = '776' AND price > 0
                ORDER BY price ASC LIMIT 1
235 0.0002 0.00023889541625977
SELECT value FROM productattributes WHERE product_id = '776' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
236 0.0004 0.00037789344787598
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
237 0.0006 0.00055289268493652
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
238 0.0007 0.00069999694824219
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
239 0.0004 0.00040006637573242
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
240 0.0004 0.00038790702819824
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
241 0.0005 0.00047802925109863
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
242 0.0004 0.00040197372436523
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
243 0.0004 0.00038313865661621
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'