SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001388s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413848 LIMIT 1 [ RunTime:0.000423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413848 [ RunTime:0.001646s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (409133,215648,819716,64958,269074,412623,102375,179421,406676,393014,80218,381122,138309,878873,431365,560542,973367,138831,514270,969659,21523,350250,855315,220061,175798,366960,957724,251506,113018,607006,117726,540239,701403,625551,693127,537404,845460,396220,125555,418360,631496,749684,574823,903269,792169,1008275,789856,224277,507958,364497,16709,349624,396596,335519,58950,338356,420487,553310,172752,309432) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413848 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000517s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413848 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000456s ]