SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438217 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438217 [ RunTime:0.001695s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (932511,739887,184721,174831,488175,807365,349414,1020492,518937,536246,304439,790202,327322,631599,163992,594946,10507,925834,200584,176342,677416,710823,405067,1018762,244614,985324,565913,622106,964587,310219,501007,180863,345020,580387,665214,593170,893008,63583,973191,708008,493768,833954,381015,122602,462520,1035732,878243,165404,816118,161369,26963,168765,201957,555556,987126,1045072,859562,720862,662795,27239) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438217 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438217 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000671s ]