SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104371 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104371 [ RunTime:0.003078s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (426276,211084,963883,336941,958230,252437,915522,77926,793094,344282,821498,1046409,721966,661678,772581,566480,311883,647058,197925,873143,407401,213084,923073,1014427,856062,1012847,980364,290779,771953,788816,730018,224510,944981,842246,782932,725790,303117,177012,863065,97801,367444,762557,648649,818201,530488,709309,299476,507867,427694,728430,1035074,665739,874457,881456,581580,822258,468441,85466,221768,885209) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104371 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104371 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000440s ]