SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545431 LIMIT 1 [ RunTime:0.000435s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545431 [ RunTime:0.002362s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (418104,851827,858857,838109,53702,222411,600228,306425,143789,555341,486716,199163,27656,98778,565618,723089,488503,891002,205036,825143,157790,619463,987243,752597,524252,531598,582711,211188,215134,145469,957023,483138,1011081,78174,1025639,483937,40609,580836,672148,432373,427644,435384,950089,187988,164623,132986,163085,364338,247263,639336,767703,22514,302493,594085,115986,686314,641497,178970,260109,395179) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005185s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545431 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545431 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]