hot queries

hot queries

dao.query                                                                      count (times/s, m1)    duration (ms, mean)  count*duration
---                                                                            ---                    ---                  ---
com.navixy.apiserver.storage.dao.HistoryDao.getUnreadCountTrackers             16.910988115064935     34.52788928728147    583.9007253754947
com.navixy.apiserver.storage.dao.ChatMessagesDao.getUnreadIncomingCounts       23.00383369376803      19.755927569260955   454.4620722694059
com.navixy.apiserver.storage.dao.TrackerDao.getTrackerInfo                     20.156757997465466     21.37336715330609    430.8177893001683
com.navixy.apiserver.storage.dao.SensorDao.getDiscreteInputs                   16.539122047415464     24.782417269824435   409.8794238556031
com.navixy.apiserver.storage.dao.HistoryDao.getTrackersHistory                 10.926893378445559     33.5619322390539     366.7276551507566
com.navixy.apiserver.storage.dao.SensorDao.getSensors                          17.288942685209694     14.608167094551739   252.55976363367122
com.navixy.apiserver.storage.dao.TariffDao.getTariff                           36.22633153170559      6.080669149376914    220.2803365399423
com.navixy.apiserver.storage.dao.TrackerDao.getUserTrackers                    13.70612507463973      14.883010869944421   203.98840847068087
com.navixy.apiserver.storage.dao.SensorDao.getLastValue                        30.075508888989063     6.0287965662860925   181.31912471924412
com.navixy.apiserver.storage.dao.TrackerDao.getSourceLink                      32.487960762201176     5.437122883301709    176.64103489197203
com.navixy.apiserver.storage.dao.SensorDao.getSensorsBoundaryValues            25.726681898221056     4.607310571386699    118.5308134763767
com.navixy.apiserver.storage.dao.TrackingDao.getUnchargedActiveDays            3.479482223127597      29.05886000972254    101.109786828183
com.navixy.apiserver.storage.dao.UserDao.getShowNotifications                  7.6464752125901905     10.62718433602817    81.26050160506615
com.navixy.apiserver.storage.dao.UserSessionDao.findByHash                     7.563837018178889      9.798216159527726    74.1121100995544
com.navixy.apiserver.storage.dao.SensorDao.getMeteringSensors                  5.8197744794066635     9.246276973983706    53.81124676271584
com.navixy.apiserver.storage.dao.TariffDao.listUserTariffs                     2.892091322375834      15.588214152667074   45.082538882264615
com.navixy.apiserver.storage.dao.UserDao.getNotifications                      4.32989196495812       8.3965284530321      36.35606108232592
com.navixy.apiserver.storage.dao.CountersDao.getCountersList                   3.6538218081664664     9.258928510516688    33.83047491198013
com.navixy.apiserver.storage.dao.TrackingDao.getTrackPointByGetTime            6.63729720222674       4.333679071955929    28.763915979641663
com.navixy.apiserver.storage.dao.UserDao.getSettings                           5.7287398124608515     4.9116675456157814   28.137665414141004
com.navixy.apiserver.storage.dao.TrackerDao.getTrackerModel                    2.7259541274595867     8.109245007774447    22.105429899523802
com.navixy.apiserver.storage.dao.DealerDao.getDealerContractInfo               2.927475671924247      7.172092384483193    20.99612597236771
com.navixy.apiserver.storage.dao.SensorDao.getData                             0.0010076927083719376  19915.02127996052    20.06822173088819
com.navixy.apiserver.storage.dao.PluginDao.getDealerPluginIds                  2.6843483020301058     6.7871858633056155   18.219170847727167
com.navixy.apiserver.storage.dao.TariffDao.getTrackersToSwitchOff              0.037775120567512394   468.43409700000007   17.6951544921088
com.navixy.apiserver.storage.dao.TrackerDao.countTrackersWithDiscount          3.8097360048854356     4.4963962555332895   17.130082706937227
com.navixy.apiserver.storage.dao.CountersDao.getLastValue                      1.6464381760047695     9.759796382625815    16.068901354388395
com.navixy.apiserver.storage.dao.HistoryDao.getUnreadListTrackers              1.4260307922869593     10.751001697058973   15.331259467935451
com.navixy.apiserver.storage.dao.TrackerDao.createTrackerObject                0.155760156614281      92.956123            14.478860276736368
com.navixy.apiserver.storage.dao.PluginDao.getUserPluginIds                    2.6417579514751246     5.05456405264838     13.352934777324188
com.navixy.apiserver.storage.dao.TrackingDao.getTracksList                     0.255416839907903      48.880862423858744   12.484995412274959
com.navixy.apiserver.storage.dao.UserDao.getUserInfo                           1.1711434720508658     10.136774009112393   11.871616708426863
com.navixy.apiserver.storage.dao.DealerDao.getPaasSettings                     1.3388579395468985     7.97961332675144     10.683568657035405
com.navixy.apiserver.storage.dao.UserSessionDao.logRequest                     0.4964996921328738     14.660367487502445   7.278867944099757
com.navixy.apiserver.storage.dao.PlacesDao.create                              0.16929634497812282    39.583737            6.701381994675284
com.navixy.panel.storage.dao.PanelSessionDao.getRights                         0.7248454374996908     8.224747499531404    5.961670699622328
com.navixy.apiserver.storage.dao.TariffDao.listByDeviceType                    0.41411803608126885    14.382446266112884   5.956030401767046
com.navixy.panel.storage.dao.PanelSessionDao.findByHash                        0.6262505396874125     9.306402160423357    5.828139375513229
com.navixy.apiserver.storage.dao.ReportDao.getSheetStates                      0.3828186001969405     15.153431723801466   5.801015520685588
com.navixy.apiserver.storage.dao.TrackerDao.listTrackers                       0.13097511652177282    41.13444498063042    5.387588724396522
com.navixy.apiserver.storage.dao.TrackerDao.getTrackerGroups                   0.4530876585976545     10.294693466946283   4.664398558919261
com.navixy.apiserver.storage.dao.TrackingDao.createTrackingTable               0.155760156614281      29.736578            4.631774046452783
com.navixy.apiserver.storage.dao.UserSessionDao.replacePushToken               0.36879805864384224    12.505532561872775   4.612016131126034
com.navixy.apiserver.storage.dao.PluginDao.getPlugins                          0.7187598917291548     6.104308261584277    4.387531945177701
com.navixy.apiserver.storage.dao.PaymentsDao.getPaymentSystem                  0.8035111437449872     5.397698323750877    4.337110753707467
com.navixy.apiserver.storage.dao.TrackerDao.updateSettings                     0.155760156614281      23.672797000000003   3.687278568218082
com.navixy.apiserver.storage.dao.TariffDao.getSubTariffs                       0.5927677164096377     5.522208224345444    3.2733867586837686
com.navixy.apiserver.storage.dao.HistoryDao.getUnreadList                      0.269769066811908      12.111957844578944   3.26743156499723
com.navixy.apiserver.storage.dao.PlacesDao.list                                0.31879165047065056    9.767374006400312    3.113757280264486
com.navixy.apiserver.storage.dao.UserSessionDao.createSession                  0.28881351202382455    10.451133809942688   3.0184286602804815
com.navixy.apiserver.storage.dao.TrackerDao.getEngineImmobilizerState          0.5023981929340277     5.602412675294073    2.8146420041384337
com.navixy.apiserver.storage.dao.TrackerDao.getAlarmState                      0.515783022425552      5.415668530968825    2.793309883358049
com.navixy.apiserver.storage.dao.TariffDao.getTrackersToSwitchOn               0.037775120567512394   71.104245            2.6859714277369404
com.navixy.apiserver.storage.dao.UserDao.getUserAuthInfo                       0.2766781623810017     9.583490834787442    2.651542633364161
com.navixy.apiserver.storage.dao.MapLayerDao.listLayers                        0.2854368156103219     8.86626481591922     2.530758395413819
com.navixy.apiserver.storage.dao.TrackingDao.getTrackPoints                    0.23563514601968855    10.678626533699447   2.5162597225579897
com.navixy.apiserver.storage.dao.VehicleDao.getByTrackerId                     0.1843240114125069     13.457499785341643   2.4805403440171223
com.navixy.apiserver.storage.dao.ZoneDao.readZones                             0.2840852496688255     8.674119510785678    2.4641894068787797
com.navixy.apiserver.storage.dao.UserDao.updateLoginStats                      0.14582827443302473    13.818244408809061   2.0150907378304175
com.navixy.apiserver.storage.dao.UserDao.isDemoUser                            0.24960135393162838    8.01569507178086     2.000728342619584