Tactical Equipment - Survivalist Equipment
   

USA Green Tip Ammo Ban

Green tip ammunition may soon be banned in the USA

UPDATED:  

Some readers may have heard of a proposed ban in the USA of a type of 5.56mm (.223) round known a “Green Tip” or M855A1 EPR. The objective of creating the Green Tip Ammunition cartridge was to create an environmentallyfriendly small arms training round after the US Army had been required to remove lead from their bullets to reduce lead accumulation at stateside training ranges.

The lead slug is replaced by a copper alloy slug in a reversedrawn jacket, with a hardened steel penetrator extending beyond the jacket, thereby reducing lead contamination of the environment. The alloy core however, means that the round fits the definition of armour piercing in USA Federal regulations, but for a long time it has been considered exempt from this definition and is popular for sporting purposes.

This issue appears to have come about because of the availability of pistol-sized AR-15 type weapons that could conceivable fire these rounds and the perceived threat to police officers. True armor-piercing handgun ammunition has quite rightly been banned in the USA since 1986 as a way to protect police officers under the Federal Law Enforcement Officers Protection Act.

While it is reasonable for the US government to seek to ban certain categories of ammunition that have (body) armour piercing capability for the safety of its officers, it does cause problems for shooters at large.

Any ammo ban makes gun owners suspicious of where it will lead, particularly when the round concerned is in the most popular calibre and used in one of the most popular types of firearm today (the AR15), a rifle that has drawn the close attention of anti-gun lobbyists. Secondly, the threat of any ammo ban leads to panic buying of all types of ammo in the US, which means supplies dry up, causing shortages here and abroad which is at the far end of the supply chain.

In the USA there are concerns about the way this proposed ban is being handled. There appears to be a very short consultation period, which the NRA is trying to extend. When the Alcohol, Tobacco & Firearms Agency recently published their latest Regulations they “mistakenly” omitted the still current legal exemption for this round. This has lead to accusations that they appear to be going ahead with the ban without proper public consultation.


Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.258171081543 604 0.5769 0


No Amazon API Requests Made.


App Debug - Total Time 1.258171081543 seconds

Number Time From Start Name Description
1 0.4381639957428 Initialise Initialise FSB Function
2 0.44617509841919 App Controller Start Start of the App controller (called before the controller of every page)
3 0.45799016952515 Start of getCategoryListByGroup Function Before first category groups query
4 0.45815920829773 After initial query Before first category groups query
5 0.45816016197205 Get Category List for Group Before the call to getCategoryList function
6 0.45816421508789 Start of GetCategoryList function Start of the function
7 0.45817017555237 Before getting categories Query to get specific category list
8 0.45876717567444 After getting categories Query to get specific category list
9 0.45876908302307 Before getting category custom Before call to function getCategoryCustom
10 0.46064519882202 After getting category custom After call to function getCategoryCustom
11 0.46064710617065 Before getting category custom Before call to function getCategoryCustom
12 0.47101211547852 After getting category custom After call to function getCategoryCustom
13 0.47101521492004 Before getting category custom Before call to function getCategoryCustom
14 0.47648119926453 After getting category custom After call to function getCategoryCustom
15 0.47648406028748 Before getting category custom Before call to function getCategoryCustom
16 0.48050117492676 After getting category custom After call to function getCategoryCustom
17 0.48050403594971 End of GetCategoryList function End of the function
18 0.48051309585571 Get Category List for Group Before the call to getCategoryList function
19 0.48051500320435 Start of GetCategoryList function Start of the function
20 0.48051810264587 Before getting categories Query to get specific category list
21 0.48094916343689 After getting categories Query to get specific category list
22 0.48095011711121 Before getting category custom Before call to function getCategoryCustom
23 0.48637914657593 After getting category custom After call to function getCategoryCustom
24 0.48638105392456 Before getting category custom Before call to function getCategoryCustom
25 0.49685001373291 After getting category custom After call to function getCategoryCustom
26 0.49685215950012 End of GetCategoryList function End of the function
27 0.4968581199646 Get Category List for Group Before the call to getCategoryList function
28 0.49686098098755 Start of GetCategoryList function Start of the function
29 0.49686408042908 Before getting categories Query to get specific category list
30 0.49768400192261 After getting categories Query to get specific category list
31 0.4976851940155 Before getting category custom Before call to function getCategoryCustom
32 0.50670909881592 After getting category custom After call to function getCategoryCustom
33 0.50671100616455 Before getting category custom Before call to function getCategoryCustom
34 0.52365708351135 After getting category custom After call to function getCategoryCustom
35 0.52365899085999 Before getting category custom Before call to function getCategoryCustom
36 0.52946209907532 After getting category custom After call to function getCategoryCustom
37 0.52946519851685 Before getting category custom Before call to function getCategoryCustom
38 0.5352520942688 After getting category custom After call to function getCategoryCustom
39 0.53525400161743 Before getting category custom Before call to function getCategoryCustom
40 0.54135417938232 After getting category custom After call to function getCategoryCustom
41 0.54135704040527 Before getting category custom Before call to function getCategoryCustom
42 0.56284403800964 After getting category custom After call to function getCategoryCustom
43 0.56284713745117 Before getting category custom Before call to function getCategoryCustom
44 0.56683707237244 After getting category custom After call to function getCategoryCustom
45 0.56683921813965 Before getting category custom Before call to function getCategoryCustom
46 0.57134103775024 After getting category custom After call to function getCategoryCustom
47 0.57134318351746 End of GetCategoryList function End of the function
48 0.57135605812073 Get Category List for Group Before the call to getCategoryList function
49 0.57135820388794 Start of GetCategoryList function Start of the function
50 0.57136201858521 Before getting categories Query to get specific category list
51 0.57178521156311 After getting categories Query to get specific category list
52 0.57178711891174 Before getting category custom Before call to function getCategoryCustom
53 0.57403016090393 After getting category custom After call to function getCategoryCustom
54 0.57403206825256 Before getting category custom Before call to function getCategoryCustom
55 0.57630920410156 After getting category custom After call to function getCategoryCustom
56 0.5763111114502 End of GetCategoryList function End of the function
57 0.57631707191467 Get Category List for Group Before the call to getCategoryList function
58 0.57631921768188 Start of GetCategoryList function Start of the function
59 0.57632207870483 Before getting categories Query to get specific category list
60 0.5766270160675 After getting categories Query to get specific category list
61 0.5766282081604 Before getting category custom Before call to function getCategoryCustom
62 0.58145999908447 After getting category custom After call to function getCategoryCustom
63 0.58146214485168 End of GetCategoryList function End of the function
64 0.58146810531616 End of getCategoryListByGroup Function Before return()
65 0.63279104232788 App Controller End End of the App controller (called before the controller of every page)
66 0.6344780921936 App_after Controller Start Start of the App_after controller (called after the controller of every page)
67 0.63462114334106 Before Get Options Before the call to getOptions in the tpl class
68 1.0421681404114 After Get Options After the call to getOptions in the tpl class
69 1.0422480106354 App_after Controller End End of the App_after controller (called after the controller of every page)
70 1.2581532001495 Finalizing debug Before the debug is output to the page.
71 1.2581691741943 End of App This is the end of the app logging, final timestamp


Query Debug - 604 Database Queries. Total time 0.5769 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0002 0.00016522407531738
SELECT value FROM parameters WHERE `parameter` = 'BAD_BOTS_ENABLER'
2 0.0005 0.00046014785766602
SHOW TABLES LIKE 'bad_bots'
3 0.0002 0.00015091896057129
SELECT value FROM parameters WHERE `parameter` = 'STORE_WHITELISTED_IPS'
4 0.0001 0.00014281272888184
SELECT * FROM `bad_bots`
5 0.0005 0.00046300888061523
SELECT parameter, value FROM parameters
6 0.0002 0.00017023086547852
SET time_zone = 'Europe/London'
7 0.0003 0.00028395652770996
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0001 0.00014400482177734
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0001 0.00010895729064941
delete from cachefiles
10 0.0002 0.00024986267089844
SELECT id FROM pages WHERE pagename = 'usa-green-tip-ammo-ban' LIMIT 1
11 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = 228
12 0.0008 0.00077605247497559
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
13 0.0095 0.0094950199127197
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
14 0.0003 0.00026392936706543
SELECT * FROM pages WHERE pagename = 'usa-green-tip-ammo-ban'
15 0.0002 0.00015401840209961
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0005 0.00051307678222656
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0005 0.00049591064453125
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.00023102760314941
SELECT id FROM categories WHERE parent_id = '49'
19 0.0004 0.00043416023254395
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.00015687942504883
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.00015401840209961
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.00017094612121582
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '49'
23 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '1'
24 0.0029 0.0029358863830566
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.0002 0.00024986267089844
SELECT id FROM categories WHERE parent_id = '50'
26 0.0002 0.00020098686218262
SELECT id FROM categories WHERE parent_id = '96'
27 0.0002 0.00020790100097656
SELECT id FROM categories WHERE parent_id = '97'
28 0.0002 0.0001978874206543
SELECT id FROM categories WHERE parent_id = '111'
29 0.0002 0.00019598007202148
SELECT id FROM categories WHERE parent_id = '129'
30 0.0056 0.005620002746582
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.00016689300537109
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.00015401840209961
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.0001680850982666
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '50'
34 0.0001 0.00012302398681641
SELECT * FROM categorygroups WHERE id = '1'
35 0.0023 0.0022649765014648
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.00025510787963867
SELECT id FROM categories WHERE parent_id = '80'
37 0.0023 0.0022609233856201
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.0001 0.00014495849609375
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.00015807151794434
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.00016212463378906
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '80'
41 0.0001 0.00012302398681641
SELECT * FROM categorygroups WHERE id = '1'
42 0.0011 0.0011310577392578
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 51
43 0.0002 0.0002439022064209
SELECT id FROM categories WHERE parent_id = '51'
44 0.0002 0.0001990795135498
SELECT id FROM categories WHERE parent_id = '101'
45 0.0017 0.0017471313476562
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.0001 0.00014996528625488
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.00015711784362793
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.00016593933105469
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '51'
49 0.0001 0.00012302398681641
SELECT * FROM categorygroups WHERE id = '1'
50 0.0004 0.00040698051452637
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
51 0.0023 0.0022509098052979
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
52 0.0002 0.00024700164794922
SELECT id FROM categories WHERE parent_id = '30'
53 0.0022 0.0022461414337158
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.0001 0.00014710426330566
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0 
55 0.0001 0.00014591217041016
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.00017595291137695
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
57 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '2'
58 0.0047 0.0047249794006348
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.00026702880859375
SELECT id FROM categories WHERE parent_id = '61'
60 0.0048 0.0047600269317627
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.00016117095947266
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.00014686584472656
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.00016283988952637
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '61'
64 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '2'
65 0.0007 0.00066518783569336
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '10'  AND hidden = 0 ORDER BY sortorder ASC
66 0.0040 0.0040371417999268
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.00026392936706543
SELECT id FROM categories WHERE parent_id = '64'
68 0.0040 0.0040218830108643
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.00017094612121582
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.00016093254089355
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '64'
72 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '10'
73 0.0079 0.0079450607299805
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.00027918815612793
SELECT id FROM categories WHERE parent_id = '65'
75 0.0080 0.0080039501190186
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.00017619132995605
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.0001 0.00014996528625488
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (65)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
78 0.0002 0.00016403198242188
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '65'
79 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '10'
80 0.0024 0.0024209022521973
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.00026392936706543
SELECT id FROM categories WHERE parent_id = '81'
82 0.0024 0.0024399757385254
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.0001 0.00014901161193848
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (81)
				  AND p.disabled = 0 
84 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 (81)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
85 0.0002 0.00015902519226074
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '81'
86 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '10'
87 0.0024 0.0024008750915527
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.00026607513427734
SELECT id FROM categories WHERE parent_id = '31'
89 0.0024 0.0024290084838867
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.00015497207641602
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.00014495849609375
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.00016283988952637
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
93 0.0001 0.00012803077697754
SELECT * FROM categorygroups WHERE id = '10'
94 0.0022 0.0021800994873047
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.00025105476379395
SELECT id FROM categories WHERE parent_id = '66'
96 0.0002 0.00020194053649902
SELECT id FROM categories WHERE parent_id = '131'
97 0.0028 0.00276780128479
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.0001530647277832
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (131,66)
				  AND p.disabled = 0 
99 0.0001 0.00014901161193848
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.00016903877258301
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '66'
101 0.0001 0.00012421607971191
SELECT * FROM categorygroups WHERE id = '10'
102 0.0093 0.0092549324035645
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.00027799606323242
SELECT id FROM categories WHERE parent_id = '34'
104 0.0002 0.00021505355834961
SELECT id FROM categories WHERE parent_id = '94'
105 0.0002 0.00020098686218262
SELECT id FROM categories WHERE parent_id = '98'
106 0.0002 0.00019717216491699
SELECT id FROM categories WHERE parent_id = '99'
107 0.0002 0.00019407272338867
SELECT id FROM categories WHERE parent_id = '110'
108 0.0002 0.00019288063049316
SELECT id FROM categories WHERE parent_id = '130'
109 0.0102 0.010162830352783
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.00018310546875
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.00015687942504883
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (94,98,99,110,130,34)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
112 0.0002 0.00017786026000977
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '34'
113 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '10'
114 0.0015 0.0015292167663574
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.00025391578674316
SELECT id FROM categories WHERE parent_id = '32'
116 0.0015 0.0015461444854736
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.00014495849609375
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (32)
				  AND p.disabled = 0 
118 0.0001 0.00014615058898926
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
				WHERE ep.id = c.product_id
				  AND c.category_id IN (32)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
119 0.0002 0.00015902519226074
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '32'
120 0.0001 0.0001220703125
SELECT * FROM categorygroups WHERE id = '10'
121 0.0018 0.001777172088623
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.0002 0.0002448558807373
SELECT id FROM categories WHERE parent_id = '89'
123 0.0018 0.0018010139465332
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.00014495849609375
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.00017404556274414
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '89'
127 0.0001 0.00012397766113281
SELECT * FROM categorygroups WHERE id = '10'
128 0.0004 0.00039482116699219
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '17'  AND hidden = 0 ORDER BY sortorder ASC
129 0.0007 0.00066494941711426
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.00023078918457031
SELECT id FROM categories WHERE parent_id = '84'
131 0.0007 0.00068306922912598
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.00014305114746094
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.00014305114746094
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.00016188621520996
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '84'
135 0.0001 0.00012087821960449
SELECT * FROM categorygroups WHERE id = '17'
136 0.0007 0.00068187713623047
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.00023078918457031
SELECT id FROM categories WHERE parent_id = '90'
138 0.0007 0.00070500373840332
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.00014305114746094
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.00014090538024902
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.00016307830810547
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '90'
142 0.0001 0.0001218318939209
SELECT * FROM categorygroups WHERE id = '17'
143 0.0003 0.00029206275939941
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '20'  AND hidden = 0 ORDER BY sortorder ASC
144 0.0020 0.001957893371582
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.00023698806762695
SELECT id FROM categories WHERE parent_id = '92'
146 0.0020 0.0019750595092773
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.00014400482177734
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.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 (92)
				  AND c.prod_type = 'ebay'
				  AND ep.hide = 1 
149 0.0001 0.00014805793762207
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '92'
150 0.0001 0.0001218318939209
SELECT * FROM categorygroups WHERE id = '20'
151 0.0051 0.0050718784332275
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
152 0.0004 0.0003659725189209
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
153 0.0002 0.0001828670501709
SELECT value FROM parameters WHERE parameter = 'EBAY_APP_ID' 
154 0.0002 0.00015687942504883
SELECT * FROM sideboxes_pages WHERE sidebox_id = '1'
155 0.0002 0.00017809867858887
SELECT * FROM pages WHERE id = '67'
156 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '82'
157 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '84'
158 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '94'
159 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '116'
160 0.0002 0.00020599365234375
SELECT * FROM pages WHERE id = '52'
161 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '135'
162 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '245'
163 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '269'
164 0.0002 0.0001981258392334
SELECT * FROM pages WHERE id = '275'
165 0.0002 0.00019407272338867
SELECT * FROM pages WHERE id = '280'
166 0.0002 0.00020098686218262
SELECT * FROM pages WHERE id = '357'
167 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '379'
168 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '401'
169 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '450'
170 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '454'
171 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '457'
172 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '458'
173 0.0002 0.00015497207641602
SELECT * FROM sideboxes_pages WHERE sidebox_id = '2'
174 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '41'
175 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '43'
176 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '44'
177 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '68'
178 0.0002 0.00021100044250488
SELECT * FROM pages WHERE id = '80'
179 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '85'
180 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '97'
181 0.0002 0.0001680850982666
SELECT * FROM pages WHERE id = '107'
182 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '108'
183 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '128'
184 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '133'
185 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '148'
186 0.0002 0.00017094612121582
SELECT * FROM pages WHERE id = '217'
187 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '228'
188 0.0001 0.00014281272888184
SELECT * FROM pages WHERE id = '257'
189 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '271'
190 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '286'
191 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '287'
192 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '291'
193 0.0002 0.00015616416931152
SELECT * FROM pages WHERE id = '380'
194 0.0002 0.00016617774963379
SELECT * FROM pages WHERE id = '344'
195 0.0002 0.00016117095947266
SELECT * FROM pages WHERE id = '354'
196 0.0002 0.00019097328186035
SELECT * FROM pages WHERE id = '363'
197 0.0002 0.00018692016601562
SELECT * FROM pages WHERE id = '364'
198 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '368'
199 0.0002 0.00016999244689941
SELECT * FROM pages WHERE id = '369'
200 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '400'
201 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '463'
202 0.0002 0.00016617774963379
SELECT * FROM sideboxes_pages WHERE sidebox_id = '33'
203 0.0003 0.0002739429473877
SELECT * FROM pages WHERE id = '66'
204 0.0002 0.00019192695617676
SELECT * FROM pages WHERE id = '77'
205 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '90'
206 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '414'
207 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '119'
208 0.0002 0.00015020370483398
SELECT * FROM pages WHERE id = '406'
209 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '149'
210 0.0001 0.00014781951904297
SELECT * FROM pages WHERE id = '150'
211 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '412'
212 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '162'
213 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '164'
214 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '167'
215 0.0001 0.00013613700866699
SELECT * FROM pages WHERE id = '180'
216 0.0001 0.0001368522644043
SELECT * FROM pages WHERE id = '187'
217 0.0002 0.0001978874206543
SELECT * FROM pages WHERE id = '265'
218 0.0002 0.00016593933105469
SELECT * FROM pages WHERE id = '268'
219 0.0001 0.00014281272888184
SELECT * FROM pages WHERE id = '411'
220 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '290'
221 0.0001 0.0001368522644043
SELECT * FROM pages WHERE id = '413'
222 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '409'
223 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '327'
224 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '336'
225 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '351'
226 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '358'
227 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '360'
228 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '362'
229 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '366'
230 0.0002 0.00017285346984863
SELECT * FROM pages WHERE id = '370'
231 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '377'
232 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '386'
233 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '408'
234 0.0002 0.0001521110534668
SELECT * FROM pages WHERE id = '415'
235 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '416'
236 0.0002 0.00018692016601562
SELECT * FROM pages WHERE id = '419'
237 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '423'
238 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '427'
239 0.0002 0.00018000602722168
SELECT * FROM pages WHERE id = '428'
240 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '432'
241 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '433'
242 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '436'
243 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '437'
244 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '461'
245 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '464'
246 0.0002 0.00015592575073242
SELECT * FROM sideboxes_pages WHERE sidebox_id = '34'
247 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '74'
248 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '137'
249 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = '145'
250 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '156'
251 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '407'
252 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '410'
253 0.0002 0.00018882751464844
SELECT * FROM pages WHERE id = '266'
254 0.0002 0.00020694732666016
SELECT * FROM pages WHERE id = '316'
255 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '332'
256 0.0002 0.00019001960754395
SELECT * FROM pages WHERE id = '334'
257 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '367'
258 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '387'
259 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '389'
260 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = '397'
261 0.0002 0.00015401840209961
SELECT * FROM pages WHERE id = '449'
262 0.0002 0.00017118453979492
SELECT * FROM sideboxes_pages WHERE sidebox_id = '35'
263 0.0002 0.0001978874206543
SELECT * FROM pages WHERE id = '42'
264 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '79'
265 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '86'
266 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '95'
267 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '102'
268 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '109'
269 0.0002 0.00021600723266602
SELECT * FROM pages WHERE id = '114'
270 0.0002 0.00017404556274414
SELECT * FROM pages WHERE id = '121'
271 0.0002 0.00020790100097656
SELECT * FROM pages WHERE id = '138'
272 0.0002 0.0001678466796875
SELECT * FROM pages WHERE id = '142'
273 0.0002 0.0001981258392334
SELECT * FROM pages WHERE id = '62'
274 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '157'
275 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '246'
276 0.0002 0.00019097328186035
SELECT * FROM pages WHERE id = '276'
277 0.0002 0.00019001960754395
SELECT * FROM pages WHERE id = '278'
278 0.0002 0.00021219253540039
SELECT * FROM pages WHERE id = '279'
279 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '317'
280 0.0001 0.00014615058898926
SELECT * FROM pages WHERE id = '405'
281 0.0002 0.00017213821411133
SELECT * FROM pages WHERE id = '343'
282 0.0002 0.00015997886657715
SELECT * FROM pages WHERE id = '345'
283 0.0002 0.00019383430480957
SELECT * FROM pages WHERE id = '346'
284 0.0002 0.0001528263092041
SELECT * FROM pages WHERE id = '347'
285 0.0002 0.00015687942504883
SELECT * FROM pages WHERE id = '348'
286 0.0001 0.00014877319335938
SELECT * FROM pages WHERE id = '349'
287 0.0002 0.00015783309936523
SELECT * FROM pages WHERE id = '381'
288 0.0001 0.00014996528625488
SELECT * FROM pages WHERE id = '392'
289 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '393'
290 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '394'
291 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '395'
292 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '399'
293 0.0002 0.00015497207641602
SELECT * FROM pages WHERE id = '421'
294 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '426'
295 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '430'
296 0.0001 0.00013899803161621
SELECT * FROM pages WHERE id = '431'
297 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '434'
298 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '435'
299 0.0002 0.00016403198242188
SELECT * FROM pages WHERE id = '440'
300 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '441'
301 0.0001 0.00014591217041016
SELECT * FROM pages WHERE id = '451'
302 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = '453'
303 0.0001 0.0001380443572998
SELECT * FROM sideboxes_pages WHERE sidebox_id = '37'
304 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '146'
305 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '158'
306 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '163'
307 0.0002 0.00022006034851074
SELECT * FROM pages WHERE id = '293'
308 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '340'
309 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '417'
310 0.0001 0.00013899803161621
SELECT * FROM sideboxes_pages WHERE sidebox_id = '40'
311 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '173'
312 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '181'
313 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '288'
314 0.0001 0.00014781951904297
SELECT * FROM pages WHERE id = '299'
315 0.0002 0.00016903877258301
SELECT * FROM pages WHERE id = '300'
316 0.0001 0.00014686584472656
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.0001 0.00014805793762207
SELECT * FROM pages WHERE id = '442'
320 0.0001 0.0001380443572998
SELECT * FROM sideboxes_pages WHERE sidebox_id = '38'
321 0.0003 0.00025010108947754
SELECT * FROM pages WHERE id = '103'
322 0.0002 0.00022006034851074
SELECT * FROM pages WHERE id = '134'
323 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '139'
324 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '143'
325 0.0002 0.00016212463378906
SELECT * FROM pages WHERE id = '234'
326 0.0002 0.00015592575073242
SELECT * FROM pages WHERE id = '248'
327 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '260'
328 0.0002 0.0001518726348877
SELECT * FROM pages WHERE id = '398'
329 0.0002 0.0001530647277832
SELECT * FROM sideboxes_pages WHERE sidebox_id = '29'
330 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '61'
331 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '87'
332 0.0002 0.00015902519226074
SELECT * FROM pages WHERE id = '104'
333 0.0002 0.00020599365234375
SELECT * FROM pages WHERE id = '115'
334 0.0001 0.00014305114746094
SELECT * FROM pages WHERE id = '124'
335 0.0002 0.00016093254089355
SELECT * FROM pages WHERE id = '144'
336 0.0002 0.0001838207244873
SELECT * FROM pages WHERE id = '151'
337 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '199'
338 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '200'
339 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = '304'
340 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '321'
341 0.0002 0.00015711784362793
SELECT * FROM pages WHERE id = '333'
342 0.0002 0.00015807151794434
SELECT * FROM pages WHERE id = '350'
343 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '378'
344 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '422'
345 0.0002 0.00017285346984863
SELECT * FROM pages WHERE id = '425'
346 0.0001 0.00014185905456543
SELECT * FROM pages WHERE id = '443'
347 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '444'
348 0.0002 0.00015091896057129
SELECT * FROM pages WHERE id = '445'
349 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '446'
350 0.0001 0.00014114379882812
SELECT * FROM pages WHERE id = '447'
351 0.0001 0.00014710426330566
SELECT * FROM pages WHERE id = '448'
352 0.0001 0.00014090538024902
SELECT * FROM pages WHERE id = '455'
353 0.0002 0.00016307830810547
SELECT * FROM pages WHERE id = '456'
354 0.0001 0.00013995170593262
SELECT * FROM pages WHERE id = '459'
355 0.0002 0.0001530647277832
SELECT * FROM pages WHERE id = '460'
356 0.0001 0.00014901161193848
SELECT * FROM pages WHERE id = '462'
357 0.0001 0.00013995170593262
SELECT * FROM sideboxes_pages WHERE sidebox_id = '32'
358 0.0002 0.00017595291137695
SELECT * FROM pages WHERE id = '153'
359 0.0002 0.0001990795135498
SELECT * FROM pages WHERE id = '182'
360 0.0001 0.00014519691467285
SELECT * FROM pages WHERE id = '238'
361 0.0001 0.00014209747314453
SELECT * FROM pages WHERE id = '240'
362 0.0001 0.00013589859008789
SELECT * FROM pages WHERE id = '242'
363 0.0001 0.00013518333435059
SELECT * FROM pages WHERE id = '252'
364 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '253'
365 0.0001 0.0001370906829834
SELECT * FROM pages WHERE id = '262'
366 0.0001 0.00013494491577148
SELECT * FROM pages WHERE id = '267'
367 0.0001 0.00014495849609375
SELECT * FROM pages WHERE id = '420'
368 0.0001 0.00012898445129395
SELECT value FROM parameters WHERE parameter = 'GOOGLE_SITE_KEY' 
369 0.0001 0.00011801719665527
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.0013 0.0013160705566406
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
372 0.0003 0.00026392936706543
SELECT * FROM pages WHERE pagename = 'usa-green-tip-ammo-ban'
373 0.0002 0.00021696090698242
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
374 0.0002 0.00019383430480957
SELECT * FROM pages WHERE id = 2
375 0.0001 0.00014805793762207
SELECT * FROM pages WHERE id = 4
376 0.0001 0.00013399124145508
SELECT * FROM pages WHERE id = 12
377 0.0001 0.00014400482177734
SELECT * FROM pages WHERE id = 10
378 0.0001 0.00013279914855957
SELECT * FROM pages WHERE id = 7
379 0.0001 0.0001368522644043
SELECT * FROM pages WHERE id = 18
380 0.0001 0.0001370906829834
SELECT * FROM pages WHERE id = 28
381 0.0001 0.00014686584472656
SELECT * FROM pages WHERE id = 13
382 0.0001 0.00013494491577148
SELECT * FROM pages WHERE id = 3
383 0.0424 0.042396068572998
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
384 0.0002 0.00024700164794922
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:1560835206;s:8:\"products\";a:6:{i:2;s:6:\"407595\";i:4;s:6:\"171938\";i:8;s:6:\"408792\";i:12;s:6:\"414825\";i:15;s:6:\"130885\";i:21;s:6:\"406901\";}}' WHERE id = '175'
385 0.0004 0.00043296813964844
SELECT * FROM products WHERE id IN (407595,171938,408792,414825,130885,406901) ORDER BY FIELD(id, 407595,171938,408792,414825,130885,406901 )
386 0.0002 0.0002448558807373
SELECT * FROM productimages WHERE product_id = '407595' ORDER BY sortorder ASC
387 0.0002 0.00022506713867188
SELECT * FROM product_image_select WHERE product_id = '407595'
388 0.0001 0.00012707710266113
SELECT * FROM productcustomimages WHERE product_id = '407595'
389 0.0033 0.0033001899719238
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407595' AND a.name = n.originalname
390 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '407595' AND merchantid = 'ATVPDKIKX0DER'
391 0.0002 0.00020909309387207
SELECT * FROM productoffers
                WHERE product_id = '407595' AND price > 0
                ORDER BY price ASC LIMIT 1
392 0.0004 0.00043511390686035
SELECT value FROM productattributes WHERE product_id = '407595' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
393 0.0001 0.0001220703125
UPDATE products SET price = '2497' WHERE id = '407595'
394 0.0006 0.00063586235046387
SELECT * FROM productimages WHERE product_id = '171938' ORDER BY sortorder ASC
395 0.0002 0.00022292137145996
SELECT * FROM product_image_select WHERE product_id = '171938'
396 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '171938'
397 0.0025 0.0024759769439697
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '171938' AND a.name = n.originalname
398 0.0002 0.00018692016601562
SELECT * FROM productoffers WHERE product_id = '171938' AND merchantid = 'ATVPDKIKX0DER'
399 0.0002 0.00021600723266602
SELECT * FROM productoffers
                WHERE product_id = '171938' AND price > 0
                ORDER BY price ASC LIMIT 1
400 0.0004 0.00038886070251465
SELECT value FROM productattributes WHERE product_id = '171938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
401 0.0001 0.00011777877807617
UPDATE products SET price = '389500' WHERE id = '171938'
402 0.0002 0.0001990795135498
SELECT * FROM productimages WHERE product_id = '408792' ORDER BY sortorder ASC
403 0.0002 0.00021481513977051
SELECT * FROM product_image_select WHERE product_id = '408792'
404 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '408792'
405 0.0035 0.0035238265991211
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408792' AND a.name = n.originalname
406 0.0002 0.0001828670501709
SELECT * FROM productoffers WHERE product_id = '408792' AND merchantid = 'ATVPDKIKX0DER'
407 0.0002 0.0001981258392334
SELECT * FROM productoffers
                WHERE product_id = '408792' AND price > 0
                ORDER BY price ASC LIMIT 1
408 0.0004 0.00044107437133789
SELECT value FROM productattributes WHERE product_id = '408792' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
409 0.0001 0.00011706352233887
UPDATE products SET price = '13499' WHERE id = '408792'
410 0.0002 0.00021481513977051
SELECT * FROM productimages WHERE product_id = '414825' ORDER BY sortorder ASC
411 0.0002 0.00020790100097656
SELECT * FROM product_image_select WHERE product_id = '414825'
412 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '414825'
413 0.0020 0.0020210742950439
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414825' AND a.name = n.originalname
414 0.0002 0.00019311904907227
SELECT * FROM productoffers WHERE product_id = '414825' AND merchantid = 'ATVPDKIKX0DER'
415 0.0002 0.00020980834960938
SELECT * FROM productoffers
                WHERE product_id = '414825' AND price > 0
                ORDER BY price ASC LIMIT 1
416 0.0004 0.00037097930908203
SELECT value FROM productattributes WHERE product_id = '414825' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
417 0.0001 0.00011897087097168
UPDATE products SET price = '11999' WHERE id = '414825'
418 0.0002 0.00019192695617676
SELECT * FROM productimages WHERE product_id = '130885' ORDER BY sortorder ASC
419 0.0002 0.00020599365234375
SELECT * FROM product_image_select WHERE product_id = '130885'
420 0.0001 0.00013017654418945
SELECT * FROM productcustomimages WHERE product_id = '130885'
421 0.0019 0.0019471645355225
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '130885' AND a.name = n.originalname
422 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '130885' AND merchantid = 'ATVPDKIKX0DER'
423 0.0002 0.00019383430480957
SELECT * FROM productoffers
                WHERE product_id = '130885' AND price > 0
                ORDER BY price ASC LIMIT 1
424 0.0004 0.0003509521484375
SELECT value FROM productattributes WHERE product_id = '130885' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
425 0.0001 0.00011897087097168
UPDATE products SET price = '1521' WHERE id = '130885'
426 0.0002 0.00020694732666016
SELECT * FROM productimages WHERE product_id = '406901' ORDER BY sortorder ASC
427 0.0002 0.00020289421081543
SELECT * FROM product_image_select WHERE product_id = '406901'
428 0.0001 0.00012016296386719
SELECT * FROM productcustomimages WHERE product_id = '406901'
429 0.0023 0.0023021697998047
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406901' AND a.name = n.originalname
430 0.0002 0.00019001960754395
SELECT * FROM productoffers WHERE product_id = '406901' AND merchantid = 'ATVPDKIKX0DER'
431 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '406901' AND price > 0
                ORDER BY price ASC LIMIT 1
432 0.0003 0.00034213066101074
SELECT value FROM productattributes WHERE product_id = '406901' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
433 0.0001 0.00012016296386719
UPDATE products SET price = '395' WHERE id = '406901'
434 0.0421 0.042117118835449
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
435 0.0002 0.00021791458129883
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:1560835206;s:8:\"products\";a:6:{i:2;s:6:\"407595\";i:4;s:6:\"171938\";i:7;s:6:\"409759\";i:16;s:6:\"408078\";i:20;s:6:\"408079\";i:21;s:6:\"406901\";}}' WHERE id = '177'
436 0.0004 0.0004429817199707
SELECT * FROM products WHERE id IN (407595,171938,409759,408078,408079,406901) ORDER BY FIELD(id, 407595,171938,409759,408078,408079,406901 )
437 0.0002 0.00024795532226562
SELECT * FROM productimages WHERE product_id = '407595' ORDER BY sortorder ASC
438 0.0002 0.00020408630371094
SELECT * FROM product_image_select WHERE product_id = '407595'
439 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '407595'
440 0.0033 0.003324031829834
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407595' AND a.name = n.originalname
441 0.0002 0.00019311904907227
SELECT * FROM productoffers WHERE product_id = '407595' AND merchantid = 'ATVPDKIKX0DER'
442 0.0002 0.00020194053649902
SELECT * FROM productoffers
                WHERE product_id = '407595' AND price > 0
                ORDER BY price ASC LIMIT 1
443 0.0004 0.00042891502380371
SELECT value FROM productattributes WHERE product_id = '407595' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
444 0.0001 0.00011897087097168
UPDATE products SET price = '2497' WHERE id = '407595'
445 0.0006 0.00061988830566406
SELECT * FROM productimages WHERE product_id = '171938' ORDER BY sortorder ASC
446 0.0002 0.0002281665802002
SELECT * FROM product_image_select WHERE product_id = '171938'
447 0.0001 0.00013089179992676
SELECT * FROM productcustomimages WHERE product_id = '171938'
448 0.0025 0.0024821758270264
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '171938' AND a.name = n.originalname
449 0.0002 0.00019192695617676
SELECT * FROM productoffers WHERE product_id = '171938' AND merchantid = 'ATVPDKIKX0DER'
450 0.0002 0.00021696090698242
SELECT * FROM productoffers
                WHERE product_id = '171938' AND price > 0
                ORDER BY price ASC LIMIT 1
451 0.0004 0.00038886070251465
SELECT value FROM productattributes WHERE product_id = '171938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
452 0.0001 0.00011706352233887
UPDATE products SET price = '389500' WHERE id = '171938'
453 0.0002 0.00020694732666016
SELECT * FROM productimages WHERE product_id = '409759' ORDER BY sortorder ASC
454 0.0002 0.00021505355834961
SELECT * FROM product_image_select WHERE product_id = '409759'
455 0.0001 0.00012111663818359
SELECT * FROM productcustomimages WHERE product_id = '409759'
456 0.0027 0.0027410984039307
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '409759' AND a.name = n.originalname
457 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '409759' AND merchantid = 'ATVPDKIKX0DER'
458 0.0002 0.00020003318786621
SELECT * FROM productoffers
                WHERE product_id = '409759' AND price > 0
                ORDER BY price ASC LIMIT 1
459 0.0004 0.00039792060852051
SELECT value FROM productattributes WHERE product_id = '409759' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
460 0.0001 0.00013208389282227
UPDATE products SET price = '229000' WHERE id = '409759'
461 0.0002 0.00020313262939453
SELECT * FROM productimages WHERE product_id = '408078' ORDER BY sortorder ASC
462 0.0002 0.00021004676818848
SELECT * FROM product_image_select WHERE product_id = '408078'
463 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '408078'
464 0.0030 0.0029900074005127
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408078' AND a.name = n.originalname
465 0.0002 0.00018405914306641
SELECT * FROM productoffers WHERE product_id = '408078' AND merchantid = 'ATVPDKIKX0DER'
466 0.0002 0.00021004676818848
SELECT * FROM productoffers
                WHERE product_id = '408078' AND price > 0
                ORDER BY price ASC LIMIT 1
467 0.0004 0.00040698051452637
SELECT value FROM productattributes WHERE product_id = '408078' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
468 0.0001 0.00012016296386719
UPDATE products SET price = '23352' WHERE id = '408078'
469 0.0002 0.00017404556274414
SELECT * FROM productimages WHERE product_id = '408079' ORDER BY sortorder ASC
470 0.0002 0.00021982192993164
SELECT * FROM product_image_select WHERE product_id = '408079'
471 0.0001 0.0001220703125
SELECT * FROM productcustomimages WHERE product_id = '408079'
472 0.0031 0.0031249523162842
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408079' AND a.name = n.originalname
473 0.0002 0.00019001960754395
SELECT * FROM productoffers WHERE product_id = '408079' AND merchantid = 'ATVPDKIKX0DER'
474 0.0002 0.00020194053649902
SELECT * FROM productoffers
                WHERE product_id = '408079' AND price > 0
                ORDER BY price ASC LIMIT 1
475 0.0004 0.00038886070251465
SELECT value FROM productattributes WHERE product_id = '408079' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
476 0.0001 0.00011992454528809
UPDATE products SET price = '18547' WHERE id = '408079'
477 0.0002 0.00019502639770508
SELECT * FROM productimages WHERE product_id = '406901' ORDER BY sortorder ASC
478 0.0002 0.00020384788513184
SELECT * FROM product_image_select WHERE product_id = '406901'
479 0.0001 0.00012993812561035
SELECT * FROM productcustomimages WHERE product_id = '406901'
480 0.0023 0.0022940635681152
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406901' AND a.name = n.originalname
481 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '406901' AND merchantid = 'ATVPDKIKX0DER'
482 0.0002 0.00019383430480957
SELECT * FROM productoffers
                WHERE product_id = '406901' AND price > 0
                ORDER BY price ASC LIMIT 1
483 0.0003 0.00034999847412109
SELECT value FROM productattributes WHERE product_id = '406901' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
484 0.0001 0.00011897087097168
UPDATE products SET price = '395' WHERE id = '406901'
485 0.1022 0.10223197937012
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
486 0.0003 0.00028204917907715
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:1560835207;s:8:\"products\";a:6:{i:2;s:6:\"407595\";i:4;s:6:\"171938\";i:8;s:6:\"408792\";i:10;s:6:\"370121\";i:14;s:6:\"406758\";i:17;s:6:\"405644\";}}' WHERE id = '181'
487 0.0004 0.00044608116149902
SELECT * FROM products WHERE id IN (407595,171938,408792,370121,406758,405644) ORDER BY FIELD(id, 407595,171938,408792,370121,406758,405644 )
488 0.0002 0.0002439022064209
SELECT * FROM productimages WHERE product_id = '407595' ORDER BY sortorder ASC
489 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '407595'
490 0.0001 0.00012493133544922
SELECT * FROM productcustomimages WHERE product_id = '407595'
491 0.0033 0.0033190250396729
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407595' AND a.name = n.originalname
492 0.0002 0.00018501281738281
SELECT * FROM productoffers WHERE product_id = '407595' AND merchantid = 'ATVPDKIKX0DER'
493 0.0002 0.00021195411682129
SELECT * FROM productoffers
                WHERE product_id = '407595' AND price > 0
                ORDER BY price ASC LIMIT 1
494 0.0004 0.00043702125549316
SELECT value FROM productattributes WHERE product_id = '407595' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
495 0.0001 0.00011992454528809
UPDATE products SET price = '2497' WHERE id = '407595'
496 0.0006 0.0006251335144043
SELECT * FROM productimages WHERE product_id = '171938' ORDER BY sortorder ASC
497 0.0002 0.00022602081298828
SELECT * FROM product_image_select WHERE product_id = '171938'
498 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '171938'
499 0.0025 0.0024888515472412
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '171938' AND a.name = n.originalname
500 0.0002 0.00018906593322754
SELECT * FROM productoffers WHERE product_id = '171938' AND merchantid = 'ATVPDKIKX0DER'
501 0.0002 0.00020599365234375
SELECT * FROM productoffers
                WHERE product_id = '171938' AND price > 0
                ORDER BY price ASC LIMIT 1
502 0.0004 0.0003969669342041
SELECT value FROM productattributes WHERE product_id = '171938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
503 0.0001 0.00011801719665527
UPDATE products SET price = '389500' WHERE id = '171938'
504 0.0002 0.0001988410949707
SELECT * FROM productimages WHERE product_id = '408792' ORDER BY sortorder ASC
505 0.0002 0.00021505355834961
SELECT * FROM product_image_select WHERE product_id = '408792'
506 0.0001 0.00012898445129395
SELECT * FROM productcustomimages WHERE product_id = '408792'
507 0.0035 0.0035128593444824
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '408792' AND a.name = n.originalname
508 0.0002 0.00018715858459473
SELECT * FROM productoffers WHERE product_id = '408792' AND merchantid = 'ATVPDKIKX0DER'
509 0.0002 0.00020599365234375
SELECT * FROM productoffers
                WHERE product_id = '408792' AND price > 0
                ORDER BY price ASC LIMIT 1
510 0.0004 0.00044107437133789
SELECT value FROM productattributes WHERE product_id = '408792' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
511 0.0001 0.00011706352233887
UPDATE products SET price = '13499' WHERE id = '408792'
512 0.0002 0.00018596649169922
SELECT * FROM productimages WHERE product_id = '370121' ORDER BY sortorder ASC
513 0.0002 0.00021600723266602
SELECT * FROM product_image_select WHERE product_id = '370121'
514 0.0001 0.00012302398681641
SELECT * FROM productcustomimages WHERE product_id = '370121'
515 0.0027 0.002701997756958
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '370121' AND a.name = n.originalname
516 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '370121' AND merchantid = 'ATVPDKIKX0DER'
517 0.0002 0.00019979476928711
SELECT * FROM productoffers
                WHERE product_id = '370121' AND price > 0
                ORDER BY price ASC LIMIT 1
518 0.0004 0.00038790702819824
SELECT value FROM productattributes WHERE product_id = '370121' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
519 0.0001 0.00012588500976562
UPDATE products SET price = '9899' WHERE id = '370121'
520 0.0002 0.00018501281738281
SELECT * FROM productimages WHERE product_id = '406758' ORDER BY sortorder ASC
521 0.0002 0.00020790100097656
SELECT * FROM product_image_select WHERE product_id = '406758'
522 0.0001 0.00012087821960449
SELECT * FROM productcustomimages WHERE product_id = '406758'
523 0.0026 0.0025560855865479
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406758' AND a.name = n.originalname
524 0.0002 0.00018310546875
SELECT * FROM productoffers WHERE product_id = '406758' AND merchantid = 'ATVPDKIKX0DER'
525 0.0002 0.00019717216491699
SELECT * FROM productoffers
                WHERE product_id = '406758' AND price > 0
                ORDER BY price ASC LIMIT 1
526 0.0004 0.0003960132598877
SELECT value FROM productattributes WHERE product_id = '406758' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
527 0.0001 0.00012016296386719
UPDATE products SET price = '2694' WHERE id = '406758'
528 0.0002 0.00018000602722168
SELECT * FROM productimages WHERE product_id = '405644' ORDER BY sortorder ASC
529 0.0002 0.00020623207092285
SELECT * FROM product_image_select WHERE product_id = '405644'
530 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '405644'
531 0.0033 0.0033111572265625
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '405644' AND a.name = n.originalname
532 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '405644' AND merchantid = 'ATVPDKIKX0DER'
533 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '405644' AND price > 0
                ORDER BY price ASC LIMIT 1
534 0.0004 0.00042605400085449
SELECT value FROM productattributes WHERE product_id = '405644' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
535 0.0001 0.00011897087097168
UPDATE products SET price = '63539' WHERE id = '405644'
536 0.1021 0.10207605361938
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
537 0.0003 0.0002598762512207
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:1560835207;s:8:\"products\";a:6:{i:7;s:6:\"409759\";i:13;s:6:\"414188\";i:0;s:6:\"414940\";i:1;s:6:\"398315\";i:2;s:6:\"407595\";i:14;s:6:\"406758\";}}' WHERE id = '183'
538 0.0005 0.00045990943908691
SELECT * FROM products WHERE id IN (409759,414188,414940,398315,407595,406758) ORDER BY FIELD(id, 409759,414188,414940,398315,407595,406758 )
539 0.0002 0.00022077560424805
SELECT * FROM productimages WHERE product_id = '409759' ORDER BY sortorder ASC
540 0.0002 0.00020694732666016
SELECT * FROM product_image_select WHERE product_id = '409759'
541 0.0001 0.00012397766113281
SELECT * FROM productcustomimages WHERE product_id = '409759'
542 0.0028 0.0027549266815186
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '409759' AND a.name = n.originalname
543 0.0002 0.00018787384033203
SELECT * FROM productoffers WHERE product_id = '409759' AND merchantid = 'ATVPDKIKX0DER'
544 0.0002 0.00021600723266602
SELECT * FROM productoffers
                WHERE product_id = '409759' AND price > 0
                ORDER BY price ASC LIMIT 1
545 0.0004 0.00040817260742188
SELECT value FROM productattributes WHERE product_id = '409759' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
546 0.0001 0.00012421607971191
UPDATE products SET price = '229000' WHERE id = '409759'
547 0.0003 0.00026488304138184
SELECT * FROM productimages WHERE product_id = '414188' ORDER BY sortorder ASC
548 0.0002 0.00021815299987793
SELECT * FROM product_image_select WHERE product_id = '414188'
549 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '414188'
550 0.0025 0.0025079250335693
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414188' AND a.name = n.originalname
551 0.0002 0.00019097328186035
SELECT * FROM productoffers WHERE product_id = '414188' AND merchantid = 'ATVPDKIKX0DER'
552 0.0002 0.00019502639770508
SELECT * FROM productoffers
                WHERE product_id = '414188' AND price > 0
                ORDER BY price ASC LIMIT 1
553 0.0004 0.00038409233093262
SELECT value FROM productattributes WHERE product_id = '414188' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
554 0.0001 0.00011706352233887
UPDATE products SET price = '9999' WHERE id = '414188'
555 0.0002 0.00018310546875
SELECT * FROM productimages WHERE product_id = '414940' ORDER BY sortorder ASC
556 0.0002 0.0002129077911377
SELECT * FROM product_image_select WHERE product_id = '414940'
557 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '414940'
558 0.0032 0.0031769275665283
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '414940' AND a.name = n.originalname
559 0.0002 0.00018596649169922
SELECT * FROM productoffers WHERE product_id = '414940' AND merchantid = 'ATVPDKIKX0DER'
560 0.0002 0.0002138614654541
SELECT * FROM productoffers
                WHERE product_id = '414940' AND price > 0
                ORDER BY price ASC LIMIT 1
561 0.0004 0.00042581558227539
SELECT value FROM productattributes WHERE product_id = '414940' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
562 0.0001 0.00011587142944336
UPDATE products SET price = '4490' WHERE id = '414940'
563 0.0002 0.00019717216491699
SELECT * FROM productimages WHERE product_id = '398315' ORDER BY sortorder ASC
564 0.0002 0.0002138614654541
SELECT * FROM product_image_select WHERE product_id = '398315'
565 0.0001 0.0001218318939209
SELECT * FROM productcustomimages WHERE product_id = '398315'
566 0.0024 0.0024290084838867
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '398315' AND a.name = n.originalname
567 0.0002 0.00018191337585449
SELECT * FROM productoffers WHERE product_id = '398315' AND merchantid = 'ATVPDKIKX0DER'
568 0.0002 0.00020503997802734
SELECT * FROM productoffers
                WHERE product_id = '398315' AND price > 0
                ORDER BY price ASC LIMIT 1
569 0.0004 0.00038313865661621
SELECT value FROM productattributes WHERE product_id = '398315' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
570 0.0001 0.00011992454528809
UPDATE products SET price = '1999' WHERE id = '398315'
571 0.0002 0.00022387504577637
SELECT * FROM productimages WHERE product_id = '407595' ORDER BY sortorder ASC
572 0.0002 0.00021100044250488
SELECT * FROM product_image_select WHERE product_id = '407595'
573 0.0001 0.00011992454528809
SELECT * FROM productcustomimages WHERE product_id = '407595'
574 0.0033 0.0032939910888672
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '407595' AND a.name = n.originalname
575 0.0002 0.00018095970153809
SELECT * FROM productoffers WHERE product_id = '407595' AND merchantid = 'ATVPDKIKX0DER'
576 0.0002 0.00020384788513184
SELECT * FROM productoffers
                WHERE product_id = '407595' AND price > 0
                ORDER BY price ASC LIMIT 1
577 0.0004 0.00042581558227539
SELECT value FROM productattributes WHERE product_id = '407595' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
578 0.0001 0.00011682510375977
UPDATE products SET price = '2497' WHERE id = '407595'
579 0.0002 0.00019001960754395
SELECT * FROM productimages WHERE product_id = '406758' ORDER BY sortorder ASC
580 0.0002 0.00021719932556152
SELECT * FROM product_image_select WHERE product_id = '406758'
581 0.0001 0.00011897087097168
SELECT * FROM productcustomimages WHERE product_id = '406758'
582 0.0026 0.0025558471679688
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '406758' AND a.name = n.originalname
583 0.0002 0.00019097328186035
SELECT * FROM productoffers WHERE product_id = '406758' AND merchantid = 'ATVPDKIKX0DER'
584 0.0002 0.00019598007202148
SELECT * FROM productoffers
                WHERE product_id = '406758' AND price > 0
                ORDER BY price ASC LIMIT 1
585 0.0004 0.00038409233093262
SELECT value FROM productattributes WHERE product_id = '406758' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
586 0.0001 0.00011801719665527
UPDATE products SET price = '2694' WHERE id = '406758'
587 0.0005 0.00046992301940918
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
588 0.0001 0.00013303756713867
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
589 0.0001 0.00012111663818359
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
590 0.0001 0.0001218318939209
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
591 0.0004 0.00038814544677734
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
592 0.0001 0.00012612342834473
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
593 0.0001 0.00012421607971191
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
594 0.0009 0.00091195106506348
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
595 0.0003 0.00030303001403809
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
596 0.0003 0.00027894973754883
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
597 0.0004 0.00036096572875977
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
598 0.0001 0.00013589859008789
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
599 0.0001 0.00012016296386719
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
600 0.0001 0.00013113021850586
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
601 0.0001 0.00012016296386719
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
602 0.0001 0.00011706352233887
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
603 0.0003 0.00033307075500488
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'
604 0.0003 0.00031781196594238
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_CUSTOM_BANNER'