0

All Products

Wait! We have a something for you...

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

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

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.5358529090881 334 1.0932 0


No Amazon API Requests Made.


App Debug - Total Time 1.5358529090881 seconds

Number Time From Start Name Description
1 0.35751295089722 Initialise Initialise FSB Function
2 0.36013388633728 App Controller Start Start of the App controller (called before the controller of every page)
3 0.39906787872314 Start of getCategoryListByGroup Function Before first category groups query
4 0.39965391159058 After initial query Before first category groups query
5 0.39965486526489 Get Category List for Group Before the call to getCategoryList function
6 0.3996570110321 Start of GetCategoryList function Start of the function
7 0.39965891838074 Before getting categories Query to get specific category list
8 0.40041899681091 After getting categories Query to get specific category list
9 0.40041995048523 Before getting category custom Before call to function getCategoryCustom
10 0.41796684265137 After getting category custom After call to function getCategoryCustom
11 0.41796803474426 Before getting category custom Before call to function getCategoryCustom
12 0.43180394172668 After getting category custom After call to function getCategoryCustom
13 0.43180584907532 Before getting category custom Before call to function getCategoryCustom
14 0.43950295448303 After getting category custom After call to function getCategoryCustom
15 0.43950390815735 Before getting category custom Before call to function getCategoryCustom
16 0.4443998336792 After getting category custom After call to function getCategoryCustom
17 0.44440197944641 Before getting category custom Before call to function getCategoryCustom
18 0.44944000244141 After getting category custom After call to function getCategoryCustom
19 0.44944190979004 Before getting category custom Before call to function getCategoryCustom
20 0.45413494110107 After getting category custom After call to function getCategoryCustom
21 0.45413589477539 End of GetCategoryList function End of the function
22 0.45413994789124 Get Category List for Group Before the call to getCategoryList function
23 0.45414090156555 Start of GetCategoryList function Start of the function
24 0.45414185523987 Before getting categories Query to get specific category list
25 0.45473790168762 End of getCategoryListByGroup Function Before return()
26 1.2290048599243 App Controller End End of the App controller (called before the controller of every page)
27 1.4311380386353 After Getting Product/Bundle Reviews After getting full product/bundle customer review in the All Products Controller
28 1.4320108890533 App_after Controller Start Start of the App_after controller (called after the controller of every page)
29 1.4327540397644 Before Get Options Before the call to getOptions in the tpl class
30 1.4765539169312 After Get Options After the call to getOptions in the tpl class
31 1.4766659736633 App_after Controller End End of the App_after controller (called after the controller of every page)
32 1.5358438491821 Finalizing debug Before the debug is output to the page.
33 1.5358519554138 End of App This is the end of the app logging, final timestamp


Query Debug - 334 Database Queries. Total time 1.0932 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0010 0.0010149478912354
SELECT parameter, value FROM parameters
2 0.0038 0.0038461685180664
SELECT * FROM `bad_bots`
3 0.0004 0.00044989585876465
SET time_zone = 'Europe/London'
4 0.0010 0.0009911060333252
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0008 0.00082612037658691
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:11:\"3.142.156.4\";}'
6 0.0007 0.0007469654083252
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1743685731'
7 0.0011 0.0010871887207031
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0005 0.00054383277893066
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0011 0.0010950565338135
SELECT id FROM pages WHERE pagename = 'all-products' LIMIT 1
10 0.0006 0.00060701370239258
SELECT * FROM pages WHERE id = 37
11 0.0042 0.0042009353637695
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0340 0.034030914306641
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0004 0.00040292739868164
SELECT * FROM pages WHERE pagename = 'all-products'
14 0.0006 0.00058197975158691
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0008 0.00075006484985352
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0066 0.0065639019012451
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
17 0.0006 0.00060892105102539
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
18 0.0005 0.00050497055053711
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0005 0.00047802925109863
SELECT id FROM categories WHERE parent_id = '26'
20 0.0072 0.0072128772735596
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 
21 0.0006 0.00061297416687012
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 
22 0.0006 0.00064897537231445
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
23 0.0005 0.00046801567077637
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0004 0.00040006637573242
SELECT * FROM categorygroups WHERE id = '1'
25 0.0043 0.0043148994445801
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
26 0.0005 0.00049400329589844
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
27 0.0009 0.00085592269897461
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0005 0.00050997734069824
SELECT id FROM categories WHERE parent_id = '27'
29 0.0055 0.005479097366333
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 
30 0.0006 0.00059103965759277
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 
31 0.0006 0.00060892105102539
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
32 0.0005 0.00054311752319336
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0004 0.00040006637573242
SELECT * FROM categorygroups WHERE id = '1'
34 0.0025 0.002518892288208
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
35 0.0008 0.00075793266296387
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
36 0.0004 0.00038790702819824
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0004 0.00043702125549316
SELECT id FROM categories WHERE parent_id = '28'
38 0.0015 0.0014998912811279
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 
39 0.0005 0.00051403045654297
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 
40 0.0006 0.0005800724029541
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
41 0.0005 0.0005030632019043
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0005 0.00047183036804199
SELECT * FROM categorygroups WHERE id = '1'
43 0.0007 0.00068402290344238
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
44 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 = 29
45 0.0004 0.00044107437133789
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0004 0.00043892860412598
SELECT id FROM categories WHERE parent_id = '29'
47 0.0007 0.00067996978759766
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 
48 0.0005 0.00049710273742676
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 
49 0.0006 0.0006401538848877
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
50 0.0005 0.00051712989807129
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0005 0.00049114227294922
SELECT * FROM categorygroups WHERE id = '1'
52 0.0007 0.00065994262695312
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
53 0.0004 0.00042915344238281
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
54 0.0005 0.00048398971557617
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0005 0.00046706199645996
SELECT id FROM categories WHERE parent_id = '30'
56 0.0007 0.00074601173400879
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 
57 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 (30)
				  AND p.disabled = 0 
58 0.0005 0.00047397613525391
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
59 0.0005 0.00051498413085938
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0008 0.00076198577880859
SELECT * FROM categorygroups WHERE id = '1'
61 0.0006 0.00059103965759277
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
62 0.0005 0.00047087669372559
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
63 0.0004 0.00035715103149414
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0004 0.00044512748718262
SELECT id FROM categories WHERE parent_id = '31'
65 0.0008 0.00076508522033691
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 
66 0.0004 0.00044393539428711
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 
67 0.0006 0.00058078765869141
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
68 0.0006 0.00058889389038086
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0004 0.00043010711669922
SELECT * FROM categorygroups WHERE id = '1'
70 0.0006 0.00059294700622559
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0020 0.0020198822021484
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0008 0.00078511238098145
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0007 0.000701904296875
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
74 0.0005 0.00048112869262695
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0014 0.0014159679412842
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0010 0.0010271072387695
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.7645 0.76449584960938
SELECT * FROM ipgeocountries WHERE INET_ATON('3.142.156.4') >= INET_ATON(ip_start) AND INET_ATON('3.142.156.4') <= INET_ATON(ip_end)
78 0.0012 0.0012211799621582
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0009 0.00093817710876465
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0009 0.00091099739074707
SELECT * FROM pages WHERE pagename = 'all-products'
81 0.0126 0.012633085250854
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
82 0.0024 0.0024421215057373
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
83 0.0008 0.00076794624328613
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
84 0.0086 0.0085899829864502
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
85 0.0021 0.0020818710327148
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
86 0.0006 0.00061297416687012
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
87 0.0061 0.0061440467834473
SELECT COUNT(*) FROM products p WHERE parent_id = 0 AND hidden = 0 AND enabled = 1  AND 1 = 1
88 0.0076 0.0075747966766357
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
89 0.0021 0.0021181106567383
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
90 0.0006 0.00058197975158691
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
91 0.0072 0.0072391033172607
SELECT p.* FROM products p WHERE hidden = 0 AND enabled = 1 AND parent_id = 0 AND 1 = 1 ORDER BY salesrank ASC  LIMIT 108, 18
92 0.0008 0.00079917907714844
SELECT * FROM productimages WHERE product_id = '941' ORDER BY sortorder ASC
93 0.0007 0.0007169246673584
SELECT * FROM product_image_select WHERE product_id = '941'
94 0.0005 0.00048685073852539
SELECT * FROM productcustomimages WHERE product_id = '941'
95 0.0015 0.0015449523925781
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '941' AND a.name = n.originalname
96 0.0005 0.0005338191986084
SELECT * FROM productoffers WHERE product_id = '941' AND merchantid = 'A1X6FK5RDHNB96'
97 0.0006 0.00063610076904297
SELECT * FROM productoffers
                WHERE product_id = '941' AND price > 0
                ORDER BY price ASC LIMIT 1
98 0.0006 0.00060486793518066
SELECT value FROM productattributes WHERE product_id = '941' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
99 0.0007 0.0007469654083252
SELECT * FROM productimages WHERE product_id = '4814' ORDER BY sortorder ASC
100 0.0009 0.00087785720825195
SELECT * FROM product_image_select WHERE product_id = '4814'
101 0.0007 0.00069689750671387
SELECT * FROM productcustomimages WHERE product_id = '4814'
102 0.0015 0.0014829635620117
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4814' AND a.name = n.originalname
103 0.0008 0.00084590911865234
SELECT * FROM productoffers WHERE product_id = '4814' AND merchantid = 'A1X6FK5RDHNB96'
104 0.0007 0.00068283081054688
SELECT * FROM productoffers
                WHERE product_id = '4814' AND price > 0
                ORDER BY price ASC LIMIT 1
105 0.0010 0.0010199546813965
SELECT value FROM productattributes WHERE product_id = '4814' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
106 0.0008 0.00081992149353027
SELECT * FROM productimages WHERE product_id = '2883' ORDER BY sortorder ASC
107 0.0010 0.0009620189666748
SELECT * FROM product_image_select WHERE product_id = '2883'
108 0.0009 0.00086307525634766
SELECT * FROM productcustomimages WHERE product_id = '2883'
109 0.0013 0.0013320446014404
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2883' AND a.name = n.originalname
110 0.0012 0.0011920928955078
SELECT * FROM productoffers WHERE product_id = '2883' AND merchantid = 'A1X6FK5RDHNB96'
111 0.0009 0.00093507766723633
SELECT * FROM productoffers
                WHERE product_id = '2883' AND price > 0
                ORDER BY price ASC LIMIT 1
112 0.0011 0.0011138916015625
SELECT * FROM productoffers
                WHERE product_id = 2883
                ORDER BY price ASC LIMIT 1
113 0.0008 0.00082898139953613
SELECT value FROM productattributes
                WHERE product_id = '2883'
                AND name = 'ListPriceAmount'
114 0.0014 0.0013589859008789
SELECT value FROM productattributes WHERE product_id = '2883' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
115 0.0009 0.000885009765625
SELECT * FROM productimages WHERE product_id = '3828' ORDER BY sortorder ASC
116 0.0009 0.00088787078857422
SELECT * FROM product_image_select WHERE product_id = '3828'
117 0.0005 0.0005338191986084
SELECT * FROM productcustomimages WHERE product_id = '3828'
118 0.0016 0.0015749931335449
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3828' AND a.name = n.originalname
119 0.0005 0.0005340576171875
SELECT * FROM productoffers WHERE product_id = '3828' AND merchantid = 'A1X6FK5RDHNB96'
120 0.0005 0.00053000450134277
SELECT * FROM productoffers
                WHERE product_id = '3828' AND price > 0
                ORDER BY price ASC LIMIT 1
121 0.0006 0.00055193901062012
SELECT value FROM productattributes WHERE product_id = '3828' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
122 0.0005 0.00054502487182617
SELECT * FROM productimages WHERE product_id = '3575' ORDER BY sortorder ASC
123 0.0008 0.00076699256896973
SELECT * FROM product_image_select WHERE product_id = '3575'
124 0.0005 0.00052189826965332
SELECT * FROM productcustomimages WHERE product_id = '3575'
125 0.0020 0.0020420551300049
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3575' AND a.name = n.originalname
126 0.0010 0.00099301338195801
SELECT * FROM productoffers WHERE product_id = '3575' AND merchantid = 'A1X6FK5RDHNB96'
127 0.0008 0.0008399486541748
SELECT * FROM productoffers
                WHERE product_id = '3575' AND price > 0
                ORDER BY price ASC LIMIT 1
128 0.0007 0.0007328987121582
SELECT * FROM productoffers
                WHERE product_id = 3575
                ORDER BY price ASC LIMIT 1
129 0.0006 0.0006258487701416
SELECT value FROM productattributes
                WHERE product_id = '3575'
                AND name = 'ListPriceAmount'
130 0.0007 0.00074601173400879
SELECT value FROM productattributes WHERE product_id = '3575' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
131 0.0008 0.00082898139953613
SELECT * FROM productimages WHERE product_id = '1418' ORDER BY sortorder ASC
132 0.0009 0.00094914436340332
SELECT * FROM product_image_select WHERE product_id = '1418'
133 0.0007 0.00066304206848145
SELECT * FROM productcustomimages WHERE product_id = '1418'
134 0.0019 0.0019128322601318
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1418' AND a.name = n.originalname
135 0.0009 0.0009009838104248
SELECT * FROM productoffers WHERE product_id = '1418' AND merchantid = 'A1X6FK5RDHNB96'
136 0.0006 0.00063204765319824
SELECT * FROM productoffers
                WHERE product_id = '1418' AND price > 0
                ORDER BY price ASC LIMIT 1
137 0.0009 0.00087094306945801
SELECT value FROM productattributes WHERE product_id = '1418' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
138 0.0007 0.00072097778320312
SELECT * FROM productimages WHERE product_id = '2220' ORDER BY sortorder ASC
139 0.0007 0.00071001052856445
SELECT * FROM product_image_select WHERE product_id = '2220'
140 0.0004 0.00040197372436523
SELECT * FROM productcustomimages WHERE product_id = '2220'
141 0.0009 0.00090408325195312
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2220' AND a.name = n.originalname
142 0.0005 0.00053191184997559
SELECT * FROM productoffers WHERE product_id = '2220' AND merchantid = 'A1X6FK5RDHNB96'
143 0.0005 0.0005180835723877
SELECT * FROM productoffers
                WHERE product_id = '2220' AND price > 0
                ORDER BY price ASC LIMIT 1
144 0.0005 0.00046801567077637
SELECT value FROM productattributes WHERE product_id = '2220' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
145 0.0006 0.00062799453735352
SELECT * FROM productimages WHERE product_id = '774' ORDER BY sortorder ASC
146 0.0007 0.00069189071655273
SELECT * FROM product_image_select WHERE product_id = '774'
147 0.0005 0.00049901008605957
SELECT * FROM productcustomimages WHERE product_id = '774'
148 0.0010 0.001007080078125
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '774' AND a.name = n.originalname
149 0.0006 0.00058698654174805
SELECT * FROM productoffers WHERE product_id = '774' AND merchantid = 'A1X6FK5RDHNB96'
150 0.0005 0.00046300888061523
SELECT * FROM productoffers
                WHERE product_id = '774' AND price > 0
                ORDER BY price ASC LIMIT 1
151 0.0004 0.00035595893859863
SELECT * FROM productoffers
                WHERE product_id = 774
                ORDER BY price ASC LIMIT 1
152 0.0004 0.0003960132598877
SELECT value FROM productattributes
                WHERE product_id = '774'
                AND name = 'ListPriceAmount'
153 0.0005 0.00052905082702637
SELECT value FROM productattributes WHERE product_id = '774' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
154 0.0006 0.00055909156799316
SELECT * FROM productimages WHERE product_id = '1093' ORDER BY sortorder ASC
155 0.0008 0.00075483322143555
SELECT * FROM product_image_select WHERE product_id = '1093'
156 0.0005 0.00052118301391602
SELECT * FROM productcustomimages WHERE product_id = '1093'
157 0.0009 0.00088000297546387
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1093' AND a.name = n.originalname
158 0.0005 0.00051403045654297
SELECT * FROM productoffers WHERE product_id = '1093' AND merchantid = 'A1X6FK5RDHNB96'
159 0.0005 0.0004580020904541
SELECT * FROM productoffers
                WHERE product_id = '1093' AND price > 0
                ORDER BY price ASC LIMIT 1
160 0.0004 0.00044703483581543
SELECT value FROM productattributes WHERE product_id = '1093' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
161 0.0006 0.00055313110351562
SELECT * FROM productimages WHERE product_id = '1354' ORDER BY sortorder ASC
162 0.0006 0.00064706802368164
SELECT * FROM product_image_select WHERE product_id = '1354'
163 0.0004 0.00039005279541016
SELECT * FROM productcustomimages WHERE product_id = '1354'
164 0.0013 0.0013370513916016
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1354' AND a.name = n.originalname
165 0.0005 0.00048518180847168
SELECT * FROM productoffers WHERE product_id = '1354' AND merchantid = 'A1X6FK5RDHNB96'
166 0.0004 0.00044989585876465
SELECT * FROM productoffers
                WHERE product_id = '1354' AND price > 0
                ORDER BY price ASC LIMIT 1
167 0.0004 0.00044703483581543
SELECT value FROM productattributes WHERE product_id = '1354' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
168 0.0005 0.00049114227294922
SELECT * FROM productimages WHERE product_id = '4032' ORDER BY sortorder ASC
169 0.0011 0.0011370182037354
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4032' AND p.id = pi.product_id ORDER BY pi.sortorder
170 0.0007 0.00067806243896484
SELECT * FROM product_image_select WHERE product_id = '4032'
171 0.0004 0.00036406517028809
SELECT * FROM productcustomimages WHERE product_id = '4032'
172 0.0006 0.00056195259094238
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 = '4032'
                GROUP BY o.product_id
173 0.0008 0.00081682205200195
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     = '4032'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
174 0.0004 0.00044798851013184
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4032
175 0.0010 0.00098085403442383
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4032' AND a.name = n.originalname
176 0.0004 0.00037097930908203
SELECT * FROM productoffers WHERE product_id = '4032' AND merchantid = 'A1X6FK5RDHNB96'
177 0.0004 0.00037097930908203
SELECT * FROM productoffers
                WHERE product_id = '4032' AND price > 0
                ORDER BY price ASC LIMIT 1
178 0.0004 0.00041699409484863
SELECT * FROM productoffers
                WHERE product_id = 4032
                ORDER BY price ASC LIMIT 1
179 0.0005 0.00050997734069824
SELECT value FROM productattributes
                WHERE product_id = '4032'
                AND name = 'ListPriceAmount'
180 0.0005 0.0005488395690918
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 = '4032'
                GROUP BY o.product_id
181 0.0009 0.00085783004760742
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     = '4032'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
182 0.0004 0.00044989585876465
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4032
183 0.0006 0.00061297416687012
SELECT value FROM productattributes WHERE product_id = '4032' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
184 0.0008 0.00082087516784668
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4032'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
185 0.0006 0.00061392784118652
SELECT * FROM productimages WHERE product_id = '3786' ORDER BY sortorder ASC
186 0.0005 0.00053596496582031
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3786' AND p.id = pi.product_id ORDER BY pi.sortorder
187 0.0007 0.00068211555480957
SELECT * FROM product_image_select WHERE product_id = '3786'
188 0.0005 0.00051188468933105
SELECT * FROM productcustomimages WHERE product_id = '3786'
189 0.0006 0.00061893463134766
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 = '3786'
                GROUP BY o.product_id
190 0.0008 0.00075793266296387
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     = '3786'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
191 0.0004 0.00040316581726074
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3786
192 0.0009 0.0009150505065918
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3786' AND a.name = n.originalname
193 0.0003 0.00033998489379883
SELECT * FROM productoffers WHERE product_id = '3786' AND merchantid = 'A1X6FK5RDHNB96'
194 0.0004 0.00035905838012695
SELECT * FROM productoffers
                WHERE product_id = '3786' AND price > 0
                ORDER BY price ASC LIMIT 1
195 0.0003 0.00030803680419922
SELECT * FROM productoffers
                WHERE product_id = 3786
                ORDER BY price ASC LIMIT 1
196 0.0004 0.00037908554077148
SELECT value FROM productattributes
                WHERE product_id = '3786'
                AND name = 'ListPriceAmount'
197 0.0004 0.00044083595275879
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 = '3786'
                GROUP BY o.product_id
198 0.0007 0.00072479248046875
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     = '3786'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
199 0.0004 0.00038504600524902
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3786
200 0.0006 0.00057196617126465
SELECT value FROM productattributes WHERE product_id = '3786' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
201 0.0007 0.00068497657775879
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3786'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
202 0.0005 0.00049710273742676
SELECT * FROM productimages WHERE product_id = '2851' ORDER BY sortorder ASC
203 0.0006 0.00062704086303711
SELECT * FROM product_image_select WHERE product_id = '2851'
204 0.0004 0.00038599967956543
SELECT * FROM productcustomimages WHERE product_id = '2851'
205 0.0011 0.0011460781097412
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2851' AND a.name = n.originalname
206 0.0005 0.00046396255493164
SELECT * FROM productoffers WHERE product_id = '2851' AND merchantid = 'A1X6FK5RDHNB96'
207 0.0004 0.00038719177246094
SELECT * FROM productoffers
                WHERE product_id = '2851' AND price > 0
                ORDER BY price ASC LIMIT 1
208 0.0004 0.0004420280456543
SELECT value FROM productattributes WHERE product_id = '2851' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
209 0.0005 0.00045108795166016
SELECT * FROM productimages WHERE product_id = '1348' ORDER BY sortorder ASC
210 0.0006 0.00062799453735352
SELECT * FROM product_image_select WHERE product_id = '1348'
211 0.0004 0.00039196014404297
SELECT * FROM productcustomimages WHERE product_id = '1348'
212 0.0008 0.00083184242248535
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1348' AND a.name = n.originalname
213 0.0005 0.00046706199645996
SELECT * FROM productoffers WHERE product_id = '1348' AND merchantid = 'A1X6FK5RDHNB96'
214 0.0004 0.00036811828613281
SELECT * FROM productoffers
                WHERE product_id = '1348' AND price > 0
                ORDER BY price ASC LIMIT 1
215 0.0005 0.00046610832214355
SELECT value FROM productattributes WHERE product_id = '1348' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
216 0.0004 0.00044608116149902
SELECT * FROM productimages WHERE product_id = '1339' ORDER BY sortorder ASC
217 0.0006 0.00062108039855957
SELECT * FROM product_image_select WHERE product_id = '1339'
218 0.0004 0.00036311149597168
SELECT * FROM productcustomimages WHERE product_id = '1339'
219 0.0012 0.0011777877807617
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1339' AND a.name = n.originalname
220 0.0005 0.00046586990356445
SELECT * FROM productoffers WHERE product_id = '1339' AND merchantid = 'A1X6FK5RDHNB96'
221 0.0003 0.00034499168395996
SELECT * FROM productoffers
                WHERE product_id = '1339' AND price > 0
                ORDER BY price ASC LIMIT 1
222 0.0003 0.00030708312988281
SELECT * FROM productoffers
                WHERE product_id = 1339
                ORDER BY price ASC LIMIT 1
223 0.0004 0.00041484832763672
SELECT value FROM productattributes
                WHERE product_id = '1339'
                AND name = 'ListPriceAmount'
224 0.0004 0.00044703483581543
SELECT value FROM productattributes WHERE product_id = '1339' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
225 0.0005 0.00049805641174316
SELECT * FROM productimages WHERE product_id = '843' ORDER BY sortorder ASC
226 0.0006 0.00061702728271484
SELECT * FROM product_image_select WHERE product_id = '843'
227 0.0004 0.00036191940307617
SELECT * FROM productcustomimages WHERE product_id = '843'
228 0.0021 0.002140998840332
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '843' AND a.name = n.originalname
229 0.0009 0.00093197822570801
SELECT * FROM productoffers WHERE product_id = '843' AND merchantid = 'A1X6FK5RDHNB96'
230 0.0006 0.0005648136138916
SELECT * FROM productoffers
                WHERE product_id = '843' AND price > 0
                ORDER BY price ASC LIMIT 1
231 0.0005 0.00046300888061523
SELECT * FROM productoffers
                WHERE product_id = 843
                ORDER BY price ASC LIMIT 1
232 0.0007 0.00066184997558594
SELECT value FROM productattributes
                WHERE product_id = '843'
                AND name = 'ListPriceAmount'
233 0.0007 0.00069904327392578
SELECT value FROM productattributes WHERE product_id = '843' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
234 0.0008 0.00079989433288574
SELECT * FROM productimages WHERE product_id = '4910' ORDER BY sortorder ASC
235 0.0012 0.0012209415435791
SELECT * FROM product_image_select WHERE product_id = '4910'
236 0.0008 0.00079703330993652
SELECT * FROM productcustomimages WHERE product_id = '4910'
237 0.0028 0.0027651786804199
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4910' AND a.name = n.originalname
238 0.0008 0.00082802772521973
SELECT * FROM productoffers WHERE product_id = '4910' AND merchantid = 'A1X6FK5RDHNB96'
239 0.0007 0.00066590309143066
SELECT * FROM productoffers
                WHERE product_id = '4910' AND price > 0
                ORDER BY price ASC LIMIT 1
240 0.0008 0.0007779598236084
SELECT value FROM productattributes WHERE product_id = '4910' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
241 0.0009 0.00085997581481934
SELECT * FROM productimages WHERE product_id = '2671' ORDER BY sortorder ASC
242 0.0012 0.0012080669403076
SELECT * FROM product_image_select WHERE product_id = '2671'
243 0.0005 0.00052618980407715
SELECT * FROM productcustomimages WHERE product_id = '2671'
244 0.0015 0.0014519691467285
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2671' AND a.name = n.originalname
245 0.0006 0.0006101131439209
SELECT * FROM productoffers WHERE product_id = '2671' AND merchantid = 'A1X6FK5RDHNB96'
246 0.0005 0.00049400329589844
SELECT * FROM productoffers
                WHERE product_id = '2671' AND price > 0
                ORDER BY price ASC LIMIT 1
247 0.0004 0.0003509521484375
SELECT * FROM productoffers
                WHERE product_id = 2671
                ORDER BY price ASC LIMIT 1
248 0.0004 0.00042390823364258
SELECT value FROM productattributes
                WHERE product_id = '2671'
                AND name = 'ListPriceAmount'
249 0.0005 0.00047421455383301
SELECT value FROM productattributes WHERE product_id = '2671' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
250 0.0005 0.0005040168762207
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '941' ORDER BY timestamp DESC
251 0.0004 0.00035810470581055
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4814' ORDER BY timestamp DESC
252 0.0003 0.0002741813659668
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2883' ORDER BY timestamp DESC
253 0.0003 0.00028014183044434
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3828' ORDER BY timestamp DESC
254 0.0003 0.00026512145996094
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3575' ORDER BY timestamp DESC
255 0.0003 0.00026392936706543
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1418' ORDER BY timestamp DESC
256 0.0003 0.00029802322387695
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2220' ORDER BY timestamp DESC
257 0.0004 0.00035691261291504
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '774' ORDER BY timestamp DESC
258 0.0003 0.00028896331787109
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1093' ORDER BY timestamp DESC
259 0.0003 0.00033307075500488
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1354' ORDER BY timestamp DESC
260 0.0003 0.0002899169921875
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4032' ORDER BY timestamp DESC
261 0.0003 0.00029993057250977
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3786' ORDER BY timestamp DESC
262 0.0003 0.0003058910369873
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2851' ORDER BY timestamp DESC
263 0.0003 0.00030303001403809
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1348' ORDER BY timestamp DESC
264 0.0003 0.00030398368835449
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1339' ORDER BY timestamp DESC
265 0.0003 0.00031113624572754
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '843' ORDER BY timestamp DESC
266 0.0003 0.00029706954956055
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4910' ORDER BY timestamp DESC
267 0.0003 0.00030899047851562
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2671' ORDER BY timestamp DESC
268 0.0006 0.00055789947509766
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
269 0.0004 0.00041985511779785
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
270 0.0003 0.00028800964355469
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
271 0.0146 0.014553070068359
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
272 0.0010 0.00099301338195801
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
273 0.0005 0.00047397613525391
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
274 0.0004 0.00043797492980957
SELECT * FROM products WHERE id = 1626
275 0.0003 0.0002899169921875
SELECT * FROM products WHERE id = 4041
276 0.0003 0.00027608871459961
SELECT * FROM products WHERE id = 4312
277 0.0003 0.00030303001403809
SELECT * FROM products WHERE id = 777
278 0.0003 0.00029206275939941
SELECT * FROM products WHERE id = 3881
279 0.0004 0.00037097930908203
SELECT * FROM products WHERE id = 4213
280 0.0003 0.00026798248291016
SELECT * FROM products WHERE id = '1626'
281 0.0004 0.00037097930908203
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
282 0.0005 0.00051307678222656
SELECT * FROM product_image_select WHERE product_id = '1626'
283 0.0003 0.00030112266540527
SELECT * FROM productcustomimages WHERE product_id = '1626'
284 0.0007 0.00069689750671387
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
285 0.0004 0.00037980079650879
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
286 0.0003 0.0003199577331543
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
287 0.0004 0.00036501884460449
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
288 0.0004 0.00041389465332031
SELECT * FROM products WHERE id = '4041'
289 0.0004 0.00039100646972656
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
290 0.0005 0.00048589706420898
SELECT * FROM product_image_select WHERE product_id = '4041'
291 0.0003 0.0002899169921875
SELECT * FROM productcustomimages WHERE product_id = '4041'
292 0.0009 0.00093507766723633
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
293 0.0004 0.00043702125549316
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
294 0.0003 0.00031518936157227
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
295 0.0003 0.00033903121948242
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
296 0.0004 0.00040602684020996
SELECT * FROM products WHERE id = '4312'
297 0.0004 0.0003659725189209
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
298 0.0005 0.00054097175598145
SELECT * FROM product_image_select WHERE product_id = '4312'
299 0.0003 0.00032687187194824
SELECT * FROM productcustomimages WHERE product_id = '4312'
300 0.0009 0.00091290473937988
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
301 0.0004 0.00036811828613281
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
302 0.0003 0.00030994415283203
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
303 0.0003 0.00034785270690918
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
304 0.0004 0.00040698051452637
SELECT * FROM products WHERE id = '777'
305 0.0004 0.00039291381835938
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
306 0.0005 0.0005340576171875
SELECT * FROM product_image_select WHERE product_id = '777'
307 0.0003 0.0003361701965332
SELECT * FROM productcustomimages WHERE product_id = '777'
308 0.0010 0.00099396705627441
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
309 0.0004 0.00040507316589355
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
310 0.0003 0.00030899047851562
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
311 0.0003 0.0003361701965332
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
312 0.0004 0.00040984153747559
SELECT * FROM products WHERE id = '3881'
313 0.0004 0.00040721893310547
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
314 0.0005 0.00049901008605957
SELECT * FROM product_image_select WHERE product_id = '3881'
315 0.0003 0.00030612945556641
SELECT * FROM productcustomimages WHERE product_id = '3881'
316 0.0010 0.00097012519836426
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
317 0.0004 0.00037193298339844
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
318 0.0003 0.00030803680419922
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
319 0.0003 0.00033307075500488
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
320 0.0004 0.0003960132598877
SELECT * FROM products WHERE id = '4213'
321 0.0004 0.00040602684020996
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
322 0.0005 0.00048303604125977
SELECT * FROM product_image_select WHERE product_id = '4213'
323 0.0003 0.00031399726867676
SELECT * FROM productcustomimages WHERE product_id = '4213'
324 0.0010 0.0010011196136475
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
325 0.0004 0.00038599967956543
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
326 0.0003 0.00031208992004395
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
327 0.0004 0.00038504600524902
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
328 0.0007 0.00074195861816406
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
329 0.0006 0.00060200691223145
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
330 0.0013 0.0012860298156738
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
331 0.0006 0.00057506561279297
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
332 0.0004 0.00042510032653809
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
333 0.0007 0.00067615509033203
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
334 0.0006 0.0005500316619873
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'