SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 446021 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 446021 [ RunTime:0.001618s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (242656,276252,100014,724230,955287,218280,245022,799980,53541,702041,391457,876067,263591,734178,423704,786092,120842,970283,343064,462240,1005785,834901,400915,887766,879378,195657,429971,896501,472557,989891,327078,997843,387570,318935,133798,784627,745717,979522,1030756,445280,628228,349697,803128,781473,310458,740210,137415,806259,676637,530618,818308,1029424,606614,650520,586025,566439,136559,78242,528994,75951) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 446021 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 446021 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]