SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 343210 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 343210 [ RunTime:0.001550s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (113216,923312,700273,951281,490624,282566,211722,731135,340373,751205,909311,122016,565370,812792,129049,555180,645308,61677,129929,1027119,600446,340870,421826,182072,357771,955302,609049,392813,820600,962955,791574,376508,408371,932530,662579,348948,575565,152577,571542,823959,160422,270443,471843,915040,792947,393294,100492,162396,136926,574049,937213,958362,222988,322561,939023,721873,393461,777651,759470,295205) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002519s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 343210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000649s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 343210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002816s ]