SHOW COLUMNS FROM `sp_route` [ RunTime:0.005001s ]

SELECT * FROM `sp_route` WHERE ( status=1 ) ORDER BY listorder asc [ RunTime:0.000000s ]

SELECT * FROM `sp_route` WHERE ( status=1 ) ORDER BY listorder asc [ RunTime:0.001000s ]

SELECT * FROM `sp_route` WHERE ( status=1 ) ORDER BY listorder asc [ RunTime:0.001000s ]

SELECT * FROM `sp_route` WHERE ( status=1 ) ORDER BY listorder asc [ RunTime:0.000000s ]

SELECT * FROM `sp_route` WHERE ( status=1 ) ORDER BY listorder asc [ RunTime:0.000000s ]

引起原因：

function sp_get_routes($refresh = false) {
 $routes = F ( "routes" );
 
 if (! empty ( $routes ) && ! $refresh) {
  
  return $routes;
 }
 $routes = M ( "Route" )->where ( "status=1" )->order ( "listorder asc" )->select (); 
 $module_routes = array ();
 $cache_routes = array ();

表空白导致一直查询

评论