SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003881s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 343983 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 343983 [ RunTime:0.002532s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (25454,984666,434924,251462,607512,400086,294969,143774,846107,681036,916992,633226,165608,54490,28787,511880,947967,263739,1029579,713106,419908,379623,176560,1040514,790383,434892,48679,327511,339500,692454,455731,562030,446587,32676,560850,776725,397174,687250,51361,734590,390412,975716,708410,974086,480006,53677,442381,157259,264546,345320,1025524,723280,593538,937158,516245,908728,626243,867835,31512,787230) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 343983 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002739s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 343983 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]