0
  1. My Store
  2. All Products

All Products

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.8949389457703 391 1.2284 0


No Amazon API Requests Made.


App Debug - Total Time 1.8949389457703 seconds

Number Time From Start Name Description
1 0.44461679458618 Initialise Initialise FSB Function
2 0.44988584518433 App Controller Start Start of the App controller (called before the controller of every page)
3 0.48862290382385 Start of getCategoryListByGroup Function Before first category groups query
4 0.48976993560791 After initial query Before first category groups query
5 0.48976993560791 Get Category List for Group Before the call to getCategoryList function
6 0.48977184295654 Start of GetCategoryList function Start of the function
7 0.48977398872375 Before getting categories Query to get specific category list
8 0.49101686477661 After getting categories Query to get specific category list
9 0.49101686477661 Before getting category custom Before call to function getCategoryCustom
10 0.5110228061676 After getting category custom After call to function getCategoryCustom
11 0.51102995872498 Before getting category custom Before call to function getCategoryCustom
12 0.5216019153595 After getting category custom After call to function getCategoryCustom
13 0.52160286903381 Before getting category custom Before call to function getCategoryCustom
14 0.52760887145996 After getting category custom After call to function getCategoryCustom
15 0.52761101722717 Before getting category custom Before call to function getCategoryCustom
16 0.53158402442932 After getting category custom After call to function getCategoryCustom
17 0.53158593177795 Before getting category custom Before call to function getCategoryCustom
18 0.53533697128296 After getting category custom After call to function getCategoryCustom
19 0.53533887863159 Before getting category custom Before call to function getCategoryCustom
20 0.53959989547729 After getting category custom After call to function getCategoryCustom
21 0.53960084915161 End of GetCategoryList function End of the function
22 0.53960585594177 Get Category List for Group Before the call to getCategoryList function
23 0.53960800170898 Start of GetCategoryList function Start of the function
24 0.53960990905762 Before getting categories Query to get specific category list
25 0.54021382331848 End of getCategoryListByGroup Function Before return()
26 1.3544239997864 App Controller End End of the App controller (called before the controller of every page)
27 1.602264881134 After Getting Product/Bundle Reviews After getting full product/bundle customer review in the All Products Controller
28 1.6042478084564 App_after Controller Start Start of the App_after controller (called after the controller of every page)
29 1.6060960292816 Before Get Options Before the call to getOptions in the tpl class
30 1.6775949001312 After Get Options After the call to getOptions in the tpl class
31 1.677750825882 App_after Controller End End of the App_after controller (called after the controller of every page)
32 1.8949298858643 Finalizing debug Before the debug is output to the page.
33 1.8949389457703 End of App This is the end of the app logging, final timestamp


Query Debug - 391 Database Queries. Total time 1.2284 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0010 0.0009768009185791 
SELECT parameter, value FROM parameters
2 0.0095 0.0094561576843262 
SELECT * FROM `bad_bots`
3 0.0006 0.00056600570678711 
SET time_zone = 'Europe/London'
4 0.0048 0.0048148632049561 
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0042 0.0042409896850586 
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:12:\"3.145.10.222\";}'
6 0.0038 0.0037539005279541 
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1746418891'
7 0.0034 0.0033860206604004 
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0006 0.00060915946960449 
UPDATE autorun SET lastrun = '2025-05-05 04:21:31' WHERE id = '8'
9 0.0008 0.00075101852416992 
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0033 0.0033369064331055 
SELECT id FROM pages WHERE pagename = 'all-products' LIMIT 1
11 0.0006 0.00055789947509766 
SELECT * FROM pages WHERE id = 37
12 0.0050 0.0050308704376221 
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13 0.0328 0.032778024673462 
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14 0.0005 0.00053095817565918 
SELECT * FROM pages WHERE pagename = 'all-products'
15 0.0011 0.0011420249938965 
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0012 0.001230001449585 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0069 0.0069460868835449 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
18 0.0016 0.001600980758667 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
19 0.0011 0.0011129379272461 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20 0.0004 0.00042390823364258 
SELECT id FROM categories WHERE parent_id = '26'
21 0.0054 0.0053670406341553 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
22 0.0015 0.0014548301696777 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0
23 0.0013 0.0013442039489746 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
24 0.0013 0.0012588500976562 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25 0.0004 0.0004279613494873 
SELECT * FROM categorygroups WHERE id = '1'
26 0.0035 0.0035018920898438 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
27 0.0005 0.00047898292541504 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
28 0.0004 0.00037312507629395 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29 0.0004 0.00038814544677734 
SELECT id FROM categories WHERE parent_id = '27'
30 0.0038 0.0038230419158936 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
31 0.0005 0.00046801567077637 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0
32 0.0006 0.00063991546630859 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
33 0.0004 0.00044393539428711 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34 0.0004 0.00040984153747559 
SELECT * FROM categorygroups WHERE id = '1'
35 0.0014 0.001392126083374 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
36 0.0005 0.00054502487182617 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
37 0.0004 0.0003809928894043 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38 0.0005 0.00046300888061523 
SELECT id FROM categories WHERE parent_id = '28'
39 0.0014 0.001410961151123 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
40 0.0005 0.0004730224609375 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0
41 0.0005 0.00047898292541504 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
42 0.0004 0.00041818618774414 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43 0.0004 0.00038814544677734 
SELECT * FROM categorygroups WHERE id = '1'
44 0.0005 0.0005190372467041 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
45 0.0004 0.0003969669342041 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
46 0.0004 0.00035190582275391 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47 0.0004 0.00035786628723145 
SELECT id FROM categories WHERE parent_id = '29'
48 0.0006 0.00058484077453613 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
49 0.0005 0.00046300888061523 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0
50 0.0005 0.0004580020904541 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
51 0.0004 0.00042891502380371 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52 0.0003 0.00033807754516602 
SELECT * FROM categorygroups WHERE id = '1'
53 0.0005 0.00047516822814941 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
54 0.0004 0.00037288665771484 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
55 0.0003 0.00031304359436035 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56 0.0004 0.00035500526428223 
SELECT id FROM categories WHERE parent_id = '30'
57 0.0005 0.00054192543029785 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
58 0.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 (30)
				  AND p.disabled = 0
59 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
60 0.0004 0.00041294097900391 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61 0.0003 0.00034189224243164 
SELECT * FROM categorygroups WHERE id = '1'
62 0.0005 0.00053715705871582 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
63 0.0004 0.00038003921508789 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
64 0.0003 0.00032901763916016 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65 0.0004 0.00036787986755371 
SELECT id FROM categories WHERE parent_id = '31'
66 0.0006 0.00060391426086426 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
67 0.0004 0.00043916702270508 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0
68 0.0006 0.0005650520324707 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
69 0.0005 0.00050091743469238 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70 0.0005 0.00046491622924805 
SELECT * FROM categorygroups WHERE id = '1'
71 0.0006 0.00059700012207031 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
72 0.0025 0.0024659633636475 
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73 0.0014 0.0014240741729736 
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74 0.0006 0.00057411193847656 
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
75 0.0011 0.0011281967163086 
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76 0.0011 0.0011420249938965 
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77 0.0008 0.00080585479736328 
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78 0.8017 0.80173802375793 
SELECT * FROM ipgeocountries WHERE INET_ATON('3.145.10.222') >= INET_ATON(ip_start) AND INET_ATON('3.145.10.222') <= INET_ATON(ip_end)
79 0.0019 0.0019350051879883 
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80 0.0012 0.001215934753418 
SELECT * FROM countryredirects WHERE countrycode = 'US'
81 0.0011 0.0010831356048584 
SELECT * FROM pages WHERE pagename = 'all-products'
82 0.0202 0.020176887512207 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
83 0.0050 0.0049879550933838 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
84 0.0036 0.0036439895629883 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
85 0.0102 0.010213136672974 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
86 0.0023 0.0023031234741211 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
87 0.0006 0.00064992904663086 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
88 0.0070 0.0069680213928223 
SELECT COUNT(*) FROM products p WHERE parent_id = 0 AND hidden = 0 AND enabled = 1  AND 1 = 1
89 0.0074 0.0073590278625488 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
90 0.0020 0.0020451545715332 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
91 0.0006 0.00060606002807617 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
92 0.0086 0.0085861682891846 
SELECT p.* FROM products p WHERE hidden = 0 AND enabled = 1 AND parent_id = 0 AND 1 = 1 ORDER BY salesrank ASC  LIMIT 936, 18
93 0.0022 0.0021629333496094 
SELECT * FROM productimages WHERE product_id = '2420' ORDER BY sortorder ASC
94 0.0020 0.0019590854644775 
SELECT * FROM product_image_select WHERE product_id = '2420'
95 0.0016 0.0016348361968994 
SELECT * FROM productcustomimages WHERE product_id = '2420'
96 0.0027 0.0026760101318359 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2420' AND a.name = n.originalname
97 0.0019 0.0018789768218994 
SELECT * FROM productoffers WHERE product_id = '2420' AND merchantid = 'A1X6FK5RDHNB96'
98 0.0005 0.00049495697021484 
SELECT * FROM productoffers
                WHERE product_id = '2420' AND price > 0
                ORDER BY price ASC LIMIT 1
99 0.0004 0.00044798851013184 
SELECT * FROM productoffers
                WHERE product_id = 2420
                ORDER BY price ASC LIMIT 1
100 0.0006 0.000640869140625 
SELECT value FROM productattributes
                WHERE product_id = '2420'
                AND name = 'ListPriceAmount'
101 0.0007 0.00066614151000977 
SELECT value FROM productattributes WHERE product_id = '2420' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
102 0.0006 0.00064182281494141 
SELECT * FROM productimages WHERE product_id = '2421' ORDER BY sortorder ASC
103 0.0008 0.00075197219848633 
SELECT * FROM product_image_select WHERE product_id = '2421'
104 0.0005 0.00053691864013672 
SELECT * FROM productcustomimages WHERE product_id = '2421'
105 0.0022 0.0021500587463379 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2421' AND a.name = n.originalname
106 0.0010 0.00099301338195801 
SELECT * FROM productoffers WHERE product_id = '2421' AND merchantid = 'A1X6FK5RDHNB96'
107 0.0007 0.00066995620727539 
SELECT * FROM productoffers
                WHERE product_id = '2421' AND price > 0
                ORDER BY price ASC LIMIT 1
108 0.0006 0.00062704086303711 
SELECT * FROM productoffers
                WHERE product_id = 2421
                ORDER BY price ASC LIMIT 1
109 0.0008 0.00078105926513672 
SELECT value FROM productattributes
                WHERE product_id = '2421'
                AND name = 'ListPriceAmount'
110 0.0009 0.00091385841369629 
SELECT value FROM productattributes WHERE product_id = '2421' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
111 0.0009 0.0009000301361084 
SELECT * FROM productimages WHERE product_id = '2422' ORDER BY sortorder ASC
112 0.0010 0.0010409355163574 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2422' AND p.id = pi.product_id ORDER BY pi.sortorder
113 0.0015 0.0014579296112061 
SELECT * FROM product_image_select WHERE product_id = '2422'
114 0.0007 0.00067400932312012 
SELECT * FROM productcustomimages WHERE product_id = '2422'
115 0.0012 0.0011720657348633 
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 = '2422'
                GROUP BY o.product_id
116 0.0057 0.0057499408721924 
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     = '2422'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
117 0.0008 0.00081801414489746 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2422
118 0.0014 0.0013711452484131 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2422' AND a.name = n.originalname
119 0.0005 0.00048494338989258 
SELECT * FROM productoffers WHERE product_id = '2422' AND merchantid = 'A1X6FK5RDHNB96'
120 0.0005 0.00048398971557617 
SELECT * FROM productoffers
                WHERE product_id = '2422' AND price > 0
                ORDER BY price ASC LIMIT 1
121 0.0004 0.00043702125549316 
SELECT * FROM productoffers
                WHERE product_id = 2422
                ORDER BY price ASC LIMIT 1
122 0.0005 0.00052094459533691 
SELECT value FROM productattributes
                WHERE product_id = '2422'
                AND name = 'ListPriceAmount'
123 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 = '2422'
                GROUP BY o.product_id
124 0.0011 0.0011420249938965 
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     = '2422'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
125 0.0007 0.00065088272094727 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2422
126 0.0008 0.00078797340393066 
SELECT value FROM productattributes WHERE product_id = '2422' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
127 0.0008 0.00077104568481445 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '2422'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
128 0.0005 0.00050592422485352 
SELECT * FROM productimages WHERE product_id = '2425' ORDER BY sortorder ASC
129 0.0005 0.00046610832214355 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2425' AND p.id = pi.product_id ORDER BY pi.sortorder
130 0.0008 0.00075483322143555 
SELECT * FROM product_image_select WHERE product_id = '2425'
131 0.0005 0.00049090385437012 
SELECT * FROM productcustomimages WHERE product_id = '2425'
132 0.0006 0.00060796737670898 
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 = '2425'
                GROUP BY o.product_id
133 0.0007 0.00070309638977051 
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     = '2425'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
134 0.0004 0.00042819976806641 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2425
135 0.0009 0.00094103813171387 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2425' AND a.name = n.originalname
136 0.0004 0.00039100646972656 
SELECT * FROM productoffers WHERE product_id = '2425' AND merchantid = 'A1X6FK5RDHNB96'
137 0.0004 0.00037097930908203 
SELECT * FROM productoffers
                WHERE product_id = '2425' AND price > 0
                ORDER BY price ASC LIMIT 1
138 0.0003 0.00034999847412109 
SELECT * FROM productoffers
                WHERE product_id = 2425
                ORDER BY price ASC LIMIT 1
139 0.0004 0.0003809928894043 
SELECT value FROM productattributes
                WHERE product_id = '2425'
                AND name = 'ListPriceAmount'
140 0.0005 0.00046801567077637 
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 = '2425'
                GROUP BY o.product_id
141 0.0007 0.00071215629577637 
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     = '2425'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
142 0.0004 0.00043797492980957 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2425
143 0.0007 0.00065398216247559 
SELECT value FROM productattributes WHERE product_id = '2425' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
144 0.0007 0.00071191787719727 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '2425'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
145 0.0005 0.00048589706420898 
SELECT * FROM productimages WHERE product_id = '2428' ORDER BY sortorder ASC
146 0.0005 0.00046205520629883 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2428' AND p.id = pi.product_id ORDER BY pi.sortorder
147 0.0006 0.0006260871887207 
SELECT * FROM product_image_select WHERE product_id = '2428'
148 0.0004 0.00043010711669922 
SELECT * FROM productcustomimages WHERE product_id = '2428'
149 0.0006 0.00060009956359863 
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 = '2428'
                GROUP BY o.product_id
150 0.0007 0.00070095062255859 
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     = '2428'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
151 0.0004 0.00043606758117676 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2428
152 0.0008 0.00078487396240234 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2428' AND a.name = n.originalname
153 0.0004 0.00035595893859863 
SELECT * FROM productoffers WHERE product_id = '2428' AND merchantid = 'A1X6FK5RDHNB96'
154 0.0004 0.00035405158996582 
SELECT * FROM productoffers
                WHERE product_id = '2428' AND price > 0
                ORDER BY price ASC LIMIT 1
155 0.0003 0.00034689903259277 
SELECT * FROM productoffers
                WHERE product_id = 2428
                ORDER BY price ASC LIMIT 1
156 0.0003 0.00034904479980469 
SELECT value FROM productattributes
                WHERE product_id = '2428'
                AND name = 'ListPriceAmount'
157 0.0004 0.0004119873046875 
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 = '2428'
                GROUP BY o.product_id
158 0.0006 0.00059914588928223 
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     = '2428'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
159 0.0004 0.00039386749267578 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2428
160 0.0006 0.00061297416687012 
SELECT value FROM productattributes WHERE product_id = '2428' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
161 0.0006 0.00059294700622559 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '2428'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
162 0.0004 0.00043201446533203 
SELECT * FROM productimages WHERE product_id = '2431' ORDER BY sortorder ASC
163 0.0004 0.00044918060302734 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2431' AND p.id = pi.product_id ORDER BY pi.sortorder
164 0.0006 0.00057506561279297 
SELECT * FROM product_image_select WHERE product_id = '2431'
165 0.0004 0.00040698051452637 
SELECT * FROM productcustomimages WHERE product_id = '2431'
166 0.0005 0.00051593780517578 
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 = '2431'
                GROUP BY o.product_id
167 0.0006 0.00064396858215332 
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     = '2431'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
168 0.0005 0.00046300888061523 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2431
169 0.0008 0.00083279609680176 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2431' AND a.name = n.originalname
170 0.0004 0.00041484832763672 
SELECT * FROM productoffers WHERE product_id = '2431' AND merchantid = 'A1X6FK5RDHNB96'
171 0.0004 0.00044417381286621 
SELECT * FROM productoffers
                WHERE product_id = '2431' AND price > 0
                ORDER BY price ASC LIMIT 1
172 0.0003 0.00031781196594238 
SELECT * FROM productoffers
                WHERE product_id = 2431
                ORDER BY price ASC LIMIT 1
173 0.0004 0.00037693977355957 
SELECT value FROM productattributes
                WHERE product_id = '2431'
                AND name = 'ListPriceAmount'
174 0.0005 0.00051593780517578 
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 = '2431'
                GROUP BY o.product_id
175 0.0007 0.0006711483001709 
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     = '2431'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
176 0.0004 0.00043010711669922 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2431
177 0.0005 0.00054097175598145 
SELECT value FROM productattributes WHERE product_id = '2431' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
178 0.0006 0.00058698654174805 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '2431'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
179 0.0005 0.00048398971557617 
SELECT * FROM productimages WHERE product_id = '2434' ORDER BY sortorder ASC
180 0.0005 0.0004889965057373 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2434' AND p.id = pi.product_id ORDER BY pi.sortorder
181 0.0006 0.00064992904663086 
SELECT * FROM product_image_select WHERE product_id = '2434'
182 0.0005 0.00051689147949219 
SELECT * FROM productcustomimages WHERE product_id = '2434'
183 0.0006 0.00064182281494141 
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 = '2434'
                GROUP BY o.product_id
184 0.0006 0.00064802169799805 
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     = '2434'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
185 0.0004 0.0004429817199707 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2434
186 0.0009 0.00089812278747559 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2434' AND a.name = n.originalname
187 0.0005 0.00049686431884766 
SELECT * FROM productoffers WHERE product_id = '2434' AND merchantid = 'A1X6FK5RDHNB96'
188 0.0004 0.00040388107299805 
SELECT * FROM productoffers
                WHERE product_id = '2434' AND price > 0
                ORDER BY price ASC LIMIT 1
189 0.0005 0.00048995018005371 
SELECT * FROM productoffers
                WHERE product_id = 2434
                ORDER BY price ASC LIMIT 1
190 0.0005 0.00054311752319336 
SELECT value FROM productattributes
                WHERE product_id = '2434'
                AND name = 'ListPriceAmount'
191 0.0005 0.00048184394836426 
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 = '2434'
                GROUP BY o.product_id
192 0.0008 0.00075078010559082 
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     = '2434'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
193 0.0005 0.00045490264892578 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2434
194 0.0007 0.00068402290344238 
SELECT value FROM productattributes WHERE product_id = '2434' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
195 0.0007 0.00068879127502441 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '2434'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
196 0.0008 0.00082993507385254 
SELECT * FROM productimages WHERE product_id = '4908' ORDER BY sortorder ASC
197 0.0006 0.00061798095703125 
SELECT * FROM product_image_select WHERE product_id = '4908'
198 0.0005 0.00050902366638184 
SELECT * FROM productcustomimages WHERE product_id = '4908'
199 0.0012 0.0011560916900635 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4908' AND a.name = n.originalname
200 0.0005 0.00046801567077637 
SELECT * FROM productoffers WHERE product_id = '4908' AND merchantid = 'A1X6FK5RDHNB96'
201 0.0004 0.0003960132598877 
SELECT * FROM productoffers
                WHERE product_id = '4908' AND price > 0
                ORDER BY price ASC LIMIT 1
202 0.0003 0.00034093856811523 
SELECT * FROM productoffers
                WHERE product_id = 4908
                ORDER BY price ASC LIMIT 1
203 0.0004 0.0003819465637207 
SELECT value FROM productattributes
                WHERE product_id = '4908'
                AND name = 'ListPriceAmount'
204 0.0004 0.00044488906860352 
SELECT value FROM productattributes WHERE product_id = '4908' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
205 0.0005 0.00054597854614258 
SELECT * FROM productimages WHERE product_id = '2442' ORDER BY sortorder ASC
206 0.0007 0.00071501731872559 
SELECT * FROM product_image_select WHERE product_id = '2442'
207 0.0005 0.00045895576477051 
SELECT * FROM productcustomimages WHERE product_id = '2442'
208 0.0008 0.00082182884216309 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2442' AND a.name = n.originalname
209 0.0005 0.00051116943359375 
SELECT * FROM productoffers WHERE product_id = '2442' AND merchantid = 'A1X6FK5RDHNB96'
210 0.0005 0.00045895576477051 
SELECT * FROM productoffers
                WHERE product_id = '2442' AND price > 0
                ORDER BY price ASC LIMIT 1
211 0.0004 0.00036001205444336 
SELECT * FROM productoffers
                WHERE product_id = 2442
                ORDER BY price ASC LIMIT 1
212 0.0004 0.00043416023254395 
SELECT value FROM productattributes
                WHERE product_id = '2442'
                AND name = 'ListPriceAmount'
213 0.0005 0.00049996376037598 
SELECT value FROM productattributes WHERE product_id = '2442' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
214 0.0006 0.00057291984558105 
SELECT * FROM productimages WHERE product_id = '2447' ORDER BY sortorder ASC
215 0.0007 0.00070095062255859 
SELECT * FROM product_image_select WHERE product_id = '2447'
216 0.0005 0.00046205520629883 
SELECT * FROM productcustomimages WHERE product_id = '2447'
217 0.0008 0.00084090232849121 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2447' AND a.name = n.originalname
218 0.0005 0.00048112869262695 
SELECT * FROM productoffers WHERE product_id = '2447' AND merchantid = 'A1X6FK5RDHNB96'
219 0.0004 0.00037407875061035 
SELECT * FROM productoffers
                WHERE product_id = '2447' AND price > 0
                ORDER BY price ASC LIMIT 1
220 0.0005 0.00047087669372559 
SELECT * FROM productoffers
                WHERE product_id = 2447
                ORDER BY price ASC LIMIT 1
221 0.0005 0.00047111511230469 
SELECT value FROM productattributes
                WHERE product_id = '2447'
                AND name = 'ListPriceAmount'
222 0.0007 0.00065708160400391 
SELECT value FROM productattributes WHERE product_id = '2447' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
223 0.0006 0.00057792663574219 
SELECT * FROM productimages WHERE product_id = '2776' ORDER BY sortorder ASC
224 0.0007 0.0007319450378418 
SELECT * FROM product_image_select WHERE product_id = '2776'
225 0.0004 0.00041699409484863 
SELECT * FROM productcustomimages WHERE product_id = '2776'
226 0.0012 0.0011849403381348 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2776' AND a.name = n.originalname
227 0.0011 0.0011038780212402 
SELECT * FROM productoffers WHERE product_id = '2776' AND merchantid = 'A1X6FK5RDHNB96'
228 0.0009 0.00090479850769043 
SELECT * FROM productoffers
                WHERE product_id = '2776' AND price > 0
                ORDER BY price ASC LIMIT 1
229 0.0006 0.00058698654174805 
SELECT * FROM productoffers
                WHERE product_id = 2776
                ORDER BY price ASC LIMIT 1
230 0.0007 0.00067996978759766 
SELECT value FROM productattributes
                WHERE product_id = '2776'
                AND name = 'ListPriceAmount'
231 0.0008 0.00080513954162598 
SELECT value FROM productattributes WHERE product_id = '2776' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
232 0.0009 0.00094079971313477 
SELECT * FROM productimages WHERE product_id = '2460' ORDER BY sortorder ASC
233 0.0012 0.0012390613555908 
SELECT * FROM product_image_select WHERE product_id = '2460'
234 0.0008 0.00079917907714844 
SELECT * FROM productcustomimages WHERE product_id = '2460'
235 0.0020 0.0019950866699219 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2460' AND a.name = n.originalname
236 0.0008 0.00083422660827637 
SELECT * FROM productoffers WHERE product_id = '2460' AND merchantid = 'A1X6FK5RDHNB96'
237 0.0009 0.00087881088256836 
SELECT * FROM productoffers
                WHERE product_id = '2460' AND price > 0
                ORDER BY price ASC LIMIT 1
238 0.0008 0.00079894065856934 
SELECT * FROM productoffers
                WHERE product_id = 2460
                ORDER BY price ASC LIMIT 1
239 0.0007 0.00072908401489258 
SELECT value FROM productattributes
                WHERE product_id = '2460'
                AND name = 'ListPriceAmount'
240 0.0008 0.00079107284545898 
SELECT value FROM productattributes WHERE product_id = '2460' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
241 0.0008 0.00080490112304688 
SELECT * FROM productimages WHERE product_id = '2461' ORDER BY sortorder ASC
242 0.0020 0.0020208358764648 
SELECT * FROM product_image_select WHERE product_id = '2461'
243 0.0009 0.00086784362792969 
SELECT * FROM productcustomimages WHERE product_id = '2461'
244 0.0017 0.0016860961914062 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2461' AND a.name = n.originalname
245 0.0009 0.00094795227050781 
SELECT * FROM productoffers WHERE product_id = '2461' AND merchantid = 'A1X6FK5RDHNB96'
246 0.0007 0.00065183639526367 
SELECT * FROM productoffers
                WHERE product_id = '2461' AND price > 0
                ORDER BY price ASC LIMIT 1
247 0.0006 0.00059103965759277 
SELECT * FROM productoffers
                WHERE product_id = 2461
                ORDER BY price ASC LIMIT 1
248 0.0007 0.00074005126953125 
SELECT value FROM productattributes
                WHERE product_id = '2461'
                AND name = 'ListPriceAmount'
249 0.0008 0.00078487396240234 
SELECT value FROM productattributes WHERE product_id = '2461' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
250 0.0010 0.00095796585083008 
SELECT * FROM productimages WHERE product_id = '2565' ORDER BY sortorder ASC
251 0.0013 0.0012891292572021 
SELECT * FROM product_image_select WHERE product_id = '2565'
252 0.0007 0.00065803527832031 
SELECT * FROM productcustomimages WHERE product_id = '2565'
253 0.0020 0.0020051002502441 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2565' AND a.name = n.originalname
254 0.0010 0.00095987319946289 
SELECT * FROM productoffers WHERE product_id = '2565' AND merchantid = 'A1X6FK5RDHNB96'
255 0.0007 0.00071096420288086 
SELECT * FROM productoffers
                WHERE product_id = '2565' AND price > 0
                ORDER BY price ASC LIMIT 1
256 0.0008 0.00078487396240234 
SELECT value FROM productattributes WHERE product_id = '2565' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
257 0.0009 0.00090217590332031 
SELECT * FROM productimages WHERE product_id = '2490' ORDER BY sortorder ASC
258 0.0012 0.0011990070343018 
SELECT * FROM product_image_select WHERE product_id = '2490'
259 0.0007 0.00073814392089844 
SELECT * FROM productcustomimages WHERE product_id = '2490'
260 0.0015 0.0015051364898682 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2490' AND a.name = n.originalname
261 0.0006 0.00063800811767578 
SELECT * FROM productoffers WHERE product_id = '2490' AND merchantid = 'A1X6FK5RDHNB96'
262 0.0006 0.00055909156799316 
SELECT * FROM productoffers
                WHERE product_id = '2490' AND price > 0
                ORDER BY price ASC LIMIT 1
263 0.0005 0.00048995018005371 
SELECT * FROM productoffers
                WHERE product_id = 2490
                ORDER BY price ASC LIMIT 1
264 0.0006 0.00058698654174805 
SELECT value FROM productattributes
                WHERE product_id = '2490'
                AND name = 'ListPriceAmount'
265 0.0006 0.00056600570678711 
SELECT value FROM productattributes WHERE product_id = '2490' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
266 0.0007 0.00072193145751953 
SELECT * FROM productimages WHERE product_id = '3234' ORDER BY sortorder ASC
267 0.0011 0.001068115234375 
SELECT * FROM product_image_select WHERE product_id = '3234'
268 0.0006 0.00057196617126465 
SELECT * FROM productcustomimages WHERE product_id = '3234'
269 0.0015 0.0015192031860352 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3234' AND a.name = n.originalname
270 0.0006 0.00064897537231445 
SELECT * FROM productoffers WHERE product_id = '3234' AND merchantid = 'A1X6FK5RDHNB96'
271 0.0005 0.00048208236694336 
SELECT * FROM productoffers
                WHERE product_id = '3234' AND price > 0
                ORDER BY price ASC LIMIT 1
272 0.0004 0.00044989585876465 
SELECT * FROM productoffers
                WHERE product_id = 3234
                ORDER BY price ASC LIMIT 1
273 0.0006 0.00058102607727051 
SELECT value FROM productattributes
                WHERE product_id = '3234'
                AND name = 'ListPriceAmount'
274 0.0006 0.0005640983581543 
SELECT value FROM productattributes WHERE product_id = '3234' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
275 0.0007 0.00073885917663574 
SELECT * FROM productimages WHERE product_id = '2637' ORDER BY sortorder ASC
276 0.0009 0.00087213516235352 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2637' AND p.id = pi.product_id ORDER BY pi.sortorder
277 0.0008 0.00078296661376953 
SELECT * FROM product_image_select WHERE product_id = '2637'
278 0.0005 0.00048494338989258 
SELECT * FROM productcustomimages WHERE product_id = '2637'
279 0.0006 0.00064301490783691 
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 = '2637'
                GROUP BY o.product_id
280 0.0008 0.00080704689025879 
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     = '2637'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
281 0.0006 0.00057101249694824 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2637
282 0.0016 0.0016121864318848 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2637' AND a.name = n.originalname
283 0.0004 0.0004122257232666 
SELECT * FROM productoffers WHERE product_id = '2637' AND merchantid = 'A1X6FK5RDHNB96'
284 0.0005 0.00048303604125977 
SELECT * FROM productoffers
                WHERE product_id = '2637' AND price > 0
                ORDER BY price ASC LIMIT 1
285 0.0004 0.00044488906860352 
SELECT * FROM productoffers
                WHERE product_id = 2637
                ORDER BY price ASC LIMIT 1
286 0.0005 0.00048518180847168 
SELECT value FROM productattributes
                WHERE product_id = '2637'
                AND name = 'ListPriceAmount'
287 0.0006 0.0005648136138916 
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 = '2637'
                GROUP BY o.product_id
288 0.0008 0.00078082084655762 
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     = '2637'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
289 0.0004 0.00042891502380371 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2637
290 0.0006 0.00061202049255371 
SELECT value FROM productattributes WHERE product_id = '2637' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
291 0.0008 0.00079107284545898 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '2637'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'PackageQuantity'
                GROUP BY o.value
                ORDER BY o.value ASC
292 0.0004 0.00043892860412598 
SELECT * FROM products WHERE parent_id = '2637'
293 0.0006 0.00064206123352051 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2638' AND a.name = n.originalname
294 0.0005 0.00050497055053711 
SELECT * FROM productoffers WHERE product_id = '2638' AND merchantid = 'A1X6FK5RDHNB96'
295 0.0007 0.00067615509033203 
SELECT * FROM productoffers
                WHERE product_id = '2638' AND price > 0
                ORDER BY price ASC LIMIT 1
296 0.0004 0.00038695335388184 
SELECT * FROM productoffers
                WHERE product_id = 2638
                ORDER BY price ASC LIMIT 1
297 0.0005 0.00049901008605957 
SELECT value FROM productattributes
                WHERE product_id = '2638'
                AND name = 'ListPriceAmount'
298 0.0007 0.00069689750671387 
SELECT * FROM productimages WHERE product_id = '2687' ORDER BY sortorder ASC
299 0.0008 0.00080108642578125 
SELECT * FROM product_image_select WHERE product_id = '2687'
300 0.0004 0.0004429817199707 
SELECT * FROM productcustomimages WHERE product_id = '2687'
301 0.0014 0.0013599395751953 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2687' AND a.name = n.originalname
302 0.0005 0.0005190372467041 
SELECT * FROM productoffers WHERE product_id = '2687' AND merchantid = 'A1X6FK5RDHNB96'
303 0.0004 0.00041508674621582 
SELECT * FROM productoffers
                WHERE product_id = '2687' AND price > 0
                ORDER BY price ASC LIMIT 1
304 0.0004 0.0004270076751709 
SELECT * FROM productoffers
                WHERE product_id = 2687
                ORDER BY price ASC LIMIT 1
305 0.0005 0.00050806999206543 
SELECT value FROM productattributes
                WHERE product_id = '2687'
                AND name = 'ListPriceAmount'
306 0.0006 0.00058889389038086 
SELECT value FROM productattributes WHERE product_id = '2687' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
307 0.0016 0.0015900135040283 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2420' ORDER BY timestamp DESC
308 0.0004 0.00037789344787598 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2421' ORDER BY timestamp DESC
309 0.0003 0.00032997131347656 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2422' ORDER BY timestamp DESC
310 0.0003 0.00029897689819336 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2425' ORDER BY timestamp DESC
311 0.0003 0.00033307075500488 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2428' ORDER BY timestamp DESC
312 0.0003 0.00033998489379883 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2431' ORDER BY timestamp DESC
313 0.0003 0.00030803680419922 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2434' ORDER BY timestamp DESC
314 0.0003 0.00033402442932129 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4908' ORDER BY timestamp DESC
315 0.0003 0.00031900405883789 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2442' ORDER BY timestamp DESC
316 0.0003 0.00031685829162598 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2447' ORDER BY timestamp DESC
317 0.0004 0.00039505958557129 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2776' ORDER BY timestamp DESC
318 0.0004 0.0003669261932373 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2460' ORDER BY timestamp DESC
319 0.0004 0.00036501884460449 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2461' ORDER BY timestamp DESC
320 0.0003 0.00030303001403809 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2565' ORDER BY timestamp DESC
321 0.0003 0.0003211498260498 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2490' ORDER BY timestamp DESC
322 0.0003 0.00031614303588867 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3234' ORDER BY timestamp DESC
323 0.0004 0.00037598609924316 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2637' ORDER BY timestamp DESC
324 0.0003 0.00034999847412109 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2687' ORDER BY timestamp DESC
325 0.0015 0.0015010833740234 
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
326 0.0014 0.0013790130615234 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
327 0.0004 0.00042819976806641 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
328 0.0152 0.015159130096436 
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
329 0.0016 0.001594066619873 
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
330 0.0005 0.00049495697021484 
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
331 0.0005 0.00046110153198242 
SELECT * FROM products WHERE id = 1626
332 0.0004 0.00036311149597168 
SELECT * FROM products WHERE id = 4041
333 0.0003 0.00034689903259277 
SELECT * FROM products WHERE id = 4312
334 0.0003 0.00032806396484375 
SELECT * FROM products WHERE id = 777
335 0.0003 0.00033879280090332 
SELECT * FROM products WHERE id = 3881
336 0.0003 0.0003359317779541 
SELECT * FROM products WHERE id = 4213
337 0.0004 0.00042605400085449 
SELECT * FROM products WHERE id = '1626'
338 0.0004 0.00044393539428711 
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
339 0.0005 0.00054097175598145 
SELECT * FROM product_image_select WHERE product_id = '1626'
340 0.0004 0.00038790702819824 
SELECT * FROM productcustomimages WHERE product_id = '1626'
341 0.0008 0.00076603889465332 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
342 0.0005 0.00048184394836426 
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
343 0.0004 0.00037217140197754 
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
344 0.0004 0.00042104721069336 
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
345 0.0005 0.00052595138549805 
SELECT * FROM products WHERE id = '4041'
346 0.0005 0.00047111511230469 
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
347 0.0006 0.00057005882263184 
SELECT * FROM product_image_select WHERE product_id = '4041'
348 0.0004 0.00038313865661621 
SELECT * FROM productcustomimages WHERE product_id = '4041'
349 0.0012 0.0011658668518066 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
350 0.0004 0.0004279613494873 
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
351 0.0004 0.0003969669342041 
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
352 0.0005 0.00048112869262695 
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
353 0.0005 0.00049805641174316 
SELECT * FROM products WHERE id = '4312'
354 0.0004 0.00044012069702148 
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
355 0.0006 0.00056004524230957 
SELECT * FROM product_image_select WHERE product_id = '4312'
356 0.0004 0.00035595893859863 
SELECT * FROM productcustomimages WHERE product_id = '4312'
357 0.0010 0.0009760856628418 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
358 0.0005 0.00051498413085938 
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
359 0.0005 0.0004730224609375 
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
360 0.0005 0.00050997734069824 
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
361 0.0006 0.00060796737670898 
SELECT * FROM products WHERE id = '777'
362 0.0005 0.00052118301391602 
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
363 0.0005 0.00054812431335449 
SELECT * FROM product_image_select WHERE product_id = '777'
364 0.0004 0.00040793418884277 
SELECT * FROM productcustomimages WHERE product_id = '777'
365 0.0013 0.0013048648834229 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
366 0.0005 0.00054311752319336 
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
367 0.0005 0.0004880428314209 
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
368 0.0005 0.00052499771118164 
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
369 0.0006 0.00057196617126465 
SELECT * FROM products WHERE id = '3881'
370 0.0006 0.00059390068054199 
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
371 0.0006 0.00063896179199219 
SELECT * FROM product_image_select WHERE product_id = '3881'
372 0.0004 0.00044798851013184 
SELECT * FROM productcustomimages WHERE product_id = '3881'
373 0.0016 0.0015511512756348 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
374 0.0004 0.00044989585876465 
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
375 0.0004 0.00043416023254395 
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
376 0.0005 0.00051093101501465 
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
377 0.0006 0.00056099891662598 
SELECT * FROM products WHERE id = '4213'
378 0.0006 0.00055789947509766 
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
379 0.0007 0.00067996978759766 
SELECT * FROM product_image_select WHERE product_id = '4213'
380 0.0004 0.0004270076751709 
SELECT * FROM productcustomimages WHERE product_id = '4213'
381 0.0010 0.0010290145874023 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
382 0.0004 0.00038599967956543 
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
383 0.0003 0.00031089782714844 
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
384 0.0004 0.00041103363037109 
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
385 0.0017 0.0016851425170898 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
386 0.0007 0.00066900253295898 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
387 0.0030 0.0030090808868408 
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
388 0.0024 0.002424955368042 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
389 0.0007 0.00067710876464844 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
390 0.0009 0.00089907646179199 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
391 0.0012 0.0012199878692627 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'