SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438616 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438616 [ RunTime:0.001526s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (452455,978141,591832,11764,52567,861301,474075,746742,41574,508696,93962,714946,846631,745032,344767,269744,130249,359617,150369,801240,277686,911844,253816,1028105,107003,251982,136795,728765,195764,240406,770262,605816,780633,975732,695874,155399,120190,955930,1005800,451088,256719,979798,880613,908321,136853,390536,505822,799714,543714,777923,183041,591294,547114,612474,997271,734785,419979,141750,70427,644813) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000944s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438616 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438616 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]