0

SoBuy FRG Porte-Capsules, Boîte de rangement à tiroirs pour capsules de thé et café en bambou, Boîte à Capsules de Café thé

Price: €29,95
Product prices and availability are accurate as of 2022-06-24 17:53:41 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.
Availability: In Stock
En stock.
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

Rangement idéal pour vos capsules de café et thé préférées ! Fabriqué en Bambou écologique, solide et durable. 4 compartiments amovables. Dimensions de la Boîte : L30cmxP31cmxH9,5cm; compartiment : L12,5xP25xH6,5cm/L12,5xP12,5xH6,5cm. Grande capacité - Grands compartiments adaptés à la taille des capsules de café et des sachets de thé de toutes marques. Avec la Facture. La commande passée avant le 14H00 sera expédiée le même jour.

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
0.95383787155151 307 0.1972 0


No Amazon API Requests Made.


App Debug - Total Time 0.95383787155151 seconds

Number Time From Start Name Description
1 0.66629600524902 Initialise Initialise FSB Function
2 0.66865110397339 App Controller Start Start of the App controller (called before the controller of every page)
3 0.67138004302979 Start of getCategoryListByGroup Function Before first category groups query
4 0.67172503471375 After initial query Before first category groups query
5 0.67172789573669 Get Category List for Group Before the call to getCategoryList function
6 0.67173099517822 Start of GetCategoryList function Start of the function
7 0.67173600196838 Before getting categories Query to get specific category list
8 0.67225790023804 After getting categories Query to get specific category list
9 0.67226004600525 Before getting category custom Before call to function getCategoryCustom
10 0.6753408908844 After getting category custom After call to function getCategoryCustom
11 0.67534399032593 Before getting category custom Before call to function getCategoryCustom
12 0.67831897735596 After getting category custom After call to function getCategoryCustom
13 0.6783230304718 Before getting category custom Before call to function getCategoryCustom
14 0.68124508857727 After getting category custom After call to function getCategoryCustom
15 0.68124794960022 Before getting category custom Before call to function getCategoryCustom
16 0.68424987792969 After getting category custom After call to function getCategoryCustom
17 0.68425393104553 Before getting category custom Before call to function getCategoryCustom
18 0.68721795082092 After getting category custom After call to function getCategoryCustom
19 0.68722200393677 Before getting category custom Before call to function getCategoryCustom
20 0.69031691551208 After getting category custom After call to function getCategoryCustom
21 0.69032096862793 End of GetCategoryList function End of the function
22 0.69033098220825 Get Category List for Group Before the call to getCategoryList function
23 0.69033408164978 Start of GetCategoryList function Start of the function
24 0.69033789634705 Before getting categories Query to get specific category list
25 0.69070100784302 End of getCategoryListByGroup Function Before return()
26 0.6965799331665 App Controller End End of the App controller (called before the controller of every page)
27 0.69738101959229 Product Start Start of the product info controller
28 0.72995805740356 Cache file not found Starting get product details
29 0.79503607749939 Related products Start getting related products if enabled
30 0.79503798484802 Related Products Start Before the related products are found
31 0.79503989219666 Related Products Keywords Before the related product keywords are found
32 0.79504609107971 Create Keyword List Function Start of function
33 0.7951340675354 Create Keyword List Function After looping provided content - 55 keywords found
34 0.79877805709839 Create Keyword List Function After looping initial keyword list - 50 keywords remaining
35 0.79879403114319 Create Keyword List Function After reducing keyword list
36 0.79951095581055 Create Keyword List Function After selecting by scoring keywords
37 0.79951786994934 Create Keyword List Function After final loop of keywords
38 0.79952096939087 Related Products Keywords After the related product keywords are found
39 0.84360098838806 Related Products End After the related products are found
40 0.85670900344849 Product End End of the product info controller (Product Info)
41 0.85793399810791 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 0.85861587524414 Before Get Options Before the call to getOptions in the tpl class
43 0.90333604812622 After Get Options After the call to getOptions in the tpl class
44 0.90351986885071 App_after Controller End End of the App_after controller (called after the controller of every page)
45 0.90356397628784 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 0.92949795722961 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 0.92950487136841 Product Info: Before Template Display Before the template is displayed
48 0.95379495620728 Product Info: After Template Display After the template is displayed
49 0.95381808280945 Finalizing debug Before the debug is output to the page.
50 0.95383596420288 End of App This is the end of the app logging, final timestamp


Query Debug - 307 Database Queries. Total time 0.1972 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0005 0.00053596496582031
SELECT parameter, value FROM parameters
2 0.0015 0.0014700889587402
SELECT * FROM `bad_bots`
3 0.0005 0.00049996376037598
SET time_zone = 'Europe/London'
4 0.0003 0.00027298927307129
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0009 0.00091099739074707
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:12:\"44.200.86.95\";}'
6 0.0007 0.00068092346191406
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1716703520'
7 0.0006 0.00055980682373047
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0003 0.00032615661621094
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0003 0.00028705596923828
SELECT id FROM pages WHERE pagename = 'sobuy-frg-porte-capsules-bote-de-rangement-tiroirs-pour-capsules-de' LIMIT 1
10 0.0010 0.00095510482788086
SELECT id FROM products WHERE pagename = 'sobuy-frg-porte-capsules-bote-de-rangement-tiroirs-pour-capsules-de' AND hidden = 0 LIMIT 1
11 0.0007 0.0006868839263916
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0007 0.00074100494384766
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0005 0.0005040168762207
SELECT * FROM pages WHERE pagename = 'sobuy-frg-porte-capsules-bote-de-rangement-tiroirs-pour-capsules-de'
14 0.0003 0.00032901763916016
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0005 0.00049400329589844
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0003 0.00028491020202637
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.0003199577331543
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.00031304359436035
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0004 0.00038504600524902
SELECT id FROM categories WHERE parent_id = '26'
20 0.0003 0.00031805038452148
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.00033783912658691
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.0003 0.00029110908508301
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
23 0.0003 0.0003201961517334
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0003 0.00034093856811523
SELECT * FROM categorygroups WHERE id = '1'
25 0.0004 0.00037693977355957
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.0003 0.00031185150146484
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.0003 0.00031304359436035
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0003 0.00029706954956055
SELECT id FROM categories WHERE parent_id = '27'
29 0.0003 0.00029587745666504
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.0003 0.00031685829162598
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
31 0.0003 0.00033283233642578
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
32 0.0003 0.00029516220092773
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0003 0.00030183792114258
SELECT * FROM categorygroups WHERE id = '1'
34 0.0003 0.00029110908508301
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
35 0.0003 0.00029802322387695
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
36 0.0003 0.0003049373626709
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0003 0.00030517578125
SELECT id FROM categories WHERE parent_id = '28'
38 0.0003 0.00032305717468262
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
39 0.0004 0.00036501884460449
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.0003 0.00029706954956055
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.0003 0.00030088424682617
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0003 0.00030398368835449
SELECT * FROM categorygroups WHERE id = '1'
43 0.0004 0.00040793418884277
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.0003 0.00029087066650391
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
45 0.0003 0.00030183792114258
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0003 0.00031113624572754
SELECT id FROM categories WHERE parent_id = '29'
47 0.0003 0.00031018257141113
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
48 0.0003 0.0003058910369873
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0 
49 0.0003 0.00033211708068848
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
50 0.0003 0.00029492378234863
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0003 0.00030517578125
SELECT * FROM categorygroups WHERE id = '1'
52 0.0003 0.00029897689819336
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.0003 0.00029110908508301
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.0003 0.00031495094299316
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0003 0.00031590461730957
SELECT id FROM categories WHERE parent_id = '30'
56 0.0003 0.00031685829162598
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
57 0.0003 0.00030803680419922
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0 
58 0.0004 0.00036311149597168
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.0003 0.00031495094299316
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0003 0.00030684471130371
SELECT * FROM categorygroups WHERE id = '1'
61 0.0003 0.00028681755065918
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.00034594535827637
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.0003 0.00031399726867676
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0004 0.00036883354187012
SELECT id FROM categories WHERE parent_id = '31'
65 0.0004 0.00035595893859863
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
66 0.0003 0.00032401084899902
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
67 0.0003 0.00033402442932129
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
68 0.0003 0.00031781196594238
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0003 0.00030684471130371
SELECT * FROM categorygroups WHERE id = '1'
70 0.0003 0.00034689903259277
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0003 0.00031709671020508
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0003 0.00034308433532715
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0004 0.00035786628723145
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
74 0.0003 0.00028491020202637
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0003 0.00030207633972168
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0007 0.0006568431854248
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.0003 0.00032305717468262
SELECT * FROM ipgeocountries WHERE INET_ATON('44.200.86.95') >= INET_ATON(ip_start) AND INET_ATON('44.200.86.95') <= INET_ATON(ip_end)
78 0.0003 0.00029301643371582
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0003 0.00028800964355469
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0009 0.0009150505065918
SELECT * FROM products WHERE pagename = 'sobuy-frg-porte-capsules-bote-de-rangement-tiroirs-pour-capsules-de'
81 0.0061 0.0061230659484863
UPDATE products SET viewcount = viewcount + 1 WHERE id = 850
82 0.0018 0.0017509460449219
SELECT * FROM manufacturers WHERE id = '211'
83 0.0011 0.0010809898376465
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '211'
84 0.0003 0.0003199577331543
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '211' LIMIT 1
85 0.0020 0.0019569396972656
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '211' ORDER BY RAND() LIMIT 1
86 0.0004 0.0004429817199707
SELECT * FROM productimages WHERE product_id = '3738' ORDER BY sortorder ASC
87 0.0003 0.00034594535827637
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '211'
88 0.0011 0.0011119842529297
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '211'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
89 0.0004 0.00039100646972656
SELECT * FROM manufacturerimages WHERE manufacturer_id = '211'
90 0.0003 0.00031518936157227
SELECT category_id FROM products_categories WHERE product_id = '850'
91 0.0004 0.0003960132598877
SELECT * FROM categories WHERE id = '26'
92 0.0152 0.015209913253784
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
93 0.0003 0.00031018257141113
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
94 0.0003 0.00025200843811035
SELECT id FROM categories WHERE parent_id = '26'
95 0.0102 0.010195970535278
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 
96 0.0003 0.00028800964355469
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 
97 0.0003 0.00025701522827148
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
98 0.0003 0.00028395652770996
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
99 0.0005 0.00046610832214355
SELECT * FROM productimages WHERE product_id = '850' ORDER BY sortorder ASC
100 0.0006 0.00060796737670898
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
101 0.0003 0.00029206275939941
SELECT * FROM product_image_select WHERE product_id = '850'
102 0.0003 0.00026607513427734
SELECT * FROM productcustomimages WHERE product_id = '850'
103 0.0003 0.00029110908508301
SELECT * FROM productfeeds WHERE product_id = '850' ORDER BY item_date DESC
104 0.0003 0.00025510787963867
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '850' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
105 0.0002 0.0002448558807373
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '850' AND t.hidden = 0 AND display_product = 1
106 0.0003 0.00030088424682617
SELECT * FROM tags WHERE id = '216'
107 0.0045 0.0045089721679688
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
108 0.0046 0.0045959949493408
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 
109 0.0044 0.0043962001800537
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
110 0.0003 0.00034403800964355
SELECT * FROM productimages WHERE product_id = '4122' ORDER BY sortorder ASC
111 0.0003 0.00029802322387695
SELECT * FROM tags WHERE id = '91'
112 0.0013 0.0012550354003906
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '91'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
113 0.0012 0.001201868057251
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '91'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
114 0.0013 0.0012760162353516
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '91' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
115 0.0003 0.00034999847412109
SELECT * FROM productimages WHERE product_id = '4933' ORDER BY sortorder ASC
116 0.0004 0.00037193298339844
SELECT * FROM productamazoncontent WHERE product_id = '850'
117 0.0006 0.00061392784118652
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
118 0.0007 0.00069499015808105
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
119 0.0005 0.00048303604125977
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
120 0.0003 0.0003199577331543
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '850' AND a.name = n.originalname
121 0.0003 0.00033116340637207
SELECT * FROM productoffers WHERE product_id = '850' AND merchantid = 'A1X6FK5RDHNB96'
122 0.0003 0.00029897689819336
SELECT * FROM productoffers
                WHERE product_id = '850' AND price > 0
                ORDER BY price ASC LIMIT 1
123 0.0003 0.00033783912658691
SELECT * FROM productoffers
                WHERE product_id = 850
                ORDER BY price ASC LIMIT 1
124 0.0003 0.00026178359985352
SELECT value FROM productattributes
                WHERE product_id = '850'
                AND name = 'ListPriceAmount'
125 0.0004 0.00036883354187012
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
126 0.0003 0.00027012825012207
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
127 0.0003 0.00028300285339355
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
128 0.0004 0.00035285949707031
SELECT value FROM productattributes WHERE product_id = '850' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
129 0.0007 0.00069999694824219
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
130 0.0006 0.00063109397888184
SELECT * FROM products WHERE parent_id = '850'
131 0.0004 0.00041699409484863
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4891' AND a.name = n.originalname
132 0.0003 0.00031781196594238
SELECT * FROM productoffers WHERE product_id = '4891' AND merchantid = 'A1X6FK5RDHNB96'
133 0.0003 0.00031805038452148
SELECT * FROM productoffers
                WHERE product_id = '4891' AND price > 0
                ORDER BY price ASC LIMIT 1
134 0.0003 0.0003058910369873
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
135 0.0105 0.010462999343872
SELECT *, MATCH (description, title) AGAINST ('capsules de' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('capsules de' IN BOOLEAN MODE) AND 850 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
136 0.0005 0.00052380561828613
SELECT *, MATCH (description, title) AGAINST ('capsules de' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('capsules de' IN BOOLEAN MODE) AND 850 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
137 0.0005 0.00050997734069824
SELECT *, MATCH (description, title) AGAINST ('capsules de' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('capsules de' IN BOOLEAN MODE) AND 850 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
138 0.0006 0.00058197975158691
SELECT * FROM productimages WHERE product_id = '810' ORDER BY sortorder ASC
139 0.0003 0.00031304359436035
SELECT * FROM product_image_select WHERE product_id = '810'
140 0.0004 0.00035810470581055
SELECT * FROM productcustomimages WHERE product_id = '810'
141 0.0003 0.00027704238891602
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '810' AND a.name = n.originalname
142 0.0003 0.00028395652770996
SELECT * FROM productoffers WHERE product_id = '810' AND merchantid = 'A1X6FK5RDHNB96'
143 0.0003 0.00030112266540527
SELECT * FROM productoffers
                WHERE product_id = '810' AND price > 0
                ORDER BY price ASC LIMIT 1
144 0.0003 0.00028300285339355
SELECT value FROM productattributes WHERE product_id = '810' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
145 0.0004 0.00037884712219238
SELECT * FROM productimages WHERE product_id = '850' ORDER BY sortorder ASC
146 0.0003 0.00034999847412109
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
147 0.0004 0.00036883354187012
SELECT * FROM product_image_select WHERE product_id = '850'
148 0.0003 0.00029897689819336
SELECT * FROM productcustomimages WHERE product_id = '850'
149 0.0004 0.00036907196044922
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
150 0.0003 0.00026893615722656
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
151 0.0004 0.00040102005004883
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
152 0.0003 0.00025606155395508
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '850' AND a.name = n.originalname
153 0.0003 0.00027894973754883
SELECT * FROM productoffers WHERE product_id = '850' AND merchantid = 'A1X6FK5RDHNB96'
154 0.0003 0.00031900405883789
SELECT * FROM productoffers
                WHERE product_id = '850' AND price > 0
                ORDER BY price ASC LIMIT 1
155 0.0004 0.00038313865661621
SELECT * FROM productoffers
                WHERE product_id = 850
                ORDER BY price ASC LIMIT 1
156 0.0003 0.00030016899108887
SELECT value FROM productattributes
                WHERE product_id = '850'
                AND name = 'ListPriceAmount'
157 0.0003 0.00027799606323242
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
158 0.0003 0.00026607513427734
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
159 0.0003 0.00028800964355469
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
160 0.0003 0.00030112266540527
SELECT value FROM productattributes WHERE product_id = '850' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
161 0.0003 0.00026392936706543
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
162 0.0004 0.00040698051452637
SELECT * FROM products WHERE parent_id = '850'
163 0.0002 0.00024890899658203
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4891' AND a.name = n.originalname
164 0.0003 0.0002901554107666
SELECT * FROM productoffers WHERE product_id = '4891' AND merchantid = 'A1X6FK5RDHNB96'
165 0.0003 0.00034189224243164
SELECT * FROM productoffers
                WHERE product_id = '4891' AND price > 0
                ORDER BY price ASC LIMIT 1
166 0.0003 0.00029110908508301
SELECT * FROM productimages WHERE product_id = '865' ORDER BY sortorder ASC
167 0.0003 0.00029301643371582
SELECT * FROM product_image_select WHERE product_id = '865'
168 0.0003 0.00026512145996094
SELECT * FROM productcustomimages WHERE product_id = '865'
169 0.0003 0.0002739429473877
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '865' AND a.name = n.originalname
170 0.0003 0.0002892017364502
SELECT * FROM productoffers WHERE product_id = '865' AND merchantid = 'A1X6FK5RDHNB96'
171 0.0003 0.0002899169921875
SELECT * FROM productoffers
                WHERE product_id = '865' AND price > 0
                ORDER BY price ASC LIMIT 1
172 0.0002 0.00024604797363281
SELECT value FROM productattributes WHERE product_id = '865' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
173 0.0004 0.00035214424133301
SELECT * FROM productimages WHERE product_id = '1354' ORDER BY sortorder ASC
174 0.0003 0.00025606155395508
SELECT * FROM product_image_select WHERE product_id = '1354'
175 0.0003 0.00026893615722656
SELECT * FROM productcustomimages WHERE product_id = '1354'
176 0.0003 0.00028610229492188
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1354' AND a.name = n.originalname
177 0.0003 0.0002899169921875
SELECT * FROM productoffers WHERE product_id = '1354' AND merchantid = 'A1X6FK5RDHNB96'
178 0.0003 0.00029110908508301
SELECT * FROM productoffers
                WHERE product_id = '1354' AND price > 0
                ORDER BY price ASC LIMIT 1
179 0.0003 0.00029706954956055
SELECT value FROM productattributes WHERE product_id = '1354' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
180 0.0003 0.0002739429473877
SELECT * FROM productimages WHERE product_id = '966' ORDER BY sortorder ASC
181 0.0003 0.00026106834411621
SELECT * FROM product_image_select WHERE product_id = '966'
182 0.0003 0.00025415420532227
SELECT * FROM productcustomimages WHERE product_id = '966'
183 0.0003 0.00025105476379395
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '966' AND a.name = n.originalname
184 0.0003 0.00028491020202637
SELECT * FROM productoffers WHERE product_id = '966' AND merchantid = 'A1X6FK5RDHNB96'
185 0.0003 0.00029301643371582
SELECT * FROM productoffers
                WHERE product_id = '966' AND price > 0
                ORDER BY price ASC LIMIT 1
186 0.0002 0.00024795532226562
SELECT value FROM productattributes WHERE product_id = '966' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
187 0.0003 0.00027203559875488
SELECT * FROM productimages WHERE product_id = '4940' ORDER BY sortorder ASC
188 0.0003 0.00025510787963867
SELECT * FROM product_image_select WHERE product_id = '4940'
189 0.0003 0.00026202201843262
SELECT * FROM productcustomimages WHERE product_id = '4940'
190 0.0003 0.00029706954956055
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4940' AND a.name = n.originalname
191 0.0003 0.0003211498260498
SELECT * FROM productoffers WHERE product_id = '4940' AND merchantid = 'A1X6FK5RDHNB96'
192 0.0003 0.00032591819763184
SELECT * FROM productoffers
                WHERE product_id = '4940' AND price > 0
                ORDER BY price ASC LIMIT 1
193 0.0003 0.00026106834411621
SELECT value FROM productattributes WHERE product_id = '4940' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
194 0.0100 0.010021924972534
SELECT *, MATCH (description, title) AGAINST ('rangement  tiroirs' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('rangement  tiroirs' IN BOOLEAN MODE) AND 850 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 1
195 0.0005 0.00050687789916992
SELECT *, MATCH (description, title) AGAINST ('rangement  tiroirs' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('rangement  tiroirs' IN BOOLEAN MODE) AND 850 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 1
196 0.0005 0.00048112869262695
SELECT *, MATCH (description, title) AGAINST ('rangement  tiroirs' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('rangement  tiroirs' IN BOOLEAN MODE) AND 850 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 1
197 0.0003 0.00033378601074219
SELECT * FROM productimages WHERE product_id = '764' ORDER BY sortorder ASC
198 0.0003 0.00027894973754883
SELECT * FROM product_image_select WHERE product_id = '764'
199 0.0003 0.00026798248291016
SELECT * FROM productcustomimages WHERE product_id = '764'
200 0.0003 0.00031805038452148
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '764' AND a.name = n.originalname
201 0.0003 0.0003049373626709
SELECT * FROM productoffers WHERE product_id = '764' AND merchantid = 'A1X6FK5RDHNB96'
202 0.0004 0.00035190582275391
SELECT * FROM productoffers
                WHERE product_id = '764' AND price > 0
                ORDER BY price ASC LIMIT 1
203 0.0003 0.00031614303588867
SELECT value FROM productattributes WHERE product_id = '764' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
204 0.0004 0.00043201446533203
SELECT id,asin FROM products WHERE parent_id = 850
205 0.0003 0.00027799606323242
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4891
206 0.0003 0.00026512145996094
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4891
207 0.0003 0.00029206275939941
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '850' ORDER BY timestamp DESC
208 0.0003 0.00027608871459961
SELECT category_id FROM products_categories WHERE product_id = '850'
209 0.0003 0.00033783912658691
SELECT * FROM categories WHERE id = '26'
210 0.0003 0.00028395652770996
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
211 0.0003 0.00032210350036621
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
212 0.0003 0.00033307075500488
SELECT id FROM categories WHERE parent_id = '26'
213 0.0003 0.00028300285339355
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 
214 0.0004 0.00035810470581055
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 
215 0.0003 0.00028276443481445
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
216 0.0003 0.00032401084899902
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
217 0.0004 0.00035715103149414
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '850' AND a.name = n.originalname
218 0.0006 0.00055313110351562
SELECT * FROM productoffers WHERE product_id = '850' AND merchantid = 'A1X6FK5RDHNB96'
219 0.0004 0.0003659725189209
SELECT * FROM productoffers
                WHERE product_id = '850' AND price > 0
                ORDER BY price ASC LIMIT 1
220 0.0003 0.0003049373626709
SELECT * FROM productoffers
                WHERE product_id = 850
                ORDER BY price ASC LIMIT 1
221 0.0004 0.00041103363037109
SELECT value FROM productattributes
                WHERE product_id = '850'
                AND name = 'ListPriceAmount'
222 0.0007 0.00073385238647461
SELECT * FROM products WHERE id = '850'
223 0.0003 0.00028491020202637
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
224 0.0003 0.00027704238891602
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
225 0.0003 0.00026607513427734
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
226 0.0003 0.0002589225769043
SELECT value FROM productattributes WHERE product_id = '850' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
227 0.0003 0.00031590461730957
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '850' AND a.name = n.originalname
228 0.0003 0.00031518936157227
SELECT * FROM productoffers WHERE product_id = '850' AND merchantid = 'A1X6FK5RDHNB96'
229 0.0003 0.00029587745666504
SELECT * FROM productoffers
                WHERE product_id = '850' AND price > 0
                ORDER BY price ASC LIMIT 1
230 0.0004 0.00035810470581055
SELECT * FROM productoffers
                WHERE product_id = 850
                ORDER BY price ASC LIMIT 1
231 0.0003 0.00031399726867676
SELECT value FROM productattributes
                WHERE product_id = '850'
                AND name = 'ListPriceAmount'
232 0.0003 0.00029778480529785
SELECT category_id FROM products_categories WHERE product_id = '850' AND prod_type = 'amz'
233 0.0003 0.00028300285339355
SELECT parent_id FROM categories WHERE id = '26'
234 0.0003 0.00028705596923828
SELECT * FROM categories WHERE id = '26'
235 0.0002 0.0002448558807373
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.0003 0.00031399726867676
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
237 0.0003 0.00028419494628906
SELECT id FROM categories WHERE parent_id = '26'
238 0.0003 0.00029706954956055
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.0003 0.00032186508178711
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.0003 0.00033712387084961
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.0003 0.00025796890258789
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
242 0.0003 0.00034999847412109
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
243 0.0003 0.00029301643371582
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
244 0.0003 0.00029206275939941
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
245 0.0178 0.017780065536499
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
246 0.0003 0.00033879280090332
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
247 0.0003 0.00034213066101074
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
248 0.0006 0.00061488151550293
SELECT * FROM products WHERE id = 1626
249 0.0007 0.00072216987609863
SELECT * FROM products WHERE id = 4041
250 0.0007 0.00067305564880371
SELECT * FROM products WHERE id = 4312
251 0.0006 0.00062417984008789
SELECT * FROM products WHERE id = 777
252 0.0006 0.00064492225646973
SELECT * FROM products WHERE id = 4213
253 0.0007 0.00065207481384277
SELECT * FROM products WHERE id = 3881
254 0.0006 0.00064516067504883
SELECT * FROM products WHERE id = '1626'
255 0.0003 0.0002748966217041
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
256 0.0003 0.00028300285339355
SELECT * FROM product_image_select WHERE product_id = '1626'
257 0.0003 0.00028491020202637
SELECT * FROM productcustomimages WHERE product_id = '1626'
258 0.0003 0.00030899047851562
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
259 0.0003 0.0002899169921875
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
260 0.0003 0.00031495094299316
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
261 0.0003 0.00026416778564453
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
262 0.0005 0.00052881240844727
SELECT * FROM products WHERE id = '4041'
263 0.0004 0.00043702125549316
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
264 0.0003 0.00029611587524414
SELECT * FROM product_image_select WHERE product_id = '4041'
265 0.0003 0.00030112266540527
SELECT * FROM productcustomimages WHERE product_id = '4041'
266 0.0003 0.0002899169921875
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
267 0.0003 0.00031304359436035
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
268 0.0003 0.00031208992004395
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
269 0.0003 0.00030303001403809
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
270 0.0006 0.00056290626525879
SELECT * FROM products WHERE id = '4312'
271 0.0003 0.00028109550476074
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
272 0.0003 0.00030303001403809
SELECT * FROM product_image_select WHERE product_id = '4312'
273 0.0003 0.0002739429473877
SELECT * FROM productcustomimages WHERE product_id = '4312'
274 0.0003 0.00032401084899902
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
275 0.0003 0.0003211498260498
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
276 0.0003 0.00032591819763184
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
277 0.0003 0.0002748966217041
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
278 0.0006 0.00055694580078125
SELECT * FROM products WHERE id = '777'
279 0.0003 0.00029897689819336
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
280 0.0003 0.00028109550476074
SELECT * FROM product_image_select WHERE product_id = '777'
281 0.0003 0.00026798248291016
SELECT * FROM productcustomimages WHERE product_id = '777'
282 0.0003 0.00031709671020508
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
283 0.0003 0.00032496452331543
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
284 0.0003 0.00034499168395996
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
285 0.0003 0.00030398368835449
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
286 0.0007 0.00065398216247559
SELECT * FROM products WHERE id = '4213'
287 0.0005 0.00049901008605957
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
288 0.0003 0.00027203559875488
SELECT * FROM product_image_select WHERE product_id = '4213'
289 0.0003 0.00026607513427734
SELECT * FROM productcustomimages WHERE product_id = '4213'
290 0.0003 0.00027298927307129
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
291 0.0003 0.00030899047851562
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
292 0.0003 0.00029802322387695
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
293 0.0003 0.00026679039001465
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
294 0.0006 0.00058603286743164
SELECT * FROM products WHERE id = '3881'
295 0.0005 0.00051212310791016
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
296 0.0003 0.00029706954956055
SELECT * FROM product_image_select WHERE product_id = '3881'
297 0.0003 0.00028109550476074
SELECT * FROM productcustomimages WHERE product_id = '3881'
298 0.0003 0.00028800964355469
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
299 0.0003 0.00028896331787109
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
300 0.0003 0.0003349781036377
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
301 0.0004 0.00035214424133301
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
302 0.0004 0.00039505958557129
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
303 0.0004 0.0003659725189209
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
304 0.0005 0.00045299530029297
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
305 0.0006 0.00056910514831543
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
306 0.0006 0.00056314468383789
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
307 0.0004 0.00042915344238281
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'