SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1035320 LIMIT 1 [ RunTime:0.001040s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1035320 [ RunTime:0.001599s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (246646,30734,854821,462495,793953,609863,906954,1018622,300273,599623,949661,530281,193856,870618,690314,404023,548956,915581,832084,310401,382249,910740,361467,916596,1020470,47031,1016175,466084,253046,98501,512300,953668,838892,1019688,442729,163235,249209,985998,353598,14618,607881,243972,354771,200933,103944,1037840,562327,41729,847959,360863,445274,740436,178899,512283,373345,892128,546509,853651,714018,700484) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1035320 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1035320 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003641s ]