SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 583806 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 583806 [ RunTime:0.001872s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (724422,949040,750514,874940,413027,803047,55985,131237,58733,1043892,146140,759854,1008285,668126,638980,348573,29614,1014552,702952,43400,386029,254166,163872,52139,377438,679469,250389,1000026,990735,73940,640725,387257,335258,203408,997863,849603,695437,32394,282523,210020,289700,864828,996987,42238,683394,130964,910070,33396,659477,589304,438625,805861,778227,955346,1019052,782124,35810,247389,981435,1028278) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 583806 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 583806 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000752s ]