SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512964 LIMIT 1 [ RunTime:0.001205s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512964 [ RunTime:0.002304s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (270400,667460,272295,32303,803741,306577,811554,13821,1041427,963136,283661,483302,239720,792272,605384,217659,851393,253857,604619,1015587,281961,485853,782176,938017,88996,453539,185969,940874,121193,982409,585221,29597,746491,54334,563356,384855,150492,377333,702757,45244,60621,220577,981171,1020453,478941,189199,172016,362517,138261,131509,532628,639679,592690,235458,252853,284186,449814,522001,760072,184291) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003297s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512964 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003931s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512964 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]