SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 361838 LIMIT 1 [ RunTime:0.000610s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 361838 [ RunTime:0.004612s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (862647,402825,407970,1011608,1007928,199052,335203,325154,223097,783744,215137,786114,781154,812939,828644,743802,544694,673707,931173,909755,651206,550527,817579,91177,81475,794050,398092,885922,977607,157593,478226,5550,72489,2446,222353,195237,289117,96763,462185,846135,552636,707357,166380,467660,404345,863489,1000564,1024339,994256,489874,720431,10249,1013367,325521,395585,559661,620195,619728,846019,267010) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003790s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 361838 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 361838 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]