0

Natives, 3 boîtes empilables à thé carré "Mon jardin sucré"

Price: Click Button for Price
Product prices and availability are accurate as of 2021-07-22 03:17:27 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.

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

Wait! We have a something for you...

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

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

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
2.10786485672 323 1.7364 0


No Amazon API Requests Made.


App Debug - Total Time 2.10786485672 seconds

Number Time From Start Name Description
1 0.3636839389801 Initialise Initialise FSB Function
2 0.36580586433411 App Controller Start Start of the App controller (called before the controller of every page)
3 0.40556001663208 Start of getCategoryListByGroup Function Before first category groups query
4 0.40610504150391 After initial query Before first category groups query
5 0.40610599517822 Get Category List for Group Before the call to getCategoryList function
6 0.40610790252686 Start of GetCategoryList function Start of the function
7 0.40611100196838 Before getting categories Query to get specific category list
8 0.40670394897461 After getting categories Query to get specific category list
9 0.40670490264893 Before getting category custom Before call to function getCategoryCustom
10 0.43322682380676 After getting category custom After call to function getCategoryCustom
11 0.43322896957397 Before getting category custom Before call to function getCategoryCustom
12 0.44900798797607 After getting category custom After call to function getCategoryCustom
13 0.44900989532471 Before getting category custom Before call to function getCategoryCustom
14 0.45637488365173 After getting category custom After call to function getCategoryCustom
15 0.45637583732605 Before getting category custom Before call to function getCategoryCustom
16 0.46359586715698 After getting category custom After call to function getCategoryCustom
17 0.46359801292419 Before getting category custom Before call to function getCategoryCustom
18 0.47241282463074 After getting category custom After call to function getCategoryCustom
19 0.47241401672363 Before getting category custom Before call to function getCategoryCustom
20 0.47956395149231 After getting category custom After call to function getCategoryCustom
21 0.47956585884094 End of GetCategoryList function End of the function
22 0.47956991195679 Get Category List for Group Before the call to getCategoryList function
23 0.47957181930542 Start of GetCategoryList function Start of the function
24 0.47957301139832 Before getting categories Query to get specific category list
25 0.48093700408936 End of getCategoryListByGroup Function Before return()
26 1.8198578357697 App Controller End End of the App controller (called before the controller of every page)
27 1.820277929306 Product Start Start of the product info controller
28 1.822173833847 Cache file not found Starting get product details
29 1.8685989379883 Related products Start getting related products if enabled
30 1.8686008453369 Related Products Start Before the related products are found
31 1.8686058521271 Related Products Keywords Before the related product keywords are found
32 1.8686139583588 Create Keyword List Function Start of function
33 1.8686950206757 Create Keyword List Function After looping provided content - 27 keywords found
34 1.8691940307617 Create Keyword List Function After looping initial keyword list - 25 keywords remaining
35 1.869197845459 Create Keyword List Function After reducing keyword list
36 1.8692319393158 Create Keyword List Function After selecting by scoring keywords
37 1.8692350387573 Create Keyword List Function After final loop of keywords
38 1.8692359924316 Related Products Keywords After the related product keywords are found
39 1.9892809391022 Related Products End After the related products are found
40 2.0434718132019 Product End End of the product info controller (Product Info)
41 2.0443859100342 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 2.0452690124512 Before Get Options Before the call to getOptions in the tpl class
43 2.0970559120178 After Get Options After the call to getOptions in the tpl class
44 2.0971758365631 App_after Controller End End of the App_after controller (called after the controller of every page)
45 2.0971989631653 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 2.1002278327942 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 2.1002309322357 Product Info: Before Template Display Before the template is displayed
48 2.1078479290009 Product Info: After Template Display After the template is displayed
49 2.1078560352325 Finalizing debug Before the debug is output to the page.
50 2.1078639030457 End of App This is the end of the app logging, final timestamp


Query Debug - 323 Database Queries. Total time 1.7364 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0010 0.0010209083557129
SELECT parameter, value FROM parameters
2 0.0069 0.0068860054016113
SELECT * FROM `bad_bots`
3 0.0015 0.0015349388122559
SET time_zone = 'Europe/London'
4 0.0010 0.00096797943115234
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0010 0.001025915145874
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"18.117.185.140\";}'
6 0.0007 0.00065994262695312
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1746057092'
7 0.0008 0.00078511238098145
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0006 0.00058698654174805
UPDATE autorun SET lastrun = '2025-04-30 23:51:32' WHERE id = '16'
9 0.0004 0.00041413307189941
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0006 0.00062298774719238
SELECT id FROM pages WHERE pagename = 'natives-3-botes-empilables-the-carre-mon-jardin-sucre' LIMIT 1
11 0.0007 0.0007469654083252
SELECT id FROM products WHERE pagename = 'natives-3-botes-empilables-the-carre-mon-jardin-sucre' AND hidden = 0 LIMIT 1
12 0.0018 0.0018079280853271
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13 0.0370 0.036962032318115
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14 0.0005 0.00050902366638184
SELECT * FROM pages WHERE pagename = 'natives-3-botes-empilables-the-carre-mon-jardin-sucre'
15 0.0005 0.00053501129150391
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0006 0.0005800724029541
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0126 0.01255202293396
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
18 0.0014 0.0014338493347168
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
19 0.0007 0.00072193145751953
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20 0.0005 0.00045204162597656
SELECT id FROM categories WHERE parent_id = '26'
21 0.0089 0.0089070796966553
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
22 0.0006 0.00059890747070312
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0 
23 0.0007 0.00066900253295898
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
24 0.0006 0.00058197975158691
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25 0.0005 0.00051307678222656
SELECT * FROM categorygroups WHERE id = '1'
26 0.0055 0.0055480003356934
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
27 0.0010 0.0010108947753906
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
28 0.0005 0.00048184394836426
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29 0.0006 0.00055289268493652
SELECT id FROM categories WHERE parent_id = '27'
30 0.0059 0.0058989524841309
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
31 0.0006 0.00058698654174805
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
32 0.0007 0.00065112113952637
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
33 0.0005 0.00052189826965332
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34 0.0005 0.0004730224609375
SELECT * FROM categorygroups WHERE id = '1'
35 0.0018 0.0018160343170166
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
36 0.0005 0.00051403045654297
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
37 0.0005 0.00050902366638184
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38 0.0005 0.00047588348388672
SELECT id FROM categories WHERE parent_id = '28'
39 0.0019 0.0018608570098877
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
40 0.0006 0.00055789947509766
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0 
41 0.0006 0.00058984756469727
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
42 0.0006 0.00056314468383789
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43 0.0005 0.00045108795166016
SELECT * FROM categorygroups WHERE id = '1'
44 0.0007 0.00071001052856445
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
45 0.0006 0.00056600570678711
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
46 0.0005 0.00045990943908691
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47 0.0004 0.00044417381286621
SELECT id FROM categories WHERE parent_id = '29'
48 0.0007 0.00071597099304199
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
49 0.0013 0.0012710094451904
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0 
50 0.0011 0.0011179447174072
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
51 0.0011 0.0010550022125244
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52 0.0008 0.0008399486541748
SELECT * FROM categorygroups WHERE id = '1'
53 0.0012 0.0012309551239014
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
54 0.0010 0.00098204612731934
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
55 0.0008 0.00075697898864746
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56 0.0007 0.00072383880615234
SELECT id FROM categories WHERE parent_id = '30'
57 0.0015 0.001471996307373
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
58 0.0009 0.00093817710876465
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0 
59 0.0010 0.00099301338195801
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
60 0.0009 0.00091695785522461
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61 0.0008 0.00077414512634277
SELECT * FROM categorygroups WHERE id = '1'
62 0.0015 0.0015120506286621
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
63 0.0007 0.00074410438537598
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
64 0.0005 0.0005340576171875
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65 0.0006 0.00064396858215332
SELECT id FROM categories WHERE parent_id = '31'
66 0.0011 0.0010809898376465
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
67 0.0007 0.0006871223449707
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
68 0.0007 0.00072002410888672
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
69 0.0006 0.0006258487701416
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70 0.0006 0.00058102607727051
SELECT * FROM categorygroups WHERE id = '1'
71 0.0014 0.0013599395751953
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
72 0.0029 0.0028681755065918
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73 0.0009 0.00085902214050293
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74 0.0006 0.00064611434936523
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
75 0.0009 0.0009310245513916
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76 0.0058 0.0057690143585205
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77 0.0010 0.0010111331939697
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78 1.3239 1.3239028453827
SELECT * FROM ipgeocountries WHERE INET_ATON('18.117.185.140') >= INET_ATON(ip_start) AND INET_ATON('18.117.185.140') <= INET_ATON(ip_end)
79 0.0016 0.0015890598297119
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80 0.0006 0.00057077407836914
SELECT * FROM countryredirects WHERE countrycode = 'US'
81 0.0006 0.00062799453735352
SELECT * FROM products WHERE pagename = 'natives-3-botes-empilables-the-carre-mon-jardin-sucre'
82 0.0005 0.00049901008605957
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1832
83 0.0008 0.00076484680175781
SELECT * FROM manufacturers WHERE id = '206'
84 0.0005 0.00053286552429199
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '206'
85 0.0005 0.00046014785766602
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '206' LIMIT 1
86 0.0007 0.0006859302520752
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '206' ORDER BY RAND() LIMIT 1
87 0.0004 0.00040602684020996
SELECT * FROM productimages WHERE product_id = '1293' ORDER BY sortorder ASC
88 0.0005 0.00048398971557617
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '206'
89 0.0005 0.00048398971557617
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '206'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
90 0.0003 0.00034999847412109
SELECT * FROM manufacturerimages WHERE manufacturer_id = '206'
91 0.0005 0.00051617622375488
SELECT category_id FROM products_categories WHERE product_id = '1832'
92 0.0006 0.00056695938110352
SELECT * FROM categories WHERE id = '26'
93 0.0053 0.0053081512451172
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
94 0.0005 0.00046992301940918
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
95 0.0003 0.00033116340637207
SELECT id FROM categories WHERE parent_id = '26'
96 0.0052 0.0051569938659668
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
97 0.0005 0.00052404403686523
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0 
98 0.0005 0.00054311752319336
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
99 0.0005 0.00046586990356445
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
100 0.0005 0.00049591064453125
SELECT * FROM productimages WHERE product_id = '1832' ORDER BY sortorder ASC
101 0.0005 0.0004889965057373
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1832' AND p.id = pi.product_id ORDER BY pi.sortorder
102 0.0006 0.00060796737670898
SELECT * FROM product_image_select WHERE product_id = '1832'
103 0.0004 0.00037598609924316
SELECT * FROM productcustomimages WHERE product_id = '1832'
104 0.0005 0.00045084953308105
SELECT * FROM productfeeds WHERE product_id = '1832' ORDER BY item_date DESC
105 0.0007 0.00069808959960938
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '1832' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
106 0.0011 0.0011360645294189
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '1832' AND t.hidden = 0 AND display_product = 1
107 0.0004 0.0003809928894043
SELECT * FROM tags WHERE id = '62'
108 0.0016 0.0015761852264404
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '62'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
109 0.0015 0.0014619827270508
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '62'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
110 0.0014 0.0014297962188721
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '62' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
111 0.0006 0.00058698654174805
SELECT * FROM productimages WHERE product_id = '1215' ORDER BY sortorder ASC
112 0.0003 0.00032401084899902
SELECT * FROM tags WHERE id = '216'
113 0.0027 0.002655029296875
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
114 0.0026 0.0026180744171143
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 
115 0.0025 0.0025160312652588
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
116 0.0004 0.00043702125549316
SELECT * FROM productimages WHERE product_id = '4122' ORDER BY sortorder ASC
117 0.0005 0.00052785873413086
SELECT * FROM productamazoncontent WHERE product_id = '1832'
118 0.0005 0.00052499771118164
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 = '1832'
                GROUP BY o.product_id
119 0.0029 0.002856969833374
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     = '1832'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
120 0.0006 0.00055408477783203
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1832
121 0.0008 0.00079894065856934
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1832' AND a.name = n.originalname
122 0.0004 0.00039005279541016
SELECT * FROM productoffers WHERE product_id = '1832' AND merchantid = 'A1X6FK5RDHNB96'
123 0.0004 0.00040006637573242
SELECT * FROM productoffers
                WHERE product_id = '1832' AND price > 0
                ORDER BY price ASC LIMIT 1
124 0.0004 0.00037789344787598
SELECT * FROM productoffers
                WHERE product_id = 1832
                ORDER BY price ASC LIMIT 1
125 0.0004 0.00041604042053223
SELECT value FROM productattributes
                WHERE product_id = '1832'
                AND name = 'ListPriceAmount'
126 0.0004 0.00037598609924316
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 = '1832'
                GROUP BY o.product_id
127 0.0006 0.00056695938110352
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     = '1832'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
128 0.0004 0.00037312507629395
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1832
129 0.0005 0.00052094459533691
SELECT value FROM productattributes WHERE product_id = '1832' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
130 0.0004 0.00039005279541016
SELECT * FROM products WHERE parent_id = '1832'
131 0.0005 0.00050091743469238
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
132 0.0130 0.012974977493286
SELECT *, MATCH (description, title) AGAINST ('andquotmon jardin sucréandquot' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('andquotmon jardin sucréandquot' IN BOOLEAN MODE) AND 1832 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
133 0.0016 0.0015640258789062
SELECT *, MATCH (description, title) AGAINST ('andquotmon jardin sucréandquot' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('andquotmon jardin sucréandquot' IN BOOLEAN MODE) AND 1832 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
134 0.0014 0.0013580322265625
SELECT *, MATCH (description, title) AGAINST ('andquotmon jardin sucréandquot' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('andquotmon jardin sucréandquot' IN BOOLEAN MODE) AND 1832 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
135 0.0010 0.001025915145874
SELECT * FROM productimages WHERE product_id = '4505' ORDER BY sortorder ASC
136 0.0009 0.00092601776123047
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4505' AND p.id = pi.product_id ORDER BY pi.sortorder
137 0.0016 0.001582145690918
SELECT * FROM product_image_select WHERE product_id = '4505'
138 0.0008 0.00080585479736328
SELECT * FROM productcustomimages WHERE product_id = '4505'
139 0.0010 0.0010490417480469
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 = '4505'
                GROUP BY o.product_id
140 0.0014 0.0014340877532959
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     = '4505'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
141 0.0009 0.00091385841369629
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4505
142 0.0017 0.001708984375
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4505' AND a.name = n.originalname
143 0.0006 0.00063586235046387
SELECT * FROM productoffers WHERE product_id = '4505' AND merchantid = 'A1X6FK5RDHNB96'
144 0.0006 0.00064492225646973
SELECT * FROM productoffers
                WHERE product_id = '4505' AND price > 0
                ORDER BY price ASC LIMIT 1
145 0.0006 0.00059795379638672
SELECT * FROM productoffers
                WHERE product_id = 4505
                ORDER BY price ASC LIMIT 1
146 0.0006 0.00063705444335938
SELECT value FROM productattributes
                WHERE product_id = '4505'
                AND name = 'ListPriceAmount'
147 0.0007 0.0007011890411377
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 = '4505'
                GROUP BY o.product_id
148 0.0011 0.0011100769042969
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     = '4505'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
149 0.0007 0.00065898895263672
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4505
150 0.0009 0.00094294548034668
SELECT value FROM productattributes WHERE product_id = '4505' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
151 0.0011 0.0011179447174072
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4505'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'PackageQuantity'
                GROUP BY o.value
                ORDER BY o.value ASC
152 0.0008 0.00078392028808594
SELECT * FROM products WHERE parent_id = '4505'
153 0.0010 0.00095701217651367
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4506' AND a.name = n.originalname
154 0.0007 0.0006568431854248
SELECT * FROM productoffers WHERE product_id = '4506' AND merchantid = 'A1X6FK5RDHNB96'
155 0.0006 0.00061798095703125
SELECT * FROM productimages WHERE product_id = '2835' ORDER BY sortorder ASC
156 0.0008 0.00080490112304688
SELECT * FROM product_image_select WHERE product_id = '2835'
157 0.0005 0.00047707557678223
SELECT * FROM productcustomimages WHERE product_id = '2835'
158 0.0011 0.0010960102081299
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2835' AND a.name = n.originalname
159 0.0006 0.00059413909912109
SELECT * FROM productoffers WHERE product_id = '2835' AND merchantid = 'A1X6FK5RDHNB96'
160 0.0005 0.00046992301940918
SELECT * FROM productoffers
                WHERE product_id = '2835' AND price > 0
                ORDER BY price ASC LIMIT 1
161 0.0005 0.00053501129150391
SELECT value FROM productattributes WHERE product_id = '2835' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
162 0.0007 0.00067019462585449
SELECT * FROM productimages WHERE product_id = '4474' ORDER BY sortorder ASC
163 0.0007 0.00067591667175293
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4474' AND p.id = pi.product_id ORDER BY pi.sortorder
164 0.0008 0.00078797340393066
SELECT * FROM product_image_select WHERE product_id = '4474'
165 0.0005 0.00052905082702637
SELECT * FROM productcustomimages WHERE product_id = '4474'
166 0.0007 0.0006721019744873
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 = '4474'
                GROUP BY o.product_id
167 0.0008 0.00081491470336914
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     = '4474'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
168 0.0005 0.00046992301940918
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4474
169 0.0009 0.00092506408691406
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4474' AND a.name = n.originalname
170 0.0004 0.00041890144348145
SELECT * FROM productoffers WHERE product_id = '4474' AND merchantid = 'A1X6FK5RDHNB96'
171 0.0004 0.0004270076751709
SELECT * FROM productoffers
                WHERE product_id = '4474' AND price > 0
                ORDER BY price ASC LIMIT 1
172 0.0004 0.00035595893859863
SELECT * FROM productoffers
                WHERE product_id = 4474
                ORDER BY price ASC LIMIT 1
173 0.0004 0.00040793418884277
SELECT value FROM productattributes
                WHERE product_id = '4474'
                AND name = 'ListPriceAmount'
174 0.0005 0.00047183036804199
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 = '4474'
                GROUP BY o.product_id
175 0.0007 0.00070595741271973
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     = '4474'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
176 0.0004 0.00043201446533203
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4474
177 0.0007 0.00070285797119141
SELECT value FROM productattributes WHERE product_id = '4474' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
178 0.0008 0.00078582763671875
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4474'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'PackageQuantity'
                GROUP BY o.value
                ORDER BY o.value ASC
179 0.0005 0.0004889965057373
SELECT * FROM products WHERE parent_id = '4474'
180 0.0007 0.00066018104553223
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4697' AND a.name = n.originalname
181 0.0006 0.00055193901062012
SELECT * FROM productoffers WHERE product_id = '4697' AND merchantid = 'A1X6FK5RDHNB96'
182 0.0093 0.0093438625335693
SELECT *, MATCH (description, title) AGAINST ('boÃtes empilables Ã' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('boÃtes empilables Ã' IN BOOLEAN MODE) AND 1832 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
183 0.0006 0.00056195259094238
SELECT *, MATCH (description, title) AGAINST ('boÃtes empilables Ã' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('boÃtes empilables Ã' IN BOOLEAN MODE) AND 1832 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
184 0.0005 0.00053596496582031
SELECT *, MATCH (description, title) AGAINST ('boÃtes empilables Ã' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('boÃtes empilables Ã' IN BOOLEAN MODE) AND 1832 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
185 0.0004 0.00044608116149902
SELECT * FROM productimages WHERE product_id = '792' ORDER BY sortorder ASC
186 0.0007 0.00071096420288086
SELECT * FROM product_image_select WHERE product_id = '792'
187 0.0005 0.00048589706420898
SELECT * FROM productcustomimages WHERE product_id = '792'
188 0.0011 0.0011341571807861
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '792' AND a.name = n.originalname
189 0.0005 0.0004880428314209
SELECT * FROM productoffers WHERE product_id = '792' AND merchantid = 'A1X6FK5RDHNB96'
190 0.0005 0.00051498413085938
SELECT * FROM productoffers
                WHERE product_id = '792' AND price > 0
                ORDER BY price ASC LIMIT 1
191 0.0004 0.00043296813964844
SELECT value FROM productattributes WHERE product_id = '792' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
192 0.0030 0.0029680728912354
SELECT categories.id, COUNT(*) as productcount FROM products_categories, categories WHERE categories.id IN (SELECT category_id FROM products_categories WHERE product_id = '1832') AND products_categories.category_id = categories.id GROUP BY categories.id ORDER BY productcount ASC
193 0.0321 0.032078981399536
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 <> '1832' ORDER BY RAND()
194 0.0008 0.00078415870666504
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 <> '1832' ORDER BY RAND()
195 0.0005 0.00052714347839355
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 <> '1832' ORDER BY RAND()
196 0.0006 0.00058507919311523
SELECT * FROM productimages WHERE product_id = '2926' ORDER BY sortorder ASC
197 0.0006 0.00063490867614746
SELECT * FROM product_image_select WHERE product_id = '2926'
198 0.0004 0.00043320655822754
SELECT * FROM productcustomimages WHERE product_id = '2926'
199 0.0011 0.0010619163513184
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2926' AND a.name = n.originalname
200 0.0005 0.00048303604125977
SELECT * FROM productoffers WHERE product_id = '2926' AND merchantid = 'A1X6FK5RDHNB96'
201 0.0004 0.00039196014404297
SELECT * FROM productoffers
                WHERE product_id = '2926' AND price > 0
                ORDER BY price ASC LIMIT 1
202 0.0003 0.00032782554626465
SELECT * FROM productoffers
                WHERE product_id = 2926
                ORDER BY price ASC LIMIT 1
203 0.0004 0.00039911270141602
SELECT value FROM productattributes
                WHERE product_id = '2926'
                AND name = 'ListPriceAmount'
204 0.0004 0.00040817260742188
SELECT value FROM productattributes WHERE product_id = '2926' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
205 0.0006 0.00056290626525879
SELECT * FROM productimages WHERE product_id = '822' ORDER BY sortorder ASC
206 0.0006 0.00057196617126465
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '822' AND p.id = pi.product_id ORDER BY pi.sortorder
207 0.0006 0.00057506561279297
SELECT * FROM product_image_select WHERE product_id = '822'
208 0.0004 0.00037693977355957
SELECT * FROM productcustomimages WHERE product_id = '822'
209 0.0005 0.00053000450134277
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 = '822'
                GROUP BY o.product_id
210 0.0006 0.00063800811767578
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     = '822'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
211 0.0005 0.0004889965057373
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 822
212 0.0010 0.00098800659179688
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '822' AND a.name = n.originalname
213 0.0004 0.00040817260742188
SELECT * FROM productoffers WHERE product_id = '822' AND merchantid = 'A1X6FK5RDHNB96'
214 0.0004 0.00037503242492676
SELECT * FROM productoffers
                WHERE product_id = '822' AND price > 0
                ORDER BY price ASC LIMIT 1
215 0.0004 0.00036096572875977
SELECT * FROM productoffers
                WHERE product_id = 822
                ORDER BY price ASC LIMIT 1
216 0.0004 0.00037598609924316
SELECT value FROM productattributes
                WHERE product_id = '822'
                AND name = 'ListPriceAmount'
217 0.0004 0.00044703483581543
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 = '822'
                GROUP BY o.product_id
218 0.0007 0.00067281723022461
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     = '822'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
219 0.0004 0.00042104721069336
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 822
220 0.0005 0.00052809715270996
SELECT value FROM productattributes WHERE product_id = '822' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
221 0.0006 0.00061798095703125
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '822'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
222 0.0004 0.00038814544677734
SELECT id,asin FROM products WHERE parent_id = 1832
223 0.0005 0.00048518180847168
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1832' ORDER BY timestamp DESC
224 0.0004 0.00044584274291992
SELECT category_id FROM products_categories WHERE product_id = '1832'
225 0.0005 0.00054097175598145
SELECT * FROM categories WHERE id = '26'
226 0.0055 0.0054669380187988
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
227 0.0005 0.0005040168762207
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
228 0.0004 0.00035595893859863
SELECT id FROM categories WHERE parent_id = '26'
229 0.0054 0.0054459571838379
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 
230 0.0007 0.00065302848815918
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 
231 0.0006 0.00058507919311523
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
232 0.0005 0.00049114227294922
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
233 0.0008 0.00080490112304688
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1832' AND a.name = n.originalname
234 0.0005 0.00048708915710449
SELECT * FROM productoffers WHERE product_id = '1832' AND merchantid = 'A1X6FK5RDHNB96'
235 0.0003 0.00034713745117188
SELECT * FROM productoffers
                WHERE product_id = '1832' AND price > 0
                ORDER BY price ASC LIMIT 1
236 0.0003 0.00033998489379883
SELECT * FROM productoffers
                WHERE product_id = 1832
                ORDER BY price ASC LIMIT 1
237 0.0004 0.0003669261932373
SELECT value FROM productattributes
                WHERE product_id = '1832'
                AND name = 'ListPriceAmount'
238 0.0005 0.00053691864013672
SELECT * FROM products WHERE id = '1832'
239 0.0004 0.00039005279541016
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 = '1832'
                GROUP BY o.product_id
240 0.0005 0.00053596496582031
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     = '1832'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
241 0.0004 0.00035595893859863
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1832
242 0.0005 0.00047802925109863
SELECT value FROM productattributes WHERE product_id = '1832' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
243 0.0007 0.00067305564880371
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1832' AND a.name = n.originalname
244 0.0003 0.00033903121948242
SELECT * FROM productoffers WHERE product_id = '1832' AND merchantid = 'A1X6FK5RDHNB96'
245 0.0004 0.0003960132598877
SELECT * FROM productoffers
                WHERE product_id = '1832' AND price > 0
                ORDER BY price ASC LIMIT 1
246 0.0004 0.00037097930908203
SELECT * FROM productoffers
                WHERE product_id = 1832
                ORDER BY price ASC LIMIT 1
247 0.0004 0.00039315223693848
SELECT value FROM productattributes
                WHERE product_id = '1832'
                AND name = 'ListPriceAmount'
248 0.0006 0.00062298774719238
SELECT category_id FROM products_categories WHERE product_id = '1832' AND prod_type = 'amz'
249 0.0007 0.00071310997009277
SELECT parent_id FROM categories WHERE id = '26'
250 0.0004 0.00041294097900391
SELECT * FROM categories WHERE id = '26'
251 0.0151 0.01505184173584
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
252 0.0009 0.0008997917175293
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
253 0.0005 0.00053811073303223
SELECT id FROM categories WHERE parent_id = '26'
254 0.0104 0.010423898696899
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 
255 0.0010 0.00095200538635254
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 
256 0.0008 0.00079703330993652
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
257 0.0007 0.00066494941711426
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
258 0.0006 0.00055599212646484
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
259 0.0005 0.00046801567077637
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
260 0.0004 0.00036215782165527
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
261 0.0142 0.014192819595337
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
262 0.0006 0.00062108039855957
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
263 0.0006 0.00055098533630371
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
264 0.0005 0.00049996376037598
SELECT * FROM products WHERE id = 1626
265 0.0004 0.00041508674621582
SELECT * FROM products WHERE id = 4041
266 0.0004 0.00038909912109375
SELECT * FROM products WHERE id = 4312
267 0.0004 0.00040197372436523
SELECT * FROM products WHERE id = 777
268 0.0004 0.00042414665222168
SELECT * FROM products WHERE id = 3881
269 0.0004 0.00036382675170898
SELECT * FROM products WHERE id = 4213
270 0.0003 0.00033688545227051
SELECT * FROM products WHERE id = '1626'
271 0.0005 0.00052690505981445
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
272 0.0007 0.0006711483001709
SELECT * FROM product_image_select WHERE product_id = '1626'
273 0.0004 0.00042486190795898
SELECT * FROM productcustomimages WHERE product_id = '1626'
274 0.0009 0.00086879730224609
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
275 0.0007 0.00066208839416504
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
276 0.0005 0.00049614906311035
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
277 0.0005 0.00045013427734375
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
278 0.0005 0.00054383277893066
SELECT * FROM products WHERE id = '4041'
279 0.0005 0.00048613548278809
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
280 0.0006 0.00061511993408203
SELECT * FROM product_image_select WHERE product_id = '4041'
281 0.0005 0.00047206878662109
SELECT * FROM productcustomimages WHERE product_id = '4041'
282 0.0011 0.001060962677002
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
283 0.0006 0.00057101249694824
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
284 0.0005 0.00045108795166016
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
285 0.0005 0.00050497055053711
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
286 0.0005 0.00053119659423828
SELECT * FROM products WHERE id = '4312'
287 0.0004 0.00044894218444824
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
288 0.0006 0.00057697296142578
SELECT * FROM product_image_select WHERE product_id = '4312'
289 0.0004 0.00044703483581543
SELECT * FROM productcustomimages WHERE product_id = '4312'
290 0.0011 0.0010559558868408
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
291 0.0006 0.00058913230895996
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
292 0.0005 0.00045394897460938
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
293 0.0004 0.00039219856262207
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
294 0.0006 0.00058698654174805
SELECT * FROM products WHERE id = '777'
295 0.0005 0.00046515464782715
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
296 0.0006 0.00062012672424316
SELECT * FROM product_image_select WHERE product_id = '777'
297 0.0009 0.00085091590881348
SELECT * FROM productcustomimages WHERE product_id = '777'
298 0.0010 0.0010120868682861
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
299 0.0005 0.00049591064453125
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
300 0.0005 0.00048708915710449
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
301 0.0004 0.00040602684020996
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
302 0.0006 0.0005500316619873
SELECT * FROM products WHERE id = '3881'
303 0.0005 0.0005028247833252
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
304 0.0006 0.00055980682373047
SELECT * FROM product_image_select WHERE product_id = '3881'
305 0.0004 0.0003659725189209
SELECT * FROM productcustomimages WHERE product_id = '3881'
306 0.0010 0.001011848449707
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
307 0.0005 0.00045204162597656
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
308 0.0004 0.00037693977355957
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
309 0.0004 0.00043606758117676
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
310 0.0005 0.00049996376037598
SELECT * FROM products WHERE id = '4213'
311 0.0005 0.00049710273742676
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
312 0.0006 0.00056099891662598
SELECT * FROM product_image_select WHERE product_id = '4213'
313 0.0004 0.00042605400085449
SELECT * FROM productcustomimages WHERE product_id = '4213'
314 0.0011 0.0010859966278076
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
315 0.0005 0.00045609474182129
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
316 0.0005 0.00046491622924805
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
317 0.0005 0.00046801567077637
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
318 0.0011 0.0011179447174072
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
319 0.0008 0.0007789134979248
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
320 0.0018 0.0018250942230225
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
321 0.0008 0.00082302093505859
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
322 0.0007 0.00072908401489258
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
323 0.0006 0.00062084197998047
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'