Colette nous Rooibos Patron de Couture Robe Tailles 0–18

Colette nous Rooibos Patron de Couture Robe Tailles 0–18
Colette nous Rooibos Patron de Couture Robe Tailles 0–18 Colette nous Rooibos Patron de Couture Robe Tailles 0–18 (cliquez sur les images pour élargir)
Bouton de clic pour le prix
Non Disponible Épuisé
Le prix et la disponibilité du produit sont corrects en date du 2021-09-20 05:16:41 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

Motif intermédiaire égouts Utilisation à la maison Conçu et fabriqué par Colette aux USA Robe avec grande taille. Bon, instructions claires
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.85655808448792 235 0.1130 0


No Amazon API Requests Made.

Total time 0.85655808448792 seconds

Number Time From Start Name Description
1 0.69464802742004 Initialise Initialise FSB Function
2 0.69704103469849 App Controller Start Start of the App controller (called before the controller of every page)
3 0.70235013961792 Start of getCategoryListByGroup Function Before first category groups query
4 0.70269417762756 After initial query Before first category groups query
5 0.7026960849762 Get Category List for Group Before the call to getCategoryList function
6 0.70270013809204 Start of GetCategoryList function Start of the function
7 0.70270299911499 Before getting categories Query to get specific category list
8 0.70319509506226 After getting categories Query to get specific category list
9 0.70319700241089 Before getting category custom Before call to function getCategoryCustom
10 0.70655107498169 After getting category custom After call to function getCategoryCustom
11 0.70655417442322 Before getting category custom Before call to function getCategoryCustom
12 0.72081804275513 After getting category custom After call to function getCategoryCustom
13 0.72082018852234 Before getting category custom Before call to function getCategoryCustom
14 0.72551608085632 After getting category custom After call to function getCategoryCustom
15 0.72551918029785 Before getting category custom Before call to function getCategoryCustom
16 0.72785019874573 After getting category custom After call to function getCategoryCustom
17 0.72785210609436 Before getting category custom Before call to function getCategoryCustom
18 0.73014497756958 After getting category custom After call to function getCategoryCustom
19 0.73014712333679 Before getting category custom Before call to function getCategoryCustom
20 0.73245620727539 After getting category custom After call to function getCategoryCustom
21 0.73245906829834 End of GetCategoryList function End of the function
22 0.7324640750885 End of getCategoryListByGroup Function Before return()
23 0.73672604560852 App Controller End End of the App controller (called before the controller of every page)
24 0.73732805252075 Product Start Start of the product info controller
25 0.739089012146 Cache file not found Starting get product details
26 0.75874304771423 Related products Start getting related products if enabled
27 0.75874519348145 Related Products Start Before the related products are found
28 0.75874614715576 Related Products Keywords Before the related product keywords are found
29 0.75875115394592 Create Keyword List Function Start of function
30 0.75883197784424 Create Keyword List Function After looping provided content - 24 keywords found
31 0.75980710983276 Create Keyword List Function After looping initial keyword list - 22 keywords remaining
32 0.75981402397156 Create Keyword List Function After reducing keyword list
33 0.75986409187317 Create Keyword List Function After selecting by scoring keywords
34 0.75986909866333 Create Keyword List Function After final loop of keywords
35 0.75987100601196 Related Products Keywords After the related product keywords are found
36 0.77472901344299 Related Products End After the related products are found
37 0.78173804283142 Product End End of the product info controller (Product Info)
38 0.78252696990967 App_after Controller Start Start of the App_after controller (called after the controller of every page)
39 0.78295516967773 Before Get Options Before the call to getOptions in the tpl class
40 0.81211018562317 After Get Options After the call to getOptions in the tpl class
41 0.81223607063293 App_after Controller End End of the App_after controller (called after the controller of every page)
42 0.8122661113739 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
43 0.8235399723053 Product Info: After Smarty Fetch After the product.tpl template is fetched
44 0.82354497909546 Product Info: Before Template Display Before the template is displayed
45 0.85652709007263 Product Info: After Template Display After the template is displayed
46 0.8565411567688 Finalizing debug Before the debug is output to the page.
47 0.85655403137207 End of App This is the end of the app logging, final timestamp


Query Debug - 235 Database Queries. Total time 0.1130 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0004 0.00044393539428711
SELECT parameter, value FROM parameters
2 0.0011 0.0011081695556641
SELECT * FROM `bad_bots`
3 0.0004 0.00037193298339844
SET time_zone = 'Europe/London'
4 0.0003 0.00033402442932129
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0021 0.0020551681518555
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"3.236.212.116\";}'
6 0.0012 0.0012478828430176
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1632133354'
7 0.0004 0.0004119873046875
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0003 0.00028681755065918
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0007 0.00072717666625977
SELECT id FROM pages WHERE pagename = 'colette-nous-rooibos-patron-de-couture-robe-tailles-018' LIMIT 1
10 0.0007 0.0007479190826416
SELECT id FROM products WHERE pagename = 'colette-nous-rooibos-patron-de-couture-robe-tailles-018' AND hidden = 0 LIMIT 1
11 0.0032 0.0031712055206299
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
12 0.0010 0.00097393989562988
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
13 0.0006 0.00062417984008789
SELECT * FROM pages WHERE pagename = 'colette-nous-rooibos-patron-de-couture-robe-tailles-018'
14 0.0003 0.00032711029052734
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0005 0.00046801567077637
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0002 0.00024700164794922
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.0015 0.0015389919281006
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.00023698806762695
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0002 0.00020694732666016
SELECT id FROM categories WHERE parent_id = '26'
20 0.0002 0.0002140998840332
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.0002 0.00021600723266602
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.00020480155944824
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.0002 0.0001838207244873
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0002 0.00019216537475586
SELECT * FROM categorygroups WHERE id = '1'
25 0.0085 0.0085198879241943
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.0002 0.00017714500427246
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.0002 0.00016093254089355
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0002 0.00016093254089355
SELECT id FROM categories WHERE parent_id = '27'
29 0.0044 0.0044069290161133
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.0002 0.00024294853210449
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.00016498565673828
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.00015497207641602
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0002 0.00016903877258301
SELECT * FROM categorygroups WHERE id = '1'
34 0.0016 0.0016059875488281
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.00022101402282715
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.00018596649169922
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0002 0.00018095970153809
SELECT id FROM categories WHERE parent_id = '28'
38 0.0015 0.0015308856964111
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.00035905838012695
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.00017404556274414
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.00017309188842773
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0002 0.00016689300537109
SELECT * FROM categorygroups WHERE id = '1'
43 0.0005 0.0005490779876709
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.00016689300537109
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.0001528263092041
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0002 0.00016403198242188
SELECT id FROM categories WHERE parent_id = '29'
47 0.0005 0.00053882598876953
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.00018787384033203
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.0002 0.00016999244689941
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.00015783309936523
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0002 0.00016307830810547
SELECT * FROM categorygroups WHERE id = '1'
52 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 = 30
53 0.0002 0.00019311904907227
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.0002 0.00016021728515625
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0002 0.00016212463378906
SELECT id FROM categories WHERE parent_id = '30'
56 0.0005 0.00051689147949219
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.0002 0.00021481513977051
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.00016212463378906
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.0002 0.00015807151794434
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0002 0.00016999244689941
SELECT * FROM categorygroups WHERE id = '1'
61 0.0005 0.00050210952758789
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.00016307830810547
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.00015497207641602
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0002 0.00016093254089355
SELECT id FROM categories WHERE parent_id = '31'
65 0.0006 0.00055193901062012
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.00018191337585449
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.00016903877258301
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.00016307830810547
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0002 0.00015902519226074
SELECT * FROM categorygroups WHERE id = '1'
70 0.0002 0.00017786026000977
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
71 0.0002 0.00023794174194336
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
72 0.0002 0.00021004676818848
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.0002 0.00018000602722168
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
74 0.0004 0.00040292739868164
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
75 0.0005 0.00049090385437012
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
76 0.0002 0.00017189979553223
SELECT * FROM ipgeocountries WHERE INET_ATON('3.236.212.116') >= INET_ATON(ip_start) AND INET_ATON('3.236.212.116') <= INET_ATON(ip_end)
77 0.0002 0.0001671314239502
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
78 0.0002 0.00016117095947266
SELECT * FROM countryredirects WHERE countrycode = 'US'
79 0.0004 0.00044703483581543
SELECT * FROM products WHERE pagename = 'colette-nous-rooibos-patron-de-couture-robe-tailles-018'
80 0.0007 0.00068807601928711
UPDATE products SET viewcount = viewcount + 1 WHERE id = 861
81 0.0003 0.0003209114074707
SELECT * FROM manufacturers WHERE id = '224'
82 0.0004 0.00043487548828125
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '224'
83 0.0002 0.00024294853210449
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '224' LIMIT 1
84 0.0007 0.0006718635559082
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '224' ORDER BY RAND() LIMIT 1
85 0.0002 0.00021195411682129
SELECT * FROM productimages WHERE product_id = '861' ORDER BY sortorder ASC
86 0.0002 0.00015497207641602
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '224'
87 0.0005 0.00049996376037598
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '224'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
88 0.0003 0.0002598762512207
SELECT * FROM manufacturerimages WHERE manufacturer_id = '224'
89 0.0004 0.00036406517028809
SELECT category_id FROM products_categories WHERE product_id = '861'
90 0.0002 0.00020599365234375
SELECT * FROM categories WHERE id = '27'
91 0.0044 0.0044460296630859
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.0002 0.0001680850982666
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
93 0.0002 0.00016498565673828
SELECT id FROM categories WHERE parent_id = '27'
94 0.0046 0.0046091079711914
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.00020503997802734
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.00016212463378906
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.00017285346984863
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
98 0.0002 0.00016999244689941
SELECT * FROM productimages WHERE product_id = '861' ORDER BY sortorder ASC
99 0.0002 0.00018692016601562
SELECT * FROM product_image_select WHERE product_id = '861'
100 0.0002 0.0001671314239502
SELECT * FROM productcustomimages WHERE product_id = '861'
101 0.0003 0.00026392936706543
SELECT * FROM productfeeds WHERE product_id = '861' ORDER BY item_date DESC
102 0.0018 0.0018329620361328
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '861' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
103 0.0004 0.00044703483581543
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '861' AND t.hidden = 0 AND display_product = 1
104 0.0003 0.00032901763916016
SELECT * FROM productamazoncontent WHERE product_id = '861'
105 0.0002 0.00017595291137695
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '861' AND a.name = n.originalname
106 0.0003 0.00032210350036621
SELECT * FROM productoffers WHERE product_id = '861' AND merchantid = 'A1X6FK5RDHNB96'
107 0.0005 0.00053215026855469
SELECT * FROM productoffers
                WHERE product_id = '861' AND price > 0
                ORDER BY price ASC LIMIT 1
108 0.0004 0.00044608116149902
SELECT * FROM productoffers
                WHERE product_id = 861
                ORDER BY price ASC LIMIT 1
109 0.0005 0.00051999092102051
SELECT value FROM productattributes
                WHERE product_id = '861'
                AND name = 'ListPriceAmount'
110 0.0002 0.0001671314239502
SELECT value FROM productattributes WHERE product_id = '861' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
111 0.0002 0.00019192695617676
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.0081 0.0081088542938232
SELECT *, MATCH (description, title) AGAINST ('colette nous rooibos' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('colette nous rooibos' IN BOOLEAN MODE) AND 861 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
113 0.0006 0.00060105323791504
SELECT *, MATCH (description, title) AGAINST ('colette nous rooibos' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('colette nous rooibos' IN BOOLEAN MODE) AND 861 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
114 0.0006 0.00055503845214844
SELECT *, MATCH (description, title) AGAINST ('colette nous rooibos' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('colette nous rooibos' IN BOOLEAN MODE) AND 861 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
115 0.0004 0.00039386749267578
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
116 0.0002 0.00017905235290527
SELECT * FROM product_image_select WHERE product_id = '858'
117 0.0002 0.00022697448730469
SELECT * FROM productcustomimages WHERE product_id = '858'
118 0.0003 0.00028514862060547
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
119 0.0002 0.00023221969604492
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
120 0.0002 0.0001990795135498
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
121 0.0003 0.0002899169921875
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
122 0.0002 0.0001678466796875
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
123 0.0002 0.00018215179443359
SELECT * FROM product_image_select WHERE product_id = '878'
124 0.0002 0.00018405914306641
SELECT * FROM productcustomimages WHERE product_id = '878'
125 0.0002 0.00018811225891113
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
126 0.0002 0.00017404556274414
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
127 0.0002 0.00018906593322754
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
128 0.0003 0.00032806396484375
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
129 0.0003 0.00029683113098145
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
130 0.0002 0.00018715858459473
SELECT * FROM product_image_select WHERE product_id = '862'
131 0.0002 0.00018215179443359
SELECT * FROM productcustomimages WHERE product_id = '862'
132 0.0003 0.00025510787963867
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
133 0.0002 0.0001828670501709
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
134 0.0002 0.00023007392883301
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
135 0.0003 0.00034403800964355
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
136 0.0004 0.00041413307189941
SELECT id,asin FROM products WHERE parent_id = 861
137 0.0002 0.00022697448730469
SELECT category_id FROM products_categories WHERE product_id = '861'
138 0.0002 0.00019693374633789
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.00019288063049316
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
141 0.0002 0.00016403198242188
SELECT id FROM categories WHERE parent_id = '27'
142 0.0001 0.00014495849609375
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.00026917457580566
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.0001978874206543
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.0003 0.00025606155395508
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
146 0.0002 0.00017690658569336
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '861' AND a.name = n.originalname
147 0.0002 0.00018000602722168
SELECT * FROM productoffers WHERE product_id = '861' AND merchantid = 'A1X6FK5RDHNB96'
148 0.0002 0.00018000602722168
SELECT * FROM productoffers
                WHERE product_id = '861' AND price > 0
                ORDER BY price ASC LIMIT 1
149 0.0002 0.00019311904907227
SELECT * FROM productoffers
                WHERE product_id = 861
                ORDER BY price ASC LIMIT 1
150 0.0002 0.00016999244689941
SELECT value FROM productattributes
                WHERE product_id = '861'
                AND name = 'ListPriceAmount'
151 0.0005 0.00054812431335449
SELECT * FROM products WHERE id = '861'
152 0.0002 0.00015902519226074
SELECT value FROM productattributes WHERE product_id = '861' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
153 0.0002 0.00018692016601562
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '861' AND a.name = n.originalname
154 0.0002 0.00017380714416504
SELECT * FROM productoffers WHERE product_id = '861' AND merchantid = 'A1X6FK5RDHNB96'
155 0.0002 0.00017499923706055
SELECT * FROM productoffers
                WHERE product_id = '861' AND price > 0
                ORDER BY price ASC LIMIT 1
156 0.0002 0.00017690658569336
SELECT * FROM productoffers
                WHERE product_id = 861
                ORDER BY price ASC LIMIT 1
157 0.0002 0.0001678466796875
SELECT value FROM productattributes
                WHERE product_id = '861'
                AND name = 'ListPriceAmount'
158 0.0003 0.00029110908508301
SELECT category_id FROM products_categories WHERE product_id = '861' AND prod_type = 'amz'
159 0.0002 0.00017094612121582
SELECT parent_id FROM categories WHERE id = '27'
160 0.0002 0.00019216537475586
SELECT * FROM categories WHERE id = '27'
161 0.0002 0.00017118453979492
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.0001521110534668
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
163 0.0002 0.00016999244689941
SELECT id FROM categories WHERE parent_id = '27'
164 0.0002 0.00018310546875
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.00020694732666016
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.00016403198242188
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.00015997886657715
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
168 0.0002 0.0001978874206543
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
169 0.0002 0.00019311904907227
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
170 0.0002 0.00015616416931152
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
171 0.0002 0.00024700164794922
SELECT * FROM pages WHERE id = 38
172 0.0069 0.00685715675354
SELECT DISTINCT p.id FROM products p, productoffers o
            WHERE p.id IN (SELECT product_id FROM productoffers WHERE 1 ) OR p.parent_id IN (SELECT product_id FROM productoffers WHERE 1 ) AND p.parent_id = 0 LIMIT 6
173 0.0006 0.00057101249694824
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:1632133355;s:8:\"products\";a:6:{i:0;s:10:\"790|amazon\";i:1;s:10:\"788|amazon\";i:2;s:10:\"787|amazon\";i:3;s:11:\"1287|amazon\";i:4;s:10:\"779|amazon\";i:5;s:10:\"777|amazon\";}}' WHERE id = '160'
174 0.0005 0.00048494338989258
SELECT * FROM products WHERE id = 790
175 0.0006 0.00058603286743164
SELECT * FROM products WHERE id = 788
176 0.0005 0.00051498413085938
SELECT * FROM products WHERE id = 787
177 0.0006 0.00063705444335938
SELECT * FROM products WHERE id = 1287
178 0.0006 0.00056004524230957
SELECT * FROM products WHERE id = 779
179 0.0005 0.00053596496582031
SELECT * FROM products WHERE id = 777
180 0.0006 0.0005650520324707
SELECT * FROM products WHERE id = '790'
181 0.0005 0.00046896934509277
SELECT * FROM productimages WHERE product_id = '790' ORDER BY sortorder ASC
182 0.0002 0.00020003318786621
SELECT * FROM product_image_select WHERE product_id = '790'
183 0.0002 0.00018906593322754
SELECT * FROM productcustomimages WHERE product_id = '790'
184 0.0002 0.0002291202545166
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.00022697448730469
SELECT * FROM productoffers WHERE product_id = '790' AND merchantid = 'A1X6FK5RDHNB96'
186 0.0003 0.00025796890258789
SELECT * FROM productoffers
                WHERE product_id = '790' AND price > 0
                ORDER BY price ASC LIMIT 1
187 0.0003 0.0003049373626709
SELECT value FROM productattributes WHERE product_id = '790' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
188 0.0004 0.0004420280456543
SELECT * FROM products WHERE id = '788'
189 0.0002 0.0001988410949707
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
190 0.0002 0.00016403198242188
SELECT * FROM product_image_select WHERE product_id = '788'
191 0.0002 0.00018310546875
SELECT * FROM productcustomimages WHERE product_id = '788'
192 0.0002 0.0002291202545166
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.00024294853210449
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
194 0.0002 0.00023293495178223
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
195 0.0002 0.00022697448730469
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
196 0.0004 0.00041103363037109
SELECT * FROM products WHERE id = '787'
197 0.0005 0.00051593780517578
SELECT * FROM productimages WHERE product_id = '787' ORDER BY sortorder ASC
198 0.0007 0.00068902969360352
SELECT * FROM product_image_select WHERE product_id = '787'
199 0.0002 0.00018191337585449
SELECT * FROM productcustomimages WHERE product_id = '787'
200 0.0002 0.00017595291137695
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '787' AND a.name = n.originalname
201 0.0002 0.0002291202545166
SELECT * FROM productoffers WHERE product_id = '787' AND merchantid = 'A1X6FK5RDHNB96'
202 0.0002 0.0002140998840332
SELECT * FROM productoffers
                WHERE product_id = '787' AND price > 0
                ORDER BY price ASC LIMIT 1
203 0.0002 0.0001981258392334
SELECT value FROM productattributes WHERE product_id = '787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
204 0.0005 0.00045299530029297
SELECT * FROM products WHERE id = '1287'
205 0.0004 0.00040006637573242
SELECT * FROM productimages WHERE product_id = '1287' ORDER BY sortorder ASC
206 0.0002 0.00018191337585449
SELECT * FROM product_image_select WHERE product_id = '1287'
207 0.0002 0.00018787384033203
SELECT * FROM productcustomimages WHERE product_id = '1287'
208 0.0003 0.00028300285339355
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.00021815299987793
SELECT * FROM productoffers WHERE product_id = '1287' AND merchantid = 'A1X6FK5RDHNB96'
210 0.0003 0.00026106834411621
SELECT * FROM productoffers
                WHERE product_id = '1287' AND price > 0
                ORDER BY price ASC LIMIT 1
211 0.0004 0.00041794776916504
SELECT value FROM productattributes WHERE product_id = '1287' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
212 0.0005 0.00052213668823242
SELECT * FROM products WHERE id = '779'
213 0.0002 0.00021195411682129
SELECT * FROM productimages WHERE product_id = '779' ORDER BY sortorder ASC
214 0.0002 0.00017905235290527
SELECT * FROM product_image_select WHERE product_id = '779'
215 0.0002 0.00020384788513184
SELECT * FROM productcustomimages WHERE product_id = '779'
216 0.0002 0.00019192695617676
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '779' AND a.name = n.originalname
217 0.0002 0.00020098686218262
SELECT * FROM productoffers WHERE product_id = '779' AND merchantid = 'A1X6FK5RDHNB96'
218 0.0002 0.00019121170043945
SELECT * FROM productoffers
                WHERE product_id = '779' AND price > 0
                ORDER BY price ASC LIMIT 1
219 0.0002 0.0001990795135498
SELECT value FROM productattributes WHERE product_id = '779' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
220 0.0004 0.0004270076751709
SELECT * FROM products WHERE id = '777'
221 0.0002 0.00020003318786621
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
222 0.0002 0.00017499923706055
SELECT * FROM product_image_select WHERE product_id = '777'
223 0.0002 0.0001680850982666
SELECT * FROM productcustomimages WHERE product_id = '777'
224 0.0002 0.00016617774963379
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
225 0.0002 0.0002129077911377
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
226 0.0002 0.00019001960754395
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
227 0.0004 0.00036406517028809
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
228 0.0003 0.0003201961517334
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
229 0.0005 0.00045394897460938
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
230 0.0007 0.00066804885864258
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
231 0.0003 0.00029587745666504
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
232 0.0004 0.00042581558227539
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
233 0.0004 0.00040102005004883
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
234 0.0004 0.00038504600524902
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
235 0.0002 0.00019693374633789
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'