0

My Store

«grandes boîtes scandic, de 2 (pour env. 250 g de thé)

only €21,99

[Vert foncé] Boîte à thé en céramique Boîtes à café Spice Jar Tea Cadd...

only €28,77

[Arbre] Boîte à thé en céramique Boîte à thé Boîte à thé Boîte à thé p...

only €28,80

Zeller 15115 Boîte à thé Bois de Polonia Brun 24 x 24 x 7 cm

only €26,84

Youliy Mini boîte à thé rétro en métal Motif paysage

only €5,93

Youliy Mini boîte à thé rétro en métal Motif paysage

only €4,09

Quel plaisir de pouvoir ranger son thé et son rooibos dans une jolie boite agréable à regarder et surtout pratique pour conserver son thé ou son rooibos à l'abris de la lumière et de l'humidité.

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.8182668685913 344 1.0709 0


No Amazon API Requests Made.


App Debug - Total Time 1.8182668685913 seconds

Number Time From Start Name Description
1 0.5507218837738 Initialise Initialise FSB Function
2 0.55176401138306 App Controller Start Start of the App controller (called before the controller of every page)
3 0.61721897125244 Start of getCategoryListByGroup Function Before first category groups query
4 0.61785984039307 After initial query Before first category groups query
5 0.61786293983459 Get Category List for Group Before the call to getCategoryList function
6 0.61786580085754 Start of GetCategoryList function Start of the function
7 0.61787080764771 Before getting categories Query to get specific category list
8 0.61871099472046 After getting categories Query to get specific category list
9 0.61871290206909 Before getting category custom Before call to function getCategoryCustom
10 0.63907694816589 After getting category custom After call to function getCategoryCustom
11 0.63908195495605 Before getting category custom Before call to function getCategoryCustom
12 0.65384292602539 After getting category custom After call to function getCategoryCustom
13 0.65384697914124 Before getting category custom Before call to function getCategoryCustom
14 0.66340494155884 After getting category custom After call to function getCategoryCustom
15 0.663409948349 Before getting category custom Before call to function getCategoryCustom
16 0.6706748008728 After getting category custom After call to function getCategoryCustom
17 0.67067885398865 Before getting category custom Before call to function getCategoryCustom
18 0.67669296264648 After getting category custom After call to function getCategoryCustom
19 0.67669701576233 Before getting category custom Before call to function getCategoryCustom
20 0.68349385261536 After getting category custom After call to function getCategoryCustom
21 0.68349885940552 End of GetCategoryList function End of the function
22 0.68350791931152 Get Category List for Group Before the call to getCategoryList function
23 0.68351101875305 Start of GetCategoryList function Start of the function
24 0.68351483345032 Before getting categories Query to get specific category list
25 0.68464684486389 End of getCategoryListByGroup Function Before return()
26 1.296648979187 App Controller End End of the App controller (called before the controller of every page)
27 1.5573568344116 App_after Controller Start Start of the App_after controller (called after the controller of every page)
28 1.5598449707031 Before Get Options Before the call to getOptions in the tpl class
29 1.6281208992004 After Get Options After the call to getOptions in the tpl class
30 1.6286079883575 App_after Controller End End of the App_after controller (called after the controller of every page)
31 1.8182439804077 Finalizing debug Before the debug is output to the page.
32 1.8182649612427 End of App This is the end of the app logging, final timestamp


Query Debug - 344 Database Queries. Total time 1.0709 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0017 0.001655101776123
SELECT parameter, value FROM parameters
2 0.0047 0.0047152042388916
SELECT * FROM `bad_bots`
3 0.0016 0.0015950202941895
SET time_zone = 'Europe/London'
4 0.0010 0.00095200538635254
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0010 0.0010221004486084
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:11:\"18.97.14.91\";}'
6 0.0008 0.00084090232849121
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1737237073'
7 0.0014 0.0013949871063232
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0006 0.00061202049255371
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0033 0.0033459663391113
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
10 0.0601 0.060070991516113
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
11 0.0013 0.0012528896331787
SELECT * FROM pages WHERE pagename = ''
12 0.0006 0.0006251335144043
SELECT * FROM categorygroups ORDER BY sortorder ASC
13 0.0008 0.00081610679626465
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
14 0.0078 0.0078291893005371
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
15 0.0008 0.000762939453125
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
16 0.0005 0.00052309036254883
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
17 0.0006 0.00064706802368164
SELECT id FROM categories WHERE parent_id = '26'
18 0.0072 0.0072121620178223
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 
19 0.0010 0.00098013877868652
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 
20 0.0010 0.00097417831420898
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
21 0.0007 0.00069594383239746
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
22 0.0005 0.00054001808166504
SELECT * FROM categorygroups WHERE id = '1'
23 0.0045 0.0045080184936523
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
24 0.0007 0.00065088272094727
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
25 0.0005 0.00051403045654297
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
26 0.0007 0.00070309638977051
SELECT id FROM categories WHERE parent_id = '27'
27 0.0051 0.0050809383392334
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 
28 0.0009 0.0008699893951416
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 
29 0.0008 0.00084280967712402
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
30 0.0006 0.00062108039855957
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
31 0.0008 0.00082898139953613
SELECT * FROM categorygroups WHERE id = '1'
32 0.0019 0.0018582344055176
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
33 0.0006 0.00064706802368164
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
34 0.0008 0.00084400177001953
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
35 0.0007 0.00065302848815918
SELECT id FROM categories WHERE parent_id = '28'
36 0.0024 0.0024099349975586
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 
37 0.0007 0.00070595741271973
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 
38 0.0008 0.00081205368041992
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
39 0.0008 0.00076198577880859
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
40 0.0007 0.00070595741271973
SELECT * FROM categorygroups WHERE id = '1'
41 0.0008 0.00077295303344727
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
42 0.0007 0.00074005126953125
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
43 0.0009 0.00091886520385742
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
44 0.0007 0.00074195861816406
SELECT id FROM categories WHERE parent_id = '29'
45 0.0014 0.0013809204101562
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 
46 0.0006 0.00063586235046387
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 
47 0.0008 0.00075483322143555
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
48 0.0006 0.00058102607727051
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
49 0.0006 0.00058102607727051
SELECT * FROM categorygroups WHERE id = '1'
50 0.0007 0.00073909759521484
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
51 0.0005 0.00054597854614258
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
52 0.0006 0.000579833984375
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
53 0.0005 0.00053501129150391
SELECT id FROM categories WHERE parent_id = '30'
54 0.0009 0.00086498260498047
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 
55 0.0007 0.0007469654083252
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 
56 0.0007 0.00067615509033203
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
57 0.0007 0.00067901611328125
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
58 0.0005 0.00050187110900879
SELECT * FROM categorygroups WHERE id = '1'
59 0.0009 0.00090312957763672
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
60 0.0012 0.0012009143829346
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
61 0.0006 0.00055909156799316
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
62 0.0005 0.00053715705871582
SELECT id FROM categories WHERE parent_id = '31'
63 0.0009 0.00092697143554688
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 
64 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 (31)
				  AND p.disabled = 0 
65 0.0007 0.00068902969360352
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
66 0.0006 0.00059294700622559
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
67 0.0006 0.00062203407287598
SELECT * FROM categorygroups WHERE id = '1'
68 0.0011 0.001115083694458
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
69 0.0017 0.0017049312591553
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
70 0.0009 0.00090289115905762
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
71 0.0006 0.00055599212646484
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
72 0.0004 0.0004429817199707
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
73 0.0015 0.0014970302581787
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
74 0.0013 0.0012881755828857
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
75 0.6022 0.6021728515625
SELECT * FROM ipgeocountries WHERE INET_ATON('18.97.14.91') >= INET_ATON(ip_start) AND INET_ATON('18.97.14.91') <= INET_ATON(ip_end)
76 0.0013 0.0013329982757568
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
77 0.0006 0.00059103965759277
SELECT * FROM countryredirects WHERE countrycode = 'US'
78 0.0018 0.0017759799957275
SELECT * FROM widget_options WHERE templateid = 'fsb-fluid2018' ORDER BY optionid
79 0.0017 0.0016839504241943
    SELECT *
    FROM widgets_assigned
    WHERE templateuid = 'fsb-fluid2018'
    AND enabled = 1
    ORDER BY widgetarea, sortorder
80 0.0010 0.00096511840820312
SELECT * FROM pages WHERE pagename = ''
81 0.0109 0.010869979858398
SELECT p.* FROM products p
                WHERE enabled = 1
                  AND parent_id = 0
                  AND hidden = 0
                  AND offers > 0
                  AND salesrank <> 0
                  AND p.id IN (SELECT product_id FROM products_categories)
                ORDER BY RAND() LIMIT 6
82 0.0041 0.0041189193725586
SELECT * FROM productimages WHERE product_id = '2565' ORDER BY sortorder ASC
83 0.0031 0.0031251907348633
SELECT * FROM product_image_select WHERE product_id = '2565'
84 0.0016 0.001615047454834
SELECT * FROM productcustomimages WHERE product_id = '2565'
85 0.0053 0.0053119659423828
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2565' AND a.name = n.originalname
86 0.0031 0.0030879974365234
SELECT * FROM productoffers WHERE product_id = '2565' AND merchantid = 'A1X6FK5RDHNB96'
87 0.0006 0.00062394142150879
SELECT * FROM productoffers
                WHERE product_id = '2565' AND price > 0
                ORDER BY price ASC LIMIT 1
88 0.0006 0.00061893463134766
SELECT value FROM productattributes WHERE product_id = '2565' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
89 0.0006 0.00060606002807617
SELECT * FROM productimages WHERE product_id = '767' ORDER BY sortorder ASC
90 0.0007 0.00069403648376465
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '767' AND p.id = pi.product_id ORDER BY pi.sortorder
91 0.0007 0.00067996978759766
SELECT * FROM product_image_select WHERE product_id = '767'
92 0.0008 0.000823974609375
SELECT * FROM productcustomimages WHERE product_id = '767'
93 0.0007 0.00065898895263672
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 = '767'
                GROUP BY o.product_id
94 0.0082 0.0082180500030518
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     = '767'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
95 0.0014 0.0013818740844727
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 767
96 0.0014 0.001410961151123
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '767' AND a.name = n.originalname
97 0.0006 0.0005650520324707
SELECT * FROM productoffers WHERE product_id = '767' AND merchantid = 'A1X6FK5RDHNB96'
98 0.0008 0.0007789134979248
SELECT * FROM productoffers
                WHERE product_id = '767' AND price > 0
                ORDER BY price ASC LIMIT 1
99 0.0005 0.00054192543029785
SELECT * FROM productoffers
                WHERE product_id = 767
                ORDER BY price ASC LIMIT 1
100 0.0006 0.00064802169799805
SELECT value FROM productattributes
                WHERE product_id = '767'
                AND name = 'ListPriceAmount'
101 0.0016 0.0015871524810791
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 = '767'
                GROUP BY o.product_id
102 0.0019 0.0018768310546875
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     = '767'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
103 0.0011 0.0010590553283691
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 767
104 0.0013 0.001349925994873
SELECT value FROM productattributes WHERE product_id = '767' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
105 0.0017 0.0016660690307617
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '767'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
106 0.0012 0.0012118816375732
SELECT * FROM productimages WHERE product_id = '1289' ORDER BY sortorder ASC
107 0.0016 0.0016012191772461
SELECT * FROM product_image_select WHERE product_id = '1289'
108 0.0009 0.00088691711425781
SELECT * FROM productcustomimages WHERE product_id = '1289'
109 0.0022 0.0022120475769043
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1289' AND a.name = n.originalname
110 0.0008 0.00083208084106445
SELECT * FROM productoffers WHERE product_id = '1289' AND merchantid = 'A1X6FK5RDHNB96'
111 0.0006 0.000640869140625
SELECT * FROM productoffers
                WHERE product_id = '1289' AND price > 0
                ORDER BY price ASC LIMIT 1
112 0.0008 0.00080394744873047
SELECT value FROM productattributes WHERE product_id = '1289' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
113 0.0010 0.00095701217651367
SELECT * FROM productimages WHERE product_id = '995' ORDER BY sortorder ASC
114 0.0014 0.0013680458068848
SELECT * FROM product_image_select WHERE product_id = '995'
115 0.0007 0.00074410438537598
SELECT * FROM productcustomimages WHERE product_id = '995'
116 0.0020 0.001971960067749
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '995' AND a.name = n.originalname
117 0.0008 0.00080704689025879
SELECT * FROM productoffers WHERE product_id = '995' AND merchantid = 'A1X6FK5RDHNB96'
118 0.0007 0.0006718635559082
SELECT * FROM productoffers
                WHERE product_id = '995' AND price > 0
                ORDER BY price ASC LIMIT 1
119 0.0010 0.0009760856628418
SELECT value FROM productattributes WHERE product_id = '995' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
120 0.0035 0.003483772277832
SELECT * FROM productimages WHERE product_id = '1673' ORDER BY sortorder ASC
121 0.0011 0.0011229515075684
SELECT * FROM product_image_select WHERE product_id = '1673'
122 0.0007 0.00065398216247559
SELECT * FROM productcustomimages WHERE product_id = '1673'
123 0.0016 0.0015799999237061
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1673' AND a.name = n.originalname
124 0.0009 0.00086116790771484
SELECT * FROM productoffers WHERE product_id = '1673' AND merchantid = 'A1X6FK5RDHNB96'
125 0.0007 0.00070500373840332
SELECT * FROM productoffers
                WHERE product_id = '1673' AND price > 0
                ORDER BY price ASC LIMIT 1
126 0.0006 0.00060105323791504
SELECT value FROM productattributes WHERE product_id = '1673' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
127 0.0009 0.0009300708770752
SELECT * FROM productimages WHERE product_id = '1022' ORDER BY sortorder ASC
128 0.0023 0.0023350715637207
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1022' AND p.id = pi.product_id ORDER BY pi.sortorder
129 0.0014 0.0014190673828125
SELECT * FROM product_image_select WHERE product_id = '1022'
130 0.0009 0.000946044921875
SELECT * FROM productcustomimages WHERE product_id = '1022'
131 0.0012 0.0012030601501465
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 = '1022'
                GROUP BY o.product_id
132 0.0013 0.001291036605835
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     = '1022'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
133 0.0010 0.0010368824005127
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1022
134 0.0018 0.0017769336700439
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1022' AND a.name = n.originalname
135 0.0006 0.0006110668182373
SELECT * FROM productoffers WHERE product_id = '1022' AND merchantid = 'A1X6FK5RDHNB96'
136 0.0008 0.0007939338684082
SELECT * FROM productoffers
                WHERE product_id = '1022' AND price > 0
                ORDER BY price ASC LIMIT 1
137 0.0008 0.00082302093505859
SELECT * FROM productoffers
                WHERE product_id = 1022
                ORDER BY price ASC LIMIT 1
138 0.0006 0.0006401538848877
SELECT value FROM productattributes
                WHERE product_id = '1022'
                AND name = 'ListPriceAmount'
139 0.0011 0.0011379718780518
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 = '1022'
                GROUP BY o.product_id
140 0.0019 0.001878023147583
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     = '1022'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
141 0.0008 0.00084090232849121
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1022
142 0.0011 0.0010809898376465
SELECT value FROM productattributes WHERE product_id = '1022' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
143 0.0013 0.0013148784637451
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '1022'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'FlavorName'
                GROUP BY o.value
                ORDER BY o.value ASC
144 0.0026 0.0025570392608643
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2565' ORDER BY timestamp DESC
145 0.0004 0.00044393539428711
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '767' ORDER BY timestamp DESC
146 0.0005 0.00047111511230469
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1289' ORDER BY timestamp DESC
147 0.0004 0.00042080879211426
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '995' ORDER BY timestamp DESC
148 0.0004 0.00035214424133301
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1673' ORDER BY timestamp DESC
149 0.0004 0.00043416023254395
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1022' ORDER BY timestamp DESC
150 0.0010 0.0010311603546143
SELECT p.* FROM products p
                    WHERE enabled = 1
                      AND parent_id = 0
                      AND hidden = 0
                      AND offers > 0
                      AND salesrank <> 0
                      
                    ORDER BY salesrank ASC LIMIT 2
151 0.0008 0.00082612037658691
SELECT id FROM custom_products p
                WHERE hide = 0
                AND bestseller = 1
                
                LIMIT 2
152 0.0006 0.00061202049255371
SELECT id,listingtype FROM ebay_products p
                WHERE hide = 0
                
                ORDER BY soldcount DESC
                LIMIT 2
153 0.0008 0.00077509880065918
SELECT * FROM productimages WHERE product_id = '4950' ORDER BY sortorder ASC
154 0.0011 0.0011110305786133
SELECT * FROM product_image_select WHERE product_id = '4950'
155 0.0006 0.00063896179199219
SELECT * FROM productcustomimages WHERE product_id = '4950'
156 0.0017 0.0017471313476562
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4950' AND a.name = n.originalname
157 0.0007 0.00070500373840332
SELECT * FROM productoffers WHERE product_id = '4950' AND merchantid = 'A1X6FK5RDHNB96'
158 0.0007 0.00069403648376465
SELECT * FROM productoffers
                WHERE product_id = '4950' AND price > 0
                ORDER BY price ASC LIMIT 1
159 0.0007 0.00066781044006348
SELECT value FROM productattributes WHERE product_id = '4950' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
160 0.0008 0.00077700614929199
SELECT * FROM productimages WHERE product_id = '4953' ORDER BY sortorder ASC
161 0.0008 0.00081014633178711
SELECT * FROM product_image_select WHERE product_id = '4953'
162 0.0006 0.00057411193847656
SELECT * FROM productcustomimages WHERE product_id = '4953'
163 0.0010 0.0010008811950684
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4953' AND a.name = n.originalname
164 0.0006 0.0005800724029541
SELECT * FROM productoffers WHERE product_id = '4953' AND merchantid = 'A1X6FK5RDHNB96'
165 0.0006 0.00056695938110352
SELECT * FROM productoffers
                WHERE product_id = '4953' AND price > 0
                ORDER BY price ASC LIMIT 1
166 0.0006 0.00057601928710938
SELECT value FROM productattributes WHERE product_id = '4953' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
167 0.0007 0.00065183639526367
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4950' ORDER BY timestamp DESC
168 0.0005 0.0004570484161377
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4953' ORDER BY timestamp DESC
169 0.0030 0.0029799938201904
SELECT  p.*, o.price + o.amountsaved as originalprice FROM products p, productoffers o
                    WHERE   p.id        = o.product_id
                      AND   p.parent_id = 0
                      AND   p.enabled   = 1
                      AND   p.hidden    = 0
                      AND   offers > 0
                      AND   o.percentagesaved > 0
                      AND   o.price > 200
                      AND   p.id IN (SELECT product_id FROM products_categories )
                      AND   o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price))
                    ORDER BY o.percentagesaved DESC, p.salesrank DESC LIMIT 6
170 0.0008 0.00080084800720215
SELECT * FROM productimages WHERE product_id = '1364' ORDER BY sortorder ASC
171 0.0009 0.00090599060058594
SELECT * FROM product_image_select WHERE product_id = '1364'
172 0.0005 0.00049901008605957
SELECT * FROM productcustomimages WHERE product_id = '1364'
173 0.0009 0.00092387199401855
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1364' AND a.name = n.originalname
174 0.0005 0.00053501129150391
SELECT * FROM productoffers WHERE product_id = '1364' AND merchantid = 'A1X6FK5RDHNB96'
175 0.0005 0.00050210952758789
SELECT * FROM productoffers
                WHERE product_id = '1364' AND price > 0
                ORDER BY price ASC LIMIT 1
176 0.0006 0.00063014030456543
SELECT value FROM productattributes WHERE product_id = '1364' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
177 0.0007 0.00068187713623047
SELECT * FROM productimages WHERE product_id = '4932' ORDER BY sortorder ASC
178 0.0009 0.00088882446289062
SELECT * FROM product_image_select WHERE product_id = '4932'
179 0.0006 0.00056099891662598
SELECT * FROM productcustomimages WHERE product_id = '4932'
180 0.0013 0.0013048648834229
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4932' AND a.name = n.originalname
181 0.0024 0.0023748874664307
SELECT * FROM productoffers WHERE product_id = '4932' AND merchantid = 'A1X6FK5RDHNB96'
182 0.0008 0.00083208084106445
SELECT * FROM productoffers
                WHERE product_id = '4932' AND price > 0
                ORDER BY price ASC LIMIT 1
183 0.0009 0.00090503692626953
SELECT value FROM productattributes WHERE product_id = '4932' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
184 0.0011 0.0011270046234131
SELECT * FROM productimages WHERE product_id = '4921' ORDER BY sortorder ASC
185 0.0012 0.0012261867523193
SELECT * FROM product_image_select WHERE product_id = '4921'
186 0.0006 0.00060105323791504
SELECT * FROM productcustomimages WHERE product_id = '4921'
187 0.0024 0.0024359226226807
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4921' AND a.name = n.originalname
188 0.0009 0.00087308883666992
SELECT * FROM productoffers WHERE product_id = '4921' AND merchantid = 'A1X6FK5RDHNB96'
189 0.0008 0.00081992149353027
SELECT * FROM productoffers
                WHERE product_id = '4921' AND price > 0
                ORDER BY price ASC LIMIT 1
190 0.0010 0.0009770393371582
SELECT value FROM productattributes WHERE product_id = '4921' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
191 0.0010 0.0010440349578857
SELECT * FROM productimages WHERE product_id = '4933' ORDER BY sortorder ASC
192 0.0010 0.0010490417480469
SELECT * FROM product_image_select WHERE product_id = '4933'
193 0.0007 0.00067520141601562
SELECT * FROM productcustomimages WHERE product_id = '4933'
194 0.0022 0.0021810531616211
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4933' AND a.name = n.originalname
195 0.0008 0.00083208084106445
SELECT * FROM productoffers WHERE product_id = '4933' AND merchantid = 'A1X6FK5RDHNB96'
196 0.0006 0.00062179565429688
SELECT * FROM productoffers
                WHERE product_id = '4933' AND price > 0
                ORDER BY price ASC LIMIT 1
197 0.0007 0.0007331371307373
SELECT value FROM productattributes WHERE product_id = '4933' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
198 0.0010 0.00099802017211914
SELECT * FROM productimages WHERE product_id = '1290' ORDER BY sortorder ASC
199 0.0010 0.00099492073059082
SELECT * FROM product_image_select WHERE product_id = '1290'
200 0.0006 0.00062203407287598
SELECT * FROM productcustomimages WHERE product_id = '1290'
201 0.0020 0.0019910335540771
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1290' AND a.name = n.originalname
202 0.0009 0.0009160041809082
SELECT * FROM productoffers WHERE product_id = '1290' AND merchantid = 'A1X6FK5RDHNB96'
203 0.0010 0.0010130405426025
SELECT * FROM productoffers
                WHERE product_id = '1290' AND price > 0
                ORDER BY price ASC LIMIT 1
204 0.0007 0.00073409080505371
SELECT value FROM productattributes WHERE product_id = '1290' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
205 0.0008 0.00079011917114258
SELECT * FROM productimages WHERE product_id = '4953' ORDER BY sortorder ASC
206 0.0008 0.00082802772521973
SELECT * FROM product_image_select WHERE product_id = '4953'
207 0.0006 0.00059294700622559
SELECT * FROM productcustomimages WHERE product_id = '4953'
208 0.0013 0.0013489723205566
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4953' AND a.name = n.originalname
209 0.0008 0.00075912475585938
SELECT * FROM productoffers WHERE product_id = '4953' AND merchantid = 'A1X6FK5RDHNB96'
210 0.0007 0.00070309638977051
SELECT * FROM productoffers
                WHERE product_id = '4953' AND price > 0
                ORDER BY price ASC LIMIT 1
211 0.0007 0.00067996978759766
SELECT value FROM productattributes WHERE product_id = '4953' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
212 0.0007 0.00065898895263672
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1364' ORDER BY timestamp DESC
213 0.0004 0.0004429817199707
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4932' ORDER BY timestamp DESC
214 0.0005 0.00049495697021484
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4921' ORDER BY timestamp DESC
215 0.0005 0.0004880428314209
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4933' ORDER BY timestamp DESC
216 0.0006 0.00060009956359863
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1290' ORDER BY timestamp DESC
217 0.0004 0.00043606758117676
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4953' ORDER BY timestamp DESC
218 0.0181 0.018075942993164
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
219 0.0051 0.0050859451293945
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
220 0.0022 0.0022268295288086
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
221 0.0017 0.0017330646514893
SELECT * FROM products WHERE id = 1626
222 0.0010 0.0010180473327637
SELECT * FROM products WHERE id = 4041
223 0.0010 0.0010499954223633
SELECT * FROM products WHERE id = 4312
224 0.0010 0.0010168552398682
SELECT * FROM products WHERE id = 777
225 0.0010 0.00098204612731934
SELECT * FROM products WHERE id = 3881
226 0.0009 0.00090289115905762
SELECT * FROM products WHERE id = 4213
227 0.0008 0.00075888633728027
SELECT * FROM products WHERE id = '1626'
228 0.0011 0.0010969638824463
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
229 0.0012 0.0012109279632568
SELECT * FROM product_image_select WHERE product_id = '1626'
230 0.0006 0.0006251335144043
SELECT * FROM productcustomimages WHERE product_id = '1626'
231 0.0031 0.003061056137085
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
232 0.0049 0.0048651695251465
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
233 0.0007 0.00072216987609863
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
234 0.0007 0.00071406364440918
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
235 0.0008 0.00082707405090332
SELECT * FROM products WHERE id = '4041'
236 0.0007 0.00067400932312012
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
237 0.0011 0.0010590553283691
SELECT * FROM product_image_select WHERE product_id = '4041'
238 0.0006 0.0005800724029541
SELECT * FROM productcustomimages WHERE product_id = '4041'
239 0.0020 0.0019779205322266
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
240 0.0008 0.00079798698425293
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
241 0.0005 0.0005488395690918
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
242 0.0005 0.00054287910461426
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
243 0.0008 0.00080490112304688
SELECT * FROM products WHERE id = '4312'
244 0.0007 0.0006558895111084
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
245 0.0009 0.00088000297546387
SELECT * FROM product_image_select WHERE product_id = '4312'
246 0.0005 0.00053906440734863
SELECT * FROM productcustomimages WHERE product_id = '4312'
247 0.0015 0.0015480518341064
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
248 0.0007 0.00066494941711426
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
249 0.0005 0.00054693222045898
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
250 0.0006 0.00060009956359863
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
251 0.0008 0.00077509880065918
SELECT * FROM products WHERE id = '777'
252 0.0006 0.00060701370239258
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
253 0.0008 0.00084900856018066
SELECT * FROM product_image_select WHERE product_id = '777'
254 0.0005 0.00049400329589844
SELECT * FROM productcustomimages WHERE product_id = '777'
255 0.0011 0.0010781288146973
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
256 0.0005 0.0005030632019043
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
257 0.0004 0.00044012069702148
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
258 0.0005 0.0005028247833252
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
259 0.0006 0.00057506561279297
SELECT * FROM products WHERE id = '3881'
260 0.0008 0.00079894065856934
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
261 0.0006 0.00063514709472656
SELECT * FROM product_image_select WHERE product_id = '3881'
262 0.0006 0.00057196617126465
SELECT * FROM productcustomimages WHERE product_id = '3881'
263 0.0012 0.0012128353118896
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
264 0.0006 0.0005640983581543
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
265 0.0005 0.00047016143798828
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
266 0.0006 0.00057005882263184
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
267 0.0007 0.00066304206848145
SELECT * FROM products WHERE id = '4213'
268 0.0009 0.00085091590881348
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
269 0.0007 0.00071287155151367
SELECT * FROM product_image_select WHERE product_id = '4213'
270 0.0005 0.00045680999755859
SELECT * FROM productcustomimages WHERE product_id = '4213'
271 0.0015 0.0014739036560059
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
272 0.0006 0.0005500316619873
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
273 0.0005 0.0004580020904541
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
274 0.0004 0.00043392181396484
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
275 0.0024 0.0024240016937256
SELECT	m.*, COUNT(p.id) as productcount FROM manufacturers m, products p
				WHERE	m.id = p.manufacturer_id
				  AND	m.merge_manufacturer_id = 0
				  AND	p.parent_id	= 0
				  AND	p.enabled	= 1
				  AND	p.hidden	= 0
				  AND   offers > 0
				  AND	m.display_homepage	= 1
				  AND	m.id IN (SELECT manufacturer_id FROM manufacturerimages)
				GROUP BY m.id HAVING COUNT(p.id) > 0 ORDER BY COUNT(p.id) DESC LIMIT 8
276 0.0004 0.0004429817199707
SELECT * FROM `widget_options` WHERE `optionid` = 'latestpages1'
277 0.0007 0.00066399574279785
SELECT * FROM `pages` WHERE `core` = 0 ORDER BY `created_on` DESC LIMIT 0, 5
278 0.0019 0.0019149780273438
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
279 0.0019 0.0019071102142334
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
280 0.0005 0.0004730224609375
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
281 0.0143 0.014340162277222
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
282 0.0008 0.00077414512634277
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
283 0.0006 0.00063109397888184
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
284 0.0006 0.00064802169799805
SELECT * FROM products WHERE id = 1626
285 0.0006 0.00063800811767578
SELECT * FROM products WHERE id = 4041
286 0.0006 0.00058102607727051
SELECT * FROM products WHERE id = 4312
287 0.0006 0.00056719779968262
SELECT * FROM products WHERE id = 777
288 0.0006 0.00060606002807617
SELECT * FROM products WHERE id = 3881
289 0.0006 0.00063204765319824
SELECT * FROM products WHERE id = 4213
290 0.0006 0.0005791187286377
SELECT * FROM products WHERE id = '1626'
291 0.0006 0.00058197975158691
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
292 0.0007 0.00067281723022461
SELECT * FROM product_image_select WHERE product_id = '1626'
293 0.0005 0.00049209594726562
SELECT * FROM productcustomimages WHERE product_id = '1626'
294 0.0011 0.0010929107666016
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
295 0.0005 0.00051712989807129
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
296 0.0004 0.00044703483581543
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
297 0.0004 0.00044679641723633
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
298 0.0006 0.0006401538848877
SELECT * FROM products WHERE id = '4041'
299 0.0006 0.00057888031005859
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
300 0.0007 0.00065803527832031
SELECT * FROM product_image_select WHERE product_id = '4041'
301 0.0005 0.00050592422485352
SELECT * FROM productcustomimages WHERE product_id = '4041'
302 0.0037 0.0037169456481934
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
303 0.0007 0.00067591667175293
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
304 0.0005 0.00049901008605957
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
305 0.0005 0.00051093101501465
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
306 0.0006 0.00060701370239258
SELECT * FROM products WHERE id = '4312'
307 0.0005 0.00054192543029785
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
308 0.0007 0.00072717666625977
SELECT * FROM product_image_select WHERE product_id = '4312'
309 0.0004 0.00044798851013184
SELECT * FROM productcustomimages WHERE product_id = '4312'
310 0.0010 0.0010221004486084
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
311 0.0005 0.00050687789916992
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
312 0.0004 0.00042986869812012
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
313 0.0005 0.00048589706420898
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
314 0.0008 0.00082707405090332
SELECT * FROM products WHERE id = '777'
315 0.0006 0.00061798095703125
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
316 0.0007 0.00066590309143066
SELECT * FROM product_image_select WHERE product_id = '777'
317 0.0005 0.00051712989807129
SELECT * FROM productcustomimages WHERE product_id = '777'
318 0.0012 0.0012459754943848
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
319 0.0006 0.00059199333190918
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
320 0.0004 0.00043892860412598
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
321 0.0005 0.00046706199645996
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
322 0.0007 0.00065398216247559
SELECT * FROM products WHERE id = '3881'
323 0.0008 0.00075697898864746
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
324 0.0006 0.00062799453735352
SELECT * FROM product_image_select WHERE product_id = '3881'
325 0.0005 0.00045609474182129
SELECT * FROM productcustomimages WHERE product_id = '3881'
326 0.0012 0.0012028217315674
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
327 0.0005 0.00052189826965332
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
328 0.0005 0.00054597854614258
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
329 0.0005 0.0004889965057373
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
330 0.0007 0.00069904327392578
SELECT * FROM products WHERE id = '4213'
331 0.0007 0.00069808959960938
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
332 0.0007 0.00069308280944824
SELECT * FROM product_image_select WHERE product_id = '4213'
333 0.0004 0.00043892860412598
SELECT * FROM productcustomimages WHERE product_id = '4213'
334 0.0012 0.0011599063873291
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
335 0.0006 0.00058102607727051
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
336 0.0004 0.00040316581726074
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
337 0.0004 0.00043892860412598
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
338 0.0043 0.004302978515625
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
339 0.0008 0.00076889991760254
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
340 0.0033 0.0032529830932617
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
341 0.0019 0.0019330978393555
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
342 0.0006 0.00057601928710938
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
343 0.0008 0.00082993507385254
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
344 0.0007 0.00074410438537598
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'