SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 446726 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 446726 [ RunTime:0.001532s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (304074,807029,759584,897261,439021,506327,712875,791128,627170,545212,934973,464925,314637,603988,247448,986662,680001,650640,593605,674249,648315,45763,1041325,648544,649899,409486,971331,197891,841543,163868,253369,370164,431863,861381,201081,875384,640950,711222,968310,461015,313556,957942,433345,165068,596777,1024326,329419,159100,953231,788159,930281,613171,127007,329417,29580,474036,881713,224998,715847,98720) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 446726 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 446726 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]