0

Atmosphera - Boîte à thé Contemporain Factory

Price: Click Button for Price
Product prices and availability are accurate as of 2022-06-24 22:44:40 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

BOITE THE X9 COMP FACTO Dimensions : L. 24 x l. 24 x H. 8 cm - Poids : 0.79 kg - Matière : Bois MDF, paulownia et verre

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
1.8955020904541 315 1.1186 0


No Amazon API Requests Made.


App Debug - Total Time 1.8955020904541 seconds

Number Time From Start Name Description
1 0.73314714431763 Initialise Initialise FSB Function
2 0.74507594108582 App Controller Start Start of the App controller (called before the controller of every page)
3 0.78018403053284 Start of getCategoryListByGroup Function Before first category groups query
4 0.78200197219849 After initial query Before first category groups query
5 0.78200507164001 Get Category List for Group Before the call to getCategoryList function
6 0.78201007843018 Start of GetCategoryList function Start of the function
7 0.78201508522034 Before getting categories Query to get specific category list
8 0.78376913070679 After getting categories Query to get specific category list
9 0.78377199172974 Before getting category custom Before call to function getCategoryCustom
10 0.80954909324646 After getting category custom After call to function getCategoryCustom
11 0.80955410003662 Before getting category custom Before call to function getCategoryCustom
12 0.82248497009277 After getting category custom After call to function getCategoryCustom
13 0.82248997688293 Before getting category custom Before call to function getCategoryCustom
14 0.83017110824585 After getting category custom After call to function getCategoryCustom
15 0.83017611503601 Before getting category custom Before call to function getCategoryCustom
16 0.83676099777222 After getting category custom After call to function getCategoryCustom
17 0.83676695823669 Before getting category custom Before call to function getCategoryCustom
18 0.84169793128967 After getting category custom After call to function getCategoryCustom
19 0.84170293807983 Before getting category custom Before call to function getCategoryCustom
20 0.84738397598267 After getting category custom After call to function getCategoryCustom
21 0.84738898277283 End of GetCategoryList function End of the function
22 0.84739995002747 Get Category List for Group Before the call to getCategoryList function
23 0.84740304946899 Start of GetCategoryList function Start of the function
24 0.84740710258484 Before getting categories Query to get specific category list
25 0.84798908233643 End of getCategoryListByGroup Function Before return()
26 1.4725139141083 App Controller End End of the App controller (called before the controller of every page)
27 1.4734580516815 Product Start Start of the product info controller
28 1.476145029068 Cache file not found Starting get product details
29 1.552225112915 Related products Start getting related products if enabled
30 1.5522270202637 Related Products Start Before the related products are found
31 1.5522289276123 Related Products Keywords Before the related product keywords are found
32 1.552237033844 Create Keyword List Function Start of function
33 1.5523669719696 Create Keyword List Function After looping provided content - 15 keywords found
34 1.5532491207123 Create Keyword List Function After looping initial keyword list - 14 keywords remaining
35 1.5532569885254 Create Keyword List Function After reducing keyword list
36 1.5533020496368 Create Keyword List Function After selecting by scoring keywords
37 1.553307056427 Create Keyword List Function After final loop of keywords
38 1.5533089637756 Related Products Keywords After the related product keywords are found
39 1.7101929187775 Related Products End After the related products are found
40 1.7700140476227 Product End End of the product info controller (Product Info)
41 1.7725639343262 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.7747559547424 Before Get Options Before the call to getOptions in the tpl class
43 1.8430309295654 After Get Options After the call to getOptions in the tpl class
44 1.8432230949402 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.8432741165161 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.8592889308929 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.8592970371246 Product Info: Before Template Display Before the template is displayed
48 1.8954589366913 Product Info: After Template Display After the template is displayed
49 1.8954799175262 Finalizing debug Before the debug is output to the page.
50 1.8954999446869 End of App This is the end of the app logging, final timestamp


Query Debug - 315 Database Queries. Total time 1.1186 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0026 0.0025699138641357
SELECT parameter, value FROM parameters
2 0.0049 0.0049440860748291
SELECT * FROM `bad_bots`
3 0.0003 0.00031781196594238
SET time_zone = 'Europe/London'
4 0.0020 0.0020110607147217
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0179 0.017886877059937
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"18.218.219.11\";}'
6 0.0034 0.0033619403839111
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1734847228'
7 0.0035 0.0034549236297607
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0011 0.0010762214660645
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0042 0.0041890144348145
SELECT id FROM pages WHERE pagename = 'atmosphera-bote-the-contemporain-factory' LIMIT 1
10 0.0056 0.0055520534515381
SELECT id FROM products WHERE pagename = 'atmosphera-bote-the-contemporain-factory' AND hidden = 0 LIMIT 1
11 0.0042 0.0041940212249756
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0292 0.02918004989624
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0008 0.00084400177001953
SELECT * FROM pages WHERE pagename = 'atmosphera-bote-the-contemporain-factory'
14 0.0018 0.0017898082733154
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0017 0.0017049312591553
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0072 0.007194995880127
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.0020 0.0019748210906982
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.0013 0.0013070106506348
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0005 0.00051593780517578
SELECT id FROM categories WHERE parent_id = '26'
20 0.0072 0.0072441101074219
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.0031 0.0031299591064453
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.0019 0.0018699169158936
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.0016 0.0015571117401123
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0007 0.00071001052856445
SELECT * FROM categorygroups WHERE id = '1'
25 0.0043 0.0043270587921143
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.0007 0.0006558895111084
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.0005 0.00047898292541504
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0005 0.00054001808166504
SELECT id FROM categories WHERE parent_id = '27'
29 0.0047 0.0046689510345459
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
30 0.0005 0.00051593780517578
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.0006 0.00056600570678711
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.0005 0.00047516822814941
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0005 0.0005028247833252
SELECT * FROM categorygroups WHERE id = '1'
34 0.0020 0.0019519329071045
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.0006 0.00058197975158691
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.0005 0.00045013427734375
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0005 0.0004580020904541
SELECT id FROM categories WHERE parent_id = '28'
38 0.0020 0.0020108222961426
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.0007 0.00066089630126953
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0 
40 0.0005 0.00051403045654297
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.0005 0.00046610832214355
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0004 0.0003969669342041
SELECT * FROM categorygroups WHERE id = '1'
43 0.0007 0.00071883201599121
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.0006 0.00060701370239258
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
45 0.0005 0.00047922134399414
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0004 0.00043892860412598
SELECT id FROM categories WHERE parent_id = '29'
47 0.0008 0.00080108642578125
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.0007 0.00068092346191406
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.0007 0.00072097778320312
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.0007 0.00066995620727539
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0013 0.0012857913970947
SELECT * FROM categorygroups WHERE id = '1'
52 0.0006 0.00063204765319824
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.0005 0.0004889965057373
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.0005 0.00046610832214355
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0004 0.0004279613494873
SELECT id FROM categories WHERE parent_id = '30'
56 0.0007 0.00066113471984863
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.0006 0.00061416625976562
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.0006 0.00056195259094238
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.0005 0.00048398971557617
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0004 0.00043010711669922
SELECT * FROM categorygroups WHERE id = '1'
61 0.0007 0.00065708160400391
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.0005 0.00053310394287109
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.0010 0.00099396705627441
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0006 0.00056314468383789
SELECT id FROM categories WHERE parent_id = '31'
65 0.0007 0.0007469654083252
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.0005 0.00049209594726562
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.0005 0.00051498413085938
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.0006 0.00059103965759277
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0004 0.00039911270141602
SELECT * FROM categorygroups WHERE id = '1'
70 0.0006 0.0005640983581543
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0031 0.0030789375305176
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0019 0.0019299983978271
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0007 0.00065493583679199
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.0015 0.0014891624450684
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0013 0.0012550354003906
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0012 0.001248836517334
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.6082 0.60818004608154
SELECT * FROM ipgeocountries WHERE INET_ATON('18.218.219.11') >= INET_ATON(ip_start) AND INET_ATON('18.218.219.11') <= INET_ATON(ip_end)
78 0.0021 0.002094030380249
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0012 0.001244068145752
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0009 0.00087714195251465
SELECT * FROM products WHERE pagename = 'atmosphera-bote-the-contemporain-factory'
81 0.0008 0.00077199935913086
UPDATE products SET viewcount = viewcount + 1 WHERE id = 2522
82 0.0006 0.00060796737670898
SELECT * FROM manufacturers WHERE id = '423'
83 0.0005 0.00050997734069824
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '423'
84 0.0013 0.0012991428375244
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '423' LIMIT 1
85 0.0016 0.0016019344329834
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '423' ORDER BY RAND() LIMIT 1
86 0.0004 0.00043892860412598
SELECT * FROM productimages WHERE product_id = '3734' ORDER BY sortorder ASC
87 0.0005 0.00047588348388672
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '423'
88 0.0005 0.00053787231445312
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '423'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
89 0.0005 0.00045490264892578
SELECT * FROM manufacturerimages WHERE manufacturer_id = '423'
90 0.0005 0.00045514106750488
SELECT category_id FROM products_categories WHERE product_id = '2522'
91 0.0008 0.00080204010009766
SELECT * FROM categories WHERE id = '26'
92 0.0058 0.0057821273803711
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.0005 0.00045204162597656
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
94 0.0005 0.00047111511230469
SELECT id FROM categories WHERE parent_id = '26'
95 0.0055 0.0054810047149658
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.0006 0.00057101249694824
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.0005 0.00052905082702637
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.0007 0.00067591667175293
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
99 0.0007 0.00069689750671387
SELECT * FROM productimages WHERE product_id = '2522' ORDER BY sortorder ASC
100 0.0006 0.00058102607727051
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2522' AND p.id = pi.product_id ORDER BY pi.sortorder
101 0.0021 0.0020861625671387
SELECT * FROM product_image_select WHERE product_id = '2522'
102 0.0012 0.0011649131774902
SELECT * FROM productcustomimages WHERE product_id = '2522'
103 0.0012 0.0012421607971191
SELECT * FROM productfeeds WHERE product_id = '2522' ORDER BY item_date DESC
104 0.0023 0.0022909641265869
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '2522' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
105 0.0027 0.0027198791503906
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '2522' AND t.hidden = 0 AND display_product = 1
106 0.0015 0.0014810562133789
SELECT * FROM productamazoncontent WHERE product_id = '2522'
107 0.0015 0.0014669895172119
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 = '2522'
                GROUP BY o.product_id
108 0.0024 0.0024218559265137
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     = '2522'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
109 0.0006 0.0005640983581543
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2522
110 0.0008 0.00084590911865234
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2522' AND a.name = n.originalname
111 0.0005 0.00048422813415527
SELECT * FROM productoffers WHERE product_id = '2522' AND merchantid = 'A1X6FK5RDHNB96'
112 0.0004 0.00044918060302734
SELECT * FROM productoffers
                WHERE product_id = '2522' AND price > 0
                ORDER BY price ASC LIMIT 1
113 0.0005 0.00054311752319336
SELECT * FROM productoffers
                WHERE product_id = 2522
                ORDER BY price ASC LIMIT 1
114 0.0010 0.00099897384643555
SELECT value FROM productattributes
                WHERE product_id = '2522'
                AND name = 'ListPriceAmount'
115 0.0011 0.0011420249938965
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 = '2522'
                GROUP BY o.product_id
116 0.0013 0.0012719631195068
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     = '2522'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
117 0.0008 0.00078201293945312
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2522
118 0.0012 0.0011899471282959
SELECT value FROM productattributes WHERE product_id = '2522' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
119 0.0019 0.0018811225891113
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '2522'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
120 0.0117 0.011693954467773
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '2522'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
121 0.0008 0.00084614753723145
SELECT * FROM products WHERE parent_id = '2522'
122 0.0012 0.0011639595031738
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4210' AND a.name = n.originalname
123 0.0010 0.00095987319946289
SELECT * FROM productoffers WHERE product_id = '4210' AND merchantid = 'A1X6FK5RDHNB96'
124 0.0010 0.00096607208251953
SELECT * FROM productoffers
                WHERE product_id = '4210' AND price > 0
                ORDER BY price ASC LIMIT 1
125 0.0013 0.0013220310211182
SELECT * FROM productoffers
                WHERE product_id = 4210
                ORDER BY price ASC LIMIT 1
126 0.0088 0.0087978839874268
SELECT value FROM productattributes
                WHERE product_id = '4210'
                AND name = 'ListPriceAmount'
127 0.0014 0.0013668537139893
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
128 0.0281 0.028074026107788
SELECT *, MATCH (description, title) AGAINST ('thé contemporain factory' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('thé contemporain factory' IN BOOLEAN MODE) AND 2522 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
129 0.0009 0.00085711479187012
SELECT *, MATCH (description, title) AGAINST ('thé contemporain factory' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('thé contemporain factory' IN BOOLEAN MODE) AND 2522 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
130 0.0009 0.00085997581481934
SELECT *, MATCH (description, title) AGAINST ('thé contemporain factory' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('thé contemporain factory' IN BOOLEAN MODE) AND 2522 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
131 0.0112 0.011189937591553
SELECT *, MATCH (description, title) AGAINST ('atmosphera boÃte Ã' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('atmosphera boÃte Ã' IN BOOLEAN MODE) AND 2522 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
132 0.0014 0.0013778209686279
SELECT *, MATCH (description, title) AGAINST ('atmosphera boÃte Ã' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('atmosphera boÃte Ã' IN BOOLEAN MODE) AND 2522 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
133 0.0010 0.0010261535644531
SELECT *, MATCH (description, title) AGAINST ('atmosphera boÃte Ã' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('atmosphera boÃte Ã' IN BOOLEAN MODE) AND 2522 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
134 0.0041 0.0040738582611084
SELECT categories.id, COUNT(*) as productcount FROM products_categories, categories WHERE categories.id IN (SELECT category_id FROM products_categories WHERE product_id = '2522') AND products_categories.category_id = categories.id GROUP BY categories.id ORDER BY productcount ASC
135 0.0259 0.025888919830322
SELECT p.* FROM products p, products_categories pc WHERE p.parent_id = 0 AND p.id = pc.product_id AND pc.category_id = '26' AND pc.prod_type = 'amz'  AND p.id <> '2522' ORDER BY RAND()
136 0.0011 0.0010890960693359
SELECT p.* FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND pc.category_id = '26' AND pc.prod_type = 'ebay' AND p.id <> '2522' ORDER BY RAND()
137 0.0010 0.00096702575683594
SELECT p.* FROM custom_products p, products_categories pc WHERE p.id = pc.product_id AND pc.category_id = '26' AND pc.prod_type = 'custom' AND p.id <> '2522' ORDER BY RAND()
138 0.0008 0.00075006484985352
SELECT * FROM productimages WHERE product_id = '1854' ORDER BY sortorder ASC
139 0.0011 0.0010671615600586
SELECT * FROM product_image_select WHERE product_id = '1854'
140 0.0007 0.00067377090454102
SELECT * FROM productcustomimages WHERE product_id = '1854'
141 0.0012 0.0011940002441406
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1854' AND a.name = n.originalname
142 0.0007 0.00069499015808105
SELECT * FROM productoffers WHERE product_id = '1854' AND merchantid = 'A1X6FK5RDHNB96'
143 0.0005 0.0005190372467041
SELECT * FROM productoffers
                WHERE product_id = '1854' AND price > 0
                ORDER BY price ASC LIMIT 1
144 0.0005 0.00045585632324219
SELECT * FROM productoffers
                WHERE product_id = 1854
                ORDER BY price ASC LIMIT 1
145 0.0006 0.00056695938110352
SELECT value FROM productattributes
                WHERE product_id = '1854'
                AND name = 'ListPriceAmount'
146 0.0008 0.00078105926513672
SELECT value FROM productattributes WHERE product_id = '1854' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
147 0.0007 0.00072503089904785
SELECT * FROM productimages WHERE product_id = '2186' ORDER BY sortorder ASC
148 0.0009 0.00087308883666992
SELECT * FROM product_image_select WHERE product_id = '2186'
149 0.0008 0.00075602531433105
SELECT * FROM productcustomimages WHERE product_id = '2186'
150 0.0014 0.001399040222168
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2186' AND a.name = n.originalname
151 0.0011 0.0010910034179688
SELECT * FROM productoffers WHERE product_id = '2186' AND merchantid = 'A1X6FK5RDHNB96'
152 0.0014 0.0014081001281738
SELECT * FROM productoffers
                WHERE product_id = '2186' AND price > 0
                ORDER BY price ASC LIMIT 1
153 0.0009 0.00094914436340332
SELECT * FROM productoffers
                WHERE product_id = 2186
                ORDER BY price ASC LIMIT 1
154 0.0015 0.0014500617980957
SELECT value FROM productattributes
                WHERE product_id = '2186'
                AND name = 'ListPriceAmount'
155 0.0011 0.0011019706726074
SELECT value FROM productattributes WHERE product_id = '2186' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
156 0.0017 0.0017130374908447
SELECT * FROM productimages WHERE product_id = '1861' ORDER BY sortorder ASC
157 0.0015 0.0014669895172119
SELECT * FROM product_image_select WHERE product_id = '1861'
158 0.0017 0.0016748905181885
SELECT * FROM productcustomimages WHERE product_id = '1861'
159 0.0014 0.0014059543609619
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1861' AND a.name = n.originalname
160 0.0008 0.00078487396240234
SELECT * FROM productoffers WHERE product_id = '1861' AND merchantid = 'A1X6FK5RDHNB96'
161 0.0006 0.00063705444335938
SELECT * FROM productoffers
                WHERE product_id = '1861' AND price > 0
                ORDER BY price ASC LIMIT 1
162 0.0006 0.00060009956359863
SELECT value FROM productattributes WHERE product_id = '1861' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
163 0.0009 0.0008540153503418
SELECT * FROM productimages WHERE product_id = '4804' ORDER BY sortorder ASC
164 0.0019 0.0018630027770996
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4804' AND p.id = pi.product_id ORDER BY pi.sortorder
165 0.0011 0.0011148452758789
SELECT * FROM product_image_select WHERE product_id = '4804'
166 0.0007 0.00071382522583008
SELECT * FROM productcustomimages WHERE product_id = '4804'
167 0.0011 0.0010662078857422
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 = '4804'
                GROUP BY o.product_id
168 0.0013 0.0012960433959961
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     = '4804'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
169 0.0007 0.00067996978759766
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4804
170 0.0022 0.0022377967834473
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4804' AND a.name = n.originalname
171 0.0008 0.00076794624328613
SELECT * FROM productoffers WHERE product_id = '4804' AND merchantid = 'A1X6FK5RDHNB96'
172 0.0007 0.00065493583679199
SELECT * FROM productoffers
                WHERE product_id = '4804' AND price > 0
                ORDER BY price ASC LIMIT 1
173 0.0006 0.00057888031005859
SELECT * FROM productoffers
                WHERE product_id = 4804
                ORDER BY price ASC LIMIT 1
174 0.0008 0.0007789134979248
SELECT value FROM productattributes
                WHERE product_id = '4804'
                AND name = 'ListPriceAmount'
175 0.0007 0.00068998336791992
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 = '4804'
                GROUP BY o.product_id
176 0.0011 0.0011200904846191
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     = '4804'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
177 0.0006 0.00061583518981934
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4804
178 0.0010 0.00099587440490723
SELECT value FROM productattributes WHERE product_id = '4804' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
179 0.0010 0.0010190010070801
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4804'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
180 0.0007 0.00067305564880371
SELECT * FROM products WHERE parent_id = '4804'
181 0.0013 0.0013420581817627
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4815' AND a.name = n.originalname
182 0.0008 0.00084209442138672
SELECT * FROM productoffers WHERE product_id = '4815' AND merchantid = 'A1X6FK5RDHNB96'
183 0.0006 0.00058388710021973
SELECT * FROM productoffers
                WHERE product_id = '4815' AND price > 0
                ORDER BY price ASC LIMIT 1
184 0.0005 0.00054097175598145
SELECT * FROM productoffers
                WHERE product_id = 4815
                ORDER BY price ASC LIMIT 1
185 0.0007 0.00069308280944824
SELECT value FROM productattributes
                WHERE product_id = '4815'
                AND name = 'ListPriceAmount'
186 0.0008 0.00084996223449707
SELECT * FROM productimages WHERE product_id = '4232' ORDER BY sortorder ASC
187 0.0011 0.0011308193206787
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4232' AND p.id = pi.product_id ORDER BY pi.sortorder
188 0.0010 0.00097393989562988
SELECT * FROM product_image_select WHERE product_id = '4232'
189 0.0006 0.00064396858215332
SELECT * FROM productcustomimages WHERE product_id = '4232'
190 0.0023 0.002284049987793
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 = '4232'
                GROUP BY o.product_id
191 0.0011 0.0010828971862793
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     = '4232'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
192 0.0008 0.00078678131103516
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4232
193 0.0021 0.0020890235900879
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4232' AND a.name = n.originalname
194 0.0006 0.00062394142150879
SELECT * FROM productoffers WHERE product_id = '4232' AND merchantid = 'A1X6FK5RDHNB96'
195 0.0007 0.00069212913513184
SELECT * FROM productoffers
                WHERE product_id = '4232' AND price > 0
                ORDER BY price ASC LIMIT 1
196 0.0006 0.00058913230895996
SELECT * FROM productoffers
                WHERE product_id = 4232
                ORDER BY price ASC LIMIT 1
197 0.0007 0.0006709098815918
SELECT value FROM productattributes
                WHERE product_id = '4232'
                AND name = 'ListPriceAmount'
198 0.0008 0.00077295303344727
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 = '4232'
                GROUP BY o.product_id
199 0.0012 0.0011520385742188
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     = '4232'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
200 0.0007 0.00070095062255859
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4232
201 0.0009 0.0009300708770752
SELECT value FROM productattributes WHERE product_id = '4232' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
202 0.0010 0.0010120868682861
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4232'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
203 0.0015 0.001507043838501
SELECT * FROM productimages WHERE product_id = '2461' ORDER BY sortorder ASC
204 0.0023 0.0023019313812256
SELECT * FROM product_image_select WHERE product_id = '2461'
205 0.0024 0.002439022064209
SELECT * FROM productcustomimages WHERE product_id = '2461'
206 0.0012 0.0011889934539795
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2461' AND a.name = n.originalname
207 0.0007 0.00073885917663574
SELECT * FROM productoffers WHERE product_id = '2461' AND merchantid = 'A1X6FK5RDHNB96'
208 0.0005 0.00054216384887695
SELECT * FROM productoffers
                WHERE product_id = '2461' AND price > 0
                ORDER BY price ASC LIMIT 1
209 0.0005 0.00046205520629883
SELECT * FROM productoffers
                WHERE product_id = 2461
                ORDER BY price ASC LIMIT 1
210 0.0005 0.00048089027404785
SELECT value FROM productattributes
                WHERE product_id = '2461'
                AND name = 'ListPriceAmount'
211 0.0007 0.00071883201599121
SELECT value FROM productattributes WHERE product_id = '2461' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
212 0.0009 0.0008690357208252
SELECT id,asin FROM products WHERE parent_id = 2522
213 0.0008 0.00076699256896973
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4210
214 0.0011 0.0011301040649414
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4210
215 0.0026 0.0026450157165527
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2522' ORDER BY timestamp DESC
216 0.0028 0.0028188228607178
SELECT category_id FROM products_categories WHERE product_id = '2522'
217 0.0008 0.00079703330993652
SELECT * FROM categories WHERE id = '26'
218 0.0122 0.012180089950562
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
219 0.0006 0.00061798095703125
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
220 0.0004 0.00042891502380371
SELECT id FROM categories WHERE parent_id = '26'
221 0.0088 0.0087971687316895
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 
222 0.0007 0.0006558895111084
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 
223 0.0007 0.00066804885864258
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
224 0.0006 0.00061488151550293
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
225 0.0009 0.00092697143554688
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2522' AND a.name = n.originalname
226 0.0006 0.00059294700622559
SELECT * FROM productoffers WHERE product_id = '2522' AND merchantid = 'A1X6FK5RDHNB96'
227 0.0005 0.0004889965057373
SELECT * FROM productoffers
                WHERE product_id = '2522' AND price > 0
                ORDER BY price ASC LIMIT 1
228 0.0004 0.00039291381835938
SELECT * FROM productoffers
                WHERE product_id = 2522
                ORDER BY price ASC LIMIT 1
229 0.0005 0.00049400329589844
SELECT value FROM productattributes
                WHERE product_id = '2522'
                AND name = 'ListPriceAmount'
230 0.0008 0.00075078010559082
SELECT * FROM products WHERE id = '2522'
231 0.0006 0.00055718421936035
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 = '2522'
                GROUP BY o.product_id
232 0.0008 0.00076794624328613
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     = '2522'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
233 0.0004 0.00042986869812012
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2522
234 0.0006 0.00063085556030273
SELECT value FROM productattributes WHERE product_id = '2522' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
235 0.0008 0.00080394744873047
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2522' AND a.name = n.originalname
236 0.0004 0.0004119873046875
SELECT * FROM productoffers WHERE product_id = '2522' AND merchantid = 'A1X6FK5RDHNB96'
237 0.0004 0.00042414665222168
SELECT * FROM productoffers
                WHERE product_id = '2522' AND price > 0
                ORDER BY price ASC LIMIT 1
238 0.0004 0.00040102005004883
SELECT * FROM productoffers
                WHERE product_id = 2522
                ORDER BY price ASC LIMIT 1
239 0.0005 0.00045609474182129
SELECT value FROM productattributes
                WHERE product_id = '2522'
                AND name = 'ListPriceAmount'
240 0.0005 0.00049400329589844
SELECT category_id FROM products_categories WHERE product_id = '2522' AND prod_type = 'amz'
241 0.0005 0.00047206878662109
SELECT parent_id FROM categories WHERE id = '26'
242 0.0005 0.00050520896911621
SELECT * FROM categories WHERE id = '26'
243 0.0061 0.0060758590698242
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
244 0.0005 0.0004570484161377
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
245 0.0003 0.00032687187194824
SELECT id FROM categories WHERE parent_id = '26'
246 0.0058 0.0057649612426758
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 
247 0.0007 0.00069785118103027
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 
248 0.0006 0.00060415267944336
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
249 0.0006 0.00059890747070312
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
250 0.0017 0.0017070770263672
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
251 0.0013 0.0013449192047119
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
252 0.0007 0.00068092346191406
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
253 0.0136 0.013570070266724
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
254 0.0017 0.0016899108886719
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
255 0.0006 0.0005800724029541
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
256 0.0006 0.00063395500183105
SELECT * FROM products WHERE id = 1626
257 0.0006 0.00063586235046387
SELECT * FROM products WHERE id = 4041
258 0.0007 0.00065088272094727
SELECT * FROM products WHERE id = 4312
259 0.0006 0.00063109397888184
SELECT * FROM products WHERE id = 777
260 0.0008 0.00083708763122559
SELECT * FROM products WHERE id = 3881
261 0.0006 0.00058507919311523
SELECT * FROM products WHERE id = 4213
262 0.0006 0.0006101131439209
SELECT * FROM products WHERE id = '1626'
263 0.0005 0.00050616264343262
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
264 0.0006 0.00062990188598633
SELECT * FROM product_image_select WHERE product_id = '1626'
265 0.0004 0.00039196014404297
SELECT * FROM productcustomimages WHERE product_id = '1626'
266 0.0010 0.00097799301147461
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
267 0.0005 0.00051498413085938
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
268 0.0005 0.00047802925109863
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
269 0.0005 0.0005040168762207
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
270 0.0006 0.00060892105102539
SELECT * FROM products WHERE id = '4041'
271 0.0005 0.00052881240844727
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
272 0.0007 0.00074005126953125
SELECT * FROM product_image_select WHERE product_id = '4041'
273 0.0006 0.00055694580078125
SELECT * FROM productcustomimages WHERE product_id = '4041'
274 0.0015 0.0014510154724121
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
275 0.0006 0.00060892105102539
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
276 0.0005 0.00045990943908691
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
277 0.0006 0.00056195259094238
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
278 0.0008 0.00082206726074219
SELECT * FROM products WHERE id = '4312'
279 0.0006 0.00062394142150879
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
280 0.0009 0.00094509124755859
SELECT * FROM product_image_select WHERE product_id = '4312'
281 0.0010 0.00095605850219727
SELECT * FROM productcustomimages WHERE product_id = '4312'
282 0.0014 0.0014228820800781
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
283 0.0006 0.00058293342590332
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
284 0.0005 0.00053501129150391
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
285 0.0005 0.00047087669372559
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
286 0.0006 0.00064206123352051
SELECT * FROM products WHERE id = '777'
287 0.0005 0.00049591064453125
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
288 0.0008 0.00079703330993652
SELECT * FROM product_image_select WHERE product_id = '777'
289 0.0005 0.00046110153198242
SELECT * FROM productcustomimages WHERE product_id = '777'
290 0.0014 0.0013699531555176
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
291 0.0006 0.00059199333190918
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
292 0.0005 0.00047707557678223
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
293 0.0005 0.00045299530029297
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
294 0.0011 0.0010600090026855
SELECT * FROM products WHERE id = '3881'
295 0.0009 0.00090503692626953
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
296 0.0006 0.00063300132751465
SELECT * FROM product_image_select WHERE product_id = '3881'
297 0.0005 0.0004570484161377
SELECT * FROM productcustomimages WHERE product_id = '3881'
298 0.0013 0.0013258457183838
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
299 0.0006 0.00059294700622559
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
300 0.0005 0.00051116943359375
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
301 0.0005 0.0005190372467041
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
302 0.0007 0.00067019462585449
SELECT * FROM products WHERE id = '4213'
303 0.0008 0.00075292587280273
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
304 0.0007 0.00069880485534668
SELECT * FROM product_image_select WHERE product_id = '4213'
305 0.0005 0.00047707557678223
SELECT * FROM productcustomimages WHERE product_id = '4213'
306 0.0014 0.0013930797576904
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
307 0.0006 0.00055313110351562
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
308 0.0005 0.00054502487182617
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
309 0.0005 0.00050783157348633
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
310 0.0025 0.0024619102478027
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
311 0.0018 0.0017979145050049
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
312 0.0031 0.003058910369873
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
313 0.0022 0.0021500587463379
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
314 0.0008 0.00083613395690918
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
315 0.0012 0.0012359619140625
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'