1. DB::enableQueryLog(); // 开启查询日志
  2. **
  3. 这里放入查询的sql
  4. **
  5. $queriesConf = DB::getQueryLog();//获取查询日志
  6. if (!empty($queriesConf)) {
  7. foreach ($queriesConf as &$query) {
  8. foreach ($query['bindings'] as $i => $binding) {
  9. if ($binding instanceof \DateTime) {
  10. $query['bindings'][$i] = $binding->format('\'Y-m-d H:i:s\'');
  11. } else {
  12. if (is_string($binding)) {
  13. $query['bindings'][$i] = "'$binding'";
  14. }
  15. }
  16. }
  17. $query['full_query'] = vsprintf(str_replace('?', '%s', $query['query']), $query['bindings']);
  18. }
  19. }