SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001325s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419391 LIMIT 1 [ RunTime:0.000873s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419391 [ RunTime:0.001324s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (201120,796484,57855,288005,938058,28819,642658,559692,189091,892295,996151,935368,966573,578264,36622,599882,915592,100924,302623,87293,521404,888508,273976,483514,351519,970900,165100,261865,34120,575323,282583,968207,570328,299673,271115,310529,461632,57120,25779,646409,269241,530766,460336,633561,752241,703246,38893,152692,736944,356303,326721,679562,629831,383996,563236,976206,712243,5631,147086,799083) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419391 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001790s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419391 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]