(1) the development environment to

SSM framework

2 (problem description)

Click after landing, jump to the home page (index. JSP) takes 9973 ms, traced back, found that the SQL statement select * XXXX is mybatis mapping file, it took 9000 ms time,
But, with Navicat test a single SQL, fast, to solve the doubts,,



3 (the code)


Select * from tb_user

Loginname=# # {loginname} and password={password}

CodePudding user response:

* to the field name

CodePudding user response:

Can analyze the execution plan, take a look at the specific slow