SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 316101 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 316101 [ RunTime:0.001781s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1032230,225037,491538,933486,625695,918105,1009479,35818,439813,746676,790748,3640,562802,754339,912518,1032930,550573,420731,2543,637472,773030,748288,198288,940745,812902,843703,648226,723899,320567,297478,341628,380416,306658,643338,467281,768178,483050,545883,175075,435744,185008,503504,647621,474484,1009535,282900,541210,557123,1007119,512420,671854,200456,804549,994227,735585,667321,391015,283738,1014792,886217) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 316101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 316101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]