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.475114107132 348 1.0981 0


No Amazon API Requests Made.


App Debug - Total Time 1.475114107132 seconds

Number Time From Start Name Description
1 0.37196397781372 Initialise Initialise FSB Function
2 0.39382004737854 App Controller Start Start of the App controller (called before the controller of every page)
3 0.42570304870605 Start of getCategoryListByGroup Function Before first category groups query
4 0.42715001106262 After initial query Before first category groups query
5 0.42715096473694 Get Category List for Group Before the call to getCategoryList function
6 0.42715311050415 Start of GetCategoryList function Start of the function
7 0.42715501785278 Before getting categories Query to get specific category list
8 0.42772197723389 After getting categories Query to get specific category list
9 0.42772197723389 Before getting category custom Before call to function getCategoryCustom
10 0.45326089859009 After getting category custom After call to function getCategoryCustom
11 0.4532630443573 Before getting category custom Before call to function getCategoryCustom
12 0.46440196037292 After getting category custom After call to function getCategoryCustom
13 0.46440410614014 Before getting category custom Before call to function getCategoryCustom
14 0.47038888931274 After getting category custom After call to function getCategoryCustom
15 0.47039103507996 Before getting category custom Before call to function getCategoryCustom
16 0.47438097000122 After getting category custom After call to function getCategoryCustom
17 0.47438287734985 Before getting category custom Before call to function getCategoryCustom
18 0.47852206230164 After getting category custom After call to function getCategoryCustom
19 0.47852396965027 Before getting category custom Before call to function getCategoryCustom
20 0.48253488540649 After getting category custom After call to function getCategoryCustom
21 0.48253703117371 End of GetCategoryList function End of the function
22 0.48254108428955 Get Category List for Group Before the call to getCategoryList function
23 0.48254299163818 Start of GetCategoryList function Start of the function
24 0.4825439453125 Before getting categories Query to get specific category list
25 0.48301100730896 End of getCategoryListByGroup Function Before return()
26 1.2731139659882 App Controller End End of the App controller (called before the controller of every page)
27 1.3930780887604 App_after Controller Start Start of the App_after controller (called after the controller of every page)
28 1.3946409225464 Before Get Options Before the call to getOptions in the tpl class
29 1.4507479667664 After Get Options After the call to getOptions in the tpl class
30 1.4507761001587 App_after Controller End End of the App_after controller (called after the controller of every page)
31 1.4751060009003 Finalizing debug Before the debug is output to the page.
32 1.4751129150391 End of App This is the end of the app logging, final timestamp


Query Debug - 348 Database Queries. Total time 1.0981 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0021 0.0021200180053711 
SELECT parameter, value FROM parameters
2 0.0079 0.0078928470611572 
SELECT * FROM `bad_bots`
3 0.0004 0.00042319297790527 
SET time_zone = 'Europe/London'
4 0.0029 0.0028800964355469 
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0051 0.0051100254058838 
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"3.135.204.121\";}'
6 0.0027 0.0026659965515137 
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1747091780'
7 0.0037 0.0036520957946777 
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0007 0.00066304206848145 
UPDATE autorun SET lastrun = '2025-05-12 23:16:20' WHERE id = '13'
9 0.0009 0.00085186958312988 
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0038 0.003803014755249 
SELECT id FROM pages WHERE pagename = 'tag' LIMIT 1
11 0.0035 0.0034561157226562 
SELECT id FROM products WHERE pagename = 'tag' AND hidden = 0 LIMIT 1
12 0.0028 0.0027539730072021 
SELECT id FROM ebay_products WHERE pagename = 'tag'
13 0.0025 0.0025241374969482 
SELECT id FROM custom_products WHERE pagename = 'tag'
14 0.0022 0.0022189617156982 
SELECT id FROM categories WHERE pagename = 'tag' LIMIT 1
15 0.0018 0.0017549991607666 
SELECT id FROM manufacturers WHERE pagename = 'tag' LIMIT 1
16 0.0019 0.0019450187683105 
SELECT id FROM bundles WHERE pagename = 'tag' LIMIT 1
17 0.0020 0.0019881725311279 
SELECT id FROM tags WHERE pagename = 'picerie' LIMIT 1
18 0.0030 0.0030150413513184 
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
19 0.0280 0.028002023696899 
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
20 0.0005 0.00051403045654297 
SELECT * FROM pages WHERE pagename = 'tag'
21 0.0014 0.0014419555664062 
SELECT * FROM categorygroups ORDER BY sortorder ASC
22 0.0006 0.00055909156799316 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
23 0.0067 0.0066869258880615 
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.0030 0.0030479431152344 
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.0035 0.0035378932952881 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
26 0.0026 0.0025870800018311 
SELECT id FROM categories WHERE parent_id = '26'
27 0.0063 0.0063102245330811 
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.0006 0.00058507919311523 
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.0006 0.00055384635925293 
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.0017 0.0017299652099609 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
31 0.0004 0.00042891502380371 
SELECT * FROM categorygroups WHERE id = '1'
32 0.0044 0.0044350624084473 
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.00043487548828125 
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.00034689903259277 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
35 0.0005 0.00046110153198242 
SELECT id FROM categories WHERE parent_id = '27'
36 0.0038 0.0037860870361328 
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.0005 0.00045013427734375 
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.0004 0.00043606758117676 
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.0004 0.00039792060852051 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
40 0.0004 0.00035309791564941 
SELECT * FROM categorygroups WHERE id = '1'
41 0.0015 0.0014529228210449 
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.0004 0.00042819976806641 
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.0004 0.00038719177246094 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
44 0.0004 0.00037884712219238 
SELECT id FROM categories WHERE parent_id = '28'
45 0.0016 0.001600980758667 
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.0005 0.0004580020904541 
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.0005 0.00045299530029297 
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.0004 0.00040388107299805 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
49 0.0004 0.00036883354187012 
SELECT * FROM categorygroups WHERE id = '1'
50 0.0005 0.00054311752319336 
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.0004 0.00044894218444824 
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.00032496452331543 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
53 0.0003 0.00034785270690918 
SELECT id FROM categories WHERE parent_id = '29'
54 0.0006 0.00060796737670898 
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.0004 0.00043201446533203 
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.0004 0.00043201446533203 
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.0004 0.00040292739868164 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
58 0.0004 0.00040507316589355 
SELECT * FROM categorygroups WHERE id = '1'
59 0.0006 0.00061702728271484 
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.00049805641174316 
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.0004 0.00035810470581055 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
62 0.0004 0.0003669261932373 
SELECT id FROM categories WHERE parent_id = '30'
63 0.0006 0.00061607360839844 
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.0004 0.00040197372436523 
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.0004 0.00043511390686035 
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.0004 0.00040292739868164 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
67 0.0004 0.00039505958557129 
SELECT * FROM categorygroups WHERE id = '1'
68 0.0005 0.00054311752319336 
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.0004 0.00040006637573242 
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.0003 0.00034213066101074 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
71 0.0003 0.00032401084899902 
SELECT id FROM categories WHERE parent_id = '31'
72 0.0007 0.0006558895111084 
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.0004 0.00041508674621582 
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.0004 0.0004429817199707 
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.0004 0.00043702125549316 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
76 0.0004 0.00040292739868164 
SELECT * FROM categorygroups WHERE id = '1'
77 0.0005 0.00046110153198242 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
78 0.0015 0.0014610290527344 
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
79 0.0016 0.0015740394592285 
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
80 0.0005 0.00046205520629883 
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.0011 0.0010600090026855 
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
82 0.0011 0.0010788440704346 
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
83 0.0009 0.00089406967163086 
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
84 0.7791 0.77913498878479 
SELECT * FROM ipgeocountries WHERE INET_ATON('3.135.204.121') >= INET_ATON(ip_start) AND INET_ATON('3.135.204.121') <= INET_ATON(ip_end)
85 0.0018 0.0017879009246826 
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
86 0.0011 0.0011019706726074 
SELECT * FROM countryredirects WHERE countrycode = 'US'
87 0.0091 0.0091288089752197 
SELECT * FROM tags WHERE pagename = 'picerie'
88 0.0052 0.0052318572998047 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
89 0.0016 0.0016179084777832 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
90 0.0015 0.0015149116516113 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
91 0.0052 0.005173921585083 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
92 0.0015 0.0015468597412109 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
93 0.0004 0.00043702125549316 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
94 0.0025 0.002518892288208 
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.0040 0.0040168762207031 
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 126, 18
96 0.0013 0.0012898445129395 
SELECT * FROM productimages WHERE product_id = '1448' ORDER BY sortorder ASC
97 0.0013 0.0012869834899902 
SELECT * FROM product_image_select WHERE product_id = '1448'
98 0.0011 0.0010619163513184 
SELECT * FROM productcustomimages WHERE product_id = '1448'
99 0.0017 0.0016579627990723 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1448' AND a.name = n.originalname
100 0.0012 0.0011968612670898 
SELECT * FROM productoffers WHERE product_id = '1448' AND merchantid = 'A1X6FK5RDHNB96'
101 0.0003 0.00032687187194824 
SELECT * FROM productoffers
                WHERE product_id = '1448' AND price > 0
                ORDER BY price ASC LIMIT 1
102 0.0003 0.00030803680419922 
SELECT * FROM productoffers
                WHERE product_id = 1448
                ORDER BY price ASC LIMIT 1
103 0.0004 0.00043892860412598 
SELECT value FROM productattributes
                WHERE product_id = '1448'
                AND name = 'ListPriceAmount'
104 0.0004 0.0003659725189209 
SELECT value FROM productattributes WHERE product_id = '1448' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
105 0.0004 0.00037407875061035 
SELECT * FROM productimages WHERE product_id = '1451' ORDER BY sortorder ASC
106 0.0005 0.00049304962158203 
SELECT * FROM product_image_select WHERE product_id = '1451'
107 0.0003 0.0003209114074707 
SELECT * FROM productcustomimages WHERE product_id = '1451'
108 0.0007 0.00068902969360352 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1451' AND a.name = n.originalname
109 0.0004 0.00039887428283691 
SELECT * FROM productoffers WHERE product_id = '1451' AND merchantid = 'A1X6FK5RDHNB96'
110 0.0003 0.00033688545227051 
SELECT * FROM productoffers
                WHERE product_id = '1451' AND price > 0
                ORDER BY price ASC LIMIT 1
111 0.0003 0.00030684471130371 
SELECT * FROM productoffers
                WHERE product_id = 1451
                ORDER BY price ASC LIMIT 1
112 0.0003 0.00033378601074219 
SELECT value FROM productattributes
                WHERE product_id = '1451'
                AND name = 'ListPriceAmount'
113 0.0004 0.00042200088500977 
SELECT value FROM productattributes WHERE product_id = '1451' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
114 0.0005 0.00045585632324219 
SELECT * FROM productimages WHERE product_id = '1457' ORDER BY sortorder ASC
115 0.0005 0.00050902366638184 
SELECT * FROM product_image_select WHERE product_id = '1457'
116 0.0003 0.00031709671020508 
SELECT * FROM productcustomimages WHERE product_id = '1457'
117 0.0008 0.00080704689025879 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1457' AND a.name = n.originalname
118 0.0004 0.0003669261932373 
SELECT * FROM productoffers WHERE product_id = '1457' AND merchantid = 'A1X6FK5RDHNB96'
119 0.0003 0.00032901763916016 
SELECT * FROM productoffers
                WHERE product_id = '1457' AND price > 0
                ORDER BY price ASC LIMIT 1
120 0.0003 0.00030207633972168 
SELECT * FROM productoffers
                WHERE product_id = 1457
                ORDER BY price ASC LIMIT 1
121 0.0003 0.00032401084899902 
SELECT value FROM productattributes
                WHERE product_id = '1457'
                AND name = 'ListPriceAmount'
122 0.0003 0.00033998489379883 
SELECT value FROM productattributes WHERE product_id = '1457' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
123 0.0004 0.00043010711669922 
SELECT * FROM productimages WHERE product_id = '1474' ORDER BY sortorder ASC
124 0.0005 0.00052690505981445 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1474' AND p.id = pi.product_id ORDER BY pi.sortorder
125 0.0005 0.00049901008605957 
SELECT * FROM product_image_select WHERE product_id = '1474'
126 0.0003 0.00031018257141113 
SELECT * FROM productcustomimages WHERE product_id = '1474'
127 0.0004 0.00042819976806641 
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 = '1474'
                GROUP BY o.product_id
128 0.0022 0.0022239685058594 
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     = '1474'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
129 0.0005 0.00047993659973145 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1474
130 0.0008 0.00080490112304688 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1474' AND a.name = n.originalname
131 0.0004 0.00037789344787598 
SELECT * FROM productoffers WHERE product_id = '1474' AND merchantid = 'A1X6FK5RDHNB96'
132 0.0003 0.00031709671020508 
SELECT * FROM productoffers
                WHERE product_id = '1474' AND price > 0
                ORDER BY price ASC LIMIT 1
133 0.0003 0.00028204917907715 
SELECT * FROM productoffers
                WHERE product_id = 1474
                ORDER BY price ASC LIMIT 1
134 0.0003 0.00032806396484375 
SELECT value FROM productattributes
                WHERE product_id = '1474'
                AND name = 'ListPriceAmount'
135 0.0004 0.00040006637573242 
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 = '1474'
                GROUP BY o.product_id
136 0.0006 0.00057005882263184 
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     = '1474'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
137 0.0004 0.00035214424133301 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1474
138 0.0005 0.00046896934509277 
SELECT value FROM productattributes WHERE product_id = '1474' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
139 0.0005 0.00053596496582031 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '1474'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
140 0.0004 0.00040292739868164 
SELECT * FROM productimages WHERE product_id = '1478' ORDER BY sortorder ASC
141 0.0005 0.00049495697021484 
SELECT * FROM product_image_select WHERE product_id = '1478'
142 0.0003 0.00034904479980469 
SELECT * FROM productcustomimages WHERE product_id = '1478'
143 0.0010 0.0010459423065186 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1478' AND a.name = n.originalname
144 0.0005 0.00046610832214355 
SELECT * FROM productoffers WHERE product_id = '1478' AND merchantid = 'A1X6FK5RDHNB96'
145 0.0004 0.00036215782165527 
SELECT * FROM productoffers
                WHERE product_id = '1478' AND price > 0
                ORDER BY price ASC LIMIT 1
146 0.0003 0.00034713745117188 
SELECT value FROM productattributes WHERE product_id = '1478' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
147 0.0004 0.00040292739868164 
SELECT * FROM productimages WHERE product_id = '1480' ORDER BY sortorder ASC
148 0.0005 0.0004889965057373 
SELECT * FROM product_image_select WHERE product_id = '1480'
149 0.0003 0.00031518936157227 
SELECT * FROM productcustomimages WHERE product_id = '1480'
150 0.0010 0.00096702575683594 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1480' AND a.name = n.originalname
151 0.0005 0.00045490264892578 
SELECT * FROM productoffers WHERE product_id = '1480' AND merchantid = 'A1X6FK5RDHNB96'
152 0.0003 0.00032806396484375 
SELECT * FROM productoffers
                WHERE product_id = '1480' AND price > 0
                ORDER BY price ASC LIMIT 1
153 0.0003 0.00030708312988281 
SELECT * FROM productoffers
                WHERE product_id = 1480
                ORDER BY price ASC LIMIT 1
154 0.0004 0.00036406517028809 
SELECT value FROM productattributes
                WHERE product_id = '1480'
                AND name = 'ListPriceAmount'
155 0.0004 0.00036883354187012 
SELECT value FROM productattributes WHERE product_id = '1480' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
156 0.0004 0.00041007995605469 
SELECT * FROM productimages WHERE product_id = '1490' ORDER BY sortorder ASC
157 0.0005 0.00049090385437012 
SELECT * FROM product_image_select WHERE product_id = '1490'
158 0.0003 0.0003359317779541 
SELECT * FROM productcustomimages WHERE product_id = '1490'
159 0.0010 0.0010411739349365 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1490' AND a.name = n.originalname
160 0.0004 0.00041007995605469 
SELECT * FROM productoffers WHERE product_id = '1490' AND merchantid = 'A1X6FK5RDHNB96'
161 0.0003 0.00030803680419922 
SELECT * FROM productoffers
                WHERE product_id = '1490' AND price > 0
                ORDER BY price ASC LIMIT 1
162 0.0003 0.00027203559875488 
SELECT * FROM productoffers
                WHERE product_id = 1490
                ORDER BY price ASC LIMIT 1
163 0.0003 0.00034499168395996 
SELECT value FROM productattributes
                WHERE product_id = '1490'
                AND name = 'ListPriceAmount'
164 0.0004 0.00036716461181641 
SELECT value FROM productattributes WHERE product_id = '1490' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
165 0.0004 0.00043582916259766 
SELECT * FROM productimages WHERE product_id = '1492' ORDER BY sortorder ASC
166 0.0005 0.0004880428314209 
SELECT * FROM product_image_select WHERE product_id = '1492'
167 0.0003 0.00032210350036621 
SELECT * FROM productcustomimages WHERE product_id = '1492'
168 0.0008 0.00083088874816895 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1492' AND a.name = n.originalname
169 0.0004 0.00043082237243652 
SELECT * FROM productoffers WHERE product_id = '1492' AND merchantid = 'A1X6FK5RDHNB96'
170 0.0003 0.00032687187194824 
SELECT * FROM productoffers
                WHERE product_id = '1492' AND price > 0
                ORDER BY price ASC LIMIT 1
171 0.0003 0.00029802322387695 
SELECT * FROM productoffers
                WHERE product_id = 1492
                ORDER BY price ASC LIMIT 1
172 0.0003 0.0003359317779541 
SELECT value FROM productattributes
                WHERE product_id = '1492'
                AND name = 'ListPriceAmount'
173 0.0004 0.00036501884460449 
SELECT value FROM productattributes WHERE product_id = '1492' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
174 0.0004 0.00038003921508789 
SELECT * FROM productimages WHERE product_id = '1502' ORDER BY sortorder ASC
175 0.0005 0.00050711631774902 
SELECT * FROM product_image_select WHERE product_id = '1502'
176 0.0003 0.00033998489379883 
SELECT * FROM productcustomimages WHERE product_id = '1502'
177 0.0007 0.00066995620727539 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1502' AND a.name = n.originalname
178 0.0004 0.00038886070251465 
SELECT * FROM productoffers WHERE product_id = '1502' AND merchantid = 'A1X6FK5RDHNB96'
179 0.0004 0.0003669261932373 
SELECT * FROM productoffers
                WHERE product_id = '1502' AND price > 0
                ORDER BY price ASC LIMIT 1
180 0.0003 0.00026798248291016 
SELECT * FROM productoffers
                WHERE product_id = 1502
                ORDER BY price ASC LIMIT 1
181 0.0004 0.00035691261291504 
SELECT value FROM productattributes
                WHERE product_id = '1502'
                AND name = 'ListPriceAmount'
182 0.0004 0.0003659725189209 
SELECT value FROM productattributes WHERE product_id = '1502' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
183 0.0004 0.00037693977355957 
SELECT * FROM productimages WHERE product_id = '1507' ORDER BY sortorder ASC
184 0.0005 0.00052404403686523 
SELECT * FROM product_image_select WHERE product_id = '1507'
185 0.0003 0.00032281875610352 
SELECT * FROM productcustomimages WHERE product_id = '1507'
186 0.0007 0.0006558895111084 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1507' AND a.name = n.originalname
187 0.0004 0.0004119873046875 
SELECT * FROM productoffers WHERE product_id = '1507' AND merchantid = 'A1X6FK5RDHNB96'
188 0.0003 0.00031685829162598 
SELECT * FROM productoffers
                WHERE product_id = '1507' AND price > 0
                ORDER BY price ASC LIMIT 1
189 0.0003 0.00027108192443848 
SELECT * FROM productoffers
                WHERE product_id = 1507
                ORDER BY price ASC LIMIT 1
190 0.0003 0.00032997131347656 
SELECT value FROM productattributes
                WHERE product_id = '1507'
                AND name = 'ListPriceAmount'
191 0.0004 0.0003969669342041 
SELECT value FROM productattributes WHERE product_id = '1507' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
192 0.0004 0.00039005279541016 
SELECT * FROM productimages WHERE product_id = '1510' ORDER BY sortorder ASC
193 0.0005 0.00048708915710449 
SELECT * FROM product_image_select WHERE product_id = '1510'
194 0.0003 0.0003049373626709 
SELECT * FROM productcustomimages WHERE product_id = '1510'
195 0.0009 0.0008690357208252 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1510' AND a.name = n.originalname
196 0.0004 0.00035691261291504 
SELECT * FROM productoffers WHERE product_id = '1510' AND merchantid = 'A1X6FK5RDHNB96'
197 0.0003 0.00030088424682617 
SELECT * FROM productoffers
                WHERE product_id = '1510' AND price > 0
                ORDER BY price ASC LIMIT 1
198 0.0003 0.0002739429473877 
SELECT * FROM productoffers
                WHERE product_id = 1510
                ORDER BY price ASC LIMIT 1
199 0.0003 0.00030899047851562 
SELECT value FROM productattributes
                WHERE product_id = '1510'
                AND name = 'ListPriceAmount'
200 0.0004 0.00044107437133789 
SELECT value FROM productattributes WHERE product_id = '1510' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
201 0.0004 0.00038290023803711 
SELECT * FROM productimages WHERE product_id = '1514' ORDER BY sortorder ASC
202 0.0005 0.00049185752868652 
SELECT * FROM product_image_select WHERE product_id = '1514'
203 0.0004 0.0003809928894043 
SELECT * FROM productcustomimages WHERE product_id = '1514'
204 0.0010 0.00096321105957031 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1514' AND a.name = n.originalname
205 0.0004 0.00041294097900391 
SELECT * FROM productoffers WHERE product_id = '1514' AND merchantid = 'A1X6FK5RDHNB96'
206 0.0003 0.00031495094299316 
SELECT * FROM productoffers
                WHERE product_id = '1514' AND price > 0
                ORDER BY price ASC LIMIT 1
207 0.0003 0.00030398368835449 
SELECT * FROM productoffers
                WHERE product_id = 1514
                ORDER BY price ASC LIMIT 1
208 0.0003 0.00032305717468262 
SELECT value FROM productattributes
                WHERE product_id = '1514'
                AND name = 'ListPriceAmount'
209 0.0004 0.00037384033203125 
SELECT value FROM productattributes WHERE product_id = '1514' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
210 0.0004 0.00037789344787598 
SELECT * FROM productimages WHERE product_id = '1522' ORDER BY sortorder ASC
211 0.0005 0.00051999092102051 
SELECT * FROM product_image_select WHERE product_id = '1522'
212 0.0003 0.00032305717468262 
SELECT * FROM productcustomimages WHERE product_id = '1522'
213 0.0007 0.00066781044006348 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1522' AND a.name = n.originalname
214 0.0004 0.0003809928894043 
SELECT * FROM productoffers WHERE product_id = '1522' AND merchantid = 'A1X6FK5RDHNB96'
215 0.0003 0.00029182434082031 
SELECT * FROM productoffers
                WHERE product_id = '1522' AND price > 0
                ORDER BY price ASC LIMIT 1
216 0.0003 0.00028395652770996 
SELECT * FROM productoffers
                WHERE product_id = 1522
                ORDER BY price ASC LIMIT 1
217 0.0004 0.00035500526428223 
SELECT value FROM productattributes
                WHERE product_id = '1522'
                AND name = 'ListPriceAmount'
218 0.0004 0.0003669261932373 
SELECT value FROM productattributes WHERE product_id = '1522' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
219 0.0005 0.00045895576477051 
SELECT * FROM productimages WHERE product_id = '1547' ORDER BY sortorder ASC
220 0.0005 0.00050497055053711 
SELECT * FROM product_image_select WHERE product_id = '1547'
221 0.0003 0.00031900405883789 
SELECT * FROM productcustomimages WHERE product_id = '1547'
222 0.0010 0.0010049343109131 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1547' AND a.name = n.originalname
223 0.0004 0.00039982795715332 
SELECT * FROM productoffers WHERE product_id = '1547' AND merchantid = 'A1X6FK5RDHNB96'
224 0.0003 0.00032997131347656 
SELECT * FROM productoffers
                WHERE product_id = '1547' AND price > 0
                ORDER BY price ASC LIMIT 1
225 0.0003 0.00027608871459961 
SELECT * FROM productoffers
                WHERE product_id = 1547
                ORDER BY price ASC LIMIT 1
226 0.0003 0.00034594535827637 
SELECT value FROM productattributes
                WHERE product_id = '1547'
                AND name = 'ListPriceAmount'
227 0.0004 0.00036096572875977 
SELECT value FROM productattributes WHERE product_id = '1547' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
228 0.0004 0.00039505958557129 
SELECT * FROM productimages WHERE product_id = '1553' ORDER BY sortorder ASC
229 0.0005 0.00053596496582031 
SELECT * FROM product_image_select WHERE product_id = '1553'
230 0.0003 0.00031304359436035 
SELECT * FROM productcustomimages WHERE product_id = '1553'
231 0.0009 0.00089192390441895 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1553' AND a.name = n.originalname
232 0.0004 0.00035810470581055 
SELECT * FROM productoffers WHERE product_id = '1553' AND merchantid = 'A1X6FK5RDHNB96'
233 0.0003 0.00031208992004395 
SELECT * FROM productoffers
                WHERE product_id = '1553' AND price > 0
                ORDER BY price ASC LIMIT 1
234 0.0003 0.00030303001403809 
SELECT * FROM productoffers
                WHERE product_id = 1553
                ORDER BY price ASC LIMIT 1
235 0.0003 0.00031685829162598 
SELECT value FROM productattributes
                WHERE product_id = '1553'
                AND name = 'ListPriceAmount'
236 0.0004 0.00035500526428223 
SELECT value FROM productattributes WHERE product_id = '1553' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
237 0.0004 0.00043892860412598 
SELECT * FROM productimages WHERE product_id = '1573' ORDER BY sortorder ASC
238 0.0011 0.0010840892791748 
SELECT * FROM product_image_select WHERE product_id = '1573'
239 0.0003 0.00034403800964355 
SELECT * FROM productcustomimages WHERE product_id = '1573'
240 0.0011 0.0010879039764404 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1573' AND a.name = n.originalname
241 0.0004 0.00038790702819824 
SELECT * FROM productoffers WHERE product_id = '1573' AND merchantid = 'A1X6FK5RDHNB96'
242 0.0003 0.00032806396484375 
SELECT * FROM productoffers
                WHERE product_id = '1573' AND price > 0
                ORDER BY price ASC LIMIT 1
243 0.0003 0.00030708312988281 
SELECT * FROM productoffers
                WHERE product_id = 1573
                ORDER BY price ASC LIMIT 1
244 0.0003 0.00033712387084961 
SELECT value FROM productattributes
                WHERE product_id = '1573'
                AND name = 'ListPriceAmount'
245 0.0004 0.00037288665771484 
SELECT value FROM productattributes WHERE product_id = '1573' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
246 0.0004 0.00040912628173828 
SELECT * FROM productimages WHERE product_id = '1576' ORDER BY sortorder ASC
247 0.0005 0.00051307678222656 
SELECT * FROM product_image_select WHERE product_id = '1576'
248 0.0004 0.00036096572875977 
SELECT * FROM productcustomimages WHERE product_id = '1576'
249 0.0007 0.00068902969360352 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1576' AND a.name = n.originalname
250 0.0005 0.00051307678222656 
SELECT * FROM productoffers WHERE product_id = '1576' AND merchantid = 'A1X6FK5RDHNB96'
251 0.0004 0.00040102005004883 
SELECT * FROM productoffers
                WHERE product_id = '1576' AND price > 0
                ORDER BY price ASC LIMIT 1
252 0.0004 0.00041294097900391 
SELECT * FROM productoffers
                WHERE product_id = 1576
                ORDER BY price ASC LIMIT 1
253 0.0004 0.00043988227844238 
SELECT value FROM productattributes
                WHERE product_id = '1576'
                AND name = 'ListPriceAmount'
254 0.0004 0.00040507316589355 
SELECT value FROM productattributes WHERE product_id = '1576' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
255 0.0004 0.00043606758117676 
SELECT * FROM productimages WHERE product_id = '1584' ORDER BY sortorder ASC
256 0.0005 0.00051093101501465 
SELECT * FROM product_image_select WHERE product_id = '1584'
257 0.0003 0.00031781196594238 
SELECT * FROM productcustomimages WHERE product_id = '1584'
258 0.0007 0.00065708160400391 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1584' AND a.name = n.originalname
259 0.0004 0.00041508674621582 
SELECT * FROM productoffers WHERE product_id = '1584' AND merchantid = 'A1X6FK5RDHNB96'
260 0.0003 0.00032901763916016 
SELECT * FROM productoffers
                WHERE product_id = '1584' AND price > 0
                ORDER BY price ASC LIMIT 1
261 0.0003 0.00029706954956055 
SELECT * FROM productoffers
                WHERE product_id = 1584
                ORDER BY price ASC LIMIT 1
262 0.0003 0.00032806396484375 
SELECT value FROM productattributes
                WHERE product_id = '1584'
                AND name = 'ListPriceAmount'
263 0.0004 0.00036287307739258 
SELECT value FROM productattributes WHERE product_id = '1584' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
264 0.0014 0.0013561248779297 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1448' ORDER BY timestamp DESC
265 0.0003 0.00027203559875488 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1451' ORDER BY timestamp DESC
266 0.0002 0.00024700164794922 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1457' ORDER BY timestamp DESC
267 0.0003 0.00028705596923828 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1474' ORDER BY timestamp DESC
268 0.0002 0.00024795532226562 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1478' ORDER BY timestamp DESC
269 0.0002 0.00023102760314941 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1480' ORDER BY timestamp DESC
270 0.0002 0.00023698806762695 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1490' ORDER BY timestamp DESC
271 0.0003 0.00033187866210938 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1492' ORDER BY timestamp DESC
272 0.0002 0.00024890899658203 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1502' ORDER BY timestamp DESC
273 0.0002 0.00023698806762695 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1507' ORDER BY timestamp DESC
274 0.0002 0.00024604797363281 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1510' ORDER BY timestamp DESC
275 0.0003 0.00027012825012207 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1514' ORDER BY timestamp DESC
276 0.0003 0.00025606155395508 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1522' ORDER BY timestamp DESC
277 0.0002 0.00023102760314941 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1547' ORDER BY timestamp DESC
278 0.0002 0.00023293495178223 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1553' ORDER BY timestamp DESC
279 0.0002 0.00023317337036133 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1573' ORDER BY timestamp DESC
280 0.0002 0.00023198127746582 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1576' ORDER BY timestamp DESC
281 0.0003 0.00026202201843262 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1584' ORDER BY timestamp DESC
282 0.0014 0.0014479160308838 
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
283 0.0012 0.0012218952178955 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
284 0.0003 0.0003049373626709 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
285 0.0126 0.012645959854126 
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
286 0.0017 0.0016739368438721 
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
287 0.0005 0.00051307678222656 
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
288 0.0005 0.00048494338989258 
SELECT * FROM products WHERE id = 1626
289 0.0004 0.00042390823364258 
SELECT * FROM products WHERE id = 4041
290 0.0004 0.00041508674621582 
SELECT * FROM products WHERE id = 4312
291 0.0004 0.00041508674621582 
SELECT * FROM products WHERE id = 777
292 0.0005 0.00046300888061523 
SELECT * FROM products WHERE id = 3881
293 0.0005 0.00049304962158203 
SELECT * FROM products WHERE id = 4213
294 0.0004 0.00043392181396484 
SELECT * FROM products WHERE id = '1626'
295 0.0005 0.00051188468933105 
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
296 0.0006 0.00058603286743164 
SELECT * FROM product_image_select WHERE product_id = '1626'
297 0.0005 0.00047993659973145 
SELECT * FROM productcustomimages WHERE product_id = '1626'
298 0.0008 0.00079607963562012 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
299 0.0005 0.00046491622924805 
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
300 0.0003 0.00034213066101074 
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
301 0.0004 0.00039196014404297 
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
302 0.0009 0.00088286399841309 
SELECT * FROM products WHERE id = '4041'
303 0.0008 0.00084590911865234 
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
304 0.0014 0.0014278888702393 
SELECT * FROM product_image_select WHERE product_id = '4041'
305 0.0006 0.00064206123352051 
SELECT * FROM productcustomimages WHERE product_id = '4041'
306 0.0030 0.0030250549316406 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
307 0.0008 0.00079202651977539 
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
308 0.0004 0.00038909912109375 
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
309 0.0008 0.00084805488586426 
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
310 0.0005 0.00050711631774902 
SELECT * FROM products WHERE id = '4312'
311 0.0005 0.0004878044128418 
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
312 0.0010 0.00098514556884766 
SELECT * FROM product_image_select WHERE product_id = '4312'
313 0.0004 0.00041890144348145 
SELECT * FROM productcustomimages WHERE product_id = '4312'
314 0.0010 0.0010480880737305 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
315 0.0005 0.00048995018005371 
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
316 0.0004 0.00036382675170898 
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
317 0.0004 0.00038599967956543 
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
318 0.0005 0.00050902366638184 
SELECT * FROM products WHERE id = '777'
319 0.0005 0.00047612190246582 
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
320 0.0006 0.00061178207397461 
SELECT * FROM product_image_select WHERE product_id = '777'
321 0.0004 0.00036382675170898 
SELECT * FROM productcustomimages WHERE product_id = '777'
322 0.0011 0.0010612010955811 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
323 0.0005 0.00045394897460938 
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
324 0.0004 0.00041007995605469 
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
325 0.0004 0.00040102005004883 
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
326 0.0005 0.00047492980957031 
SELECT * FROM products WHERE id = '3881'
327 0.0005 0.00049710273742676 
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
328 0.0005 0.00052809715270996 
SELECT * FROM product_image_select WHERE product_id = '3881'
329 0.0004 0.00038695335388184 
SELECT * FROM productcustomimages WHERE product_id = '3881'
330 0.0011 0.0011301040649414 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
331 0.0005 0.00049495697021484 
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
332 0.0003 0.00034713745117188 
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
333 0.0004 0.00043606758117676 
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
334 0.0005 0.00053811073303223 
SELECT * FROM products WHERE id = '4213'
335 0.0005 0.00049686431884766 
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
336 0.0005 0.00051403045654297 
SELECT * FROM product_image_select WHERE product_id = '4213'
337 0.0005 0.00045013427734375 
SELECT * FROM productcustomimages WHERE product_id = '4213'
338 0.0011 0.0010941028594971 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
339 0.0004 0.00041294097900391 
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
340 0.0004 0.00040912628173828 
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
341 0.0004 0.00038909912109375 
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
342 0.0019 0.001924991607666 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
343 0.0006 0.00064706802368164 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
344 0.0022 0.0021800994873047 
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
345 0.0016 0.001554012298584 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
346 0.0005 0.00046586990356445 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
347 0.0005 0.00048089027404785 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
348 0.0005 0.00053286552429199 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'