0
  1. My Store
  2. Tags

Browse Categories

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.

no thanks

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.3091218471527 378 0.3517 0


No Amazon API Requests Made.


App Debug - Total Time 1.3091218471527 seconds

Number Time From Start Name Description
1 0.56212902069092 Initialise Initialise FSB Function
2 0.57031989097595 App Controller Start Start of the App controller (called before the controller of every page)
3 0.57279086112976 Start of getCategoryListByGroup Function Before first category groups query
4 0.57314801216125 After initial query Before first category groups query
5 0.57314991950989 Get Category List for Group Before the call to getCategoryList function
6 0.57315301895142 Start of GetCategoryList function Start of the function
7 0.57315587997437 Before getting categories Query to get specific category list
8 0.57363486289978 After getting categories Query to get specific category list
9 0.5736358165741 Before getting category custom Before call to function getCategoryCustom
10 0.60075187683105 After getting category custom After call to function getCategoryCustom
11 0.6007559299469 Before getting category custom Before call to function getCategoryCustom
12 0.61430382728577 After getting category custom After call to function getCategoryCustom
13 0.61430597305298 Before getting category custom Before call to function getCategoryCustom
14 0.61685490608215 After getting category custom After call to function getCategoryCustom
15 0.61685800552368 Before getting category custom Before call to function getCategoryCustom
16 0.62021780014038 After getting category custom After call to function getCategoryCustom
17 0.62021994590759 Before getting category custom Before call to function getCategoryCustom
18 0.62366986274719 After getting category custom After call to function getCategoryCustom
19 0.6236720085144 Before getting category custom Before call to function getCategoryCustom
20 0.6270158290863 After getting category custom After call to function getCategoryCustom
21 0.62701797485352 End of GetCategoryList function End of the function
22 0.62702488899231 Get Category List for Group Before the call to getCategoryList function
23 0.62702798843384 Start of GetCategoryList function Start of the function
24 0.62702989578247 Before getting categories Query to get specific category list
25 0.62735486030579 End of getCategoryListByGroup Function Before return()
26 0.71151089668274 App Controller End End of the App controller (called before the controller of every page)
27 0.90222096443176 App_after Controller Start Start of the App_after controller (called after the controller of every page)
28 0.90300893783569 Before Get Options Before the call to getOptions in the tpl class
29 0.93154501914978 After Get Options After the call to getOptions in the tpl class
30 0.93160390853882 App_after Controller End End of the App_after controller (called after the controller of every page)
31 1.3090980052948 Finalizing debug Before the debug is output to the page.
32 1.3091208934784 End of App This is the end of the app logging, final timestamp


Query Debug - 378 Database Queries. Total time 0.3517 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0005 0.00054812431335449 
SELECT parameter, value FROM parameters
2 0.0015 0.0014779567718506 
SELECT * FROM `bad_bots`
3 0.0004 0.00040221214294434 
SET time_zone = 'Europe/London'
4 0.0004 0.00039196014404297 
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0034 0.0034239292144775 
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:12:\"3.15.143.207\";}'
6 0.0025 0.0024750232696533 
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1716289905'
7 0.0017 0.0017337799072266 
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0007 0.00074601173400879 
UPDATE autorun SET lastrun = '2024-05-21 11:11:45' WHERE id = '15'
9 0.0004 0.0003659725189209 
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0004 0.00042319297790527 
SELECT id FROM pages WHERE pagename = 'tag' LIMIT 1
11 0.0018 0.0018429756164551 
SELECT id FROM products WHERE pagename = 'tag' AND hidden = 0 LIMIT 1
12 0.0008 0.00077915191650391 
SELECT id FROM ebay_products WHERE pagename = 'tag'
13 0.0003 0.0003359317779541 
SELECT id FROM custom_products WHERE pagename = 'tag'
14 0.0003 0.00034284591674805 
SELECT id FROM categories WHERE pagename = 'tag' LIMIT 1
15 0.0003 0.00032496452331543 
SELECT id FROM manufacturers WHERE pagename = 'tag' LIMIT 1
16 0.0003 0.00034713745117188 
SELECT id FROM bundles WHERE pagename = 'tag' LIMIT 1
17 0.0027 0.0027220249176025 
SELECT id FROM tags WHERE pagename = 'picerie' LIMIT 1
18 0.0007 0.00072503089904785 
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
19 0.0008 0.00078511238098145 
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
20 0.0004 0.00044488906860352 
SELECT * FROM pages WHERE pagename = 'tag'
21 0.0003 0.00033187866210938 
SELECT * FROM categorygroups ORDER BY sortorder ASC
22 0.0005 0.00046181678771973 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
23 0.0146 0.014558076858521 
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
24 0.0010 0.00097799301147461 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
25 0.0003 0.00031805038452148 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
26 0.0003 0.00028300285339355 
SELECT id FROM categories WHERE parent_id = '26'
27 0.0096 0.009584903717041 
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
28 0.0004 0.00036215782165527 
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
29 0.0003 0.00028204917907715 
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
30 0.0003 0.00030612945556641 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
31 0.0003 0.00029301643371582 
SELECT * FROM categorygroups WHERE id = '1'
32 0.0055 0.0055379867553711 
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
33 0.0004 0.00037598609924316 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
34 0.0003 0.00028085708618164 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
35 0.0003 0.0003199577331543 
SELECT id FROM categories WHERE parent_id = '27'
36 0.0059 0.0058610439300537 
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
37 0.0003 0.00029802322387695 
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
38 0.0003 0.00026297569274902 
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
39 0.0003 0.0002741813659668 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
40 0.0002 0.00024580955505371 
SELECT * FROM categorygroups WHERE id = '1'
41 0.0003 0.00026512145996094 
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
42 0.0003 0.00030398368835449 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
43 0.0003 0.00027608871459961 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
44 0.0003 0.00025200843811035 
SELECT id FROM categories WHERE parent_id = '28'
45 0.0003 0.0002591609954834 
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
46 0.0003 0.00027894973754883 
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
47 0.0003 0.00028586387634277 
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
48 0.0003 0.00028800964355469 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
49 0.0003 0.0002598762512207 
SELECT * FROM categorygroups WHERE id = '1'
50 0.0006 0.00058794021606445 
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
51 0.0003 0.0003349781036377 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
52 0.0003 0.00027990341186523 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
53 0.0003 0.00025296211242676 
SELECT id FROM categories WHERE parent_id = '29'
54 0.0006 0.00063896179199219 
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
55 0.0003 0.00034403800964355 
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
56 0.0003 0.00028800964355469 
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
57 0.0003 0.00029993057250977 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
58 0.0003 0.00025701522827148 
SELECT * FROM categorygroups WHERE id = '1'
59 0.0005 0.00054717063903809 
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
60 0.0005 0.00047206878662109 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
61 0.0003 0.00028300285339355 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
62 0.0003 0.0002901554107666 
SELECT id FROM categories WHERE parent_id = '30'
63 0.0006 0.00062394142150879 
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
64 0.0003 0.00029206275939941 
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
65 0.0003 0.00030803680419922 
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
66 0.0003 0.00027203559875488 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
67 0.0003 0.00027799606323242 
SELECT * FROM categorygroups WHERE id = '1'
68 0.0006 0.00056195259094238 
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
69 0.0003 0.00025105476379395 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
70 0.0004 0.00037407875061035 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
71 0.0003 0.00030803680419922 
SELECT id FROM categories WHERE parent_id = '31'
72 0.0007 0.0006709098815918 
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
73 0.0003 0.00029110908508301 
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
74 0.0003 0.00025105476379395 
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
75 0.0003 0.00026297569274902 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
76 0.0003 0.00029802322387695 
SELECT * FROM categorygroups WHERE id = '1'
77 0.0003 0.00031280517578125 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
78 0.0003 0.00025010108947754 
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
79 0.0003 0.00034904479980469 
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
80 0.0003 0.0002899169921875 
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
81 0.0003 0.00026297569274902 
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
82 0.0003 0.0002748966217041 
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
83 0.0006 0.0006248950958252 
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
84 0.0796 0.07956600189209 
SELECT * FROM ipgeocountries WHERE INET_ATON('3.15.143.207') >= INET_ATON(ip_start) AND INET_ATON('3.15.143.207') <= INET_ATON(ip_end)
85 0.0004 0.00036001205444336 
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
86 0.0003 0.0002598762512207 
SELECT * FROM countryredirects WHERE countrycode = 'US'
87 0.0027 0.0027260780334473 
SELECT * FROM tags WHERE pagename = 'picerie'
88 0.0101 0.010051965713501 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
89 0.0005 0.00050687789916992 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
90 0.0003 0.00028586387634277 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
91 0.0004 0.00040197372436523 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
92 0.0004 0.00039386749267578 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
93 0.0003 0.00028300285339355 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
94 0.0029 0.0029351711273193 
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t WHERE p.id = t.product_id AND parent_id = 0 AND t.tag_id = '62' AND hidden = 0 AND enabled = 1  AND 1 = 1
95 0.0199 0.019863128662109 
SELECT DISTINCT(p.id), p.*, IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank FROM products p, product_tags t WHERE p.id = t.product_id AND p.parent_id = 0 AND t.tag_id = '62' AND hidden = 0 AND enabled = 1  AND 1 = 1 ORDER BY salesrank ASC LIMIT 72, 18
96 0.0004 0.00042295455932617 
SELECT * FROM productimages WHERE product_id = '1487' ORDER BY sortorder ASC
97 0.0003 0.0002598762512207 
SELECT * FROM product_image_select WHERE product_id = '1487'
98 0.0003 0.00027084350585938 
SELECT * FROM productcustomimages WHERE product_id = '1487'
99 0.0003 0.00028300285339355 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1487' AND a.name = n.originalname
100 0.0003 0.00031208992004395 
SELECT * FROM productoffers WHERE product_id = '1487' AND merchantid = 'A1X6FK5RDHNB96'
101 0.0003 0.00031304359436035 
SELECT * FROM productoffers
                WHERE product_id = '1487' AND price > 0
                ORDER BY price ASC LIMIT 1
102 0.0003 0.00031900405883789 
SELECT value FROM productattributes WHERE product_id = '1487' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
103 0.0003 0.00027990341186523 
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
104 0.0003 0.00027298927307129 
SELECT * FROM product_image_select WHERE product_id = '777'
105 0.0003 0.00027799606323242 
SELECT * FROM productcustomimages WHERE product_id = '777'
106 0.0003 0.00031280517578125 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
107 0.0003 0.00027179718017578 
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
108 0.0003 0.00028395652770996 
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
109 0.0003 0.00030708312988281 
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
110 0.0013 0.0012609958648682 
SELECT * FROM productimages WHERE product_id = '1308' ORDER BY sortorder ASC
111 0.0006 0.00055694580078125 
SELECT * FROM product_image_select WHERE product_id = '1308'
112 0.0005 0.00047111511230469 
SELECT * FROM productcustomimages WHERE product_id = '1308'
113 0.0035 0.0035419464111328 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1308' AND a.name = n.originalname
114 0.0009 0.00090694427490234 
SELECT * FROM productoffers WHERE product_id = '1308' AND merchantid = 'A1X6FK5RDHNB96'
115 0.0007 0.00067400932312012 
SELECT * FROM productoffers
                WHERE product_id = '1308' AND price > 0
                ORDER BY price ASC LIMIT 1
116 0.0005 0.00049304962158203 
SELECT * FROM productoffers
                WHERE product_id = 1308
                ORDER BY price ASC LIMIT 1
117 0.0006 0.00060796737670898 
SELECT value FROM productattributes
                WHERE product_id = '1308'
                AND name = 'ListPriceAmount'
118 0.0006 0.00057196617126465 
SELECT value FROM productattributes WHERE product_id = '1308' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
119 0.0006 0.00062680244445801 
SELECT * FROM productimages WHERE product_id = '3155' ORDER BY sortorder ASC
120 0.0018 0.0017890930175781 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3155' AND p.id = pi.product_id ORDER BY pi.sortorder
121 0.0005 0.00053310394287109 
SELECT * FROM product_image_select WHERE product_id = '3155'
122 0.0007 0.00066208839416504 
SELECT * FROM productcustomimages WHERE product_id = '3155'
123 0.0008 0.00078105926513672 
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 = '3155'
                GROUP BY o.product_id
124 0.0015 0.0015189647674561 
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     = '3155'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
125 0.0005 0.0005190372467041 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3155
126 0.0011 0.0010671615600586 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3155' AND a.name = n.originalname
127 0.0007 0.00071406364440918 
SELECT * FROM productoffers WHERE product_id = '3155' AND merchantid = 'A1X6FK5RDHNB96'
128 0.0006 0.00055694580078125 
SELECT * FROM productoffers
                WHERE product_id = '3155' AND price > 0
                ORDER BY price ASC LIMIT 1
129 0.0007 0.00069808959960938 
SELECT * FROM productoffers
                WHERE product_id = 3155
                ORDER BY price ASC LIMIT 1
130 0.0010 0.0010240077972412 
SELECT value FROM productattributes
                WHERE product_id = '3155'
                AND name = 'ListPriceAmount'
131 0.0012 0.0011870861053467 
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 = '3155'
                GROUP BY o.product_id
132 0.0011 0.001105785369873 
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     = '3155'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
133 0.0004 0.00036120414733887 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3155
134 0.0007 0.00070691108703613 
SELECT value FROM productattributes WHERE product_id = '3155' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
135 0.0016 0.0015771389007568 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3155'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
136 0.0010 0.0010130405426025 
SELECT * FROM productimages WHERE product_id = '1309' ORDER BY sortorder ASC
137 0.0006 0.00058889389038086 
SELECT * FROM product_image_select WHERE product_id = '1309'
138 0.0004 0.00044798851013184 
SELECT * FROM productcustomimages WHERE product_id = '1309'
139 0.0017 0.001694917678833 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1309' AND a.name = n.originalname
140 0.0006 0.00062203407287598 
SELECT * FROM productoffers WHERE product_id = '1309' AND merchantid = 'A1X6FK5RDHNB96'
141 0.0011 0.0010960102081299 
SELECT * FROM productoffers
                WHERE product_id = '1309' AND price > 0
                ORDER BY price ASC LIMIT 1
142 0.0005 0.00047898292541504 
SELECT * FROM productoffers
                WHERE product_id = 1309
                ORDER BY price ASC LIMIT 1
143 0.0006 0.00063300132751465 
SELECT value FROM productattributes
                WHERE product_id = '1309'
                AND name = 'ListPriceAmount'
144 0.0006 0.00062298774719238 
SELECT value FROM productattributes WHERE product_id = '1309' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
145 0.0004 0.00036191940307617 
SELECT * FROM productimages WHERE product_id = '2233' ORDER BY sortorder ASC
146 0.0003 0.00029206275939941 
SELECT * FROM product_image_select WHERE product_id = '2233'
147 0.0003 0.00026917457580566 
SELECT * FROM productcustomimages WHERE product_id = '2233'
148 0.0003 0.00028109550476074 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2233' AND a.name = n.originalname
149 0.0003 0.00025606155395508 
SELECT * FROM productoffers WHERE product_id = '2233' AND merchantid = 'A1X6FK5RDHNB96'
150 0.0003 0.00027203559875488 
SELECT * FROM productoffers
                WHERE product_id = '2233' AND price > 0
                ORDER BY price ASC LIMIT 1
151 0.0003 0.00029611587524414 
SELECT value FROM productattributes WHERE product_id = '2233' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
152 0.0003 0.0003361701965332 
SELECT * FROM productimages WHERE product_id = '3699' ORDER BY sortorder ASC
153 0.0009 0.00089788436889648 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3699' AND p.id = pi.product_id ORDER BY pi.sortorder
154 0.0003 0.00028395652770996 
SELECT * FROM product_image_select WHERE product_id = '3699'
155 0.0003 0.00032806396484375 
SELECT * FROM productcustomimages WHERE product_id = '3699'
156 0.0006 0.00058293342590332 
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 = '3699'
                GROUP BY o.product_id
157 0.0010 0.001021146774292 
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     = '3699'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
158 0.0005 0.00050783157348633 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3699
159 0.0003 0.00028896331787109 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3699' AND a.name = n.originalname
160 0.0003 0.00029492378234863 
SELECT * FROM productoffers WHERE product_id = '3699' AND merchantid = 'A1X6FK5RDHNB96'
161 0.0003 0.00030016899108887 
SELECT * FROM productoffers
                WHERE product_id = '3699' AND price > 0
                ORDER BY price ASC LIMIT 1
162 0.0003 0.00028586387634277 
SELECT * FROM productoffers
                WHERE product_id = 3699
                ORDER BY price ASC LIMIT 1
163 0.0003 0.00026893615722656 
SELECT value FROM productattributes
                WHERE product_id = '3699'
                AND name = 'ListPriceAmount'
164 0.0003 0.00028300285339355 
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 = '3699'
                GROUP BY o.product_id
165 0.0003 0.00027298927307129 
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     = '3699'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
166 0.0003 0.00026917457580566 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3699
167 0.0003 0.00028204917907715 
SELECT value FROM productattributes WHERE product_id = '3699' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
168 0.0008 0.00082492828369141 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3699'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
169 0.0006 0.00059890747070312 
SELECT * FROM productimages WHERE product_id = '1324' ORDER BY sortorder ASC
170 0.0003 0.00027203559875488 
SELECT * FROM product_image_select WHERE product_id = '1324'
171 0.0004 0.00037002563476562 
SELECT * FROM productcustomimages WHERE product_id = '1324'
172 0.0003 0.00028896331787109 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1324' AND a.name = n.originalname
173 0.0005 0.00051712989807129 
SELECT * FROM productoffers WHERE product_id = '1324' AND merchantid = 'A1X6FK5RDHNB96'
174 0.0005 0.00051093101501465 
SELECT * FROM productoffers
                WHERE product_id = '1324' AND price > 0
                ORDER BY price ASC LIMIT 1
175 0.0003 0.00028181076049805 
SELECT value FROM productattributes WHERE product_id = '1324' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
176 0.0003 0.00028491020202637 
SELECT * FROM productimages WHERE product_id = '807' ORDER BY sortorder ASC
177 0.0003 0.00028300285339355 
SELECT * FROM product_image_select WHERE product_id = '807'
178 0.0003 0.00026798248291016 
SELECT * FROM productcustomimages WHERE product_id = '807'
179 0.0003 0.00031304359436035 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '807' AND a.name = n.originalname
180 0.0003 0.00031900405883789 
SELECT * FROM productoffers WHERE product_id = '807' AND merchantid = 'A1X6FK5RDHNB96'
181 0.0003 0.00032401084899902 
SELECT * FROM productoffers
                WHERE product_id = '807' AND price > 0
                ORDER BY price ASC LIMIT 1
182 0.0003 0.00031208992004395 
SELECT * FROM productoffers
                WHERE product_id = 807
                ORDER BY price ASC LIMIT 1
183 0.0003 0.00027012825012207 
SELECT value FROM productattributes
                WHERE product_id = '807'
                AND name = 'ListPriceAmount'
184 0.0003 0.00026202201843262 
SELECT value FROM productattributes WHERE product_id = '807' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
185 0.0003 0.00030899047851562 
SELECT * FROM productimages WHERE product_id = '3771' ORDER BY sortorder ASC
186 0.0003 0.00027203559875488 
SELECT * FROM product_image_select WHERE product_id = '3771'
187 0.0003 0.00028705596923828 
SELECT * FROM productcustomimages WHERE product_id = '3771'
188 0.0003 0.00033307075500488 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3771' AND a.name = n.originalname
189 0.0003 0.00029683113098145 
SELECT * FROM productoffers WHERE product_id = '3771' AND merchantid = 'A1X6FK5RDHNB96'
190 0.0003 0.0003349781036377 
SELECT * FROM productoffers
                WHERE product_id = '3771' AND price > 0
                ORDER BY price ASC LIMIT 1
191 0.0003 0.00032401084899902 
SELECT value FROM productattributes WHERE product_id = '3771' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
192 0.0007 0.00073480606079102 
SELECT * FROM productimages WHERE product_id = '3770' ORDER BY sortorder ASC
193 0.0005 0.00050806999206543 
SELECT * FROM product_image_select WHERE product_id = '3770'
194 0.0006 0.0005500316619873 
SELECT * FROM productcustomimages WHERE product_id = '3770'
195 0.0025 0.0025169849395752 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3770' AND a.name = n.originalname
196 0.0007 0.00069808959960938 
SELECT * FROM productoffers WHERE product_id = '3770' AND merchantid = 'A1X6FK5RDHNB96'
197 0.0008 0.00075316429138184 
SELECT * FROM productoffers
                WHERE product_id = '3770' AND price > 0
                ORDER BY price ASC LIMIT 1
198 0.0008 0.00081801414489746 
SELECT value FROM productattributes WHERE product_id = '3770' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
199 0.0003 0.00033998489379883 
SELECT * FROM productimages WHERE product_id = '924' ORDER BY sortorder ASC
200 0.0008 0.00082802772521973 
SELECT * FROM product_image_select WHERE product_id = '924'
201 0.0005 0.00051689147949219 
SELECT * FROM productcustomimages WHERE product_id = '924'
202 0.0021 0.0020909309387207 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '924' AND a.name = n.originalname
203 0.0015 0.001521110534668 
SELECT * FROM productoffers WHERE product_id = '924' AND merchantid = 'A1X6FK5RDHNB96'
204 0.0007 0.0007469654083252 
SELECT * FROM productoffers
                WHERE product_id = '924' AND price > 0
                ORDER BY price ASC LIMIT 1
205 0.0007 0.00069808959960938 
SELECT value FROM productattributes WHERE product_id = '924' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
206 0.0003 0.00031304359436035 
SELECT * FROM productimages WHERE product_id = '4211' ORDER BY sortorder ASC
207 0.0009 0.00092887878417969 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4211' AND p.id = pi.product_id ORDER BY pi.sortorder
208 0.0003 0.00031113624572754 
SELECT * FROM product_image_select WHERE product_id = '4211'
209 0.0003 0.00029802322387695 
SELECT * FROM productcustomimages WHERE product_id = '4211'
210 0.0013 0.0013260841369629 
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 = '4211'
                GROUP BY o.product_id
211 0.0009 0.00088286399841309 
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     = '4211'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
212 0.0006 0.00057291984558105 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4211
213 0.0003 0.0003049373626709 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4211' AND a.name = n.originalname
214 0.0003 0.00030207633972168 
SELECT * FROM productoffers WHERE product_id = '4211' AND merchantid = 'A1X6FK5RDHNB96'
215 0.0003 0.00030303001403809 
SELECT * FROM productoffers
                WHERE product_id = '4211' AND price > 0
                ORDER BY price ASC LIMIT 1
216 0.0003 0.00030303001403809 
SELECT * FROM productoffers
                WHERE product_id = 4211
                ORDER BY price ASC LIMIT 1
217 0.0003 0.00028204917907715 
SELECT value FROM productattributes
                WHERE product_id = '4211'
                AND name = 'ListPriceAmount'
218 0.0003 0.00031304359436035 
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 = '4211'
                GROUP BY o.product_id
219 0.0003 0.0002901554107666 
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     = '4211'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
220 0.0003 0.00028705596923828 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4211
221 0.0003 0.00028204917907715 
SELECT value FROM productattributes WHERE product_id = '4211' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
222 0.0008 0.00084614753723145 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4211'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
223 0.0007 0.00067281723022461 
SELECT * FROM products WHERE parent_id = '4211'
224 0.0003 0.00028419494628906 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4212' AND a.name = n.originalname
225 0.0003 0.00030803680419922 
SELECT * FROM productoffers WHERE product_id = '4212' AND merchantid = 'A1X6FK5RDHNB96'
226 0.0003 0.00032186508178711 
SELECT * FROM productoffers
                WHERE product_id = '4212' AND price > 0
                ORDER BY price ASC LIMIT 1
227 0.0011 0.0010678768157959 
SELECT * FROM productimages WHERE product_id = '2537' ORDER BY sortorder ASC
228 0.0010 0.00096511840820312 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2537' AND p.id = pi.product_id ORDER BY pi.sortorder
229 0.0009 0.0008699893951416 
SELECT * FROM product_image_select WHERE product_id = '2537'
230 0.0005 0.00054717063903809 
SELECT * FROM productcustomimages WHERE product_id = '2537'
231 0.0007 0.00068306922912598 
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 = '2537'
                GROUP BY o.product_id
232 0.0008 0.0008089542388916 
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     = '2537'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
233 0.0006 0.00062799453735352 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2537
234 0.0021 0.0021159648895264 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2537' AND a.name = n.originalname
235 0.0006 0.0005950927734375 
SELECT * FROM productoffers WHERE product_id = '2537' AND merchantid = 'A1X6FK5RDHNB96'
236 0.0005 0.00054216384887695 
SELECT * FROM productoffers
                WHERE product_id = '2537' AND price > 0
                ORDER BY price ASC LIMIT 1
237 0.0007 0.00067996978759766 
SELECT * FROM productoffers
                WHERE product_id = 2537
                ORDER BY price ASC LIMIT 1
238 0.0082 0.0082259178161621 
SELECT value FROM productattributes
                WHERE product_id = '2537'
                AND name = 'ListPriceAmount'
239 0.0006 0.00062894821166992 
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 = '2537'
                GROUP BY o.product_id
240 0.0003 0.00028109550476074 
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     = '2537'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
241 0.0003 0.0002751350402832 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2537
242 0.0007 0.00071310997009277 
SELECT value FROM productattributes WHERE product_id = '2537' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
243 0.0013 0.0012779235839844 
SELECT * FROM products WHERE parent_id = '2537'
244 0.0008 0.00077414512634277 
SELECT * FROM productimages WHERE product_id = '1051' ORDER BY sortorder ASC
245 0.0006 0.00064682960510254 
SELECT * FROM product_image_select WHERE product_id = '1051'
246 0.0005 0.00051498413085938 
SELECT * FROM productcustomimages WHERE product_id = '1051'
247 0.0019 0.0019121170043945 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1051' AND a.name = n.originalname
248 0.0011 0.0011239051818848 
SELECT * FROM productoffers WHERE product_id = '1051' AND merchantid = 'A1X6FK5RDHNB96'
249 0.0006 0.00061392784118652 
SELECT * FROM productoffers
                WHERE product_id = '1051' AND price > 0
                ORDER BY price ASC LIMIT 1
250 0.0005 0.00053811073303223 
SELECT * FROM productoffers
                WHERE product_id = 1051
                ORDER BY price ASC LIMIT 1
251 0.0007 0.00067996978759766 
SELECT value FROM productattributes
                WHERE product_id = '1051'
                AND name = 'ListPriceAmount'
252 0.0008 0.00078201293945312 
SELECT value FROM productattributes WHERE product_id = '1051' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
253 0.0004 0.00037097930908203 
SELECT * FROM productimages WHERE product_id = '2652' ORDER BY sortorder ASC
254 0.0014 0.0013868808746338 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2652' AND p.id = pi.product_id ORDER BY pi.sortorder
255 0.0003 0.00032806396484375 
SELECT * FROM product_image_select WHERE product_id = '2652'
256 0.0003 0.00029206275939941 
SELECT * FROM productcustomimages WHERE product_id = '2652'
257 0.0011 0.0010581016540527 
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 = '2652'
                GROUP BY o.product_id
258 0.0009 0.00094103813171387 
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     = '2652'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
259 0.0006 0.00056004524230957 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2652
260 0.0004 0.0003960132598877 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2652' AND a.name = n.originalname
261 0.0003 0.00030708312988281 
SELECT * FROM productoffers WHERE product_id = '2652' AND merchantid = 'A1X6FK5RDHNB96'
262 0.0003 0.0002899169921875 
SELECT * FROM productoffers
                WHERE product_id = '2652' AND price > 0
                ORDER BY price ASC LIMIT 1
263 0.0003 0.00030016899108887 
SELECT * FROM productoffers
                WHERE product_id = 2652
                ORDER BY price ASC LIMIT 1
264 0.0003 0.00026202201843262 
SELECT value FROM productattributes
                WHERE product_id = '2652'
                AND name = 'ListPriceAmount'
265 0.0003 0.00026416778564453 
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 = '2652'
                GROUP BY o.product_id
266 0.0003 0.00026702880859375 
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     = '2652'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
267 0.0003 0.00027084350585938 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2652
268 0.0003 0.00027799606323242 
SELECT value FROM productattributes WHERE product_id = '2652' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
269 0.0009 0.00091791152954102 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '2652'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
270 0.0017 0.0017139911651611 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '2652'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
271 0.0006 0.0006098747253418 
SELECT * FROM products WHERE parent_id = '2652'
272 0.0003 0.00029492378234863 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2655' AND a.name = n.originalname
273 0.0003 0.00029587745666504 
SELECT * FROM productoffers WHERE product_id = '2655' AND merchantid = 'A1X6FK5RDHNB96'
274 0.0003 0.00028395652770996 
SELECT * FROM productoffers
                WHERE product_id = '2655' AND price > 0
                ORDER BY price ASC LIMIT 1
275 0.0003 0.00027894973754883 
SELECT * FROM productoffers
                WHERE product_id = 2655
                ORDER BY price ASC LIMIT 1
276 0.0003 0.00031805038452148 
SELECT value FROM productattributes
                WHERE product_id = '2655'
                AND name = 'ListPriceAmount'
277 0.0003 0.00028395652770996 
SELECT * FROM productimages WHERE product_id = '2799' ORDER BY sortorder ASC
278 0.0003 0.00027084350585938 
SELECT * FROM product_image_select WHERE product_id = '2799'
279 0.0003 0.00028896331787109 
SELECT * FROM productcustomimages WHERE product_id = '2799'
280 0.0003 0.00030303001403809 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2799' AND a.name = n.originalname
281 0.0003 0.00028514862060547 
SELECT * FROM productoffers WHERE product_id = '2799' AND merchantid = 'A1X6FK5RDHNB96'
282 0.0003 0.00027894973754883 
SELECT * FROM productoffers
                WHERE product_id = '2799' AND price > 0
                ORDER BY price ASC LIMIT 1
283 0.0003 0.00028896331787109 
SELECT * FROM productoffers
                WHERE product_id = 2799
                ORDER BY price ASC LIMIT 1
284 0.0003 0.00025796890258789 
SELECT value FROM productattributes
                WHERE product_id = '2799'
                AND name = 'ListPriceAmount'
285 0.0003 0.00025296211242676 
SELECT value FROM productattributes WHERE product_id = '2799' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
286 0.0003 0.00028896331787109 
SELECT * FROM productimages WHERE product_id = '1662' ORDER BY sortorder ASC
287 0.0003 0.00027203559875488 
SELECT * FROM product_image_select WHERE product_id = '1662'
288 0.0003 0.00026798248291016 
SELECT * FROM productcustomimages WHERE product_id = '1662'
289 0.0003 0.00032687187194824 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1662' AND a.name = n.originalname
290 0.0003 0.00030994415283203 
SELECT * FROM productoffers WHERE product_id = '1662' AND merchantid = 'A1X6FK5RDHNB96'
291 0.0003 0.00028204917907715 
SELECT * FROM productoffers
                WHERE product_id = '1662' AND price > 0
                ORDER BY price ASC LIMIT 1
292 0.0003 0.00028491020202637 
SELECT * FROM productoffers
                WHERE product_id = 1662
                ORDER BY price ASC LIMIT 1
293 0.0003 0.00026822090148926 
SELECT value FROM productattributes
                WHERE product_id = '1662'
                AND name = 'ListPriceAmount'
294 0.0003 0.00029110908508301 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1487' ORDER BY timestamp DESC
295 0.0003 0.00029397010803223 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '777' ORDER BY timestamp DESC
296 0.0013 0.0013179779052734 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1308' ORDER BY timestamp DESC
297 0.0005 0.00045919418334961 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3155' ORDER BY timestamp DESC
298 0.0006 0.00062203407287598 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1309' ORDER BY timestamp DESC
299 0.0003 0.00033402442932129 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2233' ORDER BY timestamp DESC
300 0.0003 0.00032496452331543 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3699' ORDER BY timestamp DESC
301 0.0003 0.00032687187194824 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1324' ORDER BY timestamp DESC
302 0.0003 0.00030994415283203 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '807' ORDER BY timestamp DESC
303 0.0003 0.00031709671020508 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3771' ORDER BY timestamp DESC
304 0.0009 0.00088000297546387 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3770' ORDER BY timestamp DESC
305 0.0005 0.0004730224609375 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '924' ORDER BY timestamp DESC
306 0.0003 0.00031781196594238 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4211' ORDER BY timestamp DESC
307 0.0005 0.0005490779876709 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2537' ORDER BY timestamp DESC
308 0.0006 0.00063800811767578 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1051' ORDER BY timestamp DESC
309 0.0003 0.0003211498260498 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2652' ORDER BY timestamp DESC
310 0.0003 0.00030899047851562 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2799' ORDER BY timestamp DESC
311 0.0003 0.00031685829162598 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1662' ORDER BY timestamp DESC
312 0.0004 0.00037813186645508 
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
313 0.0004 0.0004119873046875 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
314 0.0003 0.0002899169921875 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
315 0.0003 0.0003209114074707 
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
316 0.0003 0.00030303001403809 
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
317 0.0003 0.00029802322387695 
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
318 0.0004 0.00038385391235352 
SELECT * FROM products WHERE id = 1626
319 0.0005 0.00051093101501465 
SELECT * FROM products WHERE id = 4041
320 0.0006 0.00055909156799316 
SELECT * FROM products WHERE id = 4312
321 0.0014 0.0014050006866455 
SELECT * FROM products WHERE id = 777
322 0.0006 0.00058579444885254 
SELECT * FROM products WHERE id = 4213
323 0.0007 0.00070905685424805 
SELECT * FROM products WHERE id = 3881
324 0.0006 0.00055503845214844 
SELECT * FROM products WHERE id = '1626'
325 0.0003 0.0003361701965332 
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
326 0.0003 0.00031590461730957 
SELECT * FROM product_image_select WHERE product_id = '1626'
327 0.0006 0.00062990188598633 
SELECT * FROM productcustomimages WHERE product_id = '1626'
328 0.0003 0.00034999847412109 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
329 0.0004 0.00043487548828125 
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
330 0.0003 0.00034403800964355 
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
331 0.0003 0.00031089782714844 
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
332 0.0004 0.00042510032653809 
SELECT * FROM products WHERE id = '4041'
333 0.0003 0.00029706954956055 
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
334 0.0003 0.00030303001403809 
SELECT * FROM product_image_select WHERE product_id = '4041'
335 0.0003 0.00030899047851562 
SELECT * FROM productcustomimages WHERE product_id = '4041'
336 0.0003 0.00030517578125 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
337 0.0003 0.00033283233642578 
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
338 0.0004 0.00035285949707031 
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
339 0.0004 0.00041890144348145 
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
340 0.0004 0.00042009353637695 
SELECT * FROM products WHERE id = '4312'
341 0.0003 0.00034904479980469 
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
342 0.0003 0.00031590461730957 
SELECT * FROM product_image_select WHERE product_id = '4312'
343 0.0003 0.00031709671020508 
SELECT * FROM productcustomimages WHERE product_id = '4312'
344 0.0003 0.0003359317779541 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
345 0.0003 0.00032591819763184 
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
346 0.0003 0.00034999847412109 
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
347 0.0003 0.00033903121948242 
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
348 0.0004 0.0004279613494873 
SELECT * FROM products WHERE id = '777'
349 0.0003 0.00032806396484375 
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
350 0.0003 0.00033378601074219 
SELECT * FROM product_image_select WHERE product_id = '777'
351 0.0003 0.0003349781036377 
SELECT * FROM productcustomimages WHERE product_id = '777'
352 0.0003 0.00034594535827637 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
353 0.0003 0.00033187866210938 
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
354 0.0004 0.00035405158996582 
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
355 0.0003 0.00030803680419922 
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
356 0.0004 0.00039100646972656 
SELECT * FROM products WHERE id = '4213'
357 0.0005 0.00052785873413086 
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
358 0.0004 0.00036716461181641 
SELECT * FROM product_image_select WHERE product_id = '4213'
359 0.0003 0.00032210350036621 
SELECT * FROM productcustomimages WHERE product_id = '4213'
360 0.0005 0.00048589706420898 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
361 0.0004 0.00036907196044922 
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
362 0.0004 0.00039196014404297 
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
363 0.0003 0.00031805038452148 
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
364 0.0004 0.00043606758117676 
SELECT * FROM products WHERE id = '3881'
365 0.0005 0.00053000450134277 
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
366 0.0004 0.00037193298339844 
SELECT * FROM product_image_select WHERE product_id = '3881'
367 0.0004 0.00035905838012695 
SELECT * FROM productcustomimages WHERE product_id = '3881'
368 0.0003 0.00032687187194824 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
369 0.0004 0.00036406517028809 
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
370 0.0003 0.00034809112548828 
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
371 0.0003 0.00031709671020508 
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
372 0.0004 0.00043201446533203 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
373 0.0004 0.00041794776916504 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
374 0.0005 0.00048494338989258 
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
375 0.0006 0.00057697296142578 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
376 0.0006 0.00058102607727051 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
377 0.0006 0.00058197975158691 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
378 0.0005 0.00051712989807129 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'