SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001389s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 805904 LIMIT 1 [ RunTime:0.000714s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 805904 [ RunTime:0.002197s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (362811,771871,108091,161730,326182,678635,34445,445550,467134,212551,802514,611866,542658,989293,766095,368601,526239,186000,1009045,1028921,991503,579559,392218,419632,949831,1030192,446615,1038056,711523,771065,109819,438125,332277,774220,54189,230981,658787,689625,854800,282271,499672,170247,519082,701001,30290,548983,1002146,70325,375271,986414,504803,549748,992823,971986,687321,237623,1024864,760058,546422,102909) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 805904 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000504s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 805904 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]