SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 150776 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 150776 [ RunTime:0.001723s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (618916,314891,840555,1016888,852108,708343,903832,49052,240688,805171,236369,1033600,1015057,268039,862530,63993,50531,629346,30757,99043,113599,717395,952593,245819,330628,415106,822453,572265,537718,806583,913165,620987,429684,864765,562380,424254,591273,136754,492813,810505,624102,171775,447665,97082,123206,469488,728171,159600,11122,717748,675657,577380,967186,676574,171307,297932,894905,502540,92426,551110) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002615s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 150776 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 150776 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004731s ]