SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5328 LIMIT 1 [ RunTime:0.001833s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5328 [ RunTime:0.004271s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (315784,515584,879063,277480,846445,85259,631686,102194,705964,149710,331091,549969,195631,914804,625530,832894,210259,274220,174950,428282,935614,899366,520096,69470,455803,671116,474573,832881,576291,398887,1037464,805013,89575,371386,882152,536378,1035560,499456,535160,204494,880696,298504,411906,470173,413568,543473,353583,154322,686526,469404,289016,463652,1018011,477954,845347,939580,243283,1043531,730198,28777) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001730s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5328 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000537s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5328 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000953s ]