SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1009864 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1009864 [ RunTime:0.002587s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (807548,960422,111462,345174,464314,956774,1045225,132796,211541,117171,192903,742726,424489,13779,469657,567809,576125,856533,719653,29677,1008800,704206,788946,102870,703986,550653,158357,744789,200909,102540,628320,465320,922388,351287,335617,722993,390687,335839,809747,928879,765424,903148,465779,204664,138334,308418,300969,564168,405242,520043,1019106,527005,985777,178411,776726,1020798,1048118,602688,826626,415533) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1009864 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1009864 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000444s ]