SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406758 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406758 [ RunTime:0.001963s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (816259,878845,758613,834421,777558,816691,104222,102191,677258,517913,841171,986101,544690,371553,783393,998449,348788,913674,146827,858623,845910,451562,162875,1012971,896166,977860,16467,50927,831481,949323,942553,707919,686735,961123,623569,804469,832693,788971,452485,686304,600185,770557,227454,871528,381167,611087,378714,275056,172448,700455,649570,52713,519554,736936,539429,855996,687335,758637,710689,648664) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001057s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406758 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406758 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000462s ]