DERRIERE LA PORTE - Boite à boucles d'oreilles rouge DLP -

DERRIERE LA PORTE - Boite à boucles d'oreilles rouge DLP -
DERRIERE LA PORTE - Boite à boucles d'oreilles rouge DLP - DERRIERE LA PORTE - Boite à boucles d'oreilles rouge DLP - DERRIERE LA PORTE - Boite à boucles d'oreilles rouge DLP - DERRIERE LA PORTE - Boite à boucles d'oreilles rouge DLP - DERRIERE LA PORTE - Boite à boucles d'oreilles rouge DLP - (cliquez sur les images pour élargir)
€18,00
Non Disponible Épuisé
Le prix et la disponibilité du produit sont corrects en date du 2021-09-20 13:51:50 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

Longueur?: 22 cm Profondeur?: 14 cm Hauteur?: 5 cm Matière?: Métal Designer?: Valérie Nylin.
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.66340494155884 249 0.1439 0


No Amazon API Requests Made.

Total time 0.66340494155884 seconds

Number Time From Start Name Description
1 0.50020909309387 Initialise Initialise FSB Function
2 0.50210690498352 App Controller Start Start of the App controller (called before the controller of every page)
3 0.50518012046814 Start of getCategoryListByGroup Function Before first category groups query
4 0.50543904304504 After initial query Before first category groups query
5 0.50544095039368 Get Category List for Group Before the call to getCategoryList function
6 0.50544404983521 Start of GetCategoryList function Start of the function
7 0.50544810295105 Before getting categories Query to get specific category list
8 0.50586700439453 After getting categories Query to get specific category list
9 0.50586891174316 Before getting category custom Before call to function getCategoryCustom
10 0.50851511955261 After getting category custom After call to function getCategoryCustom
11 0.50851798057556 Before getting category custom Before call to function getCategoryCustom
12 0.5192539691925 After getting category custom After call to function getCategoryCustom
13 0.51925611495972 Before getting category custom Before call to function getCategoryCustom
14 0.52389311790466 After getting category custom After call to function getCategoryCustom
15 0.52389597892761 Before getting category custom Before call to function getCategoryCustom
16 0.52657198905945 After getting category custom After call to function getCategoryCustom
17 0.52657508850098 Before getting category custom Before call to function getCategoryCustom
18 0.52916502952576 After getting category custom After call to function getCategoryCustom
19 0.52916812896729 Before getting category custom Before call to function getCategoryCustom
20 0.53194308280945 After getting category custom After call to function getCategoryCustom
21 0.53194499015808 End of GetCategoryList function End of the function
22 0.53195190429688 End of getCategoryListByGroup Function Before return()
23 0.5356559753418 App Controller End End of the App controller (called before the controller of every page)
24 0.53609299659729 Product Start Start of the product info controller
25 0.53889298439026 Cache file not found Starting get product details
26 0.57132005691528 Related products Start getting related products if enabled
27 0.57132291793823 Related Products Start Before the related products are found
28 0.57132411003113 Related Products Keywords Before the related product keywords are found
29 0.57132911682129 Create Keyword List Function Start of function
30 0.57136607170105 Create Keyword List Function After looping provided content - 24 keywords found
31 0.57229995727539 Create Keyword List Function After looping initial keyword list - 21 keywords remaining
32 0.57230806350708 Create Keyword List Function After reducing keyword list
33 0.5723569393158 Create Keyword List Function After selecting by scoring keywords
34 0.57236099243164 Create Keyword List Function After final loop of keywords
35 0.57236289978027 Related Products Keywords After the related product keywords are found
36 0.59777498245239 Related Products End After the related products are found
37 0.60608696937561 Product End End of the product info controller (Product Info)
38 0.6070020198822 App_after Controller Start Start of the App_after controller (called after the controller of every page)
39 0.60770606994629 Before Get Options Before the call to getOptions in the tpl class
40 0.64582204818726 After Get Options After the call to getOptions in the tpl class
41 0.64591908454895 App_after Controller End End of the App_after controller (called after the controller of every page)
42 0.64595198631287 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
43 0.65114903450012 Product Info: After Smarty Fetch After the product.tpl template is fetched
44 0.65115404129028 Product Info: Before Template Display Before the template is displayed
45 0.6633620262146 Product Info: After Template Display After the template is displayed
46 0.66338706016541 Finalizing debug Before the debug is output to the page.
47 0.66340398788452 End of App This is the end of the app logging, final timestamp


Query Debug - 249 Database Queries. Total time 0.1439 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0005 0.00046396255493164
SELECT parameter, value FROM parameters
2 0.0010 0.0010030269622803
SELECT * FROM `bad_bots`
3 0.0005 0.00052189826965332
SET time_zone = 'Europe/London'
4 0.0004 0.00039196014404297
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0025 0.0024712085723877
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"34.231.247.88\";}'
6 0.0015 0.0015161037445068
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1653727115'
7 0.0005 0.00048303604125977
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0003 0.00034213066101074
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0006 0.00057315826416016
SELECT id FROM pages WHERE pagename = 'derriere-la-porte-boite-boucles-doreilles-rouge-dlp-' LIMIT 1
10 0.0006 0.00061511993408203
SELECT id FROM products WHERE pagename = 'derriere-la-porte-boite-boucles-doreilles-rouge-dlp-' AND hidden = 0 LIMIT 1
11 0.0012 0.0012269020080566
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
12 0.0009 0.00085687637329102
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
13 0.0006 0.00057888031005859
SELECT * FROM pages WHERE pagename = 'derriere-la-porte-boite-boucles-doreilles-rouge-dlp-'
14 0.0002 0.00024604797363281
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0004 0.00039911270141602
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0003 0.0003359317779541
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.00033116340637207
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.00032687187194824
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0004 0.00037908554077148
SELECT id FROM categories WHERE parent_id = '26'
20 0.0003 0.00026607513427734
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.00026893615722656
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.00021219253540039
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.00019478797912598
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0002 0.00020098686218262
SELECT * FROM categorygroups WHERE id = '1'
25 0.0047 0.0046918392181396
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.00020599365234375
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.00020813941955566
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0002 0.00018692016601562
SELECT id FROM categories WHERE parent_id = '27'
29 0.0043 0.0043070316314697
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.00040316581726074
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.00023698806762695
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.00019598007202148
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0002 0.00018596649169922
SELECT * FROM categorygroups WHERE id = '1'
34 0.0016 0.0016050338745117
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.0002140998840332
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.00019693374633789
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0002 0.00018596649169922
SELECT id FROM categories WHERE parent_id = '28'
38 0.0016 0.0015730857849121
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.0002 0.00020599365234375
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.00018906593322754
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.00017690658569336
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0002 0.00018310546875
SELECT * FROM categorygroups WHERE id = '1'
43 0.0006 0.00057792663574219
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.00023293495178223
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.00020003318786621
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0002 0.00020098686218262
SELECT id FROM categories WHERE parent_id = '29'
47 0.0005 0.00054192543029785
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.00023412704467773
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.00020813941955566
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.00019598007202148
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0002 0.0001828670501709
SELECT * FROM categorygroups WHERE id = '1'
52 0.0005 0.00053310394287109
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.00022292137145996
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.00019407272338867
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0002 0.00018596649169922
SELECT id FROM categories WHERE parent_id = '30'
56 0.0005 0.00054407119750977
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.0001981258392334
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.00018501281738281
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.00020694732666016
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0002 0.00021195411682129
SELECT * FROM categorygroups WHERE id = '1'
61 0.0005 0.00053906440734863
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.00025486946105957
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.00024604797363281
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0002 0.00022006034851074
SELECT id FROM categories WHERE parent_id = '31'
65 0.0006 0.00061988830566406
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.0002138614654541
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.00020408630371094
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.00018787384033203
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0002 0.00018620491027832
SELECT * FROM categorygroups WHERE id = '1'
70 0.0002 0.00021600723266602
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
71 0.0003 0.00025105476379395
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
72 0.0002 0.00022602081298828
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.0001990795135498
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
74 0.0005 0.00045013427734375
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
75 0.0005 0.0004580020904541
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
76 0.0002 0.00024008750915527
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.0002 0.00023102760314941
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
78 0.0002 0.00021791458129883
SELECT * FROM countryredirects WHERE countrycode = 'US'
79 0.0007 0.00071501731872559
SELECT * FROM products WHERE pagename = 'derriere-la-porte-boite-boucles-doreilles-rouge-dlp-'
80 0.0016 0.0015718936920166
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1291
81 0.0004 0.00037813186645508
SELECT * FROM manufacturers WHERE id = '210'
82 0.0006 0.00064802169799805
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '210'
83 0.0002 0.00019693374633789
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '210' LIMIT 1
84 0.0010 0.00098896026611328
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '210' ORDER BY RAND() LIMIT 1
85 0.0018 0.0017778873443604
SELECT * FROM productimages WHERE product_id = '1051' ORDER BY sortorder ASC
86 0.0002 0.0002448558807373
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '210'
87 0.0007 0.00065088272094727
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '210'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
88 0.0003 0.00029301643371582
SELECT * FROM manufacturerimages WHERE manufacturer_id = '210'
89 0.0004 0.00044989585876465
SELECT category_id FROM products_categories WHERE product_id = '1291'
90 0.0004 0.00035405158996582
SELECT * FROM categories WHERE id = '26'
91 0.0073 0.0073249340057373
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
92 0.0002 0.00022101402282715
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
93 0.0003 0.00026202201843262
SELECT id FROM categories WHERE parent_id = '26'
94 0.0093 0.0092959403991699
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 
95 0.0002 0.00022983551025391
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 
96 0.0002 0.00020909309387207
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
97 0.0002 0.00021696090698242
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
98 0.0010 0.00097918510437012
SELECT * FROM productimages WHERE product_id = '1291' ORDER BY sortorder ASC
99 0.0005 0.00051498413085938
SELECT * FROM product_image_select WHERE product_id = '1291'
100 0.0004 0.00043916702270508
SELECT * FROM productcustomimages WHERE product_id = '1291'
101 0.0004 0.0004119873046875
SELECT * FROM productfeeds WHERE product_id = '1291' ORDER BY item_date DESC
102 0.0005 0.00051712989807129
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '1291' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
103 0.0007 0.0006871223449707
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '1291' AND t.hidden = 0 AND display_product = 1
104 0.0006 0.00061798095703125
SELECT * FROM productamazoncontent WHERE product_id = '1291'
105 0.0009 0.00094199180603027
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1291' AND a.name = n.originalname
106 0.0005 0.0004880428314209
SELECT * FROM productoffers WHERE product_id = '1291' AND merchantid = 'A1X6FK5RDHNB96'
107 0.0004 0.00043511390686035
SELECT * FROM productoffers
                WHERE product_id = '1291' AND price > 0
                ORDER BY price ASC LIMIT 1
108 0.0005 0.00051593780517578
SELECT * FROM productoffers
                WHERE product_id = 1291
                ORDER BY price ASC LIMIT 1
109 0.0005 0.00050687789916992
SELECT value FROM productattributes
                WHERE product_id = '1291'
                AND name = 'ListPriceAmount'
110 0.0005 0.00052905082702637
SELECT value FROM productattributes WHERE product_id = '1291' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
111 0.0003 0.00033307075500488
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.0077 0.0076720714569092
SELECT *, MATCH (description, title) AGAINST ('derriere la porte' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('derriere la porte' IN BOOLEAN MODE) AND 1291 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
113 0.0006 0.00062394142150879
SELECT *, MATCH (description, title) AGAINST ('derriere la porte' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('derriere la porte' IN BOOLEAN MODE) AND 1291 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
114 0.0005 0.00045394897460938
SELECT *, MATCH (description, title) AGAINST ('derriere la porte' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('derriere la porte' IN BOOLEAN MODE) AND 1291 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
115 0.0004 0.00040292739868164
SELECT * FROM productimages WHERE product_id = '1354' ORDER BY sortorder ASC
116 0.0003 0.00031900405883789
SELECT * FROM product_image_select WHERE product_id = '1354'
117 0.0003 0.00031304359436035
SELECT * FROM productcustomimages WHERE product_id = '1354'
118 0.0003 0.00028896331787109
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1354' AND a.name = n.originalname
119 0.0004 0.00040984153747559
SELECT * FROM productoffers WHERE product_id = '1354' AND merchantid = 'A1X6FK5RDHNB96'
120 0.0004 0.00042414665222168
SELECT * FROM productoffers
                WHERE product_id = '1354' AND price > 0
                ORDER BY price ASC LIMIT 1
121 0.0003 0.00030899047851562
SELECT value FROM productattributes WHERE product_id = '1354' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
122 0.0005 0.00047397613525391
SELECT * FROM productimages WHERE product_id = '850' ORDER BY sortorder ASC
123 0.0008 0.00075292587280273
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '850' AND p.id = pi.product_id ORDER BY pi.sortorder
124 0.0003 0.00028491020202637
SELECT * FROM product_image_select WHERE product_id = '850'
125 0.0002 0.00022101402282715
SELECT * FROM productcustomimages WHERE product_id = '850'
126 0.0008 0.00076484680175781
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '850'
                GROUP BY o.product_id
127 0.0006 0.0006098747253418
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '850'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
128 0.0004 0.00037693977355957
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 850
129 0.0002 0.00023293495178223
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '850' AND a.name = n.originalname
130 0.0003 0.00034403800964355
SELECT * FROM productoffers WHERE product_id = '850' AND merchantid = 'A1X6FK5RDHNB96'
131 0.0004 0.00038695335388184
SELECT * FROM productoffers
                WHERE product_id = '850' AND price > 0
                ORDER BY price ASC LIMIT 1
132 0.0004 0.00040006637573242
SELECT * FROM productoffers
                WHERE product_id = 850
                ORDER BY price ASC LIMIT 1
133 0.0003 0.00033211708068848
SELECT value FROM productattributes
                WHERE product_id = '850'
                AND name = 'ListPriceAmount'
134 0.0003 0.00033712387084961
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '850'
                GROUP BY o.product_id
135 0.0003 0.00033903121948242
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '850'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
136 0.0003 0.00026488304138184
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 850
137 0.0002 0.00023102760314941
SELECT value FROM productattributes WHERE product_id = '850' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
138 0.0008 0.00078606605529785
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '850'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
139 0.0006 0.00058698654174805
SELECT * FROM products WHERE parent_id = '850'
140 0.0003 0.0002589225769043
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4891' AND a.name = n.originalname
141 0.0004 0.00044584274291992
SELECT * FROM productoffers WHERE product_id = '4891' AND merchantid = 'A1X6FK5RDHNB96'
142 0.0004 0.00043988227844238
SELECT * FROM productoffers
                WHERE product_id = '4891' AND price > 0
                ORDER BY price ASC LIMIT 1
143 0.0011 0.0011289119720459
SELECT * FROM productimages WHERE product_id = '1422' ORDER BY sortorder ASC
144 0.0004 0.00035190582275391
SELECT * FROM product_image_select WHERE product_id = '1422'
145 0.0005 0.00046086311340332
SELECT * FROM productcustomimages WHERE product_id = '1422'
146 0.0009 0.00091791152954102
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1422' AND a.name = n.originalname
147 0.0005 0.00048184394836426
SELECT * FROM productoffers WHERE product_id = '1422' AND merchantid = 'A1X6FK5RDHNB96'
148 0.0005 0.00046086311340332
SELECT * FROM productoffers
                WHERE product_id = '1422' AND price > 0
                ORDER BY price ASC LIMIT 1
149 0.0005 0.00045609474182129
SELECT value FROM productattributes WHERE product_id = '1422' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
150 0.0004 0.00042390823364258
SELECT id,asin FROM products WHERE parent_id = 1291
151 0.0002 0.00021505355834961
SELECT category_id FROM products_categories WHERE product_id = '1291'
152 0.0002 0.00022411346435547
SELECT * FROM categories WHERE id = '26'
153 0.0002 0.00019288063049316
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
154 0.0002 0.00017714500427246
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
155 0.0002 0.00021910667419434
SELECT id FROM categories WHERE parent_id = '26'
156 0.0002 0.0001990795135498
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 
157 0.0002 0.00019216537475586
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 
158 0.0002 0.00018882751464844
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
159 0.0002 0.00019407272338867
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
160 0.0002 0.00020408630371094
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1291' AND a.name = n.originalname
161 0.0002 0.00022101402282715
SELECT * FROM productoffers WHERE product_id = '1291' AND merchantid = 'A1X6FK5RDHNB96'
162 0.0002 0.00021791458129883
SELECT * FROM productoffers
                WHERE product_id = '1291' AND price > 0
                ORDER BY price ASC LIMIT 1
163 0.0002 0.00020194053649902
SELECT * FROM productoffers
                WHERE product_id = 1291
                ORDER BY price ASC LIMIT 1
164 0.0002 0.00017809867858887
SELECT value FROM productattributes
                WHERE product_id = '1291'
                AND name = 'ListPriceAmount'
165 0.0005 0.00051188468933105
SELECT * FROM products WHERE id = '1291'
166 0.0002 0.00020503997802734
SELECT value FROM productattributes WHERE product_id = '1291' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
167 0.0002 0.00022792816162109
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1291' AND a.name = n.originalname
168 0.0003 0.00034284591674805
SELECT * FROM productoffers WHERE product_id = '1291' AND merchantid = 'A1X6FK5RDHNB96'
169 0.0005 0.00051188468933105
SELECT * FROM productoffers
                WHERE product_id = '1291' AND price > 0
                ORDER BY price ASC LIMIT 1
170 0.0004 0.00042414665222168
SELECT * FROM productoffers
                WHERE product_id = 1291
                ORDER BY price ASC LIMIT 1
171 0.0002 0.00020885467529297
SELECT value FROM productattributes
                WHERE product_id = '1291'
                AND name = 'ListPriceAmount'
172 0.0004 0.00035881996154785
SELECT category_id FROM products_categories WHERE product_id = '1291' AND prod_type = 'amz'
173 0.0003 0.00026392936706543
SELECT parent_id FROM categories WHERE id = '26'
174 0.0002 0.00023698806762695
SELECT * FROM categories WHERE id = '26'
175 0.0002 0.00019598007202148
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
176 0.0002 0.0001981258392334
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
177 0.0002 0.00020194053649902
SELECT id FROM categories WHERE parent_id = '26'
178 0.0002 0.00020503997802734
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 
179 0.0002 0.00017905235290527
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 
180 0.0002 0.00017809867858887
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
181 0.0002 0.00019383430480957
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
182 0.0005 0.00047087669372559
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
183 0.0003 0.00025105476379395
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
184 0.0004 0.00037622451782227
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
185 0.0004 0.00043106079101562
SELECT * FROM pages WHERE id = 38
186 0.0039 0.0039029121398926
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
187 0.0008 0.00078296661376953
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:1653727115;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'
188 0.0006 0.00059604644775391
SELECT * FROM products WHERE id = 788
189 0.0009 0.0008699893951416
SELECT * FROM products WHERE id = 787
190 0.0027 0.0026979446411133
SELECT * FROM products WHERE id = 1287
191 0.0006 0.00055193901062012
SELECT * FROM products WHERE id = 780
192 0.0006 0.00061511993408203
SELECT * FROM products WHERE id = 777
193 0.0005 0.00054383277893066
SELECT * FROM products WHERE id = 776
194 0.0068 0.0067679882049561
SELECT * FROM products WHERE id = '788'
195 0.0004 0.0003819465637207
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
196 0.0003 0.00030303001403809
SELECT * FROM product_image_select WHERE product_id = '788'
197 0.0002 0.0002131462097168
SELECT * FROM productcustomimages WHERE product_id = '788'
198 0.0004 0.00037693977355957
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
199 0.0002 0.00024294853210449
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
200 0.0002 0.00024795532226562
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
201 0.0002 0.00022292137145996
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
202 0.0005 0.00050997734069824
SELECT * FROM products WHERE id = '787'
203 0.0002 0.00022697448730469
SELECT * FROM productimages WHERE product_id = '787' ORDER BY sortorder ASC
204 0.0002 0.00020408630371094
SELECT * FROM product_image_select WHERE product_id = '787'
205 0.0002 0.0001990795135498
SELECT * FROM productcustomimages WHERE product_id = '787'
206 0.0002 0.00020694732666016
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '787' AND a.name = n.originalname
207 0.0002 0.00022697448730469
SELECT * FROM productoffers WHERE product_id = '787' AND merchantid = 'A1X6FK5RDHNB96'
208 0.0003 0.00025606155395508
SELECT * FROM productoffers
                WHERE product_id = '787' AND price > 0
                ORDER BY price ASC LIMIT 1
209 0.0002 0.00024104118347168
SELECT value FROM productattributes WHERE product_id = '787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
210 0.0005 0.00049686431884766
SELECT * FROM products WHERE id = '1287'
211 0.0004 0.00043082237243652
SELECT * FROM productimages WHERE product_id = '1287' ORDER BY sortorder ASC
212 0.0005 0.0004889965057373
SELECT * FROM product_image_select WHERE product_id = '1287'
213 0.0004 0.00035905838012695
SELECT * FROM productcustomimages WHERE product_id = '1287'
214 0.0004 0.00043201446533203
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1287' AND a.name = n.originalname
215 0.0003 0.00025486946105957
SELECT * FROM productoffers WHERE product_id = '1287' AND merchantid = 'A1X6FK5RDHNB96'
216 0.0002 0.00023078918457031
SELECT * FROM productoffers
                WHERE product_id = '1287' AND price > 0
                ORDER BY price ASC LIMIT 1
217 0.0002 0.00021600723266602
SELECT value FROM productattributes WHERE product_id = '1287' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
218 0.0005 0.00048494338989258
SELECT * FROM products WHERE id = '780'
219 0.0003 0.0002739429473877
SELECT * FROM productimages WHERE product_id = '780' ORDER BY sortorder ASC
220 0.0002 0.00020885467529297
SELECT * FROM product_image_select WHERE product_id = '780'
221 0.0002 0.00020599365234375
SELECT * FROM productcustomimages WHERE product_id = '780'
222 0.0004 0.0003511905670166
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '780' AND a.name = n.originalname
223 0.0004 0.00044488906860352
SELECT * FROM productoffers WHERE product_id = '780' AND merchantid = 'A1X6FK5RDHNB96'
224 0.0005 0.00047087669372559
SELECT * FROM productoffers
                WHERE product_id = '780' AND price > 0
                ORDER BY price ASC LIMIT 1
225 0.0003 0.00025677680969238
SELECT value FROM productattributes WHERE product_id = '780' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
226 0.0006 0.00060606002807617
SELECT * FROM products WHERE id = '777'
227 0.0002 0.00024104118347168
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
228 0.0004 0.00037884712219238
SELECT * FROM product_image_select WHERE product_id = '777'
229 0.0004 0.00040292739868164
SELECT * FROM productcustomimages WHERE product_id = '777'
230 0.0005 0.00048208236694336
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
231 0.0003 0.00032711029052734
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
232 0.0003 0.00029110908508301
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
233 0.0003 0.0003199577331543
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
234 0.0007 0.00070095062255859
SELECT * FROM products WHERE id = '776'
235 0.0004 0.00037002563476562
SELECT * FROM productimages WHERE product_id = '776' ORDER BY sortorder ASC
236 0.0003 0.00032901763916016
SELECT * FROM product_image_select WHERE product_id = '776'
237 0.0003 0.00025296211242676
SELECT * FROM productcustomimages WHERE product_id = '776'
238 0.0004 0.00038695335388184
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '776' AND a.name = n.originalname
239 0.0003 0.00030708312988281
SELECT * FROM productoffers WHERE product_id = '776' AND merchantid = 'A1X6FK5RDHNB96'
240 0.0002 0.0002439022064209
SELECT * FROM productoffers
                WHERE product_id = '776' AND price > 0
                ORDER BY price ASC LIMIT 1
241 0.0002 0.00022077560424805
SELECT value FROM productattributes WHERE product_id = '776' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
242 0.0004 0.0003819465637207
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
243 0.0003 0.00034785270690918
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
244 0.0007 0.0007169246673584
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
245 0.0004 0.00040698051452637
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
246 0.0005 0.00054693222045898
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
247 0.0006 0.00055813789367676
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
248 0.0005 0.00045013427734375
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
249 0.0003 0.00029611587524414
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'