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` = 1035974 LIMIT 1 [ RunTime:0.001710s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1035974 [ RunTime:0.003530s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (270640,544276,178740,100728,202474,106560,917002,388735,165760,488550,474790,1005427,337244,552714,369063,432598,371237,48265,637841,1031711,758924,789373,525426,455285,1019136,60729,62956,920700,574752,931092,27945,146585,776296,305103,826858,477160,789127,489094,631911,963300,345441,511185,961297,432922,10510,290887,844028,377342,304080,246053,319420,857661,162897,929774,647586,240891,253787,72249,682313,624474) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001488s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1035974 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000736s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1035974 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]