SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 245403 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 245403 [ RunTime:0.001896s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (810490,591899,975208,734343,647900,934579,413100,746829,811558,742729,807396,127219,633490,116756,586433,615636,1001880,339487,1040723,507676,769879,250907,744484,434858,394852,654495,27321,896627,206819,556429,624732,346482,1028154,158602,83595,754997,466235,383057,328200,413127,1038579,721172,626596,342787,128910,137595,67360,940427,920187,912421,410907,938258,108565,1022436,369695,270098,1048476,818037,608147,798734) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 245403 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001816s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 245403 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]