SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002296s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 596654 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 596654 [ RunTime:0.003686s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (331591,585768,560609,32597,92384,857809,295065,906814,177544,707496,136793,537870,468918,817537,126375,592593,374603,938287,94130,27920,971362,514994,211848,593556,528634,1002626,24507,929496,1027586,780030,742737,521232,238346,727716,616848,198423,419418,527871,784912,936598,865659,908613,384070,692781,843473,339895,842647,940304,946400,27088,991395,177143,28325,798747,647381,292327,333145,777493,369745,749507) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 596654 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 596654 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000758s ]