SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 448346 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 448346 [ RunTime:0.001524s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (866092,535498,555955,1004596,448984,665660,562015,473035,17753,946575,440047,963952,269986,841921,213317,302375,450057,1043318,620200,1020905,536652,721049,200608,175239,1027938,330790,389725,657657,360642,803432,514159,169578,877970,112378,850247,49407,908648,791588,228129,315711,427014,888318,276508,609693,202197,481361,338794,157030,236487,238527,1004652,205963,881139,216907,658695,760636,238677,628771,804319,459027) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000973s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 448346 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000457s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 448346 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000497s ]