SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001775s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438909 LIMIT 1 [ RunTime:0.000480s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438909 [ RunTime:0.001714s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (306849,586547,777188,263261,197022,792823,525398,542635,994504,884769,347114,711522,116038,224622,896642,865746,768565,931537,361699,894870,514325,929862,496641,401527,369574,933673,664557,946225,505301,736651,688196,246701,443328,153262,684211,594122,659039,81874,498295,726517,143933,428066,1036487,534013,973199,1020070,444499,389333,26419,76537,767610,330657,592785,155199,336826,689913,565679,379726,215893,782293) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001614s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438909 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438909 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]