SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003621s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505654 LIMIT 1 [ RunTime:0.001371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505654 [ RunTime:0.005856s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (746330,453584,6846,54549,508912,359285,766022,910307,135312,446302,124529,574542,701177,629060,540198,928632,853038,283207,937766,635082,261256,198450,924910,675016,24793,868200,359593,252335,565703,686838,912036,222977,372705,988509,113826,1032063,278534,388695,408018,397774,813906,239070,440718,889954,711139,581124,1004855,1013073,894717,641846,717280,905133,24130,684849,280730,4798,510983,840043,835985,326591) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003637s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505654 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505654 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002667s ]