SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027913 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027913 [ RunTime:0.001445s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (22654,824788,879668,162330,243725,837402,438789,931808,619652,26944,783384,910253,849114,403984,790479,130192,703507,215749,7172,121411,720577,369489,230477,540828,989178,1035631,27473,86026,901041,136294,106321,547321,271153,866257,771794,281478,146388,230515,424525,659553,190724,455422,771591,397426,791238,392362,638527,833291,893910,702906,60796,537660,553211,260482,842950,342384,851195,708389,841872,777465) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001556s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027913 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027913 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]