SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 488687 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 488687 [ RunTime:0.001710s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (206150,505519,971878,213274,534586,330643,97834,571287,622800,312099,50659,622200,712551,100838,595357,262064,946200,227384,441957,931393,421245,1007751,617539,1015452,767959,82198,201472,148091,611075,469197,495172,206351,478350,190297,548775,103586,641386,22509,155040,778685,43237,412148,822423,699247,321502,801056,207390,884347,728801,893497,670233,689654,445012,554986,872918,127825,707288,560479,957656,653691) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001786s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 488687 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 488687 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]