Tactical Equipment - Survivalist Equipment

Leica Geovid 10x42 HD-R 2200 Rangefinder Binocular, Black by Leica Sport Optics

Price: Click Button for Price
Product prices and availability are accurate as of 2019-06-13 10:22:16 UTC and are subject to change. Any price and availability information displayed on http://www.amazon.com/ at the time of purchase will apply to the purchase of this product.
Availability: Not Available Discontinued
CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED 'AS IS' AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME.

Product Description

The Tactical and Survivalist shop is happy to stock the excellent Leica Geovid 10x42 HD-R 2200 Rangefinder Binocular, Black today at this great price.

With so many competing tactical, combat and survival products on offer recently, it is great to have a brand that you can recognize. The Leica Geovid 10x42 HD-R 2200 Rangefinder Binocular, Black is certainly all that and will be a sound purchase for your combat equipment or tactical ability.

We pride ourselves to provide the highest quality survival gear for all your front line requirements.

For this low price, the Leica Geovid 10x42 HD-R 2200 Rangefinder Binocular, Black is greatly respected and is always a favored choice amongst many like minded people. Leica Sport Optics have passed on some great touches and this means good value for money.

Manufacturer Description

This Leica Geovid 8x42 HD-B 2200 Yards Binocular includes long varying ability up to 2,200 meters with accurate EHR out to 1200 meters, advanced ballistic settlement with MOA corrections output, microSD memory card, LED display with automatic change, Perger porro prisms, aqua dura covering, two-button operation, eyecups with 4 click-stop settings, ergonomic bridge building, and a totally rubber-armored magnesium body. The Geovid HD-B 2200 uses sharp, high-contrast images, plasticity, astonishing depth, high light transmission, vivid colors and the included precision of user chosen ballistic curves.

Product Features

Nitrogen-filled, water and fogproof Aluminum alloy housing Two-position click-stop twist-up eyecup for customized eye-relief with or without eye wear Tethered objective lens caps for easy flip-down use Operational temperature down to -13°F (-25°C)

Write a Review

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
5.6356728076935 772 2.5721 0


No Amazon API Requests Made.


App Debug - Total Time 5.6356728076935 seconds

Number Time From Start Name Description
1 0.40031290054321 Initialise Initialise FSB Function
2 0.41209197044373 App Controller Start Start of the App controller (called before the controller of every page)
3 0.42700290679932 Start of getCategoryListByGroup Function Before first category groups query
4 0.4271879196167 After initial query Before first category groups query
5 0.42718887329102 Get Category List for Group Before the call to getCategoryList function
6 0.42719388008118 Start of GetCategoryList function Start of the function
7 0.42719793319702 Before getting categories Query to get specific category list
8 0.42783784866333 After getting categories Query to get specific category list
9 0.42783880233765 Before getting category custom Before call to function getCategoryCustom
10 0.42991185188293 After getting category custom After call to function getCategoryCustom
11 0.42991495132446 Before getting category custom Before call to function getCategoryCustom
12 0.44213080406189 After getting category custom After call to function getCategoryCustom
13 0.44213390350342 Before getting category custom Before call to function getCategoryCustom
14 0.44823980331421 After getting category custom After call to function getCategoryCustom
15 0.44824194908142 Before getting category custom Before call to function getCategoryCustom
16 0.45273494720459 After getting category custom After call to function getCategoryCustom
17 0.45273780822754 End of GetCategoryList function End of the function
18 0.45274686813354 Get Category List for Group Before the call to getCategoryList function
19 0.45274901390076 Start of GetCategoryList function Start of the function
20 0.45275187492371 Before getting categories Query to get specific category list
21 0.45316696166992 After getting categories Query to get specific category list
22 0.45316791534424 Before getting category custom Before call to function getCategoryCustom
23 0.45930886268616 After getting category custom After call to function getCategoryCustom
24 0.45931100845337 Before getting category custom Before call to function getCategoryCustom
25 0.47103595733643 After getting category custom After call to function getCategoryCustom
26 0.47103786468506 End of GetCategoryList function End of the function
27 0.47104382514954 Get Category List for Group Before the call to getCategoryList function
28 0.47104692459106 Start of GetCategoryList function Start of the function
29 0.47105002403259 Before getting categories Query to get specific category list
30 0.4717710018158 After getting categories Query to get specific category list
31 0.47177195549011 Before getting category custom Before call to function getCategoryCustom
32 0.48155784606934 After getting category custom After call to function getCategoryCustom
33 0.48156094551086 Before getting category custom Before call to function getCategoryCustom
34 0.50005388259888 After getting category custom After call to function getCategoryCustom
35 0.50005698204041 Before getting category custom Before call to function getCategoryCustom
36 0.50641679763794 After getting category custom After call to function getCategoryCustom
37 0.50641894340515 Before getting category custom Before call to function getCategoryCustom
38 0.5127329826355 After getting category custom After call to function getCategoryCustom
39 0.51273488998413 Before getting category custom Before call to function getCategoryCustom
40 0.51941394805908 After getting category custom After call to function getCategoryCustom
41 0.51941680908203 Before getting category custom Before call to function getCategoryCustom
42 0.54305481910706 After getting category custom After call to function getCategoryCustom
43 0.54305791854858 Before getting category custom Before call to function getCategoryCustom
44 0.54740381240845 After getting category custom After call to function getCategoryCustom
45 0.54740691184998 Before getting category custom Before call to function getCategoryCustom
46 0.55232286453247 After getting category custom After call to function getCategoryCustom
47 0.552325963974 End of GetCategoryList function End of the function
48 0.55233979225159 Get Category List for Group Before the call to getCategoryList function
49 0.5523419380188 Start of GetCategoryList function Start of the function
50 0.55234599113464 Before getting categories Query to get specific category list
51 0.5527617931366 After getting categories Query to get specific category list
52 0.55276298522949 Before getting category custom Before call to function getCategoryCustom
53 0.55515384674072 After getting category custom After call to function getCategoryCustom
54 0.55515599250793 Before getting category custom Before call to function getCategoryCustom
55 0.55757188796997 After getting category custom After call to function getCategoryCustom
56 0.5575737953186 End of GetCategoryList function End of the function
57 0.55757880210876 Get Category List for Group Before the call to getCategoryList function
58 0.55758094787598 Start of GetCategoryList function Start of the function
59 0.55758380889893 Before getting categories Query to get specific category list
60 0.55788898468018 After getting categories Query to get specific category list
61 0.55788993835449 Before getting category custom Before call to function getCategoryCustom
62 0.56318187713623 After getting category custom After call to function getCategoryCustom
63 0.56318402290344 End of GetCategoryList function End of the function
64 0.56318998336792 End of getCategoryListByGroup Function Before return()
65 0.61611795425415 App Controller End End of the App controller (called before the controller of every page)
66 0.61681580543518 Product Start Start of the product info controller
67 0.61768078804016 Cache file not found Starting get product details
68 0.64632391929626 Related products Start getting related products if enabled
69 0.64632701873779 Related Products Start Before the related products are found
70 0.64632797241211 Related Products Keywords Before the related product keywords are found
71 0.64633393287659 Create Keyword List Function Start of function
72 0.64748597145081 Create Keyword List Function After looping provided content - 870 keywords found
73 0.70222401618958 Create Keyword List Function After looping initial keyword list - 791 keywords remaining
74 0.70243692398071 Create Keyword List Function After reducing keyword list
75 0.703773021698 Create Keyword List Function After selecting by scoring keywords
76 0.70377898216248 Create Keyword List Function After final loop of keywords
77 0.70378494262695 Related Products Keywords After the related product keywords are found
78 0.96658492088318 Related Products End After the related products are found
79 1.1546568870544 Start Remote Request http://svcs.ebay.com/services/search/FindingServic...
80 1.5328469276428 End Remote Request http://svcs.ebay.com/services/search/FindingServic...
81 1.7176289558411 Start Remote Request http://svcs.ebay.com/services/search/FindingServic...
82 2.1367118358612 End Remote Request http://svcs.ebay.com/services/search/FindingServic...
83 2.3194189071655 Start Remote Request http://svcs.ebay.com/services/search/FindingServic...
84 2.6077969074249 End Remote Request http://svcs.ebay.com/services/search/FindingServic...
85 2.7884960174561 Start Remote Request http://svcs.ebay.com/services/search/FindingServic...
86 3.0629858970642 End Remote Request http://svcs.ebay.com/services/search/FindingServic...
87 3.2438318729401 Start Remote Request http://svcs.ebay.com/services/search/FindingServic...
88 3.5664618015289 End Remote Request http://svcs.ebay.com/services/search/FindingServic...
89 3.7472529411316 Start Remote Request http://svcs.ebay.com/services/search/FindingServic...
90 4.0071308612823 End Remote Request http://svcs.ebay.com/services/search/FindingServic...
91 4.1874878406525 Start Remote Request http://svcs.ebay.com/services/search/FindingServic...
92 4.516096830368 End Remote Request http://svcs.ebay.com/services/search/FindingServic...
93 4.6972649097443 Start Remote Request http://svcs.ebay.com/services/search/FindingServic...
94 4.953104019165 End Remote Request http://svcs.ebay.com/services/search/FindingServic...
95 5.1780920028687 Product End End of the product info controller (Product Info)
96 5.178505897522 App_after Controller Start Start of the App_after controller (called after the controller of every page)
97 5.1785879135132 Before Get Options Before the call to getOptions in the tpl class
98 5.5933048725128 After Get Options After the call to getOptions in the tpl class
99 5.5934917926788 App_after Controller End End of the App_after controller (called after the controller of every page)
100 5.593505859375 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
101 5.6102600097656 Product Info: After Smarty Fetch After the product.tpl template is fetched
102 5.6102659702301 Product Info: Before Template Display Before the template is displayed
103 5.6356499195099 Product Info: After Template Display After the template is displayed
104 5.6356549263 Finalizing debug Before the debug is output to the page.
105 5.6356718540192 End of App This is the end of the app logging, final timestamp


Query Debug - 772 Database Queries. Total time 2.5721 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0002 0.00016283988952637
SELECT value FROM parameters WHERE `parameter` = 'BAD_BOTS_ENABLER'
2 0.0004 0.00043892860412598
SHOW TABLES LIKE 'bad_bots'
3 0.0001 0.00014805793762207
SELECT value FROM parameters WHERE `parameter` = 'STORE_WHITELISTED_IPS'
4 0.0001 0.00013899803161621
SELECT * FROM `bad_bots`
5 0.0004 0.00043916702270508
SELECT parameter, value FROM parameters
6 0.0001 0.00013399124145508
SET time_zone = 'Europe/London'
7 0.0003 0.00032711029052734
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0002 0.00017499923706055
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0001 0.00012087821960449
delete from cachefiles
10 0.0003 0.00026202201843262
SELECT id FROM pages WHERE pagename = 'leica-geovid-10x42-hd-r-2200-rangefinder-binocular-black' LIMIT 1
11 0.0003 0.00025701522827148
SELECT id FROM products WHERE pagename = 'leica-geovid-10x42-hd-r-2200-rangefinder-binocular-black' AND hidden = 0 LIMIT 1
12 0.0010 0.00097393989562988
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
13 0.0129 0.012927055358887
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
14 0.0002 0.00023388862609863
SELECT * FROM pages WHERE pagename = 'leica-geovid-10x42-hd-r-2200-rangefinder-binocular-black'
15 0.0002 0.00016903877258301
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0006 0.00060105323791504
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0005 0.00052213668823242
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 = 49
18 0.0003 0.0002589225769043
SELECT id FROM categories WHERE parent_id = '49'
19 0.0005 0.00051593780517578
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (49)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
20 0.0002 0.00017786026000977
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (49)
				  AND p.disabled = 0 
21 0.0002 0.00017404556274414
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (49)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
22 0.0002 0.00019097328186035
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '49'
23 0.0001 0.00014114379882812
SELECT * FROM categorygroups WHERE id = '1'
24 0.0036 0.0035679340362549
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 = 50
25 0.0003 0.00028610229492188
SELECT id FROM categories WHERE parent_id = '50'
26 0.0002 0.00024008750915527
SELECT id FROM categories WHERE parent_id = '96'
27 0.0002 0.00024604797363281
SELECT id FROM categories WHERE parent_id = '97'
28 0.0002 0.00023794174194336
SELECT id FROM categories WHERE parent_id = '111'
29 0.0002 0.00023508071899414
SELECT id FROM categories WHERE parent_id = '129'
30 0.0066 0.0065548419952393
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (96,97,111,129,50)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
31 0.0002 0.00023484230041504
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (96,97,111,129,50)
				  AND p.disabled = 0 
32 0.0002 0.00016093254089355
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (96,97,111,129,50)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
33 0.0002 0.00018501281738281
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '50'
34 0.0001 0.00012707710266113
SELECT * FROM categorygroups WHERE id = '1'
35 0.0028 0.0028178691864014
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 = 80
36 0.0003 0.00025820732116699
SELECT id FROM categories WHERE parent_id = '80'
37 0.0024 0.0023500919342041
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (80)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
38 0.0002 0.0001530647277832
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (80)
				  AND p.disabled = 0 
39 0.0001 0.00014805793762207
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (80)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
40 0.0002 0.00015997886657715
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '80'
41 0.0001 0.00012588500976562
SELECT * FROM categorygroups WHERE id = '1'
42 0.0013 0.0013411045074463
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 = 51
43 0.0002 0.00024914741516113
SELECT id FROM categories WHERE parent_id = '51'
44 0.0002 0.00020313262939453
SELECT id FROM categories WHERE parent_id = '101'
45 0.0020 0.00199294090271
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (101,51)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
46 0.0002 0.0001530647277832
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (101,51)
				  AND p.disabled = 0 
47 0.0002 0.00016093254089355
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (101,51)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
48 0.0002 0.00016903877258301
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '51'
49 0.0001 0.00012612342834473
SELECT * FROM categorygroups WHERE id = '1'
50 0.0004 0.00039076805114746
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
51 0.0028 0.0027549266815186
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
52 0.0002 0.00024795532226562
SELECT id FROM categories WHERE parent_id = '30'
53 0.0025 0.0024549961090088
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 
54 0.0002 0.0001521110534668
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 
55 0.0001 0.00014781951904297
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
56 0.0002 0.00016689300537109
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
57 0.0001 0.00012707710266113
SELECT * FROM categorygroups WHERE id = '2'
58 0.0053 0.0053069591522217
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 = 61
59 0.0003 0.00027298927307129
SELECT id FROM categories WHERE parent_id = '61'
60 0.0055 0.0054550170898438
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (61)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
61 0.0002 0.00015807151794434
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (61)
				  AND p.disabled = 0 
62 0.0002 0.00015091896057129
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (61)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
63 0.0002 0.00016498565673828
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '61'
64 0.0001 0.00012707710266113
SELECT * FROM categorygroups WHERE id = '2'
65 0.0007 0.00065994262695312
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '10'  AND hidden = 0 ORDER BY sortorder ASC
66 0.0044 0.004378080368042
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 = 64
67 0.0003 0.00026798248291016
SELECT id FROM categories WHERE parent_id = '64'
68 0.0044 0.0044388771057129
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (64)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
69 0.0002 0.00015592575073242
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (64)
				  AND p.disabled = 0 
70 0.0001 0.00014686584472656
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (64)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
71 0.0002 0.00017499923706055
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '64'
72 0.0001 0.00012993812561035
SELECT * FROM categorygroups WHERE id = '10'
73 0.0087 0.0086610317230225
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 = 65
74 0.0003 0.00028395652770996
SELECT id FROM categories WHERE parent_id = '65'
75 0.0088 0.0088369846343994
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (65)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
76 0.0002 0.00016903877258301
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (65)
				  AND p.disabled = 0 
77 0.0002 0.00015020370483398
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (65)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
78 0.0002 0.0001680850982666
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '65'
79 0.0001 0.00012707710266113
SELECT * FROM categorygroups WHERE id = '10'
80 0.0027 0.0026681423187256
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 = 81
81 0.0003 0.0002598762512207
SELECT id FROM categories WHERE parent_id = '81'
82 0.0027 0.0027439594268799
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (81)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
83 0.0002 0.00015091896057129
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (81)
				  AND p.disabled = 0 
84 0.0001 0.00014805793762207
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (81)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
85 0.0002 0.00016093254089355
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '81'
86 0.0001 0.00013589859008789
SELECT * FROM categorygroups WHERE id = '10'
87 0.0027 0.0026569366455078
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
88 0.0003 0.00026702880859375
SELECT id FROM categories WHERE parent_id = '31'
89 0.0027 0.0026941299438477
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 
90 0.0002 0.00015401840209961
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 
91 0.0002 0.00015592575073242
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
92 0.0002 0.00016903877258301
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
93 0.0001 0.00012588500976562
SELECT * FROM categorygroups WHERE id = '10'
94 0.0024 0.0024158954620361
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 = 66
95 0.0003 0.00026297569274902
SELECT id FROM categories WHERE parent_id = '66'
96 0.0002 0.00020408630371094
SELECT id FROM categories WHERE parent_id = '131'
97 0.0031 0.0030820369720459
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (131,66)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
98 0.0002 0.00015997886657715
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (131,66)
				  AND p.disabled = 0 
99 0.0001 0.00014996528625488
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (131,66)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
100 0.0002 0.00016307830810547
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '66'
101 0.0001 0.00013494491577148
SELECT * FROM categorygroups WHERE id = '10'
102 0.0104 0.010355949401855
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 = 34
103 0.0003 0.00028204917907715
SELECT id FROM categories WHERE parent_id = '34'
104 0.0002 0.00020599365234375
SELECT id FROM categories WHERE parent_id = '94'
105 0.0002 0.00020408630371094
SELECT id FROM categories WHERE parent_id = '98'
106 0.0002 0.00020003318786621
SELECT id FROM categories WHERE parent_id = '99'
107 0.0002 0.0001978874206543
SELECT id FROM categories WHERE parent_id = '110'
108 0.0002 0.00019598007202148
SELECT id FROM categories WHERE parent_id = '130'
109 0.0112 0.011204957962036
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (94,98,99,110,130,34)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
110 0.0002 0.00017809867858887
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (94,98,99,110,130,34)
				  AND p.disabled = 0 
111 0.0002 0.00015783309936523
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (94,98,99,110,130,34)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
112 0.0002 0.00017786026000977
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
113 0.0001 0.00012898445129395
SELECT * FROM categorygroups WHERE id = '10'
114 0.0017 0.0017027854919434
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 = 32
115 0.0003 0.00025796890258789
SELECT id FROM categories WHERE parent_id = '32'
116 0.0017 0.0016999244689941
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (32)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
117 0.0001 0.00014686584472656
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (32)
				  AND p.disabled = 0 
118 0.0001 0.00014615058898926
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (32)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
119 0.0002 0.00016212463378906
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
120 0.0001 0.00013995170593262
SELECT * FROM categorygroups WHERE id = '10'
121 0.0020 0.0019760131835938
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 = 89
122 0.0003 0.00025010108947754
SELECT id FROM categories WHERE parent_id = '89'
123 0.0020 0.0020029544830322
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (89)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
124 0.0001 0.00014901161193848
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (89)
				  AND p.disabled = 0 
125 0.0001 0.00014686584472656
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (89)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
126 0.0002 0.0001671314239502
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '89'
127 0.0001 0.00013303756713867
SELECT * FROM categorygroups WHERE id = '10'
128 0.0004 0.00039100646972656
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '17'  AND hidden = 0 ORDER BY sortorder ASC
129 0.0007 0.0007328987121582
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 = 84
130 0.0002 0.00023293495178223
SELECT id FROM categories WHERE parent_id = '84'
131 0.0008 0.00075292587280273
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (84)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
132 0.0001 0.00014519691467285
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (84)
				  AND p.disabled = 0 
133 0.0001 0.00014591217041016
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (84)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
134 0.0002 0.00016593933105469
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '84'
135 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '17'
136 0.0007 0.00074601173400879
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 = 90
137 0.0002 0.00023317337036133
SELECT id FROM categories WHERE parent_id = '90'
138 0.0008 0.00077390670776367
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (90)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
139 0.0001 0.00014281272888184
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (90)
				  AND p.disabled = 0 
140 0.0001 0.00014400482177734
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (90)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
141 0.0002 0.00016403198242188
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '90'
142 0.0001 0.00012302398681641
SELECT * FROM categorygroups WHERE id = '17'
143 0.0003 0.00029087066650391
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '20'  AND hidden = 0 ORDER BY sortorder ASC
144 0.0022 0.0022079944610596
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 = 92
145 0.0002 0.00024890899658203
SELECT id FROM categories WHERE parent_id = '92'
146 0.0022 0.0021750926971436
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (92)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
147 0.0001 0.00014805793762207
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (92)
				  AND p.disabled = 0 
148 0.0001 0.00014710426330566
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (92)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
149 0.0001 0.00014901161193848
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '92'
150 0.0001 0.00012493133544922
SELECT * FROM categorygroups WHERE id = '20'
151 0.0051 0.0050768852233887
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
152 0.0004 0.00036501884460449
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
153 0.0002 0.00018692016601562
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
154 0.0002 0.00015497207641602
SELECT * FROM sideboxes_pages WHERE sidebox_id = '1'
155 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '67'
156 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '82'
157 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '84'
158 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '94'
159 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = '116'
160 0.0002 0.0001981258392334
SELECT * FROM pages WHERE id = '52'
161 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '135'
162 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '245'
163 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '269'
164 0.0002 0.00018215179443359
SELECT * FROM pages WHERE id = '275'
165 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '280'
166 0.0002 0.00020599365234375
SELECT * FROM pages WHERE id = '357'
167 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '379'
168 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '401'
169 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '450'
170 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '454'
171 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '457'
172 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '458'
173 0.0002 0.0001528263092041
SELECT * FROM sideboxes_pages WHERE sidebox_id = '2'
174 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '41'
175 0.0002 0.00016021728515625
SELECT * FROM pages WHERE id = '43'
176 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '44'
177 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '68'
178 0.0002 0.00020718574523926
SELECT * FROM pages WHERE id = '80'
179 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '85'
180 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '97'
181 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '107'
182 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '108'
183 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '128'
184 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '133'
185 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '148'
186 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '217'
187 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '228'
188 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '257'
189 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '271'
190 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '286'
191 0.0001 0.00014781951904297
SELECT * FROM pages WHERE id = '287'
192 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '291'
193 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '380'
194 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '344'
195 0.0002 0.00016379356384277
SELECT * FROM pages WHERE id = '354'
196 0.0002 0.00018000602722168
SELECT * FROM pages WHERE id = '363'
197 0.0002 0.00018000602722168
SELECT * FROM pages WHERE id = '364'
198 0.0001 0.00014281272888184
SELECT * FROM pages WHERE id = '368'
199 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '369'
200 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '400'
201 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '463'
202 0.0002 0.00016403198242188
SELECT * FROM sideboxes_pages WHERE sidebox_id = '33'
203 0.0002 0.00023698806762695
SELECT * FROM pages WHERE id = '66'
204 0.0002 0.00018715858459473
SELECT * FROM pages WHERE id = '77'
205 0.0002 0.00019288063049316
SELECT * FROM pages WHERE id = '90'
206 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '414'
207 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '119'
208 0.0002 0.00023889541625977
SELECT * FROM pages WHERE id = '406'
209 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '149'
210 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '150'
211 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '412'
212 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '162'
213 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '164'
214 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '167'
215 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '180'
216 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '187'
217 0.0002 0.00019001960754395
SELECT * FROM pages WHERE id = '265'
218 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '268'
219 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '411'
220 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '290'
221 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '413'
222 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '409'
223 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '327'
224 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '336'
225 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '351'
226 0.0001 0.00014519691467285
SELECT * FROM pages WHERE id = '358'
227 0.0002 0.0001671314239502
SELECT * FROM pages WHERE id = '360'
228 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '362'
229 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '366'
230 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '370'
231 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '377'
232 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '386'
233 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '408'
234 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '415'
235 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '416'
236 0.0002 0.00017905235290527
SELECT * FROM pages WHERE id = '419'
237 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '423'
238 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '427'
239 0.0002 0.00018906593322754
SELECT * FROM pages WHERE id = '428'
240 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '432'
241 0.0001 0.00014281272888184
SELECT * FROM pages WHERE id = '433'
242 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '436'
243 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '437'
244 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '461'
245 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '464'
246 0.0002 0.00015091896057129
SELECT * FROM sideboxes_pages WHERE sidebox_id = '34'
247 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '74'
248 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '137'
249 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '145'
250 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '156'
251 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '407'
252 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '410'
253 0.0002 0.00017690658569336
SELECT * FROM pages WHERE id = '266'
254 0.0002 0.00019311904907227
SELECT * FROM pages WHERE id = '316'
255 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '332'
256 0.0002 0.00017809867858887
SELECT * FROM pages WHERE id = '334'
257 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '367'
258 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '387'
259 0.0002 0.00017619132995605
SELECT * FROM pages WHERE id = '389'
260 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '397'
261 0.0002 0.00017619132995605
SELECT * FROM pages WHERE id = '449'
262 0.0002 0.00016403198242188
SELECT * FROM sideboxes_pages WHERE sidebox_id = '35'
263 0.0002 0.00019001960754395
SELECT * FROM pages WHERE id = '42'
264 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '79'
265 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '86'
266 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '95'
267 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '102'
268 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '109'
269 0.0002 0.0001978874206543
SELECT * FROM pages WHERE id = '114'
270 0.0002 0.0001828670501709
SELECT * FROM pages WHERE id = '121'
271 0.0002 0.00019407272338867
SELECT * FROM pages WHERE id = '138'
272 0.0002 0.00024509429931641
SELECT * FROM pages WHERE id = '142'
273 0.0002 0.00019192695617676
SELECT * FROM pages WHERE id = '62'
274 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '157'
275 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '246'
276 0.0002 0.00019717216491699
SELECT * FROM pages WHERE id = '276'
277 0.0002 0.00018191337585449
SELECT * FROM pages WHERE id = '278'
278 0.0002 0.00019502639770508
SELECT * FROM pages WHERE id = '279'
279 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '317'
280 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '405'
281 0.0002 0.00018811225891113
SELECT * FROM pages WHERE id = '343'
282 0.0002 0.00024104118347168
SELECT * FROM pages WHERE id = '345'
283 0.0002 0.00021195411682129
SELECT * FROM pages WHERE id = '346'
284 0.0002 0.00017714500427246
SELECT * FROM pages WHERE id = '347'
285 0.0002 0.00019192695617676
SELECT * FROM pages WHERE id = '348'
286 0.0002 0.00017809867858887
SELECT * FROM pages WHERE id = '349'
287 0.0002 0.00016498565673828
SELECT * FROM pages WHERE id = '381'
288 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '392'
289 0.0002 0.00016283988952637
SELECT * FROM pages WHERE id = '393'
290 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '394'
291 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '395'
292 0.0002 0.00017309188842773
SELECT * FROM pages WHERE id = '399'
293 0.0002 0.00017905235290527
SELECT * FROM pages WHERE id = '421'
294 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '426'
295 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '430'
296 0.0002 0.00017309188842773
SELECT * FROM pages WHERE id = '431'
297 0.0002 0.00017380714416504
SELECT * FROM pages WHERE id = '434'
298 0.0002 0.00017213821411133
SELECT * FROM pages WHERE id = '435'
299 0.0002 0.00017881393432617
SELECT * FROM pages WHERE id = '440'
300 0.0002 0.00017189979553223
SELECT * FROM pages WHERE id = '441'
301 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '451'
302 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '453'
303 0.0002 0.00015902519226074
SELECT * FROM sideboxes_pages WHERE sidebox_id = '37'
304 0.0002 0.00018095970153809
SELECT * FROM pages WHERE id = '146'
305 0.0002 0.00016117095947266
SELECT * FROM pages WHERE id = '158'
306 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '163'
307 0.0002 0.00022101402282715
SELECT * FROM pages WHERE id = '293'
308 0.0002 0.00017118453979492
SELECT * FROM pages WHERE id = '340'
309 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '417'
310 0.0002 0.00015711784362793
SELECT * FROM sideboxes_pages WHERE sidebox_id = '40'
311 0.0002 0.00018501281738281
SELECT * FROM pages WHERE id = '173'
312 0.0002 0.00017619132995605
SELECT * FROM pages WHERE id = '181'
313 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '288'
314 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '299'
315 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '300'
316 0.0002 0.00017905235290527
SELECT * FROM pages WHERE id = '383'
317 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '385'
318 0.0002 0.00016617774963379
SELECT * FROM pages WHERE id = '438'
319 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '442'
320 0.0002 0.00015497207641602
SELECT * FROM sideboxes_pages WHERE sidebox_id = '38'
321 0.0003 0.00025105476379395
SELECT * FROM pages WHERE id = '103'
322 0.0002 0.0002288818359375
SELECT * FROM pages WHERE id = '134'
323 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '139'
324 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '143'
325 0.0002 0.00018692016601562
SELECT * FROM pages WHERE id = '234'
326 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '248'
327 0.0002 0.00016117095947266
SELECT * FROM pages WHERE id = '260'
328 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '398'
329 0.0002 0.00016903877258301
SELECT * FROM sideboxes_pages WHERE sidebox_id = '29'
330 0.0002 0.00018310546875
SELECT * FROM pages WHERE id = '61'
331 0.0002 0.00017213821411133
SELECT * FROM pages WHERE id = '87'
332 0.0002 0.00018095970153809
SELECT * FROM pages WHERE id = '104'
333 0.0002 0.00020503997802734
SELECT * FROM pages WHERE id = '115'
334 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '124'
335 0.0002 0.00017690658569336
SELECT * FROM pages WHERE id = '144'
336 0.0002 0.00019001960754395
SELECT * FROM pages WHERE id = '151'
337 0.0002 0.00016283988952637
SELECT * FROM pages WHERE id = '199'
338 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '200'
339 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '304'
340 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '321'
341 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '333'
342 0.0002 0.00018596649169922
SELECT * FROM pages WHERE id = '350'
343 0.0002 0.00016283988952637
SELECT * FROM pages WHERE id = '378'
344 0.0002 0.00016188621520996
SELECT * FROM pages WHERE id = '422'
345 0.0002 0.00020098686218262
SELECT * FROM pages WHERE id = '425'
346 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '443'
347 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '444'
348 0.0002 0.00015783309936523
SELECT * FROM pages WHERE id = '445'
349 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '446'
350 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '447'
351 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '448'
352 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '455'
353 0.0002 0.00017189979553223
SELECT * FROM pages WHERE id = '456'
354 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '459'
355 0.0002 0.00018095970153809
SELECT * FROM pages WHERE id = '460'
356 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '462'
357 0.0002 0.00016093254089355
SELECT * FROM sideboxes_pages WHERE sidebox_id = '32'
358 0.0002 0.00018906593322754
SELECT * FROM pages WHERE id = '153'
359 0.0002 0.00021696090698242
SELECT * FROM pages WHERE id = '182'
360 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '238'
361 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '240'
362 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '242'
363 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '252'
364 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = '253'
365 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '262'
366 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = '267'
367 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '420'
368 0.0002 0.00015902519226074
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
369 0.0001 0.00013518333435059
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 
370 0.0001 0.00014901161193848
SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
371 0.0014 0.0014259815216064
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
372 0.0002 0.00019407272338867
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
373 0.0001 0.00013613700866699
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 
374 0.0001 0.0001370906829834
SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
375 0.0003 0.00028896331787109
SELECT * FROM products WHERE pagename = 'leica-geovid-10x42-hd-r-2200-rangefinder-binocular-black'
376 0.0002 0.0001978874206543
SELECT * FROM manufacturers WHERE id = '883'
377 0.0004 0.00043821334838867
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '883'
378 0.0001 0.00012993812561035
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '883' LIMIT 1
379 0.0004 0.00038719177246094
SELECT pagename, id FROM products p WHERE manufacturer_id = '883' ORDER BY RAND() LIMIT 1
380 0.0002 0.00019192695617676
SELECT * FROM productimages WHERE product_id = '414826' ORDER BY sortorder ASC
381 0.0004 0.00038909912109375
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '883'
382 0.0004 0.00042009353637695
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '883'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
383 0.0001 0.00012898445129395
SELECT * FROM manufacturerimages WHERE manufacturer_id = '883'
384 0.0002 0.00015997886657715
SELECT category_id FROM products_categories WHERE product_id = '406975'
385 0.0002 0.00021004676818848
SELECT * FROM categories WHERE id = '65'
386 0.0088 0.0087602138519287
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 = 65
387 0.0001 0.00014805793762207
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 65
388 0.0003 0.00027990341186523
SELECT id FROM categories WHERE parent_id = '65'
389 0.0088 0.008836030960083
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (65)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
390 0.0002 0.0001828670501709
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (65)
				  AND p.disabled = 0 
391 0.0002 0.00016903877258301
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (65)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
392 0.0002 0.00018692016601562
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '65'
393 0.0003 0.00028085708618164
SELECT * FROM productimages WHERE product_id = '406975' ORDER BY sortorder ASC
394 0.0002 0.00022721290588379
SELECT * FROM product_image_select WHERE product_id = '406975'
395 0.0001 0.0001380443572998
SELECT * FROM productcustomimages WHERE product_id = '406975'
396 0.0001 0.00012803077697754
SELECT * FROM productfeeds WHERE product_id = '406975' ORDER BY item_date DESC
397 0.0004 0.00037789344787598
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '406975' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
398 0.0003 0.00034809112548828
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '406975' AND t.hidden = 0 AND display_product = 1
399 0.0002 0.00018405914306641
SELECT * FROM productamazoncontent WHERE product_id = '406975'
400 0.0037 0.0037209987640381
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406975' AND a.name = n.originalname
401 0.0002 0.00018715858459473
SELECT * FROM productoffers WHERE product_id = '406975' AND merchantid = 'ATVPDKIKX0DER'
402 0.0002 0.00020909309387207
SELECT * FROM productoffers
                WHERE product_id = '406975' AND price > 0
                ORDER BY price ASC LIMIT 1
403 0.0002 0.00017595291137695
SELECT * FROM productoffers
                WHERE product_id = 406975
                ORDER BY price ASC LIMIT 1
404 0.0002 0.00024795532226562
SELECT value FROM productattributes
                WHERE product_id = '406975'
                AND name = 'ListPriceAmount'
405 0.0005 0.0004570484161377
SELECT value FROM productattributes WHERE product_id = '406975' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
406 0.2316 0.23162412643433
SELECT *, MATCH (description, keyfeatures, title) AGAINST ('leica' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, keyfeatures, title) AGAINST ('leica' IN BOOLEAN MODE) AND 406975 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
407 0.0003 0.00031304359436035
SELECT * FROM productimages WHERE product_id = '123875' ORDER BY sortorder ASC
408 0.0002 0.00023412704467773
SELECT * FROM product_image_select WHERE product_id = '123875'
409 0.0001 0.00013613700866699
SELECT * FROM productcustomimages WHERE product_id = '123875'
410 0.0039 0.0039238929748535
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '123875' AND a.name = n.originalname
411 0.0002 0.00020790100097656
SELECT * FROM productoffers WHERE product_id = '123875' AND merchantid = 'ATVPDKIKX0DER'
412 0.0002 0.00021982192993164
SELECT * FROM productoffers
                WHERE product_id = '123875' AND price > 0
                ORDER BY price ASC LIMIT 1
413 0.0004 0.00035309791564941
SELECT value FROM productattributes WHERE product_id = '123875' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
414 0.0002 0.00015902519226074
UPDATE products SET price = '59900' WHERE id = '123875'
415 0.0003 0.00027894973754883
SELECT * FROM productimages WHERE product_id = '405525' ORDER BY sortorder ASC
416 0.0002 0.00022411346435547
SELECT * FROM product_image_select WHERE product_id = '405525'
417 0.0001 0.00013494491577148
SELECT * FROM productcustomimages WHERE product_id = '405525'
418 0.0038 0.0037879943847656
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '405525' AND a.name = n.originalname
419 0.0002 0.00020599365234375
SELECT * FROM productoffers WHERE product_id = '405525' AND merchantid = 'ATVPDKIKX0DER'
420 0.0002 0.00023102760314941
SELECT * FROM productoffers
                WHERE product_id = '405525' AND price > 0
                ORDER BY price ASC LIMIT 1
421 0.0005 0.0004880428314209
SELECT value FROM productattributes WHERE product_id = '405525' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
422 0.0001 0.00013899803161621
UPDATE products SET price = '62900' WHERE id = '405525'
423 0.0002 0.00020194053649902
SELECT * FROM productimages WHERE product_id = '407662' ORDER BY sortorder ASC
424 0.0002 0.00022220611572266
SELECT * FROM product_image_select WHERE product_id = '407662'
425 0.0001 0.00013494491577148
SELECT * FROM productcustomimages WHERE product_id = '407662'
426 0.0035 0.0034689903259277
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407662' AND a.name = n.originalname
427 0.0002 0.00020694732666016
SELECT * FROM productoffers WHERE product_id = '407662' AND merchantid = 'ATVPDKIKX0DER'
428 0.0002 0.00022482872009277
SELECT * FROM productoffers
                WHERE product_id = '407662' AND price > 0
                ORDER BY price ASC LIMIT 1
429 0.0005 0.00046801567077637
SELECT value FROM productattributes WHERE product_id = '407662' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
430 0.0002 0.00015091896057129
UPDATE products SET price = '224900' WHERE id = '407662'
431 0.0003 0.00026082992553711
SELECT * FROM productimages WHERE product_id = '409642' ORDER BY sortorder ASC
432 0.0002 0.00022506713867188
SELECT * FROM product_image_select WHERE product_id = '409642'
433 0.0001 0.00013518333435059
SELECT * FROM productcustomimages WHERE product_id = '409642'
434 0.0029 0.0029349327087402
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '409642' AND a.name = n.originalname
435 0.0002 0.00021219253540039
SELECT * FROM productoffers WHERE product_id = '409642' AND merchantid = 'ATVPDKIKX0DER'
436 0.0002 0.00023198127746582
SELECT * FROM productoffers
                WHERE product_id = '409642' AND price > 0
                ORDER BY price ASC LIMIT 1
437 0.0004 0.00043296813964844
SELECT value FROM productattributes WHERE product_id = '409642' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
438 0.0001 0.00013613700866699
UPDATE products SET price = '209900' WHERE id = '409642'
439 0.0002 0.00024104118347168
SELECT * FROM productimages WHERE product_id = '409759' ORDER BY sortorder ASC
440 0.0002 0.00022101402282715
SELECT * FROM product_image_select WHERE product_id = '409759'
441 0.0001 0.00013494491577148
SELECT * FROM productcustomimages WHERE product_id = '409759'
442 0.0032 0.0031540393829346
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '409759' AND a.name = n.originalname
443 0.0002 0.00020098686218262
SELECT * FROM productoffers WHERE product_id = '409759' AND merchantid = 'ATVPDKIKX0DER'
444 0.0002 0.00022101402282715
SELECT * FROM productoffers
                WHERE product_id = '409759' AND price > 0
                ORDER BY price ASC LIMIT 1
445 0.0004 0.00041294097900391
SELECT value FROM productattributes WHERE product_id = '409759' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
446 0.0001 0.0001370906829834
UPDATE products SET price = '229000' WHERE id = '409759'
447 0.0002 0.0001978874206543
SELECT * FROM productimages WHERE product_id = '411738' ORDER BY sortorder ASC
448 0.0002 0.00022482872009277
SELECT * FROM product_image_select WHERE product_id = '411738'
449 0.0001 0.00013589859008789
SELECT * FROM productcustomimages WHERE product_id = '411738'
450 0.0027 0.0026898384094238
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '411738' AND a.name = n.originalname
451 0.0002 0.00019502639770508
SELECT * FROM productoffers WHERE product_id = '411738' AND merchantid = 'ATVPDKIKX0DER'
452 0.0002 0.00021600723266602
SELECT * FROM productoffers
                WHERE product_id = '411738' AND price > 0
                ORDER BY price ASC LIMIT 1
453 0.0004 0.00041794776916504
SELECT value FROM productattributes WHERE product_id = '411738' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
454 0.0001 0.00013399124145508
UPDATE products SET price = '56999' WHERE id = '411738'
455 0.0002 0.00016379356384277
SELECT value FROM parameters WHERE parameter = 'EBAY_CACHE_TIME' 
456 0.0001 0.00013589859008789
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
457 0.0001 0.00013399124145508
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
458 0.0001 0.00014185905456543
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
459 0.0001 0.00013208389282227
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
460 0.0001 0.00013113021850586
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
461 0.0001 0.00014781951904297
SELECT * FROM ebay_locale_details WHERE cur_code = 'USD' 
462 0.1858 0.18583083152771
SELECT * FROM ebay_products_cache WHERE cachekey = 'caeeb759c55bf3e7cc9a2b6cf49c4869' 
463 0.0003 0.00025105476379395
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
464 0.0001 0.00013899803161621
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
465 0.0001 0.00014901161193848
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
466 0.0001 0.00013399124145508
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
467 0.0001 0.00013208389282227
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
468 0.1838 0.18376898765564
SELECT * FROM ebay_products_cache WHERE cachekey = 'caeeb759c55bf3e7cc9a2b6cf49c4869' 
469 0.0003 0.00026392936706543
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
470 0.0001 0.00012707710266113
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
471 0.0001 0.00013303756713867
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
472 0.0001 0.00012111663818359
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
473 0.0001 0.00011897087097168
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
474 0.1817 0.18168187141418
SELECT * FROM ebay_products_cache WHERE cachekey = 'caeeb759c55bf3e7cc9a2b6cf49c4869' 
475 0.0003 0.00026988983154297
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
476 0.0001 0.00012493133544922
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
477 0.0001 0.00012087821960449
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
478 0.0001 0.00011992454528809
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
479 0.0001 0.00012803077697754
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
480 0.1797 0.17970514297485
SELECT * FROM ebay_products_cache WHERE cachekey = 'caeeb759c55bf3e7cc9a2b6cf49c4869' 
481 0.0003 0.00026106834411621
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
482 0.0001 0.00012516975402832
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
483 0.0001 0.00011992454528809
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
484 0.0001 0.00012993812561035
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
485 0.0001 0.00012016296386719
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
486 0.1799 0.17986392974854
SELECT * FROM ebay_products_cache WHERE cachekey = 'caeeb759c55bf3e7cc9a2b6cf49c4869' 
487 0.0003 0.00025391578674316
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
488 0.0001 0.00012707710266113
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
489 0.0001 0.0001220703125
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
490 0.0001 0.00011992454528809
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
491 0.0001 0.00011682510375977
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
492 0.1798 0.17981600761414
SELECT * FROM ebay_products_cache WHERE cachekey = 'caeeb759c55bf3e7cc9a2b6cf49c4869' 
493 0.0003 0.0002601146697998
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
494 0.0001 0.00012707710266113
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
495 0.0001 0.0001218318939209
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
496 0.0001 0.00011897087097168
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
497 0.0001 0.00011706352233887
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
498 0.1794 0.17936015129089
SELECT * FROM ebay_products_cache WHERE cachekey = 'caeeb759c55bf3e7cc9a2b6cf49c4869' 
499 0.0003 0.00026297569274902
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
500 0.0001 0.00012803077697754
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
501 0.0001 0.00012111663818359
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
502 0.0001 0.00013208389282227
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
503 0.0001 0.00011992454528809
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
504 0.1802 0.18020009994507
SELECT * FROM ebay_products_cache WHERE cachekey = 'caeeb759c55bf3e7cc9a2b6cf49c4869' 
505 0.0003 0.00026202201843262
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
506 0.0001 0.00012493133544922
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
507 0.0001 0.00011801719665527
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
508 0.0001 0.00011706352233887
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
509 0.0001 0.00011587142944336
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
510 0.1794 0.17943096160889
SELECT * FROM ebay_products_cache WHERE cachekey = 'caeeb759c55bf3e7cc9a2b6cf49c4869' 
511 0.0003 0.00031399726867676
UPDATE ebay_products_cache SET products = 'a:2:{i:0;a:13:{s:6:\"itemId\";s:12:\"202546936012\";s:11:\"viewItemURL\";s:137:\"http://rover.ebay.com/rover/1/711-53200-19255-0/1?ff3=2&toolid=10041&campid=5338345274&customid=&lgeo=1&vectorid=229466&item=202546936012\";s:10:\"galleryURL\";s:58:\"//thumbs1.ebaystatic.com/m/mB0TpnVTSaxinZsRkBDUePg/140.jpg\";s:5:\"title\";s:77:\"Leica 10x42 Geovid HD-R Range Finding Binoculars Edition 2200 Type 403 40 441\";s:11:\"listingType\";s:14:\"StoreInventory\";s:20:\"conditionDisplayName\";s:4:\"Used\";s:8:\"timeLeft\";s:13:\"P17DT7H53M56S\";s:15:\"returnsAccepted\";s:4:\"true\";s:19:\"originalRetailPrice\";i:0;s:12:\"currentPrice\";s:7:\"2399.99\";s:15:\"shipToLocations\";s:9:\"Worldwide\";s:12:\"handlingTime\";s:1:\"1\";s:10:\"variations\";s:5:\"false\";}i:1;s:218:\"http://rover.ebay.com/rover/1/711-53200-19255-0/1?ff3=4&toolid=10041&campid=5338345274&customid=&lgeo=1&mpre=http%3A%2F%2Fwww.ebay.com%2Fsch%2Fi.html%3F_nkw%3DLeica%2BGeovid%2B10x42%2BHD-R%2B2200%26_ipg%3D10%26_pgn%3D1\";}', expiretime = '1560756403' WHERE id = '66614'
512 0.0002 0.00019001960754395
SELECT id,asin FROM products WHERE parent_id = 406975
513 0.0003 0.00032496452331543
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '406975' ORDER BY timestamp DESC
514 0.0001 0.00014090538024902
SELECT category_id FROM products_categories WHERE product_id = '406975'
515 0.0002 0.00019097328186035
SELECT * FROM categories WHERE id = '65'
516 0.0082 0.0082249641418457
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 = 65
517 0.0001 0.0001370906829834
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 65
518 0.0003 0.0002601146697998
SELECT id FROM categories WHERE parent_id = '65'
519 0.0081 0.008126974105835
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (65)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
520 0.0002 0.00017595291137695
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (65)
				  AND p.disabled = 0 
521 0.0002 0.00016903877258301
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (65)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
522 0.0002 0.00017094612121582
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '65'
523 0.0034 0.0034270286560059
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406975' AND a.name = n.originalname
524 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '406975' AND merchantid = 'ATVPDKIKX0DER'
525 0.0002 0.0001981258392334
SELECT * FROM productoffers
                WHERE product_id = '406975' AND price > 0
                ORDER BY price ASC LIMIT 1
526 0.0002 0.00016188621520996
SELECT * FROM productoffers
                WHERE product_id = 406975
                ORDER BY price ASC LIMIT 1
527 0.0002 0.00022506713867188
SELECT value FROM productattributes
                WHERE product_id = '406975'
                AND name = 'ListPriceAmount'
528 0.0002 0.00020503997802734
SELECT * FROM products WHERE id = '406975'
529 0.0004 0.00043797492980957
SELECT value FROM productattributes WHERE product_id = '406975' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
530 0.0033 0.0033259391784668
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406975' AND a.name = n.originalname
531 0.0002 0.00017309188842773
SELECT * FROM productoffers WHERE product_id = '406975' AND merchantid = 'ATVPDKIKX0DER'
532 0.0002 0.00018000602722168
SELECT * FROM productoffers
                WHERE product_id = '406975' AND price > 0
                ORDER BY price ASC LIMIT 1
533 0.0002 0.00015997886657715
SELECT * FROM productoffers
                WHERE product_id = 406975
                ORDER BY price ASC LIMIT 1
534 0.0002 0.00021910667419434
SELECT value FROM productattributes
                WHERE product_id = '406975'
                AND name = 'ListPriceAmount'
535 0.0001 0.00013113021850586
SELECT category_id FROM products_categories WHERE product_id = '406975'
536 0.0001 0.00011920928955078
SELECT parent_id FROM categories WHERE id = '65'
537 0.0002 0.00016188621520996
SELECT * FROM categories WHERE id = '65'
538 0.0079 0.0078649520874023
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 = 65
539 0.0001 0.00013494491577148
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 65
540 0.0003 0.00025701522827148
SELECT id FROM categories WHERE parent_id = '65'
541 0.0081 0.0080790519714355
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (65)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
542 0.0002 0.00016283988952637
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (65)
				  AND p.disabled = 0 
543 0.0001 0.00014686584472656
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (65)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
544 0.0002 0.0001671314239502
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '65'
545 0.0002 0.00017189979553223
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
546 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = 2
547 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = 4
548 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = 12
549 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = 10
550 0.0001 0.00013518333435059
SELECT * FROM pages WHERE id = 7
551 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = 18
552 0.0001 0.00013589859008789
SELECT * FROM pages WHERE id = 28
553 0.0001 0.0001370906829834
SELECT * FROM pages WHERE id = 13
554 0.0001 0.00013303756713867
SELECT * FROM pages WHERE id = 3
555 0.0429 0.042906999588013
SELECT p.id,p.parent_id, o.price FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND hidden = 0 AND offers > 0 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 24
556 0.0002 0.00023603439331055
UPDATE template_options SET value = 'a:11:{s:14:\"populationtype\";s:9:\"automatic\";s:12:\"productcount\";s:1:\"6\";s:12:\"maxsalesrank\";s:0:\"\";s:8:\"minprice\";s:1:\"0\";s:8:\"maxprice\";s:1:\"0\";s:9:\"minimages\";s:0:\"\";s:10:\"categories\";s:0:\"\";s:10:\"updatetime\";s:5:\"86400\";s:13:\"selectiontype\";s:6:\"random\";s:11:\"lastupdated\";i:1560756407;s:8:\"products\";a:6:{i:0;s:6:\"398315\";i:8;s:6:\"408792\";i:11;s:6:\"403517\";i:13;s:6:\"407831\";i:15;s:6:\"406758\";i:2;s:6:\"290575\";}}' WHERE id = '175'
557 0.0004 0.00044417381286621
SELECT * FROM products WHERE id IN (398315,408792,403517,407831,406758,290575) ORDER BY FIELD(id, 398315,408792,403517,407831,406758,290575 )
558 0.0002 0.00022983551025391
SELECT * FROM productimages WHERE product_id = '398315' ORDER BY sortorder ASC
559 0.0002 0.00021195411682129
SELECT * FROM product_image_select WHERE product_id = '398315'
560 0.0001 0.00012516975402832
SELECT * FROM productcustomimages WHERE product_id = '398315'
561 0.0025 0.0024850368499756
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398315' AND a.name = n.originalname
562 0.0002 0.00018692016601562
SELECT * FROM productoffers WHERE product_id = '398315' AND merchantid = 'ATVPDKIKX0DER'
563 0.0002 0.00020194053649902
SELECT * FROM productoffers
                WHERE product_id = '398315' AND price > 0
                ORDER BY price ASC LIMIT 1
564 0.0004 0.00037908554077148
SELECT value FROM productattributes WHERE product_id = '398315' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
565 0.0001 0.00012493133544922
UPDATE products SET price = '1999' WHERE id = '398315'
566 0.0002 0.00020194053649902
SELECT * FROM productimages WHERE product_id = '408792' ORDER BY sortorder ASC
567 0.0002 0.00020289421081543
SELECT * FROM product_image_select WHERE product_id = '408792'
568 0.0001 0.00012016296386719
SELECT * FROM productcustomimages WHERE product_id = '408792'
569 0.0036 0.0036489963531494
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408792' AND a.name = n.originalname
570 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '408792' AND merchantid = 'ATVPDKIKX0DER'
571 0.0002 0.00020098686218262
SELECT * FROM productoffers
                WHERE product_id = '408792' AND price > 0
                ORDER BY price ASC LIMIT 1
572 0.0004 0.0004420280456543
SELECT value FROM productattributes WHERE product_id = '408792' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
573 0.0001 0.00012087821960449
UPDATE products SET price = '13499' WHERE id = '408792'
574 0.0003 0.0002589225769043
SELECT * FROM productimages WHERE product_id = '403517' ORDER BY sortorder ASC
575 0.0002 0.00020289421081543
SELECT * FROM product_image_select WHERE product_id = '403517'
576 0.0001 0.00012898445129395
SELECT * FROM productcustomimages WHERE product_id = '403517'
577 0.0029 0.002932071685791
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '403517' AND a.name = n.originalname
578 0.0002 0.00018310546875
SELECT * FROM productoffers WHERE product_id = '403517' AND merchantid = 'ATVPDKIKX0DER'
579 0.0002 0.00019693374633789
SELECT * FROM productoffers
                WHERE product_id = '403517' AND price > 0
                ORDER BY price ASC LIMIT 1
580 0.0004 0.0003969669342041
SELECT value FROM productattributes WHERE product_id = '403517' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
581 0.0001 0.00012993812561035
UPDATE products SET price = '6699' WHERE id = '403517'
582 0.0002 0.00019502639770508
SELECT * FROM productimages WHERE product_id = '407831' ORDER BY sortorder ASC
583 0.0002 0.00020599365234375
SELECT * FROM product_image_select WHERE product_id = '407831'
584 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '407831'
585 0.0033 0.0033409595489502
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407831' AND a.name = n.originalname
586 0.0002 0.00018310546875
SELECT * FROM productoffers WHERE product_id = '407831' AND merchantid = 'ATVPDKIKX0DER'
587 0.0002 0.00019407272338867
SELECT * FROM productoffers
                WHERE product_id = '407831' AND price > 0
                ORDER BY price ASC LIMIT 1
588 0.0004 0.00041913986206055
SELECT value FROM productattributes WHERE product_id = '407831' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
589 0.0001 0.00011992454528809
UPDATE products SET price = '1293' WHERE id = '407831'
590 0.0002 0.00018692016601562
SELECT * FROM productimages WHERE product_id = '406758' ORDER BY sortorder ASC
591 0.0002 0.00020194053649902
SELECT * FROM product_image_select WHERE product_id = '406758'
592 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '406758'
593 0.0026 0.0026259422302246
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406758' AND a.name = n.originalname
594 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '406758' AND merchantid = 'ATVPDKIKX0DER'
595 0.0002 0.0001978874206543
SELECT * FROM productoffers
                WHERE product_id = '406758' AND price > 0
                ORDER BY price ASC LIMIT 1
596 0.0004 0.00039005279541016
SELECT value FROM productattributes WHERE product_id = '406758' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
597 0.0001 0.00012111663818359
UPDATE products SET price = '2694' WHERE id = '406758'
598 0.0006 0.00057291984558105
SELECT * FROM productimages WHERE product_id = '290575' ORDER BY sortorder ASC
599 0.0002 0.00021505355834961
SELECT * FROM product_image_select WHERE product_id = '290575'
600 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '290575'
601 0.0034 0.0033559799194336
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '290575' AND a.name = n.originalname
602 0.0002 0.00018978118896484
SELECT * FROM productoffers WHERE product_id = '290575' AND merchantid = 'ATVPDKIKX0DER'
603 0.0002 0.00019598007202148
SELECT * FROM productoffers
                WHERE product_id = '290575' AND price > 0
                ORDER BY price ASC LIMIT 1
604 0.0004 0.00041890144348145
SELECT value FROM productattributes WHERE product_id = '290575' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
605 0.0001 0.00013208389282227
UPDATE products SET price = '549500' WHERE id = '290575'
606 0.0425 0.042542934417725
SELECT p.id,p.parent_id, o.price FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND hidden = 0 AND offers > 0 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 24
607 0.0002 0.0002140998840332
UPDATE template_options SET value = 'a:10:{s:14:\"populationtype\";s:9:\"automatic\";s:12:\"productcount\";s:1:\"6\";s:12:\"maxsalesrank\";s:0:\"\";s:8:\"minprice\";s:1:\"0\";s:8:\"maxprice\";s:1:\"0\";s:9:\"minimages\";s:0:\"\";s:10:\"updatetime\";s:5:\"86400\";s:13:\"selectiontype\";s:6:\"random\";s:11:\"lastupdated\";i:1560756407;s:8:\"products\";a:6:{i:2;s:6:\"290575\";i:4;s:6:\"410588\";i:5;s:6:\"412927\";i:13;s:6:\"407831\";i:16;s:6:\"407620\";i:19;s:6:\"131163\";}}' WHERE id = '177'
608 0.0004 0.00043892860412598
SELECT * FROM products WHERE id IN (290575,410588,412927,407831,407620,131163) ORDER BY FIELD(id, 290575,410588,412927,407831,407620,131163 )
609 0.0006 0.00057482719421387
SELECT * FROM productimages WHERE product_id = '290575' ORDER BY sortorder ASC
610 0.0002 0.00022006034851074
SELECT * FROM product_image_select WHERE product_id = '290575'
611 0.0001 0.00012397766113281
SELECT * FROM productcustomimages WHERE product_id = '290575'
612 0.0034 0.0034120082855225
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '290575' AND a.name = n.originalname
613 0.0002 0.00018906593322754
SELECT * FROM productoffers WHERE product_id = '290575' AND merchantid = 'ATVPDKIKX0DER'
614 0.0002 0.0001988410949707
SELECT * FROM productoffers
                WHERE product_id = '290575' AND price > 0
                ORDER BY price ASC LIMIT 1
615 0.0004 0.00042295455932617
SELECT value FROM productattributes WHERE product_id = '290575' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
616 0.0001 0.0001218318939209
UPDATE products SET price = '549500' WHERE id = '290575'
617 0.0002 0.00018310546875
SELECT * FROM productimages WHERE product_id = '410588' ORDER BY sortorder ASC
618 0.0002 0.00020790100097656
SELECT * FROM product_image_select WHERE product_id = '410588'
619 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '410588'
620 0.0020 0.0019779205322266
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410588' AND a.name = n.originalname
621 0.0002 0.00018095970153809
SELECT * FROM productoffers WHERE product_id = '410588' AND merchantid = 'ATVPDKIKX0DER'
622 0.0002 0.00019478797912598
SELECT * FROM productoffers
                WHERE product_id = '410588' AND price > 0
                ORDER BY price ASC LIMIT 1
623 0.0004 0.00035190582275391
SELECT value FROM productattributes WHERE product_id = '410588' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
624 0.0001 0.00012016296386719
UPDATE products SET price = '269999' WHERE id = '410588'
625 0.0003 0.00025105476379395
SELECT * FROM productimages WHERE product_id = '412927' ORDER BY sortorder ASC
626 0.0002 0.00022101402282715
SELECT * FROM product_image_select WHERE product_id = '412927'
627 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '412927'
628 0.0037 0.0036509037017822
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412927' AND a.name = n.originalname
629 0.0002 0.00019192695617676
SELECT * FROM productoffers WHERE product_id = '412927' AND merchantid = 'ATVPDKIKX0DER'
630 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '412927' AND price > 0
                ORDER BY price ASC LIMIT 1
631 0.0004 0.00043511390686035
SELECT value FROM productattributes WHERE product_id = '412927' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
632 0.0001 0.00011992454528809
UPDATE products SET price = '199900' WHERE id = '412927'
633 0.0002 0.00020408630371094
SELECT * FROM productimages WHERE product_id = '407831' ORDER BY sortorder ASC
634 0.0002 0.0001988410949707
SELECT * FROM product_image_select WHERE product_id = '407831'
635 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '407831'
636 0.0034 0.0033609867095947
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407831' AND a.name = n.originalname
637 0.0002 0.00019097328186035
SELECT * FROM productoffers WHERE product_id = '407831' AND merchantid = 'ATVPDKIKX0DER'
638 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '407831' AND price > 0
                ORDER BY price ASC LIMIT 1
639 0.0004 0.00042009353637695
SELECT value FROM productattributes WHERE product_id = '407831' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
640 0.0001 0.00011801719665527
UPDATE products SET price = '1293' WHERE id = '407831'
641 0.0002 0.00020909309387207
SELECT * FROM productimages WHERE product_id = '407620' ORDER BY sortorder ASC
642 0.0002 0.00020194053649902
SELECT * FROM product_image_select WHERE product_id = '407620'
643 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '407620'
644 0.0023 0.0022540092468262
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407620' AND a.name = n.originalname
645 0.0002 0.00019001960754395
SELECT * FROM productoffers WHERE product_id = '407620' AND merchantid = 'ATVPDKIKX0DER'
646 0.0002 0.00020003318786621
SELECT * FROM productoffers
                WHERE product_id = '407620' AND price > 0
                ORDER BY price ASC LIMIT 1
647 0.0004 0.00036191940307617
SELECT value FROM productattributes WHERE product_id = '407620' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
648 0.0001 0.00011801719665527
UPDATE products SET price = '20323' WHERE id = '407620'
649 0.0002 0.00021886825561523
SELECT * FROM productimages WHERE product_id = '131163' ORDER BY sortorder ASC
650 0.0002 0.00021004676818848
SELECT * FROM product_image_select WHERE product_id = '131163'
651 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '131163'
652 0.0025 0.0025310516357422
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '131163' AND a.name = n.originalname
653 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '131163' AND merchantid = 'ATVPDKIKX0DER'
654 0.0002 0.0001990795135498
SELECT * FROM productoffers
                WHERE product_id = '131163' AND price > 0
                ORDER BY price ASC LIMIT 1
655 0.0004 0.00037288665771484
SELECT value FROM productattributes WHERE product_id = '131163' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
656 0.0001 0.00011920928955078
UPDATE products SET price = '20362' WHERE id = '131163'
657 0.1045 0.10451507568359
SELECT p.id,p.parent_id, o.price 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 24
658 0.0003 0.0002739429473877
UPDATE template_options SET value = 'a:11:{s:14:\"populationtype\";s:9:\"automatic\";s:12:\"productcount\";s:1:\"6\";s:12:\"maxsalesrank\";s:0:\"\";s:8:\"minprice\";s:1:\"0\";s:8:\"maxprice\";s:1:\"0\";s:9:\"minimages\";s:1:\"1\";s:10:\"categories\";s:0:\"\";s:10:\"updatetime\";s:5:\"86400\";s:13:\"selectiontype\";s:6:\"random\";s:11:\"lastupdated\";i:1560756408;s:8:\"products\";a:6:{i:0;s:6:\"398315\";i:3;s:6:\"171938\";i:4;s:6:\"410588\";i:10;s:6:\"370121\";i:14;s:6:\"414188\";i:15;s:6:\"406758\";}}' WHERE id = '181'
659 0.0005 0.00048208236694336
SELECT * FROM products WHERE id IN (398315,171938,410588,370121,414188,406758) ORDER BY FIELD(id, 398315,171938,410588,370121,414188,406758 )
660 0.0002 0.00021505355834961
SELECT * FROM productimages WHERE product_id = '398315' ORDER BY sortorder ASC
661 0.0002 0.00021505355834961
SELECT * FROM product_image_select WHERE product_id = '398315'
662 0.0001 0.00013399124145508
SELECT * FROM productcustomimages WHERE product_id = '398315'
663 0.0025 0.0024950504302979
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398315' AND a.name = n.originalname
664 0.0002 0.00018906593322754
SELECT * FROM productoffers WHERE product_id = '398315' AND merchantid = 'ATVPDKIKX0DER'
665 0.0002 0.0002129077911377
SELECT * FROM productoffers
                WHERE product_id = '398315' AND price > 0
                ORDER BY price ASC LIMIT 1
666 0.0004 0.0003819465637207
SELECT value FROM productattributes WHERE product_id = '398315' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
667 0.0001 0.00012421607971191
UPDATE products SET price = '1999' WHERE id = '398315'
668 0.0006 0.00061488151550293
SELECT * FROM productimages WHERE product_id = '171938' ORDER BY sortorder ASC
669 0.0002 0.0002281665802002
SELECT * FROM product_image_select WHERE product_id = '171938'
670 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '171938'
671 0.0025 0.0025279521942139
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '171938' AND a.name = n.originalname
672 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '171938' AND merchantid = 'ATVPDKIKX0DER'
673 0.0002 0.00020599365234375
SELECT * FROM productoffers
                WHERE product_id = '171938' AND price > 0
                ORDER BY price ASC LIMIT 1
674 0.0004 0.0003809928894043
SELECT value FROM productattributes WHERE product_id = '171938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
675 0.0001 0.00011897087097168
UPDATE products SET price = '389500' WHERE id = '171938'
676 0.0002 0.00017690658569336
SELECT * FROM productimages WHERE product_id = '410588' ORDER BY sortorder ASC
677 0.0002 0.0002129077911377
SELECT * FROM product_image_select WHERE product_id = '410588'
678 0.0001 0.00012803077697754
SELECT * FROM productcustomimages WHERE product_id = '410588'
679 0.0020 0.0019679069519043
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '410588' AND a.name = n.originalname
680 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '410588' AND merchantid = 'ATVPDKIKX0DER'
681 0.0002 0.00019407272338867
SELECT * FROM productoffers
                WHERE product_id = '410588' AND price > 0
                ORDER BY price ASC LIMIT 1
682 0.0004 0.00035214424133301
SELECT value FROM productattributes WHERE product_id = '410588' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
683 0.0001 0.00012993812561035
UPDATE products SET price = '269999' WHERE id = '410588'
684 0.0002 0.00018501281738281
SELECT * FROM productimages WHERE product_id = '370121' ORDER BY sortorder ASC
685 0.0002 0.0001988410949707
SELECT * FROM product_image_select WHERE product_id = '370121'
686 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '370121'
687 0.0027 0.0027189254760742
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '370121' AND a.name = n.originalname
688 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '370121' AND merchantid = 'ATVPDKIKX0DER'
689 0.0002 0.00020003318786621
SELECT * FROM productoffers
                WHERE product_id = '370121' AND price > 0
                ORDER BY price ASC LIMIT 1
690 0.0004 0.00039315223693848
SELECT value FROM productattributes WHERE product_id = '370121' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
691 0.0001 0.00011992454528809
UPDATE products SET price = '9899' WHERE id = '370121'
692 0.0003 0.00028800964355469
SELECT * FROM productimages WHERE product_id = '414188' ORDER BY sortorder ASC
693 0.0002 0.00020098686218262
SELECT * FROM product_image_select WHERE product_id = '414188'
694 0.0001 0.00013303756713867
SELECT * FROM productcustomimages WHERE product_id = '414188'
695 0.0025 0.0025129318237305
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414188' AND a.name = n.originalname
696 0.0002 0.00018095970153809
SELECT * FROM productoffers WHERE product_id = '414188' AND merchantid = 'ATVPDKIKX0DER'
697 0.0002 0.00020694732666016
SELECT * FROM productoffers
                WHERE product_id = '414188' AND price > 0
                ORDER BY price ASC LIMIT 1
698 0.0004 0.00037884712219238
SELECT value FROM productattributes WHERE product_id = '414188' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
699 0.0001 0.00011801719665527
UPDATE products SET price = '9999' WHERE id = '414188'
700 0.0002 0.0001828670501709
SELECT * FROM productimages WHERE product_id = '406758' ORDER BY sortorder ASC
701 0.0002 0.00021481513977051
SELECT * FROM product_image_select WHERE product_id = '406758'
702 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '406758'
703 0.0026 0.0026018619537354
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406758' AND a.name = n.originalname
704 0.0002 0.00019288063049316
SELECT * FROM productoffers WHERE product_id = '406758' AND merchantid = 'ATVPDKIKX0DER'
705 0.0002 0.0001990795135498
SELECT * FROM productoffers
                WHERE product_id = '406758' AND price > 0
                ORDER BY price ASC LIMIT 1
706 0.0004 0.00037693977355957
SELECT value FROM productattributes WHERE product_id = '406758' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
707 0.0001 0.00011897087097168
UPDATE products SET price = '2694' WHERE id = '406758'
708 0.1042 0.10424113273621
SELECT p.id,p.parent_id, o.price 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 24
709 0.0003 0.00026392936706543
UPDATE template_options SET value = 'a:10:{s:14:\"populationtype\";s:9:\"automatic\";s:12:\"productcount\";s:1:\"6\";s:12:\"maxsalesrank\";s:0:\"\";s:8:\"minprice\";s:1:\"0\";s:8:\"maxprice\";s:1:\"0\";s:9:\"minimages\";s:1:\"1\";s:10:\"updatetime\";s:5:\"86400\";s:13:\"selectiontype\";s:6:\"random\";s:11:\"lastupdated\";i:1560756408;s:8:\"products\";a:6:{i:1;s:6:\"407595\";i:3;s:6:\"171938\";i:6;s:6:\"409759\";i:8;s:6:\"408792\";i:9;s:6:\"103845\";i:11;s:6:\"403517\";}}' WHERE id = '183'
710 0.0005 0.00046396255493164
SELECT * FROM products WHERE id IN (407595,171938,409759,408792,103845,403517) ORDER BY FIELD(id, 407595,171938,409759,408792,103845,403517 )
711 0.0002 0.0002439022064209
SELECT * FROM productimages WHERE product_id = '407595' ORDER BY sortorder ASC
712 0.0002 0.00020694732666016
SELECT * FROM product_image_select WHERE product_id = '407595'
713 0.0001 0.00012397766113281
SELECT * FROM productcustomimages WHERE product_id = '407595'
714 0.0034 0.0033669471740723
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407595' AND a.name = n.originalname
715 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '407595' AND merchantid = 'ATVPDKIKX0DER'
716 0.0002 0.00020480155944824
SELECT * FROM productoffers
                WHERE product_id = '407595' AND price > 0
                ORDER BY price ASC LIMIT 1
717 0.0004 0.00043582916259766
SELECT value FROM productattributes WHERE product_id = '407595' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
718 0.0001 0.00012397766113281
UPDATE products SET price = '2497' WHERE id = '407595'
719 0.0006 0.0005950927734375
SELECT * FROM productimages WHERE product_id = '171938' ORDER BY sortorder ASC
720 0.0002 0.00023603439331055
SELECT * FROM product_image_select WHERE product_id = '171938'
721 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '171938'
722 0.0026 0.0025501251220703
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '171938' AND a.name = n.originalname
723 0.0002 0.00018811225891113
SELECT * FROM productoffers WHERE product_id = '171938' AND merchantid = 'ATVPDKIKX0DER'
724 0.0002 0.00020599365234375
SELECT * FROM productoffers
                WHERE product_id = '171938' AND price > 0
                ORDER BY price ASC LIMIT 1
725 0.0004 0.00037908554077148
SELECT value FROM productattributes WHERE product_id = '171938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
726 0.0001 0.00012898445129395
UPDATE products SET price = '389500' WHERE id = '171938'
727 0.0002 0.00020480155944824
SELECT * FROM productimages WHERE product_id = '409759' ORDER BY sortorder ASC
728 0.0002 0.00020909309387207
SELECT * FROM product_image_select WHERE product_id = '409759'
729 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '409759'
730 0.0028 0.0027680397033691
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '409759' AND a.name = n.originalname
731 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '409759' AND merchantid = 'ATVPDKIKX0DER'
732 0.0002 0.0001978874206543
SELECT * FROM productoffers
                WHERE product_id = '409759' AND price > 0
                ORDER BY price ASC LIMIT 1
733 0.0004 0.00040197372436523
SELECT value FROM productattributes WHERE product_id = '409759' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
734 0.0001 0.00012111663818359
UPDATE products SET price = '229000' WHERE id = '409759'
735 0.0002 0.00019598007202148
SELECT * FROM productimages WHERE product_id = '408792' ORDER BY sortorder ASC
736 0.0002 0.00021004676818848
SELECT * FROM product_image_select WHERE product_id = '408792'
737 0.0001 0.00012588500976562
SELECT * FROM productcustomimages WHERE product_id = '408792'
738 0.0036 0.0036201477050781
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408792' AND a.name = n.originalname
739 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '408792' AND merchantid = 'ATVPDKIKX0DER'
740 0.0002 0.00021004676818848
SELECT * FROM productoffers
                WHERE product_id = '408792' AND price > 0
                ORDER BY price ASC LIMIT 1
741 0.0004 0.00042986869812012
SELECT value FROM productattributes WHERE product_id = '408792' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
742 0.0001 0.00012087821960449
UPDATE products SET price = '13499' WHERE id = '408792'
743 0.0002 0.00019383430480957
SELECT * FROM productimages WHERE product_id = '103845' ORDER BY sortorder ASC
744 0.0002 0.00020909309387207
SELECT * FROM product_image_select WHERE product_id = '103845'
745 0.0001 0.00012016296386719
SELECT * FROM productcustomimages WHERE product_id = '103845'
746 0.0024 0.0023801326751709
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '103845' AND a.name = n.originalname
747 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '103845' AND merchantid = 'ATVPDKIKX0DER'
748 0.0002 0.00021195411682129
SELECT * FROM productoffers
                WHERE product_id = '103845' AND price > 0
                ORDER BY price ASC LIMIT 1
749 0.0004 0.00037503242492676
SELECT value FROM productattributes WHERE product_id = '103845' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
750 0.0001 0.00011992454528809
UPDATE products SET price = '11900' WHERE id = '103845'
751 0.0003 0.00031304359436035
SELECT * FROM productimages WHERE product_id = '403517' ORDER BY sortorder ASC
752 0.0002 0.00023198127746582
SELECT * FROM product_image_select WHERE product_id = '403517'
753 0.0001 0.00012516975402832
SELECT * FROM productcustomimages WHERE product_id = '403517'
754 0.0029 0.002924919128418
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '403517' AND a.name = n.originalname
755 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '403517' AND merchantid = 'ATVPDKIKX0DER'
756 0.0002 0.00019717216491699
SELECT * FROM productoffers
                WHERE product_id = '403517' AND price > 0
                ORDER BY price ASC LIMIT 1
757 0.0004 0.00041007995605469
SELECT value FROM productattributes WHERE product_id = '403517' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
758 0.0001 0.0001227855682373
UPDATE products SET price = '6699' WHERE id = '403517'
759 0.0004 0.00041294097900391
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
760 0.0001 0.00013303756713867
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
761 0.0001 0.00012087821960449
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
762 0.0001 0.00011801719665527
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
763 0.0001 0.00011801719665527
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
764 0.0004 0.00040602684020996
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
765 0.0001 0.00012588500976562
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
766 0.0001 0.00011897087097168
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
767 0.0001 0.00011682510375977
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
768 0.0009 0.00092101097106934
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
769 0.0003 0.0003058910369873
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
770 0.0003 0.00028800964355469
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
771 0.0003 0.00032591819763184
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'
772 0.0003 0.00030112266540527
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'