SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404958 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404958 [ RunTime:0.002672s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (279314,754815,282498,410990,809931,947116,710749,867016,474247,562498,640957,917521,204856,59589,995379,529264,536478,241499,576652,912534,395313,109388,518055,560085,998502,366645,127625,376533,532968,962470,462352,384889,195500,675352,380915,419344,70751,360074,790336,180262,385180,161508,229673,198522,35171,462971,174501,66777,512691,175529,743510,159525,154453,608874,765609,1026396,157588,205765,134412,306602) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404958 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404958 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]