SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539808 LIMIT 1 [ RunTime:0.000507s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539808 [ RunTime:0.002800s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (924275,245111,706610,987050,990270,275587,26694,58797,391632,277850,715833,446320,338184,686431,982062,38802,291749,1041718,574053,388535,278728,168007,463175,138562,689532,537501,501072,109274,629144,362312,770310,931629,135579,197679,153101,135680,1018842,182046,1004772,720046,466941,773283,198667,689188,568308,208182,329256,705367,1011705,1039589,58418,510598,620206,672698,134973,808308,984134,16417,358349,751050) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539808 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539808 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]