SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402391 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402391 [ RunTime:0.001893s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (9751,393454,465562,1030262,754431,879707,216415,232642,875780,776866,381603,665789,325228,551001,252028,61389,959933,25165,216267,750138,264729,679627,548467,179215,907127,914855,258608,90221,287748,1036104,844565,914375,529994,667285,232885,321128,174662,619081,374592,344530,316797,152278,250175,79789,1023909,220310,380378,262960,559286,757233,703331,288229,871315,159787,181885,439601,457789,861517,406756,831466) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402391 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402391 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000401s ]