SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545976 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545976 [ RunTime:0.001588s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1001043,477135,250923,895525,507304,81254,81509,258800,849210,297203,901490,149250,1025893,765797,839486,987279,981850,983058,261793,4591,478657,573835,648157,448823,643202,758473,481974,1001855,19006,411892,594596,329846,880573,364822,723884,233510,953404,714157,324883,686889,603771,113243,44251,701378,690492,425945,1010526,862036,236048,791983,589862,794834,932023,270443,390362,254280,246557,954254,827935,694742) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545976 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545976 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]