SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001450s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498697 LIMIT 1 [ RunTime:0.000750s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498697 [ RunTime:0.002385s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (801600,731144,426337,553561,862445,223613,53761,165051,424418,624597,650806,430142,622011,1032454,295691,526675,833078,579021,47003,755767,778650,127892,183792,897174,329796,654538,932379,174513,388584,813761,911464,997594,1039300,195903,891711,364504,257070,619413,18006,187871,1004575,658870,449259,39345,726272,338577,379070,184925,674497,1047522,177157,1005691,377701,445027,653606,645722,204036,651246,389302,179471) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004318s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498697 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498697 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]