0

SUPERLOVE Mini-boîtes À Thé Scellées Universelles en Métal Boîte À Thé De Voyage Portable Boîte Écologique Étanche À L'humidité Scellée Et sans Odeur

Price: Click Button for Price
Product prices and availability are accurate as of 2021-07-20 04:32:36 UTC and are subject to change. Any price and availability information displayed on https://www.amazon.fr/ at the time of purchase will apply to the purchase of this product.
CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED 'AS IS' AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME.

Product Features

100% neuf de haute qualité. Fait de fer-blanc, il est sûr et durable. Sans odeur, scellé et résistant à l'humidité avec une peinture écologique. Rangez une variété d'articles ménagers et de collations telles que du thé, du café, des sucreries, des biscuits ou autres. Convient pour les familles, les cafétérias, restaurants, etc.

There are no customer reviews yet. Be the first to Write a Review!

Wait! We have a something for you...

Don't leave empty-handed! Simply enter your email below and we will send you a great discount on our products:

We hate spam as much as you do! Your details are never shared and you can unsubscribe at any time.

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
2.2346980571747 336 1.9716 0


No Amazon API Requests Made.


App Debug - Total Time 2.2346980571747 seconds

Number Time From Start Name Description
1 0.25353002548218 Initialise Initialise FSB Function
2 0.26175117492676 App Controller Start Start of the App controller (called before the controller of every page)
3 0.29189896583557 Start of getCategoryListByGroup Function Before first category groups query
4 0.2936589717865 After initial query Before first category groups query
5 0.29366016387939 Get Category List for Group Before the call to getCategoryList function
6 0.29366207122803 Start of GetCategoryList function Start of the function
7 0.29366397857666 Before getting categories Query to get specific category list
8 0.29557299613953 After getting categories Query to get specific category list
9 0.29557299613953 Before getting category custom Before call to function getCategoryCustom
10 0.32441902160645 After getting category custom After call to function getCategoryCustom
11 0.32442116737366 Before getting category custom Before call to function getCategoryCustom
12 0.35922312736511 After getting category custom After call to function getCategoryCustom
13 0.35922503471375 Before getting category custom Before call to function getCategoryCustom
14 0.36589312553406 After getting category custom After call to function getCategoryCustom
15 0.36589503288269 Before getting category custom Before call to function getCategoryCustom
16 0.37015795707703 After getting category custom After call to function getCategoryCustom
17 0.37016010284424 Before getting category custom Before call to function getCategoryCustom
18 0.37493705749512 After getting category custom After call to function getCategoryCustom
19 0.37493896484375 Before getting category custom Before call to function getCategoryCustom
20 0.38097596168518 After getting category custom After call to function getCategoryCustom
21 0.38097906112671 End of GetCategoryList function End of the function
22 0.38098406791687 Get Category List for Group Before the call to getCategoryList function
23 0.3809859752655 Start of GetCategoryList function Start of the function
24 0.3809871673584 Before getting categories Query to get specific category list
25 0.38154101371765 End of getCategoryListByGroup Function Before return()
26 1.8771641254425 App Controller End End of the App controller (called before the controller of every page)
27 1.8776910305023 Product Start Start of the product info controller
28 1.8857450485229 Cache file not found Starting get product details
29 1.9446501731873 Related products Start getting related products if enabled
30 1.9446511268616 Related Products Start Before the related products are found
31 1.9446520805359 Related Products Keywords Before the related product keywords are found
32 1.9446551799774 Create Keyword List Function Start of function
33 1.9447400569916 Create Keyword List Function After looping provided content - 61 keywords found
34 1.9458091259003 Create Keyword List Function After looping initial keyword list - 57 keywords remaining
35 1.9458150863647 Create Keyword List Function After reducing keyword list
36 1.945974111557 Create Keyword List Function After selecting by scoring keywords
37 1.94597697258 Create Keyword List Function After final loop of keywords
38 1.9459781646729 Related Products Keywords After the related product keywords are found
39 2.0995140075684 Related Products End After the related products are found
40 2.1561660766602 Product End End of the product info controller (Product Info)
41 2.1571640968323 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 2.1580791473389 Before Get Options Before the call to getOptions in the tpl class
43 2.2133569717407 After Get Options After the call to getOptions in the tpl class
44 2.2134711742401 App_after Controller End End of the App_after controller (called after the controller of every page)
45 2.2134909629822 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 2.2165060043335 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 2.2165081501007 Product Info: Before Template Display Before the template is displayed
48 2.2346811294556 Product Info: After Template Display After the template is displayed
49 2.234689950943 Finalizing debug Before the debug is output to the page.
50 2.2346980571747 End of App This is the end of the app logging, final timestamp


Query Debug - 336 Database Queries. Total time 1.9716 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0018 0.0018389225006104
SELECT parameter, value FROM parameters
2 0.0082 0.008181095123291
SELECT * FROM `bad_bots`
3 0.0004 0.00044608116149902
SET time_zone = 'Europe/London'
4 0.0035 0.00345778465271
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0029 0.0029139518737793
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:11:\"3.143.235.3\";}'
6 0.0025 0.0025491714477539
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1746036189'
7 0.0028 0.0028009414672852
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0037 0.0037209987640381
UPDATE autorun SET lastrun = '2025-04-30 18:03:09' WHERE id = '13'
9 0.0011 0.0010590553283691
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0030 0.0030498504638672
SELECT id FROM pages WHERE pagename = 'superlove-mini-botes-the-scellees-universelles-en-metal-bote-the-de' LIMIT 1
11 0.0035 0.0035018920898438
SELECT id FROM products WHERE pagename = 'superlove-mini-botes-the-scellees-universelles-en-metal-bote-the-de' AND hidden = 0 LIMIT 1
12 0.0033 0.0032889842987061
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13 0.0258 0.025799989700317
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14 0.0007 0.00066304206848145
SELECT * FROM pages WHERE pagename = 'superlove-mini-botes-the-scellees-universelles-en-metal-bote-the-de'
15 0.0018 0.0017530918121338
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0019 0.0018978118896484
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0103 0.010293960571289
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
18 0.0031 0.0030539035797119
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
19 0.0016 0.0015909671783447
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20 0.0005 0.00048303604125977
SELECT id FROM categories WHERE parent_id = '26'
21 0.0062 0.0061659812927246
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 
22 0.0024 0.0023720264434814
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 
23 0.0023 0.0023221969604492
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
24 0.0019 0.001939058303833
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25 0.0006 0.00057411193847656
SELECT * FROM categorygroups WHERE id = '1'
26 0.0088 0.0087599754333496
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
27 0.0131 0.013116836547852
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
28 0.0022 0.0022351741790771
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29 0.0006 0.00055599212646484
SELECT id FROM categories WHERE parent_id = '27'
30 0.0072 0.00718092918396
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 
31 0.0008 0.00084090232849121
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 
32 0.0008 0.00084304809570312
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
33 0.0008 0.00075602531433105
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34 0.0005 0.00046014785766602
SELECT * FROM categorygroups WHERE id = '1'
35 0.0017 0.0017259120941162
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
36 0.0006 0.00057888031005859
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
37 0.0004 0.00039386749267578
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38 0.0005 0.00045895576477051
SELECT id FROM categories WHERE parent_id = '28'
39 0.0016 0.0015549659729004
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 
40 0.0005 0.00050783157348633
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 
41 0.0006 0.00059199333190918
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
42 0.0005 0.00045180320739746
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43 0.0004 0.00035810470581055
SELECT * FROM categorygroups WHERE id = '1'
44 0.0006 0.00062918663024902
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
45 0.0005 0.00045108795166016
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
46 0.0004 0.00035405158996582
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47 0.0004 0.00036907196044922
SELECT id FROM categories WHERE parent_id = '29'
48 0.0006 0.00059199333190918
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 
49 0.0004 0.00044012069702148
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 
50 0.0005 0.00051712989807129
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
51 0.0004 0.00042009353637695
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52 0.0004 0.00043916702270508
SELECT * FROM categorygroups WHERE id = '1'
53 0.0006 0.00061392784118652
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
54 0.0006 0.00063490867614746
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
55 0.0004 0.00037598609924316
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56 0.0004 0.00038909912109375
SELECT id FROM categories WHERE parent_id = '30'
57 0.0007 0.00067806243896484
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 
58 0.0005 0.00052499771118164
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 
59 0.0006 0.00055718421936035
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
60 0.0005 0.00051283836364746
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61 0.0004 0.00043988227844238
SELECT * FROM categorygroups WHERE id = '1'
62 0.0006 0.00064992904663086
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
63 0.0006 0.00061607360839844
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
64 0.0004 0.00042986869812012
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65 0.0005 0.00049591064453125
SELECT id FROM categories WHERE parent_id = '31'
66 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 (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
67 0.0010 0.0010299682617188
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 
68 0.0007 0.00067806243896484
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
69 0.0006 0.00057101249694824
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70 0.0005 0.00054597854614258
SELECT * FROM categorygroups WHERE id = '1'
71 0.0005 0.00054693222045898
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
72 0.0037 0.0037369728088379
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73 0.0064 0.0064449310302734
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74 0.0014 0.0013999938964844
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
75 0.0059 0.005878210067749
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76 0.0037 0.0037281513214111
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77 0.0016 0.0016460418701172
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78 1.4676 1.4675898551941
SELECT * FROM ipgeocountries WHERE INET_ATON('3.143.235.3') >= INET_ATON(ip_start) AND INET_ATON('3.143.235.3') <= INET_ATON(ip_end)
79 0.0024 0.002406120300293
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80 0.0012 0.0011510848999023
SELECT * FROM countryredirects WHERE countrycode = 'US'
81 0.0006 0.00057291984558105
SELECT * FROM products WHERE pagename = 'superlove-mini-botes-the-scellees-universelles-en-metal-bote-the-de'
82 0.0003 0.00034713745117188
UPDATE products SET viewcount = viewcount + 1 WHERE id = 3134
83 0.0005 0.00054597854614258
SELECT * FROM manufacturers WHERE id = '498'
84 0.0005 0.0004570484161377
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '498'
85 0.0015 0.0015339851379395
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '498' LIMIT 1
86 0.0017 0.0016679763793945
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '498' ORDER BY RAND() LIMIT 1
87 0.0004 0.0003819465637207
SELECT * FROM productimages WHERE product_id = '3134' ORDER BY sortorder ASC
88 0.0004 0.00038695335388184
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '498'
89 0.0005 0.00046110153198242
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '498'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
90 0.0003 0.00034403800964355
SELECT * FROM manufacturerimages WHERE manufacturer_id = '498'
91 0.0004 0.00040102005004883
SELECT category_id FROM products_categories WHERE product_id = '3134'
92 0.0004 0.00041699409484863
SELECT * FROM categories WHERE id = '26'
93 0.0066 0.0065939426422119
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
94 0.0004 0.00041508674621582
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
95 0.0003 0.00029397010803223
SELECT id FROM categories WHERE parent_id = '26'
96 0.0060 0.0060350894927979
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 
97 0.0005 0.00046491622924805
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 
98 0.0005 0.00048613548278809
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
99 0.0004 0.0003969669342041
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
100 0.0004 0.00038909912109375
SELECT * FROM productimages WHERE product_id = '3134' ORDER BY sortorder ASC
101 0.0005 0.00049304962158203
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3134' AND p.id = pi.product_id ORDER BY pi.sortorder
102 0.0015 0.0015060901641846
SELECT * FROM product_image_select WHERE product_id = '3134'
103 0.0011 0.0010888576507568
SELECT * FROM productcustomimages WHERE product_id = '3134'
104 0.0010 0.0010437965393066
SELECT * FROM productfeeds WHERE product_id = '3134' ORDER BY item_date DESC
105 0.0021 0.0020761489868164
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '3134' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
106 0.0020 0.0020358562469482
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '3134' AND t.hidden = 0 AND display_product = 1
107 0.0003 0.00029802322387695
SELECT * FROM tags WHERE id = '216'
108 0.0029 0.0029158592224121
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '216'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
109 0.0027 0.0026581287384033
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '216'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
110 0.0029 0.0028688907623291
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '216' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
111 0.0005 0.00047516822814941
SELECT * FROM productimages WHERE product_id = '4122' ORDER BY sortorder ASC
112 0.0003 0.00026893615722656
SELECT * FROM tags WHERE id = '62'
113 0.0018 0.001755952835083
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '62'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
114 0.0019 0.0019471645355225
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '62'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
115 0.0020 0.0020148754119873
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '62' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
116 0.0005 0.00052499771118164
SELECT * FROM productimages WHERE product_id = '1215' ORDER BY sortorder ASC
117 0.0022 0.002223014831543
SELECT * FROM productamazoncontent WHERE product_id = '3134'
118 0.0017 0.0016539096832275
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 = '3134'
                GROUP BY o.product_id
119 0.0028 0.0028018951416016
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     = '3134'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
120 0.0005 0.00047206878662109
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3134
121 0.0008 0.00081801414489746
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3134' AND a.name = n.originalname
122 0.0003 0.0003199577331543
SELECT * FROM productoffers WHERE product_id = '3134' AND merchantid = 'A1X6FK5RDHNB96'
123 0.0003 0.00030779838562012
SELECT * FROM productoffers
                WHERE product_id = '3134' AND price > 0
                ORDER BY price ASC LIMIT 1
124 0.0003 0.00030803680419922
SELECT * FROM productoffers
                WHERE product_id = 3134
                ORDER BY price ASC LIMIT 1
125 0.0003 0.00032496452331543
SELECT value FROM productattributes
                WHERE product_id = '3134'
                AND name = 'ListPriceAmount'
126 0.0004 0.00036787986755371
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 = '3134'
                GROUP BY o.product_id
127 0.0009 0.0008540153503418
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     = '3134'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
128 0.0005 0.0004730224609375
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3134
129 0.0006 0.00056219100952148
SELECT value FROM productattributes WHERE product_id = '3134' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
130 0.0007 0.00074315071105957
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3134'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
131 0.0006 0.00058603286743164
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
132 0.0041 0.0040938854217529
SELECT *, MATCH (description, title) AGAINST ('à thé' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('à thé' IN BOOLEAN MODE) AND 3134 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
133 0.0007 0.00066399574279785
SELECT *, MATCH (description, title) AGAINST ('à thé' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('à thé' IN BOOLEAN MODE) AND 3134 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
134 0.0006 0.00056600570678711
SELECT *, MATCH (description, title) AGAINST ('à thé' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('à thé' IN BOOLEAN MODE) AND 3134 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
135 0.0293 0.029262065887451
SELECT *, MATCH (description, title) AGAINST ('portable boÃte Ãcologique' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('portable boÃte Ãcologique' IN BOOLEAN MODE) AND 3134 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
136 0.0005 0.00048685073852539
SELECT *, MATCH (description, title) AGAINST ('portable boÃte Ãcologique' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('portable boÃte Ãcologique' IN BOOLEAN MODE) AND 3134 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
137 0.0004 0.00041580200195312
SELECT *, MATCH (description, title) AGAINST ('portable boÃte Ãcologique' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('portable boÃte Ãcologique' IN BOOLEAN MODE) AND 3134 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
138 0.0005 0.00049901008605957
SELECT * FROM productimages WHERE product_id = '2633' ORDER BY sortorder ASC
139 0.0006 0.00056910514831543
SELECT * FROM product_image_select WHERE product_id = '2633'
140 0.0029 0.0029489994049072
SELECT * FROM productcustomimages WHERE product_id = '2633'
141 0.0089 0.0088891983032227
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2633' AND a.name = n.originalname
142 0.0009 0.00085711479187012
SELECT * FROM productoffers WHERE product_id = '2633' AND merchantid = 'A1X6FK5RDHNB96'
143 0.0022 0.0022449493408203
SELECT * FROM productoffers
                WHERE product_id = '2633' AND price > 0
                ORDER BY price ASC LIMIT 1
144 0.0012 0.0011520385742188
SELECT value FROM productattributes WHERE product_id = '2633' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
145 0.0006 0.00061893463134766
SELECT * FROM productimages WHERE product_id = '2336' ORDER BY sortorder ASC
146 0.0008 0.00081110000610352
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2336' AND p.id = pi.product_id ORDER BY pi.sortorder
147 0.0009 0.00087499618530273
SELECT * FROM product_image_select WHERE product_id = '2336'
148 0.0006 0.00059795379638672
SELECT * FROM productcustomimages WHERE product_id = '2336'
149 0.0008 0.00078892707824707
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 = '2336'
                GROUP BY o.product_id
150 0.0010 0.0010349750518799
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     = '2336'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
151 0.0015 0.0015418529510498
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2336
152 0.0020 0.0019931793212891
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2336' AND a.name = n.originalname
153 0.0004 0.00040006637573242
SELECT * FROM productoffers WHERE product_id = '2336' AND merchantid = 'A1X6FK5RDHNB96'
154 0.0004 0.00038886070251465
SELECT * FROM productoffers
                WHERE product_id = '2336' AND price > 0
                ORDER BY price ASC LIMIT 1
155 0.0003 0.00033998489379883
SELECT * FROM productoffers
                WHERE product_id = 2336
                ORDER BY price ASC LIMIT 1
156 0.0017 0.0016591548919678
SELECT value FROM productattributes
                WHERE product_id = '2336'
                AND name = 'ListPriceAmount'
157 0.0012 0.001190185546875
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 = '2336'
                GROUP BY o.product_id
158 0.0011 0.0010650157928467
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     = '2336'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
159 0.0005 0.00047397613525391
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2336
160 0.0006 0.00057005882263184
SELECT value FROM productattributes WHERE product_id = '2336' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
161 0.0007 0.00072884559631348
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '2336'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
162 0.0005 0.00053906440734863
SELECT * FROM productimages WHERE product_id = '2498' ORDER BY sortorder ASC
163 0.0006 0.00060701370239258
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2498' AND p.id = pi.product_id ORDER BY pi.sortorder
164 0.0007 0.00067710876464844
SELECT * FROM product_image_select WHERE product_id = '2498'
165 0.0004 0.0003960132598877
SELECT * FROM productcustomimages WHERE product_id = '2498'
166 0.0006 0.00061988830566406
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 = '2498'
                GROUP BY o.product_id
167 0.0007 0.00073695182800293
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     = '2498'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
168 0.0004 0.00043487548828125
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2498
169 0.0014 0.0013561248779297
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2498' AND a.name = n.originalname
170 0.0003 0.00034713745117188
SELECT * FROM productoffers WHERE product_id = '2498' AND merchantid = 'A1X6FK5RDHNB96'
171 0.0003 0.00034618377685547
SELECT * FROM productoffers
                WHERE product_id = '2498' AND price > 0
                ORDER BY price ASC LIMIT 1
172 0.0003 0.0003058910369873
SELECT * FROM productoffers
                WHERE product_id = 2498
                ORDER BY price ASC LIMIT 1
173 0.0004 0.0003659725189209
SELECT value FROM productattributes
                WHERE product_id = '2498'
                AND name = 'ListPriceAmount'
174 0.0005 0.00049209594726562
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 = '2498'
                GROUP BY o.product_id
175 0.0008 0.00080585479736328
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     = '2498'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
176 0.0004 0.0004420280456543
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2498
177 0.0006 0.00058603286743164
SELECT value FROM productattributes WHERE product_id = '2498' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
178 0.0007 0.000701904296875
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '2498'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
179 0.0144 0.014403104782104
SELECT *, MATCH (description, title) AGAINST ('lhumidité scellée et' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('lhumidité scellée et' IN BOOLEAN MODE) AND 3134 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
180 0.0006 0.00064396858215332
SELECT *, MATCH (description, title) AGAINST ('lhumidité scellée et' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('lhumidité scellée et' IN BOOLEAN MODE) AND 3134 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
181 0.0005 0.0005180835723877
SELECT *, MATCH (description, title) AGAINST ('lhumidité scellée et' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('lhumidité scellée et' IN BOOLEAN MODE) AND 3134 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
182 0.0147 0.014671802520752
SELECT *, MATCH (description, title) AGAINST ('thé scellées universelles' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('thé scellées universelles' IN BOOLEAN MODE) AND 3134 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
183 0.0008 0.00079107284545898
SELECT *, MATCH (description, title) AGAINST ('thé scellées universelles' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('thé scellées universelles' IN BOOLEAN MODE) AND 3134 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
184 0.0007 0.0006859302520752
SELECT *, MATCH (description, title) AGAINST ('thé scellées universelles' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('thé scellées universelles' IN BOOLEAN MODE) AND 3134 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
185 0.0149 0.014854907989502
SELECT *, MATCH (description, title) AGAINST ('superlove mini-boÃtes Ã' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('superlove mini-boÃtes Ã' IN BOOLEAN MODE) AND 3134 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
186 0.0011 0.0010819435119629
SELECT *, MATCH (description, title) AGAINST ('superlove mini-boÃtes Ã' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('superlove mini-boÃtes Ã' IN BOOLEAN MODE) AND 3134 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
187 0.0005 0.00045919418334961
SELECT *, MATCH (description, title) AGAINST ('superlove mini-boÃtes Ã' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('superlove mini-boÃtes Ã' IN BOOLEAN MODE) AND 3134 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
188 0.0006 0.00059604644775391
SELECT * FROM productimages WHERE product_id = '4895' ORDER BY sortorder ASC
189 0.0005 0.00052404403686523
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4895' AND p.id = pi.product_id ORDER BY pi.sortorder
190 0.0007 0.00072598457336426
SELECT * FROM product_image_select WHERE product_id = '4895'
191 0.0004 0.00041508674621582
SELECT * FROM productcustomimages WHERE product_id = '4895'
192 0.0006 0.00058388710021973
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 = '4895'
                GROUP BY o.product_id
193 0.0007 0.00072097778320312
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     = '4895'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
194 0.0004 0.0004119873046875
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4895
195 0.0009 0.00091791152954102
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4895' AND a.name = n.originalname
196 0.0005 0.00045609474182129
SELECT * FROM productoffers WHERE product_id = '4895' AND merchantid = 'A1X6FK5RDHNB96'
197 0.0004 0.00044703483581543
SELECT * FROM productoffers
                WHERE product_id = '4895' AND price > 0
                ORDER BY price ASC LIMIT 1
198 0.0004 0.00042295455932617
SELECT * FROM productoffers
                WHERE product_id = 4895
                ORDER BY price ASC LIMIT 1
199 0.0005 0.0004889965057373
SELECT value FROM productattributes
                WHERE product_id = '4895'
                AND name = 'ListPriceAmount'
200 0.0005 0.00046491622924805
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 = '4895'
                GROUP BY o.product_id
201 0.0007 0.00072503089904785
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     = '4895'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
202 0.0005 0.00054287910461426
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4895
203 0.0007 0.00069785118103027
SELECT value FROM productattributes WHERE product_id = '4895' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
204 0.0011 0.0010921955108643
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4895'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
205 0.0008 0.00079798698425293
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
206 0.0010 0.0010089874267578
SELECT * FROM product_image_select WHERE product_id = '3881'
207 0.0005 0.00051283836364746
SELECT * FROM productcustomimages WHERE product_id = '3881'
208 0.0024 0.0023930072784424
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
209 0.0007 0.00065207481384277
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
210 0.0006 0.0005791187286377
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
211 0.0007 0.00069308280944824
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
212 0.0007 0.00072407722473145
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
213 0.0014 0.0013728141784668
SELECT * FROM product_image_select WHERE product_id = '4213'
214 0.0006 0.00055289268493652
SELECT * FROM productcustomimages WHERE product_id = '4213'
215 0.0034 0.003432035446167
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
216 0.0007 0.00074601173400879
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
217 0.0005 0.00051593780517578
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
218 0.0028 0.0028378963470459
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
219 0.0012 0.0011818408966064
SELECT id,asin FROM products WHERE parent_id = 3134
220 0.0021 0.0021018981933594
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3516
221 0.0008 0.0008080005645752
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3516
222 0.0008 0.00075817108154297
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3517
223 0.0013 0.0013489723205566
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3517
224 0.0004 0.00037097930908203
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3518
225 0.0007 0.00067806243896484
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3518
226 0.0004 0.00037002563476562
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3519
227 0.0005 0.00048112869262695
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3519
228 0.0004 0.00037789344787598
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3521
229 0.0006 0.00064301490783691
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3521
230 0.0005 0.00048279762268066
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4749
231 0.0006 0.00063991546630859
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4749
232 0.0005 0.00052905082702637
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3134' ORDER BY timestamp DESC
233 0.0005 0.00051712989807129
SELECT category_id FROM products_categories WHERE product_id = '3134'
234 0.0005 0.00053310394287109
SELECT * FROM categories WHERE id = '26'
235 0.0055 0.0054500102996826
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
236 0.0004 0.00042486190795898
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
237 0.0004 0.00042200088500977
SELECT id FROM categories WHERE parent_id = '26'
238 0.0057 0.0057492256164551
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 
239 0.0006 0.00055193901062012
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 
240 0.0011 0.0011129379272461
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
241 0.0005 0.0004580020904541
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
242 0.0010 0.0010409355163574
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3134' AND a.name = n.originalname
243 0.0004 0.00043988227844238
SELECT * FROM productoffers WHERE product_id = '3134' AND merchantid = 'A1X6FK5RDHNB96'
244 0.0004 0.00037622451782227
SELECT * FROM productoffers
                WHERE product_id = '3134' AND price > 0
                ORDER BY price ASC LIMIT 1
245 0.0005 0.00046586990356445
SELECT * FROM productoffers
                WHERE product_id = 3134
                ORDER BY price ASC LIMIT 1
246 0.0005 0.00050497055053711
SELECT value FROM productattributes
                WHERE product_id = '3134'
                AND name = 'ListPriceAmount'
247 0.0005 0.00053691864013672
SELECT * FROM products WHERE id = '3134'
248 0.0005 0.00051212310791016
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 = '3134'
                GROUP BY o.product_id
249 0.0007 0.00073695182800293
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     = '3134'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
250 0.0005 0.00054311752319336
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3134
251 0.0006 0.00058603286743164
SELECT value FROM productattributes WHERE product_id = '3134' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
252 0.0007 0.00069403648376465
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3134' AND a.name = n.originalname
253 0.0004 0.00040888786315918
SELECT * FROM productoffers WHERE product_id = '3134' AND merchantid = 'A1X6FK5RDHNB96'
254 0.0034 0.0033590793609619
SELECT * FROM productoffers
                WHERE product_id = '3134' AND price > 0
                ORDER BY price ASC LIMIT 1
255 0.0003 0.00031399726867676
SELECT * FROM productoffers
                WHERE product_id = 3134
                ORDER BY price ASC LIMIT 1
256 0.0003 0.00034499168395996
SELECT value FROM productattributes
                WHERE product_id = '3134'
                AND name = 'ListPriceAmount'
257 0.0005 0.00051283836364746
SELECT DISTINCT (name) FROM productoptions
258 0.0006 0.00055408477783203
SELECT * FROM productoptions WHERE product_id IN (SELECT product_id FROM productoffers WHERE product_id IN (SELECT id from products WHERE parent_id = 3134))
259 0.0005 0.0004570484161377
SELECT	o.value, o.name
			FROM	products			p,
					productoptions		o
			WHERE	p.parent_id		= 3134
			  AND	p.id			= o.product_id 
			GROUP BY o.value ORDER BY o.value ASC
260 0.0015 0.0015261173248291
SELECT * FROM translationsfilter
261 0.0004 0.0004270076751709
SELECT category_id FROM products_categories WHERE product_id = '3134' AND prod_type = 'amz'
262 0.0004 0.00037598609924316
SELECT parent_id FROM categories WHERE id = '26'
263 0.0004 0.00038313865661621
SELECT * FROM categories WHERE id = '26'
264 0.0063 0.0063381195068359
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
265 0.0005 0.00048208236694336
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
266 0.0004 0.00035715103149414
SELECT id FROM categories WHERE parent_id = '26'
267 0.0063 0.0063259601593018
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 
268 0.0006 0.00064706802368164
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 
269 0.0006 0.00057697296142578
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
270 0.0006 0.00058293342590332
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
271 0.0006 0.00062799453735352
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
272 0.0005 0.00052905082702637
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
273 0.0003 0.00032687187194824
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
274 0.0159 0.015896081924438
SELECT p.id,p.parent_id, o.price,p.asin FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND hidden = 0 AND offers > 0 AND (SELECT COUNT(pi.id) FROM productimages pi WHERE pi.product_id = p.id) > 1 AND o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price)) ORDER BY p.title DESC LIMIT 6
275 0.0006 0.0006411075592041
SELECT p.id,p.price,p.listingtype FROM ebay_products p WHERE hide = 0 AND (SELECT COUNT(pi.id) FROM ebay_prod_images pi WHERE pi.prodid = p.id) > 1 ORDER BY p.title DESC LIMIT 6
276 0.0007 0.00068402290344238
SELECT p.id,p.price,p.currency FROM custom_products p WHERE hide = 0 AND orginalprice > 0 AND (SELECT COUNT(pi.id) FROM productcustomimages pi WHERE pi.product_id = p.id) > 1 ORDER BY p.title DESC LIMIT 6
277 0.0014 0.0014071464538574
SELECT * FROM products WHERE id = 1626
278 0.0009 0.00087594985961914
SELECT * FROM products WHERE id = 4041
279 0.0008 0.00075197219848633
SELECT * FROM products WHERE id = 4312
280 0.0006 0.00064396858215332
SELECT * FROM products WHERE id = 777
281 0.0006 0.00058197975158691
SELECT * FROM products WHERE id = 3881
282 0.0010 0.0010409355163574
SELECT * FROM products WHERE id = 4213
283 0.0005 0.00051593780517578
SELECT * FROM products WHERE id = '1626'
284 0.0006 0.00057601928710938
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
285 0.0007 0.00070095062255859
SELECT * FROM product_image_select WHERE product_id = '1626'
286 0.0005 0.00045394897460938
SELECT * FROM productcustomimages WHERE product_id = '1626'
287 0.0009 0.00085115432739258
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
288 0.0005 0.00045204162597656
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
289 0.0004 0.00038599967956543
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
290 0.0005 0.00047588348388672
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
291 0.0005 0.00050902366638184
SELECT * FROM products WHERE id = '4041'
292 0.0005 0.00048303604125977
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
293 0.0006 0.00059008598327637
SELECT * FROM product_image_select WHERE product_id = '4041'
294 0.0004 0.00037717819213867
SELECT * FROM productcustomimages WHERE product_id = '4041'
295 0.0011 0.0010788440704346
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
296 0.0005 0.00049209594726562
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
297 0.0004 0.00044512748718262
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
298 0.0005 0.00049710273742676
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
299 0.0006 0.00058507919311523
SELECT * FROM products WHERE id = '4312'
300 0.0005 0.00053811073303223
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
301 0.0007 0.00071096420288086
SELECT * FROM product_image_select WHERE product_id = '4312'
302 0.0004 0.0004270076751709
SELECT * FROM productcustomimages WHERE product_id = '4312'
303 0.0012 0.0012040138244629
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
304 0.0005 0.00046205520629883
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
305 0.0004 0.00039196014404297
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
306 0.0005 0.00045895576477051
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
307 0.0005 0.00047802925109863
SELECT * FROM products WHERE id = '777'
308 0.0004 0.00042390823364258
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
309 0.0006 0.00056004524230957
SELECT * FROM product_image_select WHERE product_id = '777'
310 0.0003 0.00034594535827637
SELECT * FROM productcustomimages WHERE product_id = '777'
311 0.0011 0.0010790824890137
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
312 0.0004 0.00042295455932617
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
313 0.0004 0.00040006637573242
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
314 0.0004 0.00043392181396484
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
315 0.0005 0.00051712989807129
SELECT * FROM products WHERE id = '3881'
316 0.0005 0.00047206878662109
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
317 0.0006 0.00057697296142578
SELECT * FROM product_image_select WHERE product_id = '3881'
318 0.0003 0.00032305717468262
SELECT * FROM productcustomimages WHERE product_id = '3881'
319 0.0012 0.0011610984802246
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
320 0.0005 0.00046896934509277
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
321 0.0006 0.00060105323791504
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
322 0.0004 0.00040102005004883
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
323 0.0005 0.00054192543029785
SELECT * FROM products WHERE id = '4213'
324 0.0005 0.00046205520629883
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
325 0.0005 0.0005030632019043
SELECT * FROM product_image_select WHERE product_id = '4213'
326 0.0004 0.00035309791564941
SELECT * FROM productcustomimages WHERE product_id = '4213'
327 0.0012 0.0011758804321289
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
328 0.0005 0.00047397613525391
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
329 0.0004 0.00043821334838867
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
330 0.0004 0.00041699409484863
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
331 0.0009 0.00090217590332031
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
332 0.0007 0.00069904327392578
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
333 0.0015 0.0015430450439453
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
334 0.0010 0.001007080078125
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
335 0.0009 0.00087785720825195
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
336 0.0009 0.00093889236450195
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'