Tactical Equipment - Survivalist Equipment

Hawke Sport Optics HK6358 Endurance 4-12X42 30/30 IR Scope, Black from Sportsman Supply Inc.

Price: $224.98
Product prices and availability are accurate as of 2019-06-15 11:47:44 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 - stock arriving soon
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

Tactical Survivalist : Combat Gear : Survival Gear : Combat Equipment is happy to bring you the fantastic Hawke Sport Optics HK6358 Endurance 4-12X42 30/30 IR Scope, Black today at this special price.

With so many competing tactical, combat and survival products on offer currently, it is great to have a brand that you can trust. The Hawke Sport Optics HK6358 Endurance 4-12X42 30/30 IR Scope, Black is certainly all that and will be a superb acquisition for your combat gear or tactical ability.

We pride ourselves on providing the best quality survivalist gear for all your on the job requirements.

For this reduced price, the Hawke Sport Optics HK6358 Endurance 4-12X42 30/30 IR Scope, Black is greatly recommended and is always a regular choice for lots of like minded people. Sportsman Supply Inc. have passed on some excellent touches and this results in better value.

Manufacturer Description

With a design focus on searching, the Endurance LER (Long Eye Relief) line of scopes delivers kind and function as reputable and rugged as the American hunter. Developed in the UK, the Endurance LER family supplies the shooter a feature-rich scope. The Marksman reticle is offered in the 3-9x40 - designed to be precise on the scope's maximum zoom.

Product Features

1" Mono-tube design - handles heavy recoil Glass etched Red Illuminated Reticle 4.5 inch eye relief designed for magnum loads Infinitely adjustable stepless side rheostat Coil erector spring - no shift in zero

Write a Review

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
8.8509500026703 831 3.6253 0


No Amazon API Requests Made.


App Debug - Total Time 8.8509500026703 seconds

Number Time From Start Name Description
1 0.53721308708191 Initialise Initialise FSB Function
2 0.55034804344177 App Controller Start Start of the App controller (called before the controller of every page)
3 0.56179809570312 Start of getCategoryListByGroup Function Before first category groups query
4 0.56198310852051 After initial query Before first category groups query
5 0.56198406219482 Get Category List for Group Before the call to getCategoryList function
6 0.56198716163635 Start of GetCategoryList function Start of the function
7 0.56199097633362 Before getting categories Query to get specific category list
8 0.56262111663818 After getting categories Query to get specific category list
9 0.56262302398682 Before getting category custom Before call to function getCategoryCustom
10 0.56446003913879 After getting category custom After call to function getCategoryCustom
11 0.56446313858032 Before getting category custom Before call to function getCategoryCustom
12 0.57648706436157 After getting category custom After call to function getCategoryCustom
13 0.5764901638031 Before getting category custom Before call to function getCategoryCustom
14 0.58333897590637 After getting category custom After call to function getCategoryCustom
15 0.5833420753479 Before getting category custom Before call to function getCategoryCustom
16 0.58833312988281 After getting category custom After call to function getCategoryCustom
17 0.58833503723145 End of GetCategoryList function End of the function
18 0.58834505081177 Get Category List for Group Before the call to getCategoryList function
19 0.5883469581604 Start of GetCategoryList function Start of the function
20 0.58835005760193 Before getting categories Query to get specific category list
21 0.58887195587158 After getting categories Query to get specific category list
22 0.58887314796448 Before getting category custom Before call to function getCategoryCustom
23 0.59534406661987 After getting category custom After call to function getCategoryCustom
24 0.59534597396851 Before getting category custom Before call to function getCategoryCustom
25 0.60595107078552 After getting category custom After call to function getCategoryCustom
26 0.60595297813416 End of GetCategoryList function End of the function
27 0.60596013069153 Get Category List for Group Before the call to getCategoryList function
28 0.60596203804016 Start of GetCategoryList function Start of the function
29 0.60596513748169 Before getting categories Query to get specific category list
30 0.6067271232605 After getting categories Query to get specific category list
31 0.60672903060913 Before getting category custom Before call to function getCategoryCustom
32 0.61599612236023 After getting category custom After call to function getCategoryCustom
33 0.61599898338318 Before getting category custom Before call to function getCategoryCustom
34 0.63344216346741 After getting category custom After call to function getCategoryCustom
35 0.63344502449036 Before getting category custom Before call to function getCategoryCustom
36 0.63933610916138 After getting category custom After call to function getCategoryCustom
37 0.63933801651001 Before getting category custom Before call to function getCategoryCustom
38 0.64519906044006 After getting category custom After call to function getCategoryCustom
39 0.64520215988159 Before getting category custom Before call to function getCategoryCustom
40 0.65140795707703 After getting category custom After call to function getCategoryCustom
41 0.65141105651855 Before getting category custom Before call to function getCategoryCustom
42 0.67311811447144 After getting category custom After call to function getCategoryCustom
43 0.67312002182007 Before getting category custom Before call to function getCategoryCustom
44 0.67720198631287 After getting category custom After call to function getCategoryCustom
45 0.67720413208008 Before getting category custom Before call to function getCategoryCustom
46 0.68182611465454 After getting category custom After call to function getCategoryCustom
47 0.68182802200317 End of GetCategoryList function End of the function
48 0.68184304237366 Get Category List for Group Before the call to getCategoryList function
49 0.68184494972229 Start of GetCategoryList function Start of the function
50 0.68184804916382 Before getting categories Query to get specific category list
51 0.68229103088379 After getting categories Query to get specific category list
52 0.68229198455811 Before getting category custom Before call to function getCategoryCustom
53 0.68457412719727 After getting category custom After call to function getCategoryCustom
54 0.68457698822021 Before getting category custom Before call to function getCategoryCustom
55 0.68689107894897 After getting category custom After call to function getCategoryCustom
56 0.68689298629761 End of GetCategoryList function End of the function
57 0.68689894676208 Get Category List for Group Before the call to getCategoryList function
58 0.6869010925293 Start of GetCategoryList function Start of the function
59 0.68690395355225 Before getting categories Query to get specific category list
60 0.68721604347229 After getting categories Query to get specific category list
61 0.68721699714661 Before getting category custom Before call to function getCategoryCustom
62 0.69212007522583 After getting category custom After call to function getCategoryCustom
63 0.69212102890015 End of GetCategoryList function End of the function
64 0.69212698936462 End of getCategoryListByGroup Function Before return()
65 0.74325799942017 App Controller End End of the App controller (called before the controller of every page)
66 0.74387407302856 Product Start Start of the product info controller
67 0.74471616744995 Cache file not found Starting get product details
68 0.77489709854126 Related products Start getting related products if enabled
69 0.77489900588989 Related Products Start Before the related products are found
70 0.77489995956421 Related Products Keywords Before the related product keywords are found
71 0.7749080657959 Create Keyword List Function Start of function
72 0.77623605728149 Create Keyword List Function After looping provided content - 1029 keywords found
73 0.84394598007202 Create Keyword List Function After looping initial keyword list - 965 keywords remaining
74 0.84419298171997 Create Keyword List Function After reducing keyword list
75 0.84516501426697 Create Keyword List Function After selecting by scoring keywords
76 0.84517216682434 Create Keyword List Function After final loop of keywords
77 0.84517407417297 Related Products Keywords After the related product keywords are found
78 1.3596451282501 Related Products End After the related products are found
79 1.5499639511108 Start Remote Request http://svcs.ebay.com/services/search/FindingServic...
80 2.0234899520874 End Remote Request http://svcs.ebay.com/services/search/FindingServic...
81 2.2146489620209 Start Remote Request http://svcs.ebay.com/services/search/FindingServic...
82 2.8742780685425 End Remote Request http://svcs.ebay.com/services/search/FindingServic...
83 3.0575611591339 Start Remote Request http://svcs.ebay.com/services/search/FindingServic...
84 3.5378730297089 End Remote Request http://svcs.ebay.com/services/search/FindingServic...
85 3.7294931411743 Start Remote Request http://svcs.ebay.com/services/search/FindingServic...
86 4.1234650611877 End Remote Request http://svcs.ebay.com/services/search/FindingServic...
87 4.3178391456604 Start Remote Request http://svcs.ebay.com/services/search/FindingServic...
88 4.6922199726105 End Remote Request http://svcs.ebay.com/services/search/FindingServic...
89 4.8834979534149 Start Remote Request http://svcs.ebay.com/services/search/FindingServic...
90 5.1915040016174 End Remote Request http://svcs.ebay.com/services/search/FindingServic...
91 5.3821020126343 Start Remote Request http://svcs.ebay.com/services/search/FindingServic...
92 5.6800661087036 End Remote Request http://svcs.ebay.com/services/search/FindingServic...
93 5.8687181472778 Start Remote Request http://svcs.ebay.com/services/search/FindingServic...
94 6.1779520511627 End Remote Request http://svcs.ebay.com/services/search/FindingServic...
95 6.3683409690857 Start Remote Request http://svcs.ebay.com/services/search/FindingServic...
96 6.6692080497742 End Remote Request http://svcs.ebay.com/services/search/FindingServic...
97 6.8591680526733 Start Remote Request http://svcs.ebay.com/services/search/FindingServic...
98 7.1471590995789 End Remote Request http://svcs.ebay.com/services/search/FindingServic...
99 7.3296051025391 Start Remote Request http://svcs.ebay.com/services/search/FindingServic...
100 7.6475460529327 End Remote Request http://svcs.ebay.com/services/search/FindingServic...
101 7.8306219577789 Start Remote Request http://svcs.ebay.com/services/search/FindingServic...
102 8.1597421169281 End Remote Request http://svcs.ebay.com/services/search/FindingServic...
103 8.3805329799652 Product End End of the product info controller (Product Info)
104 8.3809061050415 App_after Controller Start Start of the App_after controller (called after the controller of every page)
105 8.3810141086578 Before Get Options Before the call to getOptions in the tpl class
106 8.8055031299591 After Get Options After the call to getOptions in the tpl class
107 8.8056991100311 App_after Controller End End of the App_after controller (called after the controller of every page)
108 8.8057131767273 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
109 8.8240461349487 Product Info: After Smarty Fetch After the product.tpl template is fetched
110 8.8240520954132 Product Info: Before Template Display Before the template is displayed
111 8.8509161472321 Product Info: After Template Display After the template is displayed
112 8.8509321212769 Finalizing debug Before the debug is output to the page.
113 8.850949048996 End of App This is the end of the app logging, final timestamp


Query Debug - 831 Database Queries. Total time 3.6253 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0002 0.00016999244689941
SELECT value FROM parameters WHERE `parameter` = 'BAD_BOTS_ENABLER'
2 0.0005 0.0005028247833252
SHOW TABLES LIKE 'bad_bots'
3 0.0002 0.00017213821411133
SELECT value FROM parameters WHERE `parameter` = 'STORE_WHITELISTED_IPS'
4 0.0002 0.00015401840209961
SELECT * FROM `bad_bots`
5 0.0005 0.00047111511230469
SELECT parameter, value FROM parameters
6 0.0002 0.00016307830810547
SET time_zone = 'Europe/London'
7 0.0003 0.00033307075500488
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0001 0.00014710426330566
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0001 0.0001068115234375
delete from cachefiles
10 0.0002 0.00024199485778809
SELECT id FROM pages WHERE pagename = 'hawke-sport-optics-hk6358-endurance-4-12x42-3030-ir-scope-black' LIMIT 1
11 0.0002 0.00023603439331055
SELECT id FROM products WHERE pagename = 'hawke-sport-optics-hk6358-endurance-4-12x42-3030-ir-scope-black' AND hidden = 0 LIMIT 1
12 0.0008 0.00078415870666504
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
13 0.0097 0.0096511840820312
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
14 0.0003 0.00025510787963867
SELECT * FROM pages WHERE pagename = 'hawke-sport-optics-hk6358-endurance-4-12x42-3030-ir-scope-black'
15 0.0002 0.0001680850982666
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0006 0.00059103965759277
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0005 0.00048208236694336
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.0002 0.00022697448730469
SELECT id FROM categories WHERE parent_id = '49'
19 0.0004 0.00043606758117676
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.0001530647277832
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.00015020370483398
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.00017404556274414
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '49'
23 0.0001 0.00012612342834473
SELECT * FROM categorygroups WHERE id = '1'
24 0.0030 0.0029721260070801
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.00025296211242676
SELECT id FROM categories WHERE parent_id = '50'
26 0.0002 0.00020003318786621
SELECT id FROM categories WHERE parent_id = '96'
27 0.0002 0.00020599365234375
SELECT id FROM categories WHERE parent_id = '97'
28 0.0002 0.0001988410949707
SELECT id FROM categories WHERE parent_id = '111'
29 0.0002 0.0001981258392334
SELECT id FROM categories WHERE parent_id = '129'
30 0.0070 0.0070490837097168
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.00022101402282715
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.00020599365234375
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.00021505355834961
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '50'
34 0.0001 0.00014615058898926
SELECT * FROM categorygroups WHERE id = '1'
35 0.0028 0.0028109550476074
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.00032997131347656
SELECT id FROM categories WHERE parent_id = '80'
37 0.0029 0.002885103225708
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.00018906593322754
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.0002 0.00019598007202148
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.0001990795135498
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '80'
41 0.0001 0.00014686584472656
SELECT * FROM categorygroups WHERE id = '1'
42 0.0014 0.0013837814331055
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.0003 0.0003209114074707
SELECT id FROM categories WHERE parent_id = '51'
44 0.0003 0.00025391578674316
SELECT id FROM categories WHERE parent_id = '101'
45 0.0022 0.0022008419036865
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.00018811225891113
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.00019001960754395
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.00020599365234375
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '51'
49 0.0001 0.00014281272888184
SELECT * FROM categorygroups WHERE id = '1'
50 0.0005 0.00049710273742676
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
51 0.0028 0.0027930736541748
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.0003 0.00031614303588867
SELECT id FROM categories WHERE parent_id = '30'
53 0.0026 0.0026381015777588
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.00016117095947266
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.0002 0.00017094612121582
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.00017499923706055
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
57 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '2'
58 0.0048 0.004784107208252
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.00026893615722656
SELECT id FROM categories WHERE parent_id = '61'
60 0.0048 0.0048460960388184
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.00015902519226074
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.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 (61)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
63 0.0002 0.00016307830810547
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '61'
64 0.0001 0.00012302398681641
SELECT * FROM categorygroups WHERE id = '2'
65 0.0007 0.00068402290344238
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '10'  AND hidden = 0 ORDER BY sortorder ASC
66 0.0041 0.004119873046875
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.00027918815612793
SELECT id FROM categories WHERE parent_id = '64'
68 0.0041 0.0041460990905762
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.00016689300537109
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.00014901161193848
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.0001678466796875
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '64'
72 0.0001 0.00013589859008789
SELECT * FROM categorygroups WHERE id = '10'
73 0.0082 0.0082290172576904
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.0003058910369873
SELECT id FROM categories WHERE parent_id = '65'
75 0.0082 0.0081741809844971
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.00018000602722168
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.0001518726348877
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.00017118453979492
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '65'
79 0.0001 0.00012803077697754
SELECT * FROM categorygroups WHERE id = '10'
80 0.0024 0.0024299621582031
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.0002739429473877
SELECT id FROM categories WHERE parent_id = '81'
82 0.0025 0.0024969577789307
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.0001530647277832
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.0002 0.00015807151794434
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.00016403198242188
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '81'
86 0.0001 0.00012493133544922
SELECT * FROM categorygroups WHERE id = '10'
87 0.0024 0.0024468898773193
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.00026988983154297
SELECT id FROM categories WHERE parent_id = '31'
89 0.0025 0.0024569034576416
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.00015091896057129
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.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 (31)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
92 0.0002 0.00017499923706055
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
93 0.0001 0.00012612342834473
SELECT * FROM categorygroups WHERE id = '10'
94 0.0022 0.0022139549255371
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.00025796890258789
SELECT id FROM categories WHERE parent_id = '66'
96 0.0002 0.00020289421081543
SELECT id FROM categories WHERE parent_id = '131'
97 0.0028 0.0028238296508789
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.00015592575073242
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.0002 0.0001518726348877
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.00015997886657715
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '66'
101 0.0001 0.00012493133544922
SELECT * FROM categorygroups WHERE id = '10'
102 0.0094 0.0093920230865479
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.00029683113098145
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.00020003318786621
SELECT id FROM categories WHERE parent_id = '98'
106 0.0002 0.0001990795135498
SELECT id FROM categories WHERE parent_id = '99'
107 0.0002 0.00020813941955566
SELECT id FROM categories WHERE parent_id = '110'
108 0.0002 0.00020098686218262
SELECT id FROM categories WHERE parent_id = '130'
109 0.0102 0.010212898254395
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.00017595291137695
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.00015497207641602
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.00018906593322754
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
113 0.0001 0.00012898445129395
SELECT * FROM categorygroups WHERE id = '10'
114 0.0015 0.0015490055084229
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.00026893615722656
SELECT id FROM categories WHERE parent_id = '32'
116 0.0016 0.0015869140625
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.00014591217041016
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.00014495849609375
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.00017213821411133
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
120 0.0001 0.00012493133544922
SELECT * FROM categorygroups WHERE id = '10'
121 0.0019 0.0018541812896729
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.00025296211242676
SELECT id FROM categories WHERE parent_id = '89'
123 0.0018 0.0018391609191895
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.00014805793762207
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.00014495849609375
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.00016689300537109
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '89'
127 0.0001 0.00012516975402832
SELECT * FROM categorygroups WHERE id = '10'
128 0.0004 0.00041699409484863
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '17'  AND hidden = 0 ORDER BY sortorder ASC
129 0.0007 0.00067996978759766
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.0007 0.00069689750671387
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.00014400482177734
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.00014400482177734
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.00016498565673828
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '84'
135 0.0001 0.00012302398681641
SELECT * FROM categorygroups WHERE id = '17'
136 0.0007 0.00069904327392578
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.00023484230041504
SELECT id FROM categories WHERE parent_id = '90'
138 0.0007 0.00072908401489258
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.00014400482177734
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.00014305114746094
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.00015497207641602
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '90'
142 0.0001 0.00012111663818359
SELECT * FROM categorygroups WHERE id = '17'
143 0.0003 0.00029802322387695
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '20'  AND hidden = 0 ORDER BY sortorder ASC
144 0.0020 0.0019850730895996
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.00024008750915527
SELECT id FROM categories WHERE parent_id = '92'
146 0.0020 0.0020129680633545
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.00014615058898926
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.00014305114746094
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.0002 0.00015807151794434
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '92'
150 0.0001 0.00012612342834473
SELECT * FROM categorygroups WHERE id = '20'
151 0.0053 0.0053110122680664
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.00018906593322754
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
154 0.0002 0.00015592575073242
SELECT * FROM sideboxes_pages WHERE sidebox_id = '1'
155 0.0002 0.00018095970153809
SELECT * FROM pages WHERE id = '67'
156 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '82'
157 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '84'
158 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '94'
159 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '116'
160 0.0002 0.00021505355834961
SELECT * FROM pages WHERE id = '52'
161 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '135'
162 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '245'
163 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '269'
164 0.0002 0.00020098686218262
SELECT * FROM pages WHERE id = '275'
165 0.0002 0.00020194053649902
SELECT * FROM pages WHERE id = '280'
166 0.0002 0.00019001960754395
SELECT * FROM pages WHERE id = '357'
167 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '379'
168 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '401'
169 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '450'
170 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '454'
171 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '457'
172 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '458'
173 0.0001 0.00014996528625488
SELECT * FROM sideboxes_pages WHERE sidebox_id = '2'
174 0.0002 0.00016117095947266
SELECT * FROM pages WHERE id = '41'
175 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '43'
176 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '44'
177 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '68'
178 0.0002 0.00020599365234375
SELECT * FROM pages WHERE id = '80'
179 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '85'
180 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '97'
181 0.0002 0.00015377998352051
SELECT * FROM pages WHERE id = '107'
182 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '108'
183 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '128'
184 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '133'
185 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '148'
186 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '217'
187 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '228'
188 0.0002 0.00015878677368164
SELECT * FROM pages WHERE id = '257'
189 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '271'
190 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '286'
191 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = '287'
192 0.0002 0.00015377998352051
SELECT * FROM pages WHERE id = '291'
193 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '380'
194 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '344'
195 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '354'
196 0.0002 0.00018906593322754
SELECT * FROM pages WHERE id = '363'
197 0.0002 0.00020003318786621
SELECT * FROM pages WHERE id = '364'
198 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '368'
199 0.0002 0.00018405914306641
SELECT * FROM pages WHERE id = '369'
200 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '400'
201 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '463'
202 0.0002 0.00016498565673828
SELECT * FROM sideboxes_pages WHERE sidebox_id = '33'
203 0.0002 0.00023889541625977
SELECT * FROM pages WHERE id = '66'
204 0.0002 0.00020503997802734
SELECT * FROM pages WHERE id = '77'
205 0.0002 0.00019407272338867
SELECT * FROM pages WHERE id = '90'
206 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '414'
207 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '119'
208 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '406'
209 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '149'
210 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '150'
211 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '412'
212 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '162'
213 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '164'
214 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '167'
215 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '180'
216 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '187'
217 0.0002 0.00019407272338867
SELECT * FROM pages WHERE id = '265'
218 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '268'
219 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '411'
220 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '290'
221 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '413'
222 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '409'
223 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '327'
224 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '336'
225 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '351'
226 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '358'
227 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '360'
228 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '362'
229 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '366'
230 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '370'
231 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '377'
232 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '386'
233 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '408'
234 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '415'
235 0.0002 0.00016117095947266
SELECT * FROM pages WHERE id = '416'
236 0.0002 0.00019598007202148
SELECT * FROM pages WHERE id = '419'
237 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '423'
238 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '427'
239 0.0002 0.00017809867858887
SELECT * FROM pages WHERE id = '428'
240 0.0001 0.0001368522644043
SELECT * FROM pages WHERE id = '432'
241 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '433'
242 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '436'
243 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '437'
244 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '461'
245 0.0002 0.00017499923706055
SELECT * FROM pages WHERE id = '464'
246 0.0001 0.00014591217041016
SELECT * FROM sideboxes_pages WHERE sidebox_id = '34'
247 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '74'
248 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '137'
249 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '145'
250 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '156'
251 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '407'
252 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '410'
253 0.0002 0.00017309188842773
SELECT * FROM pages WHERE id = '266'
254 0.0002 0.00022506713867188
SELECT * FROM pages WHERE id = '316'
255 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '332'
256 0.0002 0.00018000602722168
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.0001 0.00014781951904297
SELECT * FROM pages WHERE id = '389'
260 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '397'
261 0.0002 0.00016880035400391
SELECT * FROM pages WHERE id = '449'
262 0.0002 0.00016212463378906
SELECT * FROM sideboxes_pages WHERE sidebox_id = '35'
263 0.0002 0.0001981258392334
SELECT * FROM pages WHERE id = '42'
264 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '79'
265 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '86'
266 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '95'
267 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '102'
268 0.0001 0.00014019012451172
SELECT * FROM pages WHERE id = '109'
269 0.0002 0.00022602081298828
SELECT * FROM pages WHERE id = '114'
270 0.0002 0.00019001960754395
SELECT * FROM pages WHERE id = '121'
271 0.0002 0.00021982192993164
SELECT * FROM pages WHERE id = '138'
272 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '142'
273 0.0002 0.0001981258392334
SELECT * FROM pages WHERE id = '62'
274 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '157'
275 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '246'
276 0.0002 0.00020098686218262
SELECT * FROM pages WHERE id = '276'
277 0.0002 0.00020790100097656
SELECT * FROM pages WHERE id = '278'
278 0.0002 0.00023293495178223
SELECT * FROM pages WHERE id = '279'
279 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '317'
280 0.0001 0.00014781951904297
SELECT * FROM pages WHERE id = '405'
281 0.0002 0.00018000602722168
SELECT * FROM pages WHERE id = '343'
282 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '345'
283 0.0002 0.00020003318786621
SELECT * FROM pages WHERE id = '346'
284 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '347'
285 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '348'
286 0.0001 0.00014877319335938
SELECT * FROM pages WHERE id = '349'
287 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '381'
288 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '392'
289 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '393'
290 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '394'
291 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '395'
292 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '399'
293 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '421'
294 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = '426'
295 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '430'
296 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '431'
297 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '434'
298 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '435'
299 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '440'
300 0.0002 0.00015783309936523
SELECT * FROM pages WHERE id = '441'
301 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '451'
302 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = '453'
303 0.0001 0.00013899803161621
SELECT * FROM sideboxes_pages WHERE sidebox_id = '37'
304 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '146'
305 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '158'
306 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '163'
307 0.0002 0.00024509429931641
SELECT * FROM pages WHERE id = '293'
308 0.0002 0.00015115737915039
SELECT * FROM pages WHERE id = '340'
309 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '417'
310 0.0001 0.00013995170593262
SELECT * FROM sideboxes_pages WHERE sidebox_id = '40'
311 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '173'
312 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '181'
313 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '288'
314 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '299'
315 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '300'
316 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '383'
317 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '385'
318 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '438'
319 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '442'
320 0.0001 0.0001380443572998
SELECT * FROM sideboxes_pages WHERE sidebox_id = '38'
321 0.0003 0.00025296211242676
SELECT * FROM pages WHERE id = '103'
322 0.0002 0.00022602081298828
SELECT * FROM pages WHERE id = '134'
323 0.0001 0.00014519691467285
SELECT * FROM pages WHERE id = '139'
324 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '143'
325 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '234'
326 0.0002 0.0001678466796875
SELECT * FROM pages WHERE id = '248'
327 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '260'
328 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '398'
329 0.0002 0.0001518726348877
SELECT * FROM sideboxes_pages WHERE sidebox_id = '29'
330 0.0002 0.00016379356384277
SELECT * FROM pages WHERE id = '61'
331 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '87'
332 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '104'
333 0.0002 0.0001988410949707
SELECT * FROM pages WHERE id = '115'
334 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '124'
335 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '144'
336 0.0002 0.00017189979553223
SELECT * FROM pages WHERE id = '151'
337 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '199'
338 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '200'
339 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '304'
340 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = '321'
341 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '333'
342 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '350'
343 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '378'
344 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '422'
345 0.0002 0.00017285346984863
SELECT * FROM pages WHERE id = '425'
346 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '443'
347 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '444'
348 0.0002 0.00016283988952637
SELECT * FROM pages WHERE id = '445'
349 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '446'
350 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '447'
351 0.0002 0.00016689300537109
SELECT * FROM pages WHERE id = '448'
352 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '455'
353 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '456'
354 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = '459'
355 0.0002 0.00017905235290527
SELECT * FROM pages WHERE id = '460'
356 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '462'
357 0.0001 0.00014209747314453
SELECT * FROM sideboxes_pages WHERE sidebox_id = '32'
358 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '153'
359 0.0002 0.0002140998840332
SELECT * FROM pages WHERE id = '182'
360 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '238'
361 0.0001 0.00014519691467285
SELECT * FROM pages WHERE id = '240'
362 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '242'
363 0.0001 0.0001370906829834
SELECT * FROM pages WHERE id = '252'
364 0.0001 0.00013589859008789
SELECT * FROM pages WHERE id = '253'
365 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = '262'
366 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '267'
367 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '420'
368 0.0001 0.0001370906829834
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
369 0.0001 0.00011897087097168
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 
370 0.0001 0.00011801719665527
SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
371 0.0014 0.0014400482177734
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
372 0.0002 0.00015687942504883
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
373 0.0001 0.00012111663818359
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SECRET_KEY' 
374 0.0001 0.00011706352233887
SELECT value FROM parameters WHERE parameter = 'GOOGLE_RECAPTCHA_TYPE' 
375 0.0003 0.00028705596923828
SELECT * FROM products WHERE pagename = 'hawke-sport-optics-hk6358-endurance-4-12x42-3030-ir-scope-black'
376 0.0002 0.0001680850982666
SELECT * FROM manufacturers WHERE id = '858'
377 0.0008 0.00076985359191895
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '858'
378 0.0001 0.00012493133544922
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '858' LIMIT 1
379 0.0007 0.00072383880615234
SELECT pagename, id FROM products p WHERE manufacturer_id = '858' ORDER BY RAND() LIMIT 1
380 0.0002 0.00020098686218262
SELECT * FROM productimages WHERE product_id = '404905' ORDER BY sortorder ASC
381 0.0007 0.00066995620727539
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '858'
382 0.0007 0.00072789192199707
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '858'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
383 0.0001 0.00012803077697754
SELECT * FROM manufacturerimages WHERE manufacturer_id = '858'
384 0.0001 0.00013494491577148
SELECT category_id FROM products_categories WHERE product_id = '404378'
385 0.0001 0.00014901161193848
SELECT * FROM categories WHERE id = '98'
386 0.0007 0.00073409080505371
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 = 98
387 0.0001 0.00011396408081055
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 98
388 0.0003 0.00025701522827148
SELECT id FROM categories WHERE parent_id = '98'
389 0.0008 0.00077700614929199
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (98)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
390 0.0001 0.00014209747314453
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (98)
				  AND p.disabled = 0 
391 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 (98)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
392 0.0002 0.00016283988952637
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '98'
393 0.0002 0.00019001960754395
SELECT * FROM productimages WHERE product_id = '404378' ORDER BY sortorder ASC
394 0.0002 0.00020790100097656
SELECT * FROM product_image_select WHERE product_id = '404378'
395 0.0001 0.00012516975402832
SELECT * FROM productcustomimages WHERE product_id = '404378'
396 0.0001 0.00011110305786133
SELECT * FROM productfeeds WHERE product_id = '404378' ORDER BY item_date DESC
397 0.0003 0.00034594535827637
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '404378' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
398 0.0004 0.00037002563476562
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '404378' AND t.hidden = 0 AND display_product = 1
399 0.0002 0.00015091896057129
SELECT * FROM tags WHERE id = '2972'
400 0.0036 0.003572940826416
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '2972'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
401 0.0032 0.0032289028167725
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '2972'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
402 0.0031 0.0031170845031738
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '2972' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
403 0.0005 0.00052499771118164
SELECT * FROM productimages WHERE product_id = '79386' ORDER BY sortorder ASC
404 0.0002 0.00019097328186035
SELECT * FROM tags WHERE id = '3345'
405 0.0026 0.0026140213012695
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '3345'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
406 0.0025 0.0025451183319092
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '3345'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
407 0.0023 0.0023179054260254
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '3345' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
408 0.0003 0.00030708312988281
SELECT * FROM productimages WHERE product_id = '232837' ORDER BY sortorder ASC
409 0.0002 0.00016689300537109
SELECT * FROM productamazoncontent WHERE product_id = '404378'
410 0.0022 0.0022060871124268
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '404378' AND a.name = n.originalname
411 0.0002 0.00019288063049316
SELECT * FROM productoffers WHERE product_id = '404378' AND merchantid = 'ATVPDKIKX0DER'
412 0.0002 0.00018501281738281
SELECT * FROM productoffers
                WHERE product_id = '404378' AND price > 0
                ORDER BY price ASC LIMIT 1
413 0.0002 0.00016403198242188
SELECT * FROM productoffers
                WHERE product_id = 404378
                ORDER BY price ASC LIMIT 1
414 0.0002 0.00021505355834961
SELECT value FROM productattributes
                WHERE product_id = '404378'
                AND name = 'ListPriceAmount'
415 0.0001 0.00013494491577148
UPDATE products SET price = '22498' WHERE id = '404378'
416 0.2332 0.23323678970337
SELECT *, MATCH (description, keyfeatures, title) AGAINST ('endurance' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, keyfeatures, title) AGAINST ('endurance' IN BOOLEAN MODE) AND 404378 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
417 0.0005 0.0004730224609375
SELECT * FROM productimages WHERE product_id = '399126' ORDER BY sortorder ASC
418 0.0003 0.0002589225769043
SELECT * FROM product_image_select WHERE product_id = '399126'
419 0.0001 0.00014710426330566
SELECT * FROM productcustomimages WHERE product_id = '399126'
420 0.0028 0.0028209686279297
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '399126' AND a.name = n.originalname
421 0.0002 0.000244140625
SELECT * FROM productoffers WHERE product_id = '399126' AND merchantid = 'ATVPDKIKX0DER'
422 0.0003 0.00025296211242676
SELECT * FROM productoffers
                WHERE product_id = '399126' AND price > 0
                ORDER BY price ASC LIMIT 1
423 0.0004 0.00044107437133789
SELECT value FROM productattributes WHERE product_id = '399126' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
424 0.0002 0.00017213821411133
UPDATE products SET price = '62999' WHERE id = '399126'
425 0.0003 0.00027704238891602
SELECT * FROM productimages WHERE product_id = '407694' ORDER BY sortorder ASC
426 0.0002 0.0002439022064209
SELECT * FROM product_image_select WHERE product_id = '407694'
427 0.0001 0.00014090538024902
SELECT * FROM productcustomimages WHERE product_id = '407694'
428 0.0027 0.0027360916137695
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407694' AND a.name = n.originalname
429 0.0002 0.00021004676818848
SELECT * FROM productoffers WHERE product_id = '407694' AND merchantid = 'ATVPDKIKX0DER'
430 0.0002 0.00022411346435547
SELECT * FROM productoffers
                WHERE product_id = '407694' AND price > 0
                ORDER BY price ASC LIMIT 1
431 0.0004 0.0004119873046875
SELECT value FROM productattributes WHERE product_id = '407694' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
432 0.0001 0.00013303756713867
UPDATE products SET price = '1299' WHERE id = '407694'
433 0.0002 0.00019097328186035
SELECT * FROM productimages WHERE product_id = '408027' ORDER BY sortorder ASC
434 0.0003 0.0002601146697998
SELECT * FROM product_image_select WHERE product_id = '408027'
435 0.0001 0.0001380443572998
SELECT * FROM productcustomimages WHERE product_id = '408027'
436 0.0033 0.0032761096954346
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408027' AND a.name = n.originalname
437 0.0002 0.00018715858459473
SELECT * FROM productoffers WHERE product_id = '408027' AND merchantid = 'ATVPDKIKX0DER'
438 0.0002 0.00021100044250488
SELECT * FROM productoffers
                WHERE product_id = '408027' AND price > 0
                ORDER BY price ASC LIMIT 1
439 0.0004 0.00041699409484863
SELECT value FROM productattributes WHERE product_id = '408027' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
440 0.0001 0.00011897087097168
UPDATE products SET price = '35999' WHERE id = '408027'
441 0.0002 0.00017189979553223
SELECT * FROM productimages WHERE product_id = '408028' ORDER BY sortorder ASC
442 0.0002 0.00022292137145996
SELECT * FROM product_image_select WHERE product_id = '408028'
443 0.0001 0.00012397766113281
SELECT * FROM productcustomimages WHERE product_id = '408028'
444 0.0023 0.0022599697113037
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408028' AND a.name = n.originalname
445 0.0002 0.0001838207244873
SELECT * FROM productoffers WHERE product_id = '408028' AND merchantid = 'ATVPDKIKX0DER'
446 0.0002 0.00019598007202148
SELECT * FROM productoffers
                WHERE product_id = '408028' AND price > 0
                ORDER BY price ASC LIMIT 1
447 0.0004 0.00035309791564941
SELECT value FROM productattributes WHERE product_id = '408028' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
448 0.0001 0.00011897087097168
UPDATE products SET price = '32999' WHERE id = '408028'
449 0.2533 0.25329399108887
SELECT *, MATCH (description, keyfeatures, title) AGAINST ('scope' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, keyfeatures, title) AGAINST ('scope' IN BOOLEAN MODE) AND 404378 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 2
450 0.0005 0.00050497055053711
SELECT * FROM productimages WHERE product_id = '192125' ORDER BY sortorder ASC
451 0.0002 0.00022006034851074
SELECT * FROM product_image_select WHERE product_id = '192125'
452 0.0001 0.00012397766113281
SELECT * FROM productcustomimages WHERE product_id = '192125'
453 0.0023 0.0023181438446045
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '192125' AND a.name = n.originalname
454 0.0002 0.00020694732666016
SELECT * FROM productoffers WHERE product_id = '192125' AND merchantid = 'ATVPDKIKX0DER'
455 0.0002 0.00023603439331055
SELECT * FROM productoffers
                WHERE product_id = '192125' AND price > 0
                ORDER BY price ASC LIMIT 1
456 0.0004 0.00039219856262207
SELECT value FROM productattributes WHERE product_id = '192125' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
457 0.0001 0.0001380443572998
UPDATE products SET price = '44999' WHERE id = '192125'
458 0.0003 0.00031590461730957
SELECT * FROM productimages WHERE product_id = '47380' ORDER BY sortorder ASC
459 0.0002 0.00020217895507812
SELECT * FROM product_image_select WHERE product_id = '47380'
460 0.0001 0.00013494491577148
SELECT * FROM productcustomimages WHERE product_id = '47380'
461 0.0026 0.0025660991668701
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '47380' AND a.name = n.originalname
462 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '47380' AND merchantid = 'ATVPDKIKX0DER'
463 0.0002 0.00020980834960938
SELECT * FROM productoffers
                WHERE product_id = '47380' AND price > 0
                ORDER BY price ASC LIMIT 1
464 0.0004 0.00038599967956543
SELECT value FROM productattributes WHERE product_id = '47380' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
465 0.0001 0.00011777877807617
UPDATE products SET price = '25900' WHERE id = '47380'
466 0.0002 0.00015592575073242
SELECT value FROM parameters WHERE parameter = 'EBAY_CACHE_TIME' 
467 0.0001 0.0001220703125
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
468 0.0001 0.00011897087097168
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
469 0.0001 0.00011801719665527
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
470 0.0001 0.00011587142944336
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
471 0.0001 0.00011587142944336
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
472 0.0001 0.00013399124145508
SELECT * FROM ebay_locale_details WHERE cur_code = 'USD' 
473 0.1883 0.18833589553833
SELECT * FROM ebay_products_cache WHERE cachekey = 'd6a31fc2887293d1a32db921fbd7eae1' 
474 0.0002 0.00018596649169922
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
475 0.0001 0.00012493133544922
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
476 0.0001 0.0001220703125
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
477 0.0001 0.00011992454528809
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
478 0.0001 0.00012803077697754
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
479 0.1899 0.18993902206421
SELECT * FROM ebay_products_cache WHERE cachekey = 'd6a31fc2887293d1a32db921fbd7eae1' 
480 0.0003 0.00031280517578125
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
481 0.0002 0.00015401840209961
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
482 0.0001 0.00013589859008789
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
483 0.0001 0.00013089179992676
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
484 0.0001 0.00014281272888184
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
485 0.1823 0.18227696418762
SELECT * FROM ebay_products_cache WHERE cachekey = 'd6a31fc2887293d1a32db921fbd7eae1' 
486 0.0003 0.00026297569274902
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
487 0.0001 0.00012516975402832
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
488 0.0001 0.00012111663818359
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
489 0.0001 0.00011897087097168
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
490 0.0001 0.00011801719665527
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
491 0.1904 0.19039607048035
SELECT * FROM ebay_products_cache WHERE cachekey = 'd6a31fc2887293d1a32db921fbd7eae1' 
492 0.0003 0.00031018257141113
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
493 0.0002 0.00016283988952637
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
494 0.0001 0.00014805793762207
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
495 0.0001 0.00013303756713867
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
496 0.0001 0.00013208389282227
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
497 0.1932 0.19317603111267
SELECT * FROM ebay_products_cache WHERE cachekey = 'd6a31fc2887293d1a32db921fbd7eae1' 
498 0.0003 0.00031614303588867
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
499 0.0001 0.00014400482177734
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
500 0.0001 0.00014615058898926
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
501 0.0001 0.00013589859008789
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
502 0.0001 0.00012898445129395
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
503 0.1902 0.19021701812744
SELECT * FROM ebay_products_cache WHERE cachekey = 'd6a31fc2887293d1a32db921fbd7eae1' 
504 0.0003 0.0002739429473877
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
505 0.0001 0.00012707710266113
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
506 0.0001 0.00011992454528809
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
507 0.0001 0.00011801719665527
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
508 0.0001 0.00011801719665527
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
509 0.1894 0.18937206268311
SELECT * FROM ebay_products_cache WHERE cachekey = 'd6a31fc2887293d1a32db921fbd7eae1' 
510 0.0003 0.00026798248291016
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
511 0.0002 0.0001828670501709
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
512 0.0002 0.00016903877258301
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
513 0.0001 0.00012493133544922
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
514 0.0001 0.00012302398681641
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
515 0.1876 0.18762397766113
SELECT * FROM ebay_products_cache WHERE cachekey = 'd6a31fc2887293d1a32db921fbd7eae1' 
516 0.0003 0.0002751350402832
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
517 0.0001 0.00012493133544922
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
518 0.0001 0.00011992454528809
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
519 0.0001 0.00011801719665527
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
520 0.0001 0.00011801719665527
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
521 0.1894 0.18938302993774
SELECT * FROM ebay_products_cache WHERE cachekey = 'd6a31fc2887293d1a32db921fbd7eae1' 
522 0.0002 0.0002448558807373
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
523 0.0001 0.00012493133544922
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
524 0.0001 0.00012493133544922
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
525 0.0001 0.00011992454528809
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
526 0.0001 0.00012016296386719
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
527 0.1890 0.1889750957489
SELECT * FROM ebay_products_cache WHERE cachekey = 'd6a31fc2887293d1a32db921fbd7eae1' 
528 0.0002 0.00023698806762695
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
529 0.0001 0.00012397766113281
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
530 0.0001 0.00012087821960449
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
531 0.0001 0.00013113021850586
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
532 0.0001 0.00011682510375977
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
533 0.1814 0.18142795562744
SELECT * FROM ebay_products_cache WHERE cachekey = 'd6a31fc2887293d1a32db921fbd7eae1' 
534 0.0003 0.00027012825012207
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
535 0.0001 0.00012588500976562
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
536 0.0001 0.00012302398681641
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
537 0.0001 0.00011992454528809
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
538 0.0001 0.00011897087097168
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
539 0.1819 0.18194007873535
SELECT * FROM ebay_products_cache WHERE cachekey = 'd6a31fc2887293d1a32db921fbd7eae1' 
540 0.0003 0.00031709671020508
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
541 0.0002 0.00016999244689941
SELECT value FROM parameters WHERE parameter = 'EBAY_TRACKING_ID' 
542 0.0001 0.00012087821960449
SELECT value FROM parameters WHERE parameter = 'EBAY_NETWORK_ID' 
543 0.0001 0.00011992454528809
SELECT value FROM parameters WHERE parameter = 'EBAY_LOCALE' 
544 0.0001 0.00011897087097168
SELECT value FROM parameters WHERE parameter = 'EBAY_AUTH_TOKEN' 
545 0.1825 0.18250799179077
SELECT * FROM ebay_products_cache WHERE cachekey = 'd6a31fc2887293d1a32db921fbd7eae1' 
546 0.0002 0.00019001960754395
SELECT id FROM ebay_products WHERE itemid = '263635618390' 
547 0.0001 0.00010108947753906
SELECT id FROM ebay_products WHERE itemid = '133068941825' 
548 0.0001 9.7990036010742E-5
SELECT id FROM ebay_products WHERE itemid = '113773984718' 
549 0.0001 0.00010895729064941
SELECT id FROM ebay_products WHERE itemid = '311992588843' 
550 0.0001 9.7990036010742E-5
SELECT id FROM ebay_products WHERE itemid = '254264756764' 
551 0.0001 9.4890594482422E-5
SELECT id FROM ebay_products WHERE itemid = '332693690676' 
552 0.0001 9.4175338745117E-5
SELECT id FROM ebay_products WHERE itemid = '362576328598' 
553 0.0001 9.3936920166016E-5
SELECT id FROM ebay_products WHERE itemid = '362576329551' 
554 0.0001 9.4890594482422E-5
SELECT id FROM ebay_products WHERE itemid = '272890500103' 
555 0.0001 9.3936920166016E-5
SELECT id FROM ebay_products WHERE itemid = '282635096812' 
556 0.0004 0.00038599967956543
UPDATE ebay_products_cache SET products = 'a:11:{i:0;a:14:{s:6:\"itemId\";s:12:\"263635618390\";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=263635618390\";s:10:\"galleryURL\";s:58:\"//thumbs3.ebaystatic.com/m/mcfiGJKjm8D_-h2oftUQPmg/140.jpg\";s:5:\"title\";s:49:\"Hawke Sport Optics HD 3-9 x 50 Rifle Scope ~ New \";s:11:\"listingType\";s:14:\"StoreInventory\";s:20:\"conditionDisplayName\";s:3:\"New\";s:8:\"timeLeft\";s:13:\"P3DT11H54M10S\";s:15:\"returnsAccepted\";s:4:\"true\";s:19:\"originalRetailPrice\";i:0;s:12:\"currentPrice\";s:5:\"68.95\";s:15:\"shipToLocations\";s:9:\"Worldwide\";s:12:\"handlingTime\";s:1:\"0\";s:10:\"variations\";s:5:\"false\";s:8:\"is_exist\";i:0;}i:1;a:14:{s:6:\"itemId\";s:12:\"133068941825\";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=133068941825\";s:10:\"galleryURL\";s:58:\"//thumbs2.ebaystatic.com/m/mRb6CNJ08z6LJP4qXXLLJZA/140.jpg\";s:5:\"title\";s:80:\"Hawke Sport Optics Vantage 3-9x50 1in Tube Waterproof Riflescope Black,30: 14130\";s:11:\"listingType\";s:14:\"StoreInventory\";s:20:\"conditionDisplayName\";s:3:\"New\";s:8:\"timeLeft\";s:13:\"P13DT8H39M10S\";s:15:\"returnsAccepted\";s:4:\"true\";s:19:\"originalRetailPrice\";i:0;s:12:\"currentPrice\";s:5:\"99.99\";s:15:\"shipToLocations\";s:9:\"Worldwide\";s:12:\"handlingTime\";s:1:\"1\";s:10:\"variations\";s:5:\"false\";s:8:\"is_exist\";i:0;}i:2;a:14:{s:6:\"itemId\";s:12:\"113773984718\";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=113773984718\";s:10:\"galleryURL\";s:58:\"//thumbs3.ebaystatic.com/m/m0lhu0UaL5NGp7kwqTzE7_A/140.jpg\";s:5:\"title\";s:79:\"Hawke Sport Optics Vantage 4-12x40AO Mil Dot Riflescope with Mounting Rings Kit\";s:11:\"listingType\";s:10:\"FixedPrice\";s:20:\"conditionDisplayName\";s:3:\"New\";s:8:\"timeLeft\";s:12:\"P20DT8H26M4S\";s:15:\"returnsAccepted\";s:5:\"false\";s:19:\"originalRetailPrice\";i:0;s:12:\"currentPrice\";s:5:\"85.00\";s:15:\"shipToLocations\";s:9:\"Worldwide\";s:12:\"handlingTime\";s:1:\"3\";s:10:\"variations\";s:5:\"false\";s:8:\"is_exist\";i:0;}i:3;a:14:{s:6:\"itemId\";s:12:\"311992588843\";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=311992588843\";s:10:\"galleryURL\";s:58:\"//thumbs4.ebaystatic.com/m/mNk0XOc1e7VvlhQN34nfYew/140.jpg\";s:5:\"title\";s:76:\"Hawke Sport Optics Vantage SF 6-24x44 SF 1/2 Mil Dot, Black 14162 Riflescope\";s:11:\"listingType\";s:10:\"FixedPrice\";s:20:\"conditionDisplayName\";s:3:\"New\";s:8:\"timeLeft\";s:12:\"P7DT3H41M22S\";s:15:\"returnsAccepted\";s:4:\"true\";s:19:\"originalRetailPrice\";i:0;s:12:\"currentPrice\";s:6:\"229.99\";s:15:\"shipToLocations\";s:9:\"Worldwide\";s:12:\"handlingTime\";s:1:\"4\";s:10:\"variations\";s:5:\"false\";s:8:\"is_exist\";i:0;}i:4;a:14:{s:6:\"itemId\";s:12:\"254264756764\";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=254264756764\";s:10:\"galleryURL\";s:58:\"//thumbs1.ebaystatic.com/m/mDirWSDSNfuNQJ03Nb2tS3A/140.jpg\";s:5:\"title\";s:46:\"Hawke Sport Optics HK3250 3-9x40 Hunting Scope\";s:11:\"listingType\";s:10:\"FixedPrice\";s:20:\"conditionDisplayName\";s:3:\"New\";s:8:\"timeLeft\";s:12:\"P29DT5H5M53S\";s:15:\"returnsAccepted\";s:5:\"false\";s:19:\"originalRetailPrice\";i:0;s:12:\"currentPrice\";s:5:\"85.00\";s:15:\"shipToLocations\";s:9:\"Worldwide\";s:12:\"handlingTime\";s:1:\"3\";s:10:\"variations\";s:5:\"false\";s:8:\"is_exist\";i:0;}i:5;a:14:{s:6:\"itemId\";s:12:\"332693690676\";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=332693690676\";s:10:\"galleryURL\";s:58:\"//thumbs1.ebaystatic.com/m/m66U_g1lVNaTEUtiDGAd7jQ/140.jpg\";s:5:\"title\";s:80:\"Hawke Sport Optics 3-9x40 Airmax Riflescope, AMX Ranging Reticle, Adj. Objective\";s:11:\"listingType\";s:10:\"FixedPrice\";s:20:\"conditionDisplayName\";s:3:\"New\";s:8:\"timeLeft\";s:12:\"P0DT3H31M54S\";s:15:\"returnsAccepted\";s:4:\"true\";s:19:\"originalRetailPrice\";s:6:\"209.00\";s:12:\"currentPrice\";s:6:\"189.99\";s:15:\"shipToLocations\";s:9:\"Worldwide\";s:12:\"handlingTime\";s:1:\"1\";s:10:\"variations\";s:5:\"false\";s:8:\"is_exist\";i:0;}i:6;a:14:{s:6:\"itemId\";s:12:\"362576328598\";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=362576328598\";s:10:\"galleryURL\";s:58:\"//thumbs3.ebaystatic.com/m/mJxwVNpXy4E4-v-yT4k5Oig/140.jpg\";s:5:\"title\";s:66:\"Hawke Sport Optics 3-9x40 Vantage Riflescope (30/30 Reticle) 14120\";s:11:\"listingType\";s:14:\"StoreInventory\";s:20:\"conditionDisplayName\";s:3:\"New\";s:8:\"timeLeft\";s:14:\"P20DT10H48M35S\";s:15:\"returnsAccepted\";s:4:\"true\";s:19:\"originalRetailPrice\";i:0;s:12:\"currentPrice\";s:5:\"94.99\";s:15:\"shipToLocations\";s:9:\"Worldwide\";s:12:\"handlingTime\";s:1:\"1\";s:10:\"variations\";s:5:\"false\";s:8:\"is_exist\";i:0;}i:7;a:14:{s:6:\"itemId\";s:12:\"362576329551\";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=362576329551\";s:10:\"galleryURL\";s:58:\"//thumbs4.ebaystatic.com/m/ma4LLqToGDJO590NbPgMXSg/140.jpg\";s:5:\"title\";s:62:\"Hawke Sport Optics Vantage 4-12x40 AO Mil Dot Riflescope 14141\";s:11:\"listingType\";s:14:\"StoreInventory\";s:20:\"conditionDisplayName\";s:3:\"New\";s:8:\"timeLeft\";s:14:\"P20DT10H51M26S\";s:15:\"returnsAccepted\";s:4:\"true\";s:19:\"originalRetailPrice\";i:0;s:12:\"currentPrice\";s:6:\"129.95\";s:15:\"shipToLocations\";s:9:\"Worldwide\";s:12:\"handlingTime\";s:1:\"1\";s:10:\"variations\";s:5:\"false\";s:8:\"is_exist\";i:0;}i:8;a:14:{s:6:\"itemId\";s:12:\"272890500103\";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=272890500103\";s:10:\"galleryURL\";s:58:\"//thumbs4.ebaystatic.com/m/mplwPyLpnoX1byVlJTJ-iaQ/140.jpg\";s:5:\"title\";s:70:\"Hawke Sport Optics 50mm AO Sunshade, Black for 2015 collection onwards\";s:11:\"listingType\";s:10:\"FixedPrice\";s:20:\"conditionDisplayName\";s:3:\"New\";s:8:\"timeLeft\";s:13:\"P22DT17H57M2S\";s:15:\"returnsAccepted\";s:4:\"true\";s:19:\"originalRetailPrice\";i:0;s:12:\"currentPrice\";s:5:\"24.99\";s:15:\"shipToLocations\";s:9:\"Worldwide\";s:12:\"handlingTime\";s:1:\"1\";s:10:\"variations\";s:5:\"false\";s:8:\"is_exist\";i:0;}i:9;a:14:{s:6:\"itemId\";s:12:\"282635096812\";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=282635096812\";s:10:\"galleryURL\";s:58:\"//thumbs1.ebaystatic.com/m/mVlmU44DG3xEquqMPpjijSQ/140.jpg\";s:5:\"title\";s:63:\"Hawke Optics Sport HD IR 3-9x40 Rimfire SR Reticle Scope #14222\";s:11:\"listingType\";s:14:\"StoreInventory\";s:20:\"conditionDisplayName\";s:3:\"New\";s:8:\"timeLeft\";s:13:\"P7DT20H32M33S\";s:15:\"returnsAccepted\";s:4:\"true\";s:19:\"originalRetailPrice\";i:0;s:12:\"currentPrice\";s:6:\"159.99\";s:15:\"shipToLocations\";s:9:\"Worldwide\";s:12:\"handlingTime\";s:1:\"1\";s:10:\"variations\";s:5:\"false\";s:8:\"is_exist\";i:0;}i:10;s:204:\"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%3DHawke%2BSport%2BOptics%26_ipg%3D10%26_pgn%3D1\";}', expiretime = '1560672291' WHERE id = '65357'
557 0.0002 0.00015616416931152
SELECT id,asin FROM products WHERE parent_id = 404378
558 0.0003 0.00031614303588867
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '404378' ORDER BY timestamp DESC
559 0.0002 0.00015091896057129
SELECT category_id FROM products_categories WHERE product_id = '404378'
560 0.0002 0.0001521110534668
SELECT * FROM categories WHERE id = '98'
561 0.0008 0.0007939338684082
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 = 98
562 0.0001 0.00012016296386719
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 98
563 0.0003 0.00025391578674316
SELECT id FROM categories WHERE parent_id = '98'
564 0.0008 0.0007929801940918
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (98)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
565 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 (98)
				  AND p.disabled = 0 
566 0.0001 0.00014495849609375
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (98)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
567 0.0002 0.00015997886657715
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '98'
568 0.0022 0.0022239685058594
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '404378' AND a.name = n.originalname
569 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '404378' AND merchantid = 'ATVPDKIKX0DER'
570 0.0002 0.00018692016601562
SELECT * FROM productoffers
                WHERE product_id = '404378' AND price > 0
                ORDER BY price ASC LIMIT 1
571 0.0002 0.00016403198242188
SELECT * FROM productoffers
                WHERE product_id = 404378
                ORDER BY price ASC LIMIT 1
572 0.0002 0.0002131462097168
SELECT value FROM productattributes
                WHERE product_id = '404378'
                AND name = 'ListPriceAmount'
573 0.0002 0.00021505355834961
SELECT * FROM products WHERE id = '404378'
574 0.0001 0.00012111663818359
UPDATE products SET price = '22498' WHERE id = '404378'
575 0.0021 0.0021450519561768
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '404378' AND a.name = n.originalname
576 0.0002 0.00017404556274414
SELECT * FROM productoffers WHERE product_id = '404378' AND merchantid = 'ATVPDKIKX0DER'
577 0.0002 0.00017404556274414
SELECT * FROM productoffers
                WHERE product_id = '404378' AND price > 0
                ORDER BY price ASC LIMIT 1
578 0.0002 0.00017690658569336
SELECT * FROM productoffers
                WHERE product_id = 404378
                ORDER BY price ASC LIMIT 1
579 0.0002 0.00021004676818848
SELECT value FROM productattributes
                WHERE product_id = '404378'
                AND name = 'ListPriceAmount'
580 0.0001 0.00013089179992676
SELECT category_id FROM products_categories WHERE product_id = '404378'
581 0.0001 0.00011205673217773
SELECT parent_id FROM categories WHERE id = '98'
582 0.0001 0.00011396408081055
SELECT parent_id FROM categories WHERE id = '34'
583 0.0002 0.00023794174194336
SELECT * FROM categories WHERE id = '34'
584 0.0096 0.009580135345459
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
585 0.0001 0.0001380443572998
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 34
586 0.0003 0.00026082992553711
SELECT id FROM categories WHERE parent_id = '34'
587 0.0002 0.00021505355834961
SELECT id FROM categories WHERE parent_id = '94'
588 0.0002 0.0001990795135498
SELECT id FROM categories WHERE parent_id = '98'
589 0.0002 0.00019717216491699
SELECT id FROM categories WHERE parent_id = '99'
590 0.0002 0.00019717216491699
SELECT id FROM categories WHERE parent_id = '110'
591 0.0002 0.00020599365234375
SELECT id FROM categories WHERE parent_id = '130'
592 0.0104 0.010380983352661
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 
593 0.0002 0.00019502639770508
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 
594 0.0002 0.00016212463378906
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 
595 0.0002 0.00020003318786621
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
596 0.0002 0.00015902519226074
SELECT * FROM categories WHERE id = '98'
597 0.0007 0.00071215629577637
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 = 98
598 0.0001 0.00012612342834473
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 98
599 0.0003 0.0002601146697998
SELECT id FROM categories WHERE parent_id = '98'
600 0.0008 0.00076889991760254
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (98)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
601 0.0001 0.00014400482177734
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (98)
				  AND p.disabled = 0 
602 0.0001 0.00014305114746094
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (98)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
603 0.0002 0.00015592575073242
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '98'
604 0.0002 0.00017094612121582
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
605 0.0002 0.00015783309936523
SELECT * FROM pages WHERE id = 2
606 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = 4
607 0.0001 0.00013613700866699
SELECT * FROM pages WHERE id = 12
608 0.0001 0.0001380443572998
SELECT * FROM pages WHERE id = 10
609 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = 7
610 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = 18
611 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = 28
612 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = 13
613 0.0001 0.00013613700866699
SELECT * FROM pages WHERE id = 3
614 0.0447 0.044662952423096
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
615 0.0002 0.00024104118347168
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:1560672298;s:8:\"products\";a:6:{i:6;s:6:\"103845\";i:8;s:6:\"403517\";i:14;s:6:\"406758\";i:22;s:6:\"400044\";i:0;s:6:\"414940\";i:1;s:6:\"398315\";}}' WHERE id = '175'
616 0.0005 0.00045394897460938
SELECT * FROM products WHERE id IN (103845,403517,406758,400044,414940,398315) ORDER BY FIELD(id, 103845,403517,406758,400044,414940,398315 )
617 0.0002 0.00021910667419434
SELECT * FROM productimages WHERE product_id = '103845' ORDER BY sortorder ASC
618 0.0002 0.00020885467529297
SELECT * FROM product_image_select WHERE product_id = '103845'
619 0.0001 0.00012397766113281
SELECT * FROM productcustomimages WHERE product_id = '103845'
620 0.0024 0.0024490356445312
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '103845' AND a.name = n.originalname
621 0.0002 0.00018692016601562
SELECT * FROM productoffers WHERE product_id = '103845' AND merchantid = 'ATVPDKIKX0DER'
622 0.0002 0.00020194053649902
SELECT * FROM productoffers
                WHERE product_id = '103845' AND price > 0
                ORDER BY price ASC LIMIT 1
623 0.0004 0.00039911270141602
SELECT value FROM productattributes WHERE product_id = '103845' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
624 0.0001 0.00012087821960449
UPDATE products SET price = '11900' WHERE id = '103845'
625 0.0003 0.00026297569274902
SELECT * FROM productimages WHERE product_id = '403517' ORDER BY sortorder ASC
626 0.0002 0.00021100044250488
SELECT * FROM product_image_select WHERE product_id = '403517'
627 0.0001 0.00013089179992676
SELECT * FROM productcustomimages WHERE product_id = '403517'
628 0.0030 0.0029568672180176
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '403517' AND a.name = n.originalname
629 0.0002 0.0001828670501709
SELECT * FROM productoffers WHERE product_id = '403517' AND merchantid = 'ATVPDKIKX0DER'
630 0.0002 0.0001978874206543
SELECT * FROM productoffers
                WHERE product_id = '403517' AND price > 0
                ORDER BY price ASC LIMIT 1
631 0.0004 0.00040698051452637
SELECT value FROM productattributes WHERE product_id = '403517' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
632 0.0001 0.00013208389282227
UPDATE products SET price = '6699' WHERE id = '403517'
633 0.0002 0.00018882751464844
SELECT * FROM productimages WHERE product_id = '406758' ORDER BY sortorder ASC
634 0.0002 0.00019979476928711
SELECT * FROM product_image_select WHERE product_id = '406758'
635 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '406758'
636 0.0026 0.0026419162750244
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406758' AND a.name = n.originalname
637 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '406758' AND merchantid = 'ATVPDKIKX0DER'
638 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '406758' AND price > 0
                ORDER BY price ASC LIMIT 1
639 0.0004 0.00040483474731445
SELECT value FROM productattributes WHERE product_id = '406758' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
640 0.0001 0.0001220703125
UPDATE products SET price = '2694' WHERE id = '406758'
641 0.0002 0.00021100044250488
SELECT * FROM productimages WHERE product_id = '400044' ORDER BY sortorder ASC
642 0.0002 0.00020813941955566
SELECT * FROM product_image_select WHERE product_id = '400044'
643 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '400044'
644 0.0028 0.0028209686279297
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '400044' AND a.name = n.originalname
645 0.0002 0.0001981258392334
SELECT * FROM productoffers WHERE product_id = '400044' AND merchantid = 'ATVPDKIKX0DER'
646 0.0002 0.00020289421081543
SELECT * FROM productoffers
                WHERE product_id = '400044' AND price > 0
                ORDER BY price ASC LIMIT 1
647 0.0004 0.00040984153747559
SELECT value FROM productattributes WHERE product_id = '400044' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
648 0.0001 0.00011801719665527
UPDATE products SET price = '16091' WHERE id = '400044'
649 0.0002 0.00018787384033203
SELECT * FROM productimages WHERE product_id = '414940' ORDER BY sortorder ASC
650 0.0002 0.0002140998840332
SELECT * FROM product_image_select WHERE product_id = '414940'
651 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '414940'
652 0.0033 0.0032758712768555
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414940' AND a.name = n.originalname
653 0.0002 0.0001828670501709
SELECT * FROM productoffers WHERE product_id = '414940' AND merchantid = 'ATVPDKIKX0DER'
654 0.0002 0.00021004676818848
SELECT * FROM productoffers
                WHERE product_id = '414940' AND price > 0
                ORDER BY price ASC LIMIT 1
655 0.0004 0.0004270076751709
SELECT value FROM productattributes WHERE product_id = '414940' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
656 0.0001 0.00011706352233887
UPDATE products SET price = '4490' WHERE id = '414940'
657 0.0002 0.00020313262939453
SELECT * FROM productimages WHERE product_id = '398315' ORDER BY sortorder ASC
658 0.0002 0.00022292137145996
SELECT * FROM product_image_select WHERE product_id = '398315'
659 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '398315'
660 0.0025 0.0024919509887695
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398315' AND a.name = n.originalname
661 0.0002 0.00019311904907227
SELECT * FROM productoffers WHERE product_id = '398315' AND merchantid = 'ATVPDKIKX0DER'
662 0.0002 0.00019598007202148
SELECT * FROM productoffers
                WHERE product_id = '398315' AND price > 0
                ORDER BY price ASC LIMIT 1
663 0.0004 0.00038003921508789
SELECT value FROM productattributes WHERE product_id = '398315' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
664 0.0001 0.00012087821960449
UPDATE products SET price = '1999' WHERE id = '398315'
665 0.0445 0.044493913650513
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
666 0.0002 0.00023293495178223
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:1560672298;s:8:\"products\";a:6:{i:0;s:6:\"414940\";i:3;s:6:\"412927\";i:4;s:6:\"408792\";i:7;s:6:\"370121\";i:21;s:6:\"406901\";i:8;s:6:\"403517\";}}' WHERE id = '177'
667 0.0005 0.00046515464782715
SELECT * FROM products WHERE id IN (414940,412927,408792,370121,406901,403517) ORDER BY FIELD(id, 414940,412927,408792,370121,406901,403517 )
668 0.0002 0.00019407272338867
SELECT * FROM productimages WHERE product_id = '414940' ORDER BY sortorder ASC
669 0.0002 0.00020909309387207
SELECT * FROM product_image_select WHERE product_id = '414940'
670 0.0001 0.00012397766113281
SELECT * FROM productcustomimages WHERE product_id = '414940'
671 0.0034 0.0033550262451172
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414940' AND a.name = n.originalname
672 0.0002 0.00019693374633789
SELECT * FROM productoffers WHERE product_id = '414940' AND merchantid = 'ATVPDKIKX0DER'
673 0.0002 0.00021004676818848
SELECT * FROM productoffers
                WHERE product_id = '414940' AND price > 0
                ORDER BY price ASC LIMIT 1
674 0.0005 0.00048303604125977
SELECT value FROM productattributes WHERE product_id = '414940' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
675 0.0001 0.00012898445129395
UPDATE products SET price = '4490' WHERE id = '414940'
676 0.0003 0.00027108192443848
SELECT * FROM productimages WHERE product_id = '412927' ORDER BY sortorder ASC
677 0.0002 0.00022697448730469
SELECT * FROM product_image_select WHERE product_id = '412927'
678 0.0001 0.00013518333435059
SELECT * FROM productcustomimages WHERE product_id = '412927'
679 0.0036 0.0036230087280273
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412927' AND a.name = n.originalname
680 0.0002 0.00019598007202148
SELECT * FROM productoffers WHERE product_id = '412927' AND merchantid = 'ATVPDKIKX0DER'
681 0.0002 0.00019693374633789
SELECT * FROM productoffers
                WHERE product_id = '412927' AND price > 0
                ORDER BY price ASC LIMIT 1
682 0.0004 0.00044798851013184
SELECT value FROM productattributes WHERE product_id = '412927' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
683 0.0001 0.0001220703125
UPDATE products SET price = '199900' WHERE id = '412927'
684 0.0002 0.00021481513977051
SELECT * FROM productimages WHERE product_id = '408792' ORDER BY sortorder ASC
685 0.0002 0.0002138614654541
SELECT * FROM product_image_select WHERE product_id = '408792'
686 0.0001 0.00012397766113281
SELECT * FROM productcustomimages WHERE product_id = '408792'
687 0.0036 0.0036249160766602
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408792' AND a.name = n.originalname
688 0.0002 0.00018811225891113
SELECT * FROM productoffers WHERE product_id = '408792' AND merchantid = 'ATVPDKIKX0DER'
689 0.0002 0.00020194053649902
SELECT * FROM productoffers
                WHERE product_id = '408792' AND price > 0
                ORDER BY price ASC LIMIT 1
690 0.0005 0.00045084953308105
SELECT value FROM productattributes WHERE product_id = '408792' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
691 0.0001 0.00011801719665527
UPDATE products SET price = '13499' WHERE id = '408792'
692 0.0002 0.00018811225891113
SELECT * FROM productimages WHERE product_id = '370121' ORDER BY sortorder ASC
693 0.0002 0.00020003318786621
SELECT * FROM product_image_select WHERE product_id = '370121'
694 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '370121'
695 0.0028 0.0027539730072021
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '370121' AND a.name = n.originalname
696 0.0002 0.00018715858459473
SELECT * FROM productoffers WHERE product_id = '370121' AND merchantid = 'ATVPDKIKX0DER'
697 0.0002 0.00021505355834961
SELECT * FROM productoffers
                WHERE product_id = '370121' AND price > 0
                ORDER BY price ASC LIMIT 1
698 0.0004 0.00039386749267578
SELECT value FROM productattributes WHERE product_id = '370121' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
699 0.0001 0.00011801719665527
UPDATE products SET price = '9899' WHERE id = '370121'
700 0.0002 0.00020194053649902
SELECT * FROM productimages WHERE product_id = '406901' ORDER BY sortorder ASC
701 0.0002 0.00021696090698242
SELECT * FROM product_image_select WHERE product_id = '406901'
702 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '406901'
703 0.0024 0.0023550987243652
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406901' AND a.name = n.originalname
704 0.0002 0.0001828670501709
SELECT * FROM productoffers WHERE product_id = '406901' AND merchantid = 'ATVPDKIKX0DER'
705 0.0002 0.00020599365234375
SELECT * FROM productoffers
                WHERE product_id = '406901' AND price > 0
                ORDER BY price ASC LIMIT 1
706 0.0003 0.00034523010253906
SELECT value FROM productattributes WHERE product_id = '406901' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
707 0.0001 0.00012087821960449
UPDATE products SET price = '395' WHERE id = '406901'
708 0.0003 0.00026321411132812
SELECT * FROM productimages WHERE product_id = '403517' ORDER BY sortorder ASC
709 0.0002 0.00022506713867188
SELECT * FROM product_image_select WHERE product_id = '403517'
710 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '403517'
711 0.0030 0.0029599666595459
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '403517' AND a.name = n.originalname
712 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '403517' AND merchantid = 'ATVPDKIKX0DER'
713 0.0002 0.00019407272338867
SELECT * FROM productoffers
                WHERE product_id = '403517' AND price > 0
                ORDER BY price ASC LIMIT 1
714 0.0004 0.00041794776916504
SELECT value FROM productattributes WHERE product_id = '403517' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
715 0.0001 0.0001220703125
UPDATE products SET price = '6699' WHERE id = '403517'
716 0.1085 0.10849285125732
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
717 0.0003 0.00027012825012207
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:1560672298;s:8:\"products\";a:6:{i:4;s:6:\"408792\";i:6;s:6:\"103845\";i:10;s:6:\"412945\";i:11;s:6:\"414825\";i:19;s:6:\"131163\";i:9;s:6:\"412382\";}}' WHERE id = '181'
718 0.0004 0.0004429817199707
SELECT * FROM products WHERE id IN (408792,103845,412945,414825,131163,412382) ORDER BY FIELD(id, 408792,103845,412945,414825,131163,412382 )
719 0.0002 0.00021696090698242
SELECT * FROM productimages WHERE product_id = '408792' ORDER BY sortorder ASC
720 0.0002 0.00022506713867188
SELECT * FROM product_image_select WHERE product_id = '408792'
721 0.0001 0.00012588500976562
SELECT * FROM productcustomimages WHERE product_id = '408792'
722 0.0037 0.0036778450012207
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408792' AND a.name = n.originalname
723 0.0002 0.00019192695617676
SELECT * FROM productoffers WHERE product_id = '408792' AND merchantid = 'ATVPDKIKX0DER'
724 0.0002 0.00020694732666016
SELECT * FROM productoffers
                WHERE product_id = '408792' AND price > 0
                ORDER BY price ASC LIMIT 1
725 0.0004 0.00044608116149902
SELECT value FROM productattributes WHERE product_id = '408792' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
726 0.0001 0.00013208389282227
UPDATE products SET price = '13499' WHERE id = '408792'
727 0.0002 0.0001978874206543
SELECT * FROM productimages WHERE product_id = '103845' ORDER BY sortorder ASC
728 0.0002 0.00020909309387207
SELECT * FROM product_image_select WHERE product_id = '103845'
729 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '103845'
730 0.0024 0.0024230480194092
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '103845' AND a.name = n.originalname
731 0.0002 0.00018692016601562
SELECT * FROM productoffers WHERE product_id = '103845' AND merchantid = 'ATVPDKIKX0DER'
732 0.0002 0.00019693374633789
SELECT * FROM productoffers
                WHERE product_id = '103845' AND price > 0
                ORDER BY price ASC LIMIT 1
733 0.0004 0.00038003921508789
SELECT value FROM productattributes WHERE product_id = '103845' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
734 0.0001 0.00011992454528809
UPDATE products SET price = '11900' WHERE id = '103845'
735 0.0002 0.00018620491027832
SELECT * FROM productimages WHERE product_id = '412945' ORDER BY sortorder ASC
736 0.0002 0.00021100044250488
SELECT * FROM product_image_select WHERE product_id = '412945'
737 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '412945'
738 0.0028 0.0027978420257568
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412945' AND a.name = n.originalname
739 0.0002 0.00018620491027832
SELECT * FROM productoffers WHERE product_id = '412945' AND merchantid = 'ATVPDKIKX0DER'
740 0.0002 0.00020098686218262
SELECT * FROM productoffers
                WHERE product_id = '412945' AND price > 0
                ORDER BY price ASC LIMIT 1
741 0.0004 0.00037693977355957
SELECT value FROM productattributes WHERE product_id = '412945' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
742 0.0001 0.00011992454528809
UPDATE products SET price = '3199' WHERE id = '412945'
743 0.0002 0.00020098686218262
SELECT * FROM productimages WHERE product_id = '414825' ORDER BY sortorder ASC
744 0.0002 0.00021791458129883
SELECT * FROM product_image_select WHERE product_id = '414825'
745 0.0001 0.0001218318939209
SELECT * FROM productcustomimages WHERE product_id = '414825'
746 0.0020 0.0020241737365723
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414825' AND a.name = n.originalname
747 0.0002 0.00019001960754395
SELECT * FROM productoffers WHERE product_id = '414825' AND merchantid = 'ATVPDKIKX0DER'
748 0.0002 0.00020909309387207
SELECT * FROM productoffers
                WHERE product_id = '414825' AND price > 0
                ORDER BY price ASC LIMIT 1
749 0.0004 0.00037789344787598
SELECT value FROM productattributes WHERE product_id = '414825' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
750 0.0001 0.0001220703125
UPDATE products SET price = '11999' WHERE id = '414825'
751 0.0002 0.00022006034851074
SELECT * FROM productimages WHERE product_id = '131163' ORDER BY sortorder ASC
752 0.0002 0.00021696090698242
SELECT * FROM product_image_select WHERE product_id = '131163'
753 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '131163'
754 0.0026 0.0025830268859863
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '131163' AND a.name = n.originalname
755 0.0003 0.00033307075500488
SELECT * FROM productoffers WHERE product_id = '131163' AND merchantid = 'ATVPDKIKX0DER'
756 0.0003 0.00025391578674316
SELECT * FROM productoffers
                WHERE product_id = '131163' AND price > 0
                ORDER BY price ASC LIMIT 1
757 0.0005 0.00053906440734863
SELECT value FROM productattributes WHERE product_id = '131163' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
758 0.0001 0.00014090538024902
UPDATE products SET price = '20363' WHERE id = '131163'
759 0.0002 0.0002129077911377
SELECT * FROM productimages WHERE product_id = '412382' ORDER BY sortorder ASC
760 0.0002 0.00021815299987793
SELECT * FROM product_image_select WHERE product_id = '412382'
761 0.0001 0.00012898445129395
SELECT * FROM productcustomimages WHERE product_id = '412382'
762 0.0021 0.0021190643310547
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412382' AND a.name = n.originalname
763 0.0002 0.00019288063049316
SELECT * FROM productoffers WHERE product_id = '412382' AND merchantid = 'ATVPDKIKX0DER'
764 0.0002 0.00023484230041504
SELECT * FROM productoffers
                WHERE product_id = '412382' AND price > 0
                ORDER BY price ASC LIMIT 1
765 0.0003 0.00032401084899902
SELECT value FROM productattributes WHERE product_id = '412382' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
766 0.0001 0.00012016296386719
UPDATE products SET price = '3199' WHERE id = '412382'
767 0.1084 0.10840702056885
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
768 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:1560672299;s:8:\"products\";a:6:{i:2;s:6:\"290575\";i:10;s:6:\"412945\";i:15;s:6:\"130885\";i:18;s:6:\"127345\";i:19;s:6:\"131163\";i:20;s:6:\"408079\";}}' WHERE id = '183'
769 0.0005 0.00045514106750488
SELECT * FROM products WHERE id IN (290575,412945,130885,127345,131163,408079) ORDER BY FIELD(id, 290575,412945,130885,127345,131163,408079 )
770 0.0006 0.00059008598327637
SELECT * FROM productimages WHERE product_id = '290575' ORDER BY sortorder ASC
771 0.0002 0.00021696090698242
SELECT * FROM product_image_select WHERE product_id = '290575'
772 0.0001 0.00013399124145508
SELECT * FROM productcustomimages WHERE product_id = '290575'
773 0.0034 0.0034389495849609
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '290575' AND a.name = n.originalname
774 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '290575' AND merchantid = 'ATVPDKIKX0DER'
775 0.0002 0.0002140998840332
SELECT * FROM productoffers
                WHERE product_id = '290575' AND price > 0
                ORDER BY price ASC LIMIT 1
776 0.0004 0.00043702125549316
SELECT value FROM productattributes WHERE product_id = '290575' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
777 0.0001 0.00012111663818359
UPDATE products SET price = '549500' WHERE id = '290575'
778 0.0002 0.00018787384033203
SELECT * FROM productimages WHERE product_id = '412945' ORDER BY sortorder ASC
779 0.0002 0.00022387504577637
SELECT * FROM product_image_select WHERE product_id = '412945'
780 0.0001 0.00012397766113281
SELECT * FROM productcustomimages WHERE product_id = '412945'
781 0.0028 0.002802848815918
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '412945' AND a.name = n.originalname
782 0.0002 0.0001838207244873
SELECT * FROM productoffers WHERE product_id = '412945' AND merchantid = 'ATVPDKIKX0DER'
783 0.0002 0.00020194053649902
SELECT * FROM productoffers
                WHERE product_id = '412945' AND price > 0
                ORDER BY price ASC LIMIT 1
784 0.0004 0.00038599967956543
SELECT value FROM productattributes WHERE product_id = '412945' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
785 0.0001 0.00011992454528809
UPDATE products SET price = '3199' WHERE id = '412945'
786 0.0002 0.00019288063049316
SELECT * FROM productimages WHERE product_id = '130885' ORDER BY sortorder ASC
787 0.0002 0.00020599365234375
SELECT * FROM product_image_select WHERE product_id = '130885'
788 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '130885'
789 0.0020 0.0019910335540771
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '130885' AND a.name = n.originalname
790 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '130885' AND merchantid = 'ATVPDKIKX0DER'
791 0.0002 0.0001990795135498
SELECT * FROM productoffers
                WHERE product_id = '130885' AND price > 0
                ORDER BY price ASC LIMIT 1
792 0.0004 0.00035214424133301
SELECT value FROM productattributes WHERE product_id = '130885' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
793 0.0001 0.00011706352233887
UPDATE products SET price = '1521' WHERE id = '130885'
794 0.0003 0.0003058910369873
SELECT * FROM productimages WHERE product_id = '127345' ORDER BY sortorder ASC
795 0.0002 0.0002131462097168
SELECT * FROM product_image_select WHERE product_id = '127345'
796 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '127345'
797 0.0026 0.0026021003723145
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '127345' AND a.name = n.originalname
798 0.0002 0.00018000602722168
SELECT * FROM productoffers WHERE product_id = '127345' AND merchantid = 'ATVPDKIKX0DER'
799 0.0002 0.00019288063049316
SELECT * FROM productoffers
                WHERE product_id = '127345' AND price > 0
                ORDER BY price ASC LIMIT 1
800 0.0004 0.00038480758666992
SELECT value FROM productattributes WHERE product_id = '127345' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
801 0.0001 0.00012493133544922
UPDATE products SET price = '17888' WHERE id = '127345'
802 0.0002 0.00021910667419434
SELECT * FROM productimages WHERE product_id = '131163' ORDER BY sortorder ASC
803 0.0002 0.00020694732666016
SELECT * FROM product_image_select WHERE product_id = '131163'
804 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '131163'
805 0.0025 0.002547025680542
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '131163' AND a.name = n.originalname
806 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '131163' AND merchantid = 'ATVPDKIKX0DER'
807 0.0002 0.00020599365234375
SELECT * FROM productoffers
                WHERE product_id = '131163' AND price > 0
                ORDER BY price ASC LIMIT 1
808 0.0004 0.00039291381835938
SELECT value FROM productattributes WHERE product_id = '131163' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
809 0.0001 0.00011801719665527
UPDATE products SET price = '20363' WHERE id = '131163'
810 0.0002 0.00017786026000977
SELECT * FROM productimages WHERE product_id = '408079' ORDER BY sortorder ASC
811 0.0002 0.00020408630371094
SELECT * FROM product_image_select WHERE product_id = '408079'
812 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '408079'
813 0.0032 0.0032119750976562
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408079' AND a.name = n.originalname
814 0.0002 0.00018906593322754
SELECT * FROM productoffers WHERE product_id = '408079' AND merchantid = 'ATVPDKIKX0DER'
815 0.0002 0.00020885467529297
SELECT * FROM productoffers
                WHERE product_id = '408079' AND price > 0
                ORDER BY price ASC LIMIT 1
816 0.0004 0.00037980079650879
SELECT value FROM productattributes WHERE product_id = '408079' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
817 0.0001 0.00013113021850586
UPDATE products SET price = '24923' WHERE id = '408079'
818 0.0004 0.00040411949157715
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
819 0.0001 0.00013399124145508
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
820 0.0001 0.00012302398681641
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
821 0.0001 0.00011801719665527
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
822 0.0001 0.00011777877807617
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
823 0.0004 0.00041580200195312
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
824 0.0001 0.00012803077697754
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
825 0.0001 0.00013995170593262
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
826 0.0001 0.0001218318939209
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
827 0.0009 0.00092101097106934
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
828 0.0003 0.00032496452331543
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
829 0.0003 0.00027990341186523
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
830 0.0003 0.00033807754516602
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'
831 0.0003 0.00031185150146484
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'