SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 56100 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 56100 [ RunTime:0.001921s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (525329,819451,802605,1021910,732899,64198,464327,517331,971161,860765,668338,232576,841338,606117,504006,873921,981286,304458,87263,981040,709538,535144,268983,601289,647172,714212,392687,599463,636328,497243,922388,777407,137650,365360,830803,970849,1035859,188120,626839,798709,214849,35650,238231,575975,365915,417245,405951,1006196,518735,831721,834499,1030630,296124,617868,17653,208384,823798,981249,452754,91375) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003500s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 56100 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 56100 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]