SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001899s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 45808 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 45808 [ RunTime:0.001678s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (638387,889099,313031,526427,796240,48093,149433,1015931,521290,540052,943857,919485,740769,936062,668763,359131,489006,992480,396358,500738,120235,270299,1005954,768289,65921,658995,438153,15607,831950,274689,613937,760822,797188,451975,456285,90429,1004267,157818,469383,122149,545461,499337,99535,710510,825844,159115,171277,223265,726164,370845,883964,450821,518189,486205,419136,1006842,168050,790189,431207,704472) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 45808 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 45808 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000458s ]