SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 348971 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 348971 [ RunTime:0.001778s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (165385,15167,112402,637339,684439,464501,646225,978656,966948,220003,222238,455071,434231,149505,79050,131534,794008,538314,574136,69140,122074,122090,798900,34382,197591,319157,66306,136088,249525,578863,792281,1034557,1004824,543667,577029,489823,387783,38331,784936,321723,973066,919375,682051,745306,409177,650011,271611,456503,827435,585518,504687,29204,924342,1036312,839955,699763,301982,618794,280605,1033471) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 348971 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 348971 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000662s ]