SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 453142 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 453142 [ RunTime:0.002121s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (28160,128445,1029036,783172,922447,904961,257298,688552,486065,1012274,1782,496104,535779,815601,370489,686110,771392,335392,76874,200459,752223,609242,509230,687403,996832,198038,664813,772615,343924,477841,864082,610516,1038815,632742,782431,777826,50688,528252,161994,1042444,125546,109118,455497,402012,237344,138223,961874,657879,896866,975621,103158,916737,1028708,175391,441612,197174,242305,367493,350977,464369) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 453142 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 453142 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]