SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 336440 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 336440 [ RunTime:0.002287s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1028880,390091,441463,615090,878547,101678,994316,971848,210252,334468,1006202,160825,605195,667203,858463,796774,452239,74153,125639,514521,142187,268267,90640,216379,952065,157337,499057,599936,177847,400667,782666,471106,708549,227871,505755,655647,431239,992373,575981,519935,716600,902324,687587,75068,322459,932157,991347,814947,65430,437538,257852,904313,923220,519481,207884,620043,553608,716085,846622,995911) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 336440 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 336440 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002787s ]