SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 197714 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 197714 [ RunTime:0.004932s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (337940,562843,82685,408486,757060,908892,82214,823946,240031,154199,504198,418721,474076,290107,417923,831898,488450,179142,383743,123831,258977,99495,363406,709126,253288,528818,780275,148996,632833,874562,626457,645391,244278,1027991,503159,740372,522437,502246,752347,650166,469950,44110,268212,470812,502402,307838,972730,306474,809290,121913,522068,188207,1008826,131102,113707,198230,526034,652445,175513) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001797s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 197714 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000544s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 197714 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000690s ]