SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 449976 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 449976 [ RunTime:0.002434s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (406978,296999,306203,787326,918616,421533,790057,501281,578513,961282,260479,168171,452726,541801,146940,908966,689664,33246,273617,442606,718161,501192,152756,82598,429319,33884,972666,810683,523665,750324,1464,871782,851290,366649,442044,770184,1004412,1007565,883653,868779,601910,659803,275412,64910,145350,271798,297186,31021,183107,643569,660050,27281,401594,569410,851205,650612,501175,569781,984542,40488) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 449976 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 449976 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000638s ]