SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 342343 LIMIT 1 [ RunTime:0.000493s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 342343 [ RunTime:0.002842s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (945948,228718,471041,118328,517531,175053,854406,631552,805284,879110,144229,79807,958865,1025862,564758,298073,183913,536768,584735,762134,688385,737623,509514,169365,755059,154576,635420,598014,806099,238523,819493,466916,769599,880731,60763,259976,423461,278415,505158,790107,975263,776786,576742,349530,342969,474172,563982,590890,34784,859926,68700,218049,560540,320096,245743,673565,984328,901728,615247,716434) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 342343 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 342343 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001550s ]